物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
& \0 |- m% X+ j1 A1 G# s9 mConnect();
9 l! X  F+ h9 o  h3 P
7 ?6 I- k0 i' bfunction InitForm(){
//layout for the form
8 z5 l: B7 X9 H6 a. ^4 E6 N  Mecho "<strong>Send Items.</strong>
<form name='select' method='post'>
+ q  e/ _9 O/ ?* R9 D( E" l5 X<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
1 y# J2 d- l. ]! m<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
- V( V/ R: \9 E. w<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& U1 e5 E; r. n3 H; Y' v" ^
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
$ v" u; F- q0 U& h6 y4 X# Z7 `1 C2 s<input type='submit'/>
</form>";
$ {$ _: @" O% A6 O  M) V}
8 W  I/ F3 f& V. v# {" d. C( n
function PostListener (){
$ @4 {/ z4 V7 S: V/ Q4 ^//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
0 p! \) m  Z& [2 ]################################
: g. I! C: c6 l! B- i6 h4 n+ ]1 _$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
) a, m9 a6 t' {( f! L) h$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
4 f1 `; N: I4 G( i$ItemElement = @$_POST['item_element'];
8 b# o# {1 f2 ]# W$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
3 v# _9 ?" k# ~+ S& f' R################################

//Check both variables for empty value

% m4 u9 j9 w& }' jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 a, x" i; N! c1 A8 M) _
6 @3 G# t' l8 sm_szName = '{$name}'");
1 `* f8 O# i) y* B' _4 _while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ j1 N' }( w* d( s' s$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, E+ j5 x  ^6 j( m2 t0 x7 {7 U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' i, c' u  }, e9 p; D$ X
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

+ a4 D5 E# w2 F3 f  x'{$ElementUpgrade}', '{$ItemPierce}');");
# L% t- R: O" \; w0 A9 }+ X9 h}

* u. n& c7 d! @+ }* m( R- p}

}
# k- X) V, R$ J& M
6 c7 o9 V) @- t5 |6 L& _. m, l- I$InitForm = InitForm();
$Listener = PostListener();

?>




& \# X. S5 N5 g6 J! [& _* G