<?php
defined('WBCAT') or die('Restricted access');
echo '</div>
<div class="col-lg-3 col-md-3 col-sm-12 col-xs-12">';
	// Админский блок
            if ($allow) {
			    echo '<br class="visible-xs"><div class="zag_red">Управление</div>
                   <div class="title">
                   <a href="'.$home.'/?mod=create">Создать раздел</a><br/>';
             if($_SERVER['PHP_SELF'] == '/cat.php'){echo '<a href="'.$home.'/adm/edit.php?id='.$id.'">Редактировать</a><br/>
             	   <a href="'.$home.'/adm/del.php?id='.$id.'">Удалить</a><br/>';}
             echo '<a href="'.$home.'/adm/">Админка</a><br/>
                   <a href="'.$home.'/?mod=logout">Выйти</a></div><br/>';
                }
$all = mysql_result(mysql_query("SELECT COUNT(*) FROM `sites`;"), 0);
$active = mysql_result(mysql_query("SELECT COUNT(*) FROM `sites` WHERE type='1';"), 0);
$mod = mysql_result(mysql_query("SELECT COUNT(*) FROM `sites` WHERE type='0';"), 0);
$ban = mysql_result(mysql_query("SELECT COUNT(*) FROM `ban_site`;"), 0);
$review = mysql_result(mysql_query("SELECT COUNT(*) FROM `komm` WHERE `id_news`='0';"), 0);
$komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `komm` WHERE `id_site`='0';"), 0);
$view = mysql_result(mysql_query("SELECT MAX(`count`) FROM `sites` ;"), 0);
if ($view  >0 ) {
$site = mysql_result(mysql_query("SELECT `url` FROM `sites` WHERE `count` = '".$view."' LIMIT 1;"), 0);
}
$all_view = mysql_result(mysql_query("SELECT SUM(`count`) FROM `sites`;"), 0);
if($_SERVER['PHP_SELF'] != '/index.php'){$xs = 'hidden-xs hidden-sm';}else{$xs = '';}
echo '<div class="'.$xs.'">';
           	echo '<br class="visible-xs visible-sm"><div class="zag_green"><i class="fa fa-line-chart" aria-hidden="true"></i> Статистика каталога</div>
           	<div class="title">
            Всего сайтов: '.$all.'<br/>
            Активных: '.$active.'</br>
            На модерации: '.$mod.'<br/>
            Забанненых: '.$ban.'<br/>
            Отзывов: '.$review.'<br/>
            Комментариев: '.$komm.'<br/>
            Просмотров: '.$all_view.'<br/>
            </div>';
            $last = mysql_query("SELECT * FROM `sites` WHERE `type` = '1' ORDER BY id DESC LIMIT 3");
            echo '<br/><div class="zag_red"><i class="fa fa-clock-o" aria-hidden="true"></i> Последние сайты</div>';
            while($l = mysql_fetch_assoc($last)){
              echo '<div class="touch_red"><a href="/cat-'.$l['id_cat'].'/site-'.$l['id'].'.html" class="touch">'.$l['name'].'</a></div>';
            }
            $best = mysql_query("SELECT * FROM `sites` WHERE `type` = '1' ORDER BY rate DESC LIMIT 3");
            echo '<br/><div class="zag2"><i class="fa fa-star-o" aria-hidden="true"></i> Лучшие сайты</div>';
            while($b = mysql_fetch_assoc($best)){
              echo '<div class="touch_dark"><a href="/cat-'.$b['id_cat'].'/site-'.$b['id'].'.html" class="touch">'.$b['name'].' <span class="label label-success pull-right">'.$b['rate'].'</span></a></div>';
            }
echo '</div>';
echo '</div>
</div></div></div>';
echo '<style type="text/css">@media(max-width:700px){.banner IMG {display:block;width:100%;height:auto;}}</style>';
echo '<br>';
echo "<br/><div class='foot'>&copy <a href='/'>dbseo.ru</a> 2016";
?>
<span style="float:right">
    <!--LiveInternet counter-->
        <script type="text/javascript">
            document.write("<a href='//www.liveinternet.ru/click' "+
            "target=_blank><img src='//counter.yadro.ru/hit?t25.6;r"+
            escape(document.referrer)+((typeof(screen)=="undefined")?"":
            ";s"+screen.width+"*"+screen.height+"*"+(screen.colorDepth?
            screen.colorDepth:screen.pixelDepth))+";u"+escape(document.URL)+
            ";h"+escape(document.title.substring(0,150))+";"+Math.random()+
            "' alt='' title='LiveInternet: показано число посетителей за"+
            " сегодня' "+
            "border='0' width='88' height='15'><\/a>")
        </script>
    <!--/LiveInternet-->
    <small>gen <?=round(microtime(true) - $start_time,3); ?>
    |Online <?= $online_people; ?>
</span>
</div>

<script src="../themes/light/js/jquery.min.js"></script><script src="../themes/light/js/bootstrap.min.js"></script></body></html>
<?php
ob_end_flush();
?>