if exists(select * from sysobjects where id = object_id(N'[dnt_getfavoritescountbytype]') and OBJECTPROPERTY(id,N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescountbytype]
GO
if exists(select * from sysobjects where id = object_id(N'[dnt_getfavoritescount]') and OBJECTPROPERTY(id,N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescount]
GO
CREATE PROCEDURE [dnt_getfavoritescount]
@uid int,
@typeid smallint
AS
SELECT COUNT(uid) FROM [dnt_favorites] WHERE [uid]=@uid AND [typeid]=@typeid
GO
if exists (select * from sysobjects where id = object_id(N'[dnt_revisedebatetopicdiggs]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_revisedebatetopicdiggs]
GO
CREATE PROCEDURE [dnt_revisedebatetopicdiggs]
@tid int,
@opinion int,
@count int out
AS
BEGIN
SELECT @count=COUNT(1) FROM [dnt_postdebatefields] WHERE [tid] = @tid AND [opinion] = @opinion
IF @opinion=1
BEGIN
UPDATE [dnt_debates] SET [positivediggs]=(SELECT SUM(diggs + 1) FROM [dnt_postdebatefields] WHERE [tid] = @tid AND [opinion] = @opinion) WHERE [tid] = @tid
END
ELSE
BEGIN
UPDATE [dnt_debates] SET [negativediggs]=(SELECT SUM(diggs + 1) FROM [dnt_postdebatefields] WHERE [tid] = @tid AND [opinion] = @opinion) WHERE [tid] = @tid
END
END
GO
IF OBJECT_ID ('dnt_getfavoriteslist','P') IS NOT NULL
DROP PROCEDURE [dnt_getfavoriteslist]
GO
CREATE PROCEDURE [dnt_getfavoriteslist]
@uid int,
@pagesize int,
@pageindex int
AS
--SELECT [f].[uid],[f].[tid],[topics].[title],[topics].[poster],[topics].[postdatetime],[topics].[replies],[topics].[views],[topics].[posterid] FROM [dnt_favorites] [f] LEFT JOIN [dnt_topics] [topics] ON [f].[tid]=[topics].[tid] WHERE [f].[typeid]=0 AND [f].[uid]=@uid
IF @pageindex = 1
BEGIN
SELECT TOP(@pagesize) [uid],[tid],[title],[poster],[postdatetime],[replies],[views],[posterid]
FROM (SELECT [f].[uid],[f].[tid],[topics].[title],[topics].[poster],[topics].[postdatetime],[topics].[replies],[topics].[views],[topics].[posterid] FROM [dnt_favorites] [f] LEFT JOIN [dnt_topics] [topics] ON [f].[tid]=[topics].[tid] WHERE [f].[typeid]=0 AND [f].[uid]=@uid) favorites ORDER BY [tid] DESC
END
ELSE
BEGIN
SELECT TOP(@pagesize) [uid],[tid],[title],[poster],[postdatetime],[replies],[views],[posterid]
FROM (SELECT [f].[uid],[f].[tid],[topics].[title],[topics].[poster],[topics].[postdatetime],[topics].[replies],[topics].[views],[topics].[posterid] FROM [dnt_favorites] [f] LEFT JOIN [dnt_topics] [topics] ON [f].[tid]=[topics].[tid] WHERE [f].[typeid]=0 AND [f].[uid]=@uid) f1 WHERE [tid] < (SELECT MIN([tid]) FROM (SELECT TOP((@pageindex-1)*@pagesize) [tid]
FROM (SELECT [f].[uid],[f].[tid],[topics].[title],[topics].[poster],[topics].[postdatetime],[topics].[replies],[topics].[views],[topics].[posterid] FROM [dnt_favorites] [f] LEFT JOIN [dnt_topics] [topics] ON [f].[tid]=[topics].[tid] WHERE [f].[typeid]=0 AND [f].[uid]=@uid) f2 ORDER BY [tid] DESC) AS tblTmp) ORDER BY [tid] DESC
END
GO
IF OBJECT_ID ('dnt_getmyattachments','P') IS NOT NULL
DROP PROCEDURE [dnt_getmyattachments]
GO
CREATE PROCEDURE [dnt_getmyattachments]
@uid int,
@pageindex int,
@pagesize int
AS
DECLARE @startRow int,
@endRow int
SET @startRow=(@pageindex-1) * @pagesize + 1
SET @endRow = @startRow + @pagesize - 1
SELECT
[ATTACHMENTS].[aid],
[ATTACHMENTS].[uid],
[ATTACHMENTS].[attachment],
[ATTACHMENTS].[description],
[ATTACHMENTS].[downloads],
[ATTACHMENTS].[extname],
[ATTACHMENTS].[filename],
[ATTACHMENTS].[pid],
[ATTACHMENTS].[postdatetime],
[ATTACHMENTS].[tid]
FROM (SELECT ROW_NUMBER() OVER(ORDER BY [aid] DESC) AS ROWID,
[dnt_myattachments].[aid],
[dnt_myattachments].[uid],
[dnt_myattachments].[attachment],
[dnt_myattachments].[description],
[dnt_myattachments].[downloads],
[dnt_myattachments].[extname],
[dnt_myattachments].[filename],
[dnt_myattachments].[pid],
[dnt_myattachments].[postdatetime],
[dnt_myattachments].[tid]
FROM [dnt_myattachments]
WHERE [dnt_myattachments].[uid] = @uid ) AS ATTACHMENTS
WHERE ROWID BETWEEN @startRow AND @endRow
GO
IF OBJECT_ID ('dnt_createuser','P') IS NOT NULL
DROP PROCEDURE [dnt_createuser]
GO
CREATE PROCEDURE [dnt_createuser]
@username nchar(20),
@nickname nchar(20),
@password char(32),
@secques char(8),
@gender int,
@adminid int,
@groupid smallint,
@groupexpiry int,
@extgroupids char(60),
@regip char(15),
@joindate char(19),
@lastip char(15),
@lastvisit char(19),
@lastactivity char(19),
@lastpost char(19),
@lastpostid int,
@lastposttitle nchar(60),
@posts int,
@digestposts smallint,
@oltime int,
@pageviews int,
@credits int,
@extcredits1 float,
@extcredits2 float,
@extcredits3 float,
@extcredits4 float,
@extcredits5 float,
@extcredits6 float,
@extcredits7 float,
@extcredits8 float,
@avatarshowid int,
@email char(50),
@bday char(19),
@sigstatus int,
@salt nchar(6),
@tpp int,
@ppp int,
@templateid smallint,
@pmsound int,
@showemail int,
@newsletter int,
@invisible int,
@newpm int,
@accessmasks int,
@website varchar(80),
@icq varchar(12),
@qq varchar(12),
@yahoo varchar(40),
@msn varchar(40),
@skype varchar(40),
@location nvarchar(30),
@customstatus varchar(30),
@avatar varchar(255),
@avatarwidth int,
@avatarheight int,
@medals varchar(300),
@bio nvarchar(500),
@signature nvarchar(500),
@sightml nvarchar(1000),
@authstr varchar(20),
@realname nvarchar(10),
@idcard varchar(20),
@mobile varchar(20),
@phone varchar(20)
AS
DECLARE @uid int
INSERT INTO [dnt_users]([username],[nickname], [password], [secques], [gender], [adminid], [groupid], [groupexpiry], [extgroupids], [regip], [joindate], [lastip], [lastvisit], [lastactivity], [lastpost], [lastpostid], [lastposttitle], [posts], [digestposts], [oltime], [pageviews], [credits], [extcredits1], [extcredits2], [extcredits3], [extcredits4], [extcredits5], [extcredits6], [extcredits7], [extcredits8], [avatarshowid], [email], [bday], [sigstatus], [salt], [tpp], [ppp], [templateid], [pmsound], [showemail], [newsletter], [invisible], [newpm], [accessmasks]) VALUES(@username,@nickname, @password, @secques, @gender, @adminid, @groupid, @groupexpiry, @extgroupids, @regip, @joindate, @lastip, @lastvisit, @lastactivity, @lastpost, @lastpostid, @lastposttitle, @posts, @digestposts, @oltime, @pageviews, @credits, @extcredits1, @extcredits2, @extcredits3, @extcredits4, @extcredits5, @extcredits6, @extcredits7, @extcredits8, @avatarshowid, @email, @bday, @sigstatus, @salt, @tpp, @ppp, @templateid, @pmsound, @showemail, @newsletter, @invisible, @newpm, @accessmasks)
SELECT SCOPE_IDENTITY() AS 'userid'
SET @uid = SCOPE_IDENTITY()
IF @@ERROR=0
BEGIN
UPDATE [dnt_statistics] SET [totalusers]=[totalusers] + 1,[lastusername]=@username,[lastuserid]=@uid
END
INSERT INTO dnt_userfields
([uid],[website],[icq],[qq],[yahoo],[msn],[skype],[location],[customstatus],[avatar],[avatarwidth],[avatarheight],[medals],[bio],[signature],[sightml],[authstr],[realname],[idcard],[mobile],[phone])
VALUES
(@uid,@website,@icq,@qq,@yahoo,@msn,@skype,@location,@customstatus,@avatar,@avatarwidth,@avatarheight,@medals,@bio,@signature,@sightml,@authstr,@realname,@idcard,@mobile,@phone)
GO
IF OBJECT_ID ('dnt_getmytopics','P') IS NOT NULL
DROP PROCEDURE [dnt_getmytopics]
GO
CREATE PROCEDURE [dnt_getmytopics]
@uid int,
@pageindex int,
@pagesize int
AS
DECLARE @startRow int,
@endRow int
SET @startRow = ( @pageindex - 1 ) * @pagesize + 1
SET @endRow = @startRow + @pagesize - 1
SELECT
[MYTOPIC].[tid],
[MYTOPIC].[fid],
[MYTOPIC].[iconid],
[MYTOPIC].[typeid],
[MYTOPIC].[readperm],
[MYTOPIC].[price],
[MYTOPIC].[poster],
[MYTOPIC].[posterid],
[MYTOPIC].[title],
[MYTOPIC].[postdatetime],
[MYTOPIC].[lastpost],
[MYTOPIC].[lastpostid],
[MYTOPIC].[lastposter],
[MYTOPIC].[lastposterid],
[MYTOPIC].[views],
[MYTOPIC].[replies],
[MYTOPIC].[displayorder],
[MYTOPIC].[highlight],
[
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
discuz bbs(.net)源代码 (2000个子文件)
usergrouppowersetting.ascx 7KB
ajaxviewuserpost.ascx 6KB
ajaxuserbloglist.ascx 5KB
ajaxuserspacecommentlist.ascx 4KB
ajaxtopicinfo.ascx 4KB
ajaxsubmitcomment.ascx 3KB
ajaxspaceinfo.ascx 3KB
ajaxspacepostinfo.ascx 3KB
ajaxalbumlist.ascx 3KB
ajaxphotoinfo.ascx 2KB
uploadfile.ascx 2KB
ajaxuseralbums.ascx 2KB
forumstree.ascx 2KB
fronttop.ascx 2KB
ajaxuserbloglistbydate.ascx 2KB
shortcutmenu.ascx 2KB
textarearesize.ascx 2KB
onlineeditor.ascx 1KB
ajaxtopnewcomment.ascx 1KB
ajaxtopnewpost.ascx 1KB
ajaxspacelink.ascx 1011B
ajaxspaceconfigstatic.ascx 992B
frontleftnavmenu.ascx 841B
ajaxpostinfo.ascx 801B
spacecalendar.ascx 686B
pageinfo.ascx 576B
dropdownpost.ascx 262B
frontbottom.ascx 222B
AddTopictype.ascx 187B
searchfunction.ascx 174B
searchuser.ascx 166B
favoritefunction.ascx 157B
MetaBlog.ashx 74B
MixObjects.asmx 75B
editgoods.aspx 134KB
editpost.aspx 132KB
showforum.aspx 127KB
showtopic.aspx 122KB
posttopic.aspx 121KB
postgoods.aspx 118KB
showtree.aspx 108KB
postreply.aspx 105KB
showbonus.aspx 101KB
modcp.aspx 100KB
website.aspx 71KB
showdebate.aspx 69KB
showgoods.aspx 68KB
topicadmin.aspx 67KB
register.aspx 64KB
search.aspx 62KB
usercpmygoods.aspx 62KB
showgoodslist.aspx 59KB
forumindex.aspx 57KB
offlinetrade.aspx 53KB
usercp.aspx 53KB
stats.aspx 51KB
usercpspacephotoadd.aspx 47KB
tags.aspx 45KB
showtopiclist.aspx 43KB
usercppreference.aspx 43KB
usercpshopgoodsmanage.aspx 43KB
userinfo.aspx 41KB
onlinetrade.aspx 41KB
global_edituser.aspx 41KB
spaceindex.aspx 40KB
login.aspx 39KB
usercpspacemanagealbum.aspx 38KB
usercpspaceset.aspx 38KB
showphoto.aspx 37KB
goodsadmin.aspx 37KB
usercpshowpm.aspx 37KB
usercpinbox.aspx 36KB
usercpdraftbox.aspx 36KB
usercpsentbox.aspx 36KB
usercpspacemanagephoto.aspx 36KB
buytopic.aspx 35KB
usercpspaceeditblog.aspx 35KB
usercppostpm.aspx 35KB
usercpnotice.aspx 35KB
usercpspacepostblog.aspx 35KB
usercpprofile.aspx 34KB
mallindex.aspx 34KB
usercppmset.aspx 34KB
usercpshopcategory.aspx 34KB
usercpannouncepm.aspx 33KB
albumindex.aspx 33KB
mallgoodslist.aspx 33KB
usercpspacemanageblog.aspx 33KB
usercpspacemanageattachment.aspx 33KB
global_editadvs.aspx 33KB
usercpshoplink.aspx 33KB
usercpignorelist.aspx 33KB
forum_editforums.aspx 33KB
usercpspacemanagecategory.aspx 33KB
usercpspacelinklist.aspx 33KB
usercpnewpassword.aspx 32KB
usercpcreditspay.aspx 32KB
usercpsubscribe.aspx 32KB
buygoods.aspx 32KB
usercpspacecomment.aspx 32KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
azrael6619
- 粉丝: 17
- 资源: 31
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页