飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
7 F& k+ E1 x; O# ~
function Connect () {
" `& u: A( P! U: a" k. D+ W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; ^% P3 m- _" u- c/ d; A0 J, Z5 O! o5 @
: d$ X: j1 j: `. E
Failed.');
4 T E, ~$ f% M( T) k8 G
}
! E! ]+ J$ w/ ?5 e
Connect();
- B" v( G! k' C2 O' z
) [. q1 j- u* X- k( e6 ^
function InitForm(){
+ M. }+ s+ \1 v+ G
//layout for the form
3 m9 z% N4 D0 j+ p5 g, S. S9 G" Q7 ]
echo "<strong>Send Items.</strong>
% ^& g' p2 d7 r- Z
<form name='select' method='post'>
# u, d* A0 N7 i
<lable>Character Name</lable><br/>
! Q4 |( T) s' W" g0 f& ]
<input type='text' name='char'/><br/>
) L4 M5 w( z% A
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) d! W& |, s% X+ _8 D( q k$ n1 K
<input type='text' name='item_name'/><br/>
) O* P; i2 B$ B- h
<lable>Item Amount</lable><br/>
! J) V7 ?% Q$ Y4 z+ O- I
<input type='text' name='item_amount'/><br/>
% L3 D. I, @0 Q8 W8 [7 D
<lable>Item Upgrade Amount</lable><br/>
$ _' r# a9 y' t5 l5 T7 M0 }; N
<input type='text' name='item_upgrade'/><br/>
1 r x, V7 D- M P
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' N% v; ?4 g/ T2 S/ i+ Z
! S H1 m1 g' o) U( s' z+ r
</lable><br/>
% h2 I! |: z5 E! z1 l# {
<input type='text' name='item_element'/><br/>
% `5 I. V- W9 \' N8 t3 S$ U1 N
<lable>Element Upgrade Amount</lable><br/>
+ m$ O. E @% k9 }- x
<input type='text' name='element_upgrade'/><br/>
3 ]1 p7 G' e2 ~8 W2 s. Y
<lable>Pierced Amount</lable><br/>
3 x2 U& U( l5 x S: @ Z- `- N, @
<input type='text' name='item_pierce'/><br/>
|) z3 B0 _2 y% F
<input type='submit'/>
u. i8 X& S# l$ A
</form>";
/ K2 K6 x2 L/ p3 f8 b
}
6 f/ R% ]0 A& O" j
+ D; {" z( V, T. r. Y
function PostListener (){
1 W0 K! Z* D$ @ n; \" N: y
//Add more post variables if needed and add them to initform() function aswell
& g/ @, p$ x% t- h& x8 @2 w
* }& J+ L) R: b4 J( a! ?
################################
# O6 H. i _* X
##### Connection and Post ######
& Y, c- z3 _4 D( H: [4 S
################################
8 d+ o. R1 d% l% E* E3 m; w
$name = @$_POST['char'];
0 W5 L, j7 L9 s! \, S+ x& y
$ItemName = @$_POST['item_name'];
: d5 v/ d1 D( I9 |1 \
$ItemAmount = @$_POST['item_amount'];
! i4 n) g! r+ o, F' v
$ItemId = @$_POST['item_id'];
0 f7 r$ f. v# R1 Y( V0 \
$ItemUpgrade = @$_POST['item_upgrade'];
! y, e" B0 M. B8 y! I$ M9 e N
$ItemElement = @$_POST['item_element'];
7 w' M. |! L' o4 _/ Z+ S# ^
$ElementUpgrade = @$_POST['element_upgrade'];
$ @. {7 h* [' \+ d; c, s
$ItemPierce = @$_POST['item_pierce'];
# n% K, ^: q8 R; K+ u: a! H
################################
3 c* O6 n! J$ \- X! |7 i
5 ?/ w# s2 t1 _" }
//Check both variables for empty value
, f8 N, f5 H1 x" o
% N' D& r* a* e& z3 c( E- j
if (!empty($_POST['char'])){
5 \8 F7 q: _: _
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 V' P0 t4 k; E H
' ?1 L3 S% {2 f, u6 k$ W
m_szName = '{$name}'");
2 I: n! @4 N/ K( ~/ Z" ~
while ($row = mssql_fetch_object($find)){
3 d: X, _% z) s% J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 k0 Y+ e: ^' K }6 x, U+ o% ]
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 n X h9 b$ i. }& [
1 t' p+ |5 i `0 b6 o
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! l/ O3 q1 e. g& z0 C- W
3 D8 K, p2 ?$ ]& M0 D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) b) k! Z& w8 u% D+ G& s3 Y
- |: x3 b( T, y x) x8 J
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ z- N6 q G, X( x2 h
$ P5 ^- r1 X$ y1 d( r3 C
'{$ElementUpgrade}', '{$ItemPierce}');");
7 r) H# D+ v* ^, t+ m
}
6 Y& m! ^/ Y1 s" M8 H6 y
1 p4 x: t. A1 G" D) s
}
' ]/ u4 x8 g. J( W
" W1 g& }8 e9 S; S; R* ~
}
, h# u3 g) R" q$ E
0 b9 @7 J& G( a1 D! L6 f+ `
$InitForm = InitForm();
6 R( p D8 F7 J. y
$Listener = PostListener();
" {4 n z4 `; g6 g" N
9 L+ j& I+ T) w3 k& ~4 H' N4 Q
?>
1 q+ _/ b; N( c ^7 f
% o' ?+ R# `6 E4 O
+ S" q4 A' P+ c, ?/ n
0 g B) u$ l0 H4 k& I
- \' Y7 o$ l' B
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2