Site Stats - month and year values

I hope somebody could help me on this.

I am so pissed off that the site stat "this month" and "this year" do not really represent the actual month and year from the calendar. I mean the values for this items does not really change at the end of the month nor the end of the year but is based from the time of dolphin installation valued for 30 days and 365 days. Thus, if you installed dolphin in about middle of the calendar month and about middle of the calendar year you'll be pissed that your values won't change i accordance to the actual calendar days.

Another year is coming so I need this to be figured out before new year. I need help to fix this quickly. Thank you very much.

Quote · 30 Dec 2010

They should.

Perhaps i am missing something or not understanding your question, but on my site i have new members each day and the stats for new members per day, month and year do appear to be accurate.

Make sure caching is off on the site stat block.

https://www.deanbassett.com
Quote · 30 Dec 2010

Hello Sir,

Before I say anything else, Happy New Year 2011 to you.

I just want you to see my site stats at http://www.atin2.com/tambayan/ you will notice it still shows old figures from previous month and year, i am expecting it should reset to zero (0) just right after 2010 passed. This is what I mean, I think these values will change only it reached 365 days from my time of installation and this what annoys me. My month and year should have reset to zero (0) since the calendar year ends already. Thank you.

Quote · 1 Jan 2011

Like Deano states, make sure the "cache" for the block is turned off, and clear your cache.

none

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 1 Jan 2011

Ok, My stats did not change after the change of the year, so i do believe this is a bug. Caching is not the issue.

This topic i believe should be moved to the bug forum.

https://www.deanbassett.com
Quote · 1 Jan 2011

Ok. I have determined that the count go by this.

For year. The number of new members registered within the last 365 days.

For month. The number of new members registed within the last 30 days.

For today. The number of people registerd within the last 24 hours.

This of course is not how it should be done.


For example, the count for year should be the number that registed after the start of the current year.


I will see if i can come up with some replacement stat queries to correct that.

https://www.deanbassett.com
Quote · 1 Jan 2011

These are 3 replacement queries for the site stats that provide accurate calender results.

Year
SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND DATE_FORMAT(`DateReg`,'%Y') = YEAR(NOW()) AND (`Couple`=0 OR `Couple`>`ID`)

Month
SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND DATE_FORMAT(`DateReg`,'%Y') = YEAR(NOW()) AND DATE_FORMAT(`DateReg`,'%c') = MONTH(NOW()) AND (`Couple`=0 OR `Couple`>`ID`)

Day
SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND DATE_FORMAT(`DateReg`,'%Y') = YEAR(NOW()) AND DATE_FORMAT(`DateReg`,'%c') = MONTH(NOW()) AND DATE_FORMAT(`DateReg`,'%e') = DAYOFMONTH(NOW()) AND (`Couple`=0 OR `Couple`>`ID`)


These can either be replaced using my Site Stat Manager module or doing it manually in the database. Keep a copy of the origional query in a text file just in case.


https://www.deanbassett.com
Quote · 1 Jan 2011

Great, manual db edit  works perfect on my 7.0.4 site.

thanks kindly

Quote · 1 Jan 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.