UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [UBBT 6.0] Thread and Post count utility

This script will display the thread and post count of your boards along with the actual thread and post count at the time of loading. Stored values that do not match the actual values will be highlighted. If there are discrepencies you will have an option to "UPDATE" the information.


The instructions are in the script for installation. Basicly add a new link to your menu.php script in your admin directory and upload both scripts to your admin directory.


Hope someone finds this usefull. I made it because I wanted to try and count posts for each board with one query and then it evolved. LoL <img src="/threads/php/images/icons/crazy.gif" alt="" />


Edit: The latest version of this script is attached to this post.

interesting

mine was off a bit in both threads and posts - what happened to the posts that were stored and not counted when I clicked on "update" It showed ~18044 listed and 18060 stored... When I updated, both numbers dropped to 18044 )

The stored number was off then. The "actual" number list is what the script counted for each board when it loaded. When you cliked "update" it loads the page again but adjusts the stored count to what it actually counted while loading.


Just a note: It will not count unapproved posts.

ok, thanks neat little utility

Your Welcome

Now this is a useful tool! I'll add it to my 'add on after upgrading to 6.0.2 list'

It works great.

I'm using it with 6.1b2.

The only change needed is to replace "w3t_" with "{$config['tbprefix']}" for 6.1. Otherwise, I think it's ready for Finished Modifications.

I wonder if the following code could be used for 6.0-6.1 compatibility:
if (!isset($config['tbprefix'])) {
$config['tbprefix'] = 'w3t_';
}

That's not a bad idea. Then it will be of use across both versions.

A couple of other suggestions.

1) $error should be set if the thread or post counts differ for any of the individual boards, rather than by comparing the total counts. It's possible, although unlikely, that discrepancies in two boards could cancel out.

2) To make this function more user-friendly, add the following text (or something similar) to the top of the display.

If all counts agree: "Stored and actual counts agree - no corrections required."

If there are discrepancies: "Stored and actual counts differ - use the Update button to correct the stored counts."

I have updated the script to make it work with 6.0.x as well as 6.1+ as was mentioned in this thread. I also added the more detailed error check and added the extra information to make it more user friendly as was suggested as well. Some cosmetic changes were made as well.

It is still the same script that JustDave wrote though, so all credit should go to him.

Thanks

Shouldn't the initial post be updated with the new attachment?

Yeah, you're right. I've updated the original post with the new version of the script.

Just in case I forget ...

A small fix to this hack will make it compatible with 6.2. If no one else adds this fix, please remind me about this after 6.2 goes into public beta, and I'll post it here.

I'll jump the gun and post this fix for 6.2 now, while I'm thinking about it, although 6.2br1 hasn't been released yet.

Change:

code:
if ($option == "UPDATE") {

---

To (option 1, compatible with 6.0, 6.1 and 6.2):

code:
if (isset($HTTP_POST_VARS['option']) and $HTTP_POST_VARS['option'] == "UPDATE") {

---

Or To (option 2, compatible with 6.2 only):

code:
if (get_input('option', 'post') == "UPDATE") {

---

Thanks keeping this updated Dave/Gardener.
I am surpised this little utility gets the use it does. (it is handy though)