vbTrends 1.1.2 - An Enhanced Statistics Box on Forum Home

[hambil]

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

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 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_1.0.0.zip.
Unzip and follow instructions in install.html.

[steven s]

Am I missing a table?
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT AVG(MonthlyPostCount) AS 'PostCountAvg'
FROM
(
SELECT count(*) AS 'MonthlyPostCount'
FROM post
WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
)
AS posts;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) AS 'MonthlyPostCount'
FROM post
WHE
Error Number : 1064

[hambil]

Am I missing a table?
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT AVG(MonthlyPostCount) AS 'PostCountAvg'
FROM
(
SELECT count(*) AS 'MonthlyPostCount'
FROM post
WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
)
AS posts;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) AS 'MonthlyPostCount'
FROM post
WHE
Error Number : 1064

Ummm.. what version of SQL server?

[MThornback]

Same error here:


Invalid SQL:

SELECT AVG(MonthlyPostCount) AS 'PostCountAvg'
FROM
(
SELECT count(*) AS 'MonthlyPostCount'
FROM vb3_post
WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
)
AS posts;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) AS 'MonthlyPostCount'
FROM vb3_post

Error Number : 1064


SQL VEr #: 4.0.16

[steven s]

Guess I'll wait for 1.0.1. :)
I do like the concept.

[MThornback]

I fixed it up so that there is an error on line 60...thats as far as I can get it fixed so far....i'll keep picking...and see if I can help :)

[steven s]

Ummm.. what version of SQL server?
PHP 4.4.2
MySQL Version 4.0.25-standard

[hambil]

Subqueries aren't supported until version 4.1.
I'll see what I can do, but dudes you're MySQL is really showing it's age.

[MThornback]

Well...hopefully we're turfing this host soon...cause believe me...its age is showing in more ways than 1 :p

I got the first install too :) go team :p


Edit:
Fatal error: Call to a member function on a non-object in /forum/index.php(485) : eval()'d code on line 60

thats where I am....

[Omranic]

its a nice hack

but has a very bad issue
it consmes over 30 query :(

try to improve this hack by reduce database queries

[hambil]

Okay, I changed it to support older versions of MySQL now.

[hambil]

its a nice hack

but has a very bad issue
it consmes over 30 query :(

try to improve this hack by reduce database queries 30 queries? What are you drinking?

[DJ XtAzY]

im gonna test it out and see if i have the same query results

[hambil]

Keep in mind it runs a number of querys ONCE a day, the first time someone hits it, and stores the results in the datastore. I really don't think those count ;)

[wizardan]

Installed flawlessly.
MySQL 4.1.15.

Very cool hack, Hambil.
Thank you.

[DJ XtAzY]

heres my statistic

if i didnt enable vbtrend, the total amount of queries is 22
if i enabled vbtrend, the total amount of queries is 27
so i guess it boost just 5 queries... but i still love this hack =]

but how to those percentage works?

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?

[hambil]

heres my statistic

if i didnt enable vbtrend, the total amount of queries is 22
if i enabled vbtrend, the total amount of queries is 27
so i guess it boost just 5 queries... but i still love this hack =]

but how to those percentage works?

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?
Sould be 4 queries, but the implementation of the datastore is flawed, and mostly useless for hooks. I've started a thread on vb.com about it.

[hambil]

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?
Maybe, let me check my math.

[MThornback]

Okay, I changed it to support older versions of MySQL now.

Your a gentleman and a scholar :) thank you from me and my users!

[hambil]

Okay, I think I got it this time. Changing the queries through me off for a bit, but the numbers look right again. Updated.

[steven s]

Okay, I changed it to support older versions of MySQL now.
Cool. :banana:

Edit: What if I wanted
Threads: 7,500, This Month: 286 Up (286%), Posts: 64,365, This Month: 2724 Up (2724%), Members: 2,787, This Month: 74 Up (0%)
to be one one line?

[DementedMindz]

any plans to make this html complaint?

[hambil]

any plans to make this html complaint?
I don't understand the question...

[hambil]

Cool. :banana:

Edit: What if I wanted
Threads: 7,500, This Month: 286 Up (286%), Posts: 64,365, This Month: 2724 Up (2724%), Members: 2,787, This Month: 74 Up (0%)
to be one one line?
Hmmm... I'll build a template for version 1.1.0, might get it out later tonight or early tomorrow.

[DementedMindz]

any plans to make it 100% html complaint (XHTML 1.0 Transitional) it gives Failed validation, 26 errors check on http://validator.w3.org/ it will show the errors i was 100% complaint before it..

[DementedMindz]

also just wondering if it should say Welcome our newest 5 members instead of Welcome to our newest 5 members

[hambil]

also just wondering if it should say Welcome our newest 5 members instead of Welcome to our newest 5 members
It's fully phrased, you can change that.

[DementedMindz]

what about the 100% html complaint (XHTML 1.0 Transitional) issues? will they be fixed in the next one or no?

[hambil]

what about the 100% html complaint (XHTML 1.0 Transitional) issues? will they be fixed in the next one or no?
Yes. Thank for the validation link.

[DementedMindz]

no problem... this would be great if they were fixed.... good job on the work

[yinyang]

also just wondering if it should say Welcome our newest 5 members instead of Welcome to our newest 5 members

both are correct.

1) Welcome our newest 5 members. - this is a suggestion... meaning you should go and welcome them... i.e, send them a PM or post and say hi... Welcome them!

2) Welcome to our newest 5 members. - this just basically means, "Hi 5 new members courtesy of the forum."

[hambil]

Fixed the calculation of the statistics - I truly believe it is correct now. Let me know if you find anything suspicious.

[MThornback]

Looks more accurate to me....but now that its not lying to me its depressing :p

[hambil]

Looks more accurate to me....but now that its not lying to me its depressing :p
Think of it as more... motivating ;)

[dirtycrow]

Fixed the calculation of the statistics - I truly believe it is correct now. Let me know if you find anything suspicious.
hmmm. . .i just upgraded from 1.1.0 to 1.1.1 and now the stats read as

Threads: 24,713, This Month: 821 (3058%)
Posts: 425,195, This Month: 10808 (8832%)
Members: 1,004, This Month: 25 (2400%)

looks a little suspicious to me. adivce? thank you very much :)

[hambil]

hmmm. . .i just upgraded from 1.1.0 to 1.1.1 and now the stats read as



looks a little suspicious to me. adivce? thank you very much :)
Clear the datastore vbtrends variable. Erm... maybe I should provide a button for that.

[DJ XtAzY]

Clear the datastore vbtrends variable. Erm... maybe I should provide a button for that.

how do u do that?

[ryancooper]

30 queries? What are you drinking?


How do you get to see the querys?

[steven s]

Clear the datastore vbtrends variable. Erm... maybe I should provide a button for that.

Using v1.1.1
Active Members: 322
Threads: 7,508, This Month: 295 (29400%)
Posts: 64,424, This Month: 2784 (278300%)
Members: 2,787, This Month: 74 (-84%)

Guess I'll wait to find how to clear the variable too.
Or do I just need to wait 24 hours?

[PabloAM]

INstalled perfect ;)

[DementedMindz]

Uncached templates: forumhome_vbtrends (1)
Uncached templates: forumhome_vbtrends_newmember_bit (5)

i didnt do the template edit i wonder if thats why?

Edit: never mind i fixed it... sorry and 100 % complaint nice work...

[wizardan]

Statistics now reflect accurate numbers.
*upgraded*:)

[hambil]

Updated again, now you can reset your counters if needed.

[steven s]

Updated again, now you can reset your counters if needed.
Sorry, but where?
I still only have 3 settings to change.

Thanks for all your hard work and support.

[hambil]

Sorry, but where?
I still only have 3 settings to change.

Thanks for all your hard work and support.
Make sure you upload all the files (there are new files).

Then you should see a new admincp menu.

[Robru]

Active Members: 0
Threads: 22,556, Deze maand: 2647 (394%)
Posts: 73,316, Deze maand: 7601 (329%)
Members: 815, Deze maand: 105 (450%)

Active Members: 0 !! How is that possible?

[hambil]

Active Members: 0
Threads: 22,556, Deze maand: 2647 (394%)
Posts: 73,316, Deze maand: 7601 (329%)
Members: 815, Deze maand: 105 (450%)

Active Members: 0 !! How is that possible?
This hack doesn't really do anything with active members. I bet if you disable it you'll still see Active Members: 0.

[Robru]

Thanks, I'll disabled it ... :)

[hambil]

Thanks, I'll disabled it ... :)
Actually, I was half wrong. The template I wrote wasn't respecting the $show['activemembers'] setting. Fixed now. Grab and reinstall over the existing one (make sure to set allow overwrite to yes on import).

[steven s]

Make sure you upload all the files (there are new files).

Then you should see a new admincp menu.
My bad. Sorry.
Looking better, thanks.
Now one last thing (for now)
How do I get rid of the previous settings area under vBulletin Options.

[hambil]

My bad. Sorry.
Looking better, thanks.
Now one last thing (for now)
How do I get rid of the previous settings area under vBulletin Options.
It doesn't work that way. The settings area under vBulletin Options is the correct place for a hack's settings. The settings choice I put on the admincp menu is just a short cut to the same screen you'd get if you went through vBulletin Options.

[SweetHome]

thanks

[Robru]

Actually, I was half wrong. The template I wrote wasn't respecting the $show['activemembers'] setting. Fixed now. Grab and reinstall over the existing one (make sure to set allow overwrite to yes on import).
Are you sure you updated the last one? I don't get the rule Active Members anymore with the last grab, en yes I allow overwrite on import ...

Threads: 22,556, This Month: 2647 (394%)
Posts: 73,321, This Month: 7606 (330%)
Members: 815, This Month: 105 (450%)

[hambil]

Are you sure you updated the last one? I don't get the rule Active Members anymore with the last grab, en yes I allow overwrite on import ...

Threads: 22,556, This Month: 2647 (394%)
Posts: 73,321, This Month: 7606 (330%)
Members: 815, This Month: 105 (450%)
Active members is a vBulletin feature, not part of my hack. All I do is respect the settings you set in vBulletin Options under "Forums Home Page Options".

[bashy]

Looks like its all working fine at Bashy's Place ;)
Cheers m8 great looking hack ya made..... Now why the dlckens is my arrows red :( pmsl...

Bashy's Place Statistics
Threads: 3,184, This Month: 439 (-21%)
Posts: 7,567, This Month: 807 (-40%)
Members: 572, This Month: 40 (-62%)
Welcome to our newest 5 members, huggybear, Sherlock Holmes, royallady, arbnuh, TheH1dden
Thanks to our latest contributing members:
Total VIP's: 11
Check out our latest addition to the arcade, Cub Shoot 3

[snakes1100]

bashy, what don't you have installed on your site.... :D

[hotwheels]

I just installed the program and it is working flawlessly.......I do have a question though, what are the %'s based on average wise? Monthly statistic's or a time since the board opened stats?

I had 40 new member's this month and it say's that i am Threads: 4,727, This Month: 235 (-53%)
Posts: 46,389, This Month: 1624 (-67%)
Members: 596, This Month: 40 (-35%)


Just curious

[Gizmo5h1t3]

it says in the initial post mate...i think its compared to the board AVERAGE number of threads and posts....

Shows trends for posts, threads and new users - this month vs. the boards average.

[hambil]

it says in the initial post mate...i think its compared to the board AVERAGE number of threads and posts....
It's also month to date. So it's comparing the months so far (through the 19th) against the board average for the first 19 days of the month. That's why it has to run the extended queries once a day.

[rex_b]

How does one alter the layout of the output. I have my stats in a small box on a sidebar and this current layout doesn't look right in my small box.

[hambil]

How does one alter the layout of the output. I have my stats in a small box on a sidebar and this current layout doesn't look right in my small box.
There are two templates: forumhome_vbtrends and forumhome_vbtrends_newmembers_bit.

[rex_b]

OK I will see what I can come up with.. hehe

[username12]

Easy install, though I can't for the life of me figure out how the percentages work.

[hambil]

Easy install, though I can't for the life of me figure out how the percentages work.

Let me give an example. Let's say you openned your board on Dec 20th. You current post count average would be:

(January 1st - 19th + February 1st - 19th + March 1st - 19th) / 3

Let's use some numbers to make it easier:
(50 + 210 + 315) / 3 = 191.67

Okay, so we have your boards "Month to date" post count average, now compare it to this month: April 1st - 19th - let's say we have 392 posts so far this month.
(392 / 191.67) * 100 = 205.23
Which we round to 205.

This number is the percentage of the orginial, not the percentage increase. In other words, 392 is 205% of 191, but we don't have a 205% increase, because 191 represents 100%. So, we do a tiny bit more math.
205 - 100 = 105%
Your board has an increase of 105% in posts over the average this month so far!

That's how it works.

[Omranic]

30 queries? What are you drinking?
I Drink water
& some times schweppes :)

as I said
30+ query

our server is down now
when it it up i'll shot the screen & let you see :D

:|

[pspcrazy]

anyway so that admins can only see this?

[Omranic]

Now see with your eyes :rolleyes:


without vbTrends 1.0.0 (product Enabled)
https://vborg.vbsupport.ru/


with vbTrends 1.0.0 (product Disabled)
https://vborg.vbsupport.ru/external/2006/04/11.gif

:banana:

what you say for that ?
41 Query

[hambil]

Now see with your eyes :rolleyes:


without vbTrends 1.0.0 (product Enabled)
http://phpkd.com/vb/uploaded/2006/userfiles/1/1145511338.gif


with vbTrends 1.0.0 (product Disabled)
http://phpkd.com/vb/uploaded/2006/userfiles/1/1145511351.gif

:banana:

what you say for that ?
41 Query
Um, I say that's more than a bit odd. Is that the first run where it does the extra once a day queries, or every run?

I'd also say, upgrade ;)

[Omranic]

every run
every run
every run
:(

I'll Upgrade & see what will happen


------------------------

EDIT
after uninstalling the old version & installing the new one I Get 49 query for the first run & 46 Query every run

[hambil]

every run
every run
every run
:(

I'll Upgrade & see what will happen


------------------------

EDIT
after uninstalling the old version & installing the new one I Get 49 query for the first run & 46 Query every run
I can assure you the hack only runs 5 queries. You have another hack that must have hooks into something I am doing.

[Omranic]

may be
but the stange thing is that this huge number of queries doesn't appear when vbtrends is disabled

while all other hacks are working fine with or without vbtrends & with only 9 quries @ forumhome

[hambil]

may be
but the stange thing is that this huge number of queries doesn't appear when vbtrends is disabled

while all other hacks are working fine with or without vbtrends & with only 9 quries @ forumhome
Again, it's only a guess, but if one of the other hacks has a hook that is being triggered by something in my hack, that would explain it.

[Omranic]

Ok
I gave the hooks a look & found that nothing active @ forumhome_start / forumhome_complete / global_complete exept vbtrends

[username12]

I tried figuring it out mathematically but didn't get numbers resembling what I was getting. Granted, my board's been open for 7 years, but the oldest post is from 2004, so the numbers would be skewed regardless. I think I'll just leave the percentages out, though I like the numbers themselves.

[hambil]

I tried figuring it out mathematically but didn't get numbers resembling what I was getting. Granted, my board's been open for 7 years, but the oldest post is from 2004, so the numbers would be skewed regardless. I think I'll just leave the percentages out, though I like the numbers themselves.
I will recheck my forumals.

[hambil]

Ok
I gave the hooks a look & found that nothing active @ forumhome_start / forumhome_complete / global_complete exept vbtrends
There are only eight queries max in the hack. I've looked carefully and I can't see any way to ever get more then eight queries run with this hack. Something must be going on specific to your setup.

[Morrighan256]

For some reason, my birthdays and current events disappeared on the forum home when I did this. I didn't think I pasted over any code that wasn't supposed to be replaced, but is that what I did? I can't figure out what else it might be. The statistics show up fine, but the birthdays and calender events are gone.

http://www.cipher-wotr.com/forum/index.php

[hambil]

For some reason, my birthdays and current events disappeared on the forum home when I did this. I didn't think I pasted over any code that wasn't supposed to be replaced, but is that what I did? I can't figure out what else it might be. The statistics show up fine, but the birthdays and calender events are gone.

http://www.cipher-wotr.com/forum/index.php
It's possible. You can check the template history to see what you changed.

[Morrighan256]

<a href="http://img.photobucket.com/albums/v619/Morrighan256/Image2.jpg" target="_blank">http://img.photobucket.com/albums/v6...256/Image2.jpg</a>

That's what I've got--I didn't paste over anything. Now I'm really confused.

[hambil]

http://img.photobucket.com/albums/v619/Morrighan256/Image2.jpg

That's what I've got--I didn't paste over anything. Now I'm really confused.
Something funny is going on. I'm looking into it :)

[hambil]

http://img.photobucket.com/albums/v619/Morrighan256/Image2.jpg

That's what I've got--I didn't paste over anything. Now I'm really confused.
Okay, I one by one turned off every hack I had and reverted all my templates, and still no birthdays. I then checked to make sure somebody was having a birthday, and it showed four in the calendar. Then I changed my birthday to today, and finally the birthdays displayed (all of them). There is a bug alright, but it looks like it is in vb itself having to do with the active users and birthday settings.

Edit:
It appears confirmed that there is a birthday bug in vb.
http://www.vbulletin.com/forum/showthread.php?t=172384&highlight=birthday+bug
http://www.vbulletin.com/forum/showthread.php?t=165560&highlight=birthday+bug

[Morrighan256]

Well, as my forum is still closed to the public while I fiddle with everything, it's not a big deal, and thank you for looking into it. I'll keep an eye on this thread for whatever solution. ;)

[criscokid]

This mod looks great - I installed it diring the middle of last month. Today's the first of the month and unfortunately it's just red arrows pointing down. I know why the arrows are pointing down but new visitors to my site probably won't realise why and it may put them off signing up. Is there anyway to disable the red arrows and only have green arrows show (when the stats are on the increase to show positive growth)?

[Morrighan256]

Okay, the problem was that if there aren't any events or birthdays coming up, the box disappears. Problem solved.

[hambil]

This mod looks great - I installed it diring the middle of last month. Today's the first of the month and unfortunately it's just red arrows pointing down. I know why the arrows are pointing down but new visitors to my site probably won't realise why and it may put them off signing up. Is there anyway to disable the red arrows and only have green arrows show (when the stats are on the increase to show positive growth)?
vbTrends 2.0 is well underway, and it will address this issue. :)

[criscokid]

vbTrends 2.0 is well underway, and it will address this issue. :)
Cool! - something nice to look forward to :) :)

[hambil]

A very preliminary screen shot of the chart designer for 2.0.0.

It's ajax - the preview chart reflects your changes in real time.

[criscokid]

What would be great would be the ability maybe exclude a forum from these new stats - I use vbPortal and have a specified forum where the threads in that forum create the news stories for the front page of the portal.

[hambil]

What would be great would be the ability maybe exclude a forum from these new stats - I use vbPortal and have a specified forum where the threads in that forum create the news stories for the front page of the portal.
You can. That's what the match box does. Here's an example:

[hambil]

This mod looks great - I installed it diring the middle of last month.
Thanks :) How about clicking install?

[TTG]

This mod looks great - I installed it diring the middle of last month. Today's the first of the month and unfortunately it's just red arrows pointing down. I know why the arrows are pointing down but new visitors to my site probably won't realise why and it may put them off signing up. Is there anyway to disable the red arrows and only have green arrows show (when the stats are on the increase to show positive growth)?

I thought the same thing .. hope you don't mind hambil, but I removed the up / down arrows and kept the stats.
Look forward to using vbTrends 2.0

[wizardan]

vbTrends 2.0 is well underwayAwesome.

[El-Gazaly]

thnks
installed

[phkk]

good work.

[Dr.Viggy]

nice hack

*installed

[Ricky6039]

Thanks alot

[bashy]

Hi

Is there anyway to reduce the 5 queries that this uses please?

[hambil]

Hi

Is there anyway to reduce the 5 queries that this uses please?
If I can get time free to finish 2.0 it uses a cron job and adds zero queries to forum home...

[bashy]

Thanks for the quick respnse m8 :)
Will look forward to v 2.0 :) Thanks

[Ski-Whiz]

hambil,

I like this hack!! However come the 1st, all arrows are red, and indicate a slow board. It was also mentioned in this thread by someone else.

Is there maybe a way to allow for owners to install this, and display the past 30 days (or X days), vice "this month"?? I think people might like to see that. Showing any signs of a declining status is bad when new members come.

Just a thought... Allowing the past x days vice this month, might be something people would like.

[hambil]

hambil,

I like this hack!! However come the 1st, all arrows are red, and indicate a slow board. It was also mentioned in this thread by someone else.

Is there maybe a way to allow for owners to install this, and display the past 30 days (or X days), vice "this month"?? I think people might like to see that. Showing any signs of a declining status is bad when new members come.

Just a thought... Allowing the past x days vice this month, might be something people would like.
It's a good idea. I've been meaning to change this, but haven't found the time yet. Hopefully very soon.

[Stangsta]

I put a conditional in my template to only show it to mods and admins, and the regular users see the default stats.

Gotta love it.

[TheBlackPoet]

i love it!! i have my super moderators something to reach for... if the trends are down.... GREAT JOB!

[The Chief]

works like a charm!

/me clicks install!

[CodeRed]

looks cool...

by chance maybe a future release can include the ability to have it turned on for only certains usergroups... like the admins for example.

[Guest210212002]

/me clicks install

[curriertech]

What are the chances of this being updated for 3.6?

EDIT: This seems to work just fine in 3.6 :)

[hambil]

Thanks :) I haven't gotten to 3.6 updates yet. I hope to get all my hacks moved this week.

[curriertech]

Just an FYI for if/when you update for 3.6, the "month to date" calculation doesn't seem to be working (today is sept. 1 and it now says my stats are down 100%).

:cool:

[G_Man]

Thanks :) I haven't gotten to 3.6 updates yet. I hope to get all my hacks moved this week.


Looks GREAT! Gonna click install so I'll get an email when you update this for 3.6

Cheers,
G.

[KevNJ]

Any further on getting this to work with 3.6. Hambil ?

[KevNJ]

another bump

[Lionel]

We need some optimization for 3.60. I just disabled this plugin after 2 weeks. My homepage went from 6.50 seconds to open to 0.75 second

[KevNJ]

Any further on getting this to work with 3.6. Hambil ?

[Zowners]

I just installed in on 3.6 with no problems..

[Smitty]

I did too, just now, but all the trends are down when I know, according to the board history and admin stats, are going up. I'll have to read through the whole thread. I LIKE the idea.

[MThornback]

I can't get it working on a PHP5 server.....I thought it was just me....but its definatly causing a session error :(

[Cheertobi]

I use it on a PHP5 server!

[MThornback]

Did you tweak it at all?

[Smitty]

Just an FYI for if/when you update for 3.6, the "month to date" calculation doesn't seem to be working (today is sept. 1 and it now says my stats are down 100%).

:cool:

I'm on vB 3.6.4. I have this installed and I like it, all in all, but the name is mis-leading if I understand how the numbers are calculated. It doesn't actually show the true trend until the last day in any given month. So, 12 times a year you can see what the trend for the month is at the end of the last day in a given month. At the start of each month all the trends will appear to be down because it's comparing that day (e.g. February 1st) against the average of all months since the board was installed. On February 2nd it will still show a 'down' trend because it's using (<Feb 1> + Feb 2>) / <Average of All Months>

And the 'trend' will continue to be down until the number of (for example) New Members for the month reaches the average derived by <Total Members> / <Total Months Forum Installed>. This is, of course, assuming that the <number for the month> does, in fact, reach a point where it is more than <average of all months>. If the <number for the month> is lower than <average of all months> on the last day in the month you truly do have a negative trend.

By all means correct me if I'm wrong, but I think that's how the hack works.

BTW - I'd like to know where it pulls the date from that it uses to define the date the board was installed. For example, I put my forum online during August 2001. But - I imported threads from my old 'board' which used UltimateBBS, and therefore my board has posts going back to June 1998 (3 years before I installed vBulletin.

I use it on a PHP5 server!

I also have it on a PHP5 server.

[StarBuG]

Hi

I just wanted to report the same thing as Smitty.

In your explanation example here (https://vborg.vbsupport.ru/showpost.php?p=954678&postcount=64)
you say:

(January 1st - 19th + February 1st - 19th + March 1st - 19th) / 3


But this can't be how it is calculated because my trends are all negative.

Example new threads:

this month from 1-7th February: 137
1-7th January: 81
1-7th December: 91
1-7h October: 18
all before are the same around 30-90

My stats show:
Active Users: 86
Threads: 1.658, This Month: 137 (-19%)
Posts: 9.458, This Month: 679 (-30%)
Users: 357, This Month: 5 (-87%)

There defenetly is something wrong and it doesn't look good if a growing forum has negative trends in their stats so I had to deactivate it.

I really like the Idea and hope this is fixed soon.

Your idea for the calculation you used in your example would work perfectly.

StarBuG

[StarBuG]

Hello?

Any chance that this hack is still supported?

[Smitty]

But this can't be how it is calculated because my trends are all negative.

The key is it does not relate to a true trend. The only way it could do that is if it went by a comparison to the average for the specific day in the month.

What this does do, and it's OK with me, is compare a given day in a month with the total monthly average. On my forum I put in a 'header' that reads: "'Trend' Numbers = Total 'New' so far this month compared to Monthly Average". I would have been more accurate, but it would have taken up too much room, if I had said: "'Trend' Numbers = Total 'New' so far this month compared to Monthly Average over the life time of the forum".

In my case it's even trickier because I started using vBulletin in August of 2001 and imported threads from UltimateBB going back to June of 1998. I also looked at my vBulletin stats in the admin control panel and somewhere along the way the stats got screwed up so according to the vBulletin admin panel my stats are only good from about March of 2003. That said I'm not sure how this hack computes the numbers, so on my board I look at the number as a 'relative' number.

[hambil]

Hello?

Any chance that this hack is still supported?
On Dec. 2nd I had a heart-attack. I'm still recovering, but doing much better lately. I plan to get back to my hacks soon. Thank you for your continued patience.

[Chicago_VLNU_4s]

hmmmmm, the images are uploaded into the right directory, but they're coming up as a broken image. Yes, the image names and paths are 100% correct.

[hambil]

Odd. Are you sure it's not a browser cache issue?

[Fulla]

Im not sure what to do with the icons?
Where do I upload them?

[hambil]

Im not sure what to do with the icons?
Where do I upload them?
images/misc

[Fulla]

Sorry bout this,

I'm pretty sure ive checked everywhere within vbulletin.
Cant find images/misc.

Under what 'heading' is it?

[hambil]

It's on your ftp, under your forum root. e.g. /public_html/forum/images/misc/

[westpac]

wow thanks makes my site own warez-ds.net if u wanna see peoeple it owns!!!! i love it thnaks so much