Nieuws weergave bij nieuwssysteem lumox

{
	// Generate the left items

	$amount = 8;
	
	if(URI_ACTION == 'list')
	{
		$offset = (URI_PAGE > 0) ? URI_PAGE : 0;
	}
	else
	{
		$offset = URI_OFFSET;
	}
	
	$array = db_row("SELECT item_link,item_id,item_date FROM ".SITE_PREFIX."items WHERE item_cat = '".URI_CAT_ID."' AND item_date < '".CHECK."' ORDER BY item_date DESC LIMIT $offset,$amount");
	list($total) = db_row("SELECT COUNT(1) FROM ".SITE_PREFIX."items WHERE item_cat = '".URI_CAT_ID."' AND item_date < '".CHECK."'");
	
	$text = array();
	$browse = '';
	
	if($array)
	{		
		foreach($array as $value)
		{
			$text[] = array(ucfirst($value[0]),get_url('view',URI_CAT,$value[1],$offset),null,$value[2]);
		}	
	}
	
	if($total[0] > $amount)
	{
		$last = ($total[0] / $amount) - 1;
		
		if(URI_ACTION == 'list')
		{
			$current = ((URI_PAGE >= 0) ? URI_PAGE : 0) / $amount;
			
			if($current < $last)
			{
				$browse = '<div class="subarchive"><a href="'.get_url(URI_ACTION,URI_CAT,($current + 1) * $amount,($current + 1) * $amount).'">></a></div>';
			}
		}
		else
		{
			$current = URI_OFFSET / $amount;
			
			if($current < $last)
			{
				$browse = '<div class="subarchive"><a href="'.get_url(URI_ACTION,URI_CAT,URI_PAGE,($current + 1) * $amount).'">></a></div>';
			}
		}
	}
	
	load('theme_sub',array($browse.ucfirst(URI_CAT),(count($text) > 0) ? $text : ERROR_1));
}