物品发送脚本

admin

<?php
function Connect () {
& b, W5 i+ u7 A4 [' u1 {* Imssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: N. a2 y$ J% p2 [6 }3 i0 f1 _
& x8 F: P& A; D+ V) k0 P' IFailed.');
}
0 I5 I: T+ k1 Z- M3 i# ?: k8 }. }/ m* VConnect();

1 c( V7 u) a2 g* G7 T* Xfunction InitForm(){
//layout for the form
8 Z: S# }( l& f1 a, m0 wecho "<strong>Send Items.</strong>
& w, R1 ]8 {: u7 X: N" P2 D& T+ t<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/>
5 J+ C5 M" i+ k7 N<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
1 ^, X0 R+ [) l<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
4 \" D# D( ~# W5 g/ U0 B+ m<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
  L9 e9 b8 m/ ^' G+ x: u<lable>Element Upgrade Amount</lable><br/>
3 y) j( ~, q$ E. i<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
% ]) ~) q! x: B, m0 O) c( `2 L
function PostListener (){
/ ~  n9 Q" Y+ x5 L) }6 s9 T//Add more post variables if needed and add them to initform() function aswell
; z8 a* a2 V) _3 W- ]0 N
################################
##### Connection and Post ######
% @' O) Z! I7 i. V" ~/ u# g################################
3 n6 _: B0 f" C$ ^! d% S$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 x# ~7 U7 Z2 f8 g) C$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
" j! w: p6 \& U2 [$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
" e' A( K! u3 J; o# p################################

" q2 |7 Q+ G* X9 b//Check both variables for empty value
+ C6 F0 d8 G: _
$ G, i1 X; T' B; v& l8 v+ s8 Jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! v) K* m1 Y9 X7 F6 j6 c
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
& Q4 v8 A6 `: X; |$ }% x4 Hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( }3 k( u( o- S( `6 Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) o2 w7 S- J3 j8 ^) t6 C0 g
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

  Q6 a: W* l( |- Q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

6 B9 H. H/ i; Q7 T9 \1 T0 C8 s' o8 BN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 ~2 q. t7 f$ S7 V  J
'{$ElementUpgrade}', '{$ItemPierce}');");
0 P7 R& T+ e6 ]( E3 e}

}

. R+ q% r2 Q7 j( @, k}

$InitForm = InitForm();
. ?% M( C# g" @8 e9 ?) _$Listener = PostListener();

1 k  v, _% {: c0 Q% k?>
5 m1 n3 N: H# F6 |1 K7 K9 d$ E

/ a6 ]- K& K5 U

8 S# U8 _( b# \# x2 z/ X