|
|
<?php+ k9 ]# E) p: N8 u5 Z& s1 ?
function Connect () {
# F( Z" n6 c/ b5 j( e6 Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" j( D2 r" {4 `& Z0 U+ D& \0 n' Q/ g' n' {( v
Failed.');5 n6 o: b2 e4 H5 R. s# j
}7 m ~; a7 a; [* }9 r
Connect();
) r4 v$ D+ c0 {) J- E8 P* K; `0 C( f: W( P- t% _0 P9 K/ T3 a) s
function InitForm(){0 t* J/ |4 X( u0 x' P) g
//layout for the form" ?; E! J8 U4 w/ J
echo "<strong>Send Items.</strong>
$ V! x) ^" t! {<form name='select' method='post'>3 K5 \5 C+ P) N5 s. }
<lable>Character Name</lable><br/>9 u" l) N4 U4 \; T2 W8 p
<input type='text' name='char'/><br/>
; ~6 |8 v1 n: B5 c<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 o0 d7 v1 i2 i3 C8 W8 _( ~
<input type='text' name='item_name'/><br/>$ I* R3 M4 d) F# ]( a, H7 P
<lable>Item Amount</lable><br/>* S; l$ l9 T* e5 t) M T) g1 `
<input type='text' name='item_amount'/><br/>
& [7 H; x0 T* b* Q: w<lable>Item Upgrade Amount</lable><br/>
% J& C- y3 m: w) F# }- k, {' U<input type='text' name='item_upgrade'/><br/>
* ^. x& B8 L) s$ Q( h5 y* N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 e2 n5 R6 [: _9 X4 Z3 a
M3 J& Q9 M0 Z2 c1 ?0 h</lable><br/> G: [7 Y# X: |: u* Y8 |, Y
<input type='text' name='item_element'/><br/># O" E7 O$ p4 x! ?. \0 ]% E
<lable>Element Upgrade Amount</lable><br/> x( p m1 `+ J2 _8 v& W, Z
<input type='text' name='element_upgrade'/><br/>
r, q$ U j/ s<lable>Pierced Amount</lable><br/>
/ Y( M( ]/ \0 q5 t2 ~. b p$ Z7 v<input type='text' name='item_pierce'/><br/>
" ~( E, h2 s5 b. j; w' B<input type='submit'/>% M; C! D% D: g! X
</form>";3 N3 u; r: j( V, k+ q" B
}
6 z; q$ r% r' P/ a) |* J9 Y8 k( B& ]
function PostListener (){, r( ^4 x( b: l8 i7 [
//Add more post variables if needed and add them to initform() function aswell. y1 y: g: U. e5 C; |1 B9 [) A- e
1 \ t6 R' W. X3 M################################
7 d& l1 r# o1 X: F1 @- r##### Connection and Post ######
& n+ {, [7 F8 J9 n5 z################################
6 M2 r; J0 \$ x/ j _2 u. v$name = @$_POST['char'];
! I; N5 T' Q9 l/ g1 Z" z1 k( z, e$ItemName = @$_POST['item_name'];
8 g- {6 N/ e8 P6 r$ItemAmount = @$_POST['item_amount'];
" k! w$ A. u/ I# \: t$ H" A" D8 N$ItemId = @$_POST['item_id'];% L' ^4 i1 [ r9 T2 Z9 g) k; R
$ItemUpgrade = @$_POST['item_upgrade'];/ C: N8 G/ R. F1 Q+ ]) T8 x1 E% `
$ItemElement = @$_POST['item_element'];* G: O6 B& n* \2 r
$ElementUpgrade = @$_POST['element_upgrade'];
, Y1 s6 G l0 `: W& h5 D$ J$ItemPierce = @$_POST['item_pierce'];, |: j Z6 x! l% C3 G/ @; D9 y- X
################################
. P- L- U- y! j6 o y% H. F$ V% a6 c3 S$ D( d5 `* d
//Check both variables for empty value
( A5 u# S9 B6 v# A7 Q
3 J! ]$ V1 \2 Hif (!empty($_POST['char'])){4 A. r: O" H; D4 B# E) d
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ q$ _7 G" P Z }/ I0 O" W% R& L: k* C- T5 [6 k6 B9 J( w4 s
m_szName = '{$name}'");8 c4 `; a4 L2 G# Y$ X! S; J
while ($row = mssql_fetch_object($find)){5 d3 y2 B( S; K5 A9 Y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. n. ]# x. S9 z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 h- C* _# H3 E, A: h2 I+ o& z, a
, i' t! Z- y3 e/ B& i7 L( g7 c
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : q3 o0 b- l- f' [
: l: e6 P6 G/ d: K4 G; o& J t" `[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', * q+ x- m. |" |1 ^' U! f
7 R; ]; x* M3 ^5 t0 s) q9 jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 H U" E( G, R
j8 i+ q4 {3 ^: ^" F- M
'{$ElementUpgrade}', '{$ItemPierce}');");
" p+ k, Z% r, c1 P! n! N* l# M}
9 \0 U: K- ~( I( o" P7 c8 V8 J- h( r' l
}
/ X8 Z4 u9 z/ P( G0 C* F
1 W; s5 |/ v9 m$ `; E+ E6 V}
' [" X+ K( W x5 r J- \- R4 @1 P s: K! W
$InitForm = InitForm();
6 b8 ^9 f8 q% n/ A* i. G$Listener = PostListener();
( r: P' [1 T' n5 y d' ]. K
3 p: ~. q" r1 R, N3 |! \% }?>
) @7 i/ X. A; H3 t/ c8 [) q8 T5 S
% w+ ]) @, V" n+ k! w( e' `
0 {! D- r3 ~" H, f4 V* W+ O- Y9 z4 {" H8 c4 d
|
|