<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 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 http://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&#91;'global_200'&#93;.$locale&#91;'400'&#93;);
if (iMEMBER) {
openside($locale&#91;'400'&#93;);
if (isset($_GET&#91;'cat_id'&#93;) && isnum($_GET&#91;'cat_id'&#93;)) {
	$res = 0;
	$result = dbquery("SELECT * FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET&#91;'cat_id'&#93;."'");
	if (dbrows($result) || $_GET&#91;'cat_id'&#93; == 0) {
		$data = dbarray($result);
		$rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$_GET&#91;'cat_id'&#93;."' 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&#91;'cat_id'&#93; != 0) {
				echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'><!--news_cat_image--><img src='".get_image("nc_".$data&#91;'news_cat_name'&#93;)."' alt='".$data&#91;'news_cat_name'&#93;."' /><br /><br />\n";
				echo "<strong>".$locale&#91;'401'&#93;."</strong> ".$data&#91;'news_cat_name'&#93;."<br />\n<strong>".$locale&#91;'402'&#93;."</strong> $rows</td>\n";
				echo "<td class='tbl1' style='vertical-align:top'>\n";
			} else {
				echo "</td>\n</tr>\n<tr>\n<td width='150' class='tbl1' style='vertical-align:top'>".$locale&#91;'403'&#93;."<br />\n";
				echo "<strong>".$locale&#91;'401'&#93;."</strong> $rows</td>\n<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";
			}
			$result2 = dbquery("SELECT * FROM ".DB_NEWS." WHERE news_cat='".$_GET&#91;'cat_id'&#93;."' 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)) {
 
if ($i == 0)
{
echo THEME_BULLET." <a href='news.php?readmore=".$data2&#91;'news_id'&#93;."' style='color:red;'>".$data2&#91;'news_subject'&#93;."</a><br />\n";
} else {
echo THEME_BULLET." <a href='news.php?readmore=".$data2&#91;'news_id'&#93;."'>".$data2&#91;'news_subject'&#93;."</a><br />\n";
}
 
            $i++;
            }
			echo "</td>\n</tr>\n<tr>\n<td colspan='2' class='tbl1' style='text-align:center'>".THEME_BULLET." <a href='".FUSION_SELF."'>".$locale&#91;'406'&#93;."</a>";
			echo "</td>\n</tr>\n</table><!--sub_news_cat-->\n";
		}
	}
	if (!$res) { redirect(FUSION_SELF); }
} else {
	$res = 0;
	$result = dbquery("SELECT * 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&#91;'news_cat_id'&#93;."' 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&#91;'news_cat_name'&#93;)."' alt='".$data&#91;'news_cat_name'&#93;."' /><br /><br />\n";
			echo "<strong>".$locale&#91;'401'&#93;."</strong> ".$data&#91;'news_cat_name'&#93;."<br />\n<strong>".$locale&#91;'402'&#93;."</strong> $rows</td>\n";
			echo "<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";
			if ($rows) {
	  $result2 = dbquery("SELECT *, IF(news_datestamp>'".$lastvisited."',1,0) AS new FROM ".DB_NEWS." WHERE news_cat='".$data&#91;'news_cat_id'&#93;."' 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)) {
               echo THEME_BULLET." <a href='news.php?readmore=".$data2&#91;'news_id'&#93;."'>".$data2&#91;'news_subject'&#93;."</a> ".($data2&#91;'new'&#93; == '1' ? "<span style='color:#ff0000'>NEW!</span>" : "")."<br />\n";
            }
				if ($rows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=".$data&#91;'news_cat_id'&#93;."'>".$locale&#91;'405'&#93;."</a></div>\n"; }
			} else {
				echo THEME_BULLET." ".$locale&#91;'404'&#93;."\n";
			}
			echo "</td>\n</tr>\n";
		}
		$res = 1;
	}
  $result = dbquery("SELECT *, IF(news_datestamp>'".$lastvisited."',1,0) AS new 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&#91;'403'&#93;."<br />\n";
      echo "<strong>".$locale&#91;'402'&#93;."</strong> $nrows</td>\n<td class='tbl1' style='vertical-align:top'>\n";
      while ($data = dbarray($result)) {
         echo THEME_BULLET." <a href='news.php?readmore=".$data&#91;'news_id'&#93;."' title='".$data&#91;'news_news'&#93;."' class='tooltip'>".$data&#91;'news_subject'&#93;."</a> ".($data&#91;'new'&#93; == '1' ? "<span style='color:#ff0000'>NEW!</span>" : "")."<br />\n";
      }
$i++;
            }
 
		$res = 1;
		if ($nrows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=0'>".$locale&#91;'405'&#93;."</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&#91;'407'&#93;."<br /><br />\n</div>\n";
	}
}
closeside();
 
require_once "login.php";
require_once THEMES."templates/footer.php";
?>
Zinterpretowano w sekund: 0.031, wykorzystano GeSHi 1.0.8.10