物品发送脚本

admin

<?php
/ m5 I1 ]* ^" d. ^1 h% ^8 S* ^function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 d" Q4 M& q$ A# x! X: H
Failed.');
/ }: _% V& X( M) ]+ @}
Connect();

function InitForm(){
# }. M5 G: T+ h% g% B4 q//layout for the form
) N5 @6 H! q% ]' `% Necho "<strong>Send Items.</strong>
" X5 h/ q0 N' N( E) Z- x; r<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
4 p, @) h& V% V+ C' ?0 _5 a; ?) h<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 V( E8 c8 ?8 o<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
% n* c$ C; F% ]; A% ]9 w0 W( A<input type='text' name='item_upgrade'/><br/>
5 F1 h$ k# [; h$ b<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/>
" C; R& N8 u0 S2 r5 o2 Q<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
, U2 H% e# C7 C- F; I1 R! x</form>";
! j; C" ^- W# n/ {# }}

( q7 S: \2 p/ |  U7 B* yfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
% b. W5 q7 _" ~0 A+ C$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
  U8 I- ^# b* m0 b1 H* w! g4 }, r$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
. e; f; V; y4 F! O$ItemElement = @$_POST['item_element'];
2 v, e0 i; I8 a# S5 ?% Q# C$ElementUpgrade = @$_POST['element_upgrade'];
* \2 v0 B% E+ H* l$ItemPierce = @$_POST['item_pierce'];
################################
# f$ r+ R/ Z+ O7 N- l2 Q. N5 d
% X9 [) D+ W/ r+ R//Check both variables for empty value

! }0 x' |& u" p- E0 V' eif (!empty($_POST['char'])){
# W" V8 |" T( F* j$ O$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
$ {2 K- ?4 _, a; H9 ]( ]while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' b, K5 C; W2 m" G$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( u0 ?5 o4 t% U. ]
8 x. S* S2 ~' X1 l9 H% M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

) s- V  X1 B+ X8 m" M3 h" J2 m'{$ElementUpgrade}', '{$ItemPierce}');");
8 T8 z% X* w7 ^5 N" Q}

3 x% f3 w4 S+ H0 N, ~}

}

$InitForm = InitForm();
$Listener = PostListener();

?>
) _& C/ z" G, A4 ]9 u) n

" s( }2 S$ ~; Y/ H& e5 A$ U

# g/ _; Q! {2 D1 g: h8 W5 o