飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php8 @3 m0 m+ k& k! K& l8 O( q: H' Z$ S
function Connect () {, Z# w* M  [3 I8 h7 [7 q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ T$ [7 v2 g/ q# x5 k( H' W( y

' p& I$ f+ L5 _: K; ^5 e: U7 ~Failed.');
9 V8 b/ x! N3 @}8 i4 m. q9 }8 a2 D) d" @
Connect();, ]. i6 U1 f1 p

1 j3 z; j$ R: O% ^6 o. Wfunction InitForm(){0 j) Z+ o  A7 k7 M) [
//layout for the form
0 i3 g$ E5 i+ d3 g" Kecho "<strong>Send Items.</strong>
; H' Z; y5 \% j; @% t, @7 U2 m7 [" K<form name='select' method='post'>
6 f2 I. _1 m( j8 ]- D0 Z6 S<lable>Character Name</lable><br/>; \# y- E* [+ z- k. t" q3 J) R
<input type='text' name='char'/><br/>
8 m" P; Y; i& k7 f% \; C' P" F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ J5 [4 N+ V( b( ]<input type='text' name='item_name'/><br/>( ~" r3 Z) A4 [. P3 Y
<lable>Item Amount</lable><br/>$ O4 m9 `" x( `( z% P
<input type='text' name='item_amount'/><br/>; E* C0 Q0 P' Y& C. x
<lable>Item Upgrade Amount</lable><br/>8 U, M! m' j- P$ v: O# W' x
<input type='text' name='item_upgrade'/><br/>
6 ]9 B5 v4 e7 z" Y& L" D<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), B# E6 A) ~$ v: ]8 Y
- J- b3 V0 y4 M4 u
</lable><br/>
. }! @2 ~( d" X' A" t  R7 q% ~<input type='text' name='item_element'/><br/>; l% B! t5 n9 d5 d0 J6 t
<lable>Element Upgrade Amount</lable><br/>
, Z5 s; O7 B8 u4 `<input type='text' name='element_upgrade'/><br/>
) G+ w2 W$ Q' e. J& X<lable>Pierced Amount</lable><br/>- [; D$ f2 T  f
<input type='text' name='item_pierce'/><br/>
& k! @* ], D; b1 G+ W; g) H$ P<input type='submit'/>
* G4 @& C# R6 p$ q, {+ a  u</form>";3 ?+ }% \3 ]6 g  E1 J3 q2 L& q
}
1 }5 u9 j$ e( {- t  R8 S# c6 ?3 `& N% u+ t1 Q
function PostListener (){& F+ J( n, g+ F" I. j4 D
//Add more post variables if needed and add them to initform() function aswell
, q0 [& B. U# b! ^* Q0 p" D, U5 N$ @7 S4 l2 S
################################
- w- x2 i& h2 s0 y+ b( }' A##### Connection and Post ######
. q% @1 f! p8 l+ x9 p################################
! j; Z& r4 p+ m9 @9 p$ b$name = @$_POST['char'];
0 [" g: P& G2 I8 p/ C3 o+ j+ S" @$ItemName = @$_POST['item_name'];
8 D( ]. t; T+ Z" Y) p3 ?# S# D$ItemAmount = @$_POST['item_amount'];
' _" @1 F/ [9 W" o( ?& k2 Y$ItemId = @$_POST['item_id'];( c2 i; T# a( T
$ItemUpgrade = @$_POST['item_upgrade'];4 o! h1 C# h4 v8 @  S9 a
$ItemElement = @$_POST['item_element'];% ?- c  m" u; K; \$ r
$ElementUpgrade = @$_POST['element_upgrade'];! g) i) T- k- W2 S/ q
$ItemPierce = @$_POST['item_pierce'];# L$ l9 K8 A4 c3 ?  ^
################################
( K$ y* o6 I% ~# _  A' t: q; U* U9 }4 H" k" ^
//Check both variables for empty value2 M& \4 C. a' {4 \
7 b) t# k* l# j# l! c+ {
if (!empty($_POST['char'])){3 n  T4 i% d. _) t% o/ T4 ]: M% r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 e) l8 F$ O, {' F/ @! q% D
% n$ ?5 z8 |' }6 Lm_szName = '{$name}'");5 b4 s8 J9 g4 f, z8 Z! i
while ($row = mssql_fetch_object($find)){/ X' M! {$ B, c' q3 }; R! g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";" E: u4 u. M8 a7 J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ h# l0 G- H, N5 p5 e' q# p0 [1 q. p/ w! K0 G. T7 r) ]& W
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& H5 L, Q- q3 k  W0 S
/ g/ U9 f7 B( N9 K, W; R7 ?[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , L& w1 D; _1 R  s$ `

+ t* I0 q2 c( U' [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',   W2 u9 g6 I5 T1 W5 Z
% S% Z- B2 |& K3 }+ \. D
'{$ElementUpgrade}', '{$ItemPierce}');");; d+ a" g) h" ?  @
}( Y4 c4 u  v5 F

0 \+ {/ n3 d* E% {4 B  s6 K}
  a: ^  n3 {4 ]. Y7 f* q" ]# ^5 Q# j9 r7 a* u/ _: B  r  \5 H
}
; ?' W: X3 Z* X: m* \4 @3 Z; D2 [6 T, H* E" S
$InitForm = InitForm();) f3 ~" }& L) U. Q) @6 ]2 [# q
$Listener = PostListener();) F, i' V0 E$ h* Y7 p/ d

% _* y* ]: i4 _0 Y* s?>
8 ?; A' v' ^7 g2 X% S& i* u
+ i/ p0 L6 g* F# Y
6 h4 t3 `1 @) d8 {4 I( F1 B8 I$ O: Z- u: E: a" l  E
/ r1 v$ s+ ^5 }1 S
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-31 01:45 , Processed in 0.085116 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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