[Warlock40]

great hack. thought it was working on 3.5.4
but get this error when try to send out an email

Database error in vBulletin 3.5.4:

Invalid SQL:

				SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
					useractivation.activationid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
				LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)
				WHERE 
		1=1 AND (usergroupid = 6 OR usergroupid = 7 OR usergroupid = 50 OR usergroupid = 46 OR usergroupid = 51 OR usergroupid = 2 OR find_in_set(6, membergroupids) OR find_in_set(7, membergroupids) OR find_in_set(50, membergroupids) OR find_in_set(46, membergroupids) OR find_in_set(51, membergroupids) OR find_in_set(2, membergroupids))
		AND user.email <> ''
		
				ORDER BY userid
				LIMIT 0, 500;

MySQL Error  : Column: 'usergroupid' in where clause is ambiguous
Error Number : 1052