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.

[hambil]

Originally Posted by djjeffa

I upgraded and dont see this option in user group
any ideal why?

Make sure you uploaded all the xml files. Other than that, it should work.

[djjeffa]

Originally Posted by hambil

Make sure you uploaded all the xml files. Other than that, it should work.

thank you that was it

[Devil Woman]

HI there, I installed this a few weeks ago and since updating the other day I have had problems with it showing up, but yet it was showing up before I upgraded.

I have uninstalled and resinstalled it again tonight with no success any help is appreciated.

[hambil]

Originally Posted by Devil Woman

HI there, I installed this a few weeks ago and since updating the other day I have had problems with it showing up, but yet it was showing up before I upgraded.

I have uninstalled and resinstalled it again tonight with no success any help is appreciated.

For some reason I haven't figured out yet, you need to open each usergroup and re-save them for the 'can view trends' setting to take effect for that group.

[Devil Woman]

Thanks alot, have done and it's sorted

Thanks again.

[RedGTiVR6]

I just tried to install this update and have run into an issue.

I uploaded the files and I've uploaded the .xml file allowing rewrite.

I then go into the usergroups to allow the various user groups to view, when on an administrator and I select yes to can view, then hit update, I get the following database error:

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`vbtrends_permissions` = '1',
	`vbgmepermissions` = '31',
	`vbclassified` = '122879',
	`vbclassified_timeframe_limit` = '365',
	`vbimghost` = '3',
	`vbimghost_upslots` = '20',
	`vbimghost_files` = '500',
	`forumpermissions` = '1048575',
	`attachlimit` = '0',
	`pmquota` = '2000',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions` = '1038884799',
	`genericoptions` = '55',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '100000',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '65536',
	`signaturepermissions` = '230911',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '20000',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`akspam_permissions` = '0',
	`vbwikiroles` = '',
	`vbwikipermissions` = '524287'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'vbtrends_permissions' in 'field list'
Error Number : 1054

Seems that there is an issue with "vbtrends_permissions"...

Any help?

Also, do you have any special uninstall instructions? I'd like to be able to uninstall if possible for future.

EDIT: I had to completely uninstall the .xml then reinstall it to prevent this database error from occuring.

On another note, now the stats are all exagerated. Previously, our numbers were up 8%, 11%, etc.

Now it's showing a 90% increase, 88% increase, etc.

The change is just after the update...not after a few days...but rather just within a matter of a few minutes.

[Mrdby]

Will This Mess Up Cyb's Stats Hack?

[hambil]

Originally Posted by RedGTiVR6

On another note, now the stats are all exagerated. Previously, our numbers were up 8%, 11%, etc.

Now it's showing a 90% increase, 88% increase, etc.

The change is just after the update...not after a few days...but rather just within a matter of a few minutes.

That's because the new forumals are 100% based by default. It's an easy change. In the admincp change round(($current / $avg) * 100) to round(($current / $avg) * 100) - 100.

[hambil]

Originally Posted by Mrdby

Will This Mess Up Cyb's Stats Hack?

I have no idea.

[Daky]

This is very nice script, i love it!

Thank you!

I would just like to ask you how to bold this:

Teme: 2,342, Ovaj mesec: 159 (99%)
Poruke: 72,221, Ovaj mesec: 6366 (102%)
Članovi: 4,971, Ovaj mesec: 274 (4%)

I would like all numbers to be bold, only numbers.

TO BE LIKE: Teme: 2,342, Ovaj mesec: 159 (99%)

teme = threads
poruke = posts

Thank you!