飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
& d: ]* m3 i5 C
function Connect () {
$ b* A* P* o/ r
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- a' l8 G: ~: B7 V
5 [; Z ?) {) L" S! c3 m
Failed.');
$ U/ l8 W" Q" u( R, u: r5 n0 e4 \! o
}
, s/ z5 z. Y0 L' Y h( l0 s9 Z
Connect();
f1 N# m4 t0 h4 f0 s) k
+ W! O. P4 ~" l' y- n
function InitForm(){
$ Y+ S C# _+ `6 ^! u; K5 I+ S/ ?1 s- r& I
//layout for the form
' c" r& W3 d M) @; J( d$ w+ y
echo "<strong>Send Items.</strong>
1 T: r$ ]* y; j
<form name='select' method='post'>
. k% S* Z* i, f$ d
<lable>Character Name</lable><br/>
1 |9 ?6 i+ g; f8 b
<input type='text' name='char'/><br/>
; K1 N4 V* H% }7 v; C) S# j* g) ^
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ B8 G1 z9 ^" M% K
<input type='text' name='item_name'/><br/>
9 {6 L/ g9 W& V, u8 [1 I
<lable>Item Amount</lable><br/>
4 r1 x: s$ }! c; v
<input type='text' name='item_amount'/><br/>
+ [" K2 d+ e# L) M
<lable>Item Upgrade Amount</lable><br/>
# @! S2 h5 Y3 n3 s Z' U' Z; t( ~! S
<input type='text' name='item_upgrade'/><br/>
$ c& |3 L3 n; ^) L2 A
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
N: `) t. W9 Z# _
+ `. F: C# R5 h- ^# ]( f* c* f
</lable><br/>
w4 n3 a9 i6 Q" N
<input type='text' name='item_element'/><br/>
% E C6 z4 s& ~; _ J
<lable>Element Upgrade Amount</lable><br/>
% n8 h" `3 p( a% N- b
<input type='text' name='element_upgrade'/><br/>
0 T! }' B* u: r6 ]! W- J% b, N& l
<lable>Pierced Amount</lable><br/>
: g/ M4 R4 b( G, \" W8 A
<input type='text' name='item_pierce'/><br/>
/ M. J1 }# ]3 x% ~$ w+ @
<input type='submit'/>
p/ f5 e7 ]' f3 f5 G
</form>";
, V: G* O0 H) F% d0 S
}
/ b* R8 Y: n' J2 m
. ^! K: D' ^- L/ N- n' u; t
function PostListener (){
% `1 H3 }# z% E( N. d a
//Add more post variables if needed and add them to initform() function aswell
( n4 b! k# |- K3 G. E7 F
# C3 x/ ?2 q0 _! A: Y0 q
################################
- x5 ~: R8 v8 L' Z$ I( n
##### Connection and Post ######
9 I4 Z( W# w: U# M4 W
################################
# |, h% x Y3 p) ]+ u' d
$name = @$_POST['char'];
+ B% ^7 T+ B, y1 r5 S
$ItemName = @$_POST['item_name'];
* _, |# B4 f9 z+ `6 w( t
$ItemAmount = @$_POST['item_amount'];
w# Y6 u. z( b- i% ?9 A
$ItemId = @$_POST['item_id'];
9 ^6 q- z" O. C( m8 Q5 v3 D6 {9 W, u. D
$ItemUpgrade = @$_POST['item_upgrade'];
* w% h2 g; L5 ?8 `: w! q9 G' ?
$ItemElement = @$_POST['item_element'];
- \* L+ `' l1 @. f q5 a& O' x: ?, d
$ElementUpgrade = @$_POST['element_upgrade'];
2 W% K: Y) d) {1 n/ i
$ItemPierce = @$_POST['item_pierce'];
$ h L/ E' ?2 ^; t% {+ b& g1 W2 a
################################
# y! \( S; C/ H4 a5 i" c
" A* a( Z0 r0 e
//Check both variables for empty value
' n3 d, G" d6 i
1 ~0 a# V& y" C
if (!empty($_POST['char'])){
0 [$ s3 ]5 Z2 W2 k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" p; o5 M3 R e
7 j) V* D$ }/ R+ k( J
m_szName = '{$name}'");
9 R: c7 D7 B9 V/ ~ ?
while ($row = mssql_fetch_object($find)){
! z/ ^7 K6 z8 U" j# t
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ @) l; E2 y6 u) j( L$ _7 s4 s# s
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, d9 }2 p- I& }' n
( w# g r) [0 A- [& O& v( w
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: @& t c$ A+ k3 k
; J. l: \- c9 @& i! Z* u. \
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* O! W1 Y2 r6 B" P5 e
% _# ?5 c, E" V7 K& U1 v
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ I9 T2 E( [3 U) H
" r- K* A0 _) x- k" }
'{$ElementUpgrade}', '{$ItemPierce}');");
^$ [* l, N ] L( M
}
* I& i K2 x, `% L4 c7 V$ Q
. A3 N- j6 R4 B ]
}
* d% q9 S: F/ A1 s
8 \, F+ U, K4 H- }* E; D& ?
}
9 E& E7 H" U- s V
# z; D j+ \1 F4 B
$InitForm = InitForm();
6 Q% D) d) N- h. v+ _- X
$Listener = PostListener();
$ g3 E m5 ~. j4 j9 ]
8 u: Q5 q& e8 L( p1 V" W; m, Z
?>
* n! G- ^- @% _) ]4 a2 R' e
/ ^% C# Y, ?* j4 j H$ K5 o
7 k4 O' h5 ?) H0 E3 X/ p
& E9 L6 z o4 S% `; Z! [, T* ], i
+ R, _$ N, F& M
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2