物品发送脚本

admin

<?php
function Connect () {
/ y+ b! w6 T. C3 ^9 n! vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 r, }2 W4 p4 X
7 o+ {# Z2 w# u4 ?3 f' N1 v! F/ iFailed.');
}
, F( w* p- }/ o- i, N( ~- A5 H2 }Connect();

function InitForm(){
//layout for the form
5 e, p5 W5 L, ^6 ^echo "<strong>Send Items.</strong>
<form name='select' method='post'>
2 p5 P+ {; x% \$ W' J9 R<lable>Character Name</lable><br/>
& {. h. {( C+ Q! G1 ]<input type='text' name='char'/><br/>
- `. i' f" i, R; ~3 G4 P3 `' ]* G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' A& ?' m/ d& v* V<input type='text' name='item_name'/><br/>
* i' w9 O- h' B! \5 @<lable>Item Amount</lable><br/>
  Q  k* A+ _/ @" Y<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
+ O  x8 T3 ~7 |" ^, E+ _9 }<input type='text' name='item_upgrade'/><br/>
9 }7 }4 J% v! w8 M8 r  ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
+ r7 }6 K4 f' z5 W4 I$ {<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 n% [+ l4 D: j6 m' P<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
; a+ |. y5 H% e  T, `0 x! \3 P. ?/ z</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
) j( `- r" e4 x
################################
##### Connection and Post ######
& M: U# ?6 l4 @0 u0 p7 L################################
$name = @$_POST['char'];
) F# H3 ~' o9 r1 W$ItemName = @$_POST['item_name'];
, u& [8 Y3 h6 D' z: p$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
9 o) k& b- ?2 M/ |" u+ {$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
) H+ B' M% U, E' |8 O/ @  P7 J
//Check both variables for empty value

+ m. x# f) _/ ?9 l5 zif (!empty($_POST['char'])){
3 F9 J6 l# E8 \4 Q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

( R# H/ o2 U$ a# Q' w, S" d7 C" Ym_szName = '{$name}'");
* m! Q/ t" J( l" p5 }' i$ w5 vwhile ($row = mssql_fetch_object($find)){
$ V3 C' j6 g! Lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! K" H2 [/ d0 F+ \( F& m+ P
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  r8 p. |3 ~6 S3 y  b6 O# ~+ K& ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) d. q) C& S6 ^' e
5 ]# u8 U; c. ]1 x- {2 m% W'{$ElementUpgrade}', '{$ItemPierce}');");
! X, ^8 S( f) {$ L& L: z7 G}

}

}
, R1 u' h2 r: l) w; A
, K1 U# x7 l) r$InitForm = InitForm();
+ H: Z( L4 m. b& i$Listener = PostListener();
( f4 V/ X" L- a5 m8 t. U0 q, u
+ a* G& N" k! ~2 [  \; u3 R: i?>