NOW()) LIMIT 1";
if($result = mysql_query($sql, $db) or die("error while reading article datas")) {
if($row = mysql_fetch_assoc($result)) {
//Da max. 1 Datensatz -> sofort Datenbankverbindung kappen
mysql_free_result($result);
// now try to retrieve alias article information
if($row["article_aliasid"]) {
$alias_sql = "SELECT *, UNIX_TIMESTAMP(article_tstamp) AS article_date, ";
$alias_sql .= "UNIX_TIMESTAMP(article_begin) AS article_livedate, ";
$alias_sql .= "UNIX_TIMESTAMP(article_end) AS article_killdate ";
$alias_sql .= "FROM ".DB_PREPEND."phpwcms_article ";
$alias_sql .= "WHERE article_deleted=0 AND article_id=".intval($row["article_aliasid"]);
if(!$row["article_headerdata"]) {
switch(VISIBLE_MODE) {
case 0: $alias_sql .= " AND article_public=1 AND article_aktiv=1";
break;
case 1: $alias_sql .= " AND article_uid=".$_SESSION["wcs_user_id"];
break;
}
$alias_sql .= " AND article_begin < NOW() AND article_end > NOW()";
}
$alias_sql .= " AND article_deleted=0 LIMIT 1";
if($alias_result = mysql_query($alias_sql, $db)) {
if($alias_row = mysql_fetch_assoc($alias_result)) {
$row["article_id"] = $alias_row["article_id"];
// use alias article header data
if(!$row["article_headerdata"]) {
$row["article_title"] = $alias_row["article_title"];
$row["article_subtitle"] = $alias_row["article_subtitle"];
$row["article_keyword"] = $alias_row["article_keyword"];
$row["article_summary"] = $alias_row["article_summary"];
$row["article_redirect"] = $alias_row["article_redirect"];
$row["article_date"] = $alias_row["article_date"];
$row["article_image"] = $alias_row["article_image"];
$row["article_pagetitle"] = $alias_row["article_pagetitle"];
}
}
mysql_free_result($alias_result);
}
}
//Kategoriebezeichner
$article['cat'] = $content['struct'][$row["article_cid"]]['acat_name'];
//redirection definition
if($row["article_redirect"]) {
$row["article_redirect"] = str_replace('{SITE}', PHPWCMS_URL, $row["article_redirect"]);
$content["redirect"] = explode(' ', $row["article_redirect"]);
$content["redirect"]["link"] = $content["redirect"][0];
$content["redirect"]["target"] = isset($content["redirect"][1]) ? $content["redirect"][1] : '';
$content["redirect"]["timeout"] = isset($content["redirect"][2]) ? intval($content["redirect"][2]) : 0;
//check how to redirect - new window or self window
if( !$content["redirect"]["target"] || $content["redirect"]["target"] == "_self" || $content["redirect"]["target"] == "_top" || $content["redirect"]["target"] == "_parent") {
// direct redirection in the same window
headerRedirect($content["redirect"]["link"], 301);
} else {
// redirection by using a special html head part
$content["redirect"]["code"] = LF . '