飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php( l2 x) K/ G$ b, h/ ?
function Connect () {
& c/ V5 ]' \  u3 V' hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, b" `; @8 A  D; @# ?; P' X8 n0 P+ V1 n/ I
Failed.');) L0 ^2 x. U/ a7 `: i
}: u8 L6 g1 K$ s/ s2 l) G$ \
Connect();
1 s% F, ~1 Z, F" S! |& {2 b
( h% q" K4 Q' d+ K# E4 vfunction InitForm(){
- P. ?9 B6 Y" A! y" g! h//layout for the form# k/ A3 y! I3 z; P5 i; p& ^
echo "<strong>Send Items.</strong>- G9 b5 d* m0 k  E" E8 }* x% d
<form name='select' method='post'>* ?- P( g, M* x1 Z# @
<lable>Character Name</lable><br/>2 j% T) o: B8 z( O+ a
<input type='text' name='char'/><br/>* ~3 R' j0 X- a+ p4 G9 R! ^
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 ~$ Q( \% ]" A3 P; e<input type='text' name='item_name'/><br/>8 O9 I+ Y9 |$ ^8 [1 O; }
<lable>Item Amount</lable><br/>* b0 E: e4 e+ `: ]# Q( v" O1 d% T
<input type='text' name='item_amount'/><br/>( U1 _6 O% p( w4 E' \- \; ?1 P
<lable>Item Upgrade Amount</lable><br/>
3 K; ?! Z( o+ E" C& d" E9 ^5 n& a<input type='text' name='item_upgrade'/><br/># B( O3 O- x% {% N$ B
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)7 R+ Q+ h4 O; M' L2 g, P7 v
5 V) p+ ^4 c$ q% q( V: t
</lable><br/>
& l& U2 q  y# l3 n1 v* d3 p<input type='text' name='item_element'/><br/>
: j' _/ W* n0 b<lable>Element Upgrade Amount</lable><br/>' j- Y" m" w: Z+ }% |9 D: ]& e# x
<input type='text' name='element_upgrade'/><br/>, Z! [* N& t) O" b. g% I1 }' K
<lable>Pierced Amount</lable><br/>  \  W8 G1 r2 O. r) z
<input type='text' name='item_pierce'/><br/>, c. g- B# @7 Q
<input type='submit'/>  d0 K3 V5 B. e+ f
</form>";" z1 Y- L' |# C2 u% l
}
( s6 q6 i: b0 e$ m
( X0 }; j2 |& P1 ifunction PostListener (){, z: O) f  `. t1 Q. Y
//Add more post variables if needed and add them to initform() function aswell
$ H! R4 j1 N. w/ r: Z' ]4 {& O
% \% d$ P" U' y3 d& M! A0 t: o4 b################################# F" H  j! a+ C& N2 Y& E
##### Connection and Post ######
5 b7 u5 J8 Y0 n) s2 o  f, z################################
( S8 ^( t! i8 y; j9 }% k$name = @$_POST['char'];4 r: c9 h" \. ?" p& U$ D
$ItemName = @$_POST['item_name'];
( v% z! o7 I: J. w, L* X$ItemAmount = @$_POST['item_amount'];8 r& N1 \) p8 C2 k% ~) Q' C
$ItemId = @$_POST['item_id'];
8 K! C. w$ T: K5 [" P9 p- _$ItemUpgrade = @$_POST['item_upgrade'];! f; Q- V! L# C( v9 c  B
$ItemElement = @$_POST['item_element'];
# R- Y! \! W2 b9 V2 B; j$ElementUpgrade = @$_POST['element_upgrade'];
2 T$ _0 @* J* b: W& R6 S$ H$ItemPierce = @$_POST['item_pierce'];
! s9 s# J- M  d% p+ Q5 B5 v################################: I; S2 y: n+ @! ^% O2 C. p% h+ O
* v3 g& i2 a# g8 s+ e' q# K2 F, E$ o
//Check both variables for empty value- |- c. J. x* a: p/ }! [- k
: u7 j3 K: T9 U9 Z/ c
if (!empty($_POST['char'])){
. c4 k* w0 m" D. Q+ D7 s1 A$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where % ]- ]: Q( m; @2 |' M& [# f
% V( ~6 I2 g5 ]# @
m_szName = '{$name}'");) C: \( U" v4 E* V: d- }; M
while ($row = mssql_fetch_object($find)){
- y% v6 @: W& a& @! @+ p9 Q  oecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";$ a6 M$ D* r4 u5 s$ ?2 i: [, ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , Q' m- D3 m: R/ z3 u! ~, B

2 G$ T' a: r; v- F, P. \) E3 Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 }! _- l' M/ y- o5 y" U2 g$ {

2 c1 V0 X2 v" b8 q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  C, G' ]9 A( P2 u
9 w& U& q. {' l9 W; jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # V: H6 a# Y( `+ u' o

7 {) N" I1 y' L' g'{$ElementUpgrade}', '{$ItemPierce}');");
$ p, n7 ^( B) e. _# r. c% ~% F}# I1 D+ k/ d% t. c
% r: m7 |4 v' ~) D% `; g3 Z$ M
}; l5 v: ^" J3 P- x* ?' @

+ K5 @3 s8 h/ v+ m}/ `$ ^7 V, b0 O) {0 h8 S+ ^

% |( q9 k7 x' m1 F$InitForm = InitForm();
- O- r: i/ p! d; p+ f; k$Listener = PostListener();$ C1 G9 [4 [$ f/ O. S

- \$ H' _* {& g; H9 r?>% T7 v5 u' W  p1 a: K7 `( ~
6 c7 ]: C  O( W/ X" U* k

3 x, Z# ^# I; \1 ]4 D4 ^' X1 `' y) h3 g

$ @1 J  \: e* R5 g5 V1 |6 N  I
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-17 11:18 , Processed in 0.149835 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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