飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: 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! zConnect();
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! vecho "<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 aswell4 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 N3 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 Nm_szName = '{$name}'");
1 ~9 k1 C0 D; S: Y1 D* lwhile ($row = mssql_fetch_object($find)){
* m$ P/ x* O1 Y( @0 g  l7 e  Secho "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) MN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 y0 g+ ~! W) S- p/ |# D3 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