Web Wiz Forums - Getting total number of active topics.

Print Page | Close Window

Getting total number of active topics.

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13778
Printed Date: 12 April 2026 at 4:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Getting total number of active topics.

Posted By: niugiovanni
Subject: Getting total number of active topics.
Date Posted: 11 February 2005 at 11:31pm

I'm just finishing up a site integration of WebWiz ( http://www.heatofbattle.net/new/ - http://www.heatofbattle.net/new/ ) and the last thing I want to do is query the Active Topics to find two things:

1. How many topics have been posted in since the last visit.

2. If any of these topics are from a certain Category.

The category-specific query is easy once I figure out a good way to finish goal #1. I'm wondering if anyone has any suggestions towards the logic for this? My initial thought is to execute a complete Active Topics process (without Response.write) and count the amount of loops. The topics per page and great amount of code necessary for this leads me to believe that there's another solution that I'm missing.

Thanks in advance!

Replies:

Posted By: dj air
Date Posted: 12 February 2005 at 7:02am

the active topics page already can be set to check for "since last visit"

so if you look in the code you should see some where , where it gets the last visit date value and adds it to the query.

Posted By: niugiovanni
Date Posted: 12 February 2005 at 11:37am

FYI, what I did was a standard call to every forum_ID that I'd like to check for. It removes the last 25 posts and checks to see if any of them are newer than your cookie. This isnot ideal and I hope to use some of the Active Topics code. I'm just not smart enough yet to extract exactly what I need.