Hi Dirk,
ich habe deine Funktion dw_generateFrontendUrl mal etwas "eingedampft". So braucht sie nur noch eine Datenbankabfrage mit zwei Joins, weniger Variablen und weniger Code.
Code:
protected function dw_generateFrontendUrl($id)
{
$objResult = $this->Database->prepare('SELECT tl_news.id as newsid, tl_news.alias as newsalias, tl_page.id as pageid, tl_page.alias as pagealias FROM tl_news, tl_news_archive, tl_page WHERE tl_page.id = tl_news_archive.jumpto and tl_news_archive.id = tl_news.pid and tl_news.id=?') ->execute($id);
$page['id'] = $objResult->pageid;
$page['alias'] = $objResult->pagealias;
return($this->Environment->base . ampersand($this->generateFrontendUrl($page, '/items/' . ((!$GLOBALS['TL_CONFIG']['disableAlias'] && strlen($objResult->newsalias)) ? $objResult->newsalias : $objResult->newsid))));
}
Gruß
Jan
Lesezeichen