Файл: templates/default/pages/friends.tpl.php
Строк: 21
<?php
?>
<? $db = Simple::openDB();
   $db->query("SET NAMES utf8");
   
   //Определим, откуда стартовать
        if (isset($_GET['start'])) {
        $start = abs(intval($_GET['start']));
        } else {
        $start = 0;
        } 
        //Количество объявлений на страницу
        $kmess = 30;
   ?>
<div class="news">
    <div class="tnews">Друзья сайта</div>
    <a href="index.php?mod=pages&a=friends&d=add">Добавить сайт</a>
</div>
                                                    <?
   $q = $db->query("SELECT * FROM `friends` WHERE `mod` = '1'");
   $total = $q->num_rows;
                                                                                                     
    if ($total > 0) {
    if ($start >= $total) {
      $start = 0;
    } 
    $page = floor(1 + $start / $kmess);
    $queryusers = $db->query("SELECT * FROM `friends` WHERE `mod` = '1' ORDER BY `id` DESC LIMIT " . $start . ", " . $kmess . ";");
    while ($row = $queryusers->fetch_array(MYSQLI_ASSOC)) {
       
                                                
                                                    ?>
                                     
<div class="alink">
    <a href="<?=$row['http']?>">
        <div class="link"><?=$row['name']?>
            </div></a></div>
    
                                                    <? }
                                                    $navi = new navi();
                                                    $navi->page_strnavigation('index.php?mod=pages&a=friends&', $kmess, $start, $total);
                                                    
                                                    }else{
                                                        
                                                    ?>
                                                    
                                                    <div class="text">Пока сайтов нет...</div>
                                                    
                                                    <? } ?>