物品发送脚本

admin

<?php
function Connect () {
$ h/ d! ~; B0 O2 Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

6 O# ~. ?: }7 k. u7 r6 S9 _# GFailed.');
}
7 M* t1 N# `4 z0 y2 M* X! iConnect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
7 {8 T; @- A# M+ ^4 y<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
2 E: `! \; l8 V<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
* c) g: a, F$ T  A, w) ]5 B<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
; A4 Y1 l) r" _! _7 |  k<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( a6 t) }9 ]( N1 d) v# y7 w" g9 y
& O- [4 w% d- P4 r' n</lable><br/>
7 g( N- |5 z0 B<input type='text' name='item_element'/><br/>
9 H. Y2 P/ G6 L3 _' Q8 h<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 w/ v; z! w7 B' N: E6 J<lable>Pierced Amount</lable><br/>
, _/ `6 ]7 S% p5 I1 @) N! R<input type='text' name='item_pierce'/><br/>
+ H, ?" F% G1 H( _( W<input type='submit'/>
# Z+ |9 z1 ?6 U  h</form>";
}

: A. n8 F; d" H: o5 v4 vfunction PostListener (){
' K% `6 B9 ?) B/ r9 M* k$ U//Add more post variables if needed and add them to initform() function aswell

################################
' D3 F+ h. a/ Q" J##### Connection and Post ######
################################
0 e8 H- p' b  A' R4 J. x3 N7 {7 d4 C$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
7 u- J9 U& c; M$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
/ s  t/ n0 k& t' }% a################################

3 d% s& U" B; M- w//Check both variables for empty value

6 G- I3 _& F  J! Wif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
8 M4 N  m) N8 F: R( Vwhile ($row = mssql_fetch_object($find)){
& t  I% c: s' becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: {! F( m7 c4 w% A/ Q& @$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) E- R6 A) ?- Z) P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

3 j' I. I- ^/ }4 c! R) v' DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 _9 W+ w6 B  B4 j) n4 c
/ c, v8 D' }& t4 Y+ g'{$ElementUpgrade}', '{$ItemPierce}');");
}
8 b' o5 S: b1 w: w/ D! x; N: H1 U
}
- p+ A/ D+ W5 Q
) t/ {, d# f1 m; L/ o$ C}

8 y9 B3 @1 A3 y. S0 l5 t8 z$InitForm = InitForm();
$Listener = PostListener();
! ]7 w0 r5 B; X5 y6 T
2 G0 T4 s9 H, _?>
$ y& N/ T8 Y8 y. z


6 q0 u" S8 T1 X" P* F6 G