物品发送脚本

admin

<?php
" Q( `& b% w+ h: V. {+ ?1 Y& `function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

1 _0 r3 ^' U; q+ HFailed.');
% t7 f+ l6 U# d# U% D# x}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
0 f  W. l1 g1 n' P' t4 t+ d<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/>
% X- ?. c, {1 A1 n<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. \0 g7 F" A5 S1 F5 o
9 z9 L( w. g. F4 B4 i; q7 R</lable><br/>
' D+ D7 Y6 Z; V$ h6 d9 [2 t<input type='text' name='item_element'/><br/>
7 }& |  R1 R( c( z# j+ E% S0 b1 Q<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
* D8 o' i8 @3 d; m" B) I<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
0 V8 }2 b7 x% ?" }' L</form>";
; O" K7 M, [8 O' E}

+ z4 a' F: [7 I$ E) ~  vfunction PostListener (){
$ J- Q. C% n3 W1 |3 m( W//Add more post variables if needed and add them to initform() function aswell

+ B8 q  s* V* ?  ]: p################################
, s9 H3 M- a: @$ d* I6 {4 c##### Connection and Post ######
################################
/ n( W  G* ]* i5 p1 M. h$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
* F. M' @/ J% N/ X9 E$ItemAmount = @$_POST['item_amount'];
1 `. P! x6 Z2 Q( X2 j1 Z- h$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
3 ]1 D1 x9 Z( Y0 b, k3 L$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
8 s& P' B8 A& z5 ^################################
- ^, z( b1 i& B2 x) M
//Check both variables for empty value
0 t' w! s  w! }7 k
6 q- b' A9 G0 w/ G) K1 {) Xif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. k  \$ d4 I; h0 h9 j' z
8 P3 u/ b: o/ s: r$ D. xm_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],
0 i) Q! E" d+ T: D
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& p: V" ~+ P; u; k# b
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

) [1 i9 p$ U/ K8 ]! I: ?1 YN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

7 u# d& u3 T( q. L' e, Y" n'{$ElementUpgrade}', '{$ItemPierce}');");
}
+ ?3 s3 i& n" [9 A
}

# ]7 x* I- l- r- z% l}

$InitForm = InitForm();
$Listener = PostListener();
0 u/ B) |: r; ]+ S- V6 C# f
?>

% L9 L& V8 c* N: X5 q# Z7 k6 d