Change most users ever online to specific amount, rather than reset completely

[tnedator]

I don't know what happened last night, but my max users ever online jumped from 155 or so to 501. Based on Google analytics there is no way that was actual uers/guests, so I imagine there must have been some search bot flood or something else.

I have seen queries posted that look like they will reset the max online users to 0, but is there anyway for me to set it back to 155? My members like checking that figure out, and while the jump to 501 makes them think something is wrong, I would hate to revert it all the way back to 0.

Thanks

[Jake Bunce]

Run this query:

UPDATE datastore
SET data = 'a:2:{s:9:"maxonline";i:563;s:13:"maxonlinedate";i:1182947492;}'
WHERE title = 'maxloggedin'

The first number is the max online users. The second number is the timestamp.

[tnedator]

Run this query:

UPDATE datastore
SET data = 'a:2:{s:9:"maxonline";i:563;s:13:"maxonlinedate";i:1182947492;}'
WHERE title = 'maxloggedin'

The first number is the max online users. The second number is the timestamp.

Ok. Good news, bad news. The query worked. Thanks a bunch. Anyone else that is trying to figure out how to do this, here is a link to a unix timestamp converter. http://www.onlineconversion.com/unix_time.htm

Now the bad news. There are currently around 300 yahoo threads on my site, so once again the max count just shot up.

Do you know if there is anyway to not count searchbots or to limit the number of instances Yahoo sends? On the one hand I am glad Yahoo has started to catalog my site big time, but I hate the fact it is skewing my stats so bad.

Thanks

[tnedator]

I did some searching after I posted my last message and figured a robots.txt (which I previously didn't have) was the best option. My robots.txt currently has the following. Does this look good?

 
User-agent: *
Disallow: /forums/memberlist.php
Disallow: /forums/attachment.php
Disallow: /forums/avatar.php
Disallow: /forums/editpost.php
Disallow: /forums/member.php
Disallow: /forums/member2.php
Disallow: /forums/misc.php
Disallow: /forums/moderator.php
Disallow: /forums/newreply.php
Disallow: /forums/newthread.php
Disallow: /forums/online.php
Disallow: /forums/poll.php
Disallow: /forums/postings.php
Disallow: /forums/printthread.php
Disallow: /forums/private.php
Disallow: /forums/report.php
Disallow: /forums/search.php
Disallow: /forums/sendtofriend.php
Disallow: /forums/threadrate.php
Disallow: /forums/usercp.php
Disallow: /forums/admincp/
Disallow: /forums/modcp/
Disallow: /forums/images/
Disallow: /forums/sendmessage.php
Disallow: /forums/register.php
Disallow: /forums/subscription.php
User-agent: Slurp
Crawl-delay: 60

[Jake Bunce]

A robots file is a good way to block search spiders. There is no feature in vBulletin to exclude spiders from the online count.

[tnedator]

A robots file is a good way to block search spiders. There is no feature in vBulletin to exclude spiders from the online count.

Thanks, as always, for the quick reply.

Do you know if that list of "disallows" is about right to make sure the spiders still crawl the posts, but not the non-post pages?

[Jake Bunce]

That looks correct to me.

[ceho]

Hi, I ran the query as stated above (adjusted number & date of course) but received this error message:

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

My version is vb 3.6.9. Any idea what might be wrong?

Thanks a lot!

[Jake Bunce]

You must be using a table prefix. Add the prefix onto the word datastore. The prefix can be seen in your includes/config.php file.

[ceho]

I still need to get used to this... ;-)

Thank you very much, it worked easily!

[juice]

I did some searching after I posted my last message and figured a robots.txt (which I previously didn't have) was the best option. My robots.txt currently has the following. Does this look good?

 
User-agent: *
Disallow: /forums/memberlist.php
Disallow: /forums/attachment.php
Disallow: /forums/avatar.php
Disallow: /forums/editpost.php
Disallow: /forums/member.php
Disallow: /forums/member2.php
Disallow: /forums/misc.php
Disallow: /forums/moderator.php
Disallow: /forums/newreply.php
Disallow: /forums/newthread.php
Disallow: /forums/online.php
Disallow: /forums/poll.php
Disallow: /forums/postings.php
Disallow: /forums/printthread.php
Disallow: /forums/private.php
Disallow: /forums/report.php
Disallow: /forums/search.php
Disallow: /forums/sendtofriend.php
Disallow: /forums/threadrate.php
Disallow: /forums/usercp.php
Disallow: /forums/admincp/
Disallow: /forums/modcp/
Disallow: /forums/images/
Disallow: /forums/sendmessage.php
Disallow: /forums/register.php
Disallow: /forums/subscription.php
User-agent: Slurp
Crawl-delay: 60

How and where do you add this robot.txt file? I want to avoid this situation as well.

[Jake Bunce]

The file is called robots.txt and it is placed in your web root.