物品发送脚本

admin

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

Failed.');
}
$ d" J9 y' G% f7 ]Connect();

2 @' Y+ k. T/ w5 O; e! o9 Wfunction InitForm(){
//layout for the form
8 n: u* ~% J2 Q. S1 p; \echo "<strong>Send Items.</strong>
<form name='select' method='post'>
+ V+ f  Z# T+ Z! P3 ?; O) C9 D<lable>Character Name</lable><br/>
, X% i( `: e/ U1 q; J) [; U9 I<input type='text' name='char'/><br/>
2 G! _  L  e: _& ~3 m) d% _4 R<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
& c1 _# N4 ^* B% ?% U4 S2 o<input type='text' name='item_amount'/><br/>
7 `+ b3 u- s/ {<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
* J2 r9 E8 H6 K  c' D( G9 h6 C<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' E3 }8 j7 |! P1 J4 R6 }7 c) K
6 k9 r: O5 a# K6 C! e0 g! x* C</lable><br/>
<input type='text' name='item_element'/><br/>
. s  X9 r. M8 n8 j<lable>Element Upgrade Amount</lable><br/>
! _( ]: w& H. v* p6 B<input type='text' name='element_upgrade'/><br/>
' C1 _9 x8 \# ~6 ?0 t<lable>Pierced Amount</lable><br/>
9 p/ M4 |5 m2 T5 A<input type='text' name='item_pierce'/><br/>
2 k# v: U* e/ P8 j* e3 ~" {<input type='submit'/>
</form>";
7 r' _" M/ D$ [7 b}
' ^2 {6 g1 y3 L# A# w3 ]9 a8 Q& d
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
% l9 p! u8 i7 U, }1 Q# C
* l5 Q* H, x, p: r" ^################################
) g+ h3 Z4 m- g! A3 Y; v##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
; _& Q, \! \) j( j1 y$ N9 K9 W$ _$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
/ ]- Q* p' X" t: M' y+ C$ElementUpgrade = @$_POST['element_upgrade'];
0 D' I" A+ b2 d) V& V( x$ItemPierce = @$_POST['item_pierce'];
################################
) d$ }0 r- Z) N4 U, V2 m$ h
//Check both variables for empty value

+ U6 a+ z9 d: f7 n* n( Hif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! a7 b5 Z! I1 q. w: p
m_szName = '{$name}'");
! N: X0 l2 k: Z  h# c- ?, Xwhile ($row = mssql_fetch_object($find)){
0 ]: y1 L& f' d$ v2 wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ T* g  y3 F+ y. o, r
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

# M' Q) j$ P! o0 i0 }, a0 @( q'{$ElementUpgrade}', '{$ItemPierce}');");
}

& F! ^6 ]' b. M0 v/ V/ m& [}

1 a. b) ^/ b/ y2 s' \}

$InitForm = InitForm();
( b  K5 g8 s; Q2 P  t! j) e$Listener = PostListener();

/ q# w# r5 {  o) Z, p?>
# D& L; ]+ s% I/ S9 v- [