飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php! _2 u1 L$ }1 S. v6 Q4 l: [1 H: u
function Connect () {: ]# q9 T& @+ _, a: J& R& p/ _% Q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 [$ k0 o0 l+ Q9 L* ^$ M
; U% E) {" ]+ o! wFailed.');
/ _7 o3 l( f2 o6 B# m9 s}- Q' A1 K: y& e
Connect();
& ~: J! Z3 Y/ W2 b) O, F# b( Z/ k
( F8 }! F: f+ efunction InitForm(){7 m( X6 H( v: a0 I6 o, D
//layout for the form
4 f7 z+ |, x  @6 g: a# wecho "<strong>Send Items.</strong>6 b* e& w- @/ @% q
<form name='select' method='post'>
; v4 y8 ^( x0 _# m, p0 `" _, Y<lable>Character Name</lable><br/>; W' P4 z( I. ]% Y% N3 `5 ]
<input type='text' name='char'/><br/>
% ^4 C) u1 Y4 m. S2 v  M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, a; X  l  i+ Q<input type='text' name='item_name'/><br/>
' ^# J+ f4 [' c<lable>Item Amount</lable><br/>3 A6 p! G8 T. m( N) X. I
<input type='text' name='item_amount'/><br/>
3 P& m8 i" [1 U* ~+ u% f& H<lable>Item Upgrade Amount</lable><br/>
, b+ i, r4 ], g4 M4 `! M<input type='text' name='item_upgrade'/><br/>
* y1 n4 [3 D+ Q9 M( ~2 |1 U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( r& n+ a" ~& V! G. Y
. o2 P; B/ Q* l
</lable><br/>
, H5 r# o2 y7 A<input type='text' name='item_element'/><br/>
7 {) _  w  E& _) m( @6 g& I<lable>Element Upgrade Amount</lable><br/>
( \7 e6 Q! C1 C4 p* Z<input type='text' name='element_upgrade'/><br/>
! v( W0 ~# W% v6 m* \+ ~) A1 A<lable>Pierced Amount</lable><br/>
6 ~' v# o6 l' Z1 l<input type='text' name='item_pierce'/><br/>' U9 o$ H( `4 C5 \5 B
<input type='submit'/>
! z0 G* r/ {' j& N: Z8 `/ C</form>";
: r: D$ |7 j1 A}
" V# `( ~0 i" ^0 J& l( C6 {* T" w" f' Q" F% x* }# n3 d9 H
function PostListener (){
5 ~. |8 P. _$ z, m) G//Add more post variables if needed and add them to initform() function aswell
4 @& p7 b. R# X4 R4 E! a9 a3 K; W3 t. u
################################
: N! b- ]: a( J& b##### Connection and Post ######- V4 T9 B  V* n2 `
################################0 A/ f: H: G/ d
$name = @$_POST['char'];
3 W6 G/ c  |/ f) c% _$ItemName = @$_POST['item_name'];
- K7 e( [. s; \; D+ Y# g3 z1 {$ItemAmount = @$_POST['item_amount'];
, f, A& Q' p7 }: [: P6 U) X$ItemId = @$_POST['item_id'];
2 f1 _) z, h- f6 t5 u$ItemUpgrade = @$_POST['item_upgrade'];4 C% `4 @9 H4 j: z, u' u
$ItemElement = @$_POST['item_element'];
, l  A- }' z  q2 P9 B: e4 o5 Q$ElementUpgrade = @$_POST['element_upgrade'];
0 z+ u0 f; n0 y3 W( G$ItemPierce = @$_POST['item_pierce'];
+ s2 g/ m( W2 ]. M% P################################
2 s3 O4 a& P/ [) Z3 V7 ]. }6 @6 v, V: F2 h# X" c' z
//Check both variables for empty value! S& x: s7 F* l

8 ~6 P2 S& j7 V: J+ G/ ~if (!empty($_POST['char'])){
$ d4 K/ G: U( Y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 O2 q3 O, c7 ]8 B% O
0 ]% v4 i$ e5 |& j( om_szName = '{$name}'");
2 I( ?0 G  ?4 ~9 z  C4 P" U, Z! Zwhile ($row = mssql_fetch_object($find)){1 @! `  }% c3 x' s, I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 Y- G% }. {8 x$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ b2 J4 n1 l( J
2 G, r# H" `  [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; r6 A* v; K' y7 ^$ P
: \2 v) ~8 o: F' L6 s' J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% {# d' y1 W* S5 i" D) f5 ~' A+ u" y$ u* Y5 m- k- E7 H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 6 O; D# N$ @+ b9 ~4 \2 [
8 T7 \$ p; `, J. _+ _* V
'{$ElementUpgrade}', '{$ItemPierce}');");
8 x% K) g4 c- R1 H}( W4 d8 p! M3 |6 U- C) F
; j' v' M, \, x: m2 n. e
}0 W% k& q5 R$ m2 T2 u8 c

2 ~" k. O6 j9 z) d* \) ]5 y}% j6 p' y! F" l8 ]9 P, M8 O
7 F# `& U4 Y0 V" p3 o5 a
$InitForm = InitForm();. S* _4 z3 b8 `! |  A6 o% i
$Listener = PostListener();
: K5 d4 r" I4 e
* l: L9 O1 @8 V4 x?>3 ^+ N8 o: A  B
1 p; r* Q! M$ k9 n! `$ {
' F) Y4 {3 L6 h! P8 s

5 ~5 t: w" r" r& Z! |8 S) O/ @" S4 c; W! I0 c
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-27 19:03 , Processed in 0.070491 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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