Quellcode

if(!defined('pkFRONTEND') || pkFRONTEND!='public')
die('Direct access to this location is not permitted.');


$boxlinks=array();

$query=$SQL->query("SELECT 
".pkSQLTAB_CONTENT.".content_id,
".pkSQLTAB_CONTENT.".content_title
FROM ".pkSQLTAB_CONTENT."
LEFT JOIN ".pkSQLTAB_CONTENT_CATEGORY." ON ".pkSQLTAB_CONTENT_CATEGORY.".contentcat_id=".pkSQLTAB_CONTENT.".content_cat
WHERE ".pkSQLTAB_CONTENT.".content_option=1 AND 
".pkSQLTAB_CONTENT.".content_status=1 AND
(".pkSQLTAB_CONTENT.".content_expire>'".pkTIME."' OR
".pkSQLTAB_CONTENT.".content_expire='0') AND
".pkSQLTAB_CONTENT.".content_time<'".pkTIME."' AND 
".sqlrights("".pkSQLTAB_CONTENT_CATEGORY.".contentcat_rights")." AND
".pkSQLTAB_CONTENT_CATEGORY.".contentcat_id='5'
ORDER by ".pkSQLTAB_CONTENT.".content_time DESC
LIMIT 5");
while(list($id,$title)=$SQL->fetch_row($query))
{
$title_cutted=pkEntities(pkStringCut($title));
$title=pkEntities($title);

$boxlinks[]=pkHtmlLink(pkLink('article','','contentid='.$id),$title_cutted,'','pknidheadline'.count($boxlinks),'pkcontent_a_'.$navalign,$title);
}

return $boxlinks;
?>