Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Septimus on August 08, 2008, 09:28:23 PM

Title: Bad stats
Post by: Septimus on August 08, 2008, 09:28:23 PM
Well I was upset with 2.0's way of counting guests and spiders in the most online, so I changed the code.

I also edited the database- the log_activity table. My most online table does not excede 19, but my stats claim "162". I have recounted forum totals and stats to no eval.

I'm not sure what to do....maybe I missed some part of the database where this info is kept?
Title: Re: Bad stats
Post by: Rumbaar on August 12, 2008, 05:03:14 AM
Well in the {prefix}log_activity table you need to find the entry that has '162' for it's most_on field. You might have to search for a few if it appears more than once in that table.
Title: Re: Bad stats
Post by: Septimus on August 13, 2008, 08:09:33 PM
I aligned by ammount and deleted anything above 20. It's still showing and the table does not have anywhere near 162 anymore lol.
Title: Re: Bad stats
Post by: Rumbaar on August 13, 2008, 08:29:20 PM
Ah you also need to alter the entries in the {prefix}settings table
mostOnline  'value'
mostDate 'value'
Title: Re: Bad stats
Post by: Septimus on August 13, 2008, 08:45:19 PM
Ahhh thank you!! Will do that now and get back to you :D.
Title: Re: Bad stats
Post by: Rumbaar on August 13, 2008, 08:51:16 PM
mostDate is in Unix time (http://en.wikipedia.org/wiki/Unix_time) FYI, so be sure to set it correctly if that's important as well.
Title: Re: Bad stats
Post by: Septimus on August 13, 2008, 08:59:01 PM
Looks like you're spot on....but I'm not sure how to do the date.

2008-07-25 is what I need
1205783567 is what I have which shows as Mon 17 March, 2008 EDT.. How do I know what date numbers I need?


Wow Rumbaar, thank you so much for that :D.