物品发送脚本

admin

<?php
function Connect () {
& q+ b0 l2 D) e" `; h6 Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

9 N6 l5 Z" s' }# D" KFailed.');
8 C+ \& c3 J" K/ ~- e- X+ P}
* _7 D3 n  l7 U' J6 X, b3 rConnect();
& U; g( ^" }. D0 c8 V
% O! ]1 f6 j1 Y, Q  b4 Qfunction InitForm(){
, C; @! n$ n9 ^. v//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
' F  G. Y. Y& n* K( t& Y<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
- z2 V( k4 O- T<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 R/ f. s6 \& o! j% r- ]5 B6 @<input type='text' name='item_name'/><br/>
4 @# L* ~; G- U; u( {<lable>Item Amount</lable><br/>
3 M( x9 u  a3 M) e  [! _: G6 N<input type='text' name='item_amount'/><br/>
- J/ r2 P: V8 V' t8 k$ G4 \' ?$ V<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.)

</lable><br/>
<input type='text' name='item_element'/><br/>
/ D$ @- P) ]8 M4 h9 G<lable>Element Upgrade Amount</lable><br/>
: O. h) |% _+ M<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
6 m5 ^6 d+ q, u& N  z* t# ~<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
8 s* T; G$ `2 s1 c# V
function PostListener (){
: l. [7 Z* x+ {8 G' q' I: \$ q2 o//Add more post variables if needed and add them to initform() function aswell
  D( \) r; T, g
################################
4 K7 q- N7 `3 }  P+ n3 q##### Connection and Post ######
' E& |/ Q' O$ o7 f################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
& f; N$ q% S8 u$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
. j, T" J0 s7 G/ o
//Check both variables for empty value
& `! @+ y+ V; }- ?; ~) v
. t! D" L  G  Y  Y' o7 s+ c2 ~8 Fif (!empty($_POST['char'])){
% @: G* e- i9 g% C- a$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 z- y% |7 v: Q( d7 z" p) q/ t
1 V( z  S  {, j$ \" m2 \m_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],

  x! h$ [! Z4 C2 c[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}',
; A; |2 ?* A7 G8 r  E/ S' W) d1 c$ ^
3 W9 ?) `- R' z" w0 Z1 J0 i- O5 S'{$ElementUpgrade}', '{$ItemPierce}');");
}
' l$ l; W5 }3 ~; r
}

}

8 M+ k9 i/ s1 d8 v$InitForm = InitForm();
# L! E5 u1 G0 ^  W$Listener = PostListener();
5 r& ?" P7 u4 @7 j
?>
  j: ^. `+ l$ W- H$ m6 l, X
; Q) f/ y, u% a+ g0 z/ C
3 K5 r4 d. x1 d, C" E7 Y4 s