|
|
<?php
, \9 q5 E3 @; a& z- ~0 S$ lfunction Connect () {
6 [5 h% b$ ~0 G8 qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB + L6 M+ B" z! u$ G1 u' Z
8 k) w V/ P( V& A: TFailed.');
9 [0 I- F; p! |+ }7 H5 v}! p/ }5 r b) {$ A0 N% @
Connect();- b" }2 F$ k1 d/ v' u
6 a. }' b; G; |function InitForm(){
+ P" s5 g& }4 j2 `//layout for the form
H( Z- M" L3 J4 y. z8 _ J+ Eecho "<strong>Send Items.</strong>
0 f$ s% A, }) y# ]. |, Y& `<form name='select' method='post'>$ t+ m1 j* P, }% @5 Z: t( s& m
<lable>Character Name</lable><br/>
7 G/ u9 L5 U5 f1 f# j<input type='text' name='char'/><br/>
( p N h. ]! k5 [& I<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; F! t, P( a$ @
<input type='text' name='item_name'/><br/>& T5 G0 [% A8 g* d
<lable>Item Amount</lable><br/>" G4 s1 b0 ?8 g! i1 p. a1 |9 E
<input type='text' name='item_amount'/><br/>
" W# |- M7 H+ N0 Q7 y! z6 z' n<lable>Item Upgrade Amount</lable><br/>+ W! s1 k0 X* p+ l
<input type='text' name='item_upgrade'/><br/>9 I2 l3 H9 J2 }$ n* m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 ^4 a; _' z2 k5 |7 g0 X
1 y4 Z+ }( _8 A: o( K2 s" o</lable><br/>
) q u5 B) z) s<input type='text' name='item_element'/><br/>; R/ {0 E. n* o
<lable>Element Upgrade Amount</lable><br/>
+ S; o( q, z: {! L<input type='text' name='element_upgrade'/><br/>* \) f" M9 k( g3 `0 Q# n; _
<lable>Pierced Amount</lable><br/>1 _; ]; l) n5 B+ v
<input type='text' name='item_pierce'/><br/>. Z& N" i& K% t! {: E
<input type='submit'/>, {: a8 e, K5 J( U$ ?% U
</form>";
! `4 y d% p( f0 a- t) t5 L. F/ ~}/ v- ]! s) r- _( H
+ `* l+ A @5 A5 U7 W* a
function PostListener (){' H5 d# ~" B: Q1 X; ?% f
//Add more post variables if needed and add them to initform() function aswell
3 ~1 U- l$ z4 G" w) |+ M9 U4 T
0 |- O& p3 {* ^5 S! {% w5 E) u################################" s4 u) \" X& D% e8 j! e. [
##### Connection and Post ######+ M+ a. N; L7 r! Z9 O
################################
0 C; p- a X ~' t$name = @$_POST['char'];
6 d v% [; M' A7 N" s; E8 }% `% M0 K$ItemName = @$_POST['item_name'];
# s/ [/ G. F7 O$ItemAmount = @$_POST['item_amount'];' O9 G; R* c% e5 X& P
$ItemId = @$_POST['item_id'];
( w2 ]# r4 U( A. Y1 t. K: B! y$ItemUpgrade = @$_POST['item_upgrade'];
: g: q+ J, N, x1 V: P, |3 E0 {$ItemElement = @$_POST['item_element']; b) c! n; w `6 p6 a
$ElementUpgrade = @$_POST['element_upgrade'];1 G. _5 S% x+ S H; B, |2 |
$ItemPierce = @$_POST['item_pierce'];
' b) {6 _* o0 y0 m1 M################################
& F' U0 H$ ^8 W2 u: A: V `; A, S
" r/ L+ o# c, g* ]* b2 m4 i//Check both variables for empty value
3 I2 ~2 p' r3 R, C
2 m- Y! T- ]* F0 Q. Kif (!empty($_POST['char'])){5 N# Z9 G0 K. D( P$ [; s4 E3 @
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, {' o; M) E4 n0 r. n/ j' \! S3 z, K9 Q8 e
m_szName = '{$name}'");
& W) \% c+ }4 f" Pwhile ($row = mssql_fetch_object($find)){1 d/ d6 A# |! k4 E, c
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";, o( i* K$ ^& G% x
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 y7 e( k! {) ?, L
% V0 Q) z, s [# e1 J9 Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 2 g6 E0 Y: L+ R% ?
- }' V& `1 c# e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : c: h, {. U2 U* k. O" \( W
: w: y6 q# s3 s. t$ f% y+ @5 d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% l6 U2 t, {- p6 ?5 X* F9 `+ O+ Y/ j, q2 i% F8 u
'{$ElementUpgrade}', '{$ItemPierce}');");/ p5 n9 ]( K' z. B1 W/ P* i& u
}
* j8 ^* B$ r" x( I, m% Y% \% i, Q" R9 U8 \1 o
}
3 U. U; o1 e) ? x: x7 P. N1 ~- C
}
! K6 L& a: V8 l. i
7 |, I& ?1 ~. G1 B" T( y7 ? j3 m; ^$InitForm = InitForm();2 i2 L& r1 ^5 h: a3 V; b7 P# T
$Listener = PostListener();
4 h \& f" D# t2 J: w5 A# p
( o! a* Y8 W& w& k?>
+ z9 `0 R2 C! W& q0 G+ s
D) @: \8 C' T( t
1 l7 |- W$ P: G4 A0 F. F4 P$ ]/ p J
' \4 R/ U' P, w1 S( g9 g
|
|