飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php7 Y4 a8 P1 D% G- D
function Connect () {
. [. w( q0 n8 b% M! xmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 F! K6 \% b' g/ w2 W5 }9 ]4 r* R# l$ j: o: }
Failed.');9 j  l9 @+ h3 |6 S
}5 R" B) d% _# ~9 E2 h; Y1 g
Connect();% \5 u* T# e# t) f9 E. f
% D/ z8 R7 o/ b( ^; D
function InitForm(){
- y5 Y# b. L/ u# S//layout for the form
+ M2 B7 @4 _% |* M# P/ O  Becho "<strong>Send Items.</strong>- i. M8 ?: {7 y) w
<form name='select' method='post'>. d6 v) d) E! N2 v; F& L
<lable>Character Name</lable><br/>+ z! |) F0 m- X* F0 y# P
<input type='text' name='char'/><br/>
! F2 Q9 i0 P- e/ F8 Y& q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' V+ U! S- z- h2 G1 b$ ~6 h2 w$ C6 H1 I<input type='text' name='item_name'/><br/>
; |) S" I" N2 y8 V( u. m+ t  W<lable>Item Amount</lable><br/>
! D* d) ^" J: k% n, C<input type='text' name='item_amount'/><br/>
; D+ F0 B  G, o$ b$ S0 j- Z<lable>Item Upgrade Amount</lable><br/>
0 Q% `! Z: d- y5 t8 D<input type='text' name='item_upgrade'/><br/>
; j; s6 n" L# f% [" S6 ?: M% E4 }0 G<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 K! S- R% }! p1 @
" e8 d. C3 N: D1 c; R</lable><br/>$ _4 _& |' J# V& Q5 M) u
<input type='text' name='item_element'/><br/>
0 W8 F( `& t  W  R; D5 ?0 ?<lable>Element Upgrade Amount</lable><br/>7 L% j. n/ r* _" H
<input type='text' name='element_upgrade'/><br/>$ w; H3 L- f; K6 K5 L( W
<lable>Pierced Amount</lable><br/>
3 _1 e! a& y1 e  u<input type='text' name='item_pierce'/><br/>  s/ ~" @6 A; J8 z1 I3 }
<input type='submit'/>8 o7 c( _' e5 K5 L' u
</form>";3 z5 Y& B) {! p6 S3 N1 H4 A
}/ ?& l+ }) @1 O: J. }$ V$ ~: k
$ V! L+ Q' t: X8 a
function PostListener (){
' ]: D6 @( R- H7 A& V3 z//Add more post variables if needed and add them to initform() function aswell
; }, ]' O/ D6 Q. Y3 n; N% U$ G. m+ x: q2 |/ N* s  l
################################% K( T9 z9 ]2 G* a: l8 ~3 X; s
##### Connection and Post ######0 u9 I# D0 R2 g' f4 U$ B; n
################################3 ]+ g8 p6 u0 D
$name = @$_POST['char'];
) f0 z; Y1 i2 e$ h  B! u7 l$ItemName = @$_POST['item_name'];
8 s5 s) X0 ~+ W' I1 O5 [$ItemAmount = @$_POST['item_amount'];
  }0 ]3 ?" ~' J& y5 @$ItemId = @$_POST['item_id'];
5 i1 v" Z9 k% u5 s, U$ItemUpgrade = @$_POST['item_upgrade'];: y, i% s' B& \, M9 `0 n: r: X
$ItemElement = @$_POST['item_element'];+ f% C* {- Y9 U/ Z% W, }9 i. b
$ElementUpgrade = @$_POST['element_upgrade'];. j5 n% h$ w2 k2 S# \: B; w  H
$ItemPierce = @$_POST['item_pierce'];
8 y7 u* Q. d, Z0 V################################
+ Q0 l. L; O& J, `& k! Y: {8 o" H. g8 A0 Y5 w, w; f8 l& R0 H
//Check both variables for empty value/ m* U; v! c& f3 z5 I3 q' Z% _# y
) v" G+ r9 ~& }+ g2 Q+ r
if (!empty($_POST['char'])){
: `" k* _& S  @5 L$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . R! C* m# }9 f! j6 O: W9 b& c2 P: L
+ n" ]4 C: [+ z: k# f3 q! M
m_szName = '{$name}'");" M* c% C+ U( ?9 k
while ($row = mssql_fetch_object($find)){
+ [  e! M, Y" Pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% S2 o6 R# S9 l
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], . K5 i3 ~4 F4 E" `$ D

- Y0 t* t5 |, k+ V! ?$ P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( Y, S$ h/ k% @
: c' ?$ y8 u( N! g2 h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; E) F+ y- i  _& }
! T8 E- a: A; x% `5 p" k& z% ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% m8 U; c0 K9 m: A, b) Q
* r5 v- B% q0 u8 y+ T'{$ElementUpgrade}', '{$ItemPierce}');");
, {9 g4 a) s2 [; E}
8 Q1 b9 H3 G7 Z. R; m! u" l. h8 v/ N% ^  G
}
1 N! `* ~3 E- {" }
+ W; h" ?" j) m! C}
/ W% [' ^. [2 N  H
6 @& M- w0 ^' g: E: h" X) A$InitForm = InitForm();
) f( y2 }( A0 w. F) A* ]1 ?: c$Listener = PostListener();7 @  }0 P# j1 V4 m5 O
3 Y; P7 }' a) D! v8 I
?>, X$ y8 ~) `4 j, q1 d) T
5 F( F% m8 _. K0 _' [5 l7 i

7 j. N3 E7 J" H" P. w5 E- q, k2 r5 `
* g' Y9 ?2 _) {( i4 f. i$ [& L- N7 G% o8 U7 J; _
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-14 17:28 , Processed in 0.108980 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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