物品发送脚本

admin

<?php
, {- N, ]2 j, S3 ~function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! e: C. ]! S7 t. B
Failed.');
}
4 x" M. l  W6 t+ A" r/ v9 c; l: uConnect();
& ^; t; Q$ F2 l9 N3 m2 \/ d
function InitForm(){
# z! S3 C; ~" d. o- b8 H3 ?# ]//layout for the form
echo "<strong>Send Items.</strong>
( R: @" I8 Y8 h! V& S<form name='select' method='post'>
- g, j/ f3 `# ]" @<lable>Character Name</lable><br/>
5 B2 L( A# _3 ?  |<input type='text' name='char'/><br/>
( K. R4 J( s$ Q! u5 t' W<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
6 S1 ?+ b! D1 s& P4 K1 ?' }<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<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 |- }6 M$ a# |
</lable><br/>
% j$ X$ s: D0 V5 }<input type='text' name='item_element'/><br/>
: S. ]/ J5 `" B. J1 d1 ^0 l" m2 U6 h<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
) n# c% t* ]! I8 x4 f: H9 `<input type='text' name='item_pierce'/><br/>
: N* W2 P7 \" u; L8 y& N& j<input type='submit'/>
, k0 p7 w( D* _, F+ I</form>";
}

function PostListener (){
0 F2 k, C0 y* H7 b" {& K* ^//Add more post variables if needed and add them to initform() function aswell
* V7 p1 F7 x' r/ f$ m  @: \
################################
- ]3 _- g+ K5 b  v, z  o3 G##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
0 {( k/ w9 y( \0 t2 O$ r9 J2 F$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
8 Q& C- s3 T- ?/ B$ItemUpgrade = @$_POST['item_upgrade'];
! C4 l4 C& o6 a: e1 E1 K$ItemElement = @$_POST['item_element'];
5 L" W4 l. w3 b. t% ?# I$ElementUpgrade = @$_POST['element_upgrade'];
! r' S% g0 k. w3 ~! h, l$ItemPierce = @$_POST['item_pierce'];
################################
  N" v& X. Q9 T+ z( _! r7 p  @- {
//Check both variables for empty value

6 f$ s9 `8 Y9 p' r3 ]4 wif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

6 Q: F2 K% f. M0 ~- m4 a6 c( om_szName = '{$name}'");
- b  L6 |. v4 B' e2 @4 nwhile ($row = mssql_fetch_object($find)){
' b6 }$ L* H/ Recho "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],
) ^" p6 s' p: T; ?  [
8 A: V; k3 a. m8 b" [' _$ b; R- v[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; b" d( C7 R  ?5 h, J& t7 C
'{$ElementUpgrade}', '{$ItemPierce}');");
2 [  }/ x8 _2 {' x: w5 u8 G& ^  {}

}
  r9 z7 h' o0 O9 w
9 e. \% {) v' ?6 U8 p% T" _; }- u/ `}

: n' U, g$ A5 U0 V* S$InitForm = InitForm();
1 {2 L  c. s6 N' e6 @! `$Listener = PostListener();

?>
& E* U0 I6 D. ]  {, X

( u& K$ N' \: L. a: M

3 e1 H; z5 I! {