飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
. F7 _- |% a' `& S
function Connect () {
9 Z& u( _4 K' `% ]4 U# V3 E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; ]4 J6 t3 i' p. X+ C
( C8 H, x' S4 q' d3 f
Failed.');
" ?; A h; C& r3 n
}
. }( X- V- @: a
Connect();
5 l! m3 f8 ?0 ]
, K3 v- [; J$ M0 D! h( n
function InitForm(){
2 F/ V! i" e9 S8 _; q% G9 l
//layout for the form
S9 B) y' W1 w: j! x
echo "<strong>Send Items.</strong>
5 @* Z+ M+ n0 A* p. e* ]
<form name='select' method='post'>
2 V6 J% r1 @( K( f0 O4 o' k
<lable>Character Name</lable><br/>
- `$ x3 R l" K" u. p
<input type='text' name='char'/><br/>
; e$ b+ Q+ U( ~! y4 o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, w+ _7 T% ]" o0 Q% G: t
<input type='text' name='item_name'/><br/>
5 a) [6 @4 O: u$ O6 `/ l7 v* W: y2 w
<lable>Item Amount</lable><br/>
4 _# }" Y% L2 w( @
<input type='text' name='item_amount'/><br/>
, r& X' W& K$ o/ E, G: ~; J
<lable>Item Upgrade Amount</lable><br/>
, }% a* f! M5 X9 g6 g7 j
<input type='text' name='item_upgrade'/><br/>
D' o& z7 b/ t% f( `2 Z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) S# ^. k$ g6 v
& |* e+ n; Z( Z" s3 @
</lable><br/>
4 M$ T5 r @: k4 l$ [
<input type='text' name='item_element'/><br/>
- r' \! p W, b/ H& G* l F8 l
<lable>Element Upgrade Amount</lable><br/>
2 {4 ]: j0 h: w+ C
<input type='text' name='element_upgrade'/><br/>
+ L, q6 t& n4 R9 S3 I2 B7 b
<lable>Pierced Amount</lable><br/>
9 {8 E- a% l& _) W
<input type='text' name='item_pierce'/><br/>
4 v9 n2 t) }8 X/ D- f+ y
<input type='submit'/>
0 C: R1 ?: s2 G$ E9 I1 R
</form>";
' x* d1 o! [! _7 g: h
}
, X2 `2 S- V' L/ Y, V) z
9 ~; Q& L3 E( s) r" S
function PostListener (){
4 U+ ]8 a" x) {! f6 R& V$ A6 C; f
//Add more post variables if needed and add them to initform() function aswell
_! R" l7 J/ T- M7 ]9 x3 c
* L* J6 Q* }+ ^8 z
################################
# y7 o& d4 y2 B0 ]( n. }5 ~7 W3 [
##### Connection and Post ######
7 H6 j0 L+ S. q: U6 s
################################
1 ?5 ^: m$ }. {8 C0 s
$name = @$_POST['char'];
/ [/ R% g2 R8 ]. s/ g
$ItemName = @$_POST['item_name'];
. r5 o6 t6 r5 u8 y7 g& O" Q
$ItemAmount = @$_POST['item_amount'];
; G2 ]3 \3 B. B& O/ T; t- h6 ?
$ItemId = @$_POST['item_id'];
8 G6 A( O* U7 X- J
$ItemUpgrade = @$_POST['item_upgrade'];
; a C6 n3 |& m* p0 k( [
$ItemElement = @$_POST['item_element'];
0 o4 D' V7 e) [$ h M$ A7 v
$ElementUpgrade = @$_POST['element_upgrade'];
; U; h. h) b. W' }$ o+ O
$ItemPierce = @$_POST['item_pierce'];
1 q1 p U& O1 _5 X
################################
4 E. o- u" J9 B3 b
$ |% e7 P) A7 l8 O1 h: ?8 H# g& {
//Check both variables for empty value
2 v* \) s( {9 P# e( }% b
3 Z+ o' `4 T1 T! I" E# Z
if (!empty($_POST['char'])){
2 z+ D5 ~; X7 t5 F; N% a2 z. x5 F5 M
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- E2 ~" s- s2 r' B v
?1 z) u3 \& [ m
m_szName = '{$name}'");
/ w& v; x: F3 Y6 ?. i
while ($row = mssql_fetch_object($find)){
( R5 h3 p& B9 ~
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" X' [8 I; f+ N: R, p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 ^7 E# F# r6 S8 t# h/ @
% i+ X1 {5 i: X9 V$ K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. Q% a% Y# b* i4 |
$ ~. q4 p5 I5 _/ m: C5 B
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! J2 J% Z/ k) W& v3 u; b8 c
; C' _5 F: g# M% n% H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! G2 v, Q, `! n. N# l/ u
! ]- [+ L- \/ }0 H# E% e5 C9 Z( z
'{$ElementUpgrade}', '{$ItemPierce}');");
+ C, x* t8 n* c2 w- M
}
. H/ L" w& M/ k9 R, Z+ i
! ?; J: r* g4 k( J( g. L) T; J
}
! f6 r6 C- O5 S4 x' u' v8 e
2 W7 p0 i, a3 r' \5 u
}
! x7 j( }% M* L P0 ] r0 O+ Y! X1 v
& ~( [! q' d! Q7 b4 H2 t8 ? [
$InitForm = InitForm();
- `: m2 J- j/ \& C4 l1 m* V
$Listener = PostListener();
$ L( E# C: A: y! {0 o9 [0 o
, W) k& i E7 O0 \
?>
8 U0 O7 ~7 \" \* }6 q, G( m# T
0 u( j: u3 q! O# g' w0 Z
6 ]. H3 [' f) Z. `# q+ }
8 T" e1 {1 x% ~0 {
0 I- }+ M, P2 C6 E4 G9 A% V2 z
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2