SRC_quotes

<?
if (!isset($_GET['ajax']) || $_GET['ajax'] != 1) {
    require_once "inc/top.php";
}
require_once "config.php";
require_once "func.php";
$query = mysql_query("SELECT * FROM `quotes` WHERE `status` = 'checked'");
if (mysql_num_rows($query) > 0) {
    if (!isset($_GET['id'])) {
        $query = mysql_query("SELECT * FROM `config`");
        $r     = mysql_fetch_array($query);
        $num   = $r['quotes_num'];
        if (!isset($_GET['page']) or empty($_GET['page']) or $_GET['page'] < 1)
            $_GET['page'] = 1;
        $page  = $_GET['page'];
        $query = mysql_query("SELECT * FROM `quotes` WHERE `status` = 'checked'");
        $posts = mysql_num_rows($query);
        $total = intval(($posts - 1) / $num) + 1;
        $page  = intval($page);
        if ($page > $total)
            $page = $total;
        $from  = $page * $num - $num;
        $query = mysql_query("SELECT * FROM `quotes` WHERE `status`= 'checked' ORDER BY `id` DESC LIMIT $from,$num");
        if ($query) {
            echo "<table width=500>";
            while ($r = mysql_fetch_array($query)) {
                echo showquote($r['id'], $r['content'], $r['moderator'], $r['date'], $r['rating']);
            }
            echo "</table><br><br>";
            $pervpage   = "";
            $nextpage   = "";
            $page2left  = "";
            $page1left  = "";
            $page2right = "";
            $page1right = "";
            if ($page != 1)
                $pervpage = "<a href=/page/1>в начало</a> <a href=/page/" . ($page - 1) . ">назад</a>";
            if ($page != $total)
                $nextpage = " <a href=/page/" . ($page + 1) . ">вперед</a> <a href=/page/" . $total . ">в конец</a>";
            if ($page - 2 > 0)
                $page2left = " <a href=/page/" . ($page - 2) . ">" . ($page - 2) . "</a> | ";
            if ($page - 1 > 0)
                $page1left = "<a href=/page/" . ($page - 1) . ">" . ($page - 1) . "</a> | ";
            if ($page + 2 <= $total)
                $page2right = " | <a href=/page/" . ($page + 2) . ">" . ($page + 2) . "</a>";
            if ($page + 1 <= $total)
                $page1right = " | <a href=/page/" . ($page + 1) . ">" . ($page + 1) . "</a>";
            echo "<div align=right>" . $pervpage . $page2left . $page1left . "<b>" . $page . "</b>" . $page1right . $page2right . $nextpage . "</div>";
        }
    } else {
        if (is_string($_GET['id'])) {
            if (preg_match("|^[\d]*$|", $_GET['id'])) {
                $ip    = getip();
                $id    = $_GET['id'];
                $query = mysql_query("SELECT * FROM `quotes` WHERE `id` = '$id' AND `status` = 'checked'");
                $r     = mysql_fetch_array($query);
                if (mysql_num_rows($query) > 0) {
                    if (isset($_GET['rating'])) {
                        if ($_GET['rating'] == "plus") {
                            $query = mysql_query("SELECT * FROM `logs` WHERE `qid` = '$id' AND `ip` = '$ip' AND `rating` = 'plus'");
                            if (mysql_num_rows($query) > 0) {
                                $msg = "Вы уже изменяли рейтинг данной цитаты";
                            } else {
                                $msg = modrate($id, $ip, "plus");
                            }
                        } elseif ($_GET['rating'] == "minus") {
                            $query = mysql_query("SELECT * FROM `logs` WHERE `qid` = '$id' AND `ip` = '$ip' AND `rating` = 'minus'");
                            if (mysql_num_rows($query) > 0) {
                                $msg = "Вы уже изменяли рейтинг данной цитаты";
                            } else {
                                $msg = modrate($id, $ip, "minus");
                            }
                        } else
                            $msg = "Неверный параметр для рейтинга";
                        if (isset($_GET['ajax']) && $_GET['ajax'] == 1) {
                            if (is_numeric($msg)) {
                                echo $msg;
                            } else {
                                echo (cp1251_to_utf8($msg));
                            }
                            die();
                        } else {
                            if (is_numeric($msg))
                                echo "Спасибо, рейтинг успешно изменен";
                            else
                                echo $msg;
                        }
                    } else {
                        echo "<table width=500>";
                        echo showquote($r['id'], $r['content'], $r['moderator'], $r['date'], $r['rating']);
                        echo "</table><br><br>";
                    }
                } else
                    echo "Цитата с таким id не найдена или еще не проверена.";
            } else
                echo "Неверный id.";
        } else
            echo "Неверный id.";
    }
} else
    echo "В базе данных отсутствуют цитаты.";
require_once "inc/bottom.php";
?>