飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
) |2 B s. `% ?* O) W# N
function Connect () {
5 Z5 ]% a( A: S, C( ]/ I$ j% t
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ Z7 Q$ n( s5 C7 ]7 R* b
0 c- A4 l( ~7 s% S
Failed.');
) D T$ ^+ W! X+ P$ ]8 n
}
6 F$ U. Y3 {- }" M) Q6 c
Connect();
7 }+ n" |( M( M) E& y
! I# N8 m& Q% r. J' N2 `
function InitForm(){
. ]( L# \2 V* @$ Q
//layout for the form
3 I7 g! ~* o* f3 l! R
echo "<strong>Send Items.</strong>
4 K+ q4 ^$ o* S
<form name='select' method='post'>
; i: m5 N, `: C; O; O+ O' f
<lable>Character Name</lable><br/>
9 v) D5 T& v0 r- ]$ c
<input type='text' name='char'/><br/>
) O' v/ a4 z/ T4 b7 g! a q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 v s/ ~) J% t' P" d
<input type='text' name='item_name'/><br/>
7 o' n: M6 K- @% r1 |9 @" e& ?
<lable>Item Amount</lable><br/>
$ d) D" L' z2 N- [& Z0 }$ G
<input type='text' name='item_amount'/><br/>
: w2 X0 A. `$ N, @0 U
<lable>Item Upgrade Amount</lable><br/>
. a& B1 c# t& X$ b
<input type='text' name='item_upgrade'/><br/>
l+ X# \$ U1 O) \) N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) u6 f/ Z) |- O4 ~7 _
2 Y2 a! [ G! d
</lable><br/>
1 u( J) S* H% X( J
<input type='text' name='item_element'/><br/>
* M! N' `! ~7 I& e0 r& a/ a7 g
<lable>Element Upgrade Amount</lable><br/>
6 N* u' z- J0 l! w( d* `
<input type='text' name='element_upgrade'/><br/>
( ~ j; P" x0 g5 `( r1 r7 j1 V9 a! }; M
<lable>Pierced Amount</lable><br/>
* z( {( [# v; x! g' o
<input type='text' name='item_pierce'/><br/>
5 s! \2 E: T1 g
<input type='submit'/>
" h3 d& D6 ]1 @/ F
</form>";
0 o2 ^, \5 B' R+ e1 m
}
+ @- V; e0 @6 x+ ?% Y; l* o" }) Q( `8 X
* p' Q! H4 t( B4 j, s% j# S% J
function PostListener (){
1 y& x% i# Y' \% z9 z) G& V
//Add more post variables if needed and add them to initform() function aswell
, q# F V+ h% k- F0 S) a7 j$ _( ?
0 C9 S. M. h5 h' D& f& [& J0 Q
################################
3 r, F" w% J5 Y
##### Connection and Post ######
7 U" h8 m; u1 ? `' Z
################################
6 O$ A; o* E* f7 i
$name = @$_POST['char'];
( ?; w( @2 ` w' s+ _
$ItemName = @$_POST['item_name'];
3 c& ]$ w) }4 t6 M5 V' t: v' i
$ItemAmount = @$_POST['item_amount'];
0 ]% ?1 {; t- r
$ItemId = @$_POST['item_id'];
7 U3 F4 z5 l# s" H8 t
$ItemUpgrade = @$_POST['item_upgrade'];
, I+ s( W8 o' x6 V$ X i& H4 T
$ItemElement = @$_POST['item_element'];
$ E k4 C" B% z7 v
$ElementUpgrade = @$_POST['element_upgrade'];
! i* A' g/ S5 C; C5 K- R
$ItemPierce = @$_POST['item_pierce'];
7 E/ I" C: N, P9 p! _8 p
################################
( ~. W, ?8 p* z7 @2 B; u! C& K
; Q6 O+ Z5 W3 Q- ~- L
//Check both variables for empty value
: G, d. ^$ N1 Z5 _& O+ Z
8 @& A$ ^! E& {0 L* X
if (!empty($_POST['char'])){
+ ]! h4 i; {, [0 @, q) a
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- J4 J& H$ B( M6 E/ u
9 D0 Y2 ^% `6 S1 a
m_szName = '{$name}'");
9 y0 e H) B2 N9 q' _
while ($row = mssql_fetch_object($find)){
2 j% h l% o7 M. Y# c
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 t0 J1 o) J& l- g: t
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 P8 z, @2 |4 ~: H8 ?: m
, e9 D1 ?5 J7 z* f7 i' m: Y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& a1 n' b% _1 [% [$ q
8 k# p. _* }: i: y4 W5 y6 }
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ I0 W5 S/ B- O' W; w3 l, Z( A$ h
# w7 r! E2 F1 e( j2 \) J* L
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 F6 y4 T2 Y3 D
' ^; c7 ]! f7 J# n& R- h& ] Q
'{$ElementUpgrade}', '{$ItemPierce}');");
1 I" B0 K x. o/ B- } L. V4 S
}
9 J1 x+ U5 |0 J: x
; H, l7 ~1 H+ b8 r q
}
" X' P) a1 ~9 \4 p; \
3 h3 W: H: k% h5 B5 _- a5 V! g) d
}
% R: D4 y# i4 J/ G4 W @# {+ U
4 \6 m5 p% m0 i8 F& ?
$InitForm = InitForm();
5 w; s% I- ^) o' K
$Listener = PostListener();
& \& x6 G; Z1 R5 l, E. e
: N7 x/ h4 U; ?4 ~9 x% S
?>
1 u7 O# ^! `/ m7 H
d2 r ^, U- R d! G! b X& ~# Q
) z' m9 P# e' e( B
( X6 j( G5 p2 P7 Z7 W
4 _! g$ p1 a M" }9 p
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2