飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php& U1 ^) J2 }+ p+ f8 \
function Connect () {
7 u. y) w: C0 D/ ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, K5 V7 q* N3 ^4 u( ^5 p
& B' T" s5 _( n. `0 C4 WFailed.');( Z- c' ]; Q& q8 e, e, ?
}) o6 s8 v. X* i7 m
Connect();3 z  ^) i1 N" b& v1 G
. S; O; D3 j0 m: f6 b* m
function InitForm(){/ }9 X4 e6 u7 x' d7 k  K
//layout for the form
0 y+ w8 g5 m( j4 }echo "<strong>Send Items.</strong>7 ?+ s( ^6 o9 C+ W7 P3 G# t
<form name='select' method='post'>5 W8 O5 n! H4 ^" y
<lable>Character Name</lable><br/>
# }; q' l) X" ^<input type='text' name='char'/><br/>
$ P  S& W! i0 f' B<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>: X7 W2 |+ z* d7 q0 o; Q/ S" ?( E
<input type='text' name='item_name'/><br/>' @  w! o( b8 X( E% J" _
<lable>Item Amount</lable><br/>
3 e  p7 j& l/ [<input type='text' name='item_amount'/><br/>
: p5 Q; j! L7 g<lable>Item Upgrade Amount</lable><br/>
6 I& t8 ?5 x: {7 p! I<input type='text' name='item_upgrade'/><br/>6 F, F4 u" X* R4 ^8 A% t; t- {" |
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 i0 o+ ]+ w' g+ i% ^4 Z
/ G# L4 _! A& `7 D
</lable><br/>
* W  z/ Z( E/ L: u  {0 F: g2 G$ G<input type='text' name='item_element'/><br/>5 J! e# M, q4 i$ D+ `
<lable>Element Upgrade Amount</lable><br/>, h0 v. [9 W4 B" O: X2 w
<input type='text' name='element_upgrade'/><br/>+ v8 c& P5 ~! Y* @
<lable>Pierced Amount</lable><br/>
! e% g* ~+ P" z- ?# M3 q+ }$ k<input type='text' name='item_pierce'/><br/>
  T2 l5 Y; O- G# |* G6 l<input type='submit'/>3 {* k; c) E+ g, J
</form>";- e. y- x) R  v& ?4 U- l" A
}" k( O1 Q: h, b: b3 T: b
5 g0 T; |* A% I( i- ~
function PostListener (){
0 k7 m! e5 x% r- q//Add more post variables if needed and add them to initform() function aswell2 E& Z$ t  r( ?+ b  l

' W3 w$ j4 c) B* z3 I################################; j+ n& }- y$ @1 i
##### Connection and Post ######$ A0 \$ x) I  J9 S+ R" B; ?5 o/ d
################################
" @$ k2 ~3 M# K; ^. [$name = @$_POST['char'];
- r' @0 E2 a! x8 I, g$ItemName = @$_POST['item_name'];; b. {' F: X: i) G. |/ Z1 h
$ItemAmount = @$_POST['item_amount'];
( u0 P- h( R  t; G$ItemId = @$_POST['item_id'];9 o# a+ z3 j9 z4 E- f; r8 {! z
$ItemUpgrade = @$_POST['item_upgrade'];1 v# F% k6 A6 @  T
$ItemElement = @$_POST['item_element'];7 [+ n4 J$ x- [& |* E
$ElementUpgrade = @$_POST['element_upgrade'];5 {; i. }) F: n
$ItemPierce = @$_POST['item_pierce'];: H# T- P- O' z* c1 k* X: q  k- G
################################$ j% q7 K4 @8 O3 k$ N/ Z+ i

- b* M/ ]. _: ~: o5 K. p//Check both variables for empty value" J# f6 Z1 u% [2 ^$ H# U  c, Z5 f
% Q$ p+ w9 Y) {, l5 W
if (!empty($_POST['char'])){2 r$ s) z5 J' ~( g) F
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 U$ f8 P1 Q4 S# p
$ ?& |) k$ h1 @) K# D, hm_szName = '{$name}'");# Q9 R+ r0 z: h
while ($row = mssql_fetch_object($find)){. F, e( h/ g5 z0 S( u1 ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* o9 W4 R, K8 R% T' T; O  p. I$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 1 C0 q3 v/ H3 d2 d/ Q
1 n$ F9 X( D" ~- T. h- l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# H/ e  _3 M- ^0 t. m. p5 S- `/ J. _" P. F! b$ G# j2 T( ^$ w
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ! s, @# H* Z( i, l2 J& o

& [! W9 O" R; F0 G( d6 ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
- d& t$ g7 J1 {6 L( F3 S/ {9 K. m4 J
'{$ElementUpgrade}', '{$ItemPierce}');");2 K$ \& c7 S5 `, V* ~& m
}+ {% n9 e$ N# n' ^! f" \

& B( x% h( y, K4 k" x% A}9 S" x" g* F: f. h  m

9 K4 Q. ?. l: }9 I$ ?/ m}; F- u6 m# T$ D. y

' r3 ?( a; ]3 n! M) C$InitForm = InitForm();0 Q2 C1 v) I3 Q. Y* w3 h$ }9 z" g  i
$Listener = PostListener();
4 i; o; I, g. C- Y1 q
, [  t8 L4 x5 F: ?2 v# U4 X?>
2 e. I' M, g5 L9 {- W! a' L- I7 t

) w& b  k1 Y" j1 _6 [6 m5 ]5 l8 A: \1 J2 @4 W
. S1 _/ q9 C/ _% p; o# b7 k' l
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-21 06:08 , Processed in 0.074731 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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