物品发送脚本

admin

<?php
, G$ C) d! _3 C4 L6 p' b8 n. s+ `function Connect () {
0 O& I* t& Y; e& `( l% x4 y/ Smssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 Y% H) v) O7 k2 B- m
Failed.');
}
7 B/ h- `: ]/ YConnect();
/ C# e. _/ N; v+ g: N9 v3 q, v' |, C
" m& q; Y1 Q/ t, }7 `+ @6 gfunction InitForm(){
5 K# @, {2 G, I9 G//layout for the form
8 n1 w3 {) ?9 s9 i( [4 ~2 Gecho "<strong>Send Items.</strong>
* @3 ]- g/ I9 @. G2 a8 h<form name='select' method='post'>
9 B6 Q+ Y9 ]" T- u1 {<lable>Character Name</lable><br/>
8 o6 t. x+ j1 v$ c8 l% t8 C5 K  K  M<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 R& @% a  Z2 u! V5 j& [8 c<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
# _" T; ?4 r' w; j! b7 m<input type='text' name='item_amount'/><br/>
5 R' o) G& h% C% ?7 e; B: z9 @+ f<lable>Item Upgrade Amount</lable><br/>
/ ?& I. {( m* X# s; Y+ J8 L: V<input type='text' name='item_upgrade'/><br/>
) W$ x, x) P% ~8 |2 R; A. B5 v+ i/ t<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; }" a/ I* h; P! U8 r1 i* y* A
5 a/ \& J2 B5 m- |3 f5 i# q</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
7 K* s3 \3 K# |* ~, P& M5 _# H<input type='text' name='element_upgrade'/><br/>
- i+ b3 R% e/ B  i<lable>Pierced Amount</lable><br/>
* s4 i2 \) p- a# Y7 r, o<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
5 a) B7 h- }: D7 |6 V& |0 I
function PostListener (){
5 T# F, q5 G' f//Add more post variables if needed and add them to initform() function aswell

' |( j7 A, l4 D8 d! G# H3 N3 M, T################################
##### Connection and Post ######
: S& n! ~: R1 d% J. j9 R################################
- j+ W3 I7 q+ {9 ?0 q) x9 g$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
) {8 g6 |  Y/ a$ ?2 y$ `$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
. P" }8 u8 _. z/ L- g8 c$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
- A9 c: S4 r5 Y; L+ d( _$ItemPierce = @$_POST['item_pierce'];
$ T9 f/ w4 D2 \6 X* V################################
* `. y( {3 n- u- h! c
//Check both variables for empty value
' W/ e; a3 O+ Z$ C1 G, ~2 t
8 j  H/ l1 h. ~6 aif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 E( ]& A, C6 e! n
: U5 i" L/ K& x. E6 N) S- ?: bm_szName = '{$name}'");
( K$ s7 ~. t+ D- b/ F1 Vwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 b9 t6 o0 F2 X/ l+ _  b$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( {3 I: R$ u" _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

9 M: [  h- R6 `[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 V# s2 }$ ]% ], n, h0 v0 J, y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 r7 r5 {! {! u+ N  e7 ~  q$ g* }
'{$ElementUpgrade}', '{$ItemPierce}');");
2 p( e0 {- {6 _$ k# p}
% N2 G2 S( o3 Y& K
}

}
& A( I' p: u3 [% ~7 x  X
0 q2 g. l+ H0 `# T( ^& x$InitForm = InitForm();
$ C, {* E8 N5 N9 N" J4 \* l- i4 }1 s$Listener = PostListener();
$ [9 ]3 J  A8 u3 @* o9 f# ?
?>




* {+ v3 y) ?! j