物品发送脚本

admin

<?php
& d6 }) D! E% W5 qfunction Connect () {
4 a6 J' ^1 @8 i1 umssql_connect('Server','UserName','Password') or die('Error: Connection to DB

* W+ T  G0 \- sFailed.');
}
) \( m, z, w* h, u; bConnect();
2 `) J) D3 e9 T9 S1 M
6 ^4 l3 b( H" a+ efunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
& c5 ~8 A& Y4 j/ x2 x9 ~- X<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/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
1 X" N  R/ Y. k: W<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
2 v7 Z9 [* u1 z( g  q% c2 p<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

/ H8 _" g1 @& t; p4 |; p</lable><br/>
9 }7 M  m# z! M1 V: B; w<input type='text' name='item_element'/><br/>
/ C, K7 k& p. d; w; H3 d. D<lable>Element Upgrade Amount</lable><br/>
. T9 n( V# J5 @$ U<input type='text' name='element_upgrade'/><br/>
6 J: w  H9 e0 R: u, M! Z<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
( j6 i$ _1 T3 u  {& ~+ m  M</form>";
" V: @& R- t- f% C6 V# k8 g}

function PostListener (){
4 |7 l% ]5 s/ q' u4 F% V//Add more post variables if needed and add them to initform() function aswell

################################
. ]! S9 t+ P4 A. c0 H2 I0 a##### Connection and Post ######
1 K3 T8 e3 r( C+ e% [################################
  k* u: s, e* _0 j$ L, J! N$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
) y4 r  M+ u- [# m+ _! ^; H$ItemUpgrade = @$_POST['item_upgrade'];
5 P' N, C& ]5 v3 e- u3 h, T5 p, _$ItemElement = @$_POST['item_element'];
* h% ^; b, ?8 ~8 T" i" Y$ElementUpgrade = @$_POST['element_upgrade'];
. D2 a$ i2 {) W* g4 k) W& O$ItemPierce = @$_POST['item_pierce'];
  ^; H$ B$ l2 p0 C################################

9 I9 C" x* h% Z6 x) g) \2 K; W* [6 e//Check both variables for empty value

9 V* t  V9 |7 u1 }6 x2 {5 Wif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' L! Z  g* i- q4 d% P0 @
m_szName = '{$name}'");
- }+ b' g, \2 j7 u( u0 Y% pwhile ($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],

1 S5 u- T- y" P( T1 \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 h9 F/ Z2 Z0 l# k[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ ~$ i- ]6 Q. Q0 Y' i: K: C, ?& Z1 T5 I
5 j; W# I4 r5 ]N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 k7 d; Z; U6 U$ \( s& W' Y0 l
( k8 I& r$ t3 c7 E6 _'{$ElementUpgrade}', '{$ItemPierce}');");
! @# P5 `' |% l& ^& d/ A/ c4 `& M8 a}
$ q& q, P4 g1 ~( p" n/ W  X9 i* s" ]
}
) }2 J! i9 e/ n3 r* G& V) ]% O
! y/ m; ^6 q: x6 K- T) K) A0 p}

$InitForm = InitForm();
$Listener = PostListener();
4 J8 w) P) r. a2 b" ?4 s$ \
?>
3 X# N3 [  ?  q( M
3 z/ B( M1 E& n. O6 k

4 d8 C: h2 F8 c0 h/ |