物品发送脚本

admin

<?php
) f- a5 C! s5 H' ]function Connect () {
1 K" R2 p+ P4 Z3 Z! d+ C# f  v1 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
$ ^$ k* ?( i  Y% m0 aConnect();

0 Y: x+ W8 q# E6 |7 H1 Cfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
) U! Q! a, _) l# O0 R  j4 n<form name='select' method='post'>
<lable>Character Name</lable><br/>
+ F+ q1 Y4 Y. f, U; z- P1 P, x<input type='text' name='char'/><br/>
+ |3 U5 j$ P4 k/ x2 j* w4 g<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, j5 H& Y$ |$ _5 n& f9 }<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
( E+ O, v! m. s/ A: _: i<input type='text' name='item_amount'/><br/>
; I4 h5 `, q- s, d* m0 g2 J  \& S9 H<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
4 n3 F  R% ^5 F! f. O8 q* p  b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

8 v3 G$ U( u, ]8 ^% Y# f</lable><br/>
! z, `" I' _4 o3 @# R3 w<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/>
% r+ m; y2 X% d; q) Z<input type='submit'/>
: G3 B7 Z" [8 W; g1 ~</form>";
9 a1 C" _! ~- n$ u& i+ _1 Q}
* y- _. U7 j8 \6 o' O
& l( G' K. I" o. Sfunction PostListener (){
* p  Y( x2 ?/ z//Add more post variables if needed and add them to initform() function aswell
. x8 y6 b$ G6 C! W3 ?" K% h
) \! f& }* K$ z; y/ p. C( D################################
##### Connection and Post ######
$ T; t) x! l5 k6 L################################
4 h& r5 W; {4 h$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
3 {8 n! f$ ]3 w2 C% D- |$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
3 O$ M3 i8 w. [* A################################
& u5 z' R& S" M% y$ T! Q. N" X
( ~. i* h# i+ F//Check both variables for empty value
) t. N, Z/ Z8 o0 B
/ m' U+ B6 o0 t$ T/ r0 @if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
* }2 m. r8 N/ _8 S$ E( B. n3 rwhile ($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],

& |* J0 T5 I# D- e" W/ Q- D8 X3 R[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 [- I4 ]8 W, M/ B4 r6 i# n+ V
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

% f; X- Q+ Z/ W3 C9 u& H- xN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 }2 i% o6 ]. o
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}
! ]& P0 N& j6 z, o% Q
6 A2 B+ ]1 d+ H% O8 u8 t$InitForm = InitForm();
* {% Y- \( o9 s4 m; p$Listener = PostListener();
* h" a4 w5 Q# _8 e
+ q3 T1 F, q3 R2 U?>
# ]) D& ?0 r, j

" }3 ?0 ^8 ]* D
" X. Q  i  B8 x! n; i