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.

[rayw]

Installed and working great on my forum, i think!

[rayw]

There is an option in the admincp Set this to number of previous months you want included in trend data.

If I set this to 1, will it calculate the figures based on the previous months registrations, posts, threads etc? I'm assuming that by leaving it at 6 months it uses averages based on a 6 month period?

Can anyone confirm this for me please?

Thanks

[kiFF]

It's not working for me. I tried it with and without auto replace. If "auto replace" is off and I add edit the template, the statistics box is empty. And if I turn "auto replace" on and leave the template unedited, it just shows the default statistics.

[Ronak]

Awesome hack

[Digbijoy]

will surely install when it is out of beta stage.

I hope by that time, more features get added.

[nikki712]

Edited: I got it fixed. Great hack!

[rayw]

Originally Posted by rayw

There is an option in the admincp Set this to number of previous months you want included in trend data.

If I set this to 1, will it calculate the figures based on the previous months registrations, posts, threads etc? I'm assuming that by leaving it at 6 months it uses averages based on a 6 month period?

Is anyone able to answer this for me please?

Thanks!

[FreshFroot]

Originally Posted by kiFF

It's not working for me. I tried it with and without auto replace. If "auto replace" is off and I add edit the template, the statistics box is empty. And if I turn "auto replace" on and leave the template unedited, it just shows the default statistics.

same here.. very odd... i don't get why? could another stats hack be causing a problem or something? This hack doesn't show anything at all..

NVM... guys if it doesn't work.. MAKE SURE it is FTPed properly. Since my admincp folder is different it missed 1 file.. but anyways, be SURE everything is FTPed right.. double check it for the people that it isn't working for.

[hambil]

Originally Posted by rayw

Is anyone able to answer this for me please?

Thanks!

Yes, that is how it works. Month to date average for the past x months (not including the current month, since the current month is the comparison point).

[wolfe]

heres a alteration to show the newest members in the usergroup colour

FIND: plugin manager > [vbTrends] Run Main Trends Code

        $vbtrends_newmembers_bit = '';    
        while($member = $db->fetch_array($vbtrends_last_x_joins_result))
        {
              $newuserid = $member['userid'];
              $newusername = $member['username'];
              eval('$vbtrends_newmembers_bit .= "' . fetch_template('forumhome_vbtrends_newmember_bit') . '";');
        }
    }

REPLACE WITH:

        $vbtrends_newmembers_bit = '';    
        while($member = $db->fetch_array($vbtrends_last_x_joins_result))
        {
              $newuserid = $member['userid'];
                        fetch_musername($member);
              $newusername = $member['musername'];
              eval('$vbtrends_newmembers_bit .= "' . fetch_template('forumhome_vbtrends_newmember_bit') . '";');
        }
    }

THEN FIND: plugin manager > [vbTrends] Default Last X Joins Hook

    // Last x joins
    $vbtrends_last_x_joins_result = $db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "user              
        ORDER BY joindate DESC
        LIMIT " . $vbulletin->options['vbtrends_newmembers']
    );

REPLACE WITH:

    // Last x joins
    $vbtrends_last_x_joins_result = $db->query_read("
        SELECT username, userid, joindate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        FROM " . TABLE_PREFIX . "user AS user               
        ORDER BY joindate DESC
        LIMIT " . $vbulletin->options['vbtrends_newmembers']
    );

result atttached

asked bwt it a while bk and no response so made it my self