Reset most users online number.

[accyroy]

I'd like to reset this number as I think a spider totally messed it up as it is reading over 100 on line and the most i usually get is about 20-30..

[Steve Machol]

To reset this back to 0 in vB3, run this query:

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

[accyroy]

That worked a treat, thanks!

[Jimmy D. Giles]

That worked a treat, thanks!

Speaking of users online, I notice a 'wake' effect as I watch users online. That is, one IP appears to create multiple visitors?

[conqsoft]

Speaking of users online, I notice a 'wake' effect as I watch users online. That is, one IP appears to create multiple visitors?

More than one user can show up as being from one IP if they are behind a firewall/proxy.

[Don Z.]

To reset this back to 0 in vB3, run this query:

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

Steve, sorry to restart this old thread but when I run the query I get this error:

"An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'photopost.datastore' doesn't exist"

I'm running 3.0.0

Can you help?

[Steve Machol]

Run this script to fix your datastore table:

http://www.vbulletin.com/forum/showpost.php?p=575568&postcount=7

You should also upgrade to 3.0.3.

[Don Z.]

Run this script to fix your datastore table:

http://www.vbulletin.com/forum/showpost.php?p=575568&postcount=7

Thanks Steve but when I run it I get this error:

"Rebuilding options
Fatal error: Call to undefined function: build_datastore() in /home/.sites/28/site1/web/forums/includes/adminfunctions.php on line 1785"

Could it be because I'm using the vb3 prefix on the table names?

You should also upgrade to 3.0.3.

I have so many tweaks and customizations that I can't possibly upgrade with every version. I usually wait for the big ones.

Thanks for your help.

[Steve Machol]

You need to reupload the original adminfunctions.php file from the vB 3.0.0 zip file. This function is defined in that file. Make sure you upload in ASCII and overwrite the one on the server.

[globalbuzz]

We have just been visited by the spiders from hell

is there no way we can reset the most online to say a figure we had originally .. say 70 for example?

any assistance appreciated

G

[Steve Machol]

Run this query:

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

[user 1-2-3]

I have the same problem (spiders, errors etc.). I'm running version 3.01. I don't want to upgrade now. How can I reset this counter?

[Steve Machol]

Same query, except change the data number.

[user 1-2-3]

Same error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'name.datastore' doesn't exist

[user 1-2-3]

Sorry, forget to add prefix. Now everything is Ok. Thanks.