• Mike •

 
<php? include_once "/news/calend.php"; ?>
 

 
<php? include_once("папка скрипта/news.php"); ?>
 

 
{php} include_once("папка скрипта/news.php"); {/php}
 

 
<div class="grid_8" id="main">
 

 
<img src="/images/users/avatars/{$article.avatar}" border="0" style="float:left;margin-right:1em;width:64px;" />
 

 
    public function getArticle($article_id) {
		$today = date("Y-m-d H:i:s");
		$sql = "SELECT  con.*,
						cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.modgrp_id,
						cat.showtags as showtags, cat.seolink as catseolink, u.nickname as author, u.login as user_login
				FROM cms_content con
				LEFT JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id				
				WHERE con.id = '$article_id' LIMIT 1";
 
		$result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
        $article = $this->inDB->fetch_assoc($result);
 
        $article = cmsCore::callEvent('GET_ARTICLE', $article);
 
        return $article;
 
    }
 
/* ==================================================================================================== */
/* ==================================================================================================== */
 
    public function getArticleByLink($seolink) {
 
		$sql = "SELECT con.*,
						cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.showtags as showtags,
						cat.modgrp_id, u.nickname as author, con.user_id as user_id, u.login as user_login
				FROM cms_content con
				LEFT JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id				
				WHERE con.seolink = '$seolink' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today' AND con.pubdate <= '$today')) LIMIT 1";
 
		$result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
        $article = $this->inDB->fetch_assoc($result);
 
        $article = cmsCore::callEvent('GET_ARTICLE', $article);
 
        return $article;
 
    }
 

 
    public function getArticle($article_id) {
		$today = date("Y-m-d H:i:s");
		$sql = "SELECT  con.*,
						cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.modgrp_id,
						cat.showtags as showtags, cat.seolink as catseolink, u.nickname as author, u.login as user_login, up.imageurl as avatar
				FROM cms_content con
				LEFT JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id
				LEFT JOIN cms_user_profiles up ON up.user_id = con.user_id
				WHERE con.id = '$article_id' LIMIT 1";
 
		$result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
        $article = $this->inDB->fetch_assoc($result);
 
        $article = cmsCore::callEvent('GET_ARTICLE', $article);
 
        return $article;
 
    }
 
/* ==================================================================================================== */
/* ==================================================================================================== */
 
    public function getArticleByLink($seolink) {
 
		$sql = "SELECT con.*,
						cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.showtags as showtags,
						cat.modgrp_id, u.nickname as author, con.user_id as user_id, u.login as user_login, up.imageurl as avatar
				FROM cms_content con
				LEFT JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id
				LEFT JOIN cms_user_profiles up ON up.user_id = con.user_id
				WHERE con.seolink = '$seolink' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today' AND con.pubdate <= '$today')) LIMIT 1";
 
		$result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
        $article = $this->inDB->fetch_assoc($result);
 
        $article = cmsCore::callEvent('GET_ARTICLE', $article);
 
        return $article;
 
    }
 

 
{* ======================= Заголовок статьи =============================== *}
<img src="/images/users/avatars/{$article.avatar}" border="0" style="float:left;margin-right:1em;width:64px;" />
{if $article.showtitle}
 
    <h1 class="con_heading">{$article.title}</h1>
{/if}