飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
: S* Y1 Y/ z" G+ C5 @6 \ u
function Connect () {
G: x, A5 ]' A# \8 ]2 j4 E9 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 M7 u/ V6 y% F5 d% B- y
/ ^2 T/ B4 J b( n
Failed.');
2 L* F; Y8 r' l! ] G
}
$ x/ V' Y# t/ k0 j
Connect();
1 t1 W! L5 i+ C; Y2 O0 W
( I6 Y0 Q, l/ l' G; E0 \
function InitForm(){
$ ?# A1 r# y* S+ D5 N
//layout for the form
$ K8 L# A0 N r
echo "<strong>Send Items.</strong>
6 e7 @# u, q4 Q1 `+ X4 @
<form name='select' method='post'>
# c& r. h3 G9 p
<lable>Character Name</lable><br/>
4 q- C! G( A" ?. C" F, h8 D
<input type='text' name='char'/><br/>
! ]; h9 a Z" s- [: z# h* v
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 o2 w7 c. \& \0 s
<input type='text' name='item_name'/><br/>
$ X9 b$ H7 x" }9 x' _
<lable>Item Amount</lable><br/>
$ a7 Z4 Y1 G! o( d
<input type='text' name='item_amount'/><br/>
) {0 l3 l, p/ X) s3 T- R
<lable>Item Upgrade Amount</lable><br/>
/ v2 X0 O% w1 c. A, F; g3 ?
<input type='text' name='item_upgrade'/><br/>
) `8 F; _4 Y+ F2 F7 m7 A; h
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( ~1 F7 T1 m6 W
& l) b0 ?" ~& ^1 L5 u( L
</lable><br/>
$ I4 U$ @6 t1 {0 r4 O
<input type='text' name='item_element'/><br/>
: m6 H) d& }' {7 f9 h7 O& i
<lable>Element Upgrade Amount</lable><br/>
, d% ?! b/ k' A: e
<input type='text' name='element_upgrade'/><br/>
4 W- T* f# \7 @# ~, x( I
<lable>Pierced Amount</lable><br/>
" n% M: ~+ ]# k
<input type='text' name='item_pierce'/><br/>
' D( G! e. J- O; @! B* _- u
<input type='submit'/>
3 [2 G+ E2 C$ R# v- u+ c7 S" A
</form>";
$ A: C: O& I1 ]* u) |
}
' X& H/ B" e; m6 c4 Y8 E
$ p6 P2 u ]7 y8 B" ~
function PostListener (){
1 U$ @% ]3 r; g6 O
//Add more post variables if needed and add them to initform() function aswell
/ I" L/ H. M6 m9 o j
& h4 G. N. p% C+ J
################################
2 j0 y/ P& d6 R" _. r" r) d, u
##### Connection and Post ######
. M: v* F& X5 r* _9 e3 k/ `% x" X
################################
% z5 o7 d' I" s: m% j# m
$name = @$_POST['char'];
8 h7 O2 n* u' _1 R* U, i
$ItemName = @$_POST['item_name'];
4 P$ y) R! X7 o# { m
$ItemAmount = @$_POST['item_amount'];
6 l$ h! r# t- w/ {: n1 ?
$ItemId = @$_POST['item_id'];
C9 V; p2 i4 R8 S0 O) F4 l
$ItemUpgrade = @$_POST['item_upgrade'];
; b* z$ }6 X! @2 O+ [
$ItemElement = @$_POST['item_element'];
; G1 V! P( ?& _, p- U$ c
$ElementUpgrade = @$_POST['element_upgrade'];
# _& w% s0 |7 n# I. Z% K- ?+ Z
$ItemPierce = @$_POST['item_pierce'];
$ x% @0 H8 P5 M! _
################################
2 X! X- i4 m3 }6 r) Y: R s/ X
+ X W/ x# W4 `
//Check both variables for empty value
" h& q& R: H8 a& k h+ {2 i
9 p* [0 m& s* \ l5 G) G) r/ Z
if (!empty($_POST['char'])){
( f9 B; u7 ?6 K' G; \: L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
. m5 n% ]! l; q: f, f
% X( |( w6 r0 T# \1 b/ x& A1 z) \
m_szName = '{$name}'");
: ]' g! H7 e+ L" ^' {! @/ w
while ($row = mssql_fetch_object($find)){
7 P9 P# n' B. x0 g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; ^9 k$ b) h* i2 v" R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 S( ^ V% \" w" E7 j- t, R9 j e
4 H. E# ]1 i) T6 J
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% B( n A" m# b9 a
; Q6 s( }8 O$ j- w+ y( B3 i
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: Y8 w' z) V- s" y
0 Y+ H3 w3 u7 U r) {8 Z7 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 [; r- k& B1 t- s4 r0 ]. Y
. X6 f2 c1 u: P0 A6 G5 g
'{$ElementUpgrade}', '{$ItemPierce}');");
7 h" {, i M& \/ t$ u% o; N0 O2 _
}
' W; M: U# H1 _7 Z0 i9 R5 {
7 }; e9 A9 }, d; S8 U0 |
}
: l( [! t! Z5 W
$ |5 r: C6 Z) J5 z2 `
}
0 P$ c! Z% c8 ?& o
( P! w$ m- n: l# D9 C5 p3 W
$InitForm = InitForm();
. S- D l) u: j' g
$Listener = PostListener();
) F8 r5 d) d/ y7 b
6 M2 d; k4 U) Q- N4 g+ m% w) b
?>
. s( x3 N; z, e& W4 E% L) c
9 w1 f' i* |; C" n+ i9 O4 Q1 W- g# ?
5 a3 U$ @1 o& y6 k
8 m7 v2 L9 w" c9 x9 p# P
* M8 F+ r5 A, C0 Q, e5 _
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2