Random User Picker

[Dean C]

[Random User Picker]

Information

vBulletin Version: 3.0.3


Author: Dean Clatworthy (http://www.deanclatworthy.com)


Copyright: You may use this modification at your own risk. I cannot and will not be held responsible for any damage you may cause to your forums during installation or thereafter. You may not distribute this modification in whole or parts and anyone found doing so faces risk of prosecution. All my modifications are released at vBulletin.org and anyone found releasing them elsewhere also faces risk of prosecution. You may not translate this modification without my prior permission.


Donations: I release my modifications for free. If you wish to donate please contact me and I will give you my details. All donations are graciously appreciated.


Credits: I would like to thank the following people who contributed to the making of this modification.

ChrisBaktis - requested the modification



What does this modification do?
This modification adds a new link to the admincp where you can select a random user. Simple as that!

Installation

1/

Add the following phrases:

Phrase Type: Control Panel User Management
Varname: random_user_picker
Text: Random User Picker

Phrase Type: Control Panel Global
Varname: pick_random_user
Text: Pick Random User

2/

Find in admincp/index.php:

construct_nav_option($vbphrase['generate_mailing_list'], 'email.php?do=genlist', '<br />');

Replace with:

construct_nav_option($vbphrase['generate_mailing_list'], 'email.php?do=genlist', '<br />');
construct_nav_option($vbphrase['pick_random_user'], 'user_random.php', '<br />');

3/

Upload the attached user_random.php to your /admincp/ directory.

Please Click Install!
If you installed this modifcation please click the install button. It'll help you keep up to date with future releases and important bugfixes, security updates.

[duncan99]

Wondering the purpose of this mod ?!?

[Dean C]

To pick a random user? Someone requested it, so here it is :)

[Dio]

This is a great hack!

Question: What would I use this for?

Answer: If you were running a promotion, contest, etc. and needed to randomly pick a winner, this Hack will do it for you. Much like a random number generator gives you a "random number". :)

[Dio]

Still stumped...It works but is not showing up on my Admin control panel. You can see it's spot between Generate Mailing List and Access Masks.

[Dean C]

Still stumped...It works but is not showing up on my Admin control panel. You can see it's spot between Generate Mailing List and Access Masks.

Apply step #2 again, my bad :)

[Dio]

Apply step #2 again, my bad :)
Found it! I loaded the Phrase in the wrong area. Thanks! :D

[Xtrm2Matt]

Great hack. I'm using this for contests :) (Random username picked out from the contest thread).

Sure beats getting them to email me! :D

[Jolten]

Wow Dean, nothing like sniping code and not giving credit. Not that this was difficult by any means. I'm sure a lot of people could have done it. Anyway... nice mod. Too bad I was asleep and couldn't do it myself in the past 5 hours.

[Dean C]

Um snipping code and taking credit? I've been working with PHP/MySQL for almost 5 years now. I don't need to take others code thanks :)

[MindTrix]

Yeah you tell em :) How is this different from the other mod that randomly picks a user? That one used to pick a user from a thread.

[Dean C]

I don't know, I did a search after seeing the request and there wasn't a modification that randomnly selects a user from the whole board :) So here it is.

[MindTrix]

Yup your right there isnt. The other one selects users that post in a certain thread

[Jolten]

<a href="https://vborg.vbsupport.ru/showthread.php?p=588553#post588553" target="_blank">https://vborg.vbsupport.ru/showt...553#post588553</a>

[Dio]

https://vborg.vbsupport.ru/showthread.php?p=588553#post588553
I'm lost now granted I am a ultra newbie coder, but Jolten your hack (very good I might add) is doing it in the global.php. Where as Dean C is doing it via a phrase with a call to user_random.php.

I want to make sure that I understand how he stole your code because they appear to be two different things.

[Dean C]

Well you'll have to excuse me because I may be wrong here, but last time I checked there was only one way to run a MySQL query to gain a random record from a table? I don't see what the big deal is here? Do you want credits in my first post or something?

I wrote that query without even looking at your post buddy so :)

[Koutaru]

Dean did not steal that code as you can see he missed the WHERE and the code isn't that difficult. That's the first way anyone would probably think of to grab a random user from the user table.

The WHERE which, by the way, I think should be put in so you don't grab banned members or members with no posts. If not, maybe an option to select WHERE clauses.

[Dan]

This is a nice quirky mod thanks for sharing it Dean

[theArchitect]

last time I checked there was only one way to run a MySQL query to gain a random record from a table? I don't see what the big deal is here? Do you want credits in my first post or something?We could be in the wrong here. It is possible he invented MySQL and as such came up with the command. If so I suppose he would be entitled to a thank you.

[Jolten]

It was really no big deal. Just kind of would have liked the opportunity to finish what I had started.

If you were engaged in a thread with someone about a request I certainly wouldn't just step in.

[SVTBlackLight01]

This has been requested since a hack like this was released for vb2, and AFAIK hasn't ever been done. Is it possible to modify this to give a greater weight to those with more posts?

[Zacharicus]

Fantastic, I needed one of these to pick a winner of a Half Life 2 contest. Just gotta sign up to win :D

Thanks!!

[Dean C]

This has been requested since a hack like this was released for vb2, and AFAIK hasn't ever been done. Is it possible to modify this to give a greater weight to those with more posts?

I spent a few minutes ago just adding some filters. Will release an updated file within the next couple of days with a few options to add bias ;)

[SVTBlackLight01]

You're Awesome!! :banana: Looking forward to it. :D

[ChrisBaktis]

Thank you - Thank you - Thank you!!!

I requested this hack because I run a sports card trading site. On this site we receive product from sponsors that we give out to members. I was looking for something to pick a random user every month from the entire member base - not just a thread where a member posts.

Thank you again for the hack!

[ChrisBaktis]

I saw that you are going to add a few features to this hack - If I can suggest one I would like to be able to eliminate members with 0 posts.

[T3MEDIA]

Well get this. I want something like this (http://match.com/search/searchSubmit.aspx?RN=2221782&PN=1&DO=2&sid=D0D1A819-9FFC-43F4-ADFD-1FDCE25FE8BB&trackingid=0&theme=213&lid=1000005) that would keep my style but show users profile picture that has a photo.

Never mind the sorting and all that. Just can that be done?

I can do it and have done it in memberfind (http://www.sprnch.com/forums/memberlist.php?do=getall&page=2&ltr=&pp=10&order=asc&postslower=0&postsupper=0&sort=username&ausername=&homepage=&icq=&aim=&yahoo=&msn=&joindateafter=&joindatebefore=&lastpostafter=&lastpostbefore=). but randomly and "must have photo"
Nope and yet to find anyone that can do it or has the time.

HA! Do that...

[Dean C]

File updated with new filters:

Exclude unregistered/unconfirmed users
Eliminate users with less than or equal to x posts
Eliminate users with greater than or equal to x posts


P.S. I'm too lazy to carry on making new phrases :p

[SnowBot]

Simple but effective :) nice hack Dean :)

1 suggestion :) Maybe have a filter by group ? Maybe do it by group ID as i would like to pick users but not say staff.

[Dean C]

So have some tickboxes to filter by usergroup perhaps :)?

[SnowBot]

Yer that sounds good :)

[Dean C]

Ok reupload user_random.php again, it has every search option you could possibly need in there :)

[SnowBot]

hehehe :) abit overkill but nice :)

[Dean C]

Well I thought I might as well add it all, after looking at user.php it was easy to do :)

[jamesk]

Is it possible to set this to a specific usergroup??

[SVTBlackLight01]

Yes. It works just like searching for users. Just select which usergroup(s) to choose from.

[ChrisBaktis]

Thanks for the filters!

[Dean C]

Is it possible to set this to a specific usergroup??

Yes, it's an option when picking a user :)

[mekro]

Hi can you help me with a small error i have it is below:

Invalid SQL:
SELECT
user.userid,
usergroupid,
birthday_search,
username,
posts
FROM
vb_user
LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE
1=1
ORDER BY
RAND()
LIMIT
1

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Thanks for any help.

Kirk

[Marco van Herwaarden]

Change:
FROM
vb_user


Into:
FROM
vb_user AS user

[Freezerator]

^^ that would be great :)

I want to start a lottery for one usergroup only :)

I have installed this current one, it's working fine :)
Thanks!

[Dean C]

Just updated the user_random.php file with Marco's fix, need to make a habit out of using aliases now :)

[SupraT]

Nice little hack, was wanting something to make giveaways easier. Thanks!

[Dean C]

Glad you like it SupraT :)

[zachlee]

Thanks Dean, Works perfectly!!

/clicks install

[Sleepyk]

works great good deal

[tomwilkinson2]

Thanks Dean!

I have just installed this successfully, but I was wondering whether you or someone could help me modify it so that it only picks registered users that have posted something, anything, over the last seven days?

We want to give some freebies to people each week but only pick from the recent posters.

Any help would be really appreciated.

Thanks again....

[Freezerator]

Hi Dean C,

thanks for this hack, i have been using it alot. Will there be an update of this hack to 3.5.x?
Thanks in advance.

[lazyseller]

Yeah i been looking for something simliar as well but misplaced this post for a request for 3.5

[hoopsta]

will this work with 3.5?

[Camz]

will this work with 3.5?
BUMP!!!

[Cebby]

Will this work on 3.6?