物品发送脚本

admin

<?php
4 S; c. u  w. @- O6 t& V2 Y2 ~function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
& U1 o0 }: Q& g; T}
( m: m. B/ w2 ]7 W  z5 e. HConnect();

function InitForm(){
" K9 m/ P% E* z4 O% j6 l//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
: m1 p. v7 p, |7 K# m<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/>
<input type='text' name='item_name'/><br/>
$ C$ M- G% E+ b$ y3 g6 T, k, c<lable>Item Amount</lable><br/>
2 e  O% Q# a1 A' H<input type='text' name='item_amount'/><br/>
0 `. ]6 ?  F8 b" O' g+ x. H<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& \6 Q7 a; \& f" N1 h
; i. r5 j( R2 N- n</lable><br/>
<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/>
% F; Y" M3 \$ h: X: ^/ I( k; j" _<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
: D1 j9 j3 [  ~2 f6 \</form>";
}
/ F- w& q% q8 E5 K+ N( o9 s
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
7 J: B2 ]2 M; U3 P1 _( C5 W
################################
##### Connection and Post ######
' X6 I9 b* N, E- Y################################
$name = @$_POST['char'];
" v$ N# j- E8 r5 R$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
% l4 G5 ?7 Q" N$ItemId = @$_POST['item_id'];
: {0 _8 p+ c+ ]) {, O9 |/ ?$ItemUpgrade = @$_POST['item_upgrade'];
8 w) c" b3 w; x  |+ K$ItemElement = @$_POST['item_element'];
) `! D; d8 w; U3 w+ H4 }$ElementUpgrade = @$_POST['element_upgrade'];
% T' v; j7 V: w8 V# D, A; \) G$ItemPierce = @$_POST['item_pierce'];
1 V2 r  A- A9 I+ G$ m0 E4 l################################
9 H3 T/ `% d& ~3 W# G2 O3 L/ |
//Check both variables for empty value

! `3 m/ K$ z. A1 d7 ^- Vif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% q9 K0 q8 O# C% }
m_szName = '{$name}'");
7 d' D6 |" W( B3 C  bwhile ($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],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

% c6 J$ S. R8 ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

! Q+ L7 K7 z" F+ I5 Z1 YN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ `+ d5 a) C" u/ f3 v
* @2 U- ?) u1 }9 {2 @'{$ElementUpgrade}', '{$ItemPierce}');");
}
, M' B3 s* ]) ~8 t# k) s
}
' }% b3 \( K5 S/ V' p" b/ ?6 H
}
1 q: C5 T3 c  g( Y& d! A
$InitForm = InitForm();
2 H8 c: p( ~3 q) H- d( F, {$Listener = PostListener();
! g' R' ^; q. [. m
7 ]5 u9 F2 a* G; f6 J! ^1 D+ h  J7 A4 _?>

( Z) l* M* G, N0 T' }. i


9 I& n# k! }. V; V: I6 b; Z