[Jhonnyf]

Originally Posted by Sym0n

Nope, well saying that depends on what you want to reset. If you wanted to reset the counter to 0 with todays date then yes a simple SQL query on datastore to change the value to 0 with todays date then the following:

UPDATE datastore SET data = 'a:4:{s:9:"maxonline";i:0;s:13:"maxonlinedate";i:1219276801;s:15:"maxvisitorsdate";i:1219276801;s:11:"maxvisitors";i:0;}

(I think, so double check it before you run it and don't blame me if it wrecks your DB lol)

However if you want to reset the max users online figure with a date in the past you'd need to change that query so that the bits in red fit your criteria. To calculate the date in unix time I've used this online calculator.

Anyway further details, written by someone who has a clue of what they are talking about, can be found HERE.

Sy

Thank you, but Paul have reason

Originally Posted by Paul M

Dont run that query as is, it will cause a lot of damage as it as it doesnt specifically reference the maxloggedin record, but even if it did - running it will wipe out other dates/values stored in that record.

Like I said, there is no easy way. Most things can be done if you have the knowledge and experience.

I thought that this value is inside a custom table and not inside a vBulletin table

But I remembered that one time this counter was restarted alone...