The Arcive of Official vBulletin Modifications Site.

Wild Bronco · #1 05-31-2009, 10:59 AM

I don't know if this is the right place to ask, but it did not fit anywhare else...

I am having a game on my site and need to pull out 3 random usernames who have registered in Mai.

Is there a mod/plugin for this ??

Lynne · #2 05-31-2009, 05:38 PM

I have not seen a mod for this.

Wild Bronco · #3 06-01-2009, 10:50 PM

It would be nice to have this in/for vBulletin

But I solved it by using http://random.org/

By using User ID's I could make a random draw

SamirDarji · #4 03-23-2011, 05:03 AM

I'm looking for almost exactly the same thing. Except I want to choose from the active users in a given month. I don't need anything fancy, just the sql query. But I don't know how to construct those.

Any assistance appreciated.

Lynne · #5 03-23-2011, 04:10 PM

Getting active users in a given month is going to be more difficult than getting registered users. Registration dates are kept; dates a user logged in are not. You will need to set up a database/field/something to actually log all times a user is logged in if you wish to find when they were active.

SamirDarji · #6 03-23-2011, 04:49 PM

Isn't there a last login date? And if the query (or manually if I have to) can determine the number of days in the current month, then it could check the number of days between the last login date and the current date and if it doesn't exceed the number of days in the month, it's a valid user.

Then take all these valid users and pull a random one. Is there not a way?

Lynne · #7 03-23-2011, 05:11 PM

But if you are looking for anybody who was active in the month of February, someone could come log in right now, and not have been online since last year, and that means their last login date would be March, but they were definitely not an active user in February.

SamirDarji · #8 03-23-2011, 05:40 PM

True, but that's why I was going to run the query at the end of each month on the last day. Either via a cron or manually.

Lynne · #9 03-23-2011, 05:44 PM

Then that would work. You hadn't said that before which is why I couldn't see how that would work.

SamirDarji · #10 03-23-2011, 06:02 PM

Sorry.

I didn't know if there was a way to make it work outside of the current month or not.

Now I just need the db query.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04509 seconds Memory Usage 2,238KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!