<?php

    include "./system/common.php";
    include "./system/functions.php";
    include "./system/user.php";
    
    if($user == false || $user["id"] != 1 && $user['login'] != 'xmaqu'){

        header("Location: /");
        exit;

    }
    
    function time_a($time){
$sec = time()-$time;
if($sec < 60) $_time = $sec." сек. назад";
if($sec >= 60 && $sec < (60*60)) $_time = round($sec/60)." мин. назад";
if($sec >= (60*60) && $sec < ((60*60)*6))$_time = "Сегодня в ".date("H:i",$time);
if($sec >= ((60*60)*6) && $sec < ((60*60)*12)) $_time = "Сегодня в ".date("H:i",$time);
if($sec >= ((60*60)*12) && $sec < (((60*60)*24)*2)) $_time = "Вчера в ".date("H:i",$time);
if($sec >= (((60*60)*12)*2)){
$__time = date("d F Y в H:i", $time);
$__time = str_replace("January","января",$__time);
$__time = str_replace("February","февраля",$__time);
$__time = str_replace("March","марта",$__time);
$__time = str_replace("April","апреля",$__time);
$__time = str_replace("May","мая",$__time);
$__time = str_replace("June","июня",$__time);
$__time = str_replace("July","июля",$__time);
$__time = str_replace("August","августа",$__time);
$__time = str_replace("September","сентября",$__time);
$__time = str_replace("October","октября",$__time);
$__time = str_replace("November","ноября",$__time);
$__time = str_replace("December","декабря",$__time);
$_time = $__time;
}
return $_time;
}

    $title = "Шпион маляв";
    include "./system/h.php";

    echo "<div class=\"content\">
    <div class=\"block center s125 color3\">Шпион маляв</div>
    <div class=\"line\"></div>";

    $max = 10;
    $count = mysql_fetch_array(mysql_query("SELECT COUNT(`id`) FROM `mail`"));
    $pages = ceil($count[0]/$max);
    $page = trim($_GET["page"]);

    if($page > $pages) $page = $pages;
    if($page < 1) $page = 1;

    $start = $page * $max - $max;

    if($count[0] > 0){

        $query = mysql_query("SELECT * FROM `mail` ORDER BY `time` DESC LIMIT $start, $max");
        while($row = mysql_fetch_assoc($query)){

            $from = mysql_fetch_assoc(mysql_query('SELECT `login` FROM `users` WHERE `id` = '.$row['from']));
            $to   = mysql_fetch_assoc(mysql_query('SELECT `login` FROM `users` WHERE `id` = '.$row['to']));

            echo "<div class=\"block\">
            <div>
            Кто: <a href=\"/profile/{$row['from']}\">{$from['login']}</a>
            </div>
            <div>
            Кому: <a href=\"/profile/{$row['to']}\">{$to['login']}</a>
            </div>
            <div>
            Сообщение: <span class=\"blue\">".smiles($row["text"])."</span>
            </div>
            <span class=\"color2 small\">Время отправки: ".time_a($row["time"])."</span>
            </div>
            <div class=\"dotted\"></div>";

        }

        ?>
            <ul class="pagination"><?=pages("?")?></ul>
        <?

    }else{

        echo "<div class=\"block\">Нет маляв</div>";
    
    }

    echo "</div>";

    include "./system/f.php";