飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1092

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1092
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
! \: T- ^; l6 d; T0 Bfunction Connect () {0 t* k9 d$ D, _
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 |+ b: r& q8 l6 b* o" L! [9 _/ Z" u

5 x/ j; Q$ K5 T& M' BFailed.');* N% N) ?  N- |
}
3 Z4 x; {( U6 W" yConnect();
. n6 t5 t# r2 f" u& u
, e, {5 W) @0 g. {2 Hfunction InitForm(){( k# `5 U& ]  h8 E8 e/ U0 ~- t
//layout for the form' I, I6 Q, U( _5 m" t; ]
echo "<strong>Send Items.</strong>8 a0 U; j* K% _
<form name='select' method='post'>/ y" z& h% D9 @- \% ~
<lable>Character Name</lable><br/>
& n7 W2 ^$ s% z+ S/ U! G, _; C<input type='text' name='char'/><br/>2 K" Q# ]8 D- `# d7 K3 g
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: a7 {6 W- Y/ r: [<input type='text' name='item_name'/><br/>
. p9 n6 E8 S: R' I5 m8 _% X<lable>Item Amount</lable><br/>3 B9 R# Q! j% z2 `) T! w
<input type='text' name='item_amount'/><br/>$ p9 r8 g; s, p& p+ n& x) X8 A
<lable>Item Upgrade Amount</lable><br/>
' `8 l. [8 v/ y% _<input type='text' name='item_upgrade'/><br/>6 d. [4 ~' ]# c/ M5 X
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% B% H" \: ~2 Q2 t) [9 V

+ k. ~+ k/ I+ w8 g</lable><br/>, w* w, d$ O' h. ?
<input type='text' name='item_element'/><br/>  f1 V5 p7 A3 n6 d: O1 B1 f
<lable>Element Upgrade Amount</lable><br/>
8 C! j6 r) q* r( S: z<input type='text' name='element_upgrade'/><br/>
, P1 x% r! Q+ }4 i" d+ G<lable>Pierced Amount</lable><br/>: q  I1 c* ^" J$ `! L  h
<input type='text' name='item_pierce'/><br/>
! W  b! `4 H# _" N; u<input type='submit'/>7 P' R8 @9 {0 d. [
</form>";
3 I" ~8 ?$ ]% I) Y0 Z* p}
( c! M2 H# F/ g6 {, G
' Y: `1 s. ?. m* m5 ~" P  T6 A* bfunction PostListener (){$ I7 p7 r6 {- n9 m$ u
//Add more post variables if needed and add them to initform() function aswell" c  V, E0 O. {* S/ `2 X6 R

  a, H' x+ _4 Q$ n6 K, x& v) c################################
& r$ j, k3 l, W% Y+ k. b9 @  _##### Connection and Post ######1 n3 H$ J  u8 _0 d) Q) v9 l/ m2 U5 K
################################& r: y+ q$ ~  R$ T0 N) o5 ?
$name = @$_POST['char'];, T: ~0 \1 i0 V" E7 N
$ItemName = @$_POST['item_name'];3 A; O% z8 B; a3 q) y: e' X  t
$ItemAmount = @$_POST['item_amount'];
; ?( K" n/ G$ {2 b$ItemId = @$_POST['item_id'];5 d: \' P, }0 m* i( ^
$ItemUpgrade = @$_POST['item_upgrade'];
, k) e) n9 i9 j; b4 S$ItemElement = @$_POST['item_element'];; R2 e) q& U5 B4 L: c
$ElementUpgrade = @$_POST['element_upgrade'];
5 F  y7 Q+ f, i% k* s+ b, ]$ItemPierce = @$_POST['item_pierce'];
1 y4 S. z6 M7 ~& x) s################################
2 ^) Q! S; p9 l" [2 Y; @/ y2 ~  x  p9 u9 P/ i$ @
//Check both variables for empty value
/ L# O% r3 {; |4 C7 w+ F" `( v  h- n* A: x( q. D
if (!empty($_POST['char'])){
- y! z! f* D# j) d+ t0 n$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 i6 j  _3 {9 e" {" n
/ h. a) E6 F& Q! R. K$ h# r
m_szName = '{$name}'");( U% o: s% n6 K
while ($row = mssql_fetch_object($find)){- M0 ]# O% K( S' t
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 a" e9 w$ ^9 O$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 `: k+ [' m0 ^) h; @, V1 w9 x
: w$ G6 @  Q% q' |
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + Q) T- H# N- Q8 H; \# ]9 w! ]

) R# _' b8 \. ~( g# T, |& a[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 p5 J: g$ g6 I" A% C+ m$ ?, B6 f6 \4 p! d) B4 w/ I3 Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ H6 u* H8 s8 y: u' S5 V) F
1 z4 a+ `, M7 @% ?'{$ElementUpgrade}', '{$ItemPierce}');");
6 o% p, T0 p, [8 ^' m# M9 N+ o}) ?5 Q" g( w8 O/ q' t0 ^1 J
9 _' [. M6 Q$ |1 [) N- [
}
5 O* o/ k2 L, {% Y1 w4 X- Z* e, v" E! a, d1 ~7 f
}4 e9 K$ _& x5 q1 n2 C

" A# m# C; Z6 ^2 B$InitForm = InitForm();
* ]$ |! }2 O- k( v. ]$Listener = PostListener();2 z/ [% a, Y' _+ u( U# [, z
8 T9 M; r$ Q# N- L  X2 i
?>  a% h/ e1 |6 B# h8 }9 y: A; h
0 z6 I1 e3 R; l. e3 Z$ F5 A0 ^
# f9 V+ \, A6 Z8 b2 ^5 [) ~! g
9 X" R# N# `* p+ b0 E1 Z
- _: n! g4 Q  C0 X: q4 S: j
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-29 11:13 , Processed in 0.078925 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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