飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
9 ]& p) N1 p. U: K6 T* P
function Connect () {
" ^* d: r# \$ Z% m$ c3 u0 q# Z+ ^% a! H4 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 I3 v9 G: I) r" f
6 c9 g; |8 c: N( w( I& X, o! T
Failed.');
/ p$ c& `' {/ h# C4 s
}
2 ]# p' v i- P& p
Connect();
# b* b' B* e- v" f6 @" f4 T
/ \/ w6 C1 }5 o+ A
function InitForm(){
9 |7 d Y1 R% n1 F4 o
//layout for the form
6 u) Q1 {$ g& V- S* N# [
echo "<strong>Send Items.</strong>
. i( J& f' l- |8 _4 {4 H
<form name='select' method='post'>
. o) X) x9 h0 Q6 z
<lable>Character Name</lable><br/>
9 Y) n1 N) ~# f2 y5 A' t
<input type='text' name='char'/><br/>
/ m0 ?0 i0 A4 z7 h1 l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ ?. P' n# ?5 X. X {- F( t
<input type='text' name='item_name'/><br/>
5 N- N) a- a w
<lable>Item Amount</lable><br/>
$ N! h5 s- C; b; `% U3 F
<input type='text' name='item_amount'/><br/>
1 W+ O! V+ o; ~" f y1 o6 T
<lable>Item Upgrade Amount</lable><br/>
6 ~: z( i; V/ y8 u
<input type='text' name='item_upgrade'/><br/>
* o- W) ^2 _( {+ S
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 W6 c& d0 [1 W5 n& o5 `/ B3 u
0 b1 ?- z) \) I0 R& d7 p; {+ W1 y
</lable><br/>
/ ?, X, j( L( u/ W# Y; ?! ^6 W; z1 D
<input type='text' name='item_element'/><br/>
* l/ V) w. ]# l. E- X7 M g
<lable>Element Upgrade Amount</lable><br/>
7 @* D2 g5 m3 V7 H) K
<input type='text' name='element_upgrade'/><br/>
! K: G% W$ |0 x
<lable>Pierced Amount</lable><br/>
; a K! u7 S( L' a" k
<input type='text' name='item_pierce'/><br/>
/ [+ t- P l* g2 G4 T' j. Z
<input type='submit'/>
: J3 X7 T# l* `0 t7 h
</form>";
. A5 g8 U; T. f
}
3 \6 t% ]5 _! v1 R# U' |1 n* r, ?
5 [! Z; m# S r% a* W- N- j: |# A
function PostListener (){
6 n& m, o! {" [* \! t& }( F- M. l& d
//Add more post variables if needed and add them to initform() function aswell
! c; V x" P4 h; I" _0 s
0 S! Q/ E- M! [2 `
################################
, g% T$ X5 ^) F4 Z) Q
##### Connection and Post ######
4 g1 x; s5 c4 j8 w+ y1 W& h) }, l9 O
################################
5 f. M s( E+ W7 h. Y5 C
$name = @$_POST['char'];
( F! H5 L3 u& n, L$ @
$ItemName = @$_POST['item_name'];
7 H0 V [/ }, l+ G# _
$ItemAmount = @$_POST['item_amount'];
9 g- y9 N7 C, ?% o( A
$ItemId = @$_POST['item_id'];
- A: s0 U8 I0 q- \) M
$ItemUpgrade = @$_POST['item_upgrade'];
$ t* Y9 W8 \3 n
$ItemElement = @$_POST['item_element'];
, x$ U' h3 `' M/ f5 Q V
$ElementUpgrade = @$_POST['element_upgrade'];
( T3 h/ X t! S( R+ |( X
$ItemPierce = @$_POST['item_pierce'];
% J9 k" X% z. @! {
################################
7 S! J4 n5 N% t1 h
' t2 T: z, O4 n S
//Check both variables for empty value
5 r# i: G* n; }( e; ]
8 g* c# o% |7 S3 H/ V6 X# p
if (!empty($_POST['char'])){
+ `$ ^ n9 y* g. s
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 p! ^) E$ O( M( X7 Y% @& T% G
* Y% F; `2 x) ]
m_szName = '{$name}'");
2 c0 ?% f7 t6 S* O# J) C
while ($row = mssql_fetch_object($find)){
, i2 G% s* G7 [8 h6 w0 z1 }
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# f+ h* s0 k( s v
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ I+ j3 j Q, s0 f# E. _5 k7 ^
0 P; B$ d- f, Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* u" y z" M& ?+ |. ^& P& g" ]1 Q
( X/ q, F% U( O9 U! }9 }' }& G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 L6 U3 _7 z3 w* o- x/ \' h/ w6 u* \/ Q
6 N& m% h/ H, w5 @2 s: R
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: t1 h- j l$ n2 z; N- f* p' J
A6 _2 ]+ K/ j, g ]
'{$ElementUpgrade}', '{$ItemPierce}');");
3 q }! ^* e$ L1 q
}
& c( n7 s8 R8 ]6 [$ a1 x
' L6 v- x0 I( n' @
}
. F* D* r7 Q- R) ?/ M
" n* G$ i. j4 @4 O
}
2 m, w6 [! q/ L: s" c
" y3 J( s1 _/ Q0 b2 }" y/ R) @
$InitForm = InitForm();
1 R5 \/ ?9 e1 V$ A' z, t: ?
$Listener = PostListener();
; A0 ?' ~ q# b" {& v
- S$ k6 j$ A* v x
?>
9 J6 E. e; V# S# U
/ _, M7 S, e+ R% o
" w7 F# _0 U+ P$ j9 j7 z9 o0 W0 w
) f# ~) M; P2 g' y
: D9 A, @8 H" @9 G5 B4 @+ L
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2