物品发送脚本

admin

<?php
function Connect () {
6 J: a3 _7 g* R, m9 X6 K  Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# Z- o5 K/ n- u' y' n( L' ~
Failed.');
}
9 z' X; @( q3 qConnect();
1 G' K+ c" O  ]- I+ i: W+ y4 H
function InitForm(){
2 u0 a2 [/ _& m2 U//layout for the form
% P6 [# F- j5 D$ b1 @; iecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
$ M% ~$ {6 \% Z<input type='text' name='char'/><br/>
/ Q6 K% A0 v6 Q' y" W3 U8 o: o/ g<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ A2 V4 Z9 o' W6 `% z7 K9 ]. N<input type='text' name='item_name'/><br/>
; V3 {- I. Z: O6 ^! G  H<lable>Item Amount</lable><br/>
9 _0 ~/ q7 l* J: B<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
9 \0 m# M) w) G<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. P/ W6 n" V. c- e) \
</lable><br/>
8 r) y! O9 M( C<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
" j$ O4 b0 t/ }$ z- H- m<input type='text' name='element_upgrade'/><br/>
0 l: F1 s% [+ _% u: P6 S. s; o/ t! t* g<lable>Pierced Amount</lable><br/>
/ ^5 I4 `/ \+ _7 d- c8 ^<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
% U. c( h( F! R: R) {1 d</form>";
}
1 M. ^, K% o1 b
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

8 g7 B/ P" T3 R0 d################################
##### Connection and Post ######
- n+ L" y3 N2 G# k2 D: O################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
( b$ O# E1 r; o7 H  s9 v7 _; N$ItemAmount = @$_POST['item_amount'];
, j3 ]) U- T! {+ K' B- ]0 b% i$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
! G( A4 K, R* f$ V6 |! k$ItemPierce = @$_POST['item_pierce'];
5 x6 o& k# g+ M################################

( H5 v" X/ S; S& q" X//Check both variables for empty value
! [) b; y7 ?- w3 Z; J
0 e9 P$ y6 v4 |0 c" M8 Jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, ^) z  r: U! O
, L& t5 ~9 k7 Sm_szName = '{$name}'");
8 _- I3 e2 z; m' swhile ($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],

) W) r# ^: i4 y/ Z' `( q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 U$ J$ b* B  t, ?+ w
7 @7 l! K) j* G[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

; R2 b, s3 K% f8 [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

; P* B/ a# |: {* c'{$ElementUpgrade}', '{$ItemPierce}');");
}
3 _$ e, ^" l2 H7 C% J
# e) V3 s! R9 N0 B; @}

8 |" z) {7 U8 v0 ]6 A1 _}

$InitForm = InitForm();
$Listener = PostListener();
% O% M2 \) U$ D4 ?4 d
?>

6 r. }( f# D$ u
( a! J) `% K' t% A1 ?, A3 C

1 L" \, ~& w6 {- H+ g