物品发送脚本

admin

<?php
; |" {( X/ u& d" H. v7 b9 \function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" D' ]( K- z2 ^
Failed.');
# s% Q) W* }* g; b  u" H* J}
) {! y5 U; m  X! ~( gConnect();

. d9 `  o( B$ Y5 mfunction InitForm(){
# @% ^  A0 W8 n6 h//layout for the form
( Y9 G' a$ y' P7 k( N& w& _5 _echo "<strong>Send Items.</strong>
" H4 _" J; d& e4 w* d7 v<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/>
- c7 O, v" I$ f  n/ Y<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
6 W1 V8 b  U7 g" x<input type='text' name='item_amount'/><br/>
2 J4 A: Y- T$ A; p0 R& R; X/ M<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.)
, R# T. w1 g( C5 C0 \5 ^- G. Q. r. M
</lable><br/>
. t+ L0 c" l4 S' o+ t4 P* O4 }<input type='text' name='item_element'/><br/>
! @9 i+ B; p; x* [5 X- Z# l<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
9 D2 H* R5 F2 Z' S" {7 z  v<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
* ?! A1 u  R& r, ]" P}
; n1 u5 G0 @* E, Y, k
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

. P$ m1 c1 {7 V, b# t' X################################
##### Connection and Post ######
+ ~6 Y. M$ h) ]! c4 w, X################################
9 ]: P6 b, p: p1 N$ u1 N: L$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
. E9 {1 K0 B% p5 ?4 P+ Z; X5 r$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
- }. U8 Y5 `/ [* {$ItemPierce = @$_POST['item_pierce'];
################################
: a- N3 x1 u% B; s8 O
//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! a# Y4 Q( v& j# j( M
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, U8 f3 h+ m4 X: p, ^. D  m$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. n7 j0 a8 n& W' K) ?; \
: t8 h' y1 ~5 r" [! c[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}',
+ z$ M4 q. s4 |+ q
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

  M0 R/ g$ U+ ~, c. @* ^}
) b3 ~+ q, F8 k( X
. P' [, o% A" W/ m7 W2 Z9 ~3 B8 p$InitForm = InitForm();
: \* J0 O: o+ ]- |# z' J3 h0 t/ F$Listener = PostListener();

& i: }3 W4 u) }1 E/ u& v9 \  ~?>



+ C. I/ s4 b2 n
; ?$ f$ |/ Y4 |