飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
# x$ W& M1 M: X! \0 i
function Connect () {
/ m7 Q: @5 m9 D O, f- f0 g
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 b7 ^, O- a/ r- M3 P
: l/ p2 l: C$ [2 e0 D5 t _
Failed.');
3 v" L J' u$ z" e: H2 S
}
) f* }! G# F8 |
Connect();
. N9 t* C% f. P, K2 h
1 \, W5 P/ J9 S. h. j6 m$ T
function InitForm(){
4 r9 P c# ?% c# O( P0 k3 ]" ^
//layout for the form
1 B$ i1 \/ t3 c. W5 s5 o( O
echo "<strong>Send Items.</strong>
1 {8 l& t, ?$ `6 S. T/ ^0 N6 L/ H1 K
<form name='select' method='post'>
% Z, t5 Z/ l* R. |9 [% Z/ h* |5 z
<lable>Character Name</lable><br/>
}/ k8 `9 |1 U. c
<input type='text' name='char'/><br/>
! K; V/ O- L" b% }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 u$ [" e$ w7 @; x% N
<input type='text' name='item_name'/><br/>
! R/ D9 b; b) E
<lable>Item Amount</lable><br/>
7 c, \" @4 F* N1 U+ W
<input type='text' name='item_amount'/><br/>
( Z9 R% b, R$ X. r0 ^ c, }
<lable>Item Upgrade Amount</lable><br/>
# z8 `6 a. `. W0 m
<input type='text' name='item_upgrade'/><br/>
3 F- W) i' N7 b7 E0 A7 W. T$ S4 @
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 j- k j1 f; Z n7 B P& A" J8 L
7 T3 f4 R3 ~! O5 b9 g: ~
</lable><br/>
% @9 ~0 L' \+ g$ ^) e" @4 Z
<input type='text' name='item_element'/><br/>
8 z) N$ V2 ^; x; A
<lable>Element Upgrade Amount</lable><br/>
9 v" j' h l: L) z
<input type='text' name='element_upgrade'/><br/>
* v3 o0 _. D$ K% G/ p
<lable>Pierced Amount</lable><br/>
K7 q! O' G8 W5 \! V
<input type='text' name='item_pierce'/><br/>
h7 ]4 s3 I) i3 T
<input type='submit'/>
2 i, ^: ~( k% X
</form>";
$ I5 S, y8 x; W4 C# M
}
# C6 x& q' D0 t, v
6 _& x" v0 Z, J" c. ^
function PostListener (){
8 L6 w O( f6 l4 I9 h9 A& F
//Add more post variables if needed and add them to initform() function aswell
7 V) h' f. v' c
, M y H5 S+ p. G% v
################################
2 [" s' {, b: L" s
##### Connection and Post ######
( {( q$ A4 }7 w# d E8 n" A- D5 P
################################
$ R: s. K; w4 O/ ]( B$ @0 N
$name = @$_POST['char'];
( T' b4 i6 `! R( d8 \1 _( L
$ItemName = @$_POST['item_name'];
' _$ X+ h' ^1 A& X2 j1 n% p
$ItemAmount = @$_POST['item_amount'];
- \( ]5 Q- ~% r9 I" _- Q4 k) H( M
$ItemId = @$_POST['item_id'];
9 I) [; a$ P* T% C; ]. j7 X
$ItemUpgrade = @$_POST['item_upgrade'];
: E) E9 C! q1 d9 ^7 F
$ItemElement = @$_POST['item_element'];
4 c9 q" R9 l. T: q5 ]( ?; k
$ElementUpgrade = @$_POST['element_upgrade'];
2 [+ i4 ? r) Q! k
$ItemPierce = @$_POST['item_pierce'];
& a* |5 t, n( q2 H9 m
################################
8 Z+ V. \1 d/ G' z3 @
- w+ I% ]6 W( W% ~
//Check both variables for empty value
* r0 p. X0 y: c m$ e% X
3 {- ^9 m+ b1 x2 o& R
if (!empty($_POST['char'])){
\( |) G1 Y1 b3 ]( T$ @9 G$ G
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" D# p7 C/ ]6 p2 x! C8 G; X S1 w
! p9 L/ f6 A3 `
m_szName = '{$name}'");
) \7 d/ W" K. s" ^/ |. |
while ($row = mssql_fetch_object($find)){
1 E7 Y) e( K! h8 q7 J0 i% p
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 q8 g* p' ^4 e O" i& u
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: E2 H( P- f1 F5 P+ x; C
s* y8 M* k/ ?
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 {2 Y# e& k" U# R) l
- L! c- a5 o7 D4 s* z0 s2 g- u
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ S, c8 A- o/ }8 P) T% n+ @7 k
2 T3 G( u% _. l1 @- S/ {
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 J% `. X. ?0 Y0 c( F. }) o4 E& P9 u
8 V# }' P9 R* l* X. G2 C
'{$ElementUpgrade}', '{$ItemPierce}');");
1 Z1 f! A$ @3 ]# _# F
}
* k, {1 u+ N- N8 z5 g1 Z
4 n: p c5 N, c; ?
}
" I/ k5 x) u2 M X7 r
r8 Q0 N/ K+ y9 w+ V' C
}
7 |6 q% O9 X, U: i8 n& U) p
4 F, T' f$ B: P5 B( O( Z- W
$InitForm = InitForm();
$ ^& d4 B3 O8 b {
$Listener = PostListener();
- ^3 f1 ~. I, Q x' L8 N
9 K1 \( ^) l: e: ]1 t+ Z1 V8 ]
?>
" D4 ?# S6 }( Z) s' ?; v8 P
3 F: r9 K7 N$ }: z* s8 o; W
- P- c+ ^9 f2 @# L) m( g
8 n m/ D) u: ], o! b3 r/ N/ P# J
( J) n6 A# J3 ?6 i6 {9 d7 w
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2