物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( ~$ H/ G( E$ v: @8 D6 S& F& S' b
Failed.');
0 ]# L% {" K) b  T+ X  U# f( X}
$ Q8 V1 t- i8 K. }+ Z9 M8 q6 sConnect();

% W3 y) |+ F# ]( Z5 `- g- vfunction 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/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
1 ]0 o0 B. H' r<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
5 b. a/ ?8 H  T: F! ^<lable>Item Upgrade Amount</lable><br/>
2 z: m0 [( G8 ^' L. [7 D- X<input type='text' name='item_upgrade'/><br/>
' ?3 t$ g8 g" j' j5 Y<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; j9 y* v3 D2 Q+ G
% k2 u1 a$ [1 A1 D2 r8 C</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
, j' ~# @; \  \- p* A<input type='text' name='element_upgrade'/><br/>
/ i0 [9 L6 {1 d& w) g- C! V9 X<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
5 B; c* ^9 ]' _( C4 s+ S</form>";
% q8 m: O4 r+ T$ C+ Q: g  r& T/ l4 C}

function PostListener (){
, s  K% c5 Y$ Q7 s5 f% o7 n//Add more post variables if needed and add them to initform() function aswell
3 b) M; k1 X0 {! T" Z0 o# `( o9 Y
################################
9 H2 q/ A6 O1 g. D$ v* o) o, c##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
& Y; H1 F6 f9 O! t5 Y% `% t/ [$ItemAmount = @$_POST['item_amount'];
0 }0 r5 N3 P  q" \) T$ItemId = @$_POST['item_id'];
: t7 G$ ~8 X% }; i/ }5 p$ItemUpgrade = @$_POST['item_upgrade'];
2 f, F' P3 i- |4 _$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

" n2 O9 ?9 N5 y, L8 f6 S9 N1 j1 h+ y$ y//Check both variables for empty value
- ~6 J. s2 ~' i" m/ u3 F$ X5 q
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, j( J5 p* ~- x' [m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 ]4 ~4 I7 a: l5 C8 ]% L% o$ C$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
4 d& Q% e6 L% J) q% m) W
0 n6 [' c' L1 Q; W+ T- I* v[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 o) J7 Z( u- d6 f* M# r
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 \+ R, E6 _/ V- _) k
" B7 y4 h% \2 r. o8 k; _' o" q  i: o'{$ElementUpgrade}', '{$ItemPierce}');");
/ ^) g2 L6 b' S}

}

: ?# @% O* t4 L+ s' m" ^6 z- t}

9 X  a# d4 K9 k0 S: }; a; ]1 k$InitForm = InitForm();
9 }6 B7 Z# K. Z+ u$Listener = PostListener();
3 K; b  ^! `  _( {7 _- t/ e4 z
# H9 Q0 i( B( u?>
2 r8 l# \2 G  {
# y" n7 x  y; R5 E9 n: s  ?