飞飞世界论坛

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 14942|回复: 0
打印 上一主题 下一主题

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
2 W& U4 j. q5 _$ t* ^function Connect () {, `# w/ W% t* w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB + ^/ ^" o$ c* ?9 N% g
& ?( V& ?& a( n7 A" J4 V! s$ i
Failed.');
7 V3 H9 p% y* L; A0 |9 D}
$ Y) u% l+ B. LConnect();
5 \% U: K# j6 w2 c8 W7 o4 v
; h2 ~5 b; Y% J% _* k( Efunction InitForm(){) R1 g( H) K. |6 m
//layout for the form% Q& Q2 q$ a8 o" o. o
echo "<strong>Send Items.</strong>
' L+ Q. `$ `( b7 H% \/ `4 u) g3 C<form name='select' method='post'>
- t  a5 j- Y1 [4 R<lable>Character Name</lable><br/>
5 a" b3 A6 e7 ]1 r- g- T, D& e7 a<input type='text' name='char'/><br/>
( s% N3 }5 y) \) \3 w<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>) X1 v4 P! [9 b, _3 \
<input type='text' name='item_name'/><br/>
8 b( j0 T1 S/ v8 M% H4 h$ @<lable>Item Amount</lable><br/>
! C& ^+ b. K" C  q<input type='text' name='item_amount'/><br/>! F" r/ n$ J( O! B
<lable>Item Upgrade Amount</lable><br/>
6 O# G/ c0 F. e$ _: t* \$ i<input type='text' name='item_upgrade'/><br/>- B, s; M) `5 b8 |9 K2 D. ~+ K' y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# Q' e% H. f' D; l6 }) w4 b
5 ?$ M9 ^; s1 z+ e) J</lable><br/>
7 P8 M# b2 F# ?, B, h<input type='text' name='item_element'/><br/>
; n, n' S1 N& H! s  ]4 u<lable>Element Upgrade Amount</lable><br/>
4 x1 o/ \5 E: a1 `0 L# L<input type='text' name='element_upgrade'/><br/>
. E* R  I* O4 w$ g& b% d$ U1 L6 h<lable>Pierced Amount</lable><br/># w+ P2 Y2 d: I6 I; ^% M
<input type='text' name='item_pierce'/><br/>
/ D/ {( B0 o& c; S' R3 I& _2 d3 k<input type='submit'/>) e4 e, W( d3 @/ n9 P
</form>";
) H& M: z6 ^! Z4 B  n2 o2 y5 v}3 T+ b/ l* g8 h0 j1 n. p% i
+ s% m) y' ?7 Q4 s
function PostListener (){
3 q# f" S+ s& d. n4 p//Add more post variables if needed and add them to initform() function aswell* V* d4 _8 {( H5 G" K
0 \% \! V& T- j( B7 N7 {$ [
################################
2 M0 ?8 I) O6 s##### Connection and Post ######
7 \% d- {$ b8 s################################8 E; I: e% [. R; Z; S7 _' q' y
$name = @$_POST['char'];6 h7 T8 F6 H* B: z
$ItemName = @$_POST['item_name'];
5 E) Y4 R1 }# E4 F; e$ {8 I  z3 l$ItemAmount = @$_POST['item_amount'];
4 }8 m; ]! T- D! y3 N! Z3 l$ItemId = @$_POST['item_id'];
' Q1 e% C- p4 e6 m3 t) n! D$ItemUpgrade = @$_POST['item_upgrade'];
; A8 K  h  R& r% u' A, Y: C; T9 e$ItemElement = @$_POST['item_element'];% p( Q- f: o: g+ ?8 D  y* j6 M
$ElementUpgrade = @$_POST['element_upgrade'];
" e5 r0 `8 O# U5 I' A/ s$ItemPierce = @$_POST['item_pierce'];
/ J3 s3 V7 V9 k1 o: N. f( @################################
4 j% a1 ]0 f, X7 P! D9 E7 p7 C# g
; X$ g8 o& Z" F+ n4 e3 Z% Z! i//Check both variables for empty value! ^2 _  R$ m( c% L( O

2 q. v4 z2 x8 C; Dif (!empty($_POST['char'])){
, Q0 j8 q2 `. C% ^# [$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ D$ E6 m4 ^, ~% l) [$ U$ ^6 ]
2 \- D4 d/ Z* I9 B1 Jm_szName = '{$name}'");
9 _, ~, r: c' ~; m2 o. nwhile ($row = mssql_fetch_object($find)){
1 j1 ]  B  s7 ?1 @. t- fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";, z) G! v6 _: E- I  l( U+ k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], " D* M% D5 c/ W0 ]

( S2 k2 f' |5 W( _7 c[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ p2 Q; R1 m7 }- X
$ ]: U: g  S) r; ^" O. I8 g$ K+ ?[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', " H; k6 A* b: A' [7 h
* S* j4 g+ ]/ ~, R5 W
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # t( f/ `0 O9 Y3 C" A& c

8 j8 I! z4 I% `' a# N; ~'{$ElementUpgrade}', '{$ItemPierce}');");
) {/ k9 K$ }; j$ k0 O$ T* s9 u}' p4 }' \6 V! I' g; a& R6 i
; U4 J* F3 O7 ~: E+ P, O
}
. p0 k1 i) W8 p' K, m8 K9 r2 V. Q  d7 e
}
2 Y1 r, }$ n% Q9 g
0 }5 c) ~8 [& c3 [! q* c: {$InitForm = InitForm();
5 d! G) X" d) T5 I6 \  [( ?2 W$Listener = PostListener();
. x. k8 {! Q/ w# q# F0 l8 B9 D- A- R. Z: C( q# I% [. T
?>3 L- O! \6 }9 n8 x9 ]
7 z" Y* b( e( S% M0 @
0 I# l! t9 m+ G$ m/ S
! P% C9 y/ m) r) ~* i7 U9 ]
3 n" W: K) k" i6 N
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|飞飞世界技术论坛  

GMT+8, 2026-1-26 02:46 , Processed in 0.061727 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表