飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php, e' F+ _  k  ~, m+ p
function Connect () {
# _9 G+ \% P- V" ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: T% j. M' Q0 |; K0 ]6 ]# x+ \  L
8 ^) F5 S+ D3 [7 _6 U4 X# E* lFailed.');
" G! `  [3 U2 k9 k}
0 ?7 d. {; H& T+ J$ n) Q" H2 \1 N# XConnect();
) d: L  R7 @8 E  P8 o; C5 V" I0 @/ m
function InitForm(){
$ p# `* G2 |1 V; o9 n+ M//layout for the form9 S( o1 C! T# X. `  v7 \
echo "<strong>Send Items.</strong>& _. w& s2 B9 v; d2 Y5 X! Y" D2 r7 h% n
<form name='select' method='post'>
5 O$ o9 x8 N! U/ Y' |) P2 N<lable>Character Name</lable><br/>2 ^! |: b: s1 h0 d
<input type='text' name='char'/><br/>& e1 T) M) z+ I: N$ p
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- D0 f+ ~; c& e; }5 n7 @; o<input type='text' name='item_name'/><br/>
( A1 a6 }, J6 U1 k# C. `/ s4 z<lable>Item Amount</lable><br/>" e  z$ M& s$ O, X6 z/ `+ _
<input type='text' name='item_amount'/><br/>
  _, J1 [! u5 n/ H7 V<lable>Item Upgrade Amount</lable><br/>5 D& _6 B1 A5 `! ?5 B6 b
<input type='text' name='item_upgrade'/><br/>
% M; p# i3 d3 }3 P( l- u<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 E6 J' B5 K% u4 |

& o- e8 q- j, B. P8 _8 \0 E. r" a</lable><br/>* [; z; l7 _) i1 G% @8 m8 u. {
<input type='text' name='item_element'/><br/>
/ Y; e& D2 [" a1 ]. X( o3 U! t& H<lable>Element Upgrade Amount</lable><br/>4 Z6 u# o; G  {. B
<input type='text' name='element_upgrade'/><br/>, y! B4 {% b: w) |
<lable>Pierced Amount</lable><br/>! Q% S: c4 M5 B) ]6 X' f8 G) i
<input type='text' name='item_pierce'/><br/>7 {; }9 T0 f8 c! i/ X
<input type='submit'/>
- V1 v+ B5 I$ @7 U</form>";% k- t  T/ ]$ q: ~. r, X9 f, a' s
}
5 b8 d$ N* w# @
8 C& a2 r" R/ z! xfunction PostListener (){
( I) X4 t7 \" `0 K6 p//Add more post variables if needed and add them to initform() function aswell
0 g; a- F- f0 N0 r; y3 K. z( m8 J" X$ A$ M  }
################################" x3 L6 m* o' M, t9 c& Y
##### Connection and Post ######' M1 g- o( x6 X  x
################################5 n  X7 s) P8 x2 b" ~, U- q
$name = @$_POST['char'];7 m/ q# C, r+ o, a, e" O. Q
$ItemName = @$_POST['item_name'];6 {  R& p, |+ q+ X  @, o+ g3 P! k9 U4 U
$ItemAmount = @$_POST['item_amount'];
* T1 b7 c: v: X0 f( u- i7 a7 S$ItemId = @$_POST['item_id'];( I& v9 G; j' K; C
$ItemUpgrade = @$_POST['item_upgrade'];* f$ |9 y* f5 i& \! K1 [- j. z: j
$ItemElement = @$_POST['item_element'];6 d. D0 g  `# W; i% {
$ElementUpgrade = @$_POST['element_upgrade'];4 J0 a$ Y' R% w' j+ T
$ItemPierce = @$_POST['item_pierce'];
; l/ W. N8 I' U, A- O4 J+ s################################( ]7 z  w. l4 f+ ]% |2 D
1 |2 s* S% N2 N% E8 M" x- Y# K
//Check both variables for empty value
/ B; j7 N1 w1 l7 k  z
, V6 A# P! v) y1 d+ J) bif (!empty($_POST['char'])){  g/ w0 Z8 I- O# u) a# c6 F" R
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % L7 k5 S% v, \) d4 ^6 p

# C. \3 A9 |( K3 N/ |m_szName = '{$name}'");
: U1 B: R+ F% H( @9 b  o; A& Swhile ($row = mssql_fetch_object($find)){
! c3 o* k3 q' f; J( xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& c/ A/ R3 B( }" A4 ?4 e- T
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 O+ r/ W# K6 h9 r% l
$ h, R6 a6 S' H- `/ C9 f[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. w4 h& m; M* X. o1 c9 ?' g
" }: i" E3 A/ C( w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 |2 m' p; S& D' K2 m4 M: H, A' ~- k( `. [* J7 L5 ]) G+ P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 5 k7 U! M8 x( d% Y4 Y) F

1 q3 F% \1 V" t1 W; B: Y* C'{$ElementUpgrade}', '{$ItemPierce}');");
$ B! ~0 d2 S/ j" M) l; L}3 {* h8 P  G: w/ L2 \. H
1 G7 `' c% Y$ |) }8 P* g
}
, E( O' `; ^1 I, U3 o
# y1 W9 Y( }7 G}
: \/ p) w/ I1 ^$ ~% W, |2 k1 c0 V4 _: T9 a1 B
$InitForm = InitForm();
$ L5 i$ c3 c: v) y$Listener = PostListener();
* y% ]$ \* O3 p  w9 }. N" C. v$ {+ h) O5 n6 z$ V& ?! S
?>
8 c# Q* k9 X; F3 u6 H$ \, `3 ^. C7 a/ `  h+ ^% Z+ j

  B& q4 M/ N6 r2 ^% k2 m: z5 @/ |  t; |, N$ n' I  T* f
' g0 |! N& `( m" A. P8 a
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-3 06:46 , Processed in 0.066085 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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