飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
( I- n" @$ N" U
function Connect () {
! Z) n Q: L, Z) f% \8 y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 { j: g2 K& H0 ] _
* @/ ]' E* a0 h+ S( f/ o8 a
Failed.');
) y0 u- e6 J! F+ {" E
}
7 {+ y6 N4 w2 e* b
Connect();
. ?3 J0 Y; M+ ?8 r1 E
, G; A- }! l, P# Q
function InitForm(){
* Y1 q5 `9 i' h
//layout for the form
6 S4 k8 c. o$ k7 p
echo "<strong>Send Items.</strong>
1 _+ q! h2 u( G/ l
<form name='select' method='post'>
' `% I+ {- e6 B9 p# P
<lable>Character Name</lable><br/>
, T Z2 J" e6 p; S
<input type='text' name='char'/><br/>
) y9 [ j7 x0 \4 }1 ^) z) O
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* K# F0 O' O$ j2 B$ g* p
<input type='text' name='item_name'/><br/>
. D: b6 v0 Y; h! Q+ G
<lable>Item Amount</lable><br/>
. |/ Y. Z& F% L! w, ~4 y
<input type='text' name='item_amount'/><br/>
' G* Z' Q/ c' r1 c
<lable>Item Upgrade Amount</lable><br/>
* |5 p3 f% Y' P r
<input type='text' name='item_upgrade'/><br/>
0 n( F' _4 f& o: T
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
O* I% f- ~6 }" L
4 X- g% S2 C" y7 l0 q
</lable><br/>
0 m1 G% J7 F5 x) M0 a
<input type='text' name='item_element'/><br/>
6 Z: b* F2 r1 ?) I
<lable>Element Upgrade Amount</lable><br/>
( z/ A, a. r: J$ w) ?
<input type='text' name='element_upgrade'/><br/>
+ f4 z" v* b8 _) g0 d7 f
<lable>Pierced Amount</lable><br/>
+ i9 j3 j( |) k$ R# N. y
<input type='text' name='item_pierce'/><br/>
$ l q1 \, n' J, p U9 ^! _$ n
<input type='submit'/>
* V( S$ D$ C+ z7 F) i; F2 d; D
</form>";
, I- @0 x5 v9 g0 Z$ P% }
}
! |8 _7 m1 M6 s9 ^2 q1 r; F7 N
3 x; k) ^ B( o! A& f
function PostListener (){
+ j6 L7 j6 q4 b( V1 W
//Add more post variables if needed and add them to initform() function aswell
9 Q" S1 k3 Z q1 {! g9 r1 S- [8 C
& I/ F$ m+ L# ~/ x
################################
2 t% V* M% f6 Q5 V. V
##### Connection and Post ######
" }9 D( y6 ^" Y/ q) y; \ C9 j
################################
3 f# t3 Q3 ~% w2 @$ a
$name = @$_POST['char'];
. J+ \/ o B& \5 k
$ItemName = @$_POST['item_name'];
! H1 M% n5 D4 ]/ Z ^) Z
$ItemAmount = @$_POST['item_amount'];
8 G- B: f C) j; I3 {
$ItemId = @$_POST['item_id'];
2 d ^* G* O8 @
$ItemUpgrade = @$_POST['item_upgrade'];
+ v7 R. D5 f. A; C
$ItemElement = @$_POST['item_element'];
5 h7 S. _ _5 {7 N Q
$ElementUpgrade = @$_POST['element_upgrade'];
: E* Q0 Q% I2 X# B& J7 u
$ItemPierce = @$_POST['item_pierce'];
( ~ _6 w( l0 p2 @
################################
7 J6 v9 P7 [: g/ Q2 i
$ k# |0 S/ D; Y3 B2 K2 B- o' ~
//Check both variables for empty value
" a) x- x4 i/ N8 I3 b- {% r
5 Y# K" H5 K# m. w. c+ e
if (!empty($_POST['char'])){
( ^* k& J. N6 @ M' y! L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) q) X& ]6 s' ~6 S$ L
( i7 l b% i( I$ M+ V) Z: W% L
m_szName = '{$name}'");
& ~4 w& Z" W; `' p5 R) Z `
while ($row = mssql_fetch_object($find)){
3 g) C9 ^5 Z$ r, ` v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 ~/ |9 C9 K+ |1 A$ i* ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, Y [! H( k4 B6 O6 O4 R
: W) _9 Q: f, T2 X7 N6 J- n
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ E3 l' p5 |8 X6 L; H+ U7 A/ y
$ Y, d/ d- x! S6 U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 G4 _0 ~0 }- K4 f7 O* I0 e) r
( N9 p9 E6 V; H- F8 ]( |3 y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 d" X) K; Q: V7 E& X$ a
/ t( t! ]0 O9 p2 w
'{$ElementUpgrade}', '{$ItemPierce}');");
! [# b5 w6 w h& E
}
* T* y, a* _: [) K
8 Q) F* n. S8 f4 J1 J- ]# F
}
9 v; m& T. P& X* H/ ]
c0 j6 j7 p( D- {' e
}
- g8 R2 \. _" e3 O+ E& X& h
7 i: X" x; t4 y+ M
$InitForm = InitForm();
, i( L! L1 b8 V* t
$Listener = PostListener();
" [9 w- d! Q( n. \" Q* c5 S7 k% H
* ?/ `% N% _1 d O6 v* |' s) w! ? y1 B
?>
- J9 m% Q) [8 [( b6 ~; g" O
3 z' z4 W: d& [! j! R! E
! `9 n" d$ d! ~ m9 I
* A) u8 c% z% ?* `
3 C/ r9 M4 W* W* u: T: ^; `
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2