物品发送脚本

admin

<?php
6 Z; Z4 \/ O+ afunction Connect () {
  u/ V" _) X& }3 c0 a; W/ vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
) w( N. p% j; K9 o; Q9 U}
Connect();
7 N( w% B' l4 M  j0 y0 i" H5 }
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
0 z! [3 X& V- {+ |0 i/ Z" I% n<lable>Character Name</lable><br/>
2 A; p. Z) F8 p3 Q+ \. {<input type='text' name='char'/><br/>
) y' h+ G- A+ @3 ~) ]2 P, r7 t( D9 p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 \4 }( p0 M; R<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
' C  S: V1 I# [! V: n6 H<input type='text' name='item_amount'/><br/>
; C7 v: l! o; I5 w; u0 }<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

% ?& t( M+ G  ^3 w7 z) u</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
7 A' t  L; |" P8 g. R( y<input type='text' name='element_upgrade'/><br/>
0 S4 k! {# O8 `# ^<lable>Pierced Amount</lable><br/>
, i2 c( _0 Z8 c+ v<input type='text' name='item_pierce'/><br/>
% t+ O  w" P, }+ p<input type='submit'/>
. @+ w5 l3 i0 d</form>";
}
) S  K) k  C! w
function PostListener (){
; _, Q" Z' @( |9 @& c7 [4 T& f" |//Add more post variables if needed and add them to initform() function aswell
2 O' z0 g' i2 v; s0 t, d
9 r3 Q$ a1 b( F. v3 k################################
! V& b4 F( X5 v; B, K##### Connection and Post ######
################################
$name = @$_POST['char'];
3 j1 @. e$ Q+ I5 c  P$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
, Y0 n: H$ Q* S/ C7 u% x8 V$ItemId = @$_POST['item_id'];
0 |) r* g3 e6 ?% z7 [# _$ItemUpgrade = @$_POST['item_upgrade'];
9 k+ j1 A5 j( v  z9 }$ItemElement = @$_POST['item_element'];
9 F9 e" D) Y: S& F* B) E$ElementUpgrade = @$_POST['element_upgrade'];
$ f$ P. C! `! B! {! ^& c$ItemPierce = @$_POST['item_pierce'];
: u" C! n7 h$ z7 O: i################################

/ }, a$ J4 J1 U1 P; G//Check both variables for empty value

, f( M7 V" v( X7 G6 J, a1 W# f0 bif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

* p, c# [; {2 a+ @( J: j  b2 Pm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
" }$ B2 [1 _9 X1 Q1 _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' }  g# t. s6 m$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* h5 ^7 f; H8 ^9 Y
% w& Y; U: k% \/ C7 s) }[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

% O. x( `; [  d) z& Y3 p2 ]- l[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( ^/ [1 @& ]+ Y/ o/ `3 u
'{$ElementUpgrade}', '{$ItemPierce}');");
. B' |, U) F  M+ G& K}
! c' c: _( o! Q# X  c' W
/ A6 q2 C$ w2 {6 p" C/ P  F}
% O1 w8 c, C  O8 Z0 N
6 m- h7 w; {  u  i  i" n5 U9 U}

7 s" }/ m9 K: W7 ]# P8 G: J$InitForm = InitForm();
+ S# c: [- q, m. T! X8 n( a$Listener = PostListener();
( F- e( A+ K3 X- R  d" S' f
?>
, y( w" Z' g0 r' d
; X) r  }# D9 K
* \; H$ f" }: E5 s. |8 C
" B/ P& A8 g4 C0 M; q