物品发送脚本

admin

<?php
function Connect () {
, i5 o) j: d- v) B4 T( Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" n# [# p, D( C$ S
Failed.');
1 \3 D5 i" H4 d}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
" C% v  i2 U3 Y/ T; k<form name='select' method='post'>
<lable>Character Name</lable><br/>
+ P# O# k# t: v6 H<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/>
! U0 |, a/ e  A0 `% I( W! M4 q<lable>Item Upgrade Amount</lable><br/>
( M3 A1 @, B2 p9 h" q# N3 b( x$ ^<input type='text' name='item_upgrade'/><br/>
, M" X$ e: V/ ~, @% T$ E! y& m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; F- l2 e7 D+ f" Y6 t3 J; S& J
</lable><br/>
<input type='text' name='item_element'/><br/>
9 b$ G) x$ `' ^, q<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
+ n+ P1 A0 ^6 v<lable>Pierced Amount</lable><br/>
' a, k, L# W% L<input type='text' name='item_pierce'/><br/>
( d) d/ M# _+ k$ x- v, j" D<input type='submit'/>
& [$ C& J2 W4 y$ {</form>";
( R9 E! i% ?/ E- Q1 _. z2 }}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
. Y3 @+ N  @/ v  U+ ~/ U################################
$name = @$_POST['char'];
+ |0 u- y) N( B$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ x7 i6 H. |1 G0 b$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
4 e' P) p$ o3 J$ [! O; |# ]
5 _! g4 S( V$ g. F8 ^7 p; iif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

$ D. `6 ?* U$ m: U6 h" Y2 sm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
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],
# l& f7 [1 {: B$ I* J8 Z  p+ }
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" a$ N1 O' z, [4 O! g5 N
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, Z1 \2 N/ U3 W
'{$ElementUpgrade}', '{$ItemPierce}');");
% d! B0 P4 b% `: D0 ^3 W}
4 i, u; Q3 w* S9 O8 Q& ?9 ?
- r% f$ t; F+ ?' @" z+ H! e/ v, A$ `  i}
5 a1 p& z0 Z, P
+ ^& ]  D' t6 \% \- p3 ]}
! ^: {" d1 R2 P% s4 n# f
+ ?8 o: g- e7 E$InitForm = InitForm();
8 ?# O9 @& V; U- }; C$Listener = PostListener();
! B6 `. K  p( X* M- \! t2 U+ v, O
5 q" v( p! j6 l5 E- c?>
3 u$ c; X6 z2 \

& K3 z" z4 a( [
# S3 E7 L" T! Y$ x% I