飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
2 n+ E1 U+ f# f* r% w& _function Connect () {
( ~- |+ h8 p3 E9 y3 O$ Gmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% e2 G# M& ~% y6 ^/ q2 A
4 T& Q9 ?2 d8 KFailed.');
. C) \( C6 V; \, A4 @}
  K1 ?- o" q5 p0 X3 SConnect();7 ^9 A( q5 _' I/ C; N2 {- {

3 y! Y4 f: d4 _6 @7 [' B3 Y& ~) r/ Dfunction InitForm(){+ w: p+ K& V1 H% m3 A1 K
//layout for the form& g- c3 P  q+ }" v" [9 n# K* I
echo "<strong>Send Items.</strong>
  ]* B( g5 G. u* b: j<form name='select' method='post'>+ p2 g: L! e" s+ N$ r
<lable>Character Name</lable><br/>
2 J. X$ U7 {# m9 ^* v1 ?<input type='text' name='char'/><br/>
. }# k! g+ U3 K' T! @! M# q9 W<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 a* n" L+ x9 u$ u+ w7 Z<input type='text' name='item_name'/><br/>; ?* T. f5 R: f+ @
<lable>Item Amount</lable><br/>. v. C" \5 v* `2 X- Q
<input type='text' name='item_amount'/><br/>
4 r$ e  L9 }2 {" y; {, w$ Y<lable>Item Upgrade Amount</lable><br/>2 ?0 B$ L& S2 B
<input type='text' name='item_upgrade'/><br/>
% p/ n/ R+ \" _6 K& s5 g* {. ^<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). J& }) S- {) Y

' _. x  I, L1 ^1 ]</lable><br/>
9 f  N6 q! u* p! ^<input type='text' name='item_element'/><br/>" g9 \/ M) B4 e
<lable>Element Upgrade Amount</lable><br/>! g- M3 ?2 T& g! h. F4 t( @
<input type='text' name='element_upgrade'/><br/>, e! ]1 z- [1 N( N
<lable>Pierced Amount</lable><br/>( M) Z4 C7 P# m/ G* x
<input type='text' name='item_pierce'/><br/>
/ Q8 R2 j3 \. D5 w7 W% I  a4 G<input type='submit'/>. b" c% j1 M7 k! I7 Y# Q* d5 ]) G3 ~
</form>";. _# b+ X% k) a
}
1 e$ Y% m) W% O7 R/ _: U1 h% C# w; l6 k6 ^5 R0 ], H
function PostListener (){
: b" M, F, l3 m( ^8 C//Add more post variables if needed and add them to initform() function aswell
2 {9 e& U0 v% X5 H+ g/ V! }; q3 D6 r9 k. S* Y/ y  @5 ~
################################
. I+ D0 l8 w2 R##### Connection and Post ######
4 j5 [5 f% B8 h' ~, Q6 r################################( d0 o: \9 p5 B1 f
$name = @$_POST['char'];1 b' @' J# s. G# |5 h0 _
$ItemName = @$_POST['item_name'];# e  ]! [# w8 G0 Z+ V
$ItemAmount = @$_POST['item_amount'];, y& ?$ _& r$ i9 i8 C0 J
$ItemId = @$_POST['item_id'];! t  r7 B" H/ G) t4 A" i0 Y
$ItemUpgrade = @$_POST['item_upgrade'];# i* k( f2 ]! x8 v( t; s- X! A
$ItemElement = @$_POST['item_element'];, z( F0 S6 t% S5 j3 K3 k$ s! B
$ElementUpgrade = @$_POST['element_upgrade'];$ d7 Z2 p: l- D: |: L+ e5 I
$ItemPierce = @$_POST['item_pierce'];& h1 T( c6 U! Y: W7 O
################################% Y: o5 V, F+ J4 `" U6 w
8 J5 |5 u9 V+ O0 K5 i
//Check both variables for empty value$ P; V  Y7 U# w; R/ \  Y1 L

7 W. `3 n0 t% E# iif (!empty($_POST['char'])){
9 I4 |9 |( v) M9 @0 x, y. h/ ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where " Q* P! T6 n' L: e$ q0 k. Y

2 Y: b4 T% \; `0 C' U6 G0 T) v- Pm_szName = '{$name}'");
& V) X2 y4 A! i1 l% ^4 K( \while ($row = mssql_fetch_object($find)){+ b3 a1 n% h" e% x2 C! d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) R+ O/ X0 q6 _$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' Q9 P  w- ?3 f5 m" \
7 w- v, [# d% E9 p[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- V) [) n4 e4 D2 O' B/ C' v8 s) Q% t  I( U, C1 Z; j6 a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ! A, C" p: S! f; V7 D- F

: h. t- j+ y9 m0 I3 w& TN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 8 z5 l( H% y9 j4 v3 P( E- p8 f+ a
& _- R6 U  |1 l: f" _
'{$ElementUpgrade}', '{$ItemPierce}');");" m: L$ L1 y8 K* I9 q9 K& I
}
9 h: E4 T% p% G
% `) |9 C6 q4 ?0 J3 r; K% y}
! Z/ n- Z/ \, q" q7 B% @/ U; [: c1 Q1 ]; e2 i: v
}
1 Y' V, g- _! `5 E$ L$ ^  p; i' r( A1 b
$InitForm = InitForm();3 R+ Y- }2 k7 p/ Q( m* T4 e+ Q
$Listener = PostListener();5 H# ~( x* M8 s0 X

# {; G% e# c  v  ]( n?>
. e, A6 g6 r" m) o! T- h
/ r1 F& c- q6 H- W* J. i
. L2 p9 x1 @$ s( D: o' b  `6 p- w
1 e& o* h" _# |4 [4 A8 e
( [" F' A) M+ X# i. |4 h: q
回复

使用道具 举报

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

本版积分规则

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

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

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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