物品发送脚本

admin

<?php
2 u/ \5 Y8 `* M- ufunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& ^. O3 }$ j! \- ~
Failed.');
}
6 e; b8 C# b$ F- t: p; }8 S6 DConnect();

& M$ ^5 T% k  Z2 Zfunction InitForm(){
. ~8 w/ v( ^/ X$ n' D) r( S//layout for the form
echo "<strong>Send Items.</strong>
6 o7 x( z+ P3 S' q6 G0 Z% r& J<form name='select' method='post'>
- b/ k! V7 E0 ?2 Q' Y: a<lable>Character Name</lable><br/>
8 ?# q) R: {* e<input type='text' name='char'/><br/>
( ~& q; x) q+ [) _9 W  p) o+ Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" v3 h5 S. o( }/ D<input type='text' name='item_name'/><br/>
5 y* E5 E' i' |4 ]9 d, C* q' l! n, D<lable>Item Amount</lable><br/>
! j+ F9 f) G# x. C( |: n<input type='text' name='item_amount'/><br/>
0 U9 b) p& \0 G& V<lable>Item Upgrade Amount</lable><br/>
! r7 d0 b: Y, h$ ]+ e; l5 R: Y* ?<input type='text' name='item_upgrade'/><br/>
+ i2 V! z  f5 @! G" }/ Q5 F7 l6 ]5 @<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 o: ?4 n' i4 x5 `  N( r: v  v
% l: b5 s) |5 d2 z8 t</lable><br/>
: n3 Z( b0 y& u. g0 E- I) T$ P<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
2 ]- t0 i* U/ X7 o0 I<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
& g3 }/ H! S/ ]
function PostListener (){
- C, p( H3 O, T- O, j//Add more post variables if needed and add them to initform() function aswell

- \8 P# w+ G. z; D################################
' ~7 [- ]- Q6 n- K- T' c##### Connection and Post ######
0 d) D/ g1 o- i6 E! a################################
$ o: V2 ]. L4 w4 K0 d$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
& ~4 R2 w2 b7 |8 R$ItemId = @$_POST['item_id'];
- |+ u3 w# ^/ m7 W8 I2 J$ItemUpgrade = @$_POST['item_upgrade'];
8 }/ y% w. Z, C4 A9 b2 h$ItemElement = @$_POST['item_element'];
0 O$ l3 }& W# R9 r0 m, {% ?$ElementUpgrade = @$_POST['element_upgrade'];
1 R( Z0 `, f4 B" ~$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
  Z/ x% ?7 u0 m. g
( h# `0 ^0 W8 o' f: P) xif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 V& K. P5 t4 V7 L& H8 g' G7 a8 Y
m_szName = '{$name}'");
  v& H0 j% j9 J- A5 o. ^* Swhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! U6 C6 c. y, ]' Z- ~! f$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

0 |* z* S3 G% _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

7 [5 \8 X: n- q5 v[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

5 n, V7 ^" ~; s% l% A( L8 r% Q+ GN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
# [. {: n0 A) j  w; l1 N}

}

}

$InitForm = InitForm();
- K9 G8 h6 T, W" h5 s  T6 O$Listener = PostListener();

+ X- Y: f* R* k$ {, B?>
' k# M6 W0 \5 s6 k. ]2 H. j

& J6 q" W( [* p% O# i7 o  k+ N
& v5 \1 t5 `  e
9 y* \/ d+ x; m0 W: t