物品发送脚本

admin

<?php
; |' }# y* A. E. M5 a' R3 p- _function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

: c, I2 v$ L4 C6 X8 {# @: m' m  V5 ZFailed.');
" J# ]" T! D! L}
9 ~& T" b0 A/ E. O4 V( M! tConnect();
2 x3 H4 B  R. }& c9 I9 ~
5 w. G  _5 m8 ?; |/ [function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
; i$ `  ~( y; W& U4 X) D! Y# }5 _<lable>Character Name</lable><br/>
8 S0 k9 C3 {, Z- s  P, e, @<input type='text' name='char'/><br/>
2 T5 t+ Z- @" ]0 ~3 l4 Q6 E<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 L* Q/ J. z, w<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
' N8 {6 J& T( G8 ?0 T<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 b  K; k+ q2 x' Z. r" o! f
% z) Y+ F  U- X( J: N) Y6 @</lable><br/>
! n# Y- k- M3 H, @<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
* E( v2 e" H% i; O' q2 l! B<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
$ z, T! f0 s; i8 W+ s; L<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
& {5 F5 X4 l9 f: Y; C( w; W* \3 k8 f}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

0 \! H7 ]* ?1 F. a/ e) f################################
- _; E& A3 M8 h# |4 U##### Connection and Post ######
################################
$name = @$_POST['char'];
- i. c6 V/ R) c; \$ItemName = @$_POST['item_name'];
. y: v! W; V1 Q! f$ i* _$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
' x) M. ?9 d2 D" n& f2 q8 U$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
2 A' Q" w0 l7 |$ItemPierce = @$_POST['item_pierce'];
/ P5 i# @( k7 w4 i2 _$ t################################
& P8 ]5 y. _3 E
//Check both variables for empty value
+ o/ U" b  k1 r/ r6 V3 g
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, h& K+ `9 P$ M' K5 _$ I4 dm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
5 L' M& d7 h& Vecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

0 G& b6 J) N6 c/ J& O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ N: b) {' O4 O0 U3 a  V
# j& p3 P: @% m' u4 z[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ B! ]# w0 o& z5 l- c0 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" \4 k1 O( t3 |: v
'{$ElementUpgrade}', '{$ItemPierce}');");
+ ^8 k0 w4 }: S7 B& y. R4 S7 w}
: w8 y; X$ e$ m/ u) }
}

}
+ F( l7 U. N) P; V* ?7 ~
$InitForm = InitForm();
" o, U- O9 o8 t# E  s9 O4 A$Listener = PostListener();
% b1 ?- q1 q$ q6 U
?>
! C7 r: m- ]; i  J$ R6 M. q
) ^5 [/ I. A3 C! P' c- q: e  g

' s3 V7 |7 w& n9 Y3 L: S