物品发送脚本

admin

<?php
9 H7 D' w: h9 l" nfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
2 ~. Y* g# L+ m( pConnect();
3 b* ]* T# H) }
+ X/ m2 }3 N0 w1 Kfunction InitForm(){
9 m! ]: [3 I( d# ?- n7 j//layout for the form
. s3 ^5 n6 _, \) l! z% @4 oecho "<strong>Send Items.</strong>
<form name='select' method='post'>
5 Q4 i: C% @$ h% {5 f1 v+ h<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/>
6 {# C' V8 Z1 W" j! _+ _- E; C1 }# j<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
8 @; v+ [( n: `& Z7 [5 e<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
( n3 }) d. F' Z' E/ G; ~8 A! \" A<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. j* E' M- W) q! }
7 s+ x1 x7 D. {# L/ f, p( B1 }# l</lable><br/>
; r! n- ?4 W- O% Z. w  p9 I& c<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
- i) T+ U& U1 X/ z! H5 B2 k5 C9 P<input type='text' name='element_upgrade'/><br/>
% J( c; z6 Q' E<lable>Pierced Amount</lable><br/>
* I. L) e! v; o4 z5 A  V! T<input type='text' name='item_pierce'/><br/>
; ?8 \; O7 B- K5 K<input type='submit'/>
</form>";
}
" i/ e6 m- `# V% A, y
0 R; [- t7 E, Y! w7 n- Efunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
3 {4 O9 Y! f" b: t. J, E# j
) s9 x. ~& [, G5 j4 C  z1 \################################
##### Connection and Post ######
################################
% c: j" L+ B1 M; V2 c, f0 ]$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
5 p" e) z# d1 @* T* g$ItemElement = @$_POST['item_element'];
! ?7 K9 G; D2 W. Q+ I$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
% G+ M4 T$ j$ G# ]; J* _################################

/ W6 g% n  e1 ~+ l( N4 u//Check both variables for empty value

+ j8 Z7 O4 p6 @9 G7 Y, [: iif (!empty($_POST['char'])){
8 c6 s  f% L- T5 v3 C$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

" d1 {, e0 Q6 U5 i, Wm_szName = '{$name}'");
5 i* _( a- h" _/ I7 c" H& x& Qwhile ($row = mssql_fetch_object($find)){
5 k) _  T' e- b/ R$ {echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! t/ q4 S, S6 q# n8 Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 s4 S/ K% r) w1 ~" J! p! z9 e+ E
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- q( H9 }/ K  k/ @
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& F) D$ Z1 u0 F  i$ B
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}

$InitForm = InitForm();
3 K5 b# f2 {( j5 K$ `8 T! D$Listener = PostListener();

?>