|
|
<?php" S2 O0 o6 e" Y+ }
function Connect () {
2 R% A/ }' b [0 D) w9 @mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) x1 O5 k( j' u; E% _7 X9 T/ A R/ l. A9 T# z
Failed.');, h, @4 c# k" s# W$ I
}6 F/ q" O, V' ] e; k; d7 s
Connect();; @- v* B; U7 H- p* y7 Y
& f4 R4 M4 u, Z/ a$ L" H
function InitForm(){
# |; Z5 U2 E B) ]! u//layout for the form* P7 X. m6 ]) Z7 ^
echo "<strong>Send Items.</strong>* p: s4 Y8 h/ d% ]4 U' z3 L
<form name='select' method='post'>
6 y |/ ?) ?) W% B! {+ x<lable>Character Name</lable><br/>
& D( A. c `7 i3 F, _ s<input type='text' name='char'/><br/>, I: ^* J, A0 h6 H" _+ [ Y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>7 C/ j# v; Y* C; K, @) T5 m0 k
<input type='text' name='item_name'/><br/>! [% s5 m1 ?1 Z
<lable>Item Amount</lable><br/>
/ @5 B3 M' ^" v0 _<input type='text' name='item_amount'/><br/>) p' W4 S/ _/ c( j8 w1 j
<lable>Item Upgrade Amount</lable><br/>
5 L. Y" g) a* ~7 a% A% `<input type='text' name='item_upgrade'/><br/>
+ G1 S8 I( [$ U* d( B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), z2 p4 X5 Z- u7 `9 ~
/ j9 F( k! j0 g8 t& K+ a+ e: O& R</lable><br/>
( z* y9 l; w2 J1 n2 {<input type='text' name='item_element'/><br/>
+ F3 s, f* I' T, b$ ~% V d, \ v9 [7 x& ?<lable>Element Upgrade Amount</lable><br/>
8 P9 m9 y1 r* \8 c3 m8 u' M<input type='text' name='element_upgrade'/><br/>
! X7 \8 `! b/ | j# s0 N<lable>Pierced Amount</lable><br/>& G8 S4 E5 f- h
<input type='text' name='item_pierce'/><br/>
) k* G2 Z, L) T1 W/ F<input type='submit'/>
* a' Y9 |! {1 u6 e* i3 L9 ^</form>";$ L$ E% q' l1 Y2 f! o1 D
}
_$ `: b( z. o
* U$ n, V0 F$ Lfunction PostListener (){7 |# W8 g9 c1 D2 Q6 L% @$ b' t
//Add more post variables if needed and add them to initform() function aswell
% }/ _. q: D3 e+ J7 ^7 v! r* j% f: p6 U7 t+ a8 V3 T
################################: h R7 S9 ?% a! H6 k- B( Z
##### Connection and Post ######
* a0 v, I+ j6 y( T################################
: e7 `, k/ v& f! N- X* W6 _; v$name = @$_POST['char'];
+ W9 S4 L6 Q9 e& T9 |( M: ^. x$ItemName = @$_POST['item_name'];
8 n. z7 e9 A; C K. b9 k2 m$ItemAmount = @$_POST['item_amount'];
0 r% L: f: p( _/ ~2 `" D$ItemId = @$_POST['item_id'];- V% N+ k% Z+ O
$ItemUpgrade = @$_POST['item_upgrade'];
3 A4 {9 ?/ a$ S$ _1 s" i! g6 z& {' w$ItemElement = @$_POST['item_element'];
& F9 }: [7 W7 W$ElementUpgrade = @$_POST['element_upgrade'];5 I& L( @6 [! z! Q
$ItemPierce = @$_POST['item_pierce'];
; Q+ @& i, m7 l) J' Q################################
: a' M0 h1 A) k/ y) Y' r) [/ \: T) L7 J9 z
//Check both variables for empty value' ^0 e% S; ~: }# ?# j2 A& R5 C
1 p: t6 n& H- o- p. [
if (!empty($_POST['char'])){- e( O& R4 x5 N% w
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 n" u$ O$ a6 @ h$ z
' F) X4 @! K G& P8 H3 ]' ?m_szName = '{$name}'");/ V; J2 }6 o7 B/ R8 D
while ($row = mssql_fetch_object($find)){0 F1 M" f2 R% h% B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";) L* E3 h5 b9 Y- A
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 D' r; H+ |) d5 F0 a2 @5 I
. Y+ p; g, `. n" B7 r/ Q+ X+ I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 3 y; J9 h3 C( o/ G& T F( }( z
5 H" @' u8 [& m( g, D: x) e% ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : e; ` ~# n& V/ P: a5 q, D. U+ E" U
k# W% N. y6 r5 W$ _N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ |3 O( R Y! p( x0 j$ i4 Q& b, d
3 O7 T3 e4 Q( [& E'{$ElementUpgrade}', '{$ItemPierce}');");
+ r' C# v5 G( t$ {' v9 v9 S1 I0 h( Z}
. z- ^! Q: k: I: ]' l
/ K) v' Q8 l7 @+ E# _& r2 r ]1 t}+ {2 H8 M: e% E% a9 V( Y& u2 d# F
/ b+ N: p9 X3 a( e' r$ h" ~} v0 C& c& Y6 Q' Z* Z- G3 t
2 T. q2 C' X8 ]) F; }$InitForm = InitForm();3 |# J& } z8 Z$ F, o5 C
$Listener = PostListener();1 K' k+ c1 I0 I1 T ], l
2 J/ W5 F8 L' }?>
2 Y2 [3 y8 @# g2 B% ]- k" Q: U3 _; I1 F8 D* c9 `# l
; k* V" L6 N2 ~
5 M) _3 {2 ~! Y5 N# e4 L8 _& ]
& z( j( b3 h/ i |
|