|
|
<?php
) j3 Q, {1 ~* A: cfunction Connect () {
. D# `: }9 r8 y m1 qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 A+ @8 ~3 Z" j; i2 }
o5 i4 L# N6 rFailed.');
9 V' b$ P- ^( q/ s1 I- x! t$ X}& e0 A C( a( @- K$ Z; q+ c
Connect();+ P3 d* [- d6 ^% }* h v! u8 ^
" K. p, R1 M! W3 g( Zfunction InitForm(){
e$ y& |" K2 Z4 e4 m1 P2 w//layout for the form% i2 j" b# Q' l8 V* H
echo "<strong>Send Items.</strong>
" e0 @0 T, z5 |; i% w. l& k<form name='select' method='post'>9 Y3 `* \6 Z! W, N5 F7 N" v
<lable>Character Name</lable><br/>" ~7 s% L, `- _+ t6 Z4 Z
<input type='text' name='char'/><br/>& q# d4 c7 n G' C
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>7 [7 g6 q1 \, N0 N' f3 U) l
<input type='text' name='item_name'/><br/>3 @8 a& ^. v, C1 G# a: l. I4 T, T
<lable>Item Amount</lable><br/>
+ g* O5 K2 x, b+ M6 H<input type='text' name='item_amount'/><br/>
! y) P) X1 m. }<lable>Item Upgrade Amount</lable><br/>
+ S" D8 v% H: \4 C7 C5 U& p. S<input type='text' name='item_upgrade'/><br/>
" D e; f/ _) O1 v, r$ v9 d2 b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& d2 S9 ], R8 M" B4 |7 C6 s. S% n
0 u1 T! o2 U7 C; @% F# G</lable><br/>7 E- G* ]& v5 G9 m0 K; ^. F. V9 f! `
<input type='text' name='item_element'/><br/>
7 l' [: h: F9 v" b' F<lable>Element Upgrade Amount</lable><br/>
: d7 b0 e' h. \: J7 Z; t<input type='text' name='element_upgrade'/><br/> x% N$ L) W. ]2 Q; Y* J; a
<lable>Pierced Amount</lable><br/>" i! j e) U" B
<input type='text' name='item_pierce'/><br/>3 F+ A( b) S! Z0 J7 R" W0 g
<input type='submit'/>. M4 Y# J4 ~' x, X' H
</form>";( X( z( p' v& P0 s: n, X% ?0 B( ~
}, l, @9 f6 G' F/ B. E
/ M* ~9 v- f& f ]3 a0 p, K' S0 cfunction PostListener (){' d' g' a2 t, `3 B* b2 S. Y
//Add more post variables if needed and add them to initform() function aswell% S. A' h6 _- h& t
* S% E. n$ \" B H
################################5 A; s E- n7 m& O$ z4 `6 O
##### Connection and Post ######! W' ?+ C4 t5 ~
################################$ j2 [% O9 t: T
$name = @$_POST['char'];9 o- K6 F" I& W4 S
$ItemName = @$_POST['item_name'];
$ D( f' D7 i9 l4 g' S* c6 U$ItemAmount = @$_POST['item_amount'];- A' @. d; R5 L$ C% s0 L; T$ M
$ItemId = @$_POST['item_id'];
9 k! p% Z" m! l% t) i$ItemUpgrade = @$_POST['item_upgrade'];9 E8 R. w# o3 G$ s; O; Y$ r! Y
$ItemElement = @$_POST['item_element'];5 K# d) q( b( u" C5 C q- N
$ElementUpgrade = @$_POST['element_upgrade'];
; C8 x, [- F' k8 W* o9 P2 o$ItemPierce = @$_POST['item_pierce'];2 i7 h) Y; ?7 F* o
################################6 t4 T4 X* n F' q8 |
2 g. m2 @$ [6 H1 R' `5 n
//Check both variables for empty value7 N- K6 Q6 X3 _" Y
0 u6 X* e& @' ~6 m7 f9 Kif (!empty($_POST['char'])){6 N4 c' w: j2 a, a! y9 }1 a
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' ?; F( n+ c" S4 ~! `$ r* s# O6 e6 V( |1 b; z
m_szName = '{$name}'");
/ q( R9 N- P! I; W! E& q/ G1 Pwhile ($row = mssql_fetch_object($find)){
5 ` B7 e1 w1 Gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 j2 ~! _0 S$ G* a% G( ^
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # K* `6 S7 K% w
" V( v9 s' r% l; ~
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. R& ^3 C( A/ `6 g2 m; T6 A5 q' J: ^, d
% q( w; p# ?7 L; ]$ s: \" w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', * z0 ?9 ^& L T9 R6 X) T. z
" i$ o+ u' z6 r. H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ {) \ H+ Q( \6 D9 q/ i/ g9 ]8 K0 ^1 h+ a% [6 G' ~
'{$ElementUpgrade}', '{$ItemPierce}');");, ^! y6 f1 @; F4 c2 s5 |
}# b' W9 A, [: N( x: y8 A
# P+ {7 q* A6 |3 G* }" @}. k2 H7 I4 _# q9 [: {
( H( d5 S6 S0 o' g! ~. Q
}. ^0 U4 ]3 _0 T9 E/ ^% e+ g
0 M) x- j. E% S& R0 d; {# f$InitForm = InitForm(); W9 [# A6 F! }; d; c3 ~2 [. s
$Listener = PostListener();' T2 k, w! a2 Y t6 T
; n8 r9 h, T$ o# Y2 A?>, Z0 O8 o+ q6 ~, A9 B5 a) w
* B7 Y9 _1 @; y5 \. c* p% i+ a8 I8 v
9 R" i, j: u3 |: z+ v5 s& H, f' {# e/ V. C. W; t% H- t% ]
h0 i8 Y+ j. }# P* [9 O" C |
|