物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

  k9 `3 @, @; k+ m/ }; V# O) _Failed.');
}
$ E2 Q# n0 ?2 S1 D0 C+ C3 E4 cConnect();
2 D8 Q+ S3 f! d( }5 s2 A) l
8 Q6 L7 M/ P: Q4 m' T+ a9 {0 cfunction InitForm(){
//layout for the form
% O6 S; a  y% f* V+ Eecho "<strong>Send Items.</strong>
# g* P9 g/ X+ H, R) Z<form name='select' method='post'>
  f4 }$ C/ ~! [' n7 ^4 k$ V. Q. g<lable>Character Name</lable><br/>
" y/ n3 l4 P! c% y0 y+ g2 i' h<input type='text' name='char'/><br/>
<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/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
: Z7 y) F$ O8 K2 ]<input type='text' name='item_upgrade'/><br/>
1 T) E: h4 D7 X7 Z0 `! f- h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ b2 `/ Y( O- S+ k  i. w/ X. C2 k# k
& M! C8 |$ c  f3 f</lable><br/>
- q) x; ?& F3 Z; Q<input type='text' name='item_element'/><br/>
/ k! y  E' ^0 A+ A8 `$ W9 X<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
7 V& D& e( |0 i* S' v4 r/ m9 Z}
% O0 b/ }2 R0 f" c- j! B
function PostListener (){
2 {/ U1 ?  O5 h//Add more post variables if needed and add them to initform() function aswell
0 W# T8 ]- @' J# B) c
################################
% \: `2 H2 Q: b8 H+ N; y##### Connection and Post ######
2 X) d+ S/ {: {################################
% R4 B/ f9 D: N5 }; }3 g. G( F$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
% e' j/ t6 {( N4 H# ]$ItemAmount = @$_POST['item_amount'];
; e8 O7 f- y& O( Z) c$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
6 {$ Y. y- l0 i' b1 ^5 e9 X$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
9 r. n7 [! r' r1 C$ItemPierce = @$_POST['item_pierce'];
################################
7 a7 o9 R. Q: v% W4 C7 U5 q
//Check both variables for empty value

if (!empty($_POST['char'])){
, I. @; n  i0 Z$ O* K0 K$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 d1 E' T: j# J( q! W, a
m_szName = '{$name}'");
- r- c" F7 o' S5 l+ t& ~while ($row = mssql_fetch_object($find)){
! Y7 e# G3 |  A& }; @" ~echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 Z+ r" d& K1 L1 {$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 }8 T1 i: P6 }, x& F  @
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ O2 u+ v( I* x% n
6 B, ]; e9 v8 q) X- iN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: D- f* v' w& P: U; g* u
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

, c9 K9 y% o0 V0 X/ \5 t2 P}
  {8 d/ Z, J1 }, S
$ t$ G8 O  i( M8 m0 R$InitForm = InitForm();
$Listener = PostListener();

+ Y8 a. J9 P' F: f1 c+ B?>
4 g# g6 `$ v0 U) w5 G# Z
2 U# j# c  H& ~, t6 k
/ U; G3 k& Q) X0 v3 f7 k" N4 q! {
8 T" N5 p0 }) j& ^4 U6 ~& @