Hi
I modified news_cats.php, in a way that now all newsitems of a certain category are shown in a list just like on in news.php. See for an example
http://www.sckr.nl/v2.0/news_cats.php...?cat_id=19 i now want to add one more thing, namelij the bar which is visible under each newsitem in news.php
the bar with the name of the blogger, the timestamp, printicon etc.
however i don't manage to get it right on news_cats.php.
who can tell me how to fix this?
here is my code
Code][syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2010 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: news_cats.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."news_cats.php";
add_to_title($locale['global_200'].$locale['400']);
opentable($locale['400']);
if (isset($_GET['cat_id']) && isnum($_GET['cat_id'])) {
$res = 0;
$result = dbquery("SELECT news_cat_name FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET['cat_id']."'"
;
if (dbrows($result) || $_GET['cat_id'] == 0) {
$data = dbarray($result);
$rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$_GET['cat_id']."' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0'"
;
if ($rows) {
$res = 1;
echo "<!--pre_news_cat--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
if ($_GET['cat_id'] != 0) {
/* echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'><!--news_cat_image--><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' /><br /><br />\n"; */
/* echo "<strong>".$locale['401']."</strong> ".$data['news_cat_name']."<br />\n<strong>".$locale['402']."</strong> $rows</td>\n";
/* echo "<td class='tbl1' style='vertical-align:top'>\n"; */
} else {
echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'>".$locale['403']."<br />\n";
echo "<strong>".$locale['401']."</strong> $rows</td>\n<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";
}
$result2 = dbquery("SELECT news_id, news_subject,news_news,news_breaks FROM ".DB_NEWS." WHERE news_cat='".$_GET['cat_id']."' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0' ORDER BY news_datestamp DESC"
;
while ($data2 = dbarray($result2)) {
$news_news = $data2['news_breaks'] == "y" ? nl2br(stripslashes($data2['news_news'])) : stripslashes($data2['news_news']);
opentable($data2['news_subject']);
echo $news_news;
closetable();
}
/* Ivo removed here: echo "</td>\n</tr>\n<tr>\n<td colspan='2' class='tbl1' style='text-align:center'>".THEME_BULLET." <a href='".FUSION_SELF."'>".$locale['406']."</a>";*/
echo "</td>\n</tr>\n</table><!--sub_news_cat-->\n";
}
}
if (!$res) { redirect(FUSION_SELF); }
/* met de volgende code wordt de overzicht pagina van alle nieuws categorieen getoond */
} else {
$res = 0;
$result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." ORDER BY news_cat_id"
;
if (dbrows($result)) {
echo "<!--pre_news_cat_idx--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
while ($data = dbarray($result)) {
$rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0'"
;
echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'><!--news_cat_image--><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' /><br /><br />\n";
echo "<strong>".$locale['401']."</strong> ".$data['news_cat_name']."<br />\n<strong>".$locale['402']."</strong> $rows</td>\n";
echo "<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";
if ($rows) {
$result2 = dbquery("SELECT news_id, news_subject,news_breaks,news_news FROM ".DB_NEWS." WHERE news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10"
;
while ($data2 = dbarray($result2)) {
$news_news = $data2['news_breaks'] == "y" ? nl2br(stripslashes($data2['news_news'])) : stripslashes($data2['news_news']);
opentable("<a class='blue' href='news.php?readmore=".$data2['news_id']."'>".$data2['news_subject']."</a>"
;
/* blue is kleur van link naar nieuws in newcat overzicht van alle categorieen */
echo $news_news;
closetable();
}
if ($rows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=".$data['news_cat_id']."'>".$locale['405']."</a></div>\n"; }
} else {
echo THEME_BULLET." ".$locale['404']."\n";
}
echo "</td>\n</tr>\n";
}
$res = 1;
}
/* vanaf hier wordt alle niet categoriseerd nieuws getoond */
$result = dbquery("SELECT * FROM ".DB_NEWS." WHERE news_cat='0' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10"
;
if (dbrows($result)) {
if ($res == 0) { echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n"; }
$nrows = dbcount("(news_id)", DB_NEWS, "news_cat='0' AND ".groupaccess('news_visibility'
." AND (news_start='0'||news_start<=".time()."
AND (news_end='0'||news_end>=".time()."
AND news_draft='0'"
;
echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'>".$locale['403']."<br />\n";
echo "<strong>".$locale['402']."</strong> $nrows</td>\n<td class='tbl1' style='vertical-align:top'>\n";
while ($data = dbarray($result)) {
opentable("<a class='white' href='news.php?readmore=".$data['news_id']."'>".$data['news_subject']."</a>"
;
$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
echo $news_news;
closetable();
}
$res = 1;
if ($nrows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=0'>".$locale['405']."</a></div>\n"; }
echo "</td>\n</tr>\n";
}
if ($res == 1) {
echo "</table><!--sub_news_cat_idx-->\n";
} else {
echo "<div style='text-align:center'><br />\n".$locale['407']."<br /><br />\n</div>\n";
}
}
closetable();
require_once THEMES."templates/footer.php";
?>[/syntaxhighlighter]
code inserted into code tags, please use the code tags when posting code