物品发送脚本

admin

<?php
function Connect () {
! ~$ G# X6 ~, @mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 J+ s' u0 R8 P
Failed.');
}
' E6 s$ ~% K& ~- }: h/ Z5 }Connect();

: T3 a0 p7 q* l* `: }* V# e0 e3 D) Ifunction InitForm(){
* S6 B5 ^, A. T6 p4 }//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
- k4 R- z; ]3 A' y7 I7 \5 t<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
1 I, l8 j/ b1 _* B* N<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% x- L- y* u. t<input type='text' name='item_name'/><br/>
% H: Y" `6 {+ O! Y4 P7 W: K<lable>Item Amount</lable><br/>
<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.)
9 x  \8 H$ }8 e  d! P
</lable><br/>
<input type='text' name='item_element'/><br/>
7 l# [: u8 l7 l" z' `<lable>Element Upgrade Amount</lable><br/>
9 @. I; W/ ]4 h+ M' G- b/ Q9 F8 ~+ b0 i<input type='text' name='element_upgrade'/><br/>
0 B  }! M1 n0 v: O<lable>Pierced Amount</lable><br/>
' f2 |; q2 V7 ~+ T. T  j; V<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
/ A3 ?+ u, P% q2 F4 p}

/ J# }# Z) v5 x' \5 }+ x- @1 ?0 ?6 lfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
) q; \) V$ A; d: Y8 e' G9 s6 W$ItemAmount = @$_POST['item_amount'];
& T& g1 ~& C- K- i5 ?# d. }$ItemId = @$_POST['item_id'];
9 t; H# c7 |3 w% Y1 c$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
7 S7 }1 D/ l# P, P0 G$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
2 d0 Z* [( D+ c6 z! \% j$ [6 c
6 w( K$ O# C% {8 D0 z+ T//Check both variables for empty value
2 t- e, A6 {' K8 l2 }* }' o, _
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

( z$ \2 j! p- k  [. Pm_szName = '{$name}'");
0 @/ Q" X' x% ^: W/ P5 E) n' {- @while ($row = mssql_fetch_object($find)){
7 J/ x* w" n9 U+ T! @echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) p9 v& c8 `0 k3 T3 x' _
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
  v1 B3 T( M! l
' ~; k  _- j! L}
; e* G& ]$ c% I' z7 \6 W
0 M; r1 m2 K; f4 O2 l) q  n}

$InitForm = InitForm();
, V0 _$ K2 p7 r, Y$Listener = PostListener();
) f0 W! K& V" K$ H# c
+ a% C) Z/ n% e, M# h- o$ t- |?>


6 N# @* N6 O: B6 F8 Q