物品发送脚本

admin

<?php
/ a5 d$ Y. ^) ~, i2 vfunction Connect () {
& g2 Z, k, ]8 ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ G5 k  {- W2 A
& j0 n* H) L3 l  c( `9 XFailed.');
}
Connect();
/ Y& p' x+ T9 H+ ?
" |. I" v6 `3 F/ C! q  Kfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
  v; f9 Q1 ?1 `# w<input type='text' name='char'/><br/>
% S- e% o3 w% w  M* x<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/>
<lable>Item Upgrade Amount</lable><br/>
& Y  A9 Q. _/ L& `<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
8 m" W" G; _8 G2 q<input type='text' name='item_element'/><br/>
, x- m' W$ c1 V0 y; u' S+ A' U1 j<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 n$ d8 q8 |6 t<lable>Pierced Amount</lable><br/>
) c/ b5 `. K) Y+ B% L<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
4 Z, {4 |+ d6 N) `& k9 F3 w! Z</form>";
}
+ [, {* g# S9 C. {( w2 E0 y" P( g$ V
8 N8 s( B% q6 o/ d+ G8 c8 [) Y6 pfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

4 p# s2 v0 z6 C################################
##### Connection and Post ######
7 q/ h& R7 b% K; x% l################################
6 G- x* W' T7 T' m/ s1 Q$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
% P: V5 m. w  x5 G' i1 K8 }) z$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
. z* C- n/ L1 L, s& d$ k" i$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
6 b6 Z/ z" ]  B$ R. Y/ O6 Y2 D! A$ElementUpgrade = @$_POST['element_upgrade'];
% D. v3 f, F) g! P( i& R) S8 q$ItemPierce = @$_POST['item_pierce'];
################################
: q7 A# p: e! _- ^( g( e0 [
9 M' o) ]8 j4 ], r9 y4 }+ s//Check both variables for empty value
) }7 \$ }$ j  X3 C3 w3 c8 N$ c- P) d
5 @4 a7 i1 E. r  z+ t$ U7 Cif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 k; S+ a. [% G5 X1 D- P
m_szName = '{$name}'");
+ \/ F8 W2 ]: Y! f7 j- gwhile ($row = mssql_fetch_object($find)){
: M( b6 t* o# v$ z! M. aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

9 @. P$ p: O% w[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

8 }/ H7 m1 q: S3 u! O2 x1 ?' |N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& L; E% I. W( A8 l) [3 T
. \  x; M, O0 l9 W8 g'{$ElementUpgrade}', '{$ItemPierce}');");
}

+ K$ V. h% w! ]1 L  a- N5 C}

: Z, O2 _% k$ ~) o; A* B# a- W7 P}
" R7 t9 E8 J2 `- [/ `
$InitForm = InitForm();
$Listener = PostListener();
0 M, F# q4 ~9 ^8 u4 V
7 o9 F7 m% C% F0 a% v$ F- Y. E0 J?>




; y! `9 x2 _5 I, L' Q1 G* {