[nhawk]

Originally Posted by clutchthese

I accidentally deleted the forum side bar for raffle. Is there any way to get that back? I delete it quickly thinking it was another widget.

Import the product again, and be sure "allow overwrite" is set to yes when you do.

That might bring it back.

If not, create a new block

Block Type: Custom HTML/PHP

Title: Active Raffles
Description: Active Raffle List block on forum sidebar
Cache Time: 0
Active: Yes

Content Type: PHP

c&p this code for Content..

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];
				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 .= '<br /><img class="display" src="' . $raffle['prizeimg'] . '" width="' . $picture_width . '" height="' . $picture_height . '" alt="' . $raffle['name'] . '" border="0" />';
				}
				$rafflelist .= '</a><br />';
			}
		}
	} 

	unset($raffle_getactive); 
    
	$statsarray = array('currentraffles'  => $raffle_list,);
    
	return $statsarray;
}

Template to Use: raffle_sideblock