物品发送脚本

admin

<?php
- p) y! r9 P2 v8 s6 g2 ifunction Connect () {
& F& A5 N; M. I0 z3 n6 l3 Vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

$ b% q8 e, g" m; A" r2 zFailed.');
}
Connect();

function InitForm(){
$ ^( h1 n, D7 r. L2 n' T3 c//layout for the form
, ~$ s- ?+ [. E! b6 I8 J' becho "<strong>Send Items.</strong>
* r' p5 [7 N: o, v7 X2 R5 q<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/>
7 X. `" G% F3 C0 L' X<input type='text' name='item_name'/><br/>
( b3 b2 b/ F/ y& V1 k# x  `0 s' T  a<lable>Item Amount</lable><br/>
$ R$ ]; M! {# k' _& G<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
- ]  R' u1 ?; m& M5 q- X5 G6 ^2 `) S<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

3 F4 X" C  f3 d</lable><br/>
<input type='text' name='item_element'/><br/>
; R, q. h, M/ U$ Y- P" g<lable>Element Upgrade Amount</lable><br/>
' R- o9 r: S9 {. \6 f% o) J( A<input type='text' name='element_upgrade'/><br/>
- y6 B2 z. I6 p7 h/ h: D) h<lable>Pierced Amount</lable><br/>
: n( f7 `9 b+ a  T- ^% `8 }* o% U<input type='text' name='item_pierce'/><br/>
. Q; z$ H, j% T) ~* |1 l2 W<input type='submit'/>
</form>";
) A3 L0 ^( U5 V" x3 u% X' c/ }}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
4 Q' U6 {' p+ s. {5 P6 {" V1 P& z
################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
3 ~4 L1 ~2 C# j( }1 ~8 g$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
: M3 q$ x4 _8 ~" G/ F$ItemUpgrade = @$_POST['item_upgrade'];
$ h3 T8 N, Y- e8 u$ItemElement = @$_POST['item_element'];
2 t* q2 _0 t6 }$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
3 G" g% Y; H% ]9 ~. d& k################################
6 X; G& W. z# w, x: z
8 c6 ]& i  Q8 M0 K# l- q//Check both variables for empty value

3 a' O) p2 F7 M1 G/ m3 N" qif (!empty($_POST['char'])){
0 Z( K% K" @6 W- {& D$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% h2 p; S4 }4 f0 H# Y( u6 k
m_szName = '{$name}'");
1 O2 n8 g/ ]1 Z/ k8 lwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 H7 a& O0 w- ^5 F( H  S
" F) g1 R) w' {! h0 b3 x8 V2 b  z  U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ i7 J( t5 ~& ~2 S5 R& o9 v/ ]8 g
% @3 m9 n1 g1 R/ V) ]N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) M0 N. y- u& t" W4 F8 v
4 C: ?5 ?; b! ]'{$ElementUpgrade}', '{$ItemPierce}');");
3 ^/ ~' {( g% J" d0 w+ {}
5 G+ ]0 K& k: ^: g7 z
}
  T: i, f" M% f- g/ ~5 b0 D
4 a# w! S' }6 W0 K1 R) I1 m6 V) X}

' i2 z4 p4 ~2 ^% ?6 p) ?$InitForm = InitForm();
$Listener = PostListener();

0 T, L+ s! f: S5 W  S1 G?>
  i) R4 j" R6 m/ H, D, d2 p

0 Y3 r9 f" T$ H0 |( M" U* d5 M
2 C8 A" Y8 p4 [, F5 O9 x7 o