Reset most users online from the AdminCP

Description
Adds a link in your AdminCP under "vBulletin Options" to reset most users online.

Installation
- Upload "reset_maxloggedin.php" to your admincp folder
- Upload "cpnav_rmli.xml" to your includes/xml folder

(0.2) bug forgot to add table prefix

search keywords: most online users max members record

works with: beta 3, beta 4

[MrSDavidson]

Doesnt work for me...
Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
UPDATE datastore
SET data = 'a:2:{s:9:"maxonline";s:1:"0";s:13:"maxonlinedate" ;s:2:"10";}'
WHERE title = 'maxloggedin';

MySQL Error : Table 'db114720746.datastore' doesn't exist
Error Number : 1146
Date : Sunday, July 3rd 2005 @ 01:34:54 AM

[Dream]

interesting I don't see how you can not have a datastore table

is "db114720746." your vB tables prefix?

[Marco van Herwaarden]

No that would be his databasename. I guess he is using a prefix, and this is maybe not supported in that query?

[Marco van Herwaarden]

PHP Code:

$zero_sql = "UPDATE datastore 

replace by

PHP Code:

$zero_sql = "UPDATE " . TABLE_PREFIX . "datastore 

[Dream]

bah I forgot to add the table prefix to the query. updated thanks

[Marco van Herwaarden]

No problem, that is why i use a table prfix on my development forums.

[MrSDavidson]

*goes off to test*

[MrSDavidson]

Thanks You!! Works a charm now

[Kirk Y]

This may seem like a stupid question, but. What do you mean "reset" most users?