物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 r" w. h8 L0 y2 k! P2 n
Failed.');
: \# {# O, M- O6 P1 k}
: C" ~$ {" W  m3 ?% a; b, S( d( R4 kConnect();
2 r) W' d7 G3 N6 a) X8 k
function InitForm(){
! h' e5 ^) N$ H$ C//layout for the form
echo "<strong>Send Items.</strong>
$ r* l& t$ b% V2 }<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/>
: I" D: e% \4 v- X0 W: t+ s<lable>Item Amount</lable><br/>
& P0 k$ v- Q0 M<input type='text' name='item_amount'/><br/>
9 Z3 K. t# |3 y+ M( e/ c; L<lable>Item Upgrade Amount</lable><br/>
! F$ X- y# U0 I! ^: h) ]$ D<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( I! A4 b$ I! B% c# I7 a
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
3 H# c+ Q& e( ^( ?5 @$ U; ~<input type='text' name='element_upgrade'/><br/>
" H" x4 n; ~0 Q<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
. e. |1 r9 W1 O8 u) L</form>";
& I2 f8 u$ U4 O! `+ A}
" I; [1 H4 r6 m7 ]
function PostListener (){
4 F! I$ ~# i3 F# R# P//Add more post variables if needed and add them to initform() function aswell

################################
; w1 I7 @1 z5 P) b; ^  c##### Connection and Post ######
! v( W* h4 t+ ?" `! K3 P' q$ e################################
$name = @$_POST['char'];
8 a/ ?$ {* h  \$ `3 B$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
6 Z: S* t- r% x# ~1 z$ c: Y$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
" e& S6 L9 p, [! ~$ElementUpgrade = @$_POST['element_upgrade'];
9 G& H8 p: K+ \$ItemPierce = @$_POST['item_pierce'];
+ H- J4 d$ b3 m, O' E################################

//Check both variables for empty value
' y1 v2 k. Z9 W) S- o
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* z- f8 h4 K. u% e. a/ ^5 J
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  @$ k8 v* [8 z8 E9 }$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ X. w0 c" [$ \8 {% `' p
2 ~! T. w5 v0 V9 {6 f8 M3 J[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, G# O$ H2 d! {+ r  d" a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 ~( ]7 R4 N/ d, }; |
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

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

}

8 w0 t+ w% a5 }8 i}
* ~2 S  A" F1 i) o8 d- b
. I5 t3 j' S& M$InitForm = InitForm();
/ d8 {+ a( ~9 o) r$Listener = PostListener();

?>
7 g- k# K0 T( {+ v6 z3 ~% a
, |; U; T$ @) j# G; l6 {