[just.b.jealous]

Thank you for this, my members love it. Is there a way to make the awards show randomly in the postbit and on the profiles?

Basically I want to add the setting here, that way the awards are shown randomly- I know if people have the same awards and never get more, that icon will set there forever and it would be nice if it rotated their awards...



I know I need to edit a plugin (awards_userawards_bit) and that I need to change one of these sql queries to pull randomly. Could someone help me out?

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'showthread') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply'))
{
	global $db, $vbulletin;
	{
		if (THIS_SCRIPT == 'private')
		{
			$this->post['userid'] =& $post['fromuserid'];
		}
		if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))
		{
			
			$post['userawards'] = '';
			// Obtain list of awards for current user
			$alluserawards =  $db->query_read("
				SELECT a.*, au.*
				FROM " . TABLE_PREFIX . "award a, " . TABLE_PREFIX . "award_user au
				WHERE (au.userid = ".$this->post['userid'].") AND (a.award_id=au.award_id) AND (a.award_active=1)
				ORDER BY ".$vbulletin->options[aw_awardorder]." 
			");

			$post['showuserawards'] = false;
			
			if ($post['num_awards'] = $db->num_rows($alluserawards))
			{
				$aw_i = 0;

				while ($award = $db->fetch_array($alluserawards))
				{
					$aw_i++;
					if ($aw_i <= $vbulletin->options['aw_display_limit'])
					{
						eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
					}
				}
				
				if (($vbulletin->options['aw_points']) AND ($this->post['userid']))
				{
					$userpoints = $db->query_read("
						SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
						FROM " . TABLE_PREFIX . "award a, " . TABLE_PREFIX . "award_user au
						WHERE (au.userid = ".$this->post['userid'].") AND (a.award_id=au.award_id) AND (a.award_active=1)
						GROUP BY au.userid
					");
				
					while ($array = $db->fetch_array($userpoints))
						{
						$post['total_points'] = $array['TotalPoints'];
						}  
				}
					
				$post['showuserawards'] = true;
				$db->free_result($alluserawards);
			}
		}
	}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']