物品发送脚本

admin

<?php
3 n8 R5 \3 U8 Rfunction Connect () {
9 o! N$ _* d' T4 Mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();

) @! X, g% x5 D8 v# M5 j3 a& v/ kfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
6 d3 l# u* ?' {( F<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
* a0 v" y* R- Y' B: o+ Q) q+ N<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 A* ~: D) F; m9 H$ V: y<input type='text' name='item_name'/><br/>
/ L/ Q$ u6 t* Q; X# E4 _- e<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
  T$ ?# x& c* m, G7 k" G<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.)
1 \9 V6 w* b0 ~' h2 w, }
" u7 R- ]& l  i+ R, i</lable><br/>
<input type='text' name='item_element'/><br/>
: P$ J! X% i6 n$ d<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
! k# V/ \6 b# d) m; H7 d<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

; }/ f2 m; V0 X6 D+ u1 A5 nfunction PostListener (){
7 w& y/ `- q, z//Add more post variables if needed and add them to initform() function aswell

% f* j+ V9 F+ ~/ j4 K################################
% q( ]7 k1 ^7 ~6 y; k##### Connection and Post ######
################################
$name = @$_POST['char'];
2 N' e/ E" `  ?% F$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
0 h2 x6 h% K1 z0 U3 R- @! k* n$ElementUpgrade = @$_POST['element_upgrade'];
' a2 K0 M2 r5 P, g5 P# d$ItemPierce = @$_POST['item_pierce'];
################################

$ H3 z/ t8 N: e8 v//Check both variables for empty value
/ ^; Z. o0 V4 H5 d* X
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
$ @9 I0 ?0 u7 H' z3 [" W0 jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; J  A( @0 ?/ X' l* v( H$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

/ M0 ^7 a7 R( m2 I7 j" z" `" P, d[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

- w- W8 N& P, O[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( {$ w4 p: O' x2 e8 BN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

( Q$ z% w4 _/ e8 h}

3 B: ~) h# Y, c+ L% B$InitForm = InitForm();
$ K$ c& X! N1 A% g9 Y$Listener = PostListener();

?>
( R$ X1 a4 j) g+ m- \6 I1 r4 @
0 P; d* H0 m* F/ `* E+ a

" c: B. n" t; ^3 g3 n2 g2 G
: E; t! }+ v/ G- ^, @