飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php; @+ Z' k; [1 x* M  s$ P$ _2 j
function Connect () {
" ]9 h) L1 P( _: N% f, {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 u+ S; p# D8 O$ o- [- k- B
" v6 S. K" C$ v4 A+ W+ L+ PFailed.');
0 {/ W5 u1 v0 F( }( V4 S}$ q. v% \3 D4 I: D! R
Connect();' ^7 q# n  {# z

& @) g" h' I8 O( L( D% N' Ffunction InitForm(){3 F5 X8 ?# f' g4 C3 g- F
//layout for the form: x$ X/ s2 s: c. I7 K3 ~' \$ C
echo "<strong>Send Items.</strong>
4 ]5 \2 m/ ?  {3 |' W5 M<form name='select' method='post'>. J+ ~7 {, G# y8 }
<lable>Character Name</lable><br/>. q. T  t9 s+ O" j; T
<input type='text' name='char'/><br/>
( _+ J# y4 w7 X5 I* `$ z* S<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* \, o# e4 ?* B" C7 [% d. X
<input type='text' name='item_name'/><br/>
+ a1 [* ?$ w/ q% x<lable>Item Amount</lable><br/>. U6 }4 U# ]# m* H7 f
<input type='text' name='item_amount'/><br/>
; n! r1 M6 W9 t8 H2 H- D5 z! \<lable>Item Upgrade Amount</lable><br/>
8 i9 T2 i# V' \' U' g! z9 y<input type='text' name='item_upgrade'/><br/>
. X( W) {$ H( k  X( \: |' m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 ]3 |* V; t. }& b% M0 u6 o: D; r( d# ?% q2 e( O. N: @
</lable><br/>7 O( A# q' G  [3 A) M# j/ O  k/ ~
<input type='text' name='item_element'/><br/>
. |7 h& q9 H- b9 H. u& E7 e<lable>Element Upgrade Amount</lable><br/>! m, i  u! R6 @6 [' y- y% h
<input type='text' name='element_upgrade'/><br/>
+ b7 e2 n4 t; K' o! U+ g* q<lable>Pierced Amount</lable><br/>( a. f' x. A# J  a( d
<input type='text' name='item_pierce'/><br/>- a0 `* C- y( h2 Q
<input type='submit'/>
7 D5 t; R1 X9 Z6 I- W& h</form>";
: H# W9 v4 I7 j$ U( p; B; J}' U5 ^$ b- o( i! }6 W

7 B, [! Z1 |4 a9 hfunction PostListener (){6 o& U, M+ J5 i7 U/ _
//Add more post variables if needed and add them to initform() function aswell
. p: q! T3 h! y# t4 P0 B
* p& N$ o$ ~3 O+ N4 W0 T) A$ H################################
8 c+ i% q. Z  a8 ~- {##### Connection and Post ######$ E+ Z  H; m; l% k/ ^; ^) D) H
################################
; l: b: s) v; a7 S% p- O* x$name = @$_POST['char'];8 n% h- b' S& ?" L
$ItemName = @$_POST['item_name'];9 ^* {# ^/ x3 n
$ItemAmount = @$_POST['item_amount'];$ l) G; ?3 p4 ?- h5 r4 R3 }, ~0 [
$ItemId = @$_POST['item_id'];
7 S; A, u8 y/ @$ItemUpgrade = @$_POST['item_upgrade'];
3 s% X6 t& O9 R5 s; o8 {$ItemElement = @$_POST['item_element'];# j/ g* T' j7 j2 B
$ElementUpgrade = @$_POST['element_upgrade'];' V8 A! O, G( m( J- o2 y$ s7 i( N! w
$ItemPierce = @$_POST['item_pierce'];* I$ P9 a/ B! z
################################
& h) o6 h6 ]* ~! y' h, `9 M+ J/ u! f1 P- @8 h9 k2 D
//Check both variables for empty value
; m  v7 W; I9 s" V9 a
  E/ c4 F2 |+ Q, Q! H' gif (!empty($_POST['char'])){1 H0 u/ b8 O& c  J
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where - T" k" X. U) I# e0 s% l
9 c0 L; W+ ~3 l
m_szName = '{$name}'");
% x4 K1 w* F, \/ W7 O* dwhile ($row = mssql_fetch_object($find)){! C- e/ r- j, Q- c( C- A) p
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";7 ]2 ~" H8 p, l- v0 `1 d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; c2 q) ]  p0 \) I  K2 D

3 T5 H' k+ D/ C4 [& C6 `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 C( _" h. k, C4 h5 i; g- I9 V* I; ^/ ^! {; H; y. D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',   n8 L- @, D1 W! G; }: f

2 X5 O% y4 R$ e6 _/ l7 N6 A+ c3 u: yN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) j; \# j! \: j- V1 ~9 \% C, Z! `  S
1 V% W5 h& [# p$ j. @'{$ElementUpgrade}', '{$ItemPierce}');");
2 e( {1 {' k7 A' M}
. |; O  O; l/ \; ]; ^# |# h2 L6 v0 o6 x0 O* a& G: g7 b* I
}+ F- G$ d2 _1 ]8 }

$ D2 ?: I, [1 b' g}! N; U! j' }: {" p. Q+ I1 y2 ~

% |% F: |7 M$ E% V1 Z! t; Y+ U1 a$InitForm = InitForm();
) M: e6 W3 y8 R. `$Listener = PostListener();0 W" k- K5 G) e; B( ~0 Q3 `: q% p! n

5 I, ?" W9 s, k4 @  V/ C?>
- }2 K. Y. w. ^8 V
2 G  i% ?) J8 R! E) |! M' ]5 u2 v$ O) [$ H4 z6 o8 Q7 J
2 o3 h* _, `. w6 b7 a

# c3 C8 J- |2 z) W+ }; N! i  B
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-23 18:14 , Processed in 0.059012 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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