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.

[Daky]

Originally Posted by hambil

I have no idea.

it wont i am using both.

www.diskusije.net

[dbirosel]

Originally Posted by 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.

I'm also getting that error....

[Neo_Angelo]

sweet hack thanks *neo clicks install*

[rjmjr69]

After installing per instructions I get no display in the forum statics box nothing. images are there product installed correctly did the template edit manually. ?

[hambil]

Did you also follow the instructions in giant red letters?

[rjmjr69]

Originally Posted by hambil

Go into the usergroups and save them (even though you haven't made a change). There is some sort of odd permission bug happening.

Sorry did not catch this post before installing. This has fixed my issues. Thank you very nice hack

Did you also follow the instructions in giant red letters?

Sadly NO I did not Sorry to waste your time

[hambil]

Originally Posted by rjmjr69

Sorry did not catch this post before installing. This has fixed my issues. Thank you very nice hack




Sadly NO I did not Sorry to waste your time

LOL - it happens

[rjmjr69]

Would it be possible to have the new usernames appear with the usergoup assigned colors?
Like staff is blue registered are green etc etc......
I looked for the normal [username] to change to [musername] but did not find anything in the template or the plug in

[hambil]

Originally Posted by rjmjr69

Would it be possible to have the new usernames appear with the usergoup assigned colors?
Like staff is blue registered are green etc etc......
I looked for the normal [username] to change to [musername] but did not find anything in the template or the plug in

Sure. In the forumhome_complete hook find

PHP Code:

$newusername = $member['username']; 


And replace it with:

PHP Code:

$newusername = fetch_musername($member); 


[Daky]

Originally Posted by 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!

Looks like there is no way to do this? to bold the numbers eh?

Pls help, i would like to have it bold on my site www.diskusije.net

D