飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php: T7 ~1 |! c8 o! ]! X1 d
function Connect () {
  T: z: z; p0 r% n+ Bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 2 h% z; `# I4 Y. I. Y% Z# ]+ ~0 y+ o: {4 Y
$ I( c7 L/ \+ @! \# I
Failed.');( v% j" A% s& O* w
}
; B* T- l5 j  w# I, o+ z, D, BConnect();
! P, u  o$ j+ _: S/ o9 f
! l# J( k) S' y9 f" P+ tfunction InitForm(){8 K1 u! y, N- L. c7 @5 P5 ?
//layout for the form
; L/ {+ h! }/ X2 d6 Wecho "<strong>Send Items.</strong>
1 }; l" Y: b- n8 p+ z1 C<form name='select' method='post'>
2 o" x4 Y" l& l8 f6 q<lable>Character Name</lable><br/>
& o! L: k4 Q7 y3 ]7 U) v<input type='text' name='char'/><br/>
" |, T& s3 L7 f: W<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) ~' w4 l: |) t5 p3 _# H6 b<input type='text' name='item_name'/><br/>
" |* `/ W# L5 g. L<lable>Item Amount</lable><br/>- s& X: T/ o. \; f0 ^
<input type='text' name='item_amount'/><br/>
3 x: e6 X) t9 ]: u<lable>Item Upgrade Amount</lable><br/>
( Z$ a1 c1 I# ~& P" ^) ?7 z( i: J2 M<input type='text' name='item_upgrade'/><br/>& [4 ?4 S' S; ?) j4 D$ ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 Q) e5 }& l" k$ @0 n  F$ O+ F* @- P- y7 q% m8 x8 X/ W
</lable><br/>
4 |! `# y6 K$ _  V; t( F<input type='text' name='item_element'/><br/>
5 m8 }! \, p7 X. ]* @; y<lable>Element Upgrade Amount</lable><br/>& v$ A  C! w1 m/ z& b4 J  R9 u
<input type='text' name='element_upgrade'/><br/>
( f: z6 Q) V5 D, H2 a% [5 a, M6 L<lable>Pierced Amount</lable><br/>$ N/ ^' k6 H3 h8 ~
<input type='text' name='item_pierce'/><br/>) L- c, p/ {, H: |' E
<input type='submit'/>
! c/ b8 l2 H, J2 R' J, B* `</form>";
+ x, T# B. ?# \& @& S}& c. g# ?$ d0 m
+ f' v7 X7 _4 \; o
function PostListener (){
5 V& ?! X9 U7 d5 v5 L//Add more post variables if needed and add them to initform() function aswell; w0 d4 w% M7 \' f. o/ e

/ l# \1 d/ a6 z' M' p5 ~################################0 c  A' K4 ?$ q3 E: t  s
##### Connection and Post ######
- X( _. U6 p$ k% D- @( |5 ]. t################################+ I0 d5 s2 N. w( Z, d& ~
$name = @$_POST['char'];' T4 j& B' A) k  [: s" F! ]5 l
$ItemName = @$_POST['item_name'];; B3 F1 z/ M5 U$ b0 D
$ItemAmount = @$_POST['item_amount'];
# ^/ E' @3 `. {. E' B$ItemId = @$_POST['item_id'];
2 w8 P7 b. F& X( M0 C3 o& A$ItemUpgrade = @$_POST['item_upgrade'];0 _5 E$ U# \. z$ t6 Q0 m7 K
$ItemElement = @$_POST['item_element'];% v+ Q, [+ o1 ?2 M. l" `
$ElementUpgrade = @$_POST['element_upgrade'];
' U( ?' N1 g! X* F. M+ y, G$ItemPierce = @$_POST['item_pierce'];0 d2 n* E2 x' s+ p
################################5 a0 }7 q0 r' ~/ l0 N- N* u. }  \
0 E4 f0 l- N) u$ i
//Check both variables for empty value3 T- @' V" S# G0 Z0 h, M
9 C: C% Z! z6 ^/ A! D
if (!empty($_POST['char'])){4 ?' y+ L8 S% p1 n" }
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where - k  t! R0 ^2 x) D: w4 ^5 l  S
# }8 ~, D6 q+ [
m_szName = '{$name}'");9 ?( i3 ]& v( t$ C7 B; _+ @
while ($row = mssql_fetch_object($find)){8 f+ N6 U' w  X8 i1 u* T! S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";  Y0 S# R( O* L% p' V; f
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' q' R4 z! N& g" c4 M. X& d  B4 ?+ M2 ~. Z6 [+ u$ I3 b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], - N( x/ T: {, W4 |4 ]5 K

9 P5 `; y; b1 j8 ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 o" K  _  |! z# n+ I
, s2 S4 q6 y* N  D# y* ?. k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ L1 T: Z9 z% x2 ^
' q! ^7 P- v) p0 }* w. Y2 J7 Y& s3 b'{$ElementUpgrade}', '{$ItemPierce}');");% \5 i! }5 N! y6 H& M4 O& E( m3 a  y
}
; U# p! e% }& I2 V, w2 Q3 n
( n5 j8 e0 ?/ h- j" r3 P}
3 Z' F/ O1 T0 b) c8 A- F6 O2 c9 d) H$ b3 i
}
' s+ ~7 Q' ]8 ?  g( l4 l% J% x/ |  D1 E
$InitForm = InitForm();
; I6 W% k% S5 z+ F$Listener = PostListener();
0 L1 N9 s- k1 C+ X$ U
: q7 q. L7 Z0 n* L?>
. v; d7 P; b# ?4 j
+ l9 M# n# z0 h
9 @5 k! B) s7 y4 U. E; `' c4 ?# K  v5 @  S+ G: }$ A0 S

' y* o: b+ t. W% z  _5 z
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-2 14:03 , Processed in 0.067959 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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