物品发送脚本

admin

<?php
! q/ f, s2 J; I9 \: Tfunction Connect () {
& P& f5 L# I8 Z$ Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 O" `; ]3 {- w; M- P; E/ K; f9 a
Failed.');
) ?% h3 {0 M) }7 x}
: [+ B' N4 [( E1 LConnect();
8 ~" T# f4 _+ z; W& V8 U" f0 Q# U" Z
+ V' Y# g4 |- B# o# C" h2 D8 P0 ?6 x4 ^9 L. Xfunction InitForm(){
//layout for the form
1 i0 W& @5 J% j7 ^) Y. gecho "<strong>Send Items.</strong>
<form name='select' method='post'>
7 C6 b' Q. W5 l* V" S: |<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/>
9 j  b5 b/ z2 p  h' _<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
2 V1 F; ], B4 \0 v' e& V3 M! x2 V<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.)
! w0 g+ {& Y- H  ~* F; |
! Z, k: x2 W3 F</lable><br/>
<input type='text' name='item_element'/><br/>
' \/ D0 ?7 e! d: f% l<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
7 }$ H: ^9 o  L2 q<lable>Pierced Amount</lable><br/>
4 o3 r; q' {/ ~<input type='text' name='item_pierce'/><br/>
) ^3 E& z" P6 d$ n" N<input type='submit'/>
# i6 e+ f  y8 e6 N' o  ]4 c6 e</form>";
}
4 D1 l! ?* b2 f, X: z$ G' f2 }
function PostListener (){
* d4 u# W+ D0 [/ F) z% ^//Add more post variables if needed and add them to initform() function aswell
/ L8 `+ n' v$ O
################################
##### Connection and Post ######
################################
! a1 Q2 r& y3 v( r& A$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
; Y0 |+ O7 R- N. X$ A6 D5 \$ItemId = @$_POST['item_id'];
5 E' w" S& S" t- Q+ m$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
2 `8 \7 ]5 ^+ O1 d& ?- A$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

6 ]) F" h: A0 m! I+ b& F8 Fif (!empty($_POST['char'])){
/ x# E  i% i* L+ q0 _- h  z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% [' t) s; j' p
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ c% R7 _, `0 z% H. |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 y3 K: q- S. X3 g9 n, o
. A* o+ I2 A1 z/ i[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

7 Z/ _1 [3 E1 B) F[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 Q4 I( n6 J! |: L# M0 S
2 w& l, E/ o- t: r. m- f* L9 y+ ON'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
8 T) r- H& ?" @0 }: J0 W; N}

}

}

$InitForm = InitForm();
$Listener = PostListener();
1 F0 {) h; U# I$ U
?>


6 A" G$ U* {0 ~! n
& h" R. a$ ~' a' `0 k
2 c  P) o7 f1 k