[nhawk]

Originally Posted by csavern

yes same block that is on the forum side block

AdminCP->vBulletin CMS->Widgets

Click the "Create New Widget" button.

Widget Type = PHP Direct Execution
Title = Current Raffles
Description = Current Raffle List

Click "Save"

Click "Configure"

Paste this code in the box that comes up..

global $vbulletin;

if ($vbulletin->options['raffle_mode'] && $vbulletin->options['raffle_showsidebar'] && !is_member_of($vbulletin->userinfo, explode(',', $vbulletin->options['raffle_perms'])))
{
	$timenow = TIMENOW;
	$raffle_getactive = $vbulletin->db->query_read_slave("SELECT * FROM " . TABLE_PREFIX . "raffle 
			WHERE enddate > $timenow AND startdate <= $timenow
			ORDER BY id DESC
			"); 

	if ($vbulletin->db->num_rows($raffle_getactive)) 
	{ 
		while($raffle = $vbulletin->db->fetch_array($raffle_getactive))
		{
			if (is_member_of($vbulletin->userinfo, explode(',', $raffle['groupperm'])))
			{
				if($raffle_list)
				{
					$raffle_list .= '<br />';
				}
				$raffle_list .= '<a href="raffles.php?' . $session[sessionurl] . 'do=raffle&id=' . $raffle[id] . '" title="' . $raffle[name] . '" />' . $raffle[name] . '<br />';
				if($raffle['showimage'])
				{
					if(empty($raffle['prizeimg']))
					{
						$raffle['prizeimg'] =  'images/raffles/default.gif';
					}

					$target =  $vbulletin->options['raffle_sidebar_maxpicture'];
					$picturesize = getimagesize($raffle['prizeimg']); 
					$percentage = ($target / $picturesize[0]); 
					$picture_width = round($picturesize[0] * $percentage); 
					$picture_height = round($picturesize[1] * $percentage); 
					$raffle_list .= '<img class="display" src="' . $raffle['prizeimg'] . '" width="' . $picture_width . '" height="' . $picture_height . '" alt="' . $raffle['name'] . '" border="0" /></a><br />';
				}
			}
		}
	} 

	unset($raffle_getactive); 

	$output = $raffle_list;    
}

Click "Save"

Then add the widget to the layout manager.