飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* K4 S8 C2 Z/ i5 D7 s
function Connect () {
! p. c! [! R6 V& q: q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 U* a8 a0 C/ y. f
0 |$ Q- A( F3 Q, J. r, p, H" E+ e; Z
Failed.');
( {& u m8 ?1 U0 A5 ~
}
) _9 d+ K( f s& H
Connect();
/ J; ^# Y& v6 l
9 }# k7 I8 s" t& M- M
function InitForm(){
5 \; v- M* u4 ~( Y$ Z
//layout for the form
0 u$ n; f: H' Y3 Y3 a
echo "<strong>Send Items.</strong>
1 r8 [ |3 `! F/ p0 I- \
<form name='select' method='post'>
; h6 B- m# c) p: f7 t
<lable>Character Name</lable><br/>
$ s8 t5 m/ R4 w9 W" {" V# |
<input type='text' name='char'/><br/>
- O1 I0 n e# V! ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% d @: a! N/ G6 y4 t. a
<input type='text' name='item_name'/><br/>
% X! W' ~5 J+ u
<lable>Item Amount</lable><br/>
5 y7 \3 o, K, E$ B* R( T
<input type='text' name='item_amount'/><br/>
" L; l9 L1 i E* y( ^" q' `
<lable>Item Upgrade Amount</lable><br/>
) t+ h8 Z0 F M
<input type='text' name='item_upgrade'/><br/>
& ]- J. s/ ?. ~$ z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* @" k9 T! W2 o1 u; E
3 M* k/ f7 H' E) D( t
</lable><br/>
( z$ }* [4 C/ d" R7 {9 Z* n
<input type='text' name='item_element'/><br/>
4 ]) C s4 F/ P! N& e5 h
<lable>Element Upgrade Amount</lable><br/>
; a$ h9 C6 @7 f) h) A% k
<input type='text' name='element_upgrade'/><br/>
& s# N, T) ~$ b& C% E8 T7 N8 C
<lable>Pierced Amount</lable><br/>
R s& b8 k- n' e+ S; p
<input type='text' name='item_pierce'/><br/>
8 b! u0 F7 t% S! o" l
<input type='submit'/>
4 H: e: }0 U. j# Y
</form>";
& ^8 ^0 L8 J5 C" P
}
" N+ t* t, Z1 ?+ q: v# J
9 w& E( l" e$ E$ E* T7 x
function PostListener (){
5 y/ t3 @9 |" Z0 t
//Add more post variables if needed and add them to initform() function aswell
; J/ K( S# P& d0 O) {' `7 i9 G
4 g/ p9 @& |! K3 L! k$ A( h2 p3 l
################################
# G9 d$ x4 U+ l" a, ?0 _! Y
##### Connection and Post ######
# E3 b) H1 u' U% F
################################
( N! c% N& g3 ~0 t r
$name = @$_POST['char'];
( e, B& c$ b/ O3 r+ x- X8 Z8 T
$ItemName = @$_POST['item_name'];
4 Y' q2 u, A. {1 w8 o n6 e
$ItemAmount = @$_POST['item_amount'];
: f, h" Q$ U( `# I0 u
$ItemId = @$_POST['item_id'];
7 K0 Z( ~5 Z* z6 e
$ItemUpgrade = @$_POST['item_upgrade'];
. i, u/ Y+ ?5 r
$ItemElement = @$_POST['item_element'];
0 t K4 k! M) k) j% l
$ElementUpgrade = @$_POST['element_upgrade'];
, m) {: T9 s! q8 V
$ItemPierce = @$_POST['item_pierce'];
3 b* O. r* \/ n* G3 g
################################
' _! ^3 v' x; ]" f" ^
8 w& q: s1 q2 H3 f: Q
//Check both variables for empty value
' ` B6 E6 B; r N
& E* F7 u1 ]9 ~7 _: Z' z0 B
if (!empty($_POST['char'])){
" f/ ]& t9 m! \* f! S& H( g. W
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 {# ]5 `) l8 c" ^) {. j
' p0 O6 C% x |+ w
m_szName = '{$name}'");
; L1 T+ F4 M* n$ N ?( N
while ($row = mssql_fetch_object($find)){
- m3 |) w( `) m( s1 p9 P0 k/ _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& u* a3 H' p3 J- A$ d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 `& \ d1 E& o- U0 r* I( e1 ^. k, I2 ^
5 |4 l/ d/ C) d7 n
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; L/ l- f! J& X3 ?- a5 ]5 G/ C' h
. b& T8 V% R" E* b0 B8 n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- Q1 I% h$ U8 @+ v% X
3 v6 E- D- k3 n* g: ?4 U! I
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& a5 r, u: @6 n; X+ r! b
' v* M% [# q! X; `
'{$ElementUpgrade}', '{$ItemPierce}');");
7 n, S% `# F. O G! x6 J; ]( t. L1 T
}
- ?5 J4 Y, Q' F0 \$ R% S" w
2 Z4 u3 S) Y' E# Z( p# L" k& x/ B
}
: L5 S4 _5 C' b0 }
. h8 U0 R, T0 u+ x" B" Q/ S) n- g
}
}7 n' u* b( N% i' }/ _. p
$ {' S2 X; L, B
$InitForm = InitForm();
0 ?& {% D( `5 k% x1 s9 L' [/ d' X* Q
$Listener = PostListener();
+ q; f8 g# ? k1 [% X8 B2 |: O0 x
5 Z+ t5 }5 A' [# |5 ], V' K1 r
?>
3 f2 J! e9 f2 b! c c) w
4 L# j; P4 t4 |/ v
, S! e5 Q' O9 ]9 b w: L6 q
- T0 X* i! z4 R- D8 v! Y! B
, G3 H+ B, A( r8 o/ a. N( X* a' s& Q
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2