The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Currently, there is a link at the top of the forum that says "Active Topics". I would like to possibly add the number of new topics added since a users last visit. It would look something like this:
Active Topics (5)
The number would represent the additional topics that were new since a users last visit. It would change dependent on the actual number of active topics for that user. If no new topics were added then it would either look like:
Active Topics
or
Active Topics (0)
Does anyone know how to do this?
Of course the formatting of the way the link looks does not have to be limited to what I suggested. It could also look something like this:
5 Active Topics<
Active Topics (5)
The number would represent the additional topics that were new since a users last visit. It would change dependent on the actual number of active topics for that user. If no new topics were added then it would either look like:
Active Topics
or
Active Topics (0)
Does anyone know how to do this?
Of course the formatting of the way the link looks does not have to be limited to what I suggested. It could also look something like this:
5 Active Topics<
Posted
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=31252&SearchTerms=Active,Topics
been done many times ;-)<
been done many times ;-)<
Posted
Thanks.
I'm trying to add it but hava a problem. I am getting an error:
It is around this area in the code:
This mod is for an older version of Snitz. Can anyone update it for the current version? Here is the code it uses. I figured out that inc_functions.asp now is inc_func_common.asp and inc_top.asp is now inc_header.asp. Perhaps there are other sections in the code itself that need to be renamed to make it work with the current version of Snitz?<
I'm trying to add it but hava a problem. I am getting an error:
Code:
Type mismatch: 'getNewMemberNumber'It is around this area in the code:
Code:
if rsForum.eof or rsForum.bof then
'nothing
else
i = 0
do until rsForum.Eof
ForumID = rsForum("FORUM_ID")
if ChkForumAccess(ForumID, getNewMemberNumber()) then
i = i + 1
if i = 1 Then
strSql = strSql & " AND ("
else
strSql = strSql & " OR "
end If
strSQL = strSQL & "F.FORUM_ID=" & ForumID
end if
rsForum.MoveNext
loop
rsForum.close
set rsForum = Nothing
if i > 0 Then
strSql = strSql & ") "
end If
end if
end If
strSql = strSql & "AND (T.T_LAST_POST > '" & lastDate & "'"
Posted
I just realized (
) that in the statistics at the bottom of the forum, it already tells you how many active topics there are since your last visit. Perhaps that number can be added to the link in the header? How would I do that?<
) that in the statistics at the bottom of the forum, it already tells you how many active topics there are since your last visit. Perhaps that number can be added to the link in the header? How would I do that?<
Posted
http://mad2kool.co.uk/forum/faq.asp works fine on my site with no changes.
i put all the code into inc_header, just to test but if you wanted to do it proper then you woudl put the code in in_func_common.asp and then make the change in inc_header.asp to display the link.<
i put all the code into inc_header, just to test but if you wanted to do it proper then you woudl put the code in in_func_common.asp and then make the change in inc_header.asp to display the link.<
Posted
In inc_func_common.asp line 1373
[code] Case "members.asp"
strNewTitle = strForumTitle & " - Members"
Case "active.asp" ActiveTopicCount = 0
if not IsNull(Session(strCookieURL & "last_here_date")) then
if not blnHiddenForums then
'## Forum_SQL - Get ActiveTopicCount from DB
strSql = "SELECT COUNT(" & strTablePrefix & "TOPICS.T_LAST_POST) AS NUM_ACTIVE " &_
" FROM " & strTablePrefix & "TOPICS " &_
" WHERE (((" & strTablePrefix & "TOPICS.T_LAST_POST)>'"& Session(strCookieURL & "last_here_date") & "'))" &_
" AND " & strTablePrefix & "TOPICS.T_STATUS <= 1"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn
if not rs.EOF then
ActiveTopicCount = rs("NUM_ACTIVE")
else
ActiveTopicCount = 0
end if
rs.close
set rs = nothing
end if
end if
strNewTitle = strForumTitle & " - Active Topics (" & ActiveTopicCount & ")" Case "faq.asp"
strNewTitle = strForumTitle & " - Frequently Asked Questions"<
[code] Case "members.asp"
strNewTitle = strForumTitle & " - Members"
Case "active.asp" ActiveTopicCount = 0
if not IsNull(Session(strCookieURL & "last_here_date")) then
if not blnHiddenForums then
'## Forum_SQL - Get ActiveTopicCount from DB
strSql = "SELECT COUNT(" & strTablePrefix & "TOPICS.T_LAST_POST) AS NUM_ACTIVE " &_
" FROM " & strTablePrefix & "TOPICS " &_
" WHERE (((" & strTablePrefix & "TOPICS.T_LAST_POST)>'"& Session(strCookieURL & "last_here_date") & "'))" &_
" AND " & strTablePrefix & "TOPICS.T_STATUS <= 1"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn
if not rs.EOF then
ActiveTopicCount = rs("NUM_ACTIVE")
else
ActiveTopicCount = 0
end if
rs.close
set rs = nothing
end if
end if
strNewTitle = strForumTitle & " - Active Topics (" & ActiveTopicCount & ")" Case "faq.asp"
strNewTitle = strForumTitle & " - Frequently Asked Questions"<