飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php) m$ p8 E0 @$ n! X. Q
function Connect () {
( O* Q6 V8 ]9 o( `1 _! T, v8 Zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( a" P7 k0 g0 M' J/ L7 R8 S/ D/ Z  Q! ~# y" @# J2 b6 ^
Failed.');
; ]6 O$ i- d8 e" G& [+ b# ?}
- [: f# z( _# K* |. ~Connect();5 c8 n: y6 P' j* E/ M4 n' ^4 t

: ?# c  K$ g# o  e+ ~6 ufunction InitForm(){
/ O& W, k* U* ]//layout for the form. t( U/ |7 e" D7 \
echo "<strong>Send Items.</strong># C" P, R1 `  e! U: L
<form name='select' method='post'>3 L9 F% b- @# L  I1 m, v
<lable>Character Name</lable><br/>; ^2 I5 u) O" L! q
<input type='text' name='char'/><br/>: N: L+ z2 t/ C- u8 A4 x' ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ [/ D( R: j5 N0 U+ j- J
<input type='text' name='item_name'/><br/>
7 k( H/ ?8 X; f# C  c<lable>Item Amount</lable><br/>
' G/ ]( i1 H$ ^* k) m<input type='text' name='item_amount'/><br/>" \; y/ D) V  A  `% t4 x( ]3 J% Z7 ?2 I) p
<lable>Item Upgrade Amount</lable><br/>1 v) ]& Y0 O7 h6 M+ q/ k- Z
<input type='text' name='item_upgrade'/><br/>, s. U  E+ k$ A2 [8 z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)9 l5 z/ P% n, R8 c

! k/ s# k# i; g1 d</lable><br/>/ Z4 o: B8 {5 B( {2 {3 Q3 \( `
<input type='text' name='item_element'/><br/>7 z/ i0 ]% T& o9 C- x6 p
<lable>Element Upgrade Amount</lable><br/>
% ?  J, C: L' u  e<input type='text' name='element_upgrade'/><br/>
4 b7 W& S- N( `: z( j<lable>Pierced Amount</lable><br/>
- B/ J: n8 Q' [: p, {<input type='text' name='item_pierce'/><br/>0 P2 Y. u5 F: m/ `; f
<input type='submit'/>
" @+ o- I7 F& a1 x</form>";9 b* p1 G) n; G/ W5 B  S' N
}: }, m9 F" G$ `: j
/ }$ \. ~1 b. t, @' Y
function PostListener (){
8 \# ]3 b+ a6 f& c//Add more post variables if needed and add them to initform() function aswell
0 `7 c# o# P$ r& J" c
' z  K9 L& M8 h' T( Q7 I################################
5 b9 e5 M& r0 c. h##### Connection and Post ######. k3 n( {  b# K' o- W& V3 D
################################7 d: w/ p% Q- O: T# t
$name = @$_POST['char'];3 ~* A# V. p. e8 D2 ^$ Z2 S
$ItemName = @$_POST['item_name'];
  L3 |  S  d9 z9 \$ItemAmount = @$_POST['item_amount'];; ~2 ^& y) I7 x/ Y
$ItemId = @$_POST['item_id'];* R) W1 G1 ]& _( v3 ^+ i
$ItemUpgrade = @$_POST['item_upgrade'];/ Q+ T1 C5 @2 G4 D
$ItemElement = @$_POST['item_element'];
- B$ C4 K% r1 h8 ?6 u- U& b1 A$ElementUpgrade = @$_POST['element_upgrade'];: v; E" _1 C6 C  Y
$ItemPierce = @$_POST['item_pierce'];
+ l9 V7 m( |; I* P5 h2 v################################0 o( q  T* G/ G( p' x2 |
/ U' ~' p' v- h! A, L2 D2 B& b. U6 z/ H
//Check both variables for empty value$ y% [) Z3 R* p4 |. o, P# y! e6 s
$ m$ y7 G7 z; U' x) D2 y4 J/ [. z
if (!empty($_POST['char'])){
7 M1 X9 [( u0 t* x. q) C; x$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# C! @- `4 o- y3 z- C0 m
% h+ E' B# }0 l* j9 xm_szName = '{$name}'");
( \2 ?, }7 W3 Q1 p" i! E" {7 ywhile ($row = mssql_fetch_object($find)){
7 Y- Q. Q3 g, i# Hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 ]0 u/ s! T% r+ E4 m* c$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ e) P5 s9 d( s
6 x9 z/ D+ |  Q  Q* Z% `5 ^[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 h5 U, d" N* ~8 Y
* q: T+ O& i7 {# ^% F[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 r* G8 z2 U, v/ F1 [5 Y

0 W" q) Y+ i  v9 ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# q% ]& ~# ~( l
0 Q/ m. T0 Q* y; X' D% ?  c1 F'{$ElementUpgrade}', '{$ItemPierce}');");
9 R# J! F" o' s$ H1 {/ E}, J; P* R# v! G# t$ Y

9 R# Z; }+ D: H, d% [}
# k1 U/ Y% X2 ]% Q( W: w0 o) g' I' b
}0 s# G; R+ m. W; {& T% o9 @

$ _( {; P7 I$ ?" e# A$InitForm = InitForm();! E2 P* c. V7 b+ k
$Listener = PostListener();
: b* I7 b" q; W; p+ M( D1 E+ M; U  x5 N& e  d3 O( g8 V
?>
, \& s- |* p7 n1 Z
3 [( ?/ b: R$ s/ D, o3 k. a* m2 N3 E/ t/ t

2 D1 H% B4 r6 \: f: R7 R" }6 l1 B8 |
* k+ q0 S( k$ _
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-22 17:06 , Processed in 0.059770 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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