物品发送脚本

admin

<?php
function Connect () {
& P% Y4 C: s7 lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
. S+ c1 [, E  ]3 E* nConnect();

function InitForm(){
//layout for the form
* ?/ N: C! @+ Mecho "<strong>Send Items.</strong>
) |% t* @' v" A. o<form name='select' method='post'>
/ q. r$ E3 C( C) q7 C: E. W<lable>Character Name</lable><br/>
2 w/ {2 @7 d0 V' X<input type='text' name='char'/><br/>
& A$ f% M# M0 _# j<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/>
3 c6 d3 p7 T9 o6 F5 V# X9 X<input type='text' name='item_upgrade'/><br/>
8 |0 n1 b& W/ q- ]7 ^6 A: b$ w<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
  G3 x% g* @+ z8 t# K, ~
( ]! R2 T) w" r</lable><br/>
  _" |. I4 W/ [' z/ D<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
' j% g/ y2 l: O<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
# s0 _* W+ @) ]0 F<input type='submit'/>
; h& t, g  X1 ]7 q7 e& r</form>";
}

0 m7 ^# T( g* ]0 z6 r) _5 ~& w6 }9 afunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
, ?) E: g) `. _
) |% C- J7 v: A6 i################################
8 R$ {# L* T7 r- B##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
3 b( v) k: B; ?7 E" Y4 z$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
  k1 m5 S* t6 y$ Z! A$ItemUpgrade = @$_POST['item_upgrade'];
6 Y$ u0 S3 _. z% `8 K$ G$ItemElement = @$_POST['item_element'];
+ _0 {4 c8 g8 v+ R$ElementUpgrade = @$_POST['element_upgrade'];
) n3 z  ~4 r4 ^7 i$ItemPierce = @$_POST['item_pierce'];
1 i- [$ K% Q0 x" ?$ \################################
3 h: P6 A! A  B# g9 D; Z0 @% ]
% t  T; M# M2 u1 \5 ~//Check both variables for empty value
6 f( v6 C1 Y) B
) v' y+ X$ X3 e9 F. c5 Xif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 a9 O/ k$ z9 {& U! N# ^9 a
m_szName = '{$name}'");
. o$ r0 s2 {' T8 R4 s! ?; Ywhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ y! s" E; G, A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. e* Z. U* k3 k6 e3 T4 z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

) b' H+ y% d* }. Q0 Z  k$ a$ i[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 {6 M3 g' [) v! B: Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* m3 a( M! I0 j4 J8 n+ Y
'{$ElementUpgrade}', '{$ItemPierce}');");
' n; w) O4 \7 R# @9 S) |6 v: W}

}
) Z( w  g$ ?8 n) x; Y* p. [! W
6 ?$ \' a4 f7 H* F# k+ m: p9 |}

0 F; r( W) d1 D$ r' i$InitForm = InitForm();
7 p0 ^; a( l9 K# N  k) w! {$Listener = PostListener();
- H. Z9 R, ]( |* x
; R! W8 B+ O/ V?>
& t6 G  L5 A" f. x, k& o

. c' P6 |" @8 m2 }( c/ Z

- G1 t! S/ d; `2 E8 a8 q