物品发送脚本

admin

<?php
function Connect () {
/ L( k( V. _, R0 h5 ~: Fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% w: q% o4 r; H% w3 `" h* G
Failed.');
}
$ b, |1 p- H0 v1 pConnect();

' l0 N6 t! t3 q6 ]  t* wfunction InitForm(){
  R' w% G% d) m+ @//layout for the form
. V0 D% G+ j$ o4 {echo "<strong>Send Items.</strong>
: @+ t) T  d6 Q4 k) j( p<form name='select' method='post'>
<lable>Character Name</lable><br/>
, v0 W; o" a$ l1 L! U<input type='text' name='char'/><br/>
: h/ \! G# O7 \1 D- _1 F6 {<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
, V4 Q5 O. h2 _% `& S! S<input type='text' name='item_amount'/><br/>
<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.)

: R. L) o( T' g7 m. h9 }</lable><br/>
( S) m9 v8 u' G; Y# \5 V5 T5 y' s<input type='text' name='item_element'/><br/>
/ w! D; A$ {" f/ q<lable>Element Upgrade Amount</lable><br/>
: a$ S( `! u2 O. n! ^7 P<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
' M8 Y3 D2 N. H- ~/ {<input type='submit'/>
</form>";
# H5 Q4 ~$ V3 ^# B% l) o}
1 h( R! \  ]5 J# g4 m4 g
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
6 k( i% M& ~5 _; W
################################
6 ^) V' K" g, |# i8 W% V4 @##### Connection and Post ######
################################
1 m0 z0 X6 X& }( u# V' ^1 I$name = @$_POST['char'];
! f) X! I& w- {% c5 v  u$ItemName = @$_POST['item_name'];
0 L  {2 }2 v& ]$ a; f1 j$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
3 O: \) m# n- ^  `. L! @/ w4 b$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
# ^# G& }) M0 b################################
1 i( s6 f1 U1 s, n2 F5 J
//Check both variables for empty value
" l5 w  G9 @: u8 O- _
5 Y/ p  ?" |' O- y3 xif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. x+ Q4 s1 _4 I% E$ f; L% q9 R$ d+ O
0 n/ z3 a  x8 ]m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

' \' V, s5 e7 Z1 ~( t2 j- b[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

; b# C( `- {; w" @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  h) o  t) z' U; A! ^* H) x( }
'{$ElementUpgrade}', '{$ItemPierce}');");
}
( P1 ?- [; l8 Q- l; ?6 H
1 V0 ?7 ^) x$ \- n4 m- e) z$ I6 a}

}
* R( O. x' F4 Q& f7 H% m
$InitForm = InitForm();
6 Q$ b- q3 a0 U0 ]( P# N# {1 l: k$Listener = PostListener();
  K' Z! t! G8 g# x5 V
?>



: d0 D1 f& O* S1 a