物品发送脚本

admin

<?php
function Connect () {
7 V. d% G: Z) T! w8 ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

# m- G9 ]- d2 }3 [) cFailed.');
}
- j) X, T2 \) T. A' p. W6 xConnect();

" b8 m4 w( ?+ {: j' ]! u; H4 {function InitForm(){
( e9 k+ [' W0 I1 W8 H//layout for the form
$ ?9 ]% ?$ ~3 n% S9 ^3 n/ S; oecho "<strong>Send Items.</strong>
& |1 h( A$ Q3 }<form name='select' method='post'>
4 G" p4 h" G/ D  E3 ]) Q, ?" {<lable>Character Name</lable><br/>
) u8 M7 q  M9 D. y+ Z- ~<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
: N$ h' \7 v8 k- _8 @- u$ U<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
  K' x: b4 p' k' D<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. O; }, j- o/ E- j# ~8 ]9 }* d
9 {& d2 a# b" `! w" @</lable><br/>
& @$ q% V& l( w0 @% U<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
, }& N0 s* Q) |' O, t<input type='text' name='element_upgrade'/><br/>
; U( k: s/ d: l. q<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
: x* s8 z, x. w0 t3 l</form>";
- ?$ w% y$ U# W2 Q& U3 O* }7 t}
9 R) }  o& Y/ c2 a- |: Y
6 ^7 {1 J) `& k. R% ^( s" jfunction PostListener (){
. _' L; K$ K5 i0 E% o//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
# E% E, J/ c/ G6 \- y################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
* T. i. U, p8 w1 {$ItemAmount = @$_POST['item_amount'];
: v: b$ n9 B2 A$ l$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
, l- f$ i* P: a4 B, ]################################

//Check both variables for empty value

3 U; _# u0 N  y. h- N2 ~if (!empty($_POST['char'])){
; x  v# ?7 G5 t; j: H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' Q# r3 E* E" T# [% X7 h( U
4 H; o/ ]* E) d! X( s; ^8 im_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
9 R6 C9 R5 i$ r; R1 ]4 F8 a9 Techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" |0 b1 L" ^9 f) r! n6 S1 Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; ^1 G( _3 r# _! a# e) K! Z( b
* f0 K, \* t5 N# O" U0 [[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. }; y! [: Z& d
* U/ }# R1 r$ ON'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

& `8 s2 Z+ E1 D& z- @+ S* J' z& I7 J'{$ElementUpgrade}', '{$ItemPierce}');");
}
. i1 @9 ]' h3 F
; W/ A: F6 E6 P% y9 E1 D}

}
1 W2 ~/ C8 z' p; F8 i8 n1 p
' a  ~$ Q, o: S" r' `  \" h$InitForm = InitForm();
6 k6 D: i, ^# a+ w% n$Listener = PostListener();

?>

7 J: }" j6 Y  W& S8 Y

0 I  N) {, j# N/ @3 D4 H& g) O! O