物品发送脚本

admin

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

6 v' r" `" _( F( ~0 t6 a( |: Z- DFailed.');
}
Connect();
* H9 C0 f- Z$ e! e! G1 I' W
function InitForm(){
5 n5 H* d- N9 X7 B) V//layout for the form
1 {8 }" D2 e+ l% y$ ?echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<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/>
) n2 t! h) x8 q  \. i' e, ?( A9 d9 I<input type='text' name='item_name'/><br/>
- m, `% u5 Q& h' @<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
$ z+ y2 Y) d, J/ l<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/>
$ u/ N9 Y+ c4 H# s6 c  B3 S<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
, F9 H( X9 @  g$ }<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
& u/ ?$ i2 V# `: s4 C}

function PostListener (){
: v8 [& F, Q& _+ O//Add more post variables if needed and add them to initform() function aswell
8 [0 V! K( o. {7 e4 f2 ?6 x; O
. u+ M. \1 i; D  s################################
##### Connection and Post ######
################################
6 ^2 Y, e# F: ~: j$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
6 n# G' z& R" j8 Y9 x2 j$ItemAmount = @$_POST['item_amount'];
, n9 E+ Z( {% c$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
" x% A2 C. i+ H: `$ItemElement = @$_POST['item_element'];
) f! ?9 ~' ]4 H- ], @! y$ElementUpgrade = @$_POST['element_upgrade'];
$ @4 t6 O4 S% ?4 z# c  ?3 u$ItemPierce = @$_POST['item_pierce'];
################################
! b' U9 J) O; n- M1 Z2 U* O: |
//Check both variables for empty value

if (!empty($_POST['char'])){
1 `: t6 o& h- ~+ @$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 r; m' m  g1 D3 z6 x' {- {
, B7 e+ @3 |( t2 Bm_szName = '{$name}'");
; A! g& u: q8 u3 U- C  C( R4 bwhile ($row = mssql_fetch_object($find)){
' \- h( {. ]6 b" Z7 [9 aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) z2 p0 c( B$ l7 I
% _7 N; T9 a4 {& r+ p. F[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" G1 v; M8 F2 |# N3 D5 T/ v
- n% d+ C$ l+ V5 A& _# RN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

8 S" A; }9 v; T# Y% O( s6 J6 c'{$ElementUpgrade}', '{$ItemPierce}');");
}
1 Y$ U( N4 i& b3 N
}

! P  c; f( o! |8 G' T}
7 X' E4 o( D1 t5 A0 k
$InitForm = InitForm();
$Listener = PostListener();
9 y8 {/ J& U$ p0 S4 j3 j- B8 s. e
?>

( h$ ]0 m) o! F9 x7 R7 K7 P( O! a
- @& G% Y/ Y; ?; ]" U! G
* q  P9 k" ?( j  P" x