Hi i modified news_cats.php and now the page shows a table at the end of the page, which I can't get removed.
Who can tell me what I did wrong, so I can remove this table?
here is my 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]