Random User Picker

[Random User Picker]

Information

• [high]vBulletin Version:[/high] 3.0.3
  
  
• [high]Author:[/high] Dean Clatworthy
  
  
• [high]Copyright:[/high] 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.
  
  
• [high]Donations:[/high] 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.
  
  
• [high]Credits:[/high] 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:

PHP Code:

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


Replace with:

PHP Code:

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.

[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]

Originally Posted by jamesk

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:
[sql] FROM
vb_user
[/sql]

Into:
[sql] FROM
vb_user AS user
[/sql]