View file testim.wmzo.ru/Modules/main.php

<?php
$title = 'TOP 100';
require_once ('Sys/head.php');

///////////////////////////// Новости
$news = $mysqli->query("SELECT * FROM `" . $prefix . "news` ORDER BY `time` DESC LIMIT " . $set['news_index'] . "");
while ($row = $news->fetch_assoc()) {
	$page_news = ceil($mysqli->query("SELECT COUNT(*) FROM `" . $prefix . "news` WHERE `id` = '" . $row['id'] . "'")->num_rows / $pageNews);
	echo '<div class="l1"><a href="http://' . $_SERVER['HTTP_HOST'] . '/m/news/' . $page_news . '"><font color="#696969"><b><span class="o">' . $row['name'] . '</span></b></font></a> [' . data($row['time']) . ']</div>';
	echo '<div class="li">';
	echo bbCodes(nl2br($row['text']));
	echo '<hr>';
	echo '<div id="left2">Доб: ' . $row['author'] . '</div>';
	echo '<div id="right2"><a href="http://' . $_SERVER['HTTP_HOST'] . '/m/news/comments/' . $row['id'] . '">Комментарии [' . $row['comments'] . ']</a></div>';
	echo '</div>';
}
//////////////////////////////////
$cat_all = $mysqli->query("SELECT `id` FROM `" . $prefix . "cat`")->num_rows;
$all = $mysqli->query("SELECT * FROM `" . $prefix . "sait` WHERE `status` = '1' AND `ban` = '0' AND `hosts` > '0' AND `category` != '21'")->num_rows;

/*
echo '
<div class="addbutton">
<a href="http://'.$_SERVER['HTTP_HOST'].'/m/registration"><span class="_add">+</span><b>Добавить сайт</b></a>
</div><!-- /.addbutton -->
';
*/
if ($all == 0) {
	echo '<div class="li">';
	echo 'Активных сайтов не найдено.<br/>';
	echo '</div>';
}
else {
	$total = intval(($all - 1) / $pageTop) + 1;
	$page = (isset ($_GET['page'])) ? abs(intval($_GET['page'])) : '';
	if (empty ($page) OR $page < 0) {
		$page = 1;
	}
	if ($page > $total) {
		$page = $total;
	}
	$past = intval($all / $pageTop);
	$start = $page * $pageTop - $pageTop;
	$top100 = $mysqli->query("SELECT `id`,`name`,`about`,`hosts`,`hits`,`in`,`out`,`url` FROM `" . $prefix . "sait` WHERE `status` = '1' AND `ban` = '0' AND `hosts` > '0' AND `category` != '21' ORDER BY `hosts` DESC LIMIT " . $start . "," . $pageTop . "");
	$idd = intval($_GET['id']);
	echo ($layoutType == 'mobile' ? '<div' : '<ul') . ' class="catalog">';
	while ($row = $top100->fetch_assoc()) {
		if ($row['id'] == $idd) {
			$u1 = '<u>';
			$u2 = '</u>';
		}
		else {
			$u1 = '';
			$u2 = '';
		}
		$start++;
		$online_site = $mysqli->query("SELECT * FROM `" . $prefix . "saitsOnline` WHERE `sid` = '" . $row['id'] . "' AND `time` > '" . ($time - 180) . "'")->num_rows;
		if ($layoutType == 'mobile') { //WAP
			echo '<div class="aa"><b>' . $start . '.</b> <a class="click" href="http://' . $_SERVER['HTTP_HOST'] . '/out/' . $row['id'] . '">
        <span>' . $u1 . '' . $row['url'] . '' . $u2 . '</span></a> <a class="stat" href="http://' . $_SERVER['HTTP_HOST'] . '/stats/' . $row['id'] . '"> &nbsp;('.$row['hosts'].'/'.$row['hits'].')</a>
        <p>' . $row['about'] . '</p>
        </div>';
		}
		else { /// WEB & PDA
			echo '<li>
        <a class="click" href="http://' . $_SERVER['HTTP_HOST'] . '/out/' . $row['id'] . '">
        <strong>' . $start . '</strong>
        <span>' . $u1 . '' . $row['url'] . '' . $u2 . '</span>  &nbsp;(' . $row['hosts'] . ')
        <p>' . $row['about'] . '</p></a>
        <a class="stat" href="http://' . $_SERVER['HTTP_HOST'] . '/stats/' . $row['id'] . '"><span>Статистика</span></a></li>';

/*
$online_site = $mysqli->query("SELECT * FROM `".$prefix."saitsOnline` WHERE `sid` = '".$row['id']."' AND `time` > '".($time-180)."'")->num_rows;
echo '<div class="li">[В топ: <strong>'.$row['in'].'</strong> | Из топа: <strong>'.$row['out'].'</strong> | <a href="/on_site/'.$row['id'].'">On: <b>'.$online_site.'</b></a>]';
echo '</div>';
*/
		}
	}
	$newSait = $mysqli->query("SELECT `id`,`name`,`about`,`status`,`ban`,`url` FROM `" . $prefix . "sait` WHERE `status` = '1' AND `ban` = '0' ORDER BY `regdate` DESC LIMIT 1");
	$nSait = $newSait->fetch_assoc();
    if ($layoutType == 'mobile') { //WAP
    $new = ($newSait->num_rows > 0)  ? '<div class="aa new"><a class="click" href="http://'.$_SERVER['HTTP_HOST'].'/stats/'.$nSait['id'].'"><img style="vertical-align: middle;" src="'.$home.'/new.gif" alt="Fire"/>&nbsp;<span>'.$nSait['url'].'</span></a></div>' : '';
    }
    else { /// WEB & PDA
    $new = ($newSait->num_rows > 0)  ? '<li class="new"><a class="click" href="http://'.$_SERVER['HTTP_HOST'].'/stats/'.$nSait['id'].'"><strong>New:</strong> <span>'.$nSait['url'].'</span><p>'.$nSait['about'].'</p></a> <a class="stat" href="http://'.$_SERVER['HTTP_HOST'].'/stats/'.$nSait['id'].'"><span>Статистика</span></a></li>' : '';
    }
    echo $new . ($layoutType == 'mobile' ? '</div>' : '</ul>');
	if ($all > $pageTop) {
		navigation($total, $page, 'http://' . $_SERVER['HTTP_HOST'] . '/');
	}
}

//////////////////////////////////
?>