物品发送脚本

admin

<?php
function Connect () {
: a+ O4 P6 k# \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

& N$ Z+ o4 t6 R- u9 [' E  fFailed.');
* Q8 s1 H% p- j" j4 R8 [* S}
Connect();

7 }4 k8 l2 E9 \% g5 y! {function 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/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
, f& \' @8 P. }% Y9 Z  w' Y7 ?/ L<lable>Item Amount</lable><br/>
% G  o+ b: B) Q3 v+ _<input type='text' name='item_amount'/><br/>
2 Q1 X" k4 I" k  C- d<lable>Item Upgrade Amount</lable><br/>
& A9 C: k* Y) m<input type='text' name='item_upgrade'/><br/>
% {$ Z. e$ Z2 _<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

5 _  U+ N. G! J4 \" Z4 {' j* w</lable><br/>
$ u6 H8 j6 A. M9 Z4 D! b<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
+ e3 ]9 b/ n9 Q! _* j<input type='text' name='element_upgrade'/><br/>
2 [5 Z* [( }- O! h0 C( _<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

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

################################
5 l- s0 T0 m. J* T##### Connection and Post ######
& s/ ~( @2 c% v# b5 ?# s# H################################
( _+ F3 E, L/ R& r. U& g- L  Z$name = @$_POST['char'];
% Q! W% Y5 T7 \1 ~2 O! L$ItemName = @$_POST['item_name'];
9 {1 s- n, u* ^$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
6 S7 V8 B* S$ R8 A) y3 K4 O$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
) l% z) u" W$ o- w, M! w/ H; @8 y$ItemPierce = @$_POST['item_pierce'];
################################

3 q( P* ]6 I7 Z3 M//Check both variables for empty value

# j! G/ P$ R4 `9 ~! V6 Bif (!empty($_POST['char'])){
: \" H& p# ^2 a( i4 q% k$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% v/ d& @# t$ q! i, k0 N+ J6 _4 p5 t
m_szName = '{$name}'");
: c( M0 p  b$ R9 ~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],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

  z: j3 F% I+ }+ G$ {[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ P& M( a9 K" l! Q$ X
( o6 _4 t% N8 u# D6 v  {N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

6 N& `% W( r, e" j0 m'{$ElementUpgrade}', '{$ItemPierce}');");
}

2 y1 }: z; x* m2 J& I6 s}
) S  X( G4 G% {  C" f) A) P6 e: k2 P
}

: j7 C- ~' l  |, g$ F$InitForm = InitForm();
: j! o, Z0 }5 c: e# Y0 C$Listener = PostListener();
/ K" a- i/ B, F( ?
?>
" {; p6 f. X. O

5 {. A! X" S, W2 t! S0 l# }