|
|
<?php' _9 d! _* I" V" f
function Connect () {& f5 z( m6 T- S8 z0 {8 `0 \9 E9 R
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB , t2 x8 r9 Y7 ^( }5 ?" T; n
4 Y/ `5 f+ b6 _. K, f% o; lFailed.');- q1 k5 Q4 }, e; s s5 p' n ]5 L
}
! V4 N' Y6 N2 P/ A, w/ DConnect();
6 u# r- O/ J2 |& h; c) f! s) _, e. [3 l5 t! [
function InitForm(){* p7 _; g! T2 L) H8 J. d1 I
//layout for the form
; i& b. A% g; H! i/ |1 p7 Mecho "<strong>Send Items.</strong>- Y8 w; n6 l) I6 z$ T
<form name='select' method='post'>
$ U, F; \4 G1 k# X2 D<lable>Character Name</lable><br/>
M' T9 x& P* F, ?' {4 n; S, o u3 J<input type='text' name='char'/><br/>' z# q3 g$ D( [4 p& P
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>- Y1 m7 \! z5 Y- z, `4 X# T3 X' v
<input type='text' name='item_name'/><br/> h% Q/ N* Q$ {: q& n8 @: U" e
<lable>Item Amount</lable><br/>
# P, b8 W4 b) q3 d e" R<input type='text' name='item_amount'/><br/>, o; k! ]+ M! N6 R
<lable>Item Upgrade Amount</lable><br/>9 |4 `# p4 ?' d2 n1 A: E; a
<input type='text' name='item_upgrade'/><br/>
+ l/ n$ r4 X# z5 `3 n<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ f7 T2 r" v* o- T0 H- d9 Q/ ~
7 K9 d# X* o* Y" k$ g! B</lable><br/>: y) t2 |5 m, ]( d# D
<input type='text' name='item_element'/><br/>
( n3 o i% W9 s7 F& e7 \9 D& x<lable>Element Upgrade Amount</lable><br/>
" g: h6 m8 m* J3 u<input type='text' name='element_upgrade'/><br/>
u$ ?1 H2 L9 ^3 S& }! g<lable>Pierced Amount</lable><br/>$ ^8 _: Y5 h7 e7 a4 m( _2 I6 `
<input type='text' name='item_pierce'/><br/>
7 G* p" x5 h: i8 m2 r! ] c<input type='submit'/>+ V. o0 d% ?0 F
</form>";" {5 p8 t2 u3 p" r$ F$ e
}
$ O: w& I4 P/ a8 `1 {! z" j5 ?% }) v2 ] E& T# V1 H' I. b* M% Q
function PostListener (){4 I7 r% d$ G" j0 E' a
//Add more post variables if needed and add them to initform() function aswell7 r& }0 Q N2 F/ Z. ^
' ]. K: z- \; h4 I! z' z1 `( p################################# g. ^9 i+ o; l. f" _. c9 D
##### Connection and Post ######
4 S z+ }" E- @################################
; X; F0 \. ~3 q, }; F4 ]6 R* j0 a$name = @$_POST['char'];- t+ k" q+ ~, p9 s
$ItemName = @$_POST['item_name'];
' ~5 D5 D; R6 |0 {$ U% F$ItemAmount = @$_POST['item_amount'];5 `) n7 T0 s+ b& o9 `) X: K
$ItemId = @$_POST['item_id'];
5 l& s7 R+ x: m s x8 `$ItemUpgrade = @$_POST['item_upgrade'];" D7 E5 A+ V4 |7 b$ f
$ItemElement = @$_POST['item_element'];8 [+ B: g9 j9 K$ E: w! t( d* H
$ElementUpgrade = @$_POST['element_upgrade'];
2 N4 O0 x+ G! a4 z$ItemPierce = @$_POST['item_pierce'];. c/ U7 } c, O% }+ C5 w9 f
################################5 P( N+ V) p* i; U5 S' Y
, [# y% u6 e6 c$ S//Check both variables for empty value
$ a; S1 g6 |: K1 P# Y/ B. ?; g$ k/ w" c1 j! `1 r5 a0 G* _
if (!empty($_POST['char'])){) } ]) n+ l$ T N& i
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # c- R! S4 i7 e9 C( x
! F2 @6 i1 ?! g f5 h5 bm_szName = '{$name}'");
. Y/ o( e3 u2 q2 @* Y% a9 ~5 |) `while ($row = mssql_fetch_object($find)){
% K2 x" Y( q9 {& E- ~' Zecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- G9 o; e! D- V8 T$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ) @7 O, K- V8 u0 d3 i7 _
6 G c- {, [2 T% m$ W5 U' L" a* ^[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; K* J; t" u5 {. q& }: `
[& ~ W' r3 Y6 n& `" _[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', # A n0 F8 I7 p. F( L' G
]$ D: g* K5 T) \! dN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / P5 D4 Z$ i% ?6 e4 u7 W
: v1 T2 m# g" U, O0 [* K* R'{$ElementUpgrade}', '{$ItemPierce}');");
/ o0 I5 e, n. V# w+ U}. b" S0 Q' [; U: u9 e% s+ }
6 l$ F0 O$ {2 `4 X% J$ P) O
}
+ W3 a7 T# w( V: w' f% L- |# ^! S9 W" q- `( G
}
3 `9 O! ~' r0 V( i: Q. v5 l
* I* j# E/ d( {& h) g) |- R: E$InitForm = InitForm();: r! M; L/ U. h1 S
$Listener = PostListener();; S; t# m2 r% ^6 M2 A
. s- p7 d1 G9 n3 u3 l
?>1 m V: k( k+ q" r6 W
* }% Z0 \! y: X* L$ n4 o8 K% Z( G/ `; X. J& D1 w# Q6 n. E
' i" n5 k: Z- m: [! M- _. }
" i: O2 F( B K7 P
|
|