How to reset...

[jbizzle]

Is there anyway to reset the "Most users ever online" I messed something up and it shows there was about 3k users online at once... :erm:

[jbizzle]

bump

[Speysider]

AdminCP >> Maintenance >> Update Counters
Run the "Rebuild Stats" counter (not sure why it tells you that your whole forum will be deleted when it doesn't do that. Take precautionary measures and backup your database if need be.)

[borbole]

Is there anyway to reset the "Most users ever online" I messed something up and it shows there was about 3k users online at once... :erm:

To reset the most users online run this query at the phpmyadmin:

UPDATE datastore SET data = '' WHERE title = 'maxloggedin';

If your tables have prefix then you should include it at the query as well.

[Speysider]

Why is everything got to be queries?? There's counter updaters to do this.

[borbole]

Why is everything got to be queries?? There's counter updaters to do this.

The counter update doesn''t reset the most users online, that is why.

[Speysider]

I'll quote from the ACP help text:
Rebuild Statistics:
This feature rebuilds the information that is displayed on your Statistics page.
The stats page includes:
Top Statistics - Such as Newest member to the forums, Record online users etc.
Registration Statistics
User Activity Statistics
New Thread Statistics
New Post Statistics

[borbole]

I'll quote from the ACP help text:
Rebuild Statistics:
This feature rebuilds the information that is displayed on your Statistics page.
The stats page includes:

Please, read carefully the post of the OP. He/she wants to rest the most users online :)

[Speysider]

I did and pointed him to the right location (it would rebuild bad post stats at same time)
I know him and he's not good with SQL or queries.

[borbole]

I did and pointed him to the right location (it would rebuild bad post stats at same time)
I know him and he's not good with SQL or queries.

It doesn''t matter if he is not good with sql, all he needs to do is copy/paste/run the query that I posted above and he should be all set. Don''t worry about it.

P.s. You are not making much sense, what bad posts would have been rebuilt at the same time? He didn''t ask for anything like that. Or you can read minds :D

[Speysider]

Yep, I can read minds :)
Known the guy since he started his forum, I've had to help him with most things.

[jbizzle]

To reset the most users online run this query at the phpmyadmin:

UPDATE datastore SET data = '' WHERE title = 'maxloggedin';

If your tables have prefix then you should include it at the query as well.

Did this, thank you!

[borbole]

Did this, thank you!

You are welcome.