Statistics Modifications - vbTrends - An Enhanced Statistics Box on Forum Home

Note: This product is now being supported at www.catnine.net

Keywords: Statistics, New members, joins, trends, Forum Home, threads, posts

ATTENTION:
If you download the latest version go into your usergroups and set the 'can view trends' permission. SAVE the usergroup even if you haven't changed the setting or things may not work. There is an odd permissions bug I haven't figured out yet.

Also note that overwrite will not work. Please uninstall the previous version before installing the new one.

Description:
Enhances the "YourBBS" Statistics box on the forum home to show trends of posts, threads and new users vs. the overall history of the board. Also allows you to display more than one "newest member".

Version 2.0.0:

1. Calculations exposed and modifiable in admincp.
2. Added ability to delay updates of stats to every x minutes in admincp.
3. Added a style setting for positive and negative trends.
4. Added custom hooks for all aspects of vbTrends, and moved code into said hooks.
5. Changed template to still show total threads when trend is negative and 'positive trends only' is enabled.
6. Usergroup permission to view trends.

Note: You cannot cause an error by messing up the calculations in the admincp. If the calculation you provide contains errors the stat in question will show as N/A.

This is a major rewrite, so I've set the hack to beta for now.

Version 1.2.6:

1. Made some minor tweaks for cleaner code
2. Made change to build datastore call to force serialization

You can just overwrite the product.xml if you are upgrading. Remember vbTrends has an option in the admincp to reset the counters. To see any changes/fixes you'll want to run that, or you'll end up having to wait for a new day before the changes will take affect.

Version 1.2.5:

1. fixed minor bug in auto-replace that was causing it not to work on some boards

Version 1.2.4:

1. fixed bug in percentage of active users
2. fixed bug in limit of queries (added order by)

Thanks to bchertov and Battle_Ring for the testing

Version 1.2.3:

1. Added option to display % of active users.
2. Added option to set the number of previous months to include in the trend data.

Version 1.1.3:

1. Updated for vBulletin 3.6.
2. Fixed long standing problem with stats calculating incorrectly.
3. Added option to only show positive trends.

Version 1.1.2:

1. Added admincp menu to reset cached counters.
2. Fixed a couple of divide by zero errors that occurred when your board had no history (was less than a month old).
3. Fixed so templates are now cached.

Version 1.1.1:

1. Fixed calculation of statistics - should definately be correct now

Version 1.1.0:

1. Fully phrased.
2. Uses templates now so look and feel can be customized
3. Fixed bug so output is valid xhtml 1.0.

Version 1.0.0:

1. Turn on/off in admincp
2. Offers the option to auto replace in templates, or to manually edit templates.
3. Allows more than one 'newest user' to be display.
4. Shows trends for posts, threads and new users - this month vs. the boards average.

Install

1. Download the vbTrends_2.0.0.zip.
2. Unzip and follow instructions in install.html.

[Deadly Assassin]

Originally Posted by hambil

It's all fixed. It appears the old template didn't get updated when you installed the new version. I have no idea why that would happen. I think perhaps it might be when people do an overwrite instead of an uninstall and reinstall, but I'm not sure.

I highly recommend anyone installing 2.0.0 do an uninstall and reinstall though.

Thanks m8, much appreciated!

[RedGTiVR6]

I can't download the .zip file for some reason.

When I do, then try and open it, it tells me it's corrupt and there's nothing in the .zip file.

Am I the only one experiencing this?

[hambil]

Odd. I use 7-zip.

Hmmm... looks like the zip got screwed up on upload somehow. I just re-uploaded it.

[encryption]

Originally Posted by hambil

It means that so far this month you've had four new threads. And compared to the last 2 months, that's 117% more than you usually have by this time of the month.

then there's something wrong in the way this mod is tracking new information because this is what I see in the admin panel and we're 11 days into the month already

New Threads Today 6


Is it 4 new threads from the date/time of install ?

[hambil]

Originally Posted by encryption

then there's something wrong in the way this mod is tracking new threads because this is what I see in the admin panel and we're 11 days into the month already

New Threads Today 6


Is it 4 new threads from the date/time of install ?

No, it shouldn't be. Let me double check the code and get back to you.

Well, here is the query used, I don't see anything wrong with it off hand...

SELECT count(*) AS 'ThreadsThisMonth'
FROM " . TABLE_PREFIX . "thread
WHERE YEAR(FROM_UNIXTIME(dateline)) = YEAR(NOW())
AND MONTH(FROM_UNIXTIME(dateline)) = MONTH(NOW())

Ahha! I found an error in the template. I've uploaded the new zip. Uninstall/Reinstall to make sure the template change gets picked up and you should be good to go.

[encryption]

yep, that fixed it

Threads: 38,782, This Month: 466 (118%)
Posts: 471,538, This Month: 4441 (94%)
Members: 13,425, This Month: 236 (5%)

[voteforbird]

These stats are not accurate. I'm getting a 93% increase in threads, a 95% increase in posts and a 1% increase in members. This is on a 355,000-post board. The 90 numbers are waaay too high. Activity is steady. *disabled*

BTW I assume encryption's stats are incorrect, as well.

[hambil]

Originally Posted by voteforbird

These stats are not accurate. I'm getting a 93% increase in threads, a 95% increase in posts and a 1% increase in members. This is on a 355,000-post board. The 90 numbers are waaay too high. Activity is steady. *disabled*

BTW I assume encryption's stats are incorrect, as well.

Very simple fix. Change the calculations used in the admincp settings as follows:

Before:

round(($current / $avg) * 100)

After:

round(($current / $avg) * 100) - 100

It's the difference between considering 100% to mean 'dead on track' or '0%' to mean 'dead on track'. That's why I've exposed the calculations in this release. The minute I change it to be one way, someone will want it the other way.

[hambil]

Of course, when you make the change all your numbers will be negative, and you probably won't like that either. Meh, I've done all I can do

[spazz191]

How many queries does this mod do? I am trying to streamline my forum and disable query intensive mods.