物品发送脚本

admin

<?php
) t3 M+ `; C6 _) d4 X2 ^' @, i, ufunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

, r. O$ a. q) c5 TFailed.');
}
Connect();

! O+ m) r/ c) i2 wfunction InitForm(){
$ a9 p! d! ~) n. M3 g//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
& v% \: N8 N6 B+ t) |3 ?4 W<input type='text' name='char'/><br/>
& ]) x" W2 m3 f8 E<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/>
- y6 ?5 k/ M) ~! p$ n& |<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& }* P) }  l( C
</lable><br/>
& Y4 U- B/ B1 ]. ~- N<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
7 u0 n6 R$ I$ h4 o2 H/ j<input type='text' name='element_upgrade'/><br/>
: g- ]. T- g- R<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
" g) _8 Z1 [# o# D- c3 b# `<input type='submit'/>
' n1 q8 d% L" F/ X4 J</form>";
! h# M0 r, V1 j4 s& X}
3 m, w% R  R5 \* H9 m
4 h( \% B7 h  e) k* ^. y) Qfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
: g- A7 Y+ I! l- ]##### Connection and Post ######
2 W4 T7 e2 i9 t################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 ]9 K! C3 y, Z! v6 W- W( f9 h% a, V1 I$ItemAmount = @$_POST['item_amount'];
/ A3 s5 d  c4 F3 _; p0 N7 H$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
4 Z3 ?# V, c5 e6 q7 D$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
0 `; R$ ~% M# M# W
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 b8 c! z; ~* l# K- V, H5 q' J& e) X5 w
m_szName = '{$name}'");
1 U6 g/ C& o6 I" Kwhile ($row = mssql_fetch_object($find)){
3 g8 Z. g/ e  s0 ?9 Z$ Recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; a6 C+ a, |+ j. z" \
  T0 r/ i& ]( i3 W* @6 n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* P2 r0 t8 c5 |' |9 F/ t* P
  c. e  ~6 p& ]3 q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

5 _' l0 w6 q5 z6 V) A% v: c'{$ElementUpgrade}', '{$ItemPierce}');");
}
' ?/ j2 @: D4 N% M+ p
}
2 |  a  h' k( E! ~
( x$ f% L1 l1 t8 z4 Z}
) H) r) y, F9 ]
$InitForm = InitForm();
; p% P% A4 C# H$Listener = PostListener();
+ @. D0 f8 o( D! }8 H
?>

7 H. k2 T( ~; U# {

4 t2 z" q2 D! W, Q8 k, I
  Y4 }5 T$ ~* _1 Y