飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
' k0 E+ i. y9 ~. z
function Connect () {
3 Z' d0 L+ r; @3 P4 N5 d. n2 b* w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% t6 |5 X: F- X- k' Q
, O0 B E: ?1 ^; e
Failed.');
, u0 ~' O( v. r) `" M8 K
}
9 F$ d8 y/ @/ \/ B/ r$ y# t
Connect();
4 C# [8 l0 t" R' g+ r8 H' Z! e
# H$ j4 Z- {! M5 k2 f P
function InitForm(){
2 f% f2 w; p. y: n
//layout for the form
2 h/ A. A' s7 A- n, q
echo "<strong>Send Items.</strong>
1 Z4 `7 R# m6 S) j0 Q! ?# N/ I) A8 Q* ]
<form name='select' method='post'>
$ R+ O) }: E3 N4 ^ d# Q3 n+ t
<lable>Character Name</lable><br/>
! D! W4 O- X( C# [
<input type='text' name='char'/><br/>
" b S' g! F) v$ S- h
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ ]1 G$ I2 Y9 x$ \! G* G
<input type='text' name='item_name'/><br/>
$ f' ]2 }7 {. _+ w% ?+ m
<lable>Item Amount</lable><br/>
* z1 s& @) x* `9 Z# |$ e& g0 i8 @
<input type='text' name='item_amount'/><br/>
' g* J2 c6 ^* q! p
<lable>Item Upgrade Amount</lable><br/>
1 k! }" o. L7 x3 I9 e9 A9 k7 N
<input type='text' name='item_upgrade'/><br/>
: S0 `3 j7 E' n% W( Z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
x* z+ M' m: H# e0 `7 P& y& M
4 _. ]+ Q; B ~" F- P
</lable><br/>
9 E! g5 k3 F$ X9 t) L/ W, b( G
<input type='text' name='item_element'/><br/>
& O! P$ s$ a* ^) m3 f! f4 \1 n
<lable>Element Upgrade Amount</lable><br/>
+ H" S7 m, i- K$ J5 C; E
<input type='text' name='element_upgrade'/><br/>
% D3 c. r0 [% C4 c) \& H
<lable>Pierced Amount</lable><br/>
0 @' k5 O9 s w& }/ w. N& I
<input type='text' name='item_pierce'/><br/>
" Y" |6 E% b' O4 E
<input type='submit'/>
) K" N8 i. Y5 s
</form>";
' m8 @; q; B! H5 ]
}
% Z9 Y% n6 ?: v( A9 H
5 R/ [2 `* l8 u, A" p
function PostListener (){
: v: \* i" @- \; G7 E( F( d
//Add more post variables if needed and add them to initform() function aswell
8 p( t& ]5 T' }! W
7 K2 _7 r) n& o$ @; ]8 Y7 R" I
################################
0 k" f. S$ {6 W1 V0 M$ v9 V/ ?% x
##### Connection and Post ######
( _7 V+ h2 ^! h9 G, u
################################
& G6 V; p/ J9 j/ ~2 E
$name = @$_POST['char'];
4 R. O! ]6 R( D. U* ^2 _
$ItemName = @$_POST['item_name'];
4 _4 v, [& g$ l f9 |/ [+ y: T
$ItemAmount = @$_POST['item_amount'];
1 o9 r$ X) J; d% w. _
$ItemId = @$_POST['item_id'];
/ x2 d- M% J3 W4 x2 }8 A' k
$ItemUpgrade = @$_POST['item_upgrade'];
$ B. q* [7 a7 v6 X2 Y
$ItemElement = @$_POST['item_element'];
3 R' ^% u9 I! o$ z+ i) t
$ElementUpgrade = @$_POST['element_upgrade'];
$ }% K$ X8 Y% a6 J
$ItemPierce = @$_POST['item_pierce'];
7 P* I! e1 m1 p* e
################################
3 v5 O1 T8 g% c+ b, C
S( Z, Z" |# P% i3 ~( ~; b! U
//Check both variables for empty value
0 m6 s/ }! ^7 J+ n- k
( ]+ P0 N; B i- v% ]8 {( S4 \
if (!empty($_POST['char'])){
1 y$ x4 L* S1 B7 N+ j! Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ ]& \* A. ?0 R/ V, h
7 ~3 q. n+ Y8 Q3 w2 A
m_szName = '{$name}'");
8 O9 l: S! _+ A5 W/ h+ Y2 P
while ($row = mssql_fetch_object($find)){
+ e6 g9 l& _* y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 x& A) r2 n, M; t! c
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" W; u; L$ C" O% }4 K5 k6 n
9 e$ ~1 _/ Q7 }" R0 _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
" t/ Z% r9 B8 ]/ U/ T3 d0 z% Z
7 k1 K& r0 w& e
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 m& o1 M, m. B
4 Q: y: b t9 n$ S: a3 [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; z( w6 ]' w4 }
- O# m8 ]6 c/ s: F- ^( ~8 a: n6 |+ _
'{$ElementUpgrade}', '{$ItemPierce}');");
6 Y8 R. M- b7 V4 T; H
}
' t7 U/ p7 o9 x |0 W7 D& I
6 e" J, C9 N* f' h
}
0 l, G% q' B" e% [
% B% {! Y* A0 ]. {# Z2 e
}
1 O& R8 e; d9 n3 C& A. T- n2 e6 z
" X t9 E- N: o8 |2 w( g
$InitForm = InitForm();
+ w- h3 J& F# n5 L/ f. t
$Listener = PostListener();
. Q/ v3 ~3 K* p
9 }; k9 j9 w$ B+ Q/ {
?>
8 h# M- o2 c4 v* ?. r1 [
% ^/ u8 Z' O* I2 w' t, b5 R4 E
# L7 U. `& v2 {3 b" l) Q
6 b2 `; s- u0 ~* y
5 z! N$ ~: m% M) n9 U; ]+ I
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2