物品发送脚本

admin

<?php
+ H7 X2 O9 z& V8 T# \function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: ]/ z6 n2 L  M. I9 r( m& x4 `
: j& H; k) v: V: J9 tFailed.');
}
Connect();

function InitForm(){
//layout for the form
; v. t7 }# M/ i( ?7 oecho "<strong>Send Items.</strong>
: Z+ o; m6 D, Q3 x3 u! C<form name='select' method='post'>
- n/ D& ?# C2 c7 L( H/ Q. o<lable>Character Name</lable><br/>
, t' q, ^) W/ }' _6 V( v<input type='text' name='char'/><br/>
7 r2 |  b6 z- G3 J. X* Y+ ]! G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ v2 Y0 w% I1 J3 \5 ], |- v<input type='text' name='item_name'/><br/>
* E' g0 h, e: l* t<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
5 K( z& j2 [0 n<lable>Item Upgrade Amount</lable><br/>
# x; W  D0 q% l' r5 Y# Y<input type='text' name='item_upgrade'/><br/>
: z& v9 z, H1 N/ ~<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) l( G; W/ F7 u% x2 Z2 }  l* g; h1 F
</lable><br/>
<input type='text' name='item_element'/><br/>
8 d& o: p  _! ?4 ?<lable>Element Upgrade Amount</lable><br/>
" z" `0 ?, D( ?2 J; {8 H8 y9 x7 |7 D<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
( y: R3 e& U! e
0 W) Y) h# W; A8 c6 Wfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
' X4 D) W5 P+ L2 g0 l
################################
##### Connection and Post ######
! @. S$ w6 P2 h0 g- l################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
. ^7 Z* N5 _- |( M$ItemId = @$_POST['item_id'];
. I4 l4 i* ~2 }, m* L7 ^$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
4 y" W8 b7 r1 e) G- z) c- P3 ^$ElementUpgrade = @$_POST['element_upgrade'];
; h' e& l0 A  s$ItemPierce = @$_POST['item_pierce'];
5 V! M: ^0 z$ D! o################################
6 J# D4 `# ?; s) z6 W6 u
2 |, @. ?6 G, j2 e//Check both variables for empty value

if (!empty($_POST['char'])){
1 k$ P5 C# a9 F; R" r- a% |$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
6 F+ P$ W1 t3 H. D% B' i6 necho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 O: q/ v& B! U: x: _, v& T$ B4 R$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& s4 J7 V5 b4 l( V! [4 S8 v- W" P: ]
+ C5 p! I% e; Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 A' j2 Z* P# y3 R) L! n6 k8 j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

; Q/ B0 q& a* I! KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

8 L, X4 K$ b- k- r4 D; }* i'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}

# j8 l4 q. l! O8 o' I. ?$InitForm = InitForm();
! E1 Z) _  v/ i4 y; ]% d$Listener = PostListener();
4 Z. S1 Z4 x' w
4 \, E4 \5 G' _" J+ F?>



$ }; d0 w; h. y0 Y