MyBB Community Forums

Full Version: clean online user stats
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
it seems my online stats are gone crazy so probably some stats may have been messed up.
how to clean the online user stats? (board statistics), is there a table to clear?

Thanks

M
Can you provide a screenshot of how it looks right now and a link to your board?
this is the stat taken today
http://oi42.tinypic.com/e1axi0.jpg
it shows 728 users online at the same time that is not correct.
How can i clear the stats and start again from scratch?

Thanks

M
Well that can be correct if they were too many bots and other visitors on your website.

Anyway, try running the following query in PHPMyAdmin:

UPDATE `mybb_datacache` SET `cache` = 'a:2:{s:8:"numusers";i:0;s:4:"time";i: 1261863381;}' WHERE `title` = 'mostonline'; 


If you are using a custom prefix instead of mybb_ then replace it in the query above before running it. By default it's mybb_
great thanks, how to get rid of bots?
What kind of bots are you referring to? SEO Bots or Spam bots?
not sure who they are, how can i find them?

ok that command seemed to have cleared the crazy stats (now it shows up 98) but i have noticed another stat is gone crazy probably due to the bot activities. Have a look:

http://oi43.tinypic.com/2nuu8f6.jpg

I'm sure the currect members are fine, not sure about the total users ( 3,648)

Thanks
There are some ways to block bots but they often mistakenly block SEO bots (Such as Google, Yahoo, and Bing). I wouldn't recommend blocking bots because SEO is important for every and any website, I doubt there even is a way to block bots from visiting your website.
ok np, thanks for the help, very helpful dude