Reset most users online from the AdminCP

[Dream]

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]

$zero_sql = "UPDATE datastore
replace by
$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?

[MrSDavidson]

What's Going On?
Currently Active Users: 28 (16 members and 12 guests)
Most users ever online was 41, Today at 04:20 PM.
Bit in blue is the most users online section
that help you :)

[MrSDavidson]

hmmm its set to blue but shows up green

Is This A BUG???

[John Smiley]

Is there anything like this for 3.0 ???

I need this badly and can't find anything in my own area.

[Dream]

this thread explains how you do it with a query

http://www.vbulletin.com/forum/showthread.php?t=140224

I dont even have 3.0.7 anymore, if anyone want to port this over be my guest

[John Smiley]

That worked great, Thanks ;^)

[evss]

Besides Reset,

is there anyways we can set the number we want and once run thru the quey, it will built the preset no. on the current dates/time or allow preset date/time ?

btw. Nice and useful hack. Thank you.

[Boofo]

I'm just curious but why would you ever want to reset that?

[Dream]

I'm just curious but why would you ever want to reset that?

when your forum is invaded by a bunch of hungry googlebots, sometimes its nice to reset the record.

evss, if that was to be included, you would have to choose a date also, so it would be a little more work to add.

[evss]

when your forum is invaded by a bunch of hungry googlebots, sometimes its nice to reset the record.

evss, if that was to be included, you would have to choose a date also, so it would be a little more work to add.

To Boofo,

As Dream pointed out..
E.g if i had a no. Most Ever User Online was 100 on date/time
Then i only have 200 Registered user..

suddenly one bunch of spider come in and spike it to 400 or 500..
this isnt something i want to see...

hence my thoughts were.. if im able to reset it back to 100 on the preset date/time or other can set to 100 on current date / time.. that what i want the function for.
But anyway i just not a coder hence i keep resetting if it every was spike to a limit.

Thanks Dream

[Herc]

I like it and I used it....Thanks, Dream...Worked for 3.5.2
I just recently got hit by a mass amount of robots....3300 simultaneous users and your reset has allowed me to get rid of that horrible number on my forumhome..

Thanks again.....Herc

[JsnakeJ]

Maybe you should post a new screenie to show that its in the vBulletin Options now and not the main page. :)

[Herc]

Tell ya what....I'll do it for him, ya wiener :rolleyes:

http://img.photobucket.com/albums/v207/Axewielder/reset.gif

[bmanzzz]

great work
*installed*

[m52]

installed, works a treat!

[alyster4k]

Worked for 3.6.1 too. Thanks.

[Robru]

Also worked for 3.6.2 :)

[fishhub]

can we insert the most no of users on specific dates manually?

[DieselMinded]

Worked on 3.6.7 PL1

[teamelusive]

^^ i can say it did worked w/ 3.6.7 PL1 as well. thx!

[pacmanfan]

I'm getting an "Invalid File Specified" error when I try to import the XML file, in 3.6.8.

[beer4life]

I'm getting an "Invalid File Specified" error when I try to import the XML file, in 3.6.8.
G'Day Everyone, been looking for this for ages, but what a disappointment when it gave the "Invalid File Specified" message when using vB 3.6.4.
Would be fantastic to get working as the figure we have now is highly inflated. Not what I like.
PLEASE, if any one can update or post an earlier working file, I would be forever grateful.
Kindest Regards, Bill. :cool: :up:

[Dream]

You don't import the xml, read the install instructions again.

[beer4life]

You are so right.
What more can I say. Methinks dazzled by your beauty, or more likely a geriatric aberration.
Many Thanks and Very Kindest Regards, Bill.:up:

[beer4life]

Many thanks for your assistance.
Worked fine except is giving Current Date/Time.
What is needed to show when record was set?
This was in the original.
Kindest Regards, Bill.:cool:

[cypher1973]

looked for this a while and works a treat nice one installed

[texasasl]

Very nice. Indeed thank you very much

[piraterevival]

Installed, working OK
Nice one

[alyster4k]

Still works in 3.7. Thanks!

[Rzoops]

Works perfectly in 3.6.8. Thanks!!

[DieselMinded]

Ive had this for a while ,, Just tried to use it again and it didnt work
3.7.2

[drsli]

Works on my 3.73-board like a charm! :) Many thanks for this helpful additon.

[DieselMinded]

It worked it just took it a while

[vithorius]

EXCELLENT Mod!!!

I had my counter for most online users with a problem for more than 3 months and this 'tiny' Mod has just SOLVED IT!!! :up: :D :up:


THANK YOU SO VERY MUCH!!!


(installed!)

[Dream]

great glad it worked well for you :)

[Nadeemjp]

hey does this mod have a counterpart for 3.7.3 as well?

[Dream]

im pretty sure this works with 3.7

[Darksaint]

Worked smoothly for me as well and helped us a lot to get a more "normal" count.

[HabboLan]

Works in 3.8.x Also
Thanks

[MarioN70]

Thanks! Excellent work

[senadxxx]

hm for me on 3.8.3 not working this is mesage:

ERROR 404 - PAGE NOT FOUND

Oops! Looks like the page you're looking for was moved or never existed.
Make sure you typed the correct URL or followed a valid link.

[guitarscanada]

works great. thanks for this one

[Robru]

Works also in 4.1.7 :)

[Robru]

Don't work anymore in 4.1.8...