飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php9 v) b* H1 d  j+ c* J" K  v
function Connect () {
: @6 r& C2 _8 x" F1 pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 4 ]* B, W4 k  Y. m% `1 K: x

1 E0 s- x: t' Q& J1 iFailed.');2 w% Z% J8 `& K- j
}
# {3 p+ `: o0 h( e: {Connect();' X& r  {- l7 J( |

9 r7 T( P$ b  H+ n: Kfunction InitForm(){  y& J: V# V+ g5 v4 q
//layout for the form
  [+ d3 ~2 N, t. u; T2 [  L  recho "<strong>Send Items.</strong>0 U9 v. Q8 C9 ~7 a) e& A
<form name='select' method='post'>$ p) i3 v# `: V5 s& ~4 ?  N
<lable>Character Name</lable><br/>
$ V; U" u, L. c' H4 |<input type='text' name='char'/><br/>) C/ F4 A' A& m/ a
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 A% L" A& A0 i% e<input type='text' name='item_name'/><br/>
2 p! u1 J4 p8 A<lable>Item Amount</lable><br/>
7 w$ O& |- C* ?  i$ n8 H& h3 i<input type='text' name='item_amount'/><br/>6 a( `4 [9 G5 h8 m
<lable>Item Upgrade Amount</lable><br/>
4 ~7 T1 Z5 C! d; H<input type='text' name='item_upgrade'/><br/>  U/ g3 v5 ^2 [! v5 K' E- t: Q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); B- A, ?, ]/ b0 ]% t1 a4 g4 \

2 F7 w9 g7 Z+ t</lable><br/>
* A3 ?; K- `" V<input type='text' name='item_element'/><br/>
- A$ K1 t" ]+ G<lable>Element Upgrade Amount</lable><br/>) g7 h, d4 B; p% P
<input type='text' name='element_upgrade'/><br/>0 O3 x# v6 N% `8 @% c- s
<lable>Pierced Amount</lable><br/>
6 Z2 _4 ^* h! B. A# c$ J! g, R<input type='text' name='item_pierce'/><br/>
/ @) e3 {4 f$ d! i; C: B<input type='submit'/>, J2 g4 b9 Y( L! V2 Q' U# \  O
</form>";
; j: f7 f* L8 P7 {}
9 A7 w9 Q& ]9 N
( e* V* C! [7 w! M' H; o5 M* Rfunction PostListener (){" I6 J7 w+ q. r
//Add more post variables if needed and add them to initform() function aswell' N: [0 s  w2 N! M1 _
, z5 \  L& X/ h0 v4 C# U4 i
################################
$ |1 w* I1 O$ H% p##### Connection and Post ######
9 _  W3 v- t, P( {################################3 _& e' p9 v8 n
$name = @$_POST['char'];+ [$ I% x# a5 z& D: S) M
$ItemName = @$_POST['item_name'];% q4 x# {; t" {9 u. u
$ItemAmount = @$_POST['item_amount'];
. O1 ~' n7 u( j$ItemId = @$_POST['item_id'];
6 k1 b0 p+ Y* u$ItemUpgrade = @$_POST['item_upgrade'];
6 y4 b+ n7 ?, G3 L  o+ ?2 K0 G; R$ItemElement = @$_POST['item_element'];5 _7 J; o1 u+ ]
$ElementUpgrade = @$_POST['element_upgrade'];
! W( y0 y  V+ z5 \' g$ItemPierce = @$_POST['item_pierce'];9 l+ C/ f' N( w4 L1 w4 T
################################
8 [- Y+ \' g, J/ ]  I, |' j% F7 _6 M. m+ F7 @* m
//Check both variables for empty value
& `' _* H3 O) u: L7 b/ H! k4 ~- j2 ^3 u8 S. \/ Z8 u
if (!empty($_POST['char'])){7 {) H( m' ~! Y$ h6 h
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 c6 I+ {4 e4 l  R  a, z% A5 k" D- ]/ F  ^  e( m* d
m_szName = '{$name}'");
; N8 t3 T( o  q% _0 H# J& rwhile ($row = mssql_fetch_object($find)){% S( B, W) |: v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ |4 D: s: w) v1 h2 Y. p. a$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 2 G2 ?( p" f0 k1 v
( b" R# m/ D; ~6 E
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 h4 i; ?6 R8 |& m: o8 y
  F  o# ?' x( n' X0 D9 c) [! Q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', $ P. r7 v) h3 u. X

8 Z$ b, b: }2 EN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 L7 D; r2 r" E: P) {/ q# P) U# H: e
'{$ElementUpgrade}', '{$ItemPierce}');");
; _. I1 G/ G2 {" R}# M- W  }; X! F7 E* u* t

3 I& t( e9 P. o9 F( Z) V}# _1 {' G* d& c* S. }6 c- A( ~

5 z5 u, V' s2 l3 @: u8 ^1 Q}
4 E4 j, {3 h5 l* m3 N3 c) Q7 {2 p
+ f. i! J: }% A$InitForm = InitForm();6 c* i" c$ q5 a# t" W
$Listener = PostListener();
1 u- ]0 q0 K8 h/ C; T* E0 h- O) Q3 Z# ^# |0 e$ Y
?>
5 a" e; p! w( d$ t  H, A+ z
8 l. a8 C/ f9 y. q" f0 H
+ R( W9 L6 ^. A3 M9 @* d  c! ?7 U7 l0 {

, \2 r; G8 D0 t2 u
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-4 06:47 , Processed in 0.066786 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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