飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
8 L. B: o* |! |% {' ?function Connect () {6 `- h- X& W: U; q4 w+ [  j2 h
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ G8 [, _& U' V& d& D

" W/ X9 f  _5 [; `Failed.');! G! @, }% g. t
}
2 _1 M( t9 y% q7 @! vConnect();3 i- t$ X9 \; C2 r! q- ]
8 V) z9 U5 P# \: _
function InitForm(){
# u4 @8 d% S. A, E# `1 g//layout for the form& {# B: b( e) q# ~( c. t/ n' [: ?
echo "<strong>Send Items.</strong>9 [1 ^( i: A7 ^
<form name='select' method='post'>
0 ?5 Q+ `* m1 {: M, U- J<lable>Character Name</lable><br/>- q; `7 e% G$ C# \+ S
<input type='text' name='char'/><br/>! N# V) S. S) ?0 r4 S( @/ [1 F
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; r, Z$ O( l& ~( k. `( w8 b9 I
<input type='text' name='item_name'/><br/>% ~1 b5 |+ b4 N4 e# t
<lable>Item Amount</lable><br/>
( I' V! b6 ^, X4 H0 y" _* u" A/ _<input type='text' name='item_amount'/><br/>* z% }0 ^1 N- k$ `
<lable>Item Upgrade Amount</lable><br/>
& `% p9 |, H9 `0 E, B7 p<input type='text' name='item_upgrade'/><br/>
: M0 s9 ~$ j' H<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 C* L. P; W% ^$ U' |( I

' H# d8 F7 C5 }- w2 c</lable><br/>" s5 J+ M. n% q. U& q+ C
<input type='text' name='item_element'/><br/>0 D" r+ n# O0 V' \2 U- h' D! z. r
<lable>Element Upgrade Amount</lable><br/>
2 J8 r3 Q9 j( U* E<input type='text' name='element_upgrade'/><br/>, P3 P4 N. ?% t$ @4 R  u
<lable>Pierced Amount</lable><br/>1 N) C$ I! j3 W8 M3 d
<input type='text' name='item_pierce'/><br/>$ o5 u8 X% t( J  s
<input type='submit'/>
" C" W/ ~- o  l; ^- W</form>";" Z9 w  e9 N. f
}
3 ]# K  q3 d2 d' v
; p3 c: M: O/ q) G3 ~function PostListener (){! J7 ]8 o6 J% ]5 e- Z$ x/ M
//Add more post variables if needed and add them to initform() function aswell
5 W/ [7 g0 ?+ T6 n" L
% \  M, ^3 I. N6 o################################
- F5 U" s- M9 e3 V" l##### Connection and Post ######
0 G1 Y8 \3 j6 R( C################################  P5 }6 }8 g( F$ |' c1 ~) T1 L
$name = @$_POST['char'];
+ n: J! x4 x: k, ]8 c$ItemName = @$_POST['item_name'];
' r% U+ L1 M/ E- b) Y$ItemAmount = @$_POST['item_amount'];
% l2 u* P# a# v. ]" j$ItemId = @$_POST['item_id'];
, \0 y$ y# D2 ?# z3 I$ H$ItemUpgrade = @$_POST['item_upgrade'];
( {+ Q1 r8 i9 k  D9 T$ItemElement = @$_POST['item_element'];
' A% O8 F  W# q! C+ H$ElementUpgrade = @$_POST['element_upgrade'];- g1 [8 c; O6 @4 d9 X* A& S
$ItemPierce = @$_POST['item_pierce'];# c/ Y. F/ T& u" }
################################" Y7 u( t3 f& n: g4 l& Y/ U0 _

( G5 A* N3 L' |//Check both variables for empty value
; W- R' T6 m5 k1 m( i' M5 P) `5 [1 x) d
if (!empty($_POST['char'])){/ W3 J4 g8 i% t
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 C( _- |5 R8 Y" t1 Z( r5 b6 }& H' S1 k
m_szName = '{$name}'");
2 y* X3 o- l" Q" A) ~while ($row = mssql_fetch_object($find)){
. e3 c- D+ c  ^% n8 A9 e- a. wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 J8 g8 e" m% H2 Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' v8 w( O6 r; b9 \. H7 @* a
! F: q6 G, t, B1 J2 \. i! I- Q8 `
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 3 B& I' H; ^  Y, `0 h& d% W3 |. v- r

" R4 N' F5 O6 |/ z9 ]/ h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', % M, N- q! X0 c: K( M' G0 H$ O

6 w* v' B/ ~! n3 R( n, KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: T% L" y8 B5 ~1 ]5 ~8 M( j0 t( X% ?( X% E% X
'{$ElementUpgrade}', '{$ItemPierce}');");
( a/ P4 v: X" H% G7 k; k9 H3 \% w}- i  C1 R) i  A2 A

: d* q" P+ m: p( S}
# ~/ {( e! Q( ~' H' R5 O! V5 V4 P+ g& G# q, D
}
% C+ J1 Y4 N" J
9 m0 P) {9 N) E. ]( Q) P$InitForm = InitForm();
+ O: \( H! j$ _( Y$Listener = PostListener();
# x0 ~- f# f1 u% ?
$ V$ B- |) J/ a& ?6 x: O, K?>
# i- U7 [+ d: B+ _9 U5 T0 b
/ y' J4 d9 h2 E+ q2 t  h
7 T0 D+ ], u1 E% R" D4 g6 O4 O; c) C- r4 J6 _) {0 H% p
. V0 Q' [3 D' }) n
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-29 19:21 , Processed in 0.111747 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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