飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
# M: C4 g3 \8 E; Ofunction Connect () {
' _7 @, \, h' s* mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ! W7 J: Y$ b3 R' ~' \
+ _" U0 v9 n1 V
Failed.');
3 K  X$ M6 \; s+ W' z- d& l- q}# z# }8 Y. W4 v4 R
Connect();
1 g6 H. b! k1 o0 r% I' b2 u
: Y! C+ F; |, r  Ofunction InitForm(){
" A: o; q% C% f//layout for the form
# ^+ a/ }: N3 d& ~& Y% B" I) yecho "<strong>Send Items.</strong>/ B' W% A5 \$ A+ @2 [3 B
<form name='select' method='post'>) R% j. g' k7 v1 I5 T# D
<lable>Character Name</lable><br/>
) ]. y) J7 a& W" @, s<input type='text' name='char'/><br/>
: I/ i6 u. D) B6 I6 u5 p3 c<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 k- T& |. r; h" p" @0 j, K<input type='text' name='item_name'/><br/>& A' p; t4 s# p# n# K% O  t- T1 c$ V
<lable>Item Amount</lable><br/>
3 D6 i6 _4 C% L3 p' ]% \<input type='text' name='item_amount'/><br/>+ a$ |2 s: n! h& i) |( w
<lable>Item Upgrade Amount</lable><br/>; U( s  ?7 Y: e
<input type='text' name='item_upgrade'/><br/>9 N, h$ E4 {; |$ D( x; h! I# j
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)' V4 h0 ?2 b! w% g/ w7 S

. d- y0 h. ^5 R( Z" I% m6 o</lable><br/>
. ]2 H" O- j8 S9 f6 q; C/ r$ @0 L<input type='text' name='item_element'/><br/>& r! X$ \& C" _1 A0 X
<lable>Element Upgrade Amount</lable><br/>
& G3 f* O& u2 A( r4 P: F4 V<input type='text' name='element_upgrade'/><br/>
# E: {0 h8 `5 }/ ]6 ^/ S<lable>Pierced Amount</lable><br/>! S0 [8 i; g: g- V
<input type='text' name='item_pierce'/><br/>  p+ G3 }! Q: R7 L! K
<input type='submit'/>! D/ B! ]! N5 u1 P
</form>";/ y9 o  D; e. d" @
}
( [. S  ]; J& n8 b, D$ l1 I3 x
6 o# ~' z- l6 f$ x. L- ]& hfunction PostListener (){- [* N6 |7 \) e* z0 t$ x
//Add more post variables if needed and add them to initform() function aswell
6 U% J  O% b4 r0 T' P8 n: \& |6 h  i' i
################################  L- X. w( c( n. ^. y1 x0 A
##### Connection and Post ######
* y7 x9 C, ^0 K+ w################################  P- @" U8 h7 A$ d" F3 T% n( P1 g
$name = @$_POST['char'];
6 Y" z) }! y2 B( f3 J$ItemName = @$_POST['item_name'];
# \/ a8 p3 u5 M& p% j$ItemAmount = @$_POST['item_amount'];0 r) M- C" ?; J* O* k
$ItemId = @$_POST['item_id'];" H0 A4 g  V) x3 p* s) N2 V3 i
$ItemUpgrade = @$_POST['item_upgrade'];
+ j6 a+ C: q, C: b& j& @$ItemElement = @$_POST['item_element'];; v4 R( {9 W+ R: J1 h
$ElementUpgrade = @$_POST['element_upgrade'];! ~+ V- e6 a1 L2 J; L' k
$ItemPierce = @$_POST['item_pierce'];+ W' \9 e5 s/ h( N/ g  j
################################/ e. R2 T: v- u# X& g  \" A7 `$ O

. k/ A0 K! Y# U# e. G/ ^8 ~//Check both variables for empty value% h/ b& D; e$ c( u& J7 y# k
+ \5 I- I' `  Q3 z7 h
if (!empty($_POST['char'])){
& b0 P: z: t9 L4 m- w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' r5 {1 B# g" B. _3 M0 }, i# |- w' k" @
m_szName = '{$name}'");
$ d7 ]( M- X2 O# g) nwhile ($row = mssql_fetch_object($find)){
; K9 u! b- m& Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& @2 U5 f$ V4 u! i1 m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( A7 ?5 L- S$ t, V' N

3 H$ H% P+ `3 E/ v% @# c1 G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ m* J* |: h" Q0 M: p
6 G$ ]. e: r6 _; @. P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ' Q* Z, L# [0 ]) N1 w4 i# P5 v+ a

6 Q9 M9 F$ P3 U5 T: mN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* f% T; Z$ A: E
! v4 c) _& q7 K6 k* l' P& \. f9 t'{$ElementUpgrade}', '{$ItemPierce}');");
+ f& q% i  @  o3 j}! R) O/ u" O- K& L

1 N5 e) a* h6 }  Q}% B3 Q! N& T) _. {/ A7 T" x

7 W6 {& w8 M6 G/ u- n}
) K2 h. M3 j+ j6 N1 p
+ a' g+ S+ x8 \* u7 L- z+ l: w/ V$InitForm = InitForm();' H) I7 _2 b6 [* X/ ]% O. S( ^
$Listener = PostListener();# U- S" `* n2 U# e

3 Y) {# F' c- [2 u' C; C?>
$ u3 v, X& D* W- l1 e/ t0 U* g& |# @9 g5 e
# Y. Y- S; C" H: }7 W/ |+ q
# W# L% Y* l1 V' ~6 \! h! i9 X$ e
$ @8 Z: x6 q7 D# D: d2 C! P% w/ I
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-9 04:06 , Processed in 0.061802 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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