物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

- K; c" P6 q  YFailed.');
}
+ g' t2 J2 [9 q" ^: c  `9 \4 EConnect();

function InitForm(){
5 W- i4 H; N0 `6 T5 n//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
- n" a6 E' {) i! q8 s* ?! V<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 O$ ]5 `9 B5 o8 ~<input type='text' name='item_name'/><br/>
( Q7 }7 u% y0 T* g0 n<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
& B3 b/ R1 T1 @/ s' j" R<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</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/>
' G8 a9 b& W. E$ C<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
6 Q* q3 T1 q8 ~0 A5 A% s) E7 V
0 e2 o8 V" ?7 `4 q( }function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
2 Q1 w  O+ R: E##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
/ s) Y$ o8 e. g* h$ItemId = @$_POST['item_id'];
" @7 H, L; X8 \$ [: C; ~$ItemUpgrade = @$_POST['item_upgrade'];
( p6 S2 Q$ l7 B0 o$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
" G  `! }( z; o% J8 z
if (!empty($_POST['char'])){
: q9 }! F' w- c3 e" `+ c6 ^/ A1 _$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; P% F/ a+ I2 c! @0 a# w
7 ~! u$ S" X$ v( @m_szName = '{$name}'");
# [7 C+ y* O$ E0 Ywhile ($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],
7 L9 K# M7 k. T4 P$ C& G! q% N
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 t# n$ V: f/ R5 h# [( {+ B* C
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( h$ U4 f% _: X. c% H9 P- p) m
! ]  l9 d! Y  |, k% i4 l' E% W0 kN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
) P! G2 }. w: |$ ~
}

}
2 _- w4 x, z+ I! ?; q
9 _  |  w* j6 `& N5 s2 p$InitForm = InitForm();
$Listener = PostListener();

?>
+ s! b+ K8 U% ~, U

9 o. R3 K% s8 D) D! r

( u5 {! n, u8 s6 ~