飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
- D& t4 v7 H8 T8 ^5 a1 g s
function Connect () {
6 X7 Q1 x) d1 R" Z
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 }3 X; y, D( o
4 q! ]$ Q& t2 d4 p J! q
Failed.');
3 E; ?9 v! ^7 W! O2 [" V
}
6 y1 z3 P! n) T; j6 k/ V7 a% [6 \
Connect();
. Y; ^2 L- }4 ^1 m8 y- s' I) C" m
" N/ r& V+ F% P0 g) A" j2 v; r* j% R
function InitForm(){
9 }9 R+ K+ b% ~
//layout for the form
4 ]' b, {5 p$ y" d. H
echo "<strong>Send Items.</strong>
. F5 A7 E4 V. G' L3 p; d
<form name='select' method='post'>
# l; A9 _ u- m* I
<lable>Character Name</lable><br/>
: w" n/ f" Q' I9 }, A5 `
<input type='text' name='char'/><br/>
% d8 l! {+ ?1 y6 c, j
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& j; |" w k' S4 ~3 P& E5 i9 h$ X# c
<input type='text' name='item_name'/><br/>
5 {5 q, D3 ] ^) b7 ]' l x2 \3 n
<lable>Item Amount</lable><br/>
4 C* n* e/ {. ~" |0 @) c |
<input type='text' name='item_amount'/><br/>
2 G/ c" o! r! O" d k. }
<lable>Item Upgrade Amount</lable><br/>
. [. z R7 s L: V
<input type='text' name='item_upgrade'/><br/>
" e# n. }; K- I$ M
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) `9 Q1 E7 u) M/ w
; j9 |6 E( N0 C! m
</lable><br/>
r4 j) f% [5 x
<input type='text' name='item_element'/><br/>
2 S( `; f( ^# W) z+ F5 Q
<lable>Element Upgrade Amount</lable><br/>
1 n; Q' G- F# ]7 y1 l* V4 ]( J
<input type='text' name='element_upgrade'/><br/>
5 V2 u9 u/ ]& w3 o7 z7 b/ ^
<lable>Pierced Amount</lable><br/>
' V0 _9 v" @/ f1 f
<input type='text' name='item_pierce'/><br/>
& p# f/ q. e' s0 A/ u' K3 B' q
<input type='submit'/>
% x% ?! j$ d; V0 _& F' K0 [* \
</form>";
4 |: h Y" ]- E3 |
}
4 U4 z' g* g' i* ]8 r1 k
$ ]# r& k5 N4 {4 X7 Z
function PostListener (){
6 I1 w4 Y: ?$ _* d2 H/ _: O
//Add more post variables if needed and add them to initform() function aswell
- ]* p" q) Y) e! ]9 g' e
& c: d: H' e' v. n
################################
& n$ t0 U! U/ U
##### Connection and Post ######
* e+ Q' p1 ^; }1 E }# r1 e* V8 }7 f
################################
. K! r6 q" o) N; H& i; f/ ]7 x
$name = @$_POST['char'];
$ g% B' Z! y8 d+ p% c; K
$ItemName = @$_POST['item_name'];
. W, ]1 X" t7 a6 C
$ItemAmount = @$_POST['item_amount'];
& R4 `4 e$ f/ G. |; |9 J5 G; A
$ItemId = @$_POST['item_id'];
8 p' m! C( n+ k9 N9 |' a) s/ E
$ItemUpgrade = @$_POST['item_upgrade'];
4 Z" R# W0 `6 J
$ItemElement = @$_POST['item_element'];
% b0 w1 j" n: Y9 {
$ElementUpgrade = @$_POST['element_upgrade'];
& _7 n0 a4 x* n4 `9 J: Q H
$ItemPierce = @$_POST['item_pierce'];
* W+ j. p) P" u) L8 J/ ]
################################
: t! N5 R- P% @
- P% ~( }" U5 U
//Check both variables for empty value
" A5 a! W% h7 J& L7 \; P2 k
7 |$ V/ w3 G1 y# {% ]* O
if (!empty($_POST['char'])){
2 [5 @/ @/ @+ ~2 b/ s2 [0 ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 K5 `) k( d7 _* P
5 g" R s" n" t9 k$ L
m_szName = '{$name}'");
. z6 E1 c1 P: T
while ($row = mssql_fetch_object($find)){
( A, o+ t5 l! n- a; ? k8 c, E
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 i: ^: p8 \& {7 E1 D. I" ~% e
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ f: B k* ]* O8 {# }
+ q' C' y% T- s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& z6 L( z7 D' H0 V7 d
% n$ I& ~( r. H `& A
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ q* S1 Z% } ?& ~, `
; P# t! i. R k1 i; Z$ \
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* X/ C) A V' q
8 e9 P t+ t! E3 ]
'{$ElementUpgrade}', '{$ItemPierce}');");
+ B, {( x" x9 W& K. [( P o8 b, ]
}
$ q: Q4 K' {; n' t" G1 K
& W- p8 V* F' H- t# A; O6 t
}
% g& H* G% z! g' e& N5 U+ L
& I; m5 c& p0 r$ h" D+ }: t& B. R
}
! N9 Y) R g! R5 Y! Q) w3 M* ~$ M
& |$ q+ f& j" T! v9 S! Z
$InitForm = InitForm();
9 w; l7 [8 j/ K0 W0 z' g' Q
$Listener = PostListener();
( W7 W# R3 W0 C8 t" X, a9 R
$ i. A, h: }1 A; Z% t1 H0 R
?>
5 J8 S( a! a. X! q* ]/ {
! q3 Z8 l0 Y* r4 ^
2 [) H* e2 K0 F4 K; i
: m+ x4 l: y5 Z; `9 B9 A
& {7 }8 C/ C' a' W5 Z
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2