物品发送脚本

admin

<?php
0 W$ A# n8 w* s3 t: Nfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
3 S) t" @. y+ ^3 g) UConnect();

6 w0 a9 |! H$ vfunction 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/>
' T; K# n: u2 p( Z. k7 v# C& m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
* ^9 T7 @, P2 g5 f" c) \& ~<lable>Item Amount</lable><br/>
3 C* F$ K& `) {5 V5 U  o<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.)

& D7 f4 a" H4 ?  L7 b</lable><br/>
<input type='text' name='item_element'/><br/>
! U5 L% L6 T. Y+ v$ D2 z0 `# `<lable>Element Upgrade Amount</lable><br/>
2 `1 `' e6 ~) G- O<input type='text' name='element_upgrade'/><br/>
5 e& C9 i% Z2 j: J' j+ M<lable>Pierced Amount</lable><br/>
1 j! N; B7 @7 ?9 W6 e' N<input type='text' name='item_pierce'/><br/>
# |" ~8 }$ z+ j" s<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
" X) ?7 H) g% |4 N2 q##### Connection and Post ######
) F$ W9 i# x6 W% k" t3 W################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
2 b! |( I* R- K; T* T% ~) h6 Y$ItemId = @$_POST['item_id'];
  |3 V& s5 s6 B$ItemUpgrade = @$_POST['item_upgrade'];
" s$ u9 w! e0 E1 S$ItemElement = @$_POST['item_element'];
  J) ^& k' i9 |, M* Q3 `" P$ElementUpgrade = @$_POST['element_upgrade'];
3 ?/ R2 ~0 R8 X1 Z5 Q$ItemPierce = @$_POST['item_pierce'];
3 M! ~* ^: v2 S$ Z7 E, p################################
# s. F/ J6 K( {: D) D
//Check both variables for empty value

9 M2 b' X2 H; }% r* F- d/ N% a& Nif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

5 K- m8 r0 a) m$ Hm_szName = '{$name}'");
while ($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],
' a% p) i4 @: q. X/ w: F2 D; S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. V& o: V; B0 r! f
* a6 T+ l; \  {  i/ K. A0 w'{$ElementUpgrade}', '{$ItemPierce}');");
}

! E5 d( S# R# D}
( M7 N( p. C/ j) Q% ?* G8 u4 `
}
; |9 \  W( @/ R/ f* n( Q/ S
4 w$ ]: x  [8 p9 f- c0 c$InitForm = InitForm();
! g% A/ ^$ t0 M- U9 L# R2 o% h9 k$Listener = PostListener();

?>
. o/ X* L/ s+ t* j: B9 n) ?
/ @9 L8 ^; d0 A" [0 Z/ M" m/ {
# K* \9 l% Z8 x6 p3 ~8 @9 |
* n( w) `1 U& U* v; `6 M