Showing counts on non forum pages
Snitz™ Forums 2000https://forum.snitz.com/forumTopic/Posts/69735?pagenum=1
05 November 2025, 01:44
Topic
Replies ...
Lon2
06 November 2010, 16:32
06 November 2010, 16:32
Does anyone have a simple script for this? 
Lon2
06 November 2010, 19:09
06 November 2010, 19:09
For clarification, I would like to show individual counts for each forum. For example:
Animals - 56 Topics
Mammals - 37 Topics
Reptiles - 9 Topics
Not the 3 combined.
I appreciate your patience with me!
Animals - 56 Topics
Mammals - 37 Topics
Reptiles - 9 Topics
Not the 3 combined.
I appreciate your patience with me!
Lon2
10 November 2010, 11:16
10 November 2010, 11:16
Originally posted by ruiribPerfect examples of why Snitz forums has failed to be a leader in forums apps. Amazing comments from a person that we have paid hundreds of dollars to in the past for help with our forums. And you say I am unappreciative!?
Try what, Craig, a contest to do what you generously have done in less lines?! You're too generous with your time, if you ask me. This thread also shows how unappreciated that can be.
Carefree
10 November 2010, 12:48
For what you wanted done, there MIGHT be an easier way but I don't see it.
Using the code I wrote is simple. Put lines 5-17 at the top of your page, before you need the information. Make sure to enclose them like this:
Note: If you're not going to use the member count anywhere, you can reduce the initial code a bit, like this:
Then put the body of your page. Whereever you'd like the output of message counts, you'd use this (changing the forum numbers in red to the ones you wish displayed), adding lines in that pattern to display additional forums:
Finally, at the bottom of the body segment of your web page (just above the closing < /body > tag, include the rest of the code I provided, like this:
That's all there is to it. Unless you provide your page to me with a list of the forum IDs for me to do it for you, that's about as easy as it gets.
10 November 2010, 12:48
Perfect examples of why Snitz forums has failed to be a leader in forums apps. Amazing comments from a person that we have paid hundreds of dollars to in the past for help with our forums. And you say I am unappreciative!?Well, you may have paid someone for help on a particular issue or even to set up a board, I don't know. I know that I didn't get paid "hundreds of dollars" for my thousands of messages trying to help people. I also know that it is customary to at least read a message (before discarding it) when someone tries to help you.
For what you wanted done, there MIGHT be an easier way but I don't see it.
Using the code I wrote is simple. Put lines 5-17 at the top of your page, before you need the information. Make sure to enclose them like this:
Code:
<!--#INCLUDE VIRTUAL="itw/config.asp"-->
<!--#INCLUDE VIRTUAL="itw/inc_func_common.asp"-->
<%
dim intMembers, intTopics, intForumID
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open(strConnString)
strSql = "SELECT COUNT(MEMBER_ID) AS CNT FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1"
set rsCount = my_Conn.Execute(strSql)
if not rsCount.EOF then
intMembers=rsCount("CNT")
rsCount.Close
end if
set rsCount = Nothing
%>
Note: If you're not going to use the member count anywhere, you can reduce the initial code a bit, like this:
Code:
<!--#INCLUDE VIRTUAL="itw/config.asp"-->
<!--#INCLUDE VIRTUAL="itw/inc_func_common.asp"-->
<%
dim intTopics, intForumID
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open(strConnString)
%>
Then put the body of your page. Whereever you'd like the output of message counts, you'd use this (changing the forum numbers in red to the ones you wish displayed), adding lines in that pattern to display additional forums:
Code:
<%
intForumID=1
Call TopicsInForum(intForumID)
intForumID=2
Call TopicsInForum(intForumID)
%>
Finally, at the bottom of the body segment of your web page (just above the closing < /body > tag, include the rest of the code I provided, like this:
Code:
<%
my_Conn.Close
set my_Conn = Nothing
Sub TopicsInForum(intForumID)
' ## Total Topics in a Particular Forum
intForumTopics = 0
strSql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & intForumID
set rsTitle = my_Conn.Execute(strSql)
if not rsTitle.EOF then
strForumTitle=rsTitle("F_SUBJECT")
rsTitle.Close
end if
set rsTitle=Nothing
strSql = "SELECT COUNT(TOPIC_ID) AS CNT FROM " & strTablePrefix & "TOPICS WHERE T_STATUS=1 AND FORUM_ID=" & intForumID
set rsCount = my_Conn.Execute(strSql)
if not rsCount.EOF then
intForumTopics=rsCount("CNT")
rsCount.Close
end if
set rsCount = Nothing
Response.Write "Our """ & strForumTitle & """ forum currently has " & intForumTopics & " topics.<br>"
End Sub
%>
That's all there is to it. Unless you provide your page to me with a list of the forum IDs for me to do it for you, that's about as easy as it gets.
Classicmotorcycling
10 November 2010, 13:14
10 November 2010, 13:14
Why don't you provide the HTML from the page that you want to show the stats in so Craig or anyone else can get a better understanding of what you are after and what the code needs to contend with.
Big bit of miss information with this comment:
You need to be clear in what you need in any site asking for help, especially for free help. You need to provide samples of what you have that you need working, and most important, you need to have a willingness to learn how to adapt the code that is provided if it is not what you thought that the supplied solution is.
Do not get up set with others on here because you what something that you have not been clear with and provided everything as it is not showing as you feel it should, adapt it to do what you want.
Big bit of miss information with this comment:
Originally posted by Lon2Depends and what the forum type is depends on where the forum app sits. Given that this is quite clearly the best Classic ASP forum app going otherwise there would not be millions around the globe using it, including yourself for it's ease and functionality.
Perfect examples of why Snitz forums has failed to be a leader in forums apps. Amazing comments from a person that we have paid hundreds of dollars to in the past for help with our forums. And you say I am unappreciative!?
You need to be clear in what you need in any site asking for help, especially for free help. You need to provide samples of what you have that you need working, and most important, you need to have a willingness to learn how to adapt the code that is provided if it is not what you thought that the supplied solution is.
Do not get up set with others on here because you what something that you have not been clear with and provided everything as it is not showing as you feel it should, adapt it to do what you want.