物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( V: @$ \) c' H7 |' R! ]7 E
Failed.');
}
( b& _2 y7 u, pConnect();

% X  D$ b* Z# t) d7 I! qfunction InitForm(){
3 h5 q4 J' c; |4 t3 g5 d//layout for the form
" i8 s. i. f* `8 t) i7 G$ K8 W4 jecho "<strong>Send Items.</strong>
<form name='select' method='post'>
  E- d! m+ k# Q<lable>Character Name</lable><br/>
  f1 ~# S4 ^- m2 L; y<input type='text' name='char'/><br/>
) v6 `( x, \. v% w<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/>
' L' v+ P5 C# M<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
. f  V8 p- \& f0 C$ U" Q9 f<input type='text' name='item_upgrade'/><br/>
5 W) H' |* N' e  s<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 Q# T, W& A) A" ~* l+ x4 E
& u) o6 j6 X5 B- p- [. \; |</lable><br/>
2 o0 B) f7 v  W8 D7 U# m<input type='text' name='item_element'/><br/>
& |0 X0 @4 S; H; l# k) u<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
  [- C) A5 x0 q0 V& x+ n<input type='text' name='item_pierce'/><br/>
, ~: K' ]: P$ ~/ g) N4 k<input type='submit'/>
</form>";
/ |" v8 r- B# m}

5 p4 ]! |9 C- ]* C& D4 ]* Rfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

" _. |' v) m- {" ?: A################################
##### Connection and Post ######
8 [/ H8 L5 j% o4 ^0 ^################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
- r- m/ F' y6 q$ItemAmount = @$_POST['item_amount'];
9 _& m; N* c" j& \& x* I$ItemId = @$_POST['item_id'];
+ z. m5 [' e6 K! a5 T$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
8 w9 ~* x* H) q( H- |4 M$ElementUpgrade = @$_POST['element_upgrade'];
3 z+ b) `9 F/ p" \$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
/ {+ Q/ c# x  E
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, i/ ^. ]& a) n
. q# p' J9 W) ?; b/ Z; C8 im_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
5 t) H' e0 R& [$ f# y  y  \( t3 qecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( z$ M5 Y1 }; c7 f7 ?
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# U# V4 f& P) g# E, U, j: I
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

2 ~/ Z8 \4 T0 W# @% ?7 `  N'{$ElementUpgrade}', '{$ItemPierce}');");
}

9 W* a$ f! u( h6 R}

}
2 `& b- m/ {1 |  J  T5 I6 |, C; t
$InitForm = InitForm();
" i, Z7 O) M  y$Listener = PostListener();

?>
; v* r; P  E/ h6 {/ ~
8 ]- z+ J. d& M: o
, a8 [: \" D9 n$ i" l! R

" S# t) k) z4 _. P! ^