|
|
<?php' {/ R/ ^' N' I. w# |
function Connect () {9 i0 R# u3 v7 g3 |% g$ @3 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; g& v3 D% A1 ]" A
: |" ?' l6 p. q5 f8 o0 _Failed.');5 q% G) I7 u% z: ]
}
& u* K" s4 f0 E- w+ e5 H) QConnect();
, h8 l4 ^) y% K `3 Y: z! Z, S- B4 L3 Q( a; \1 u# \
function InitForm(){
+ g' o7 n: a# _4 \0 }/ B. J//layout for the form
% H. C+ Z+ q# l7 @5 b. U' ]7 j% Kecho "<strong>Send Items.</strong>; _, T: h5 F5 G& R) L
<form name='select' method='post'>
+ S6 ~. y( W; m2 m2 e/ ]' n$ p; I<lable>Character Name</lable><br/>1 u L- n1 x- e, b
<input type='text' name='char'/><br/>
, f+ a1 j8 a# I) k+ C! L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
6 o1 P- ~. O4 ]* P* }<input type='text' name='item_name'/><br/>
) L' k& f( t2 ^' O<lable>Item Amount</lable><br/>
' {1 k4 N2 X" [$ e# {; z<input type='text' name='item_amount'/><br/>3 n& z4 B$ l# p
<lable>Item Upgrade Amount</lable><br/>6 d! {. \9 W3 {; t; O, @1 p( }/ P
<input type='text' name='item_upgrade'/><br/>
, n. D! W4 j* o<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& Y3 B2 y+ ]! |# g( j9 s2 p/ r( f" r
( {& S9 R F' {3 N5 ^9 p# t
</lable><br/>- l9 d0 H" t8 X7 b8 F
<input type='text' name='item_element'/><br/>/ G+ m) U* ]0 H
<lable>Element Upgrade Amount</lable><br/>5 U& `! Z2 r ]+ m
<input type='text' name='element_upgrade'/><br/>
3 Z* f8 s3 @! o' D- L<lable>Pierced Amount</lable><br/>9 p& `0 v% V" c0 R4 Y
<input type='text' name='item_pierce'/><br/>
+ E1 B8 D3 @- Q/ y- u<input type='submit'/>
! E1 R- T) n: Y6 b& g! b& `2 B: h</form>";, B% `% { b; \
}
7 \; c+ G. a+ V* @( j; j6 p: A. I* a$ K4 k/ B- ~+ f7 L" W
function PostListener (){ W. X4 G* Y0 Q
//Add more post variables if needed and add them to initform() function aswell+ b: P! d" Y7 ~* E5 K3 o4 k1 G7 W2 P
) ~4 q }0 G6 }3 M- y6 G
################################/ J" P2 c3 \5 c+ `! O
##### Connection and Post ######
3 Q" D& f. R5 }* E) K7 u* i################################$ J% I0 S9 B) Z4 \$ V! Q' b/ h
$name = @$_POST['char'];
2 \5 R4 ]1 w3 H$ItemName = @$_POST['item_name'];7 E' ^5 a$ B. I+ l& S
$ItemAmount = @$_POST['item_amount'];' c: L& B" j/ {4 e) A
$ItemId = @$_POST['item_id'];1 W, z5 ^: f+ m+ `
$ItemUpgrade = @$_POST['item_upgrade'];5 M* K: b9 @ S# k. |" P
$ItemElement = @$_POST['item_element'];
0 }' v. n9 t7 |% P5 l$ElementUpgrade = @$_POST['element_upgrade'];! |" R7 a, R9 X, j
$ItemPierce = @$_POST['item_pierce'];
$ N" u7 G( b' ]7 |################################, N i" F' l4 h1 K! I" G
% P; p! u" i: J+ e+ Q9 F% F
//Check both variables for empty value- o- Z7 G* `0 \+ ]1 G/ u7 f, u1 K @
$ H- }% \: Y" J3 I9 r% Fif (!empty($_POST['char'])){# A3 i4 ^. o) V2 i" f n \: l/ Q3 W
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % b) U: p" a s% f b
; q2 ?( t# Q2 V7 o. f, V0 R: Q( E+ Em_szName = '{$name}'");9 J; D' z, T! f# }! K3 R. c
while ($row = mssql_fetch_object($find)){* q, t5 s) y+ p$ p- u/ A
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 r% ~2 k1 v6 |- y9 D3 c. d$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ! f b6 A/ _0 i
2 V, `" O) Z* Y4 n4 \$ K: j
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, F. ^$ e) o/ E4 g' w- e! c
5 @3 l( e! P! ^6 ?' Q' F[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ n5 r4 l' w6 F# _8 K
+ \2 n+ \! k- a- X; W e7 U/ S" kN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 3 Z, }4 O, n1 e. `
5 e* d+ d' W4 ~( B'{$ElementUpgrade}', '{$ItemPierce}');");3 [ T! i) r6 R# I
}" N% f8 f ~9 {4 \4 q+ j3 U% D
% G# t$ h# l2 H ]1 e A8 r
}
: V$ W8 q8 ?1 [1 j7 q# U- p6 B. ]7 ~5 O) `9 q
}
" W6 M+ m0 S# s$ i, d6 I% g$ X- z- y, d v. v
$InitForm = InitForm();! a, u2 Z4 ]- \) o- U
$Listener = PostListener();' [4 v/ T; n5 n- L! _
1 O% r) P! F y5 C9 l9 O) x?>& y) ^7 @0 A9 B( C0 }$ V: y
' n3 R' ^- e) j5 {; ^* o3 T
7 Z v3 R# |: c+ ?3 H) c. u4 j2 y# c! Q* M; S
& K1 E& s$ l' p% b# i$ ?( K
|
|