Статистика, превью категорий - PHP-Fusion SF Russian Support Site

<?php

require_once "maincore.php";

require_once "subheader.php";

require_once "side_left.php";

include LOCALE.LOCALESET."articles.php";



if (!isset($cat_id)) {

	opentable($locale['400']);

	$result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE ".groupaccess('article_cat_access'." ORDER BY article_cat_name";

	$rows = dbrows($result);

	if ($rows != 0) {

		$counter = 0; $columns = 2;

		echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";

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

			if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";

			$num = dbcount("(article_cat)", "articles", "article_cat='".$data['article_cat_id']."'";

			echo "<td align='center' valign='top' width='50%'><b><a href='".FUSION_SELF."?cat_id=".$data['article_cat_id']."'><br>".$data['article_cat_name'].&q

uot;</a></b><span class='small2'>($num)</span>";

			if ($data['article_cat_description'] != "" echo "<br>\n<span class='small'>".$data['article_cat_description']."</span><br>";

			echo "</td>\n";

			$counter++;

		}

		echo "</tr>\n</table>\n";

	} else {

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

	}

	closetable();

} else {

	$res = 0;

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

	$result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE article_cat_id='$cat_id'";

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

		$cdata = dbarray($result);

		if (checkgroup($cdata['article_cat_access'])) {

			$res = 1;

			opentable($locale['400'].": ".$cdata['article_cat_name']);

			$rows = dbcount("(article_id)", "articles", "article_cat='$cat_id'";

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

			if ($rows != 0) {

				$result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='$cat_id' ORDER BY ".$cdata['article_cat_sorting']." LIMIT $rowstart,15";

				$numrows = dbrows($result); $i = 1;

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

					if ($data['article_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {

						$new = " <span class='small'>[".$locale['402']."]</span>";

					} else {

						$new = "";

					}

					echo "<b><a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a></b&

gt;$new<br>\n".stripslashes($data['article_snippet']);

				echo ($i != $numrows ? "<br><br>\n" : "\n"; $i++;

				}

				closetable();

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

			} else {

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

				closetable();

			}

		}

	}

	if ($res == 0) redirect(FUSION_SELF);

}





require_once "side_right.php";

require_once "footer.php";

?>

<tbody><tr><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=1" class="a2">Ремонт</a></b>

   <br>

   <a href="articles.php?cat_id=1"><img src="/images/1/remont.jpg" alt="Ремонт" style="margin: 3px;"></a>

   <br>

   <span class="small">Все для ремонта скутера. Ремонт своими руками...</span>

   <br>



  </td><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=6" class="a2">Советы</a></b>

   

   <br>

   <a href="articles.php?cat_id=6"><img src="/images/1/sovety.jpg" alt="Советы" style="margin: 3px;"></a>

   <br>

   <span class="small">Полезные советы скутеристу...</span>

   <br>



  </td></tr>

 <tr><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=3" class="a2">Стайлинг</a></b>

   

   <br>

   <a href="articles.php?cat_id=3"><img src="/images/1/stail.jpg" alt="Стайлинг" style="margin: 3px;"></a>

   <br>

   <span class="small">Красивее, стильнее. Стать по стайлингу скутера своими руками...</span>



   <br>

  </td><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=7" class="a2">Каталог скутеров</a></b>

   

   <br>

   <a href="articles.php?cat_id=7"><img src="/images/1/katalog.jpg" alt="Каталог скутеров" style="margin: 3px;"></a>

   <br>

   <span class="small">Характеристики и обзоры скутеров. Описание моделей...</span>



   <br>

  </td></tr>

 <tr><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=5" class="a2">Обслуживание</a></b>

   

   <br>

   <a href="articles.php?cat_id=5"><img src="/images/1/to.jpg" alt="Техническое обслуживание" style="margin: 3px;"></a>

   <br>

   <span class="small">Статьи по уходу за скутером...</span>



   <br>

  </td><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=2" class="a2">Тюнинг</a></b>

   

   <br>

   <a href="articles.php?cat_id=2"><img src="/images/1/tun.jpg" alt="Тюнинг" style="margin: 3px;"></a>

   <br>

   <span class="small">Тюнинг скутера своими руками...</span>



   <br>

  </td></tr>

 <tr><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=4" class="a2">Устройство</a></b>

   

   <br>

   <a href="articles.php?cat_id=4"><img src="/images/1/ustroy.jpg" alt="Устройство" style="margin: 3px;"></a>

   <br>

   <span class="small">Принцип работы основных узлов скутера...</span>

   

   <br>

 <tr><td align="center" valign="top" width="50%"><b><a href="articles.php?cat_id=8" class="a2">Электроника</a></b>

   

   <br>

   <a href="articles.php?cat_id=8"><img src="/images/1/el.jpg" alt="Электроника" style="margin: 3px;"></a>

   <br>

   <span class="small">Самодельные электронные устройства для скутера...</span>



   <br>

  </td>



   <br>

  </td></tr>

</tbody>