物品发送脚本

admin

<?php
) C6 D; F+ ]) G6 I* F0 `function Connect () {
+ {$ A4 n3 W' {8 [. }$ h8 emssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" ~7 ]8 }+ ?% L# i
Failed.');
}
. x4 I9 m: {7 d( u( }' o; ~7 MConnect();
: a2 \( r  k1 a  m. f" t! o8 O/ @
function InitForm(){
9 C& V9 Z/ B& H6 b6 _//layout for the form
3 g! b* P) z- j- \0 m  U8 _echo "<strong>Send Items.</strong>
; l# \: H0 y' P4 H( Z6 Z8 ~<form name='select' method='post'>
<lable>Character Name</lable><br/>
6 G+ c0 E/ Z/ I2 g2 m+ Q<input type='text' name='char'/><br/>
# ~/ V7 g4 c( p- F/ U! v2 h8 [<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: K( e- j; ]3 W  T<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
0 K) r: T$ _  u<input type='text' name='item_amount'/><br/>
# x# c. d# k: j/ |: _<lable>Item Upgrade Amount</lable><br/>
8 `& r3 e% a. y; e<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- ^- r% ~6 C# {2 G* `1 \7 |" {& w
</lable><br/>
6 J! [; t( k7 S4 R<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
" p! g* S% [& l' N1 u/ Y<lable>Pierced Amount</lable><br/>
7 G7 N$ v, U% E  Z<input type='text' name='item_pierce'/><br/>
! U% E/ K: E, x: q3 s9 I1 E<input type='submit'/>
</form>";
}

function PostListener (){
& p; j5 }( N9 w& }3 }# [//Add more post variables if needed and add them to initform() function aswell
9 \# Y1 `: O. U4 E* c
################################
##### Connection and Post ######
3 H5 M! Y+ u) M1 P! l################################
$ U% |  t  K- \  B- g% b4 ]' f$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
; ^; P' U+ d# l7 a+ w1 q$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
; `& [9 T( a9 A7 }$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
$ S6 \6 b( |$ j$ l3 H; c################################
( |4 l# L. a) q9 c
//Check both variables for empty value
8 l2 o! L. @6 b0 X
if (!empty($_POST['char'])){
, ^% Y: S7 C. t: a$ a/ S$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 T  ^( x: j# t) k) I8 a; I
m_szName = '{$name}'");
* t' k; ^# f' q! H, f5 R' mwhile ($row = mssql_fetch_object($find)){
7 Q" I- G9 ~8 k  _7 `0 yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 O- }2 h+ E1 d6 \$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

: p7 k% q8 _/ ^% u( {3 U. C7 _  I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ f( U: j: T9 _% E, A+ Q) x  S
6 R! q: k! ?( I6 r/ F6 a1 p; ?[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! C0 ]" A) Y" F( p+ }) l
& j4 Z! l9 W; ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
0 ~7 j" A' n- Z4 n}

}
6 |/ t: B( ?  n1 f! Y! G
4 K7 _, w$ Z4 P, y5 @}
) M& Q: g- U1 z% o& \( ~
; H4 b- `. A( R3 a' D/ m( j$InitForm = InitForm();
2 t) S2 }( e0 O/ d% X( C" O$Listener = PostListener();

?>
& O7 \$ G) r- y& o
1 v0 v) l( ~0 o/ O  g' G
, d& ^3 \) R5 W! ^: ]
! J& ?. _  ?# u
0 a4 i, e/ @& S& j- j4 b