飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
3 p1 ~! u; u( ] Q' W
function Connect () {
" g4 {: L( m% ~
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 n5 g% l- n7 |* f C5 V( s
; _( c6 ?/ [* t. a& }0 q
Failed.');
" u6 t5 n+ n4 F5 T- k% z
}
0 Y9 E# S4 i: n; K
Connect();
& @+ T( l/ Z2 p3 {3 a- W
2 K- i6 R$ r5 W% f* Q+ X
function InitForm(){
5 @0 X0 m2 x7 z
//layout for the form
, p7 P! [6 m c+ p
echo "<strong>Send Items.</strong>
' N3 a# a2 w0 G. m* y# J, O* P/ \4 j( Q
<form name='select' method='post'>
5 c, C: G8 q* ?3 y; T9 _9 \
<lable>Character Name</lable><br/>
# T* l* m: I* w. n
<input type='text' name='char'/><br/>
% D( B% i6 m2 A# Q7 Q1 k: U* g# X T
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, [2 B, `7 J7 o% g
<input type='text' name='item_name'/><br/>
+ [! C: k2 d( _, L4 r' N/ B
<lable>Item Amount</lable><br/>
8 J- q: K/ Z( t" @; n
<input type='text' name='item_amount'/><br/>
: [6 o0 K6 O9 ~% ]
<lable>Item Upgrade Amount</lable><br/>
" ?1 O' a8 N9 z
<input type='text' name='item_upgrade'/><br/>
( Z/ M2 u. g- z3 |. o4 a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 `/ z" X* Y6 U7 Q0 l; _
n6 W7 S# P/ _
</lable><br/>
# E# Z% f1 |. [0 ]
<input type='text' name='item_element'/><br/>
/ @! E1 `6 l$ _, y! |" u/ P
<lable>Element Upgrade Amount</lable><br/>
5 I3 E4 R* T* ~# O4 D
<input type='text' name='element_upgrade'/><br/>
3 T) X- p V7 W& }: e9 K6 T- G* Y
<lable>Pierced Amount</lable><br/>
5 z, ^( P1 t8 `: U
<input type='text' name='item_pierce'/><br/>
$ g% V5 z7 k% q( {, q2 W+ X3 e/ Q# ?
<input type='submit'/>
5 Q; ^/ o) k( H% t
</form>";
c6 k9 L" j$ l/ G
}
3 n+ H( s4 [( l
" }, T. _7 {& X' f1 w7 ]
function PostListener (){
( N' E) @' t L0 p
//Add more post variables if needed and add them to initform() function aswell
, v4 w& z3 o( j" V
9 i7 ?$ D, }- M& ]! A: M
################################
% f" f, j5 [1 P! I' G9 E
##### Connection and Post ######
; K. H* M' d) }5 ?
################################
0 F6 N, T- c. K8 L1 J% s6 q6 \- d
$name = @$_POST['char'];
7 A" {/ V0 n7 z6 S* \1 g1 f
$ItemName = @$_POST['item_name'];
" ?$ a0 m. ~% }) m0 ?- k7 {9 x
$ItemAmount = @$_POST['item_amount'];
& X& x. R8 N1 m4 W8 d
$ItemId = @$_POST['item_id'];
+ k- j( t& ]5 W% m; t# k
$ItemUpgrade = @$_POST['item_upgrade'];
& S1 X3 K: T4 J. \
$ItemElement = @$_POST['item_element'];
2 f' h6 u0 E" _& p
$ElementUpgrade = @$_POST['element_upgrade'];
6 ?8 K- O9 m6 ~ _8 N" a6 Y$ Q
$ItemPierce = @$_POST['item_pierce'];
" C* U) C; u2 p1 U! C8 ~$ t
################################
" p" q0 ?' y* v ^
: w- x, H- _ n' i2 S. w
//Check both variables for empty value
: i% P7 p( ` Z" c/ V. l0 T
4 I. c) d( }7 q
if (!empty($_POST['char'])){
# ]0 v1 K( {3 b4 V
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. N# m' u! }# g( G, h+ X
' J. E% m: w. E& e& V; D
m_szName = '{$name}'");
: y6 \/ S- s4 k; [7 v
while ($row = mssql_fetch_object($find)){
3 N" u# B5 o% R2 E
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 G0 p4 b& G% Q- {0 N7 T1 f/ Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% W+ L, A$ b4 U9 y
" e% }( k6 F5 n, P; e8 [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 T+ ~7 H' Q0 a" S2 q3 h
( I: X7 U# M/ t3 m, X6 B
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) }- r. M; v+ \9 h
9 e, J) _% T X$ p% V0 {9 w1 T9 d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( X7 e/ u9 b. i# \/ C3 r
& d" ~: H* D; G7 {0 U+ O
'{$ElementUpgrade}', '{$ItemPierce}');");
+ T& G" F, u; F0 \: k% w
}
* X4 l [. y( t9 y/ g) r% h9 T
9 v7 ?+ C" z. Q+ {& M d
}
8 A- I, H L; R3 ]9 k
x6 h: r- }# d1 K. Z
}
+ ^4 m k% @/ C8 J5 \, p3 B
2 F5 g5 W* \! l: p( z4 Y0 f
$InitForm = InitForm();
5 U0 j; j1 l0 ~& ?* T; G
$Listener = PostListener();
8 u" P' ?8 S9 T% O/ s/ V1 s
* o' f1 e* ?. o0 k5 J
?>
3 N- {$ ~) a0 ^, k+ y" q" h" U
9 x3 ~& _1 q/ L# \5 [: W
2 D6 k6 @) y- V$ S5 e" \- B1 ^
4 _% M/ N/ E$ Q- x
# F, b _! I* q0 M8 u1 w
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2