物品发送脚本

admin

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

Failed.');
}
& F3 J% U2 z, t2 H5 L8 D7 T4 rConnect();

# [% `, H' o1 h: W; k7 E6 \function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
6 K( b6 i3 Y6 e" Z  B<input type='text' name='char'/><br/>
: D; b/ y5 E* D( C<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" @& C1 C  U6 ^<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
; l3 [! X3 D& g<lable>Item Upgrade Amount</lable><br/>
7 [4 @0 n2 Q$ T' a+ k" U0 Q4 c, K; r<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, U1 ]0 q6 E" i, L
4 w) q# u0 B5 ]/ ?0 E* ~</lable><br/>
" y2 Q" q2 k8 v& Q" y3 M<input type='text' name='item_element'/><br/>
! h3 s% G: `* ~  S<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/>
<input type='submit'/>
</form>";
9 z/ z7 {' i7 U4 T7 P}

! u- b% I4 O# H1 Tfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
! J$ o, R: P8 c/ P. A################################
1 M" O7 z% u1 q- r/ q' K9 p: J$name = @$_POST['char'];
+ m$ I% H% o0 r* `4 t$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
0 r; t3 q& A1 V; M2 ?$ItemUpgrade = @$_POST['item_upgrade'];
0 H6 ~- k8 D4 x2 S: Y+ m$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
7 t% T1 B  s& j; R, n" K################################

( Y% ?" D* u# }: `) e+ X//Check both variables for empty value

5 s& m  F) l4 x) _4 Q4 oif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* r" O7 s: F) p, d' `" k& X" c$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& l4 A7 H7 ^2 o8 ~$ s8 H; M$ {/ x
2 I  B! `: ]! l" N7 F[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 s% m& q; m. _6 h
. |8 y* {+ f) ]$ v; m6 w, m& I'{$ElementUpgrade}', '{$ItemPierce}');");
" m9 L% X- I1 V8 O; Y0 f3 T}

}
" V2 H- H/ U- S" S/ H& u
- B4 j7 a  ~! l/ Y6 @1 _9 G0 b}
% J: T& E: k& u% H! p' `% H
$InitForm = InitForm();
  d0 P" A/ C' j: J% n) }$Listener = PostListener();

?>
: N8 h. `7 J; E$ Q% K0 O& D; n& b

! ~/ Z& e2 {& V3 n  ?5 p0 Q& V) H2 m3 W6 c
* G4 w: }# j8 G1 }- m& ]