物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. s8 U) G: s+ L2 C2 A
; t+ R; L, w+ a1 I4 ]& CFailed.');
}
Connect();

. l: N/ J  U- M2 F' o+ n, Wfunction InitForm(){
//layout for the form
4 w  A9 z  Z2 ?echo "<strong>Send Items.</strong>
4 e1 J% A8 n( ?& v5 j<form name='select' method='post'>
<lable>Character Name</lable><br/>
! t/ G) }1 @8 `1 W<input type='text' name='char'/><br/>
% t0 {0 P) p+ R7 t<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 K0 L8 R6 ~; ?2 L% T! g- T3 q9 P<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
8 W- x# L& ~8 k" o% b<lable>Item Upgrade Amount</lable><br/>
/ y8 z  u* Y! b/ H5 v8 Z<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

% ]1 K# P7 x  y' ~  s3 Q$ I</lable><br/>
3 F% J- p5 k4 [9 N! d3 Z3 x4 n. k9 u<input type='text' name='item_element'/><br/>
/ }) e+ e  A3 i8 S9 n& C( g<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
! ]+ M" l- \6 a+ t( C* Q" m+ v3 Z0 E<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
7 h, k8 Z. o) E8 _</form>";
* g6 O: t; [1 k" I* h- Y% z}
- N/ R! m- V1 @: m! _
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
0 t5 }1 M; h% A8 E' w##### Connection and Post ######
################################
$name = @$_POST['char'];
. k# @9 j* F' S$ItemName = @$_POST['item_name'];
  M; ?7 }* A" `2 u$ G0 H$ItemAmount = @$_POST['item_amount'];
& M1 g( z) t9 B$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
) @: F# B8 j7 ?( d% Y
# C2 v) u2 K8 b" U  n' p) A//Check both variables for empty value
) g1 J# [/ f; m* f0 H0 Z5 s
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 e  l, B+ F3 C
$ @0 y( g5 Y/ H. o, l% p" n2 F" gm_szName = '{$name}'");
7 p0 o& H( e! W$ Y) uwhile ($row = mssql_fetch_object($find)){
" k9 g( g" S2 p4 Iecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# {1 j; _  ?/ E) E( ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

  `+ ]6 L1 `3 ?; y- _. D[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

, x' U2 Z5 _/ G0 ^; v' Z'{$ElementUpgrade}', '{$ItemPierce}');");
}
: E" E% p- O, @
}
* G/ {9 Q0 S7 x* N
  B' ^# h; A$ Y/ c}
6 x  S3 A! L  O4 A
* w8 O) i- [( h# Y$InitForm = InitForm();
$Listener = PostListener();
$ z/ {: H) }9 L5 R
?>

1 o. ^1 p8 B+ a4 }+ R
$ J) N2 z( ~$ s" C+ i6 Q' T