物品发送脚本

admin

<?php
7 u+ y2 @. \. r8 w: h1 ]function Connect () {
% X8 o# g  W6 h# S/ \: R6 zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 E. g; N" o) \6 f
Failed.');
}
  Y% B. ~8 B' X" ^Connect();
" J7 A8 {. C. G0 c( p& B' w# }
function InitForm(){
//layout for the form
' P# L& N; Q) ^) U0 fecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* S4 ~; ]! h9 K& ~; l; |<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/>
7 O. F4 d  Z  O$ X: Q& U<input type='text' name='item_upgrade'/><br/>
) N% K4 d8 N7 ^" \( ^3 D* F<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

/ r6 j9 A2 |0 J' k. a; X</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
3 v5 O% P# W) }0 m* P' V) |<input type='text' name='item_pierce'/><br/>
% Y# C& |/ e3 V& Q$ R<input type='submit'/>
</form>";
}

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

################################
##### Connection and Post ######
" p6 d) K/ {4 Q8 f3 F$ |################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
' a+ F9 ~% |  O2 J+ p0 i$ItemAmount = @$_POST['item_amount'];
7 b* X! m. ^5 v6 N  b$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
5 N. S% Y# `( O( b$ItemPierce = @$_POST['item_pierce'];
################################
7 a/ v& ]& h6 n  f5 ]
//Check both variables for empty value

! a7 m- t2 ^9 c3 ~9 oif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
" C+ B5 V: f7 l! O8 |1 [while ($row = mssql_fetch_object($find)){
. b' \' s* d9 w9 f0 M3 ]+ w4 Techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 t! A) }6 S/ [5 J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ V$ h. a$ V! d& S
9 ~6 q. C/ F9 v% s4 F2 W'{$ElementUpgrade}', '{$ItemPierce}');");
' ]; \$ ]9 x, j- R}

" G& z( }8 _( P5 _( b* D" ]$ C}

% j3 W/ b2 g. I; N) w$ m( Q}
+ F1 N7 [5 y9 L
$InitForm = InitForm();
$Listener = PostListener();
* B1 Z& o. t* G) O4 E3 U: g
3 K  s; w9 K2 A( F2 K; s2 Y  ~2 ^, B?>

% D* [+ ^2 Y$ F  ]8 N" H8 S

6 g4 N( Q! \4 b( D
( ~& ^' e6 W: W4 t7 E4 E