|
|
<?php+ S) J* s/ V; ?+ J( X
function Connect () {8 p, p7 o. Y# B8 I5 E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 p- n! n0 L3 i% ^* ]
: W3 a' U" Q3 \ K7 q. p7 x# f$ C
Failed.');
. X. b* R* i; r2 i}
/ b+ h( }3 |5 t! iConnect();& _4 L- P; k9 i/ f
* d' b( a! y5 n2 l% Xfunction InitForm(){
8 D% V1 b+ w& ^( r7 J//layout for the form+ |! h8 [- m7 t7 X" @5 U( g; [
echo "<strong>Send Items.</strong>% I9 x* k; C/ U, ^
<form name='select' method='post'>
2 [& l' u# s* z+ Y9 G6 |0 t) [<lable>Character Name</lable><br/>
- \8 J% M, h/ O- B! w<input type='text' name='char'/><br/>
/ H: Y# `; f: ?, J$ W% S) z- M% A<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) Y& x6 o' n# {3 r<input type='text' name='item_name'/><br/>
# K" Y+ {- s; P5 }( H" j$ j- }+ k<lable>Item Amount</lable><br/>( h' u% z) l* f* L; H
<input type='text' name='item_amount'/><br/>0 N6 @3 c8 Z S7 b _5 f3 y7 q, J+ }
<lable>Item Upgrade Amount</lable><br/>
: x4 I( K7 V2 l' I! V<input type='text' name='item_upgrade'/><br/>
1 e) B6 U6 [/ n# m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! U9 d) C; z; H9 \" r$ O; Y: K4 h' Y
</lable><br/>
+ `8 [+ P4 y: u5 X6 D& x* q3 w<input type='text' name='item_element'/><br/>
8 Q+ o! o( p3 m! b, m) N<lable>Element Upgrade Amount</lable><br/>! M6 o7 L |4 g, R1 B! |) A3 `' o8 O
<input type='text' name='element_upgrade'/><br/>
( F- Y/ s6 y A3 @3 n/ K0 d<lable>Pierced Amount</lable><br/>
9 ]* w4 g2 h: N/ j: H- I2 `<input type='text' name='item_pierce'/><br/>
5 e/ L6 v9 A8 P<input type='submit'/>
8 n+ E, d* z! ?8 z! L</form>";( \6 h- |+ x" x$ v6 c! j" Q- `
}
. u7 ^- N- a, u1 S8 K, B/ i! w% C! R ?" r/ H/ o: V" H
function PostListener (){
~9 T' g! X$ h6 @) k) F) }//Add more post variables if needed and add them to initform() function aswell
4 _" S% @! H' d* Y% s8 ~) s: Q9 D
v+ Q' g5 j7 J4 m################################
5 |: k$ o2 [. R6 e- W6 z8 X* {! n5 W##### Connection and Post ######
7 p6 j* y% {% N! r################################
9 r5 t, H8 x$ }. ]$name = @$_POST['char'];" q( L8 k ]' F5 U4 z/ m0 h; o
$ItemName = @$_POST['item_name'];
7 y! q: i& ]4 q; `+ C& i' o+ q- e+ {$ItemAmount = @$_POST['item_amount'];3 r* h6 h$ g; C5 j: }
$ItemId = @$_POST['item_id'];# p3 N- ~% _. g |- }
$ItemUpgrade = @$_POST['item_upgrade'];! u& j6 v; u9 b' v& H
$ItemElement = @$_POST['item_element'];: v( Z ~" Y( o+ Y: i. w4 u
$ElementUpgrade = @$_POST['element_upgrade'];, ` a5 }9 P$ f' L+ Q$ T4 k
$ItemPierce = @$_POST['item_pierce'];
8 _- l( s2 Y4 \% k################################: }8 U: u1 o8 [' m$ O. n3 H
6 g2 |: I6 C# l \; ~3 U' u
//Check both variables for empty value
8 V+ K) U8 s( D
G$ X. X7 J; V3 r! Bif (!empty($_POST['char'])){ m) j% t5 `$ D( A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 r* D0 P3 r0 G. H9 ` Z+ W
0 h; K) \: k; C- H: k9 U6 jm_szName = '{$name}'");
' I4 c1 V- q! {3 P; twhile ($row = mssql_fetch_object($find)){
2 B9 Q c# K( `- ?, a& becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" f* e* c8 N+ Y' b$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , ^* C0 W) N/ H' P6 p6 A
, n+ d9 q, w/ r1 I3 w
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
4 }, W, [0 E0 J' ?4 Z2 K
; a7 P, B! D8 V& b C/ e% F% J/ l[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ r' E& p C5 e& [0 |3 P2 j6 b1 p" t% v' p3 y9 w( c: R
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& E' o0 _% C4 h, ~
; T7 s# {2 J, V3 ]# ['{$ElementUpgrade}', '{$ItemPierce}');");2 ?( N, f0 _, x3 ?1 O- ^9 m
}& R$ H6 u1 s R3 z3 \& h
; n+ A a) [" U- {9 x O& W}
0 S" o1 `0 \+ O; ~- o4 @+ Q9 {6 L7 d* G; D; o9 N2 {
}- m" ?$ n, \4 t, o6 s8 T S5 U
3 p {6 F: j+ x g) J2 ~$InitForm = InitForm();% [' g( ?& B4 W. Z* G7 D/ M
$Listener = PostListener();
4 ]: Z0 N2 k) R- }4 c5 n+ _: ^" t( Q" [' ~( V/ S4 R* p3 } F
?>/ Z6 n' O7 W, t! G) \; C
+ p" P9 |) q2 C; ]% \; i
- z& N8 z% ^! |# _
1 c$ v% S0 l* ]( f' L' t2 W; J# @" J' }. o
|
|