物品发送脚本

admin

<?php
function Connect () {
4 j! F; e, w# {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
( \; i1 L4 l- Z# t& R( \& jConnect();
/ M8 Y  O. Z: _1 o7 F( C
( D4 q2 Y. e9 ^function InitForm(){
//layout for the form
7 {8 q3 k( o- _0 y( uecho "<strong>Send Items.</strong>
2 @) }7 E% f; k<form name='select' method='post'>
, h5 N- R' W: u2 X# a" J9 W<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
7 o' ~0 o# R5 A/ Z3 V( Z: t<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 ^5 f8 ]6 D* ]6 C<input type='text' name='item_name'/><br/>
) n( b/ |2 R& ?/ K) c5 g<lable>Item Amount</lable><br/>
6 |1 K7 t2 ~, [; Q<input type='text' name='item_amount'/><br/>
2 |: V; D2 p% p* y+ G<lable>Item Upgrade Amount</lable><br/>
$ s. {& T  T' X& c<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

9 z  `" z$ s9 W) p2 j3 q</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
) l  T& ~) o' \5 |- o! ]<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
3 p2 I6 z4 J: A}

function PostListener (){
2 y. h7 q2 J6 c) \//Add more post variables if needed and add them to initform() function aswell
6 t/ H! N) D+ m" n  o( H* d
5 {! Q1 y- n) E2 q2 @& J# M0 i. F################################
6 `, O; ?% l' H9 v$ @$ I$ Y" o. [##### Connection and Post ######
2 G2 j- y0 B$ F/ ^% [5 u################################
$name = @$_POST['char'];
7 z* E  h1 {/ F( ]5 G$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
) h- @' X7 c3 C* t$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
' L6 K& z" k, g  {8 o- E
if (!empty($_POST['char'])){
+ `2 U6 Q* U, H" Y1 g  G! j; z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

/ I  Z. a  V3 j" T7 S# J# t- i  f1 dm_szName = '{$name}'");
( _8 H; T" h$ T: T+ [9 X# D( J( B" 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],
$ w/ k( `( _7 T# W2 n. L5 N
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 G& F& Z% ^8 B+ W$ }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

3 @" i& w8 \  ~. F& N% V2 \}
* i! j& y' D, I2 n2 F) j: l5 L
! P3 Q8 E* `  H3 T! Q* F0 _}

6 t7 p% u1 S& o; k. b$InitForm = InitForm();
* V2 E4 h; k& G4 A2 l5 A2 s8 l$Listener = PostListener();
9 g( j) b7 x3 J8 n
+ ^( B9 x4 C4 D! `9 y2 f' I?>

; d2 Q- w6 c' F* M% A0 O3 p

" u& x/ g  W3 M5 P: w
, O5 v2 f) i% G5 f; }' u, z