UBB.Developers Forums UBB.threads 7 Development How Do I? Reset "Max users online"

How can I reset this? I played around with the "time" setting on the who's online page, but would like to "reset" the number as I changed the time period back to 10 minutes.

Oh, forgot...6.4

DELETE FROM w3t_Cache

will dump all that cached data so it can start fresh.

Many thanks, as usual!

Ok, now it's constantly clearing the cache, as the "Max Users Online" now reflects the number of users currently onlline.

Just running "DELETE FROM w3t_Cache" would only reset it one time, so there is no way that could constantly reset it.

You might be getting a new "MAX" users online every so often now instead of having a maxxed amount showing.

Linkage to the site?

The link to his board is:
http://www.yenko.net/ubbthreads/ubbthreads.php?Cat=
I have observed this behaviour by following the link in his profile. Example below.

There are 18 registered and 21 anonymous users online.
Max users online was 39 @ 02/12/04 04:45 PM
There are 17 registered and 21 anonymous users online.
Max users online was 38 @ 02/12/04 04:46 PM

Unfortunately, this thread is beyond me.

I had 80 and 90 users online last night AFTER I ran that SQL command, and if you watch the counter, it constantly resets itself. I'm pretty certain it's not in my mind!

Did you place the SQL command into the code? Or did you just run it from your Admin Panel ONE time?

If it is inserted into one of your PHP or .tmpl pages, remove it...

No, just ran it from the admin panel...

My bad - after we dump the cache - I guess we need an empty record there to update.

So we'd also need to do this:



Chevy, I did this on your site for you - so it should get back on track.

Josh to the rescue...AGAIN!

Thanks all!

Bad Josh. /me slaps Josh's hand. No No No, don't DELETE * FROM w3t_Cache. If you do that the Cache table will never get updated because it doesn't it's never INSERTed into, only UPDATED. /me smacks Josh one more time for good measure

You'll need to do this to reinsert a row into your cache table:

INSERT INTO w3t_Cache
(C_Users)
VALUES
('0')

For future reference you can reset your max online by running the following

UPDATE w3t_Cache SET C_MaxOnline='', C_Maxonline_timestamp=''


And for an FYI, 6.5 will have a tool to reset the cache.

Doh, you can't correct yourself before I get a chance to reprimand you. Bad Josh! /me beats the living tar outta Josh!

LOL

Yeah, I figured that out once I looked at it and realized it didn't recreate the entry automatically. Guess I was confusing it with IIP's cache where you can nuke it and it comes back on it's own.

Good news on a reset Cache option in 6.5.

That should be "beats the living .tar.gz outta Josh". LOL

LOL I didn't even catch the fact EVERYTHING was deleted either. Too much goofing with nuke.