飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php2 }: p1 ]$ X9 D8 |4 U( ]
function Connect () {7 D# V; c- x3 a3 u2 n+ |
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# [! n* O0 ]4 _1 m
" o+ K( s" O1 R2 s: f# k. aFailed.');7 m+ d$ ^1 v+ T& S
}# Q3 \9 s5 E9 |; d
Connect();# O/ A8 j, V/ c/ i) w
' y! m2 U+ E; l% \7 v7 U
function InitForm(){
# l7 `8 \3 f0 L- m9 h% w) k//layout for the form
  z' j2 \5 K' F7 a) w) yecho "<strong>Send Items.</strong>
6 c; I- Y% \1 }1 Z2 i<form name='select' method='post'>. T; Y1 J" O# D& C3 ~: E
<lable>Character Name</lable><br/>
5 @/ D4 D5 v) q9 R' S- B<input type='text' name='char'/><br/>
5 ^$ ~. k2 ^, U; f1 V<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. @1 `/ \% g2 T6 ~- A- P* \+ }+ b
<input type='text' name='item_name'/><br/>5 q! r' w, P/ j$ ^2 I
<lable>Item Amount</lable><br/>
" H4 u/ h  B8 Y# Q* m% s<input type='text' name='item_amount'/><br/>- w7 m& Y/ X4 z# Y
<lable>Item Upgrade Amount</lable><br/>
+ n6 Q& E; f) ]; V( l<input type='text' name='item_upgrade'/><br/>
( Z+ g) n# n5 X# b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 n* E& s, [. A9 [( u4 n2 ~3 R8 U) R' f+ u& w; ?
</lable><br/>2 k# Z; x2 e+ U% ^1 ?4 }7 I
<input type='text' name='item_element'/><br/>: `' x3 ^+ E. f5 S7 A
<lable>Element Upgrade Amount</lable><br/>
4 i5 B% y2 X1 N; V0 U<input type='text' name='element_upgrade'/><br/>
6 K" T6 ^; Q# N" k! `! ^<lable>Pierced Amount</lable><br/>5 u4 p3 Y& ], p7 y+ _7 G
<input type='text' name='item_pierce'/><br/>
& V9 {& i( h: W( |$ f7 m9 `. U/ o1 n<input type='submit'/>
5 D/ ~* c+ x1 }</form>";
7 @7 ]2 r. y( b9 [+ i}% j; U8 I: q2 }# M

  g1 o9 _0 Z% I# \; h+ [function PostListener (){0 A' n# L1 h* ^5 ^
//Add more post variables if needed and add them to initform() function aswell
$ s6 q9 \: ?+ w
" i2 I& X2 H5 H6 V################################
8 I& e0 a; X4 z9 w##### Connection and Post ######* c4 X3 v6 z% j  v. Y5 P
################################
2 @7 H$ f* I0 G5 v7 V9 E- X1 H! z$name = @$_POST['char'];* D5 a$ D; z3 F% M2 W& s
$ItemName = @$_POST['item_name'];
: H# p; C; |- }% Q/ d. I$ItemAmount = @$_POST['item_amount'];
4 o/ W" Y" N# P/ i$ItemId = @$_POST['item_id'];& @- G6 S, R3 f3 {9 d- P! y3 D+ G
$ItemUpgrade = @$_POST['item_upgrade'];
% D# t! b& C, Y, b8 m$ItemElement = @$_POST['item_element'];0 W; q; p# m: q: \5 ]9 ?: X4 D
$ElementUpgrade = @$_POST['element_upgrade'];( }0 O# \. Z6 q8 p0 C+ e# _
$ItemPierce = @$_POST['item_pierce'];
! o) R1 y4 h( I- q$ j1 H8 H1 O################################: B; E, G$ e0 \# U
) D! L2 W) n0 z4 }
//Check both variables for empty value
8 P, t8 `$ h- x" K6 }% ?; `. g# ?
/ B2 J( B( B. Mif (!empty($_POST['char'])){
& k% F4 Q: o: q  k+ o! z' Z1 o( w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ Y8 A+ U7 M# p1 ~8 S/ J* V) _
0 V* j5 V, t3 k: ym_szName = '{$name}'");
& x3 u" s. B4 t' ?3 gwhile ($row = mssql_fetch_object($find)){
, e3 E; j6 {2 R- w# O) Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' K: J0 i2 V7 c, i" T: q5 Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: Z' m( }5 F# l% w- e  G% k" ^
2 I# d6 I. t5 s" [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  L9 p9 A8 p9 w1 k1 u; m; r. O  X3 `# l. B7 p7 P0 h9 O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* F* |# D5 U6 i* I: H4 S: M# f# e: A- F+ U6 `1 X( [. C' W$ }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 G# W8 Q) u9 }1 Y1 _% {4 x# L# v( x9 C
  D8 N, _$ G# e8 r'{$ElementUpgrade}', '{$ItemPierce}');");4 q6 Y' X; a* X2 w- R
}( S4 _* |% X( U8 X6 ]- e8 W

  F4 {& M3 J+ |; V}
& T& h' ?5 Z0 a. d' G! q" s2 [. N, x5 U; G
}6 C, Y  ]2 C+ @) [- F

! [) L9 X' W: p1 F3 a1 y, }6 L$InitForm = InitForm();
3 w1 T: \! ~: _- x6 K; [* j: _6 d  u$Listener = PostListener();% V8 p; y7 N3 p. B5 D
" u# m& l# P1 U! E) U
?>
# a' y$ I! A, U, \% p4 I8 m2 h" o4 C: i* T! |
5 U' ]) m5 Z& b# r( G0 u& Y
/ [1 z9 J$ f& q& v3 k. X% L' i

0 n2 ~* F- H* D4 Z% O7 p! _- t7 ~" g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-3 21:10 , Processed in 0.058644 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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