• Welcome to Simple Machines Community Forum. Please login or sign up.
September 18, 2021, 09:32:41 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


Bad stats

Started by Septimus, August 08, 2008, 09:28:23 PM

Previous topic - Next topic

Septimus

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?

Rumbaar

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.
"An important reward for a job well done is a personal sense of worthwhile achievement."


[ Themes ]

Septimus

I aligned by ammount and deleted anything above 20. It's still showing and the table does not have anywhere near 162 anymore lol.

Rumbaar

Ah you also need to alter the entries in the {prefix}settings table
mostOnline  'value'
mostDate 'value'
"An important reward for a job well done is a personal sense of worthwhile achievement."


[ Themes ]

Septimus

Ahhh thank you!! Will do that now and get back to you :D.

Rumbaar

mostDate is in Unix time FYI, so be sure to set it correctly if that's important as well.
"An important reward for a job well done is a personal sense of worthwhile achievement."


[ Themes ]

Septimus

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.

Advertisement: