物品发送脚本

admin

<?php
function Connect () {
* t5 Y% f- ?# r- b4 K/ {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 J* }1 Q7 g# ]& ]
; a& T9 ^6 `! ?$ o$ e. aFailed.');
  F. r# S6 c) B" O}
$ p6 ~4 V' w" p2 AConnect();
; t  o' ~' L) |  ^$ @) E
$ f' b" K* _, b' }0 I5 Hfunction InitForm(){
//layout for the form
% t: v/ d* x' ?" b) z8 Gecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
8 D5 f' g" D# @7 c! X3 B9 G<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
6 i# B9 g0 [! L, C1 ^  p4 B# [' G<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
& \5 j) t& E" N- |0 f<input type='text' name='item_amount'/><br/>
  s8 ^5 O9 n$ P  D+ I( z" x<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
& ^5 p; y3 [' [7 p% f4 l7 M# ]" e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 M' t6 w+ }5 v3 Y3 e
. `# P3 i9 [9 Y) G</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
6 {( q( L& J0 U% A. x" x& V6 Y9 Y<input type='text' name='element_upgrade'/><br/>
, s' J, o/ M$ W# _<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
0 y( b. Q& J3 }4 F& B: ~& d<input type='submit'/>
* s& ?% F( f: f& Y! Y" e</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

. }1 G0 e. Y6 k1 ]################################
. s* [! W9 U4 v2 {##### Connection and Post ######
( D0 l, d8 v  H$ `' j& `% C################################
7 G, {9 F" T; n" K$ ~4 [' c. ?4 t$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
  C4 W  [; ~7 w$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
8 q7 M) H. T9 O7 d8 u1 g- c6 H4 E################################

: Q# G" s1 m/ t* T. F2 B2 l: N//Check both variables for empty value
% E% K8 i, n6 B% R' K' |
# B/ _, C- S+ F9 Q3 {2 I/ @! ?if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) K5 l) E1 j" P9 `$ _6 ~  g! \
m_szName = '{$name}'");
# z6 D) \& Y4 ^% E/ Cwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  y/ \9 s% S! Y4 g/ `& p, b5 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 \9 A! d5 O% M
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ v* T; t* b+ O; _) e* t3 N% N
'{$ElementUpgrade}', '{$ItemPierce}');");
}

9 s8 L: b0 h' t! X6 b}

5 Z) L; `, M& ~, m}

$ r1 h0 H/ C# ~5 X! ]$InitForm = InitForm();
# I) f9 n& I. I' G$Listener = PostListener();

4 f8 F. o3 T. H+ R/ u9 P6 i  m6 O?>
4 z) b! l( ?# ~$ k# c4 m5 F
" O# J6 }: {; k* Y
+ G0 i! j: H% _