<?php

/*---------------------------------------------------+

| <span style="border-bottom: 1px dotted black;">PHP</span>-Fusion 6 Content Management System

+----------------------------------------------------+

| Copyright © 2002 - 2005 Nick Jones

| <a href='http://www.php-fusion.co.uk/' target='_blank'><span style='color:005C5B'>http://www.php-fusion.co.uk/</span></a>

+----------------------------------------------------+

| Released under the terms & conditions of v2 of the

| GNU General Public License. For details refer to

| the included gpl.txt file or visit <a href='http://gnu.org' target='_blank'><span style='color:005C5B'>http://gnu.org</span></a>

+----------------------------------------------------*/

require_once "maincore.php";

require_once "subheader.php";

require_once "side_left.php";

 

if (!isset($readmore)) {

	$items_per_page = 10;

	if (isset($cat_id)) {

		$result = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='$cat_id'");

		if (dbrows($result) || $cat_id == 0) {

			$data = dbarray($result);

			$rows = dbcount("(news_id)", "news", "news_cat='$cat_id' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");

			$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='$cat_id' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC");

			//opentable("News Items in " .$data['news_cat_name']. " Category");

			//closetable();

		}

	} else {

		$result = dbquery(

			"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn

			LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id

			WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")

			ORDER BY news_datestamp DESC LIMIT $rowstart,$items_per_page"

		);

		$rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");

	}

	if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;

	if ($rows != 0) {

		$i = 1;

		$numrows = dbrows($result);

		while ($data = dbarray($result)) {

			$news_cat_image = "";

			$news_subject = "<a name='news_".$data['news_id']."' id='news_".$data['news_id']."'></a>".stripslashes($data['news_subject']);

			if ($data['news_cat'] != 0) {

				$result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");

				if (dbrows($result2)) {

					$data2 = dbarray($result2);

					$news_cat_image = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".IMAGES_NC.$data2['news_cat_image']."' alt='".$data2['news_cat_name']."' align='left' style='border:0px;margin-right:5px'></a>";

				}

			}

			$news_news = stripslashes($data['news_news']);

			if ($data['news_breaks'] == "y") $news_news = nl2br($news_news);

			if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;

			$news_info = array(

				"news_id" => $data['news_id'],

				"user_id" => $data['user_id'],

				"user_name" => $data['user_name'],

				"news_date" => $data['news_datestamp'], 

				"news_ext" => $data['news_extended'] ? "y" : "n",

				"news_reads" => $data['news_reads'],

				"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),

				"news_allow_comments" => $data['news_allow_comments']

			);

			render_news($news_subject, $news_news, $news_info);

			if ($i != $numrows) { tablebreak(); } $i++;

		}

		if ($rows > $items_per_page) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n</div>\n";

	} else {

		opentable($locale['046']);

		echo "<center><br>\n".$locale['047']."<br><br>\n</center>\n";

		closetable();

	}

} else {

	if (!isNum($readmore)) fallback(FUSION_SELF);

	include INCLUDES."comments_include.php";

	include INCLUDES."ratings_include.php";

	$result = dbquery(

		"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn

		LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id

		WHERE news_id='$readmore'"

	);

	if (dbrows($result)!=0) {

		$data = dbarray($result);

		if (checkgroup($data['news_visibility'])) {

			$news_cat_image = "";

			if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {

				 $result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$readmore'");

				 $data['news_reads']++;

			}

			$news_subject = $data['news_subject'];

			if ($data['news_cat'] != 0) {

				$result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");

				if (dbrows($result2)) {

					$data2 = dbarray($result2);

					$news_cat_image = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".IMAGES_NC.$data2['news_cat_image']."' alt='".$data2['news_cat_name']."' align='left' style='border:0px;margin-right:5px'></a>";

				}

			}

			$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);

			if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }

			if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;

			$news_info = array(

				"news_id" => $data['news_id'],

				"user_id" => $data['user_id'],

				"user_name" => $data['user_name'],

				"news_date" => $data['news_datestamp'],

				"news_ext" => "n",

				"news_reads" => $data['news_reads'],

				"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),

				"news_allow_comments" => $data['news_allow_comments']

			);

			render_news($news_subject, $news_news, $news_info);

			if ($data['news_allow_comments']) showcomments("N","news","news_id",$readmore,FUSION_SELF."?readmore=$readmore");

			if ($data['news_allow_ratings']) showratings("N",$readmore,FUSION_SELF."?readmore=$readmore");

		} else {

			redirect(FUSION_SELF);

		}

	} else {

		redirect(FUSION_SELF);

	}

}

 

require_once "side_right.php";

require_once "footer.php";

?>

Notice: Undefined variable: rowstart in /home/mantask/domains/burble.xe.lt/public_html/news_cats.php on line 33

You have an error in your SQL syntax; check the manual that corresponds to your <span style="border-bottom: 1px dotted black;">MySQL</span> server version for the right syntax to use near '10' at line 4Table 'mantask_php.news' doesn't exist

ORDER BY news_datestamp DESC LIMIT $rowstart,$items_per_page"