物品发送脚本

admin

<?php
# U3 P4 ]! ?7 i8 q! ?9 t" `1 gfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( L9 N$ }9 k. U$ ?: X- u
7 N3 F0 z# o) [$ }/ _3 n) YFailed.');
}
- K4 f8 w5 a3 F% s- CConnect();
6 u2 Q3 B& F) K5 [. {: S; e
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
1 k3 @+ h1 I9 k1 v. G- S<form name='select' method='post'>
8 a5 U* W- ?. q* C  i$ `( l<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 w* w/ w4 q! P! i. t$ N# E! G$ V<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
8 j2 h( r3 F( I' |# J3 K4 s<input type='text' name='item_amount'/><br/>
4 _/ J# Q" ?9 D1 _$ k/ Z. i<lable>Item Upgrade Amount</lable><br/>
" D( R/ W7 `8 z<input type='text' name='item_upgrade'/><br/>
1 y5 B& r1 r. u& g1 H9 N4 }% ]& u) t6 U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: H* y( m) `# N) P) c- I
</lable><br/>
. d( s% P( X; j- b$ e( q<input type='text' name='item_element'/><br/>
+ I6 J7 {, }* y+ ^; d# ]" d<lable>Element Upgrade Amount</lable><br/>
0 y) l9 B( l& c8 k  E# b+ j<input type='text' name='element_upgrade'/><br/>
1 D0 I" @- v! L- @' ]<lable>Pierced Amount</lable><br/>
3 G2 s! |2 C9 M5 k" \% L7 s7 D8 ?: H<input type='text' name='item_pierce'/><br/>
. F3 Y! U6 b3 Y: v# J3 m<input type='submit'/>
1 p# A& ]0 k* X- E; I% I$ ?</form>";
}

, o) b, Y( f/ E( tfunction PostListener (){
0 x3 k! Y8 P2 \7 g. w- D//Add more post variables if needed and add them to initform() function aswell
+ B' {( Z- a: c! X' m5 P' |
! d3 S" N9 z9 @! ^################################
' `5 C  f" w2 P( B##### Connection and Post ######
' J' T3 l+ [8 _5 p! g5 u3 M0 D################################
: U% O5 W( Q7 q; z$name = @$_POST['char'];
6 k6 r2 v/ ]3 k. r" X& R7 m$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
( _! s+ w! L. P. e$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
7 v6 E. }, K. o# F# |- |$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
$ O, a/ d4 i' J################################

. a5 B& x7 }2 \//Check both variables for empty value
6 i/ ^& E- T, X! z: Y8 u5 R
if (!empty($_POST['char'])){
8 R6 B& o" o- l0 T  Y: P2 A7 r  l$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- c: P# x' A  Q
m_szName = '{$name}'");
0 J1 ?0 |' e8 P1 Zwhile ($row = mssql_fetch_object($find)){
2 b5 [# Z& K0 W$ S* `' @- |9 Zecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: a& o) n' Y3 P$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

5 ~8 _' `: Z; t$ l% o: k- P  `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

! W" k+ G& |3 A/ F' }; a[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

: M) r8 m' ]& [* O* {, SN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 U6 G3 ~5 y4 b; k+ p
'{$ElementUpgrade}', '{$ItemPierce}');");
) f5 `) K% b* @" U. i}
$ E8 T$ a  s- _* g( f
}

}
: X3 |; n3 W+ u8 A! A2 v$ w" j8 S: C
$InitForm = InitForm();
$Listener = PostListener();
+ x4 P$ F. c8 N5 E
?>

6 @* t. `- n' S# e
6 M  y8 J8 e+ ~
* x% B+ q+ D7 s& k- }