Any idea what replaced the Active field in the forum table?

[sel100]

We are currently running vbulletin version 2.3.0 and are in the process of upgrading to 3.0.3. There are obviously changes in the database table structure and somewhere from version 2.3.0 to version 3 one of those changes appear to be the active field in the forum table. This field appears to have been dropped in one of the versions along the upgrade route to the latest current version, does anyone know if it has been replaced with something else? Our problem is how to get the current number of active threads from the Mysql database? The reason we need this information is that it is displayed on our home page using a script which no longer works with version 3.0.3 because of this change.
Many thanks,
Sel

[Zachery]

Originally Posted by sel100

We are currently running vbulletin version 2.3.0 and are in the process of upgrading to 3.0.3. There are obviously changes in the database table structure and somewhere from version 2.3.0 to version 3 one of those changes appear to be the active field in the forum table. This field appears to have been dropped in one of the versions along the upgrade route to the latest current version, does anyone know if it has been replaced with something else? Our problem is how to get the current number of active threads from the Mysql database? The reason we need this information is that it is displayed on our home page using a script which no longer works with version 3.0.3 because of this change.
Many thanks,
Sel

What did the script you were using do?

[Andreas]

Hmm ... what is an "active" thread?

[sel100]

SELECT * FROM forum WHERE displayorder<>0 AND active = 1 ORDER BY
parentid,displayorder

Here is the sql query which pulls back 22 threads from our boards (running 2.3.0). It pulls back 24 threads if the "AND active=1" is removed. Not sure what warrants the active flag being set to 1 but the difference is when 24 threads are returned it contains threads which haven't had posts on then for a while. So what we want to return is a list of threads which have had posts in the last few hours. Many thanks.

[Andreas]

Table fourm does have a field lastpost, which is the unix timestamp for the last post made in this forum.
You can use this field to check which forums have been active within the last x hours, days or whatever.
Table thread does also have lastpost.

[Zachery]

Originally Posted by sel100

SELECT * FROM forum WHERE displayorder<>0 AND active = 1 ORDER BY
parentid,displayorder

Here is the sql query which pulls back 22 threads from our boards (running 2.3.0). It pulls back 24 threads if the "AND active=1" is removed. Not sure what warrants the active flag being set to 1 but the difference is when 24 threads are returned it contains threads which haven't had posts on then for a while. So what we want to return is a list of threads which have had posts in the last few hours. Many thanks.

I don't think active was a standard filed in vBulletin at any time

[sel100]

Hi

Looking at the admin console there is option to make a forum active, does anyone know which field and table does this correlate to in the database

Sel