下载地址：
[URL]http://download.dvbbs.net/softdown/2006-1/200611322591726998.exe[/URL]
5个存储过程解密代码（附件为解密后的club.sql文件）
-----------------------开始解密 [dv_Dispbbs]--------------------
CREATE PROCEDURE [dv_Dispbbs]
@boardid int=1,
@pagenow int=1, --当前页数
@pagesize int=1, --定义每页面帖子数目
@Announceid int=1,
@TotalUseTable nvarchar(10) ='Dv_bbs1'
With ENCRYPTION
AS
set nocount on
Select AnnounceID from [Dv_bbs1] Where BoardID=@BoardID And RootID=@Announceid Order By AnnounceID
-----------------------结束解密 [dv_Dispbbs]---------------------
-----------------------开始解密 [dv_list]--------------------
CREATE PROCEDURE [dv_list]
@boardid int=1,
@pagenow int=1, --当前页数
@pagesize int=1, --定义每页面帖子数目
@tl int=0, --按时间段查询
@topicmode int=0, --专题
@totalrec int output
With ENCRYPTION
AS
set nocount on
declare @int_topnum int
declare @int_timenum int
declare @var_times varchar(5000)
if @pagenow>1
if @topicmode>0
begin
select @int_timenum=(@pagenow-1)*@pagesize
set rowcount @int_timenum
select @var_times=lastposttime from Dv_Topic where mode=@topicmode and boardID=@boardID and istop = 0 ORDER BY lastposttime desc
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from dv_topic where mode=@topicmode and boardID=@boardID and istop = 0 and lastposttime < @var_times ORDER BY lastposttime desc
set nocount off
return
end
else
begin
select @int_timenum=(@pagenow-1)*@pagesize
set rowcount @int_timenum
select @var_times=lastposttime from Dv_Topic where boardID=@boardID and istop = 0 ORDER BY lastposttime desc
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from dv_topic where boardID=@boardID and istop = 0 and lastposttime < @var_times ORDER BY lastposttime desc
set nocount off
return
end
else
if @topicmode>0
begin
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from Dv_topic where mode=@topicmode and boardID=@boardid and istop = 0 ORDER BY lastposttime desc
end
else
begin
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from Dv_topic where boardID=@boardid and istop = 0 ORDER BY lastposttime desc
end
-----------------------结束解密 [dv_list]---------------------
-----------------------开始解密 [Dv_loadSetup]--------------------
CREATE PROCEDURE [Dv_loadSetup]
With ENCRYPTION
AS
Select * from [Dv_setup]
-----------------------结束解密 [Dv_loadSetup]---------------------
-----------------------开始解密 [dv_toplist]--------------------
CREATE PROCEDURE [dv_toplist]
@pagenow int ,
@pagesize int ,
@reture_value int output,
@intUserRecordCount int output
With ENCRYPTION
as
/*定义局部变量*/
declare @intBeginID int
declare @intEndID int
declare @intPageCount int
declare @intRowCount int
/*关闭计数*/
set nocount on
/*求总用户数*/
select @intUserRecordCount = count(*) from [dv_user]
if (@intUserRecordCount = 0) --如果没有用户，则返回零
set @reture_value =0
/*判断页数是否正确*/
if (@pagenow - 1) * @pagesize > @intUserRecordCount
set @reture_value =1
--return (-1)
/*求开始userID*/
set @intRowCount = (@pagenow - 1) * @pagesize + 1
/*限制条数*/
set rowcount @intRowCount
select @intBeginID = userid from [dv_user] order by userid desc
/*结束userID*/
set @intRowCount = @pagenow * @pagesize
/*限制条数*/
set rowcount @intRowCount
select @intEndID = userid from [dv_user] order by userid desc
/*恢复系统变量*/
set rowcount 0
set nocount off
select username,useremail,userclass,UserIM,UserPost,JoinDate,userwealth,userid from [dv_user] where userid between @intEndID and @intBeginID order by userid desc
return(@@rowcount)
--select @@rowcount
-----------------------结束解密 [dv_toplist]---------------------
-----------------------开始解密 [Dv_TSQL]--------------------
CREATE PROCEDURE [Dv_TSQL]
@tsql varchar(500)
With ENCRYPTION AS
exec(@tsql)
-----------------------结束解密 [Dv_TSQL]---------------------
