飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php7 V2 o1 @3 s" W, ?. a5 G
function Connect () {
2 i0 d6 d' e5 B( H1 \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; S* ~9 |0 X+ O2 Y7 \4 |$ h" E/ M! W/ G3 U8 ?6 S. x* ~3 e4 j/ q
Failed.');
. Z+ ]& r- d2 B- ]% t/ v8 n1 m}
! t& D. c) }1 t! h  \Connect();
0 z! t/ |6 _6 P# q. t3 L2 ?$ o! B( |0 M. K" T$ E' a. H
function InitForm(){9 U! L. T+ t+ Q9 _: t# S+ [
//layout for the form' T( g2 Q$ t; j6 o- [
echo "<strong>Send Items.</strong>
6 J1 X1 a  W. x! s9 q<form name='select' method='post'>
+ n' _- q' r# H# L<lable>Character Name</lable><br/>
6 b( ~4 ~0 Q4 A- J0 e* o<input type='text' name='char'/><br/># p4 J8 w5 k6 ?, l) a0 ]9 M
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' _% `3 S8 y7 o; e3 ~" l<input type='text' name='item_name'/><br/>  h2 q! E# N& @
<lable>Item Amount</lable><br/>
6 @. L) L! C* d" _$ \, q<input type='text' name='item_amount'/><br/># w, ~  l( b. [4 Q
<lable>Item Upgrade Amount</lable><br/>. W9 f' M- G# T
<input type='text' name='item_upgrade'/><br/>' a& N9 X! \8 G; @4 r+ M* U
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 s. d+ z7 a9 W. ?1 ?# b/ K3 a* x4 s" w2 Z. m, O$ X* N7 B
</lable><br/>
# T5 z0 a1 l0 D! F! u<input type='text' name='item_element'/><br/>! u. c0 t, |. I6 C! P
<lable>Element Upgrade Amount</lable><br/>
( e: S2 j; n8 }! K" d; _9 D, l<input type='text' name='element_upgrade'/><br/>
9 u* r5 {8 r/ o, G' Q: ^<lable>Pierced Amount</lable><br/>" _0 P7 B: Z- \" c
<input type='text' name='item_pierce'/><br/>
6 i/ U" `- _% E7 o1 M" J' M<input type='submit'/>
  Y5 Y) q/ w* r, J; Y</form>";) j5 [* P: i1 W* b( {+ r
}- X4 P, w% ]6 {( m. B3 Y% A5 D$ U
0 D+ u5 {/ z8 Y1 {3 a+ u$ n
function PostListener (){& O1 J8 e# i9 \" V9 L) C$ p) p
//Add more post variables if needed and add them to initform() function aswell) P/ t) q) N5 w* M4 l

% f7 J3 e& h! g################################% F+ w0 A" G' t/ ^7 n9 H
##### Connection and Post ######) @% O9 X+ b$ O" Z
################################
2 G0 @+ ~2 S( D$name = @$_POST['char'];
+ ?4 G- ~- F( j8 d$ItemName = @$_POST['item_name'];
7 y5 b' |; q9 U5 o$ItemAmount = @$_POST['item_amount'];. Z" V, h) Y- w
$ItemId = @$_POST['item_id'];$ V* M1 T$ d( [1 l: A$ I
$ItemUpgrade = @$_POST['item_upgrade'];
/ r6 {0 ^* `0 p- G2 W* ]$ItemElement = @$_POST['item_element'];2 ]% F' `( ^- r  V, n! Y4 R
$ElementUpgrade = @$_POST['element_upgrade'];
2 e8 O4 W$ D7 L( G$ItemPierce = @$_POST['item_pierce'];
  O2 {$ ]2 f8 _3 z( m################################
3 o5 Q, E5 J5 K7 d) I" ~+ M4 Y2 b& j5 E
//Check both variables for empty value
$ m# u* P0 }8 k! c5 b# f  J9 \. @7 P( b: l: i6 g) ^2 B! L( B
if (!empty($_POST['char'])){: F' w3 y$ c" Z& K8 v3 I2 g* w
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( Q. t; i- J' V6 Q7 C3 \  Y4 c
0 Z- d6 T% i3 s5 o5 o/ [: um_szName = '{$name}'");
1 s* z% J: A" |. n! f  B  C( fwhile ($row = mssql_fetch_object($find)){. h" ]1 L9 D5 |
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 p# h1 L/ O9 b) A# N$ @: l0 N! F
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - s( V5 p7 Q; U+ X9 \
" d' n2 `! X& D& W) J5 `
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ I9 h  c8 J3 R  m; p6 s; _7 }: [7 N
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', " a( `  ?& _7 T* @- n" {/ A
6 `: P+ {# E- L! ~1 A7 I% U& }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, L  S' k. x. t6 ]( A! {  }2 {3 R* l- V
'{$ElementUpgrade}', '{$ItemPierce}');");' s1 ^0 m  s+ K( b+ t) ^
}8 V  e) V* B! O# w- i' u2 v
! N1 m8 O( {# d, b# u
}
! T' e/ \/ C5 `. N3 ?) L
" G0 N5 r4 y% H}1 e$ Q& `' F- n+ R0 @" n( j
5 O; e# K4 D% x; w. K/ z( L
$InitForm = InitForm();, F# a3 e. u2 K& ~- v' S/ g7 b- A" n
$Listener = PostListener();( G2 [9 O0 S- b& Y6 F5 N9 v

1 j0 d4 \4 a( K9 j. T8 b8 l?>
- {% C' Z8 @2 a0 z3 F/ T5 R8 c' l& h. P* O. z
- `! N* I' P- N% x4 `! k; C$ M
% X( y8 B( Y. V9 n
0 C5 h, G) D: i& g  n8 @! k
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-18 03:27 , Processed in 0.104254 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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