物品发送脚本

admin

<?php
' `5 ?& s, f* ~" A# j9 l% N) [function Connect () {
# `* v: I8 y5 l$ L. A  c$ Qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

; f1 n7 C/ V# H8 V/ m  FFailed.');
}
Connect();

+ Q: g( j- v" ^" \! zfunction InitForm(){
  h- l; ^4 ]( X' Y. g0 l//layout for the form
, s' j6 s0 ?  k1 necho "<strong>Send Items.</strong>
<form name='select' method='post'>
. [. ~% _4 V/ b9 P) v/ ^<lable>Character Name</lable><br/>
( M3 Z' K2 p6 @: l4 \% M9 n<input type='text' name='char'/><br/>
0 r  }/ j# Y2 ?) L2 D7 ?<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
$ [5 `) v8 g0 |<lable>Item Amount</lable><br/>
" F3 H* a# i4 C. Z' ]* J0 K5 m<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.)

. q: _6 |) r5 S" c</lable><br/>
' `) C4 K" z; s$ C& z! N( n) ^<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
3 S. O! u$ D! {3 e, H<input type='text' name='element_upgrade'/><br/>
2 m1 x+ U- z% ]+ [<lable>Pierced Amount</lable><br/>
. w" J) \; Z, ^# x( N9 `<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
8 h# t3 |! Q. o5 p& I% U9 ?; n}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
7 w3 K9 G0 N. }+ T##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
  l  A7 `: Z% U0 D7 C6 Q$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
6 G) X5 [- j5 @1 ], R$ItemPierce = @$_POST['item_pierce'];
################################

2 a3 R' i5 L1 r//Check both variables for empty value

- I  P- j1 y8 V- B# _+ x; J) pif (!empty($_POST['char'])){
' w; W# _) `7 T" `1 x  K7 w- L$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

) p! K$ z8 H6 Q& b8 z5 ^m_szName = '{$name}'");
# X0 n1 z4 G# {; V0 T5 a2 v0 t- dwhile ($row = mssql_fetch_object($find)){
" z3 {( J" S  r/ I- ]echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 C' p* e5 C. g" J& E. ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

$ b* _5 `) J3 o- s) |+ ?[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* w6 ^- c: Z3 p5 r! {  J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

+ x, m: V3 V/ |) n0 d/ f: @2 y}
! i9 c% O. C" w  O4 {
$InitForm = InitForm();
$Listener = PostListener();

?>
% G% W* z2 ^# E& M4 x2 u" C5 }0 F

3 a8 E  L+ B8 P
3 {0 t& g! r( U$ R; Y. {
) ?5 Z0 _% e2 ^