物品发送脚本

admin

<?php
- R/ P+ k, U. ^- Nfunction Connect () {
1 s" i# ?5 C7 D2 y# Gmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

  Y' v: g5 C( _( l0 QFailed.');
% ]$ Z1 c7 }1 X}
3 e. o2 R: k! V4 k+ U2 a; O0 {Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<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/>
* e7 \2 T8 M; W! N<input type='text' name='item_name'/><br/>
/ j, U+ ~4 t- J. l<lable>Item Amount</lable><br/>
. B, \. P) C# X6 b8 o<input type='text' name='item_amount'/><br/>
, ?+ s, m+ ~2 a  \0 G<lable>Item Upgrade Amount</lable><br/>
9 N& ^* f6 G7 r1 E<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 y. e' I/ E" O6 k4 x
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
$ j4 Z2 u- @+ H$ ~<input type='text' name='element_upgrade'/><br/>
' r# S& h4 a* Q0 m- J% `# k<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
5 t6 ?' v6 O9 W2 s/ r' m</form>";
}

5 g3 b" [8 j7 [. C. Y0 }) M0 mfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
; F% J) Q+ \, h# z7 \
2 c# ^# ~% A# _, L" `################################
3 ~% m* o6 j# q8 V##### Connection and Post ######
################################
, J; H7 I: h* R; N0 z/ _5 L$name = @$_POST['char'];
3 Z% M) b  l! d- b9 D7 ^5 Z( g$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
* _9 [: j1 B. o# {$ItemElement = @$_POST['item_element'];
) r3 ?+ p& e7 i) D: z( [$ElementUpgrade = @$_POST['element_upgrade'];
! w; L  e* I8 S/ b9 }; t$ItemPierce = @$_POST['item_pierce'];
& `' }3 O# C$ Y; p' [% W- z9 a################################

5 C! y/ U4 x# X; b% A2 Y0 N//Check both variables for empty value
  W" a9 g, P3 N5 B( G
, X$ y( a5 A) E3 L. s- Hif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' J2 Y1 i" W" D5 s7 H
' [# H4 s7 [, Z% y9 |4 j' Tm_szName = '{$name}'");
; U. b: ^8 W% _6 k  C" Iwhile ($row = mssql_fetch_object($find)){
! n' m9 s8 g: Y3 r5 }echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ t& b* ]) x, x+ F! R1 c$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

7 Q" X5 x5 s# l/ H- T! S1 p+ V[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- l/ ]: X( ]; w: v
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

+ t8 Q& I7 f/ N' _* T  E' TN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

0 @4 N) |9 T% l- P- f) q& k4 y'{$ElementUpgrade}', '{$ItemPierce}');");
# ]5 ]8 Y1 Z5 U}
( Y2 {. A7 a% R5 w) t* J$ r
+ T+ U4 T& m; M% A' b}

0 E' j% I7 s1 A3 d}

, W5 i) ]# J/ e3 P  U$InitForm = InitForm();
$Listener = PostListener();

# E1 w! K$ K! y?>
# ^: A8 u0 @+ _7 n8 ?
' A+ _  S/ Y- X3 s6 F4 t9 F- D. a
* F# O5 ?' J4 p# b+ K: D4 X