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");
    $text;
    $title;
    $url;
    $post_dt;
    $upd_flg;
    $atricles = "";
    $cur_news_posted_time = "";
    $mainUrl = $_SERVER["HTTP_HOST"];
    while ($row = mysqli_fetch_array($result)) {
        global $regionName, $regionNameLatin;
        $text = $row['text'];
        $title = $row['title'];
        $url = $row['url'];
        $post_dt = $row['posted_time'];
        $upd_flg = $row['upd_flg'];
        $updTitle = "";
        if ($cur_news_posted_time != engdate($post_dt, 'jS \\of F')) {
            $cur_news_posted_time = engdate($post_dt, 'jS \\of F');
            $atricles = $atricles . "<br/><h3>" . $cur_news_posted_time . "</h3>";
        }
        if ($upd_flg == 1) {
            $updTitle = "Information updated | ";
        }
        $atricles = $atricles . "{$mainUrl}/articles/{$url};" . $title . ";" . engdate($post_dt, 'jS \\of F, h:i:s A') . "\r\n";
        /*$atricles = preg_replace("/\[STATE_NAME\]/", $regionName , $atricles);
        		$atricles = preg_replace("/\[STATE_ABBR\]/", $regionName , $atricles);*/
    }
    return $atricles;
}
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;
}
Beispiel #3
0
        $template = preg_replace("/\\[CITY_NEWS_1\\]/", "<br/>No any news were found", $template);
        $template = preg_replace("/\\[PAGER\\]/", "", $template);
    }
    //fill [BREAD_CRUMBS]
    $bread_crumbs = "<a href =\"/#\">Main</a>&nbsp;";
    //
}
$key_info = array();
if ($current_page_type == "KEY_PAGE") {
    //get city page info
    #echo "page_key: ".$page_key."<br/>";
    $key_info = getKeyInfo($con, $page_key);
    //if page exist
    if ($key_info) {
        //fill [BREAD_CRUMBS]
        $bread_crumbs = "<a href =\"http://" . $site_main_domain . "\">Main</a>&nbsp;>&nbsp;<a href =\"#\">" . $key_info['key_value'] . " " . engdate($key_info['posted_time'], 'jS \\of F') . "</a>";
    } else {
        #PAGE NOT FOUND REDIRECT
        header('HTTP/1.1 404 Not Found');
        #header('Location: /');
        $_GET['e'] = 404;
        include $_SERVER['DOCUMENT_ROOT'] . '/404.html';
        exit;
    }
}
if ($current_page_type == "KEY_PAGE") {
    $template = fillSnippetsContent($template, $key_info['key_value'], $con, $page_key);
    //delete all unnecessary templates anchors
    for ($i = 0; $i < 9; $i++) {
        $template = preg_replace("/\\[SNIPPET_TITLE_" . ($i + 1) . "\\]/", '', $template);
        $template = preg_replace("/\\[SNIPPET_CONTENT_" . ($i + 1) . "\\]/", '', $template);
Beispiel #4
0
function fillArticleList($con, $template)
{
    global $page_title, $page_meta_keywords, $page_meta_description, $keyword;
    $result = mysqli_query($con, " SELECT ac.*, at.titleOrig, 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");
    $text;
    $titleOrig;
    $url;
    $post_dt;
    $upd_flg;
    $atricles = "";
    $cur_news_posted_time = "";
    while ($row = mysqli_fetch_array($result)) {
        global $categoryName, $categoryNameLatin;
        $text = $row['text'];
        $titleOrig = $row['titleOrig'];
        $url = $row['url'];
        $post_dt = $row['posted_time'];
        $upd_flg = $row['upd_flg'];
        $updTitle = "";
        if ($cur_news_posted_time != engdate($post_dt, 'jS \\of F')) {
            $cur_news_posted_time = engdate($post_dt, 'jS \\of F');
            $atricles = $atricles . "<h3>" . $cur_news_posted_time . "</h3>";
        }
        if ($upd_flg == 1) {
            $updTitle = "Information updated | ";
        }
        $atricles = $atricles . "<a href=\"/articles/{$url}/\">" . $updTitle . " " . $titleOrig . " (" . engdate($post_dt, 'jS \\of F, h:i:s A') . ")</a></br>\r\n";
        /*$atricles = preg_replace("/\[CATEGORY_NAME\]/", $categoryName , $atricles);
        		$atricles = preg_replace("/\[CATEGORY_ABBR\]/", $categoryName , $atricles);*/
    }
    //apply template
    $template = preg_replace("/\\[ATRICLES_LIST\\]/", $atricles, $template);
    return $template;
}