物品发送脚本

admin

<?php
! H  ]$ J, l: ufunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, Q$ r/ v) O* t* k- ~. e
Failed.');
* _3 A% j' a$ X0 ~) O; e}
, ^( l1 `" x9 w! d1 k4 |+ d# LConnect();
, s8 I. ]5 T) ~* h7 u  y
function InitForm(){
, [. V# @/ U0 @3 t//layout for the form
echo "<strong>Send Items.</strong>
1 t! ^8 c( g3 E  U5 [<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/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
9 ~; d& W6 \  z* _1 h<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

% _5 a' @! e) @9 O8 n, J</lable><br/>
4 x6 l0 f6 G1 Q3 N3 E9 J& b' `( `<input type='text' name='item_element'/><br/>
* s* m" v2 L8 M+ F% v4 L) ?<lable>Element Upgrade Amount</lable><br/>
1 K" u. }8 W/ Y/ |. L! a3 h<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
4 S+ r2 L) x6 X<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
* m% b+ V( |2 z5 H( X9 O</form>";
& D8 D' L0 v1 d7 z- Y; f8 G}
! W6 z  L; D- F
function PostListener (){
) `( m& i; }, P//Add more post variables if needed and add them to initform() function aswell
. ^8 V; x) T. {  n+ g+ n
################################
##### Connection and Post ######
/ r% r" |2 K! h& K5 f2 l################################
4 s: g1 ?. S' b* ?; Q: U$name = @$_POST['char'];
/ b) H6 _3 s6 A) k% Z$ItemName = @$_POST['item_name'];
% r' G! A6 L7 `$ItemAmount = @$_POST['item_amount'];
( D! i2 ^  x- I" q; @$ItemId = @$_POST['item_id'];
' H( F- P* y+ ?) f$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
. f+ x, S; y( K/ o& \. J
//Check both variables for empty value
% |% ^/ ~- D9 p( J0 h  m5 a" F5 ?
" v( ^6 X! k# }! `# l6 Qif (!empty($_POST['char'])){
; R% U8 v: W: O6 F( v$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& x7 V" O0 F" C* n8 Y0 D* }0 c
m_szName = '{$name}'");
9 e9 x5 j7 h7 Iwhile ($row = mssql_fetch_object($find)){
2 L  X9 H$ F  G* f4 t. {- Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- E3 }6 @. c5 k/ P( z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

. o) W' w2 ]1 U6 R: ]& p[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( D5 G+ `. [8 {, H# z/ kN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
/ O" e/ W. n/ p2 X( r" }
0 |2 A' c& V3 P}

& Q1 j& e, ^8 J5 I}
2 {8 ~# f+ Q0 L8 m4 \; a
9 r1 }8 \+ x& v4 ^& s" J$InitForm = InitForm();
- M" ~: N9 z# V& N$Listener = PostListener();

?>




1 o* ~* H. Q* D  w