物品发送脚本

admin

<?php
# i- ~" k  C+ M/ y' |9 N& ^function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 F! S9 B, [5 H/ f3 B- E, ?
Failed.');
}
7 f- e6 G: V: eConnect();

( X; \7 k/ S$ Ffunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
! T$ K) ?* D  n7 T" z' `0 s<form name='select' method='post'>
3 F& b5 g* E  N: j' F) k  I<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/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
& ]# i5 E* J( J  X- n& L<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
" x1 t5 N) \/ z<input type='text' name='item_element'/><br/>
! V/ E0 ~8 R! ?2 s8 l<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( G$ f& [; L1 Y<input type='text' name='item_pierce'/><br/>
# P& ~1 v5 u& H8 f& Y<input type='submit'/>
</form>";
}

$ x1 S/ J/ f2 [* ?# W& jfunction PostListener (){
) n  Q6 U. s: y2 t1 f$ x//Add more post variables if needed and add them to initform() function aswell
9 u) ?3 Q6 e) [: Q- g3 o( J
5 T) r  A! b5 |0 P1 Q+ f% Y################################
/ e+ l0 B6 x, \$ J1 B- M- Q##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
" V& O6 f5 D# b0 V9 o$ k$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
! x6 s* u8 d6 K. i/ O$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
0 \+ U$ ]. {3 g- G- h################################
$ C8 F  L; P4 v% T& t+ w
( O, g7 c4 F+ V- ?8 F' f8 H: y//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ L: b, s7 w4 v7 G3 n( b
, V6 `- _6 n3 I& k. ym_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
  R1 {5 y. A, ?0 M4 l" i) decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 E  U* e/ s. f9 t, X$ T$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 t: I/ K/ P  b! U5 i
8 M) U( I& q7 t; b! m4 A, B+ J[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% A% C+ {* R. b' b
" }) B" C7 \( K( t9 @. g  ~; \" L8 o[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ G- j, T3 I8 w8 \1 b. i/ F
1 i- `: j9 s- `4 |! ~! {'{$ElementUpgrade}', '{$ItemPierce}');");
; f. R" i. z( \' p& V' h}
6 V/ ?7 |+ _: t9 J6 v
}

* f6 X5 N" f5 u$ _- L' S; j2 s}

+ A, P9 x; _, I' \0 s$InitForm = InitForm();
$Listener = PostListener();

?>

4 ]* s: y/ X- X8 ?( w


0 c2 P, Z' ]" x