物品发送脚本

admin

<?php
& c9 D/ s% _& v9 A% s/ |function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; z( c2 R; G- [" ~; e6 G
" v) M0 h) s+ H! `* vFailed.');
}
" q6 z* T3 |7 G) m1 H; @, zConnect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
' e) f0 ^. g' N! y<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. Y/ t( p- z1 h* X  r) R2 }; ^<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
+ V* n# [" O. u, p% f<lable>Item Upgrade Amount</lable><br/>
6 w) _3 f6 r. h7 I<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
% l( T3 \6 e9 Q<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
) Z' X' S9 d. K3 t5 H+ n<input type='text' name='item_pierce'/><br/>
. |4 G2 {* H$ @$ _<input type='submit'/>
7 s: i- V$ d) B! h# F' e% {* y</form>";
}
! R2 m$ v8 k; f# D: S* o# W# b) e
* O* z3 L8 ^- ?0 Z, o# O; s3 `function PostListener (){
! \+ r* q, x  X: y//Add more post variables if needed and add them to initform() function aswell

# Z/ o5 N7 @$ d% D################################
##### Connection and Post ######
7 T7 o3 v0 Y: z2 W, e3 I# j% r5 V################################
% \; Y+ i; `0 d9 g2 }+ N. w$name = @$_POST['char'];
& i; n) u+ ~. d: a' f! p7 r$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
, n% y( m- x& p) Q4 x$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
. U# V8 N1 @8 \2 w* D4 @
# o4 b' O. e( kif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

* W2 K8 s5 w8 M/ Q1 ^, b- C9 Fm_szName = '{$name}'");
2 ?6 R  G# y4 Qwhile ($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],
! S/ p% H/ T+ q4 j+ T. ^
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  x. q" E; |- {, A, t, n$ E
- V5 q, ]" g; F( O[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( p' o2 Q/ a8 f; E# I( F' WN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

) A8 b. ^) b4 C+ l. z'{$ElementUpgrade}', '{$ItemPierce}');");
}
8 ^  E. p+ l% e
}
+ f+ A  q: j& B) Z
}
8 a4 n3 x; C' U3 o
4 c; L. i* {7 ^- }+ s7 z$InitForm = InitForm();
0 y5 a( s7 u3 p$Listener = PostListener();
" N& `5 ~# J( Y7 r* L. K
0 t3 P/ Q- g' R. O1 e?>
2 U) |% j  U7 h% ^+ U+ o2 J

+ o% S: `) \' Z0 M% F# Q
4 F. H3 f3 I; w0 |
$ }7 g! M' G/ M  ?8 ]