飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* M* I8 B3 ^2 s. a) Y. V8 _5 N
function Connect () {
3 ?4 Q, Y, \8 N& T/ |1 R, H2 j: S$ _
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! P/ G& B2 o) ?! [* a0 }
2 n; r6 ~) V; y5 }+ q' {% z
Failed.');
( N# h5 h F. g
}
, O# Q, T* m- r: b4 n
Connect();
. f4 ?: }4 s, y% o$ X+ T4 i
; k0 o% p+ \/ V/ y! L
function InitForm(){
" q) M" n2 M8 v" L. T( z$ U
//layout for the form
# Y: J0 P1 B$ ]) Z5 Q
echo "<strong>Send Items.</strong>
, Z6 x3 h& e0 B0 C. d1 [. H, P
<form name='select' method='post'>
M9 w! R, b7 I% @# C3 G1 A0 s& k( k
<lable>Character Name</lable><br/>
4 k% s9 i" B- B! m
<input type='text' name='char'/><br/>
- B" F; k: C; L$ [! U. o! ~5 n9 T, w
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 D# h/ H; h2 x3 o2 q
<input type='text' name='item_name'/><br/>
8 L5 R6 h! l/ T5 M2 F" S
<lable>Item Amount</lable><br/>
$ v6 Q7 F8 R; _5 L' j' _
<input type='text' name='item_amount'/><br/>
% F5 M+ `, | S& P' {! f9 z
<lable>Item Upgrade Amount</lable><br/>
: u r: Y# S; \
<input type='text' name='item_upgrade'/><br/>
+ ], d3 N6 X, g5 q7 q& |2 D+ p( E
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
c0 L& p9 v. c; E! v( p+ K) _7 v
/ |7 W3 f- p3 H8 ]2 ~
</lable><br/>
, U1 } h) ?- u$ d* W
<input type='text' name='item_element'/><br/>
0 H2 ?" E. N( Y" O5 T6 g
<lable>Element Upgrade Amount</lable><br/>
/ s0 i. v( l* U+ ?3 z
<input type='text' name='element_upgrade'/><br/>
3 p7 ?9 c5 `6 P0 m/ q
<lable>Pierced Amount</lable><br/>
5 n/ W4 n; |! |: N" B
<input type='text' name='item_pierce'/><br/>
* z- W% h; R0 X1 m7 T) G8 b: n
<input type='submit'/>
$ _2 F$ Z0 t d
</form>";
7 u- f0 j. p5 m& U+ t
}
2 P$ D2 J5 W* g
J$ Y) c3 i. x+ i3 N
function PostListener (){
# Q! {( |7 C- f- N5 m
//Add more post variables if needed and add them to initform() function aswell
4 _" h+ {6 z. J( D3 [: n% ?+ Z
7 o& ^2 Q$ [1 g
################################
$ h) S" x, {+ q9 z
##### Connection and Post ######
( S# W0 x' w# i
################################
0 `6 ?, r- A% F# I" X# K) s7 j$ L
$name = @$_POST['char'];
3 ~) w" p5 @' d, }* @9 w
$ItemName = @$_POST['item_name'];
; i0 r# E [9 T! q( K" K
$ItemAmount = @$_POST['item_amount'];
6 j& i3 `' o& j5 W7 q3 ]1 z
$ItemId = @$_POST['item_id'];
: O2 C% G) o: [3 A+ y# J8 C9 w
$ItemUpgrade = @$_POST['item_upgrade'];
|- G0 i z- \! W
$ItemElement = @$_POST['item_element'];
( |9 A. y7 Z4 P }- d
$ElementUpgrade = @$_POST['element_upgrade'];
4 r& U1 q8 u, w- `! e
$ItemPierce = @$_POST['item_pierce'];
) t( g' k6 t/ y0 R, o
################################
2 J9 q+ o4 x1 s* f
9 g8 S/ I6 t& W W" D# ~
//Check both variables for empty value
! x% j9 A7 J4 ?5 d- s
2 U2 B6 m/ o! Q7 e
if (!empty($_POST['char'])){
0 o5 ], N2 ~. j$ t& f/ n, Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ A$ I3 P# F# R+ p1 _
% u! ]1 _6 M4 l" v% z, \. [6 }/ K; j
m_szName = '{$name}'");
* u& `( n S' y* ~! v+ U- g
while ($row = mssql_fetch_object($find)){
8 c+ E) A$ n/ Y3 K0 M( t1 @3 q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 T2 D" H% B! a6 d2 F% j, d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 r' J' z$ Q3 _
3 r: z+ `1 n! W- q% R' q0 Y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* B5 }6 E7 V+ N) `; o
$ q7 J" t+ ~4 P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* E2 t# ^# O9 `+ l! d8 i/ O8 w; v' h% F
! _9 B7 A: N5 i% X0 H" q; f% X
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( d' R: {& s$ d
6 M& ?; q! |4 l! X$ L
'{$ElementUpgrade}', '{$ItemPierce}');");
V% z# w& B4 i: K" K7 u z5 l; z
}
! l F0 c) |: I3 w/ y' p
7 s) O( \, d$ Y; ]( \9 `" e) L' \
}
, Q4 R, p$ _5 j+ Y- j t1 M% s5 d4 f( S
' g( A# T) l6 y) ]" o* Y" K
}
O% j+ H) R9 f1 w7 X
. c9 V4 T* D2 o! Q5 `6 Q
$InitForm = InitForm();
# y1 S5 o/ V' I; G8 o' U
$Listener = PostListener();
0 j% _* x+ s& ^7 G% {& r
+ d& V: Z$ S5 Y$ b
?>
9 p7 \! J6 t) ~* h4 ~9 Z
+ u1 ` s0 J# r) W
6 m0 F) S% ~, F! T9 y8 L
9 ]- j |4 p1 I: v) e# H7 T
/ B- s: S2 Z, F
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2