Example #1
0
				<h3>RSS Feeds</h3>
					<ul>
						<?php 
rss_links();
?>
					</ul>
				<?php 
extra();
?>
			</div>

			<div class="single">
				<h3>New Posts</h3>
					<ul>
						<?php 
menu_articles(0, 10);
?>
					</ul>
				<h3>New Comments</h3>
					<ul>
						<?php 
new_comments(5, 30);
?>
					</ul>
			</div>
		</div>
	</div>
	<div id="footer">
		<p>This site is powered by <a href="http://snewscms.com/" title="sNews CMS" onclick="target='_blank';">sNews</a> | <?php 
login_link();
?>
Example #2
0
function articles()
{
    global $categorySEF, $subcatSEF, $articleSEF, $_ID, $_POS, $_catID, $_XNAME;
    $frontpage = s('display_page');
    $title_not_found = '<h2>' . l('none_yet') . '</h2>';
    if (_ADMIN) {
        $visible = '';
        $title_not_found .= '<p>' . l('create_new') . '
			<a href="' . _SITE . 'administration/" title="' . l('administration') . '">' . l('administration') . '</a></p>';
    } else {
        $visible = ' AND a.visible=\'YES\' ';
    }
    if ($_ID || !$_catID && $frontpage != 0) {
        if (!$_ID) {
            $_ID = $frontpage;
        }
        // article or page, id as indentifier
        $query_articles = 'SELECT
					a.id AS aid,title,a.seftitle AS asef,text,a.date,
					a.displaytitle,a.displayinfo,a.commentable,a.visible
				FROM  ' . _PRE . 'articles' . ' AS a
				WHERE id =' . $_ID . $visible;
    } else {
        if (s('display_pagination') == 'on') {
            $on = true;
        } else {
            $on = false;
        }
        if ($on == true) {
            if ($articleSEF) {
                $SEF = $articleSEF;
            } elseif ($subcatSEF) {
                $SEF = $subcatSEF;
            } else {
                $SEF = $categorySEF;
            }
            // pagination
            $currentPage = strpos($SEF, l('paginator')) === 0 ? str_replace(l('paginator'), '', $SEF) : '';
            if ($_catID) {
                $count = 'SELECT COUNT(a.id) AS num
					FROM  ' . _PRE . 'articles' . ' AS a
					WHERE position = 1
						AND a.published =1
						AND category = ' . $_catID . $visible . '
						GROUP BY category';
            } else {
                $count = 'SELECT COUNT(a.id) AS num
					FROM ' . _PRE . 'articles' . ' AS a
					LEFT OUTER JOIN ' . _PRE . 'categories' . ' as c
						ON category = c.id
					LEFT OUTER JOIN ' . _PRE . 'categories' . ' as x
						ON c.subcat =  x.id AND (x.published =\'YES\')
					WHERE show_on_home = \'YES\' ' . $visible . '
						AND position = 1
						AND a.published =1
						AND c.published =\'YES\'
					GROUP BY show_on_home';
            }
            $count = mysql_query($count);
            if ($count) {
                $r = mysql_fetch_array($count);
                $num = $r['num'];
            }
        }
        if ($num === 0) {
            echo $title_not_found;
        } else {
            $articleCount = s('article_limit');
            $article_limit = empty($articleCount) || $articleCount < 1 ? 100 : $articleCount;
            $totalPages = ceil($num / $article_limit);
            if (!isset($currentPage) || !is_numeric($currentPage) || $currentPage < 1) {
                $currentPage = 1;
            }
            // get the rows for category
            if ($_catID) {
                $query_articles = 'SELECT
						a.id AS aid,title,a.seftitle AS asef,text,a.date,
						a.displaytitle,a.displayinfo,a.commentable,a.visible
				FROM ' . _PRE . 'articles' . ' AS a
				WHERE position = 1
					AND a.published =1
					AND category = ' . $_catID . $visible . '
				ORDER BY artorder ASC,date DESC
				LIMIT ' . ($currentPage - 1) * $article_limit . ',' . $article_limit;
            } else {
                $query_articles = 'SELECT
						a.id AS aid,title,a.seftitle AS asef,text,a.date,
							displaytitle,displayinfo,commentable,a.visible,
						c.name AS name,c.seftitle AS csef,
						x.name AS xname,x.seftitle AS xsef
					FROM ' . _PRE . 'articles' . ' AS a
					LEFT OUTER JOIN ' . _PRE . 'categories' . ' as c
						ON category = c.id
					LEFT OUTER JOIN ' . _PRE . 'categories' . ' as x
						ON c.subcat =  x.id AND x.published =\'YES\'
					WHERE show_on_home = \'YES\'
						AND position = 1
						AND a.published =1
						AND c.published =\'YES\'' . $visible . '
					ORDER BY date DESC
					LIMIT ' . ($currentPage - 1) * $article_limit . ',' . $article_limit;
            }
        }
    }
    $result = mysql_query($query_articles);
    $numrows = mysql_num_rows($result);
    if (!$result || !$numrows) {
        if (_ADMIN) {
            echo $title_not_found;
        }
        echo '<ul class="vertical">';
        menu_articles(0, 10, 1);
        echo '</ul>';
    } else {
        $link = '<a href="' . _SITE;
        while ($r = mysql_fetch_array($result)) {
            $infoline = $r['displayinfo'] == 'YES' ? true : false;
            $text = stripslashes($r['text']);
            if (!empty($currentPage)) {
                $short_display = strpos($text, '[break]');
                $shorten = $short_display == 0 ? 9999000 : $short_display;
            } else {
                $shorten = 9999000;
            }
            $comments_query = 'SELECT id FROM ' . _PRE . 'comments' . '
				WHERE articleid = ' . $r['aid'] . ' AND approved = \'True\'';
            $comments_result = mysql_query($comments_query);
            $comments_num = mysql_num_rows($comments_result);
            $a_date_format = date(s('date_format'), strtotime($r['date']));
            if ($r['csef']) {
                $uri = $r['xsef'] ? $r['xsef'] . '/' . $r['csef'] : $r['csef'];
            } elseif ($_XNAME) {
                $uri = $categorySEF . '/' . $subcatSEF;
            } else {
                $uri = $categorySEF;
            }
            $title = $r['title'];
            if ($r['displaytitle'] == 'YES') {
                if (!$_ID) {
                    echo '<h2 class="big">' . $link . $uri . '/' . $r['asef'] . '/">' . $title . '</a></h2>';
                } else {
                    echo '<h2>' . $title . '</h2>';
                }
            }
            file_include(str_replace('[break]', '', $text), $shorten);
            $commentable = $r['commentable'];
            $visiblity = $r['visible'] == 'YES' ? '<a href="' . _SITE . '?action=process&amp;task=hide&amp;item=snews_articles&amp;id=' . $r['aid'] . '&amp;back=' . $uri . '">' . l('hide') . '</a>' : l('hidden') . ' ( <a href="' . _SITE . '?action=process&amp;task=show&amp;item=snews_articles&amp;id=' . $r['aid'] . '&amp;back=' . $uri . '">' . l('show') . '</a> )';
            $edit_link = $link . '?action=admin_article&amp;id=' . $r['aid'] . '" title="' . $title . '">' . l('edit') . '</a> ';
            $edit_link .= ' ' . l('divider') . ' ' . $visiblity;
            if (!empty($currentPage)) {
                if ($infoline == true) {
                    $tag = explode(',', tags('infoline'));
                    foreach ($tag as $tag) {
                        switch (true) {
                            case $tag == 'date':
                                echo $a_date_format;
                                break;
                            case $tag == 'readmore' && strlen($r['text']) > $shorten:
                                echo $link . $uri . '/' . $r['asef'] . '/">' . l('read_more') . '</a> ';
                                break;
                            case $tag == 'comments' && ($commentable == 'YES' || $commentable == 'FREEZ'):
                                echo $link . $uri . '/' . $r['asef'] . '/#' . l('comment') . '1">
								' . l('comments') . ' (' . $comments_num . ')</a> ';
                                break;
                            case $tag == 'edit' && _ADMIN:
                                echo ' ' . $edit_link;
                                break;
                            case $tag != 'readmore' && $tag != 'comments' && $tag != 'edit':
                                echo $tag;
                                break;
                        }
                    }
                } else {
                    if (_ADMIN) {
                        echo '<p>' . $edit_link . '</p>';
                    }
                }
            } else {
                if (empty($currentPage)) {
                    if ($infoline == true) {
                        $tag = explode(',', tags('infoline'));
                        foreach ($tag as $tag) {
                            switch ($tag) {
                                case 'date':
                                    echo $a_date_format;
                                    break;
                                case 'readmore':
                                case 'comments':
                                    break;
                                case 'edit':
                                    if (_ADMIN) {
                                        echo ' ' . $edit_link;
                                    }
                                    break;
                                default:
                                    echo $tag;
                            }
                        }
                    } else {
                        if (_ADMIN) {
                            echo '<p>' . $edit_link . '</p>';
                        }
                    }
                }
            }
        }
        if (!empty($currentPage) && $num > $article_limit && $on) {
            paginator($currentPage, $totalPages, l('paginator'));
        }
        if (!empty($_POS) && empty($currentPage) && $infoline == true) {
            if ($commentable == 'YES') {
                comment('unfreezed');
            } else {
                if ($commentable == 'FREEZ') {
                    comment('freezed');
                }
            }
        }
    }
}