飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php' i/ ~5 B7 p! ]) A6 Q' c5 F
function Connect () {: P" n- W9 _- w- G) W0 m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 F& v2 u2 [2 K+ ^. y- N5 ^! M) j; A* j$ J7 M
Failed.');  B. M8 `( z/ m4 E& O$ `
}
6 O! o+ ]% r; m" I6 y' A; gConnect();
' N/ h$ n: F, x1 b) N7 O% M* G+ p& G+ h0 o6 |
function InitForm(){
. T3 @2 `9 F5 L//layout for the form9 Y* V* t+ r/ n$ v8 n5 k
echo "<strong>Send Items.</strong>/ O( z( X0 L( U- g9 q" {# c- n! p
<form name='select' method='post'>  Q3 W. C6 g+ m0 y: Q9 b6 S8 E* L
<lable>Character Name</lable><br/>
# w' ?, m  {% i<input type='text' name='char'/><br/>
6 d2 h3 Z% E3 ]) R' o) q, z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% A* {/ y7 ~0 r6 q# ~+ r! _<input type='text' name='item_name'/><br/>& ]3 u" m- {/ A/ C; B
<lable>Item Amount</lable><br/>$ {+ _# I) ]  Q& e8 Q
<input type='text' name='item_amount'/><br/>
/ ^3 O$ |* [' _5 _) x<lable>Item Upgrade Amount</lable><br/>
5 }' F7 ]5 G6 G# d/ Y! ~* ]9 m<input type='text' name='item_upgrade'/><br/>
) I4 d' g, T) m% t, X<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 e- B. W- C; R5 O& {* l
( Q' x, e( }+ r8 ]</lable><br/>
9 a# e1 f* R6 s+ \5 M<input type='text' name='item_element'/><br/>
1 B. W% {! M0 V) X. b; h0 A<lable>Element Upgrade Amount</lable><br/>
4 ^) F# {7 J. {& D" d" T<input type='text' name='element_upgrade'/><br/>
# Y7 s# n8 z  b  u<lable>Pierced Amount</lable><br/>) u9 D% E( e7 }; U
<input type='text' name='item_pierce'/><br/>
& A5 b* H$ n4 g0 ?) Z% H<input type='submit'/>3 g( {: z- o* E! U3 H
</form>";
0 q# g  [  H* @5 W' Y}* S- Q/ m3 U8 a) w

# T1 n+ @& A" W* I- [function PostListener (){7 a5 T- {3 {  S5 V' m0 M; f1 b' H- Z
//Add more post variables if needed and add them to initform() function aswell
# @, J! v$ N1 B8 w4 G/ |; K2 C/ {# H6 |
################################
3 T' I' i, h+ m, g' q7 u0 I; N##### Connection and Post ######0 g7 {. E# l- b4 E) g2 o6 R  J" N, m
################################, \. p+ X" v6 A# _
$name = @$_POST['char'];+ Y! k7 ^$ S  a. ]5 e3 h
$ItemName = @$_POST['item_name'];0 f  E* c$ l  v5 D( X5 d% T3 x
$ItemAmount = @$_POST['item_amount'];. E7 x1 s% R" ^. m$ U4 M
$ItemId = @$_POST['item_id'];
9 D" e& {" `  B0 ~$ItemUpgrade = @$_POST['item_upgrade'];# O; y2 I& k5 n( p8 M# Z
$ItemElement = @$_POST['item_element'];7 |1 J( p5 B0 Z1 @, ~/ f, s
$ElementUpgrade = @$_POST['element_upgrade'];
8 [* }, q6 n- v; _, l# N/ y$ItemPierce = @$_POST['item_pierce'];
5 i1 b' ]" n% X. {################################
6 F/ T+ R6 Z( _
/ m4 Z# q, `$ S( w; n/ _$ s3 }- I//Check both variables for empty value7 L1 G, W1 I! ?6 b: J9 |$ L

) S6 O4 C9 X4 C9 hif (!empty($_POST['char'])){8 T) F7 W. Q3 y  t. a, G: x# O
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, a3 X, A- `; k, B# Y7 f4 Q. m
7 C9 z$ y. N& d7 R+ M0 lm_szName = '{$name}'");8 u+ A1 e& R6 E! e& e
while ($row = mssql_fetch_object($find)){5 Z" j4 f; ~2 \, y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) i, R% u, A: |$ J* ]+ t! [2 O$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% O' X) B5 p" d/ i: |, d8 g; p8 ]! J. p3 b8 t) P
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ d3 u! |3 P8 M& ~8 c# G) G! Y
0 |# l3 P8 |1 ?# S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% p* v' a- r' w, y2 U) \# T$ i' a2 P' ~& H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ b" Z* k9 P3 g/ B9 X* }
9 T" t0 M! a8 h3 y
'{$ElementUpgrade}', '{$ItemPierce}');");
3 r3 t3 b$ _  R8 z" W}3 H$ E- h) r( @

9 L9 U; e$ Y  i& ]/ c% P}) Y1 I: V; F  g  P; a8 l- [
# P( j" Z0 c" h% D  G
}" ?" w! u8 d  l

5 H0 v  ]' g, m/ v2 s0 x$InitForm = InitForm();
( ~: q0 F6 R/ `9 e6 V* @& H5 \$Listener = PostListener();
# S. C; p; _8 ^9 L: |
' j3 Q: {2 e* X; |2 `( H: z5 K4 u?>
! M8 Q5 c* y0 F' S: O% B2 s# _; k9 t, ?
1 U3 G: ?. o: @9 g! G' i
  ?: \+ W) g2 n. @& Y" ?

* f7 `- I) a& B2 Q
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-15 21:46 , Processed in 0.075585 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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