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

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

			LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id

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

			ORDER BY news_sticky DESC, news_datestamp DESC LIMIT $rowstart,$items_per_page"

		);		

		$numrows = dbrows($result);

		if ($settings['news_style'] == "1") $nrows = round((dbrows($result) - 1) / 2);

		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_image']) {

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

			} else {

				$news_cat_image = "";

			}

 

include(INFUSIONS."brotator/brotator.php");