|
|
<?php3 ?9 ~8 D5 b( Q- Q+ I+ P
function Connect () {
; U7 d* z" Q; t) M: Xmssql_connect('Server','UserName','Password') or die('Error: Connection to DB , e: _1 V! I8 e
+ B3 T9 d$ D% ?; ~' k' }8 D
Failed.');
" J4 `2 Z6 C/ U+ [}
, [. U1 U( q/ y+ yConnect();2 }, y& O+ G- |9 g# J# R
' M4 }# f" q3 d1 ]$ b# U& wfunction InitForm(){, Z& n- `8 B9 d
//layout for the form
, Q6 O8 _& W1 V( n: B# M8 `1 Yecho "<strong>Send Items.</strong>
* x, n; p# X5 G( F$ L: X5 X2 }<form name='select' method='post'>
# L. ^% O) u0 o<lable>Character Name</lable><br/>4 {0 p% |2 V8 S3 U/ j( E" w- k
<input type='text' name='char'/><br/>
+ } ^, f" z! o3 v ]. f<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" a( \2 }2 P- D/ O+ y- A<input type='text' name='item_name'/><br/>
3 t- W9 p b8 i( \1 S' V2 r( z<lable>Item Amount</lable><br/>
3 K5 e/ n) x' ]<input type='text' name='item_amount'/><br/>
& C( C' r' M" h<lable>Item Upgrade Amount</lable><br/>
" r7 C; v2 |9 I' ]9 K" A<input type='text' name='item_upgrade'/><br/>$ Q/ C; O0 m K, [3 ?( g
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 W5 b) D0 I# T! d% b7 |7 A( g A" r; S9 M! }2 E
</lable><br/>9 ?" y9 I9 }, K1 s2 S5 r
<input type='text' name='item_element'/><br/>
/ }2 b9 b4 ]+ c# d( |: `( h1 b<lable>Element Upgrade Amount</lable><br/>
' D5 v# l% J5 \4 S<input type='text' name='element_upgrade'/><br/>& a% L' g' @% b2 S
<lable>Pierced Amount</lable><br/>
0 f( {! x& X3 _/ I<input type='text' name='item_pierce'/><br/>
1 L, v/ `! ^5 r: P0 C U, @$ ^<input type='submit'/>/ W9 g4 Y$ `& ^: O' G8 t
</form>";2 Z, B5 k1 I1 E, L) D- I3 X
}3 g |# c# j+ o) ~" ^+ f6 h, [" z% f
4 G9 M% u% t9 X* S3 v% Y8 b! M
function PostListener (){ E7 x# w1 p% \4 q1 g- G: z- C
//Add more post variables if needed and add them to initform() function aswell
* m0 d7 }8 \2 D4 w) i# u
3 s2 ]( y3 r# Z3 i+ i6 K" G+ c+ g. f################################& |& a: V$ y1 e0 c6 \" E
##### Connection and Post ######- G' P5 f9 L' G) Q. S8 i
################################
. D3 Z$ g) m( o" w& E b1 o$name = @$_POST['char'];- D* k/ z0 c1 q4 }& g( i( _- t
$ItemName = @$_POST['item_name'];. K: _+ ?$ V- V0 T* d4 A4 X7 f
$ItemAmount = @$_POST['item_amount'];5 w' s+ [( D! s$ s7 T
$ItemId = @$_POST['item_id'];+ m! c1 l' L4 W* z9 I$ _7 z( B
$ItemUpgrade = @$_POST['item_upgrade'];
' b# {; e: t& b8 v" f$ItemElement = @$_POST['item_element'];
9 N- h9 W+ y/ v$ElementUpgrade = @$_POST['element_upgrade'];
; j7 M. `- _. L$ItemPierce = @$_POST['item_pierce'];, Z: G& ?9 @- D: k3 a
################################
; J9 p F2 T6 i- E6 B5 f5 c& q3 Y' l
//Check both variables for empty value
0 ^2 d) {6 a; S3 b8 I2 D; O {0 p$ g+ E5 A4 l P
if (!empty($_POST['char'])){2 E0 `. \! g- O5 {% J9 f
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- G, d" X+ e, A2 w- e) ?2 F( T4 @
m_szName = '{$name}'");
* V0 e5 Y m* z7 F9 A# K/ j! kwhile ($row = mssql_fetch_object($find)){2 M) Z4 N; V6 P& P# w7 C
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
r8 b# s3 H. Q, r/ Q6 A8 D& J4 F$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' l+ w" I( `1 @2 Y
7 L8 s* ^. [6 o8 Q1 G% h7 O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 i; Q$ Z0 T5 r' T6 x9 Z
0 i- \9 ~7 @1 E: x; X) V. ]1 t9 i[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 @" R# Y4 t: K" p# k+ b, k2 n6 [9 v G8 _
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. M: I, K' L$ m+ Q2 u& R" k y: s+ M+ p
'{$ElementUpgrade}', '{$ItemPierce}');");
& z, S' H' r( L! D}
a+ r/ i- C2 f0 V4 T3 D2 S* i$ e9 b3 ^5 ]% u
}7 ?# u7 ~2 e* O% j/ X
" @7 z4 k2 [6 l/ G: L2 v
}
/ {5 o2 m3 O4 S. n' w* k8 K! W2 e" O7 a7 h6 a
$InitForm = InitForm();& \9 c( O! H" A4 n: S
$Listener = PostListener();
- b# L/ f' K" U. [( @# D0 i1 E1 s* s4 B9 m8 ?0 W6 L6 r
?>. ?( I: W4 d5 k( S
2 N! U$ ]* l4 _& t2 m- j3 \1 }- W3 T: j: L. i$ F; z
, {, a% U3 ^8 F) k4 u
" `# K7 F3 d& v |
|