物品发送脚本

admin

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

Failed.');
}
Connect();
6 U& m3 H8 r( _
function InitForm(){
4 \$ v0 |& y. Y# T4 C7 B3 B8 r//layout for the form
echo "<strong>Send Items.</strong>
; z* W$ ?. M, F( |# U: o$ d( }3 A<form name='select' method='post'>
<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/>
<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.)

, @! M- `- P! a0 R% y6 y7 Y/ E</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
& ~7 e3 F, I  w9 m+ O+ W+ r<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

# q3 f/ c# m  `+ }% i7 }5 k. Ifunction PostListener (){
& i- [3 h; ^8 M3 C) I//Add more post variables if needed and add them to initform() function aswell

0 _$ T3 f  Q! T! b9 E, A################################
##### Connection and Post ######
8 L! K! l$ h) U2 s, ?) T3 _################################
& h( X$ O/ a/ ^1 ]. R3 K0 {$name = @$_POST['char'];
% M3 g! `2 D7 W$ i- w$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
5 Q& O# M% s3 l( J) d# \8 l( T' a$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
, k" ?1 }! h. P' N2 H) E7 X: ?! K$ItemElement = @$_POST['item_element'];
" B  Z5 G2 [0 j$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

0 I/ U& V2 U2 |1 z//Check both variables for empty value

) s' M2 N- r$ j; z. O  \) vif (!empty($_POST['char'])){
# Y6 E3 R/ g: G2 }, f3 p1 F1 V% E$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& K6 A  J/ p+ o. a& [. k3 N9 J
m_szName = '{$name}'");
! Y- E" V8 \3 a1 a5 a' Swhile ($row = mssql_fetch_object($find)){
/ Q1 e& h1 w% becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ D! `. F+ `: |; y& t  `3 t3 x$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

9 K9 T+ G# g+ n1 }$ @[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 R2 J  n8 C# g) }- q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ c) f: V3 N% m* h
) S- ^; H! L0 w- KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 B1 s+ u2 e9 B% B, A6 f
4 C! G6 ^; c; F9 j'{$ElementUpgrade}', '{$ItemPierce}');");
}
. \0 Q  e; K3 n7 H$ _! t2 j
+ [6 `/ C" x+ ?' p}

}
  Y+ v6 s: ]# b/ J6 m
) G% b8 l9 ]1 D- D% ~$InitForm = InitForm();
0 p5 m, d: H2 q4 i' h$Listener = PostListener();

?>
' s6 e4 n  |5 v



# W' Q( ~+ z! A" g6 s* e