物品发送脚本

admin

<?php
. h- J; g+ X( D0 D- Afunction Connect () {
9 M9 S' i2 u9 j5 lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
1 X4 T4 n6 L4 B, a# i}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
; J+ m+ J# _- F! n<lable>Character Name</lable><br/>
" u" E3 G) l# I<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/>
/ J2 c6 Z4 y+ e1 U8 i<input type='text' name='item_amount'/><br/>
- y+ N  H1 g5 n2 q5 t8 y' ~! @( J. c<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.)

</lable><br/>
7 {: N& h0 m7 w, D<input type='text' name='item_element'/><br/>
" X. F- n: z+ F# a2 d. V5 m& O<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
! x8 N+ E0 J* S4 D& k, d2 C<lable>Pierced Amount</lable><br/>
* X- t: {1 V2 H; i. q7 E& Q<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
1 g: l! F% ?% I: y( T. u</form>";
- U. h2 V, I3 H6 z3 N}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
) E% L' d/ Z0 b
################################
##### Connection and Post ######
################################
1 Z5 ^$ k) q; j  M- n$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
9 V% }+ k5 [7 f% A7 c$ItemId = @$_POST['item_id'];
2 ^5 D9 G; b# D! |' g$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

* a8 ], B' k  A+ {7 Q" @//Check both variables for empty value
+ c" j' C6 c/ M- i: O6 S/ i: Z8 p2 q
4 }2 g8 U& m5 I& x9 h( wif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ B8 K3 Q& i: Y* |/ s+ _
: r4 e" J3 u* V  T8 \m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, K" ~  [+ F$ d+ g( D& Y: H. B9 Q/ d$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 G: C9 b+ T' d! _/ o3 O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

* w7 E3 w! d) C; m3 u" k( w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- ]4 z9 {) Z, _) p& Q
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

: J: Q$ E0 ~1 k# A'{$ElementUpgrade}', '{$ItemPierce}');");
$ ?8 {1 L' w. P8 r}
' A- [( i0 B5 e1 U- Q) ~0 ?
}

}
/ g; Z2 i3 o3 ]9 H' D" I' k! o
$InitForm = InitForm();
$Listener = PostListener();

7 [  d% A; k) C3 ], ]?>


) J+ ]& V/ G4 I$ e