物品发送脚本

admin

<?php
$ P7 W4 g# b5 I9 a, P8 l4 J5 E, }function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

" B- Q) u$ b9 h7 pFailed.');
- h$ A. F$ M3 }& w1 o}
1 ?. ?1 Z: t& t! a8 BConnect();
( h0 z8 k, C# g' ]# T4 C9 O+ Z
function InitForm(){
6 a. q$ ?( [+ w6 L//layout for the form
echo "<strong>Send Items.</strong>
' a) t: P* \- L1 P* A  e& o<form name='select' method='post'>
$ y3 P4 J0 j. p% s<lable>Character Name</lable><br/>
9 \% ~* Y' t; i3 g<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) `  ~0 a9 R. C<input type='text' name='item_name'/><br/>
' u2 v5 y4 G- Y' Q( K6 |<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<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.)

</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/>
<input type='text' name='item_pierce'/><br/>
' ?. R6 l7 W7 t3 u' [, W+ h<input type='submit'/>
</form>";
}

9 u& x: d8 F9 M% p. _0 v9 H' Afunction PostListener (){
, J8 @- L4 I& _3 R% }' N- i//Add more post variables if needed and add them to initform() function aswell

################################
  d/ I: q& ~/ _! W9 y+ L##### Connection and Post ######
################################
$name = @$_POST['char'];
7 S  F0 ^2 z. [# ^2 G- [$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
8 i3 \/ c5 ~  \# w+ }$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 J! x$ Y. V  F& B7 v2 k
3 \$ ]3 O0 n+ W) C: @4 Nm_szName = '{$name}'");
9 R8 n9 N% n- l: B' l. z3 bwhile ($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],

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

" Q' g# `" I9 m$ _( O" N* _2 x. n[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

) H# b7 K2 q' ^+ u( GN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 Y. E( F" H% ^' e  P2 `
( M% {' u+ S0 f1 l'{$ElementUpgrade}', '{$ItemPierce}');");
8 c& A! `* {0 E1 ?; Z$ X, o}

}
5 X1 O+ @2 i" C  q" w, ?& G
}
1 ?9 d6 D' \; s+ a8 ~) S: `; b$ }4 q
! p( P* W+ ]/ }$ p* K- h# O$InitForm = InitForm();
$Listener = PostListener();

; R% U, I8 L' z, i- n  z?>
3 }2 l( E) q3 i, D2 L% [/ f


1 |  U* z: L2 F; q5 ~7 a( E8 {