vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Most Users Ever Online Statistic. (https://vborg.vbsupport.ru/showthread.php?t=326811)

alfuzzy 10-13-2018 04:24 PM

Most Users Ever Online Statistic.
 
Anyone know how to reset (if possible) the "Most Users Ever Online Statistic" found in the "What's Going On" area?

Looked in the Admincp area...but couldn't find anything...maybe need to dig deeper.

Thanks

MarkFL 10-13-2018 04:55 PM

I think you'd have to run a query to edit the 'datastore' table. At vBcom, the advice given is to manually run this query:

Code:

UPDATE datastore SET data = '' WHERE title = 'maxloggedin';
I have not tested this, so hopefully you have a test installation you can try this with first.

alfuzzy 10-13-2018 09:35 PM

Nice. That certainly looks much more involved than a nice-easy reset button in the admincp (if there was one)!;)

Thanks MarkFL...appreciate it.:)

Max Taxable 10-14-2018 04:40 PM

Quote:

Originally Posted by alfuzzy (Post 2596776)
Nice. That certainly looks much more involved than a nice-easy reset button in the admincp (if there was one)!;)

If there was one that is exactly what it would do - run that same query but with one click.

Easy enough to paste this into ACP/Maintenance/Execute SQL Query/ Manual box and click "Continue."

alfuzzy 10-14-2018 05:14 PM

Quote:

Originally Posted by Max Taxable (Post 2596789)
If there was one that is exactly what it would do - run that same query but with one click.

Easy enough to paste this into ACP/Maintenance/Execute SQL Query/ Manual box and click "Continue."

Yes..."Easy Enough" (if someone is used to doing this sort of stuff).:) But even MarkFL above mentioned..."I have not tested this, so hopefully you have a test installation you can try this with first.";)

It really would have been great if vBulletin had incorporated a "reset" button in the admincp for that most ever users online statistic.

That statistic can be so easily manipulated...and being able to easily reset it would be handy for when a website is significantly altered...and generating a "new" most users ever stat under the new conditions would be useful.

Thanks

MarkFL 10-14-2018 05:27 PM

Quote:

Originally Posted by alfuzzy (Post 2596790)
Yes..."Easy Enough" (if someone is used to doing this sort of stuff).:) But even MarkFL above mentioned..."I have not tested this, so hopefully you have a test installation you can try this with first.";)

It really would have been great if vBulletin had incorporated a "reset" button in the admincp for that most ever users online statistic.

That statistic can be so easily manipulated...and being able to easily reset it would be handy for when a website is significantly altered...and generating a "new" most users ever stat under the new conditions would be useful.

Thanks

I just ran the manual query I posted above on my local dev site (vB 4.2.5), and it worked without issue. :)

alfuzzy 10-14-2018 05:58 PM

Quote:

Originally Posted by MarkFL (Post 2596791)
I just ran the manual query I posted above on my local dev site (vB 4.2.5), and it worked without issue. :)

Thank you sir...appreciate it.:)

Max Taxable 10-14-2018 09:37 PM

Quote:

Originally Posted by alfuzzy (Post 2596790)
Yes..."Easy Enough" (if someone is used to doing this sort of stuff).:)

I mean, it's quite simple really even if you've never done it.

alfuzzy 10-15-2018 07:21 PM

Quote:

Originally Posted by Max Taxable (Post 2596796)
I mean, it's quite simple really even if you've never done it.

I get ya on that.:)

I think that part that had me concerned was with MarkFL's first post in the tread about doing things on a test site...rather than the live site (which could indicate some level of risk).:(

But then MarkFL said he did it...and things worked fine.:)

Thanks

Max Taxable 10-15-2018 08:02 PM

Quote:

Originally Posted by alfuzzy (Post 2596813)
I think that part that had me concerned was with MarkFL's first post in the tread about doing things on a test site...rather than the live site (which could indicate some level of risk).:(

That's pretty much a standard disclaimer, any time anyone with experience is recommending you manually run a db query. Along with either/or, "Make sure you do a backup first!"

Could sound ominous, but really it's not. It's just part of "best practices" not to do stuff like that on your live site without first trying it on a tester. And it's "best practices" to recommend testing first.

You never let us know if you ran the query or not, and if so did it get you where you wanted to be.


All times are GMT. The time now is 12:53 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01126 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete