飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php& o; Y, Q$ x$ O' c- ]
function Connect () {' Q! |- b/ m/ H" V
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ I% j$ I" t0 k8 `, _9 T5 U
2 E/ v& @; q  e5 ^Failed.');; X% e  ?9 @$ x( o" ]
}
6 a1 m- B4 y. y, oConnect();
4 w. ^7 y. k, V* B; K# G
; {& _! w  j) ofunction InitForm(){
8 @9 ]# f* `% A$ R7 Q7 }0 V//layout for the form/ L6 ]% t" Q( D) Q; b' e8 U
echo "<strong>Send Items.</strong>0 B! t# t, b  E4 i0 `2 u
<form name='select' method='post'>" A% k" P0 S# e$ W+ B/ G
<lable>Character Name</lable><br/>" t2 B" Z" c# J
<input type='text' name='char'/><br/>
. d/ a, Y9 s4 U0 i9 L: S<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' _- M3 d8 i5 E2 l<input type='text' name='item_name'/><br/>& I$ o2 L+ Q* Y# y8 f
<lable>Item Amount</lable><br/>  Y8 e+ R" @' J4 G8 t8 `& i* O% _
<input type='text' name='item_amount'/><br/>
8 C/ D- ~) C# |4 Q  z<lable>Item Upgrade Amount</lable><br/>2 m+ f- ~5 K7 X0 @0 K7 \. ?
<input type='text' name='item_upgrade'/><br/>) x+ z* s# g8 V7 o$ I
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 K) J3 O2 E! H, A6 C. F- @+ n4 G2 f, s/ p4 _
</lable><br/>7 @9 [6 i" N! z. ?" \) u
<input type='text' name='item_element'/><br/>; X( r# Z' |. m1 C
<lable>Element Upgrade Amount</lable><br/>* x% F6 }" I. J4 V8 n+ p
<input type='text' name='element_upgrade'/><br/>- j( k5 |* z  x2 N& S3 V9 c  ^# H
<lable>Pierced Amount</lable><br/>
5 e+ ^2 A# H$ H( ~( ^3 }<input type='text' name='item_pierce'/><br/>
/ l% O) R4 t( z8 h0 [<input type='submit'/>
; |/ ]" e0 \: A5 x% G& X</form>";
% Z/ ~8 m& N1 d7 J( T1 q}
- W9 Z. G7 Y8 v" r4 B" q/ G
8 m  g1 ?( }, @! s1 D# O" Efunction PostListener (){
9 }/ Q) L% Q' j; R//Add more post variables if needed and add them to initform() function aswell
: i7 N' T2 L2 R
* K; W( n) }! c" j################################
9 y4 d% p$ r% O' U1 g% y) @##### Connection and Post ######
8 r( |5 e! s. l1 a  E- x################################
, L1 Z' O% e5 r. y7 M$name = @$_POST['char'];
$ i* I* D* z3 K: k/ o$ItemName = @$_POST['item_name'];
0 j$ J$ W1 X: g. E$ |0 L: j% l, @) Y$ItemAmount = @$_POST['item_amount'];
( O; F) C' |7 `: v) T& Q" a! ^$ItemId = @$_POST['item_id'];
$ Z1 R" |4 j7 a- Q, C$ItemUpgrade = @$_POST['item_upgrade'];8 W, `  F+ `; A" e8 [0 ^3 N9 `# w
$ItemElement = @$_POST['item_element'];
$ a  p  t) j! P# p/ \1 A$ElementUpgrade = @$_POST['element_upgrade'];
$ f3 B, L( y! l; y0 J$ItemPierce = @$_POST['item_pierce'];1 @9 w. M9 x, e* G! Q
################################* f' B3 }" w5 C0 f& B" r+ a
" f, K  r3 X. h
//Check both variables for empty value+ s4 x) d( c% x! V: I+ t( `5 t+ P

, C' S3 Z0 ]6 m5 z* D8 kif (!empty($_POST['char'])){
( Z# L9 _6 `$ ?$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where   f( q2 T# ~6 Z( o- ^% n3 j8 }* y+ y

7 d1 P) s2 o2 H2 j7 zm_szName = '{$name}'");
  X" j; _: c. n- T' E- Y8 B/ I2 Kwhile ($row = mssql_fetch_object($find)){
" P# c7 o* e; t$ i* z+ h' ^# b, a: xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";/ z9 G5 n/ _' s3 P9 f8 s% R4 K
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 G' i0 y% D$ b8 H" l. G

- ?& p. W! E& O: T8 h5 i# P* K% b[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* f+ z) T2 d$ r* d& P
3 o4 A3 s- m/ n; G' F/ @6 k[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / v% m8 s, [: m& X7 b

  U  Y: j3 W. {N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', , k8 e. a* N) T1 C0 l5 m, ^9 s
8 f/ j+ B( G' `# i5 }* a) e
'{$ElementUpgrade}', '{$ItemPierce}');");
/ i2 ~' d% m3 K7 S}. j! Y0 o+ [5 Q* h9 O5 @% L8 n  W

  ?5 P/ ^; x: G}
! y0 s( S, Z8 B9 I3 Y5 D6 z4 m3 c# t3 v4 i4 W* y5 v- t
}
* b- {1 V: M! c" e/ }1 @% J1 M9 w' y4 o" p& a! V0 Q! _' i
$InitForm = InitForm();
) l9 b( ^. ~* M, ?# s& m$Listener = PostListener();
/ o. U  h, X7 h; M# n
  m7 F1 L0 s. z# B?>" V" ~. w7 |& k( V$ f
( B' ?  f' \& i0 e- q7 ?
9 }. q) [% N, o3 `2 e! j

! J: [. d: [! l0 L8 W+ J/ V0 R4 M& h0 H
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-17 16:02 , Processed in 0.062258 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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