飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
1 ~9 n% y& r! M$ E# z6 k* {7 nfunction Connect () {
8 j) r" ~6 H+ @1 q0 T, bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; ~* s$ X) N5 @( s* Z8 U

; L' |+ M" t- e# y) S0 IFailed.');) U' T$ ~0 D! ~% n. Z
}8 y0 B0 X' L: H+ E* ~9 T! x2 u
Connect();
; p6 r# r# \  D; Z9 O/ n0 H# f9 v; M$ _% M
function InitForm(){; I5 a' E0 ]; z- ~6 w, R
//layout for the form
3 I  t2 _% ^: W5 vecho "<strong>Send Items.</strong>
, l' G. ^) |0 r$ y( F; `8 \<form name='select' method='post'>* x: h% @) v8 C' G7 r. c
<lable>Character Name</lable><br/>
* C3 E; f9 d+ E3 V% S( n<input type='text' name='char'/><br/>, g, C3 E9 {6 O5 ]3 l8 {
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' k, p. e, l( X<input type='text' name='item_name'/><br/>) E! a! V% {% j7 V4 l! d( \
<lable>Item Amount</lable><br/>
5 h4 D) ]4 z9 ]<input type='text' name='item_amount'/><br/># L2 J6 {; v2 i- |& \; X3 X5 A2 l
<lable>Item Upgrade Amount</lable><br/>, Q, c/ z  d. J6 B
<input type='text' name='item_upgrade'/><br/>  c* L$ Z) D" k2 H2 \# V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), a  ^1 M7 m9 Z8 F. O% H% X
. f$ t5 Z0 x9 V( J/ W" m. E
</lable><br/>
! b! k0 e7 D& X% {1 f! {# x<input type='text' name='item_element'/><br/>& _7 T% [' Z4 l) f, _9 n
<lable>Element Upgrade Amount</lable><br/>. s# h$ g$ ]; Q/ P+ b
<input type='text' name='element_upgrade'/><br/>  V9 O. Y6 g; L3 b0 [
<lable>Pierced Amount</lable><br/>- ^, e8 M9 f# ^$ O$ B
<input type='text' name='item_pierce'/><br/>  t1 n, [5 x, S% o
<input type='submit'/>
( L$ s0 J- J6 I% ^, d, o</form>";
/ ?& ~0 F8 n- M9 t}: M3 W% J# ?( T

' f7 @/ U' u. R" Mfunction PostListener (){- B/ j$ C7 I* z' s- C! g5 e
//Add more post variables if needed and add them to initform() function aswell
: `( a1 e& ~6 a$ m' [" ~  f
$ A9 S! A# v: H5 L4 N: c################################, ~  C. q6 {. Y5 z7 |4 U. B
##### Connection and Post ######1 V5 h8 x/ @( q% x
################################1 O, ]! @8 w" w+ I
$name = @$_POST['char'];
% T+ R8 }: F% A! B- \7 X% P5 S$ItemName = @$_POST['item_name'];
2 q9 M- m$ I" Z0 U* b$ \/ U$ItemAmount = @$_POST['item_amount'];, j$ c1 k; C% {! i
$ItemId = @$_POST['item_id'];- |7 ]8 u6 D4 l2 I- J
$ItemUpgrade = @$_POST['item_upgrade'];' M% _9 b+ J# s0 f6 T! Z
$ItemElement = @$_POST['item_element'];) e4 o6 Y. V5 r" ^0 v) @1 U
$ElementUpgrade = @$_POST['element_upgrade'];0 h2 s' h; {; B$ s/ \' E& e1 ]
$ItemPierce = @$_POST['item_pierce'];0 ?, |* D% U; a
################################
/ k2 |! H- X: |+ _% l9 ?- X
" C  {6 {" G$ I" M. O//Check both variables for empty value; }+ V- S! ]) g" k$ ~8 c
8 h( f' r# o6 p4 A
if (!empty($_POST['char'])){- P# }1 S4 l& P. R$ `( X
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 y5 K0 h" b0 k

! @: X+ L; d2 X; g  h# sm_szName = '{$name}'");- k7 J+ n6 }: ~+ g8 f
while ($row = mssql_fetch_object($find)){1 w* {8 [6 p8 k3 R6 ^
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";  m" V+ j# j( P/ y" \3 ^9 m( ~
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" m8 z" A" q1 b# w, p( _0 ~
) o! n3 s+ u( m5 X+ a[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# v( |5 n6 U/ h' r5 t. S! |' k' ]* r) K
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. u- |0 O2 k7 n* J
1 K# f' z. S& h, sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ' v- G& t: A" O) v; M; Y1 B

- [! t  x% r- v& ~2 j; _+ `'{$ElementUpgrade}', '{$ItemPierce}');");
' p' X3 \9 j+ @7 b) E/ o9 n}
2 s/ ^+ r9 k  h- r1 T& f; w, D: j0 W: H/ M, d) o, c
}% M  ^) I$ V; r, j: [0 ]4 P$ k& R

2 B: o; q& i7 K}+ O  M( B. ^( _2 ~1 Q
' r6 M# e$ W: x4 M  e6 I( h
$InitForm = InitForm();
4 o( e' J& Y0 @$Listener = PostListener();3 n* |1 I" ?. u& u  h0 X

& S! Y3 j! S# K+ a3 _?>8 t$ ]8 B0 ~) ]2 Y/ W5 Q" D
  K( }4 o/ E9 L5 b! F

; ]& R; D: v; l+ ?& N1 z8 R
& Q$ i# U6 x! R& \( @: k
% I4 I7 w  H9 i: i% z9 l
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-3 06:29 , Processed in 0.063706 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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