Make a new panel in the upper center or lower center with the following in the "Panel Code" box.
 Code//ORIGINAL CODE BY NICK JONES
//CODE FROM ARTICLES.PHP
//ADAPTED TO LIST IN PANEL BY skpacman
include LOCALE.LOCALESET."articles.php";
opentable($locale['400']);
echo "<!--pre_article_idx-->\n";
//$result = dbquery("SELECT article_cat_id, article_cat_name, article_cat_description FROM ".DB_ARTICLE_CATS." WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
// NEW QUERY
$result = dbquery(
"SELECT ac.article_cat_id, ac.article_cat_name, ac.article_cat_description, COUNT(a.article_cat) AS article_count FROM ".DB_ARTICLES." a
LEFT JOIN ".DB_ARTICLE_CATS." ac ON a.article_cat=ac.article_cat_id
WHERE ".groupaccess('ac.article_cat_access')."
GROUP BY ac.article_cat_id
ORDER BY ac.article_cat_name"
);
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }
//$num = dbcount("(article_cat)", DB_ARTICLES, "article_cat='".$data['article_cat_id']."' AND article_draft='0'");
echo "<td valign='top' width='50%' class='tbl article_idx_cat_name'><!--article_idx_cat_name--><a href='/articles.php?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a> <span class='small2'>(".$data['article_count'].")</span>";
if ($data['article_cat_description'] != "") { echo "<br />\n<span class='small'>".$data['article_cat_description']."</span>"; }
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<div style='text-align:center'><br />\n".$locale['401']."<br /><br />\n</div>\n";
}
echo "<!--sub_article_idx-->\n";
closetable();
in the box below it, add the following line:
Code /news.php
And click the "Include on these pages" radio button.
Save the panel, enable in panel admin and now you have a list of articles on your news page.
|
