飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* P! t n( j( w0 q; |7 l2 p
function Connect () {
0 O! O4 _2 x) B
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! w: W2 Q1 m. {! e% O- W
, N; F/ A: D$ P& l' t% h
Failed.');
$ E+ q* H( a1 W; n1 u
}
, M% O6 Z6 k+ h$ y" |/ t! z
Connect();
5 E, f2 D7 }0 {
/ ^) R' j% u5 S( B7 O, g
function InitForm(){
$ e( S2 Q l3 J% t8 V
//layout for the form
: B, r7 {7 R9 [) Y$ Q3 M7 G# H! v
echo "<strong>Send Items.</strong>
( R& z( Z, M; @
<form name='select' method='post'>
- ^5 t; e. g; a0 w2 O9 E7 _# e) f
<lable>Character Name</lable><br/>
/ T9 E* J, o4 w
<input type='text' name='char'/><br/>
. ^+ ~- H, w& i' ]/ e
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 A) g/ B0 c, {" F
<input type='text' name='item_name'/><br/>
' f# D% o& |+ |: ~& u
<lable>Item Amount</lable><br/>
7 P7 P; v( L$ X" c! ]) D
<input type='text' name='item_amount'/><br/>
: U$ b3 N# F9 k! @3 F' b
<lable>Item Upgrade Amount</lable><br/>
5 s8 ^9 a& ^* I1 Z
<input type='text' name='item_upgrade'/><br/>
, E% e; `& V+ _0 e W- x1 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- C5 l5 c3 V4 }" K L
! I# U! d# p/ H) u% C0 ^
</lable><br/>
9 ?* ^+ M( v1 |! p
<input type='text' name='item_element'/><br/>
: {6 V! @5 y1 I9 \7 q
<lable>Element Upgrade Amount</lable><br/>
, A: C' v- \4 O+ T: \. o$ ~! j
<input type='text' name='element_upgrade'/><br/>
/ n6 F) G) {0 `# Y
<lable>Pierced Amount</lable><br/>
6 U. D0 h1 h& ~) M: ~/ D
<input type='text' name='item_pierce'/><br/>
+ ?* l5 s; P- g+ s: o
<input type='submit'/>
j% w3 w; @: J) Y5 [
</form>";
' k8 B/ t# x/ d3 `* l
}
' k1 j9 o8 j( s4 N+ y U
# ~7 B3 y- _* t- @) `+ q6 N
function PostListener (){
# }; `& P" x1 q, Y; y- r# q
//Add more post variables if needed and add them to initform() function aswell
4 H- c. K: k, p
2 b" ~3 } s; {6 m6 e
################################
8 J6 g- Z# K0 W+ i" f% S2 ]+ ]6 a
##### Connection and Post ######
$ ?! m5 Z2 e4 p7 u0 U# A( j
################################
+ @ v3 s* G* K. G, }
$name = @$_POST['char'];
! Z% ^) Z# R6 b G3 c: s/ l1 Z
$ItemName = @$_POST['item_name'];
, w2 L/ j& f2 n! y) P5 n
$ItemAmount = @$_POST['item_amount'];
* s2 }9 Z- f! {; D' u- h3 u+ H
$ItemId = @$_POST['item_id'];
8 S+ t. E) r- K& R& P
$ItemUpgrade = @$_POST['item_upgrade'];
3 a8 _5 d1 M" P, q( Q) M4 n: ?+ m
$ItemElement = @$_POST['item_element'];
, y& Y/ a+ P0 d& t7 X6 C
$ElementUpgrade = @$_POST['element_upgrade'];
; P5 o. I* Y) X
$ItemPierce = @$_POST['item_pierce'];
i6 @7 d2 w3 d
################################
# ~* w6 X: t8 n( t6 v
- ^; N6 [9 G: b
//Check both variables for empty value
3 M" e, ?- ~" V" T: n3 |8 N
3 x' Y% S3 R) X5 x& p; y1 }
if (!empty($_POST['char'])){
5 ^3 E4 r( c7 i9 g* c3 M3 R n
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 m/ o. f1 w7 l6 q
8 P( C1 P. p- O4 N
m_szName = '{$name}'");
1 ~9 k1 C0 D; S: Y1 D* l
while ($row = mssql_fetch_object($find)){
* m$ P/ x* O1 Y( @0 g l7 e S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% W0 `4 U, l- _1 h% @5 }
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) D8 _+ v, |$ j& {3 T7 b
. b, g2 z; ^* Y8 w8 b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' k o7 S' o8 d: t h
. z+ o ]6 Z. |* s$ E! c( X
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( d* {4 H" p% L( v. g! r/ B
' Q: w8 b) O4 t3 [- j) M
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 y0 g+ ~! W) S- p/ |# D
3 y/ y( E0 i1 A- r" v; J
'{$ElementUpgrade}', '{$ItemPierce}');");
! t# b# o: V! }3 L1 R9 p% {
}
- N+ P$ M' S9 K) ]4 [0 {/ b8 O
" f0 K3 ^/ S+ r3 G0 `
}
8 ~1 W: d1 U/ C3 G1 v/ Z* L! v) z) w
z& s) M# F6 I& K) f0 ?- U) b
}
* ^6 f4 j6 ~) `) |. S$ w4 z7 w
& W" F# L' v) b/ a
$InitForm = InitForm();
# t6 g h6 t. Y
$Listener = PostListener();
3 w* T4 o' o* Q: P8 t5 ^* V
B1 v" M. t) @1 e7 ]+ i( ?6 ?$ h
?>
3 u& G5 y/ w$ C/ E. S2 I9 \7 |
" ~$ ^5 m1 Q- W$ _2 k1 y2 i+ @
1 M. s, Q8 G) Y* Y! v
/ Y; q3 x) c, ~, a" ?/ s. L9 D
$ U' Z' R; h1 K2 Y! G4 N6 e6 L$ Z
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2