飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php" B/ C# `& N2 H; `
function Connect () {
8 F4 g9 \7 p8 Y' t* T$ Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB 4 ?/ w% z5 k3 J$ b7 N
0 Z& P! e; W% Z# z  T9 p2 d
Failed.');
, Y# S" O9 r% I, R) r}
' b7 U& q( A' J( V: V. AConnect();
9 E9 ^! y6 i6 }, K! L4 ?! l5 {' t( [$ X) V/ R3 S
function InitForm(){" U" A; e9 q$ \0 i
//layout for the form6 L+ @% y. \! B6 S; V8 ^& C; g" w! G
echo "<strong>Send Items.</strong>7 b2 p3 K" ~) I& l+ M
<form name='select' method='post'>$ k: ~1 D' J2 J5 V+ o) ]* r3 r
<lable>Character Name</lable><br/>. F/ @3 {3 A1 O2 Z3 Q7 s' v: S
<input type='text' name='char'/><br/>
- d  R8 L. S7 z6 _, t0 Y# i) V% h<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* f# u" j# T* \5 l7 O: {<input type='text' name='item_name'/><br/>
; q9 n6 P6 X& ~* H8 F. r" r<lable>Item Amount</lable><br/>( w; {4 B- F1 R- T5 M6 _
<input type='text' name='item_amount'/><br/>
8 m: j: L2 ], b% Y, Q<lable>Item Upgrade Amount</lable><br/>+ C9 d8 s; j3 u  Z2 j$ C
<input type='text' name='item_upgrade'/><br/>
$ P3 f. _+ z) v, Q* H<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ [0 }! C: o: B- Y5 p
3 C; l+ o: n) I: \- b
</lable><br/>
& {5 D1 x( ~. B( T# e- h<input type='text' name='item_element'/><br/>
( `+ f2 f0 r7 r, y2 i9 h( m2 z' b" |<lable>Element Upgrade Amount</lable><br/>
3 y5 Q( J3 F, a# Y  @* |<input type='text' name='element_upgrade'/><br/>
8 M" f9 U7 n: r8 T+ ^<lable>Pierced Amount</lable><br/>  _6 C7 E0 v) F9 T1 `/ ?' Z- U0 a* r' b
<input type='text' name='item_pierce'/><br/>7 a" f7 n. x  Z* ]& J9 }) B2 b7 C
<input type='submit'/>) |& A) o. V3 k( E8 v% e/ ?7 Y4 ~
</form>";; j% n' F0 Z7 `5 M; p% ^) U" G
}
4 m# j8 _# k! Y6 V7 e4 |) O$ n  a; ]% U6 {$ w$ \2 V, t
function PostListener (){! A/ ^, w. ~- v3 K9 A
//Add more post variables if needed and add them to initform() function aswell7 v5 R9 j. `2 O+ H* I& y# }( N

) g2 L2 L' |7 Q. P, u5 _; @2 r################################
: \+ v5 u  [* @1 ^; H##### Connection and Post ######7 R& D# R6 X0 g; r  k0 j- R- R
################################/ X" I! B* r' H8 b( w1 D
$name = @$_POST['char'];
5 y6 F8 d! f7 O4 m5 l9 C; y# \/ i3 z$ItemName = @$_POST['item_name'];
' m) v( Y# e. |# _" x$ItemAmount = @$_POST['item_amount'];
2 V8 x, R; T% m' X$ItemId = @$_POST['item_id'];8 `$ J5 h+ j- \& \: z- I
$ItemUpgrade = @$_POST['item_upgrade'];
* u# {% N$ r$ ?4 q7 G( Y$ItemElement = @$_POST['item_element'];
9 _7 F( F  @( [5 }$ElementUpgrade = @$_POST['element_upgrade'];
, @9 R. a+ W6 i& E) Y$ItemPierce = @$_POST['item_pierce'];( O5 K( e3 x- z1 z
################################3 p1 V) B5 l: h2 ?8 k! v7 V  G

7 l# l  V" p+ w; R//Check both variables for empty value
0 X' f3 |4 q6 E6 i
9 a! K9 O& p) Kif (!empty($_POST['char'])){
3 P8 a- E! |% c! G$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; ?7 Q( v7 M, Z4 z) C

& c& n+ |9 [4 N% wm_szName = '{$name}'");0 s  f! Y' T' c
while ($row = mssql_fetch_object($find)){2 w/ e9 i5 a! Y6 k+ J5 Z7 C. ^* T
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- J! P( E# y/ p/ B% R( h+ r9 Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 n4 a1 E7 f1 h5 X- j
5 J# i8 q: T3 x% ^' q: u[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; C6 G0 O5 W. e2 _0 x- q' _/ p& y. _; m8 h, _- R
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ! G6 a) x5 w0 O$ h( J; {2 N

4 g$ H7 W: Z0 UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  I. L  F; f! w0 E* L) a6 _5 u# Y, k' }2 k3 J
'{$ElementUpgrade}', '{$ItemPierce}');");- T& b8 Q0 V! v: x
}
. k" \$ s% e* d) l3 J) v9 h7 O/ |) t* K
}
4 K& u  Z8 m/ F# Y, Y! _' C5 R% r: P5 S0 S; U
}
+ w8 D3 ?' c+ E$ s
, W- ^- i$ i8 O0 ^1 Z7 L1 U$InitForm = InitForm();. D' T$ J- `' Z& ^8 A* m3 x  \
$Listener = PostListener();
* s* A5 A: a. p; h7 S$ @
) |1 n- c9 `8 ^# W. O: J?>0 y: O; J& d' B

7 ?' M9 j5 o! b! [2 Y# z) T, Y9 s7 j( C+ P; K
) s$ G' C7 a6 h; ?3 ]

9 i$ G$ ]+ d) A9 j# x! A: c
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-25 11:01 , Processed in 0.057794 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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