物品发送脚本

admin

<?php
6 J1 D, `8 J& L' `function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 i# `+ I; v9 E
Failed.');
}
- s* a5 R* u0 Q1 ]' CConnect();

7 V% ~9 W: S; I+ Ffunction InitForm(){
//layout for the form
0 Z6 D$ G% ?3 }/ {" Y% [  Fecho "<strong>Send Items.</strong>
<form name='select' method='post'>
% Z% }: T) a- j& _<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
' P9 a& A. ^) D- X<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
$ }! g9 o/ ?9 g: l+ m3 I2 t$ o<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
: e% l, E1 I% t6 F<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ ?8 H7 i% w' C2 v8 P( v<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
7 A7 V2 Z( ~5 j) X+ k<input type='text' name='item_element'/><br/>
0 I/ w& r+ r' S5 f0 Q; W<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
' R# y* c0 h. a& |" T4 `2 q<input type='text' name='item_pierce'/><br/>
9 w3 V, C+ h& a' y6 S<input type='submit'/>
& |6 l2 R% G5 ~  Y/ o</form>";
3 S1 y4 H# N1 B1 M}
. Z7 N4 t& L9 E! c! @' l  B
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
' T; c+ C, n6 N& t; j7 w% c* J
0 |5 `8 C- ]4 |, k9 I+ m  X################################
# G8 [: X) g  ?##### Connection and Post ######
: Z3 s7 k# Y' n5 @################################
/ b5 M" @1 N- {" h; M$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
& I: I' H1 i! `5 V) F$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
, s/ R+ Y4 G* k: s  B$ i
//Check both variables for empty value
* E! }" G- R- ~# a/ b
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
6 ~+ v8 m5 l" Uwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 T% S( o4 G" ?9 Y5 E
6 |! |6 J: i, S- H! G, F) z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 Z3 D3 `; q. x; d+ Q4 t8 I
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 _8 D+ H% t% `; ~5 N" L! q
3 a4 I2 G2 M, CN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

+ a3 u( L, E, C$ s'{$ElementUpgrade}', '{$ItemPierce}');");
}
9 H' @& t$ ]* H8 L* [* G7 E1 G
}

}
8 P  S' y* ?4 }6 _, p# P9 o
$InitForm = InitForm();
1 e% ]" L  _8 D$ J; {9 h4 p0 w$Listener = PostListener();
5 e* f  @9 a! ?
?>
% Y& u- v' v* N5 c) G


2 u( u( z! ^0 Q7 z; y# o, J4 W# |
: V/ p: c6 e& ~" Q: B* z% C! V