物品发送脚本

admin

<?php
* {+ i9 }. o9 f1 Mfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% ^" w% L+ C1 m6 P( w7 s8 J7 V) k
& U6 ^9 T* X! A, IFailed.');
7 i, Y# T: g8 x3 D7 P: q}
2 [7 r0 W# k6 f) _Connect();
, h1 U" M& a% r/ }; V9 x
- ^1 S7 G; T$ M4 w) E5 [function InitForm(){
# E6 G/ Y  ]6 f* k! L5 {# j//layout for the form
( \( y% ?1 T# E( Cecho "<strong>Send Items.</strong>
<form name='select' method='post'>
! G" w# p* Q8 {' p5 ~<lable>Character Name</lable><br/>
2 U2 K. U9 F6 @5 f<input type='text' name='char'/><br/>
, p( f9 g. T% x; L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* W& ^. T! R0 m( @7 f9 R. a- F& S- {<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
% e, A* ^) q( h( @% W2 D* R: ]<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
8 }2 r0 G8 t) B<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

+ x1 o. m; n$ D! [1 r7 m</lable><br/>
<input type='text' name='item_element'/><br/>
! Z5 ^$ ^7 t% U" f# z6 Y<lable>Element Upgrade Amount</lable><br/>
5 z: F* ]! I1 Q3 n/ G6 O<input type='text' name='element_upgrade'/><br/>
% r' J+ Z- m) G+ s4 `$ v# T- m<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
% `) l) i  L) m" B2 M1 S! ?<input type='submit'/>
</form>";
}

function PostListener (){
# l# w4 A* f5 v+ @% \//Add more post variables if needed and add them to initform() function aswell

8 F$ }. ~/ I' x4 P+ f. v################################
##### Connection and Post ######
################################
. N$ G3 b+ ?) H3 {+ W$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
6 i9 }  F  W% g$ D$ItemAmount = @$_POST['item_amount'];
6 `1 p- W, Z# D6 g1 ~+ f% n( P$ItemId = @$_POST['item_id'];
! d7 L8 D7 A9 N/ p, b$ItemUpgrade = @$_POST['item_upgrade'];
$ C0 [) j1 \+ u. ?$ [$ItemElement = @$_POST['item_element'];
( d0 S% c- {# K3 L* c$ElementUpgrade = @$_POST['element_upgrade'];
& E0 L2 d3 P% [- P% F' S# E$ItemPierce = @$_POST['item_pierce'];
################################
: e* P/ u1 \9 r$ ]8 g0 U$ ^, _% h
//Check both variables for empty value
" |8 \& y; W' N0 {" v
if (!empty($_POST['char'])){
6 l! F. {8 ^* P* J2 q6 n! b$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, K1 [2 F* k# P) Sm_szName = '{$name}'");
8 e4 O# u$ D0 l& r# K  O* Gwhile ($row = mssql_fetch_object($find)){
$ U5 j2 S: O; S0 O0 T. J. k7 @echo "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],

5 Q/ S* Y2 H# e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 I' p2 p) D) f; E8 @& Q7 u
3 a- t5 \7 F! ?) uN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. c3 W, _. X: |+ ^# O
9 z5 G. f7 O2 z4 U'{$ElementUpgrade}', '{$ItemPierce}');");
8 V- G: H& N; W5 v3 ^8 B}

- f0 N  C/ L" B5 Z2 ~. d# G}
8 D# g+ g* {* [$ ^' l) n
}

$InitForm = InitForm();
/ A6 S, G* q6 t' p' N3 F$Listener = PostListener();

?>
! s) a8 O/ `2 k, c! }( X% ^1 p


% Q4 `" t0 O3 E. X5 ^' P
! x4 l7 N8 c( z5 f" m* x  W