物品发送脚本

admin

<?php
' a' M' e7 r. jfunction Connect () {
2 L+ @' m' m. _8 pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
6 s. ?+ B4 k, ^4 x# c; IConnect();
6 a& t+ W& c4 O- k2 j
! k/ L- y; m0 l; A4 s2 n  pfunction InitForm(){
) j6 G: a3 }& a+ t) ~+ |//layout for the form
3 Z; ^  m0 ~6 C( yecho "<strong>Send Items.</strong>
; k! ~% ]& U$ m% }' |7 k, c<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/>
8 ]5 C( x0 Q1 m7 \3 m2 k+ v. D( D<input type='text' name='item_name'/><br/>
5 [) `; W) I& t5 P5 Q  j* l<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
7 _% i7 Z8 ?8 c4 S) p<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 `) k6 U3 \8 \$ L% _$ |) ?
/ h/ `' J- t6 Q6 m. y9 t% ~</lable><br/>
# q6 p" R+ \6 ~) W<input type='text' name='item_element'/><br/>
  w/ b4 m+ ^- ~! e4 C: q1 x<lable>Element Upgrade Amount</lable><br/>
2 a/ }: g- `# d% ^& \9 L7 g6 n<input type='text' name='element_upgrade'/><br/>
2 ]( e& x% R' @& X# L<lable>Pierced Amount</lable><br/>
5 P. c* r2 ^! O<input type='text' name='item_pierce'/><br/>
+ x$ o  C. J1 ~) o# i<input type='submit'/>
" ]( W0 A: B' N& w, e</form>";
}

5 E5 Q+ B6 D0 A* |, hfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
3 L7 D3 W0 v5 @9 F" O! k$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
: ?4 A, v3 a! [/ X; S$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
" d8 t8 }! b& W& t( d! z' X9 r$ItemUpgrade = @$_POST['item_upgrade'];
/ k5 c* `, S' T. H- y' Q$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

/ B: O) G5 z6 r0 o  s, T6 b//Check both variables for empty value

  q. c4 e1 Y$ o9 }1 qif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
  t1 p) X( W! d% H
m_szName = '{$name}'");
+ a- B6 t+ N8 S, cwhile ($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],
+ H8 P8 [3 ~/ f+ f) I/ @2 M1 J( s" h
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 V* ^! }% z9 L$ V' h8 ^
% L: V% f4 ^% h1 W# K" ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 D$ Q. c, |; U' T) A8 R
5 \' f7 A% d8 {9 e0 U' |'{$ElementUpgrade}', '{$ItemPierce}');");
}
: \3 X/ I# O' O9 v
}
" c" o: D. w% N
}
* j  @8 o6 x( [" o
$InitForm = InitForm();
$Listener = PostListener();
9 z5 C0 P3 ?0 b* n; K
?>
! [' x9 x7 ^! W( p# M. g
) }* i8 b% M& j8 f9 l