vbTrends - An Enhanced Statistics Box on Forum Home

[hambil]

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:

Calculations exposed and modifiable in admincp.
Added ability to delay updates of stats to every x minutes in admincp.
Added a style setting for positive and negative trends.
Added custom hooks for all aspects of vbTrends, and moved code into said hooks.
Changed template to still show total threads when trend is negative and 'positive trends only' is enabled.
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:

Made some minor tweaks for cleaner code
Made change to build datastore call to force serializationYou 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:

fixed minor bug in auto-replace that was causing it not to work on some boardsVersion 1.2.4:

fixed bug in percentage of active users
fixed bug in limit of queries (added order by)Thanks to bchertov (https://vborg.vbsupport.ru/member.php?u=70601) and Battle_Ring (https://vborg.vbsupport.ru/member.php?u=53180) for the testing :)

Version 1.2.3:

Added option to display % of active users.
Added option to set the number of previous months to include in the trend data.Version 1.1.3:

Updated for vBulletin 3.6.
Fixed long standing problem with stats calculating incorrectly.
Added option to only show positive trends.Version 1.1.2:

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

Fixed calculation of statistics - should definately be correct now :)Version 1.1.0:

Fully phrased.
Uses templates now so look and feel can be customized
Fixed bug so output is valid xhtml 1.0.Version 1.0.0:

Turn on/off in admincp
Offers the option to auto replace in templates, or to manually edit templates.
Allows more than one 'newest user' to be display.
Shows trends for posts, threads and new users - this month vs. the boards average.Install
Download the vbTrends_2.0.0.zip.
Unzip and follow instructions in install.html.

[Nikke]

Will install!

[mcyates]

excellent, installed.

Thanks

[projectego]

Awesome!

/me clicks install

[Sam21]

Awesome work I've installed!

[hambil]

Just corrected a minor logic glitch that made the 'positive' only work in reverse. No need to reinstall unless you want to - just remember if you don't the yes/no is reversed.

[TTG]

Nice addition :
Added option to only show positive trends.

Clicked install

[kewl1uk]

Installed. Thank you. Just wondering how often the stats updates.

[hambil]

Installed. Thank you. Just wondering how often the stats updates.
Once a day

[kewl1uk]

Once a day

Ok thanks. Great much needed mod!

[asj]

Thanks

[MThornback]

Great work as always, glad your feeling better :D

[SaN-DeeP]

Thanks I will need this.

[Blackhat]

looks like this makes mysql use way to much server resources for a large site like mine :P

[hambil]

looks like this makes mysql use way to much server resources for a large site like mine :P
You can't show stats without running a few queries. Nothing to be done for it other than what I already do to minimize the queries. Do you know it is an issue on your site, or are you just assuming?

[bela-meaad]

thanks

but how this work?

i mean if i got 55 memebrs in this month
will this be Negative until new members reach 56 for the next month?

same thing for threads & post?

[dbirosel]

subscribed!

will install when i get home!

[MThornback]

<a href="https://vborg.vbsupport.ru/showthread.php?t=141243" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=141243</a>

[hambil]

thanks

but how this work?

i mean if i got 55 memebrs in this month
will this be Negative until new members reach 56 for the next month?

same thing for threads & post?
They way it *should* work is it compares month-to-date. So, for today as an example - it is looking at how many members you've had join so far this month, compared to the average you've had join by the 24th in past months.

Same for posts and threads.

[MThornback]

Hambil, there is a plugin on .org here to show the percent of active users....I tried to make this and that play nice...but it isn't working, probably because I had to do the file edit...though i'm not entirely sure....is there anyway to have it display the % of active users without rocking the boat with your existing code too too much?

[hambil]

Point me toward the hack and I'll see if I can make nice with it :)

[Blackhat]

I know. But its a great addon non the less :)

[Doctor Death]

Nice job. Installed.

I would like to see an AdminCP option to toggle showing numbers of Inactive members as well.

Both active and inactive ought to be hyperlinks that list the Names of both categories...

I am always trying to figure out who my inactive people are, and this would be a great assist.

[Phooey]

This looks great, I'm clicking install now and will install it when I get home later. :D

[ymy]

Great much needed mod

clicks install

Thanks

[Atakan KOC]

Thanks....

[bchertov]

Nice Hack! However...

It looks to me that you are computing stats regarding the comparison of this month compared to the average of all other months for the life of the board. I don't think this give a fair representation. I think it would be better to offer a limit of the number of months the trend is based on (default to 3 and expose as a ACP option).

Installed and removed pending update...

[hambil]

A limit is certainly easy enough to implement, and a good idea. I'll have an update later today with some more options re: limits and ranges, and some active users percentage stuff as requested.

[Lizbaby4]

I am pretty new at this and the instructions were very vague. Could you be more specific as to where the files go?

Needless to say, it is not working for me.

[hambil]

Hi liz, and welcome :) There is an install.html file that is contained within the zip. Did you read that? If so, and you are still unsure let me hack a look at the install.html and see if I can't break it down even better.

[odie3]

Great MOD and Great Information to have! Thanks!!

However, for my Black and Gold the Arrows are not showing up like on Default. I went ahead and did the "edit" template bits and turned off the Auto Option.

[Battle_Ring]

Think you can make an addition to this for Active Users and the Percentage

[hambil]

Think you can make an addition to this for Active Users and the Percentage
Yes :)

https://vborg.vbsupport.ru/showpost.php?p=1212071&postcount=28

[Battle_Ring]

cool cant wait

now get to work lol j/k

[odie3]

Great MOD and Great Information to have! Thanks!!

However, for my Black and Gold the Arrows are not showing up like on Default. I went ahead and did the "edit" template bits and turned off the Auto Option.

Had to install icons in /images/bgold/misc/ for my style.

[Lizbaby4]

Hi liz, and welcome :) There is an install.html file that is contained within the zip. Did you read that? If so, and you are still unsure let me hack a look at the install.html and see if I can't break it down even better.
Yes, I did. When I unzipped the file, there were 3 files. I uploaded the .xml file into the AdminCP. I opened the Includes file and moved the vbtrends file to the adminCP file on my ftp page, the misc folder to the images folder, and the xml file to the includes/xml file, and still nothing.

Now sure what else I have to do to get it working.

[Battle_Ring]

hey also what about a new member today addition

[akulion]

thanks

installed and workin A-OK

[hambil]

Yes, I did. When I unzipped the file, there were 3 files. I uploaded the .xml file into the AdminCP. I opened the Includes file and moved the vbtrends file to the adminCP file on my ftp page, the misc folder to the images folder, and the xml file to the includes/xml file, and still nothing.

Now sure what else I have to do to get it working.
Some people have reported trouble with the auto-replace. Try turning that off and making the suggested template edit instead.

[odie3]

Yes, that is what it allow it to work for me! Its a very easy edit....

[hambil]

Uploaded 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.

[Battle_Ring]

sorry but the percentage aint working

http://www.traderretreat.com/forum/forums.php

It shows as this
(0%)
Threads: 35,012, This Month: 1609 (76%)
Posts: 172,498, This Month: 9480 (109%)
Members: 2,318, This Month: 42 (-23%)

Welcome to our newest 5 members, jocadi, robby, jrpeevyhouse, Munoz99OD, Gmac555


Got it to work on one of my sites and it shows like this

Active Members: 411 (47.7351916376%)
Threads: 7,737, This Month: 1673 (26%)
Posts: 44,613, This Month: 8588 (14%)
Members: 861, This Month: 63 (-58%)

Welcome to our newest 5 members, Brickyard Jim, Hands, mypens66, NASCAR101, CollectorsCentral

whys it go out some many numbers

[bchertov]

I see that you have added "LIMIT " . $vbulletin->options['vbtrends_max_months']" where you are determining the base line for your trends. It seems to me that you would also need to include an ORDER BY so you get the most recent vbtrends_max_months months.

[hambil]

I added a round, hopefully that takes care of it.

As for the 0%, it looks like you've deactivated showing active members, but let showing active members percentage on. I've changed the code to handle that condition now.

I've uploaded the new zip.

[hambil]

I see that you have added "LIMIT " . $vbulletin->options['vbtrends_max_months']" where you are determining the base line for your trends. It seems to me that you would also need to include an ORDER BY so you get the most recent vbtrends_max_months months.
You are correct!

[Itzbenreel]

Installed, but the stats aren't showing yet. Is this a timed event? Do I need to update all counters before it will work. NOTE: This is on a fresh installed vB w/ 3 users and 300 posts.

[hambil]

Stats should show. Make sure you have "show positive trends only" turned off.

You may also need to do the manual change of the template. Some people are reporting problems with the auto-replace. I'm looking into that, but haven't been able to duplicate it on my board yet.

[Battle_Ring]

Ok percentage is howing up now but it says 0
Active Members: 0 (0%)
Threads: 35,023, This Month: 1620 (77%)
Posts: 172,594, This Month: 9576 (111%)
Members: 2,318, This Month: 42 (-23%)

Welcome to our newest 5 members, jocadi, robby, jrpeevyhouse, Munoz99OD, Gmac555

http://www.traderretreat.com/forum/forums.php

i have everything set to on, any ideas

[hambil]

percentage still not working

http://www.traderretreat.com/forum/forums.php

i have everything set to on
I've tested all combinations on my board - which is admittedly under construction and not open to the public yet, but still, it works for me. Can I get a temp login to check it out for you?

[Battle_Ring]

pm sent

[MThornback]

Bless your socks Hambil, just what I was looking for :D

[hambil]

Ok percentage is howing up now but it says 0
Active Members: 0 (0%)
Threads: 35,023, This Month: 1620 (77%)
Posts: 172,594, This Month: 9576 (111%)
Members: 2,318, This Month: 42 (-23%)

Welcome to our newest 5 members, jocadi, robby, jrpeevyhouse, Munoz99OD, Gmac555

http://www.traderretreat.com/forum/forums.php

i have everything set to on, any ideas
Hmmm, I can't see what is going on right away anyway. The problem is $activemembers isn't get calculated properly or set properly. The thing is, my hack has nothing to do with that. It's set by vbulletin itself. From it's standpoint my hack is reporting correctly - 0 active users = 0 percentage active users.

[Masked Crusader]

Hey Hambil --

I want to put a semicolon after the phrase "Welcome to our newest {X} members," instead of the comma.

Where would I go to edit this?

[hambil]

It's in the template forumhome_vbtrends_newmember_bit :)

[akulion]

hi im having a bit of a problem after upgrading

it shows the active members % all wrong:

https://vborg.vbsupport.ru/

[hambil]

hi im having a bit of a problem after upgrading

it shows the active members % all wrong:

http://img443.imageshack.us/img443/9227/statsmm3.png
Um... the calculation in my code looks correct. Did you overwrite or uninstall/reinstall?

[akulion]

overwrite ( :D I made a booboo didnt I? )

should I uninstall and reinstall?

[Battle_Ring]

Ok its showing now with 1.2.5 isntalled

Active Members: 541 (27050%)
Threads: 35,029, This Month: 1626 (78%)
Posts: 172,638, This Month: 9620 (112%)
Members: 2,320, This Month: 44 (-19%)

But look at the members area shows its down -19% lol

[hambil]

overwrite ( :D I made a booboo didnt I? )

should I uninstall and reinstall?
Yes, try that please :)

[hambil]

Well its showing the active Users now

But no Percentage
Okay, let me have another look - if we have the active users we should be good...

[akulion]

very strange...
uninstalled and then reinstalled
same results.

But eitherways its not a biggie since I only wanted the trends months bit...so just disabled the active %

Thanks for this wonderful mod! :D

[hambil]

Yeah, I see that. Looks like you're not alone. I've got another bug grrrrrr. This is what I get for trying to be responsive and make quick additions for you guys :p

I'm all over it, thanks :)

[hambil]

Okay... that was a fun one.

$activemembers and $numbermembers are strings that can contain commas if you have enough members. I needed to strip out the commas before trying to do math with them. Thanks to Battle_Ring for the use of his board to debug. I couldn't have found this without him (my board is too small).

[odie3]

So, that is a new *stable* version to download now?

[hambil]

So, that is a new *stable* version to download now?
Well, let's hope so. So far so good.

[odie3]

Okay, I think this is working (http://ghostdogs.net/forums/)... ;)

[akulion]

yes the percentages are working too now
thanks

[Lizbaby4]

quick question

I have this:

Active Members: 44
Threads: 929, This Month: 492 (16%)
Posts: 8,443, This Month: 4792 (24%)
Members: 50, This Month: 21 (8%)

Welcome to our newest 7 members, chxxxy, Jxxx79, Melxxx05, Bxxx80, BAxxx1, caxxx07, mixxxee
Welcome to our newest member, mixxxee

But mixxxee is not our newest member, chxxxy is. How do I change that? Where is the setting to list the newest member, not the 7th newest member?

[akulion]

the settings for the mod can be found in vBulletin Option ---> vbTrends

[hambil]

Well, "Welcome to our newest member" is replaced by my hack with "Welcome to our newest x members". It's not supposed to show both, as that is a bit confusing. Sounds like the template edit went bad.

If you actually want to show both, I will add to the next version release something that will fix your problem. However, we just got things stable, so let's let a few bugs and/or feature requests add up before I make another change.

[Doctor Death]

Have you considered adding an option to show number of inactive users that is hyperlinkedl to their names? I would love this to determine who my inactive members are since I run a small board.

In Admincp options you would have "Show Inactive users YES NO"

Great mod

[hambil]

Have you considered adding an option to show number of inactive users that is hyperlinkedl to their names? I would love this to determine who my inactive members are since I run a small board.

In Admincp options you would have "Show Inactive users YES NO"

Great mod
Interesting. After some searching it looks like there are several 'auto-prune' and 'auto-email' inactive users hacks out there, but nothing that just simply lists them. Perhaps, you'd be better off talking up one of those hack authors though. I don't want this hack to start to become a grab-bag.

[Doctor Death]

One other request: I use a version tracker for products within VB. Could you please consider supporting version checking and other product metadata (website link, etc).

Thanks, this is great stuff.

[hambil]

One other request: I use a version tracker for products within VB. Could you please consider supporting version checking and other product metadata (website link, etc).

Thanks, this is great stuff.
I definitely want to do that. Right now I'm still in the process of setting up my own site, and will version check and website link and whatnot everything once it's up and running :)

[ericgray]

i love it!

www.pbsmiles.com

could we set off the line titles in bold?

like this --

Active Members: 261 (25%)
Threads: 12,077, This Month: 606 (2%)
Posts: 168,037, This Month: 10096 (18%)
Members: 1,057, This Month: 65 (25%)
Welcome to our newest 5 members, Amatul, mmr, luv4pits, Ulyssa, chellyk17
There have been 489 post(s) in the last 24 hours.

[ericgray]

also, is there a way to get commas inserted?

like in the 10000 number above -- 10,000 is much easier -- :D

[hambil]

also, is there a way to get commas inserted?

like in the 10000 number above -- 10,000 is much easier -- :D
Good point. I'll add it to the next release once we have enough changes to warrant the risk again :)

[spazz191]

Has anyone experienced an issue with this hack and ibProArcade. When I have this hack enabled I cannot access the arcade, with it off I can. I looked on the ibProarcade forums and there is nothing said over there.

[ymy]

Hi

I am Installed . but no percentage all (0%) (0%) (0%)

any help

thanks

[hambil]

Has anyone experienced an issue with this hack and ibProArcade. When I have this hack enabled I cannot access the arcade, with it off I can. I looked on the ibProarcade forums and there is nothing said over there.
I have ibProArcade installed on my site along with this hack, and have no issues...

[hambil]

Hi

I am Installed . but no percentage all (0%) (0%) (0%)

any help

thanks
Sounds like maybe a plug in conflict? Check and make sure vbTrends is the first plugin on the forum_complete hook.

[ymy]

Sounds like maybe a plug in conflict? Check and make sure vbTrends is the first plugin on the forum_complete hook.

Thanks a lot hambil

Yes it`s working

(86%) (62%) (234%)

excellent

ymy

[spazz191]

I have ibProArcade installed on my site along with this hack, and have no issues...

what version of ibp are you using?

[hambil]

what version of ibp are you using?
ibProArcade v2.6.1+

[spazz191]

ibProArcade v2.6.1+

I just upgraded to that to see if it resolved my issue and it didn't. The issue I am having is, I have my arcade set up as a link in the forums.
When I have vBTrend turned off or uninstalled I can click on the link http://sitename/forums/arcade.php for example and takes me to my arcade.

when I turn it on, it changes the link to http://sitename/forums/arcade/ and brings me to a paypal page to buy ibpro. I even changed the link to match the new one but it still does not work.

[RedGTiVR6]

installed per the instructions and everything works fine thus far!

[spazz191]

I just upgraded to that to see if it resolved my issue and it didn't. The issue I am having is, I have my arcade set up as a link in the forums.
When I have vBTrend turned off or uninstalled I can click on the link http://sitename/forums/arcade.php for example and takes me to my arcade.

when I turn it on, it changes the link to http://sitename/forums/arcade/ and brings me to a paypal page to buy ibpro. I even changed the link to match the new one but it still does not work.


I believe I need to do something with vBSEO. I disabled it and everything works fine. Any suggestions.

[hambil]

I've never used vBSEO. It's odd that it would cause a conflict with my hack - especially the type of conflict you are mentioning (affecting the redirect link for a forum).

I'd love to look into this on your board if you are willing to let me have privileges temporarily.

[spazz191]

I've never used vBSEO. It's odd that it would cause a conflict with my hack - especially the type of conflict you are mentioning (affecting the redirect link for a forum).

I'd love to look into this on your board if you are willing to let me have privileges temporarily.

All set, check your PM on my forum. I also turned on your hack so you can see what it does to the arcade link

[shaynehammy]

This is a great hack and could go places with more options. Keep it up.

[kewl1uk]

Problems with this after uninstalling 1.1.3 and installing 1.2.5:

Upgraded late last night and shows the percentage of active members but 0% for all the other stats. Uninstalling 1.2.5 and installing 1.1.3 doesn't work now either but worked before. Could it be because it's the start of the month?

Problems with the newest member: I have the newest member listed in a side bar on forumhome using the default vb code but the newest member is not listed there. The one that is listed is always the last to be listed in the vbtrends stats which is of course not the newest member - the first to be listed in vbtrends is the newest member. The only way to get the newest member listed in the side bar is to enable only 1 newest member in the vbtrends stats.

[hambil]

Problems with this after uninstalling 1.1.3 and installing 1.2.5:

Upgraded late last night and shows the percentage of active members but 0% for all the other stats. Uninstalling 1.2.5 and installing 1.1.3 doesn't work now either but worked before. Could it be because it's the start of the month?

Since the product was recoded and re-released last month, this is the first real test of it crossing the month barrier. There does appear to be some sort of problem. Hopefully I will have it fixed today and a bug release up.


Problems with the newest member: I have the newest member listed in a side bar on forumhome using the default vb code but the newest member is not listed there. The one that is listed is always the last to be listed in the vbtrends stats which is of course not the newest member - the first to be listed in vbtrends is the newest member. The only way to get the newest member listed in the side bar is to enable only 1 newest member in the vbtrends stats.
This is a known issue, and will be fixed in the next bug release, thanks :)

[kewl1uk]

Since the product was recoded and re-released last month, this is the first real test of it crossing the month barrier. There does appear to be some sort of problem. Hopefully I will have it fixed today and a bug release up.


This is a known issue, and will be fixed in the next bug release, thanks :)

Ok thank you. Great Mod btw

[ericgray]

it's the first of the month, and everything says -100% and -99%

this is not cool -- :|

and disabling the negative stats nukes the display overall -- :|

can't disabling the negative stats just disable the negative part, not the whole stat?

[ericgray]

also, why not have a trailing last 30,60,90 days, etc, not just the current month?

it's somewhat a useless stat today, the first -- :|

[Doctor Death]

also, why not have a trailing last 30,60,90 days, etc, not just the current month?

it's somewhat a useless stat today, the first -- :|


Concur... a running window of stats?

Great mod.

[Terminatoronly]

Happy for this release since i really did wait for this mod to be for vb 3.6.4 :D

Thanks Alot for the coder ;)

[hambil]

Well, it's supposed to compare posts, joins, threads month to date. So, the numbers should never be that small. In other words - the first day of the month compared to the average first day of the month for all other months (or x number of months based on your admincp settings).

However, I think there is a bug I'm trying to locate at the moment that might be throwing off the numbers.

All that said, the only way I can see to 'soften' the stats, would be to expand the compare window. e.g. the last 24 hours vs. the average for the last x months. That might help some.

[kewl1uk]

Mine is just the opposite and I'm not sure whether they are right because they seem high to me:

Threads: 9,012, This Month: 70 up (77%)
Posts: 188,969, This Month: 1293 up (68%)
Members: 1,777, This Month: 8 up (4%)

I'm comparing the current with the last 12 months entered into the options in the Admin CP.

I installed 1.2.5 after uninstalling 1.1.3 just before midnight on April 1st and got 0% for all three stats. But on April 2nd the stats had recovered. Personally, I think it has something to do with the datastore cache causing the problems.

[hambil]

I think it has something to do with the datastore cache causing the problems.
I think you are right. I just uploaded 1.2.6 which updates the build datastore call to use the new vb3.6 parameters. Hopefully that will fix things. Remember to reset your counters for vbTrends from its admincp options.

[Staxed]

can you alter this, or upload another version that will make this change to the vbadvanced stats template? I would like to use this but I only use the vba stats module (i have a vba column on all pages)

...i don't have this info in my forumhome template...

just let me know if you will do this or not, if not I'll play around with it myself and make it work.

[hambil]

can you alter this, or upload another version that will make this change to the vbadvanced stats template? I would like to use this but I only use the vba stats module (i have a vba column on all pages)

...i don't have this info in my forumhome template...

just let me know if you will do this or not, if not I'll play around with it myself and make it work.
I will add vbAdvanced support to the list, but it may not get done for a while. So it all depends on how long you want to wait :)

[Staxed]

alrighty then,

i'll work on it sometime this weekend probably...and when I get it working I'll send you the code :)

[hambil]

alrighty then,

i'll work on it sometime this weekend probably...and when I get it working I'll send you the code :)
That would be much appreciated, thanks :)

[djjeffa]

what happend when you reset the counter?
all my stats were up like 75% now there all down like 50% as of the beginning of this month.

[hambil]

Everytime the code runs it checks the datastore. If nothing is in the datastore, or the day in the datestore doens't match the current day, it re-runs the calculations for monthly averages. All resetting the counters does it delete the datastore entry, thus forcing a re-run of monthly stats.

[mcyates]

looks like this makes mysql use way to much server resources for a large site like mine :P
yeah this slows down my site also, i've uninstalled it.

[ericgray]

I just uninstalled this --

-- the stats just don't make any sense -- 500%, 600%, etc -- :(

and also, there's too much muddle at the bottom of the page, with no bold, etc. of the real stats, with this stuff unbolded --

-- i'll check back in the future to see if it's tidied up at all -- :D

eric

[wolfe]

I just uninstalled this --

-- the stats just don't make any sense -- 500%, 600%, etc -- :(

and also, there's too much muddle at the bottom of the page, with no bold, etc. of the real stats, with this stuff unbolded --

-- i'll check back in the future to see if it's tidied up at all -- :D

eric
why dont you tidy it up yourself by editing the forumhome_vbtrends template

also m8 getting mysql error on cron job ? anyone else getting this problem.

[hambil]

There seems to be a lot of ongoing concern/criticism of the calculations used and the stats displayed. I've decided the best way to deal with this, since I can never make everyone happy, is to expose them to the end user to tweak.

I will be releasing a version soon that uses a short hand in the admincp settings to set the calculations to anything you want (within reason). The short hand in the admincp settings will be something like: Posts: ($current / $avg) * 100. Any mathematical expression will be allowed.

In addition it will include a few new hooks, for those with real ambition to put in there own php code to get monthly averages, and do the final percentage calculations. The hack will use these hooks itself, to provide an example to modify.

I'll also be adding some options for display formating for those who don't want to modify the template yet want to make some minor style changes.

ETA: Late tonight, early tomorrow (Pacific Standard Time).

[djjeffa]

yeah this slows down my site also, i've uninstalled it.
anybody else have this problem

[hambil]

It should not have much of an impact on the load times, but, I think I have a solution for this that will also be in this upcoming release. Right now, the stats are realtime. Meaning - every post effects them as soon as someone refreshes. This adds a couple queries to forum home.

I'm putting in a 'delayed' options, where you can set the number of minutes. If set to 0 it's basically the same as realtime. However, if set to 10 for example, then the trends data would only change every ten minutes, and use much less resources.

[tobias_t]

The problem I am having with this is, if I choose to only display positive trends, it doesn't even show the absolute numbers for threads, members, posts unless the trends for them are positive, which is effectively crippling the display. Is that a bug on my end or just how this mod works?

Also, it would be very helpful having the option to limit viewing rights of the trend numbers to a certain user group. Any easy code change that would make this possible?

Thanks, Tobias

[hambil]

The problem I am having with this is, if I choose to only display positive trends, it doesn't even show the absolute numbers for threads, members, posts unless the trends for them are positive, which is effectively crippling the display. Is that a bug on my end or just how this mod works?

Also, it would be very helpful having the option to limit viewing rights of the trend numbers to a certain user group. Any easy code change that would make this possible?

Thanks, Tobias
Hmmm, I guess it's a bug now that I think about it. A template fix anyway. I'll add it to the upcoming release. Group permissions is a good idea too, I'll add that.

[hambil]

The latest update is complete as promised. I hope you enjoy and it solves the problems some of you are having.

[voteforbird]

Hmm… After updating to the latest one, nothing's showing: http://www.volconvo.com

[Deadly Assassin]

Installed Thanks

Just a few things..

1. The newest member in the stats is not actually the last member to join up, will this update?

2. The % has no number next to it, will this update aswell?

3. In the forumhome template for this, how do i change the colours and make the 'Active member' bold etc...
I am a bit of a newbie a this so any help would be appreciated.

Great hack though :up:

[hambil]

Hmm? After updating to the latest one, nothing's showing: http://www.volconvo.com
You're using a custom template, so it autoreplace likely isn't working. Turn it off in the admincp options for vbtrends, and make the manual template edits as suggested in the install.htm file.

[hambil]

Installed Thanks

Just a few things..

1. The newest member in the stats is not actually the last member to join up, will this update?

2. The % has no number next to it, will this update aswell?

3. In the forumhome template for this, how do i change the colours and make the 'Active member' bold etc...
I am a bit of a newbie a this so any help would be appreciated.

Great hack though :up:
I can't tell by looking at the forum. I'll need an admin login. If you are okay with that then send my a pm.

[loonytune15]

Can you repost v1.2.6?

I dont particularly want to swich to the beta until its no longer a beta. And I missed the 1.2.6 update :(

[user02934123123]

I upgraded to the newest release today, which has caused the whole mod to cease to work.

On attempting to use auto-replace, as I did with the previous version, no vbTrend stats appear on the page.

On switching off auto-replace and modifying FORUMHOME as instructed in the installation guide, the vB stats box simply appears emply, with all contents removed. (And before this be asked: yes, the vbTrends mod is enabled from its options/settings screen in AdminCP.)

As such, the new release of the mod does not appear to work on my system at all, whereas the previous worked fine.

Any fixes?

[ncweb]

It should not have much of an impact on the load times, but, I think I have a solution for this that will also be in this upcoming release. Right now, the stats are realtime. Meaning - every post effects them as soon as someone refreshes. This adds a couple queries to forum home.

I'm putting in a 'delayed' options, where you can set the number of minutes. If set to 0 it's basically the same as realtime. However, if set to 10 for example, then the trends data would only change every ten minutes, and use much less resources.


The option to choose when the trends data is pulled will put this at the very top of my 'favorite hacks' list.

--will test new version later, hope to see it out of beta soon!

Thanks Mark, keep it up :)

[Deadly Assassin]

I can't tell by looking at the forum. I'll need an admin login. If you are okay with that then send my a pm.

PM Sent, thanks

:D

[hambil]

PM Sent, thanks

:D
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.

[hambil]

I upgraded to the newest release today, which has caused the whole mod to cease to work.

On attempting to use auto-replace, as I did with the previous version, no vbTrend stats appear on the page.

On switching off auto-replace and modifying FORUMHOME as instructed in the installation guide, the vB stats box simply appears emply, with all contents removed. (And before this be asked: yes, the vbTrends mod is enabled from its options/settings screen in AdminCP.)

As such, the new release of the mod does not appear to work on my system at all, whereas the previous worked fine.

Any fixes?
Try a full uninstall and reinstall of vbTrends from the latest zip, making sure to reupload all files. If the auto-replace used to work it should still work. I recommend reverting the FORUMHOME template as that can't be the problem.

[hambil]

My bad - and interesting note for those using export (from advanced product manager) to create their product.xml files: The template is not exported properly. Even though I've updated the template on the site, the old version is still the one exported. I had to manually edit the product.xml file. The new zip file I just posted has the correct template. I recommend a full uninstall/reinstall of vbTrends.

[KingPin6]

I was on 1.2.5 upgraded 2.0.0 but couldn't get the trends to work... tried uninstalling and reinstalling about 3 times with same results. I finally went into the user groups and saw that it was in fact set to yes for viewing trends but I still couldn't see anything on the front page, but once I clicked save on the user group it started showing up again. PS thanx for the great hack :)

[hambil]

but once I clicked save on the user group it started showing up again. PS thanx for the great hack :)

Interesting... I will look into this. Glad you got it to work.

[encryption]

I got the hack to work after having to uninstall / reinstall it entirely though I have a quick question - on my forum home it shows

Threads: 38,778, This Month: 4 (117%)

What is "This Month: 4" ?

I have set it to retrieve data from the last 2 months

[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.

[Deadly Assassin]

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. (http://www.7-zip.org/)

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

[encryption]

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]

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]

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.

[hambil]

How many queries does this mod do? I am trying to streamline my forum and disable query intensive mods.
It depends on your settings. If you leave it at the default settings it will add four small queries on each page refress, and three large queries once a day. If you change the delay setting in the admincp options to 10, it will do four small queries once every ten minutes. So it can be made very efficient, you just sacrifice some of the real-time nature is all.

[mcyates]

Newst members are the wrong way round but this is what it says.

Welcome to our newest 5 members, lastyearsman, borofan16, messi, NedvedShevchenko, foxy lady
Welcome to our newest member, foxy lady

When foxy lady was the 5th last person to join the forum. lastyearsman is the newest member.

Will this be fixed?

[hambil]

Newst members are the wrong way round but this is what it says.

Welcome to our newest 5 members, lastyearsman, borofan16, messi, NedvedShevchenko, foxy lady
Welcome to our newest member, foxy lady

When foxy lady was the 5th last person to join the forum. lastyearsman is the newest member.

Will this be fixed?
You've done some customization of the template, because in the default install newest member isn't shown anymore. It is replaced by newest x members. I recommend removing it. There is no reason to show both. Just set 'newest members' to 1 in the admincp options if that is what you want.

[zhabbo]

FANTASTIC! Thanks a bunch

[spazz191]

The same issue is back in the new version that you fixed in the old version...vbseo and my arcade link....what did you change to make it work before?

[hambil]

vbseo was screwing up the datastore, breaking the cache possibly? I moved everything to a cron job. But, I decided that is not a practical solution. I'd suggested taking it up with vbseo. I will see if I can remember/give you more details.

[subnet_rx]

Hmm, this update isn't working for me at all. When I first installed, I noticed that the trend stats were completely gone and replaced with my regular forum stats. I just went in and did a manual template update, and it just displays a blank box there now. I completely uninstalled and reinstalled, and I turned auto template edits off.

[hambil]

Okay, just an FYI to let you know 2.0.1 is in the works. It will add some minor, but useful updates, like:
1) Number formating (10,000 vs 10000)
2) If you make the manual template edit, disabling vbTrends will no longer leave the stats box empty - instead it will revert to use the original template.
3) Will attempt intelligent datastore unserialization - hope it helps with some of the problems a few of you have been having. vb made a real mess of this IMHO.

[hambil]

Hmm, this update isn't working for me at all. When I first installed, I noticed that the trend stats were completely gone and replaced with my regular forum stats. I just went in and did a manual template update, and it just displays a blank box there now. I completely uninstalled and reinstalled, and I turned auto template edits off.
Revert the FORUMHOME template - it auto-replace worked before it should still work. Then make sure you download the latest zip, even though the version hasn't changed a number of fixes have been done and uploaded. Then if a full uninstall/reinstall still doesn't fix things for you we'll see what the next step might be.

[subnet_rx]

Reverted the template, which got my original stats back, but nothing works to get the trends up. I did a full uninstall/reinstall after re-downloading the zip from here and it doesn't indicate any problems, it just doesn't show up on ForumHome.

[hambil]

Reverted the template, which got my original stats back, but nothing works to get the trends up. I did a full uninstall/reinstall after re-downloading the zip from here and it doesn't indicate any problems, it just doesn't show up on ForumHome.
Okay, well at least we have the original stats back. Now, let's see - if the manual template edit didn't work for you that means the code to fill that variable isn't getting reached. That's in the forumhome_complete hook. Someone isn't playing nice, so go into the vbTrends forumhome_complete hook and set the 'Execution Order' to 1. See if that helps.

[subnet_rx]

Hmm, still nothing. I checked to see if any other plugins were hooked at forumhome_complete and yours is the only one. I manually edited the template again, and got a blank. If no one else is having this problem, I can just go back to 1.2.6 and use it. I updated to get the "Changed template to still show total threads when trend is negative and 'positive trends only' is enabled."

[hambil]

Hmm, still nothing. I checked to see if any other plugins were hooked at forumhome_complete and yours is the only one. I manually edited the template again, and got a blank. If no one else is having this problem, I can just go back to 1.2.6 and use it. I updated to get the "Changed template to still show total threads when trend is negative and 'positive trends only' is enabled."
If you want to PM me a temp login, I'll see if I can find the problem.

[blastup]

i got blank on both mysites

[blastup]

when i manuelly edits it... but when with auto replace.. i just got the regular stats.. not the one with vbtrends..

[hambil]

when i manuelly edits it... but when with auto replace.. i just got the regular stats.. not the one with vbtrends..
If you want to PM me a temp login I'll see what I can do.

[blastup]

i just don't know what is wrong.. i tried on two sites..one with template edit.. one with out. the template edited one becomes blank.. and the other with autoreplace.. still remains the same stats.. not the vbtrends..

[hambil]

subnet_rx (https://vborg.vbsupport.ru/member.php?u=79879) and blastup (https://vborg.vbsupport.ru/member.php?u=187776):

There is an odd bug I don't quite understand yet, that was first reported by KingPin6 (https://vborg.vbsupport.ru/member.php?u=163048) in this (https://vborg.vbsupport.ru/showpost.php?p=1224840&postcount=127) post. Please try what he suggested (going into the usergroup and saving it), to see if that fixes the problem.

[tehPARADOX]

Also confirm trends no longer showing up, both auto and manual edits.

And when I tried doing permissions suggested by kingpin, received this database error:
MySQL Error : Unknown column 'vbtrends_permissions' in 'field list'

Uninstalled.

[hambil]

Uninstalled.
Good.

[hambil]

Alright, another bug squashed. Thanks for the help everyone. It would seem that a bug in the install sql was being hidden for a number of reasons, but the latest zip should correct that. You *must* do a complete uninstall and reinstall, as it appears the install code does't run on an overwrite.

[voteforbird]

You need to completely uninstall and then reinstall. Oddly, I did this and nothing happened, but the next day it was working. Perhaps it has to aggregate stats?

Also, the stats are a bit odd in that it seems to be comparing day X of the month to X amount of days in previous month, but since X doesn't change from daytime to nighttime, the % (and the arrows) move up throughout the day. At 12:00 AM, the %'s jump down again.

[hambil]

You need to completely uninstall and then reinstall. Oddly, I did this and nothing happened, but the next day it was working. Perhaps it has to aggregate stats?
See above update.


Also, the stats are a bit odd in that it seems to be comparing day X of the month to X amount of days in previous month, but since X doesn't change from daytime to nighttime, the % (and the arrows) move up throughout the day. At 12:00 AM, the %'s jump down again.
Yeah, that's an interesting issue. What I do is compare today against the average for today over the last x months. Of course as the day goes on the numbers will get better.

In order to compare literally minute to minute, I'd have to run the large 'avg' queries everytime I run the 'current' queries. However, that would make the stats more accurate. Perhaps I'll make that an options - it might be especially useful for people who are using a delay of several minutes or more anyway.

[goblues]

Had to update a usergroup to "activate" the mod but is working now. Thanks!

[Deadly Assassin]

In the Screeny, there are some green arrows, it doesnt show on mine?

I have left the board accessible :up:

[hambil]

That's because Firefox doesn't show red x's. Move the vbtrends gifs to your various skin image directories, and you're good to go.

[tobias_t]

Yeah, that's an interesting issue. What I do is compare today against the average for today over the last x months. Of course as the day goes on the numbers will get better.


Why don't you compare the previous, finished day instead of the present one? This should solve this problem.

[hambil]

Why don't you compare the previous, finished day instead of the present one? This should solve this problem.
The original inspiration for this hack was as a member motivator. I wanted my members to see the stats where down and post more and recruit more to get them up. In that light, I wanted it to change when they made a post or a thread or got someone to join. I wanted them to get positive feedback.

I still think that's a valuable thing and I want to keep the concept of quick positive feedback. However, I need to go think on this some.

[tobias_t]

The original inspiration for this hack was as a member motivator. I wanted my members to see the stats where down and post more and recruit more to get them up. In that light, I wanted it to change when they made a post or a thread or got someone to join. I wanted them to get positive feedback.


The idea of the mod is great, but I think there is much more value in it for admins and moderators than for members (which members care about the stats of a forum anyway?). So I would definitely suggest going for a readout that is probably less real-time but more valid overall.

Thanks for your efforts with this project!

[hambil]

(which members care about the stats of a forum anyway?)
You'd be surprised. On my boards they care very much. It's the same reason people like the store, and obsess over their time logged in or reputation or post count. Many people just love having things to play with as part of their community.

However, that said, since I've already added the delayed concept, tweaking it further makes perfect sense. This doesn't have to be an either/or thing.

[tobias_t]

However, that said, since I've already added the delayed concept, tweaking it further makes perfect sense. This doesn't have to be an either/or thing.

Sounds great. Frankly, I haven't come around to installing the new 2.0 version yet so I haven't looked at the current features, but...

what I think would be terrific: the option to set the stat to use either a single day, week or month as the accumulation timeframe; and also, having the option for different reference values that are being compared against, namely: previous day (week/month); same day (week/month) of the previous year, so you can filter out seasonal effects; as well as average day (week/month) starting from date x. Or maybe even having multiple reference values shown at once! Just a suggestion.

[hambil]

It is my dream to eventually have this hack support this (http://www.maani.us/charts/index.php?menu=Gallery) software, for some really nice trending and display capabilities. I was working on this a while back, but abandon it when I got sick. Perhaps now it will resurface.

[odie3]

Most likely have to put the gifs in your ambience/image/misc/ directory

[loonytune15]

hambil, thanks for sending me the v1.2.6 of this hack.

Hope you manage to work the rest of the bugs out of v2 :D

[AMG021]

Dude i just update my hack now and now its not working ! Please help me!

[hambil]

Dude i just update my hack now and now its not working ! Please help me!
Can you be more specific?

[AMG021]

What do you mean. Prior to your update It was working. I just downloaded it now and its not working at all. Look at the attachment

BTW I tried uninstalling it and reinstalling it. But nothing worked :(

[hambil]

What do you mean. Prior to your update It was working. I just downloaded it now and its not working at all. Look at the attachment

BTW I tried uninstalling it and reinstalling it. But nothing worked :(
Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.

[AMG021]

Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.
Ok that helped me thanks!

[voteforbird]

Wait, it's only comparing the X day of the month? I would think it should compare X amount of days in this month to X amount of days in past months ..

[hambil]

Wait, it's only comparing the X day of the month? I would think it should compare X amount of days in this month to X amount of days in past months ..
Yes, that is what it does.

[wolfe]

hi m8 is it possible to have the positive / negative arrow for the members mine always says 100%

also how do set the newest members to display in the colour i have set for there group. thx :P

[hambil]

hi m8 is it possible to have the positive / negative arrow for the members mine always says 100%

also how do set the newest members to display in the colour i have set for there group. thx :P
In most cases where I've seen 100% It's because the board is less than 2 months old and just doesn't have enough history to compare against. You can change the formula in the admincp if you'd like. By default it is round(($count / $avg) * 100). Change it to round(($count / $avg) * 100) - 100.

[wolfe]

In most cases where I've seen 100% It's because the board is less than 2 months old and just doesn't have enough history to compare against. You can change the formula in the admincp if you'd like. By default it is round(($count / $avg) * 100). Change it to round(($count / $avg) * 100) - 100.


m8 when i add

(($count / $avg) * 100) - 100 all the stas go to red DOWN

also what i ment was where it says active members is there anyway of putting an arrow.

also is it possible to make the stats stay at and under 100% i mean i got 115% posts theres no such percentage.

and my stats have just reset them selves ? whys that

[Deadly Assassin]

That's because Firefox doesn't show red x's. Move the vbtrends gifs to your various skin image directories, and you're good to go.

Fixed :up:

Great support, many thanks :D

[hambil]

m8 when i add

(($count / $avg) * 100) - 100 all the stas go to red DOWN

The don't put in the -100, or turn on 'positive trends only' in the admincp options. Or come up with an entirely new formula. The numbers are what they are - I just report them.


also what i ment was where it says active members is there anyway of putting an arrow.
Sure, you could edit the forumhome_vbtrends template. Of course, active members would never have a down arrow, it will always be between 0 and 100.


also is it possible to make the stats stay at and under 100% i mean i got 115% posts theres no such percentage.
Sure there is. 100% of 10 is 10. %120 of 10 is 12.

and my stats have just reset them selves ? whys thatIt's a new day. The stats track your progress over the day as compared to the previous x number of months.

[Terminatoronly]

its not working for me it doesnt show anything can u plz tell me what to do????

[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.

[Terminatoronly]

Ok Its Working Now :)

[djjeffa]

Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.
I upgraded and dont see this option in user group
any ideal why?

[hambil]

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]

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]

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]

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]

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!

[Daky]

I have no idea.


it wont i am using both.

www.diskusije.net

[dbirosel]

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]

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 :o

[hambil]

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 :o
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]

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

$newusername = $member['username'];

And replace it with:

$newusername = fetch_musername($member);

[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

[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]

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]

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]

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

[foxfirediego]

issue, using PT-BR language it show me:
Membros Ativos: 396 (11327%)
T?picos: 1.778, Esse M?s: 57 (111%)
Mensagens: 10.342, Esse M?s: 468 (171%)
Membros: 3.496, Esse M?s: 24 (-86%)

but using english language looks correct:
Active Members: 396 (11%)
Threads: 1,778, This Month: 57 (111%)
Posts: 10,342, This Month: 468 (171%)
Members: 3,496, This Month: 24 (-86%)

[DieselMinded]

I wish to completely remove the Active Members: Line How do i do this?

BTW Just upgraded to 2.0.0 with VB ver. 3.6.6 So Far So Good

DM

[wolfe]

m8 is there anyway of making a positive / negative for the Active Members: 55 (89%) like if 89% drops then its red arrow neg or if it goes up its green pos ?

[tutusinghsohi]

sorry to be a pain, but i have a small problem...

when i replace
<div class="smallfont">
<div>
$vbphrase[threads]: $totalthreads,
$vbphrase[posts]: $totalposts,
$vbphrase[members]: $numbermembers<if condition="$show['activemembers']">,
<span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
</if>
</div>
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
</div>




with
<!-- vbTrends Start -->
$vbtrends_output
<!-- vbTrends End -->


nothing shows up...:(


please help...:D...:D

[Tearstone]

Unfortunately, I had to uninstall this mod because the arrows showed up as red "X"s (broken images) on one of the skins I was using. :(

[Doctor Death]

Can you please consider adding to this hack the preservation of formatting for usernames by usergroup? (HTML Usergroup Tags)

It would be useful to retain that formatting.

Thanks much!

Doc

[Brandon Sheley]

I Installed this and I updated the usergroups and everything worked great

now 1 day later and it's just blank. I don't believe anyone touched anything ?

any idea ???

thanks
-Brandon

[GuaRRand]

how does it do the math?

Active Members: 30 (36%)
Threads: 456, This Month: 27 (84%)
Posts: 9,978, This Month: 375 (61%)
Members: 84, This Month: 1 (0%)

I mean, what is the (%) behind the numbers?... the % of posts/threads made by active members or inactive?... or something else?

[loonytune15]

Is this mod still alive? I was waiting for it to come out of BETA, but nothing has happened since April..

[provedel]

Can you please consider adding to this hack a way to show the total number of posts deleted by our mods???

Thanks!