飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ ~% e; c/ H4 H4 A0 B. d
function Connect () {
* E0 p2 L7 l- n8 Q* e$ P
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' D. J) P: R3 j( J" q
* o; }: [3 @- |4 g
Failed.');
0 ^$ A# ^- o; r0 `: M
}
, N+ C z+ ? d7 c+ m' G/ T2 d4 l
Connect();
5 Q% d) f/ D+ ~) n; g2 A
* k0 v- z. A; a9 B
function InitForm(){
1 }3 \: `: @" ]- O
//layout for the form
" g% j% q# x" D. j) u
echo "<strong>Send Items.</strong>
: I+ Y6 o3 |) P. D# W: J: }
<form name='select' method='post'>
$ H0 L5 m9 j, ~" X4 S+ F
<lable>Character Name</lable><br/>
) |+ Y2 x$ O; _' \! e6 c% Q
<input type='text' name='char'/><br/>
3 `1 w7 [6 J# J6 i8 Y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 s. a: l, I. n, {; c4 y
<input type='text' name='item_name'/><br/>
! }8 t+ R* g& u
<lable>Item Amount</lable><br/>
2 n. b5 x0 A5 l
<input type='text' name='item_amount'/><br/>
, u$ p$ R8 G: C, \
<lable>Item Upgrade Amount</lable><br/>
- o" q& B% g9 z9 T1 ?/ s
<input type='text' name='item_upgrade'/><br/>
# O$ A4 Y' }6 g, f2 Y5 Q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( T$ U0 E/ d: k7 z
* Z' _- m+ M$ s* e% o& g
</lable><br/>
0 g; Q2 F3 J' c/ n
<input type='text' name='item_element'/><br/>
- Z6 D. d5 Z7 ]2 e% U
<lable>Element Upgrade Amount</lable><br/>
) }/ z4 k, w' ?" w- z
<input type='text' name='element_upgrade'/><br/>
4 x% ]" Z' L& l. z& v) L
<lable>Pierced Amount</lable><br/>
# e( B# A& ]" @; V% ^
<input type='text' name='item_pierce'/><br/>
5 O- j `- d7 o6 m+ P
<input type='submit'/>
3 i. i! X" l6 }
</form>";
( }2 y. e+ o+ \$ @1 p: R* B
}
1 [5 d7 M6 k1 N/ F# F$ b
/ D; P _( Q- ^, m1 d2 U
function PostListener (){
( u! h) F) R, G* S4 u! h
//Add more post variables if needed and add them to initform() function aswell
3 p/ p3 \6 Y0 `1 i+ N9 @ w+ z
4 I# E9 V! q$ c4 L* N6 V3 [+ H7 g
################################
j9 v5 h2 g6 Q1 n1 W
##### Connection and Post ######
9 u. u5 \# b* E. h
################################
1 p, f" z5 c9 K
$name = @$_POST['char'];
! U7 C, |. w7 A' ^
$ItemName = @$_POST['item_name'];
) t; `1 c5 k. n9 @
$ItemAmount = @$_POST['item_amount'];
3 ~1 g/ V& [& t: S* k
$ItemId = @$_POST['item_id'];
8 F+ G% O8 u- F" M
$ItemUpgrade = @$_POST['item_upgrade'];
- }% p! a9 u$ K; j ^9 p
$ItemElement = @$_POST['item_element'];
, I& O4 N. a0 ~: d' x! f5 ]
$ElementUpgrade = @$_POST['element_upgrade'];
; E* c% X/ S! p- q- g" `& f1 s+ Z% l1 q
$ItemPierce = @$_POST['item_pierce'];
( J" s3 d0 `4 C, C, a0 V: E, m
################################
. b2 u6 W& O/ T; k, W7 }5 F
3 l; N* d8 H' U6 F) Z6 g# M
//Check both variables for empty value
, `2 a! Q* G! Q0 r& |
; B0 T( J7 [! \0 W
if (!empty($_POST['char'])){
7 h# t4 d7 U' j
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! u& _2 v' ]7 o; d! D1 P- m
/ a2 o" [5 u& @, z* Z% d
m_szName = '{$name}'");
" K$ n+ V; q" W; U2 F" X
while ($row = mssql_fetch_object($find)){
0 K- H, X% a! B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& a/ T# Q1 u8 u/ R2 ~
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# `$ [% z" ?) c4 Z
+ |$ f: w! K/ d9 V4 z; ^. R' C
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ M* o# ]9 M% R+ r( i
6 g4 z- H+ w) n9 Q6 M% e
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ ^& r# m* T) C1 h/ G
) G& S3 u$ K! m3 Z! a
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! k# c+ ]4 m S
. p" H- e) u4 Y9 T8 i) e& u# p
'{$ElementUpgrade}', '{$ItemPierce}');");
! y( x5 F2 \# X2 j: ^
}
0 ]; I2 L# D/ l
6 }' Q- R% c- t( N& ^
}
1 q4 l) e5 j. T7 s2 H
0 }2 N! R* f5 @7 f4 I. m& X
}
& ~; \! A4 e4 B8 `" K7 G! y
+ v9 @4 y* K/ |+ C
$InitForm = InitForm();
3 J. p: b9 i( H. U
$Listener = PostListener();
8 _7 T) ~7 U% K; e
3 e! S2 {9 e2 B: R9 O
?>
! M0 F$ A- n) S) d9 x+ B0 _- K
4 c/ U3 [' I% h% e' P0 D
4 o; d- i2 ^2 [1 e! E* \ N
, R! ?4 c% x3 p' M
3 |" \4 T3 ^4 E$ p- ]4 j# v
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2