物品发送脚本

admin

<?php
% D: T0 S1 D& @9 Bfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 y( M' o! Z: s& \( E. u
0 T8 V1 w" r+ z  Z. X% T1 K* {Failed.');
}
( D. G$ a! ^1 f+ h4 P! p% sConnect();
) T0 Y9 d9 h7 O
function InitForm(){
8 f8 l" |7 s. N//layout for the form
- v; T4 R7 O- S& u0 Iecho "<strong>Send Items.</strong>
- s5 Q8 l) w, D  ]<form name='select' method='post'>
" K  W3 V0 S( I* R; t3 s<lable>Character Name</lable><br/>
% y2 S2 L* l% x9 i4 L$ z; s<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 Q( w* C) R7 [<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
7 y9 V8 Q0 R9 Q& W<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
7 \0 O, C- ^: A* y9 p2 H6 ?9 x<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ s/ l/ Y$ Q" F5 |+ ~
</lable><br/>
7 V1 e5 M( U' n/ t* H<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
! L3 w* _3 g$ J7 ?7 Z% C<input type='text' name='element_upgrade'/><br/>
" B" g4 U. E9 Z$ ^<lable>Pierced Amount</lable><br/>
3 x/ X! Y$ F  Q! X% V) t' t7 G( v<input type='text' name='item_pierce'/><br/>
2 r) [& u; |2 a9 }7 A+ i" y9 y: \<input type='submit'/>
</form>";
}
, Y1 z* g; r- e9 R7 ~
function PostListener (){
2 N: O+ @" W8 h8 A. M2 I/ Y( ?//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
6 {/ N$ M9 c- o7 Z( X/ T' q9 C################################
; e4 l  \8 k+ f0 D6 O2 ]8 v7 u$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ ?8 D( v' z; {% f$ ]: @$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
4 T. z1 `5 P6 Y$ K4 i$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
! ^3 e- C4 U0 ]8 V$ItemPierce = @$_POST['item_pierce'];
################################
$ z+ U/ L( ?' L3 Q
# C0 p( m$ E. V+ `% @//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

; e+ ~2 }; \5 Pm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
; Q0 ^+ M! j) w2 iecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 x, w5 Z% O/ r$ D& Y, P" w, M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 R/ V8 A- o. p2 Q/ \
8 L+ G" F4 p! b[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' d. p* F0 H1 e. I
4 W2 ~4 Z) C- l( V/ W1 [- ~+ MN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

/ B7 @5 \' d* p. m'{$ElementUpgrade}', '{$ItemPierce}');");
}
: G2 B2 ]  W: j, t! v; N
: j& D) f9 V, ~9 N}

  N1 i$ |$ G+ F}
: S* ?0 [6 B) A# p: \$ J: x
' H, Y5 v! X- E! J5 T8 Y, f, V$InitForm = InitForm();
$Listener = PostListener();

3 f' j+ w/ b! B$ p) O# o1 o1 ^?>
6 @4 v8 s7 Q) n* w8 O1 i2 m9 C