Advertisement:

Author Topic: Bad stats  (Read 3567 times)

Offline Septimus

  • Semi-Newbie
  • *
  • Posts: 77
Bad stats
« 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?

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,806
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: Bad stats
« Reply #1 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.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Offline Septimus

  • Semi-Newbie
  • *
  • Posts: 77
Re: Bad stats
« Reply #2 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.

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,806
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: Bad stats
« Reply #3 on: August 13, 2008, 08:29:20 PM »
Ah you also need to alter the entries in the {prefix}settings table
Code: [Select]
mostOnline  'value'
mostDate 'value'
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Offline Septimus

  • Semi-Newbie
  • *
  • Posts: 77
Re: Bad stats
« Reply #4 on: August 13, 2008, 08:45:19 PM »
Ahhh thank you!! Will do that now and get back to you :D.

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,806
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: Bad stats
« Reply #5 on: August 13, 2008, 08:51:16 PM »
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 ]

Offline Septimus

  • Semi-Newbie
  • *
  • Posts: 77
Re: Bad stats
« Reply #6 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.