飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ T& U4 F/ Z- `7 t. w& D
function Connect () {
; W1 W% _* U5 ~: Q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 L, r4 M/ m: C6 `
5 Z) o, c8 m& X1 v
Failed.');
: x4 p& A7 v2 Q8 I- B8 }
}
$ V& t! Q. U, U B4 z1 k
Connect();
- w0 H3 F2 |2 i7 p+ |
- y% u0 t6 v1 y3 A9 ?' H! ]
function InitForm(){
# T8 C" t9 `- w/ s
//layout for the form
$ u; _- J! t- b, J
echo "<strong>Send Items.</strong>
6 O4 ?4 X% b F) L1 |% e
<form name='select' method='post'>
+ a+ @. @' X. r8 L3 r
<lable>Character Name</lable><br/>
- {; g& `2 c' C* m; b% h( s3 Y
<input type='text' name='char'/><br/>
2 v/ R0 Y( E) y. F- s+ o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# ~* i" S4 s6 o/ u
<input type='text' name='item_name'/><br/>
8 W/ C* r, X" k6 ~% J$ g# j
<lable>Item Amount</lable><br/>
* u* Y; L/ x. Z2 G
<input type='text' name='item_amount'/><br/>
/ J1 Q0 A% B4 f6 ], q# c. [
<lable>Item Upgrade Amount</lable><br/>
) B2 t1 i& s- T
<input type='text' name='item_upgrade'/><br/>
; S7 E9 ^3 X7 Q6 s. r' S& V- m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" X3 U9 b* S- l* i+ Q: ?1 z
% G7 E9 i' x9 a0 _0 V9 r
</lable><br/>
2 p$ T, ~2 {& i' `2 f
<input type='text' name='item_element'/><br/>
. t/ V/ @/ U0 U( h* L8 E' K
<lable>Element Upgrade Amount</lable><br/>
8 A6 e0 i( q# v
<input type='text' name='element_upgrade'/><br/>
: r" q/ [2 l2 R$ [
<lable>Pierced Amount</lable><br/>
) Y& N5 ?) S/ a, y. I3 W2 d! d
<input type='text' name='item_pierce'/><br/>
9 d5 O! H% C( M$ S
<input type='submit'/>
- o3 W# t! a: H/ j
</form>";
* ~/ L: V2 E3 p9 [% S' `- p" i6 X
}
s9 ~. F( h, ?# l/ {9 g2 t
$ k- J# g- @1 O* ?' I$ ^3 g3 @' L7 V
function PostListener (){
+ P8 t0 L" a& x* u( R; ?# b2 P& ]
//Add more post variables if needed and add them to initform() function aswell
! _+ u, ^, L( |7 a9 N
/ H0 |$ X9 @! }+ k
################################
0 q0 e& {6 s4 P
##### Connection and Post ######
" r3 Y$ O( {5 u5 |( `
################################
. I3 f. ~; g/ R% J
$name = @$_POST['char'];
: g, O% F3 A& t( D& i# P' I# ]
$ItemName = @$_POST['item_name'];
3 c' S8 A( Q1 e7 A* V/ R# t
$ItemAmount = @$_POST['item_amount'];
6 }7 A: W/ l; [1 z) y6 f. w
$ItemId = @$_POST['item_id'];
5 Z( Y6 P4 c- t9 j4 b3 |
$ItemUpgrade = @$_POST['item_upgrade'];
s% ^9 s/ h6 e) h/ k, _
$ItemElement = @$_POST['item_element'];
x' y0 \ p- V- _! |
$ElementUpgrade = @$_POST['element_upgrade'];
& Y) V6 y: ]4 y0 z
$ItemPierce = @$_POST['item_pierce'];
$ ]% R# d* d2 k6 b" N6 S
################################
+ x3 e3 ?% O/ b7 N
+ t. ^4 e1 ]* O1 X% @# a
//Check both variables for empty value
# f6 W! u# k. n% H$ U. T
1 T# ]9 w: B) p( ?$ Z, }
if (!empty($_POST['char'])){
9 G1 d1 u; t$ B5 _
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 d( {2 H+ v& w# y
( l( l9 Z9 X- t \1 V$ X
m_szName = '{$name}'");
9 @, U# _( } r5 T
while ($row = mssql_fetch_object($find)){
" H/ w+ ^6 @& D0 _4 J0 @9 A d- d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ p/ a J) Z* {7 F% q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% t0 x3 q' Z; ~
2 J# \( w5 F) f4 t( U* ^
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 Y* g: T3 x, {
1 m( Z8 ^0 A* E
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 S+ d3 r! F# |$ G" u$ L
& h8 o% @4 d* c1 [/ B
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' y I4 T8 D" A& O/ O( u$ }/ T$ {/ \
! `: Y, N0 S% @
'{$ElementUpgrade}', '{$ItemPierce}');");
2 o2 i8 q, N3 k7 X9 c1 m' g/ v
}
: {& h3 C- |$ W$ C, C. _3 |
9 q7 x2 S- X% y; O$ z6 q1 ]
}
! x4 B' X4 d, i
2 b9 n! \$ P; z) M C7 i4 W
}
?9 W1 _! B: S' G1 @/ ?8 q/ V
- C9 s2 [9 d7 _6 ~! }+ @/ x
$InitForm = InitForm();
8 ]( {( l- s$ s- \* r
$Listener = PostListener();
+ Y) q; j& z, {. A$ f1 N; u; l
& \; @" y. i, [) T2 G" t0 M9 g
?>
! X: a: v* ~4 B% ?
8 A! ?* G* T5 M2 F0 c- D5 F& T
$ H. i* v$ f, S
* Q3 k! @) S/ C4 J- o% w$ N5 |3 I
8 q: L# N5 @& v! I
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2