物品发送脚本

admin

<?php
( m; G8 H1 }  j. Q) K. R' mfunction Connect () {
) S$ z6 p) J0 v% @2 S/ u/ ^  jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

& r8 |7 N& s& ^: _- FFailed.');
}
Connect();
) Y/ |  F7 g. n! H2 u
function InitForm(){
//layout for the form
3 O( D0 K/ i+ m2 ^4 i. V/ A# {' k& Fecho "<strong>Send Items.</strong>
6 f8 X4 k5 p& W<form name='select' method='post'>
& O3 ?8 Q3 g4 n* p& m9 f3 A" l. b<lable>Character Name</lable><br/>
<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/>
8 l! y6 G  S, p<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
* P9 p3 r* S. f" I" y8 O4 w' {<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
8 m4 |7 c7 V- b9 v, M. p; l<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
# V- d' C; z2 J1 J/ E- z. ~! S( L<lable>Pierced Amount</lable><br/>
3 z; }3 Z/ Y4 N. F6 K<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
/ J. n( ?; {8 u( ^; x</form>";
}
, r7 k# P/ D  l# W0 O! z0 d
% }+ X# G6 r9 K: ~; \2 W: wfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

; T0 g, _6 ?. J' {, Z################################
##### Connection and Post ######
################################
; m) G! X) F7 E9 x5 X) v& Z5 R, e$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
: o: {2 Y1 f' h4 Z; d9 e) |. I$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
, o) M2 b7 C2 [6 {  C$ I$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
" W8 U: v6 t3 b: P3 F- u################################
* @. ?, Y2 z" v6 y* A7 X' b' I
2 G6 |1 G& m) \5 h1 o//Check both variables for empty value
. L% F# f0 {4 e9 N$ d
' J/ i, B- B* J3 wif (!empty($_POST['char'])){
7 j. L$ F$ g2 k  i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
6 f; O$ i; D; ~1 k/ Fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& l, t- }/ {+ s" B) t$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ k4 ?* g9 z: S5 [4 o; A4 x: _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 M3 Z4 ]$ M" y( D
* U' S' Y+ V  c' E; M8 N( b4 X* zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  D8 ]0 E- Y6 _* ~5 ~
( Q/ O( S; y$ D( S, g2 F'{$ElementUpgrade}', '{$ItemPierce}');");
}

# k0 l) i9 W+ U7 S}

+ ~! [+ p5 K, M}
/ m. e2 k: l- ~2 ?% z% k
$InitForm = InitForm();
$Listener = PostListener();
) X5 W0 |" O8 M% N9 a1 B7 v
1 ~' k: n& P% o9 o3 [3 J5 ?& g% i?>


+ k* S3 X1 y! p5 D
: X, d3 K! c0 q& W/ l' O: Z. @
# M& m7 ?2 s+ E* e5 j- t