物品发送脚本

admin

<?php
; r) d% F0 Y2 S  @2 X0 r. h* V8 Cfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% N+ m9 z3 R+ L: G2 S0 T9 F
$ n/ d6 n: E" G2 KFailed.');
}
: U5 A" h" ^. F  Q+ w# CConnect();

  u1 r  d, K5 D+ ]/ G. xfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
" s: u  i0 V: K8 f1 y<form name='select' method='post'>
! n* T- N  ?  l' f0 L% p7 K  X<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
; c1 ^; W7 N/ S8 Y; F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# x0 I7 \6 X% o8 \5 x+ T<input type='text' name='item_name'/><br/>
8 x$ d# w+ {2 {" ^. n2 l<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/>
2 o. ?5 R" t2 b2 t* h/ l<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 {# Z% P. K( S! V2 {! T* d  I0 ^
1 _8 G) `( p9 y4 n4 z</lable><br/>
<input type='text' name='item_element'/><br/>
; e! b+ s; |0 f' Y* y8 t<lable>Element Upgrade Amount</lable><br/>
" Q  }6 a& w8 G" F5 _<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
' h) ?, b  l. P# L& D<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
7 U2 ^2 R& x; }# y% b
; k) Y7 O( K3 D6 Z8 ^3 lfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
) _0 f' B& V: M; L9 z2 D
5 Q  ?* O( ~) M4 a* m################################
##### Connection and Post ######
5 M! A+ [' U; J/ [' L! ?4 k7 Z/ S4 |8 o################################
' g; F( y7 W$ O6 W1 l7 o) F' o$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
+ t6 l' w7 A. L$ItemId = @$_POST['item_id'];
' l+ d, K8 x8 D2 K  K7 L; v$ItemUpgrade = @$_POST['item_upgrade'];
( `3 |$ r9 F$ Z4 n, X- V$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
, z6 e6 K, k$ f* Q" c################################

* I  L3 h. M  ?* _9 w: I2 X//Check both variables for empty value

3 [: g: V5 i8 B" {; x' M2 Jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) Z& S  k# D6 y, Y& c
m_szName = '{$name}'");
* Q5 D9 p* H% K) `while ($row = mssql_fetch_object($find)){
/ p0 n8 {/ g9 x2 z- }9 |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: y# z% s1 m: y% u" I
. @$ l6 r3 }6 O% w* ]+ q/ A[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% G" `; g9 d0 B' ~8 P
; M1 M6 K3 V+ _# G! B& K[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

& |& Q# X  ^3 D- FN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, {) R$ ~) h) n; C1 E1 F
' T2 E3 g/ _8 X# W& g'{$ElementUpgrade}', '{$ItemPierce}');");
6 x& w8 e6 _( p: {}

}

  Y2 x. J6 M3 T}

$InitForm = InitForm();
" o. g& d; w- r  j, w$Listener = PostListener();

* S, j! M. t! C+ F7 b- I?>


+ Z  T4 l, o3 y& v1 t
$ b' r; M. y2 A$ b1 f2 K  R