物品发送脚本

admin

<?php
3 Y* M9 F1 y, }3 S8 ~8 bfunction Connect () {
; @6 i0 T: p9 w! A' C* nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" i$ D  Z0 T- Y$ ~8 H( a/ m
Failed.');
" J# c/ t$ L0 S" f: }: I& v$ l) G}
Connect();
  i. G8 ^* `4 ]: t8 z# E( E
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
) u6 `4 f4 B" m( Y<lable>Character Name</lable><br/>
8 Q0 s2 t. J( M1 b5 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/>
<input type='text' name='item_amount'/><br/>
+ w& k8 q3 W4 I. e<lable>Item Upgrade Amount</lable><br/>
: m$ h' b! ^0 w! |# U<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* z2 ]" v- N+ |% I1 n, A
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
: s5 P$ p- a5 K- M<lable>Pierced Amount</lable><br/>
. s# l6 _. N% Y<input type='text' name='item_pierce'/><br/>
: G# k$ ~3 s% G  P4 I. c: I+ j<input type='submit'/>
</form>";
}
1 h5 \; ^# c/ Z( ]' N0 X- I! d
: H7 e; k8 S0 y& X! efunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
: z& f& F2 _' x& }
% ~1 s/ [; J# |# O4 v% ^" ]6 W################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
! ~! y) C1 D2 z& C$ItemName = @$_POST['item_name'];
. ]; X+ b# n" I' ?$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
& V; n# n) u8 P$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ D" N7 f4 ?" w* ?$ItemPierce = @$_POST['item_pierce'];
: q, W* u+ F% }  \; a################################
5 A% n' l+ T6 B6 o6 t7 X
//Check both variables for empty value
0 V8 c* ?* a% `6 k/ q% `; N! |
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 S6 m1 W/ B% O2 [
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
7 B3 B. j5 s3 M6 B' \echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) M' K6 O! A+ I. C7 ~! i8 f
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 ~6 k, ^1 S$ ^. Q: Q& a5 S3 j
. }. j7 R/ j" H8 x1 s) L4 [$ N[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

'{$ElementUpgrade}', '{$ItemPierce}');");
& l$ L) I6 e5 X4 E. @" e6 N9 c}
% n/ I6 C0 m; R# F
}
& r; j1 k( w! L& O8 S$ p
}
, l4 K/ [, n  a
) X/ G7 K$ G2 V# w$InitForm = InitForm();
* s) W0 W4 R+ @& `1 m6 i$Listener = PostListener();
0 _8 Q7 Z, \- z; ^( H$ ?
, q6 B! f# Q. u: B- k+ j" k?>

4 w9 T* K. K& J8 z; ?3 j4 F


( T+ [4 G% t) v