How do I reset most users online ?

[z0diac]

Yahoo destroyed my max. users online by flooding my forum with crawlers.

How do I reset the max. users online? (even if I have to edit it via PhpMyAdmin that's fine - just not sure what to edit)

[Jake Bunce]

Run this query on your database:

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

That will reset the max users statistic.

[z0diac]

Unfortunately I can't run queries through vB's admin page.

This line here (in datastore / data )

a:4:{s:9:"maxonline";i:43;s:13

Can I change the 43 to 1 ? (I'm guessing that's the variable that contains the max. users online since that is the # (43) that my forum is reporting)

[z0diac]

Ok, I fixed it. Just ran that query through MyPHPAdmin.

Thanks!

[JustAskJulie]

Run this query on your database:

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

That will reset the max users statistic.

Getting this error when I run the query:

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

[Steve Machol]

You are probably using a table prefix and need to add that in front of 'datastore'.

[JustAskJulie]

Thanks. That did the trick.

[The Gismo Man]

Am wanting to reset the most users online as well and getting the same error message, 1146.
I also get the following:-
error desc: Table 'newminiforum.datastore' doesn't exist

Sadly, i have no knowledge of what this may be or where it relates to, can you advise what i may need to input, text wise?

[Jose Amaral Rego]

Am wanting to reset the most users online as well and getting the same error message, 1146.
I also get the following:-
error desc: Table 'newminiforum.datastore' doesn't exist

Sadly, i have no knowledge of what this may be or where it relates to, can you advise what i may need to input, text wise?

http://www.vbulletin.com/forum/showpost.php?p=1533003&postcount=6

[The Gismo Man]

Edit, finally sussed it out, for anyone else that does not know where or how to add your prefix, it's contained within your config.php file.
Simply add the prefix immeditely before the datastore with no gaps or underscore

[Jose Amaral Rego]

Do you know how to access your database tables though phpMyAdmin, you can see if the list of tables start with Example:
vB_test.access
vB_test.adminhelp

includes/config.php file:

	//	****** TABLE PREFIX ******
	//	Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vB_test';

[The Gismo Man]

Do you know how to access your database tables though phpMyAdmin

Sadly, nope, but, i do know where and how to edit the config.php log.
I accessed that to find the info i needed, from there trial and error to run the query.

Any advice on how to access the phpMyAdmin greatly appreciated

[Jose Amaral Rego]

What type of control panel does your host have setup... Cpanel, Plesk...

config.php is a file on the host side that was uploaded by you.

[The Gismo Man]

What type of control panel does your host have setup... Cpanel, Plesk...

I have a virtual control panel where i can set e-mail accounts and change the ftp password etc for my site and the vBulletin Admin CP.
I'm begining to think that me accessing the php side of things is beyond my capabilties
Thankfully i know enough not to change stuff......
Anyways, sorry, this seems to have veered way off topic

[Jose Amaral Rego]

Are you running on a Windows server or Linux? It seem that it maybe a custom setup and I can not find any help section...

http://www.fasthosts.co.uk/