}
} elseif ($current_page == "CITY_PAGE") {
//get city page info
$tmpl_inner = fillItemInfo($con, $url_region, $url_city, $tmpl_inner);
if ($tmpl_inner == null) {
fireCall404();
//$tmpl_inner = file_get_contents("tmpl_main_block.html");
}
$page_title = CITY_PAGE_TITLE;
$page_meta_description = CITY_META_DESCRIPTION;
$page_meta_keywords = CITY_META_KEYWORDS;
$page_h1 = CITY_PAGE_H1;
$page_h2 = CITY_PAGE_H2;
} elseif ($current_page == "ARTICLES_LIST_PAGE") {
//get city page info
$tmpl_inner = fillArticleList($con, $tmpl_inner);
if ($tmpl_inner == null) {
fireCall404();
//$tmpl_inner = file_get_contents("tmpl_main_block.html");
}
$page_title = ARTICLES_LIST_PAGE_TITLE;
$page_meta_description = ARTICLES_LIST_META_DESCRIPTION;
$page_meta_keywords = ARTICLES_LIST_META_KEYWORDS;
} elseif ($current_page == "ARTICLE_PAGE") {
//get city page info
$tmpl_inner = fillArticle($con, $url_city, $tmpl_inner);
if ($tmpl_inner == null) {
fireCall404();
//$tmpl_inner = file_get_contents("tmpl_main_block.html");
}
}
}
function fillArticleList($con)
{
global $page_title, $page_meta_keywords, $page_meta_description;
$result = mysqli_query($con, " SELECT ac.*, at.title, at.url, t1.posted_cnt, unix_timestamp(ac.post_dt) posted_time " . " FROM article_content ac, article_tmpl at," . " (SELECT ac.tmpl_id, MAX(ac.post_dt) max_post_dt, COUNT(1) posted_cnt " . " FROM article_content ac" . " WHERE ac.post_dt < now() GROUP BY ac.tmpl_id) AS t1" . " WHERE ac.tmpl_id = t1.tmpl_id AND at.tmpl_id = ac.tmpl_id AND ac.post_dt = t1.max_post_dt ORDER BY ac.post_dt DESC");
$title;
$url;
$post_dt;
$atricles = "";
$cur_news_posted_time = "";
$mainUrl = $_SERVER["HTTP_HOST"];
while ($row = mysqli_fetch_array($result)) {
global $regionName, $regionNameLatin;
$title = $row['title'];
$url = $row['url'];
$post_dt = $row['posted_time'];
$atricles = $atricles . "http://{$mainUrl}/articles/{$url};" . $title . ";" . engdate($post_dt, 'jS \\of F, h:i:s A') . "\r\n";
}
return $atricles;
}
$con = mysqli_connect(DB_HOST, DB_USER_NAME, DB_USER_PWD, DB_NAME);
#echo "Connecting...";
if (mysqli_connect_errno()) {
#echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($con, "set character_set_client='utf8'");
mysqli_query($con, "set character_set_results='utf8'");
mysqli_query($con, "set collation_connection='utf8_general_ci'");
$template = fillArticleList($con);
mysqli_close($con);
echo $template;
