飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php% @9 r6 \; ^5 e
function Connect () {
0 _+ @* Y: m" n9 Rmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ) [; n6 P, s4 N

5 o. P' M. P# f+ UFailed.');
' O) l. d0 k5 A6 p) p- n}( Z" z' Y2 y2 H6 N; G
Connect();5 N* ~  }* k0 F# ~

' j$ }3 `& m" f2 H6 M7 Mfunction InitForm(){
& H7 E; J) l$ r+ ?" r//layout for the form  `+ l& n& {' u) r+ o4 a
echo "<strong>Send Items.</strong>
0 t: o" x" {+ K6 y. h<form name='select' method='post'>
5 r$ g! S# \# y5 n8 [5 V" |<lable>Character Name</lable><br/>6 ~. d4 q* V. h0 r
<input type='text' name='char'/><br/>. e: s. b; ?. @# X! n
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; M+ ~. U! a" g<input type='text' name='item_name'/><br/>- p' x9 m- m) A8 I
<lable>Item Amount</lable><br/>
0 w5 a2 s* R7 {; ^+ Z" i# j/ K' w<input type='text' name='item_amount'/><br/>
6 B1 K# l( E, m" @1 X<lable>Item Upgrade Amount</lable><br/>
, `9 z) c( I/ p# O3 i3 L" }<input type='text' name='item_upgrade'/><br/>( {2 f1 Q' \8 i' y! B7 E3 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), C( a7 W4 |6 h& q! h* i

& Z" `5 m( i1 f" p& q</lable><br/>8 v! o; C# y- U* g& Q
<input type='text' name='item_element'/><br/>
( O# k. L9 @3 U8 g/ r. @<lable>Element Upgrade Amount</lable><br/>
1 R1 {) q+ J* R<input type='text' name='element_upgrade'/><br/>. p* ^1 }$ t4 L$ [# u  U  ~
<lable>Pierced Amount</lable><br/>. {. J6 u( t+ ?1 k5 k
<input type='text' name='item_pierce'/><br/>
2 O0 z" e/ \0 o7 i9 l* n! r<input type='submit'/>+ X: D; Z0 b  K7 N2 k6 x8 E* c) I4 ^
</form>";
% P6 Y' Y/ x3 _5 F6 M" A7 `}
9 P! [/ F* i- ?) R: E# z
, K$ q( i0 b; t, w3 K  qfunction PostListener (){+ [$ l" r( W; a0 I6 l
//Add more post variables if needed and add them to initform() function aswell
3 x% I( U1 J4 G4 f' V, M5 q+ j1 b3 n7 z7 p
################################# E/ X% M: T+ P% {4 T5 e# t, w5 U
##### Connection and Post ######
' U$ ?  o- R1 ?, [################################- R' \% o; B; \2 r4 Y/ Q0 S: j9 g
$name = @$_POST['char'];
' e/ P1 x4 n5 R& l$ItemName = @$_POST['item_name'];# ?$ X- T; {  [) B
$ItemAmount = @$_POST['item_amount'];
2 W/ a; `) E' Y' A$ItemId = @$_POST['item_id'];
' X: d) l& X2 n8 G$ItemUpgrade = @$_POST['item_upgrade'];6 I* V* @4 f0 F, b' P" e" `2 W; I
$ItemElement = @$_POST['item_element'];
) b: a# m0 v0 _: J: ~1 W$ElementUpgrade = @$_POST['element_upgrade'];( ]3 e8 }: r+ X0 }# Q
$ItemPierce = @$_POST['item_pierce'];) P" B9 U; [5 q
################################
  s! y5 I. y7 R' A1 a  g" @2 z# m
% g5 z- |7 E. a5 X6 Z//Check both variables for empty value2 q: h$ m+ K  v; D! p4 X9 C; v$ {
/ f: Z" E( T9 ^$ l0 E' e2 D
if (!empty($_POST['char'])){
' n$ Q/ m+ n% E6 @% K$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 3 i) y/ V/ _# B, d  F" n9 }( E" M
; @) O& d, p* X+ X! u+ [. o. Y
m_szName = '{$name}'");8 ~( e, y1 t# {3 @# X
while ($row = mssql_fetch_object($find)){  @: |3 ^0 A# W& }7 d. j
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" i3 a- _! |. {$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], " H, r4 i% }8 c, d* A/ L
5 I: _' ]! Q' A- O& ~2 V6 a
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- ^% q5 r' ?9 I( c# @3 A
8 s8 m) U  `# n/ l3 v6 G[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" B1 B2 H% z: N  _: Q; e
( Q( `& w; O/ v* ~% FN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 R# u: N$ F+ F+ \6 `+ T' R2 a3 ?2 I- u. ^1 a
'{$ElementUpgrade}', '{$ItemPierce}');");5 x4 C# S; j- K6 P7 ^  P2 D
}+ Q4 G; L0 J; r2 A6 m
# ?0 X, J% T+ |' n
}! B2 h0 A' B$ d0 e4 B0 k; F3 `
( C, y9 o9 y- L! {' J
}
! b/ N" c- U: r2 A( j/ Z3 B: y3 U' X( s" T' b
$InitForm = InitForm();
; P& h* t& E0 I/ U! |# o8 ~9 S; t* C; d$Listener = PostListener();
: t5 J  L2 W$ r7 K: r( n: w' B
5 q: s$ N5 x4 w, G# r8 R& \$ ?* o?>
. [' ^; j% Z2 h* p! v; e6 ?9 s! M" E1 N7 A! D
5 w2 O& l1 ~/ i- I& t
7 I- w/ R( b, N6 w6 I' \0 g
* }5 r- R* \- B' w* m
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-19 03:55 , Processed in 0.103855 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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