物品发送脚本

admin

<?php
! }* I& o  @4 j! Yfunction Connect () {
, _0 ~2 C$ I" d. Z0 d+ h  Imssql_connect('Server','UserName','Password') or die('Error: Connection to DB

. S1 c- _! i# U! v; D7 EFailed.');
7 @- ^1 E9 ^1 Y- }6 H( a% H}
4 T4 I1 I9 N  T1 ?  ?Connect();
- X4 r6 U9 y. v9 N- {
4 S6 G6 E7 l! G" X& [function InitForm(){
7 y/ w# R9 q3 \6 a//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
% W( S- h- ]: G) n% E4 f<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& p4 |4 x8 V- g4 w6 ?<input type='text' name='item_name'/><br/>
7 c- D: h7 B, s% P& Y- `& j<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
% y. R4 P" V7 Y2 _( H/ Q+ K0 j<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ u& x) z9 d% w/ j<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# G  E) B7 n: [
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
# }; I4 q- e) D<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
4 f# y2 o% H$ v! v4 {! o; A<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
. G! d+ M) ^  ^! \: G" w</form>";
}
+ z/ ]% b5 p! `6 Z- b" k! N0 `
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
, d1 X# R0 M% Y8 ^& |6 y+ K
8 s, X+ ?/ G1 D, C! G0 m6 n################################
: A9 i+ I: ~4 e2 ?##### Connection and Post ######
1 R7 K- k# l6 }################################
9 x" o- z7 {0 h7 m1 M6 N$ T' s5 ^$name = @$_POST['char'];
( l/ E/ @5 @- s$ItemName = @$_POST['item_name'];
" H4 T6 S7 o' U9 v8 s+ U$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
7 }0 ^0 \% P  S6 }! o& x$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
% ]+ {5 p+ }/ |2 e" O$ItemPierce = @$_POST['item_pierce'];
" V0 J* r* `5 U- [* v################################
( Q- G: t; Y5 p
) G1 ?. S! I3 Y3 d( l1 N1 U1 x//Check both variables for empty value
  X; C% w4 y3 B3 P2 d
if (!empty($_POST['char'])){
, I- B* K8 c% r/ ]; ?$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 R( i# w, n& E, W1 N; y
) i% `8 |& |. e, e$ I! im_szName = '{$name}'");
( Y/ G" Q2 Y  y# Y: j3 V6 Pwhile ($row = mssql_fetch_object($find)){
% C# j. R: I. ]# [- R  becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: q8 F" L+ g  v; M7 w
" q$ G9 ]6 q0 O  T, w) b# \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% R; T! Z8 ?& U
  T& ?, t! m; E6 |4 q$ aN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 C5 e2 @' G5 H
- L9 L) e8 b( f. K) \'{$ElementUpgrade}', '{$ItemPierce}');");
0 k* p4 W7 ?  [! O& K# L}
, U( R6 ~/ j2 t0 n9 |
' Q1 h$ h7 k$ Y7 n" `}
  M  R3 j+ p: V& j1 P
}
5 O- C/ l1 ^0 T! \
$InitForm = InitForm();
$Listener = PostListener();
3 n9 [, V5 t  C; _! D: z
?>
) v% S+ j8 R& w( I6 E
: h0 j+ `3 f' {& E. f7 r( e' l% H, N" a