<?php

    include "./system/common.php";
    include "./system/functions.php";
    include "./system/user.php";

    if ($user == false) {

        header("Location: /");
        exit;

    }

    $title = "Тумбочка";
    include "./system/h.php";

    $qualitySell = [
        1 => 280,
        2 => 1485,
        3 => 4860,
        4 => 10350,
        5 => 13320,
        6 => 16830,
        7 => 20520,
        8 => 27900,
        10 => 38250,
        11 => 51300
    ];

    if (isset($_GET["dress"])) {

        $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

        $id = isset($_GET["dress"]) && !empty($_GET["dress"]) ? intval($_GET["dress"]) : false;
        $inv = mysql_fetch_assoc(mysql_query("SELECT * FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `id` = '{$id}'"));
        if ($inv == false) {

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        $item = mysql_fetch_assoc(mysql_query("SELECT `w` FROM `items` WHERE `id` = '".$inv["item"]."'"));

        if ($user["level"] < $item["lvl"]) {

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        $oldItem = mysql_fetch_assoc(mysql_query("SELECT * FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '1' AND `id` = '{$user["w_{$item["w"]}"]}'"));

        $_SESSION["alert"] = "<div class=\"alert\">
        <div>
        <div class=\"color3\">
        <img src=\"/images/icons/equip.png\" width=\"16\" height=\"16\" alt=\"\"> Вещь успешно надета
        </div>
        <div class=\"a_separator\"></div>
        <span class=\"btn_start\">
        <span class=\"btn_end\">
        <a class=\"btn\" href=\"/equip\">Перейти в снаряжение</a>
        </span>
        </span>
        </div>
        </div>";

        if ($oldItem == false) {

            $bonus["str"] = $inv["_str"];
            $bonus["vit"] = $inv["_vit"];
            $bonus["def"] = $inv["_def"];

            mysql_query("UPDATE `users` SET `str` = `str` + '{$bonus["str"]}', `vit` = `vit` + '{$bonus["vit"]}', `def` = `def` + '{$bonus["def"]}', `w_{$item["w"]}` = '{$id}' WHERE `id` = '{$user["id"]}'");
            mysql_query("UPDATE `inv` SET `equip` = '1' WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `id` = '{$id}'");

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        } else {

            $bonus["str"] = ($inv["_str"] - $oldItem["_str"]);
            $bonus["vit"] = ($inv["_vit"] - $oldItem["_vit"]);
            $bonus["def"] = ($inv["_def"] - $oldItem["_def"]);

            mysql_query("UPDATE `users` SET `str` = `str` + '{$bonus["str"]}', `vit` = `vit` + '{$bonus["vit"]}', `def` = `def` + '{$bonus["def"]}', `w_{$item["w"]}` = '{$id}' WHERE `id` = '{$user["id"]}'");
            mysql_query("UPDATE `inv` SET `equip` = '0' WHERE `user` = '{$user["id"]}' AND `equip` = '1' AND `id` = '{$oldItem["id"]}'");
            mysql_query("UPDATE `inv` SET `equip` = '1' WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `id` = '{$id}'");

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

    }

    if (isset($_GET["sell"])) {

        $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

        $id = isset($_GET["sell"]) && !empty($_GET["sell"]) ? intval($_GET["sell"]) : false;
        $inv = mysql_fetch_assoc(mysql_query("SELECT `id`, `item` FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `id` = '{$id}'"));
        if ($inv == false) {

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        $item = mysql_fetch_assoc(mysql_query("SELECT * FROM `items` WHERE `id` = '{$inv["item"]}'"));
        $sell = $qualitySell[$item["quality"]];

        if (isset($_GET["yes"])) {

            mysql_query("DELETE FROM `inv` WHERE `id` = '{$id}' AND `user` = '{$user["id"]}' AND `equip` = '0'");
            mysql_query("UPDATE `users` SET `s` = `s` + {$sell} WHERE `id` = '{$user["id"]}'");

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        echo "<div class=\"content\">
        <div class=\"block center color3 s125\">
        <a href=\"/#\">{$item["name"]}</a>/ Продажа
        </div>
        <div class=\"line\"></div>
        <div class=\"block center red\">
        <div class=\"s125\">Вы уверены, что хотите продать \"{$item["name"]}\"?</div>
        </div>
        <div class=\"dotted\"></div>
        <div class=\"menu\">
        <li>
        <a href=\"?sell={$id}&yes".(($__page == true ? "&page={$__page}" : ""))."\">
        <img src=\"/images/icons/ok.png\" width=\"16\" height=\"16\" alt=\"\"> Да, продать
        </a>
        </li>
        <li>
        <a href=\"".(($__page == true ? "?page={$__page}" : "?"))."\">
        <img src=\"/images/icons/cross.png\" width=\"16\" height=\"16\" alt=\"\"> Нет, не продавать
        </a>
        </li>
        </div>
        </div>";

        include "./system/f.php";
        exit;

    }

    if (isset($_GET["sell_q"])) {

        $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

        $quality = isset($_GET["sell_q"]) && !empty($_GET["sell_q"]) ? intval($_GET["sell_q"]) : false;
        $sell_q_all = mysql_fetch_array(mysql_query("SELECT COUNT(`id`) FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `quality` = '{$quality}'"));
        if ($sell_q_all[0] == 0) {

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        $count_silver = ($sell_q_all[0] * $qualitySell[$quality]);

        if (isset($_GET["yes"])) {

            mysql_query("DELETE FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `quality` = '$quality'");
            mysql_query("UPDATE `users` SET `s` = `s` + '{$count_silver}' WHERE `id` = '{$user["id"]}'");

            header("Location: ?" . ($__page == true ? "page={$__page}" : ""));
            exit;

        }

        echo "<div class=\"content\">
        <div class=\"block center color3 s125\">
        <a href=\"?\">Тумбочка</a>/ Продать всё?
        </div>
        <div class=\"line\"></div>
        <div class=\"block center red\">
        <div class=\"s125\">Вы уверены, что хотите продать всё из выбранного качества? Отменить это действие будет невозможно!</div>
        </div>
        <div class=\"dotted\"></div>
        <div class=\"menu\">
        <li>
        <a href=\"?sell_q={$quality}&yes".(($__page == true ? "&page={$__page}" : ""))."\">
        <img src=\"/images/icons/ok.png\" width=\"16\" height=\"16\" alt=\"\"> Да, продать
        </a>
        </li>
        <li>
        <a href=\"".(($__page == true ? "?page={$__page}" : "?"))."\">
        <img src=\"/images/icons/cross.png\" width=\"16\" height=\"16\" alt=\"\"> Нет, не продавать
        </a>
        </li>
        </div>
        </div>";

        include "./system/f.php";
        exit;

    }

    $count = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM (SELECT COUNT(`id`) FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' GROUP BY `item`) t"));

    if (isset($_GET["pump"])) {

        $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

        $cost_silver= ($user["bag_place"] * 100);

        if ($user["s"] < $cost_silver) {

            $_SESSION["errors"] = "<div class=\"alert\">
            <div class=\"color1 s125\">Башли не канают</div>
            Не хватает еще <b> <img src=\"/images/icons/silver.png\" width=\"16\" height=\"16\" alt=\"\"> ".($cost_silver - $user["s"])."</b>
            <div class=\"a_separator\"></div>
            <span class=\"btn_start\">
            <span class=\"btn_end\">
            <a href=\"/pay\" class=\"btn\">Приобрести</a>
            </span>
            </span>
            </div>
            <div class=\"line\"></div>";

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        } elseif ($user["bag_place"] >= 500) {

            $_SESSION["errors"] = "<div class=\"alert\">
            <div class=\"color1 s125\">Башли не канают</div>
            Максимальное количество места в Тумбочке
            </div>
            <div class=\"line\"></div>";

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        $_SESSION["err"] = "<div class=\"alert\">
        <div>
        <div class=\"color3\">
        <img src=\"/images/icons/bag.png\" width=\"16\" height=\"16\" alt=\"\"> Тумбочка успешно расширена
        </div>
        <div class=\"a_separator\"></div>
        Вмещаемость: <b>+10 мест</b>
        <div class=\"m3\">
        Плотность: {$count[0]}/".($user["bag_place"] + 10)."
        </div>
        </div>
        </div>
        <div class=\"alert_bottom\"></div>";

        mysql_query("UPDATE `users` SET `bag_place` = `bag_place` + '10', `s` = `s` - '{$cost_silver}' WHERE `id` = '{$user["id"]}'");

        header("Location: ?");
        exit;

    }

    $silver = 0;

    for ($c = 1; $c <=14; $c++) {

        if ($c != 8) $all_quality = mysql_fetch_array(mysql_query("SELECT COUNT(`id`) FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0' AND `quality` = '{$c}'"));
        if ($all_quality == true) $silver += $all_quality[0] * $qualitySell[$c];

    }

    $count_silver_all = $silver;

    if (isset($_GET["sell_all"])) {

        $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

        if ($count_silver_all == 0) {

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        if (isset($_GET["yes"])) {

            mysql_query("UPDATE `users` SET `s` = `s` + '{$count_silver_all}' WHERE `id` = '{$user["id"]}'");
            mysql_query("DELETE FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '0'");

            header("Location: ?".($__page == true ? "page={$__page}" : ""));
            exit;

        }

        echo "<div class=\"content\">
        <div class=\"block center color3 s125\">
        <a href=\"?\">Тумбочка</a>/ Продать всё?
        </div>
        <div class=\"line\"></div>
        <div class=\"block center red\">
        <div class=\"s125\">Вы уверены, что хотите продать всё из тумбочки? Отменить это действие будет невозможно!</div>
        </div>
        <div class=\"dotted\"></div>
        <div class=\"menu\">
        <li>
        <a href=\"?sell_all&yes".(($__page == true ? "&page={$__page}" : ""))."\">
        <img src=\"/images/icons/ok.png\" width=\"16\" height=\"16\" alt=\"\"> Да, продать
        </a>
        </li>
        <li>
        <a href=\"".(($__page == true ? "?page={$__page}" : "?"))."\">
        <img src=\"/images/icons/cross.png\" width=\"16\" height=\"16\" alt=\"\"> Нет, не продавать
        </a>
        </li>
        </div>
        </div>";

        include "./system/f.php";
        exit;

    }

    if (isset($_SESSION["errors"]) or isset($_SESSION["alert"])) {

        echo isset($_SESSION["errors"]) ? $_SESSION["errors"] : isset($_SESSION["alert"]) ? $_SESSION["alert"] : false;
        unset($_SESSION["errors"], $_SESSION["alert"]);

    }

    echo "<div class=\"content\">
    <div class=\"block center color3 s125\">
    <a href=\"/profile\">{$user["login"]}</a>/ Тумбочка
    </div>
    <div class=\"line\"></div>";

    
    $max = 10;
    $pages = ceil($count[0]/$max);
    $page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim(intval($_GET["page"])) : 0;

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

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

    $__page = isset($_GET["page"]) && !empty($_GET["page"]) ? trim($_GET["page"]) : false;

    $q = mysql_query("SELECT * FROM `inv` WHERE `user` = '".$user["id"]."' AND `equip` = '0' GROUP BY `item` ORDER BY `id` ASC LIMIT '.$start.', '.$max.'");
    while ($row = mysql_fetch_array($q)) {

        $__item = mysql_fetch_array(mysql_query("SELECT * FROM `items` WHERE `id` = '".$row["item"]."'"));
        $amount_item = mysql_fetch_array(mysql_query("SELECT COUNT(`id`) FROM `inv` WHERE `user` = '".$user["id"]."' AND `equip` = '0' AND `item` = '".$row["item"]."'"));

        $__myFullBonus = mysql_fetch_array(mysql_query("SELECT SUM(`_str` + `_vit` + `_def`) FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '1' AND `id` = '{$user["w_{$__item["w"]}"]}' LIMIT 1"));
        $__itemBonus = mysql_fetch_array(mysql_query("SELECT SUM(`_str` + `_vit` + `_def`) FROM `shop` WHERE `id` = '{$__item["id"]}' LIMIT 1"));

        $__summaryMyBonus = trim($__myFullBonus[0] - $__itemBonus[0]);
        $__summaryItemBonus = trim($__itemBonus[0] - $__myFullBonus[0]);

        $__shop = mysql_fetch_array(mysql_query("SELECT `_vit`, `_str`, `_def` FROM `shop` WHERE `id` = '{$row["item"]}'"));

        $item_bonus["vit"] = $__shop["_vit"];
        $item_bonus["str"] = $__shop["_str"];
        $item_bonus["def"] = $__shop["_def"];

        $__w = mysql_fetch_array(mysql_query("SELECT * FROM `inv` WHERE `user` = '{$user["id"]}' AND `equip` = '1' AND `id` = '".$user["w_{$__item["w"]}"]."'"));
        $__wInv = mysql_fetch_array(mysql_query("SELECT `w` FROM `items` WHERE `id` = '{$__w["item"]}'"));

        echo "<div class=\"block\">
        <a href=\"#\">
        <img class=\"left mr8\" src=\"/images/items/{$__item["id"]}.jpg\" width=\"50\" alt=\"\">
        </a>
        <img src=\"/images/icons/equip.png\" width=\"16\" height=\"16\" alt=\"\">
        <a class=\"color-quality{$row["quality"]}\" href=\"#\"><span class=\"color-quality{$row["quality"]}\">{$__item["name"]}</span></a>
        <span class=\"white\">
        <img src=\"/images/icons/level.png\" width=\"16\" height=\"16\" alt=\"\"> ".($__item["lvl"] > $user["level"] ? "<span class=\"red\">{$__item["lvl"]} ур.</span>" : "{$__item["lvl"]} ур.")."
        </span>
        ".($__summaryMyBonus > $__summaryItemBonus ? "<span class=\"red small\">-{$__summaryMyBonus}</span>" : ($__summaryMyBonus < $__summaryItemBonus ? "<span class=\"color4 small\">+{$__summaryItemBonus}</span>"  : ""))."
        ".($amount_item[0] >= 2 ? "<span class=\"small color2\">, {$amount_item[0]} шт. </span>" : "")."
        <div>
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["vit"] < $__w["_vit"] ? "<span class=\"red\">" : ($item_bonus["vit"] > $__w["_vit"] ? "<span class=\"green\">" : "")) : false)."
        <img src=\"/images/icons/health.png\" width=\"16\" height=\"16\" alt=\"\"> ".nFormat($item_bonus["vit"])."
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["vit"] < $__w["_vit"] ? "</span>" : ($item_bonus["vit"] > $__w["_vit"] ? "</span>" : "")) : false)."
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["str"] < $__w["_str"] ? "<span class=\"red\">" : ($item_bonus["str"] > $__w["_str"] ? "<span class=\"green\">" : "")) : false)."
        <img src=\"/images/icons/damage.png\" width=\"16\" height=\"16\" alt=\"\"> ".nFormat($item_bonus["str"])."
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["str"] < $__w["_str"] ? "</span>" : ($item_bonus["str"] > $__w["_str"] ? "</span>" : "")) : false)."
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["def"] < $__w["_def"] ? "<span class=\"red\">" : ($item_bonus["def"] > $__w["_def"] ? "<span class=\"green\">" : "")) : false)."
        <img src=\"/images/icons/armor.png\" width=\"16\" height=\"16\" alt=\"\"> ".nFormat($item_bonus["def"])."
        ".($__item["w"] == $__wInv["w"] || $__wInv["w"] == false ? ($item_bonus["def"] < $__w["_def"] ? "</span>" : ($item_bonus["def"] > $__w["_def"] ? "</span>" : "")) : false)."
        <div class=\"clear\"></div>
        </div>
        </div>
        <div class=\"dotted\"></div>";

        if ($__item["lvl"] <= $user["level"]) {

            echo "<div class=\"block center\">
            <span class=\"btn_start\">
            <span class=\"btn_end\">
            <a class=\"btn\" href=\"?dress={$row["id"]}".(($__page == true ? "&page={$__page}" : ""))."\">Надеть шмотку</a>
            </span>
            </span>        
            </div>
            <div class=\"dotted\"></div>";

        }

        echo "<div class=\"block center\">
        <span class=\"btn_start\">
        <span class=\"btn_end\">
        <a class=\"btn\" href=\"?sell={$row["id"]}".(($__page == true ? "&page={$__page}" : ""))."\">Продать за <img src=\"/images/icons/silver.png\" width=\"16\" height=\"16\" alt=\"\"> {$qualitySell[$__item["quality"]]}</a>
        </span>
        </span>        
        </div>
        <div class=\"dotted\"></div>";

    }

    if ($count[0] == 0) {

        echo "<div class=\"block\">Здесь пусто</div>";

    }

    ?>

        <div class="dotted"></div>
        <ul class="pagination">
            <li class="next">
                <?=pages($sort.'?')?>
            </li>
        </ul>

    <?php

    echo "<div class=\"dotted\"></div>
    <ul class=\"block\">
    <li>Вмещаемость тумбочки: {$count[0]}/{$user["bag_place"]}</li>
    ".($user["bag_place"] < 500 ? "
    <li><img src=\"/images/icons/plus.png\" width=\"16\" height=\"16\" alt=\"\">
    <a href=\"?pump\">Увеличить вмещаемость</a> за
    <img src=\"/images/icons/silver.png\" width=\"16\" height=\"16\" alt=\"\"> ".($user["bag_place"] * 100)."
    </li>
    " : "
    <li>
    <span class=\"green\">
    Максимальное количество места
    </span>
    </li>
    ")."
    <li>
    Продать: ";
    
    for ($i = 1; $i <= 14; $i++) 
    if($i != 8) echo "<a href=\"?sell_q={$i}\"><img src=\"/images/quality/{$i}.png\" width=\"20\" height=\"20\" alt=\"\" style=\"border-radius: 80px;\"></a> ";

    echo "</li>
    </ul>
    <div class=\"dotted\"></div>
    <div class=\"menu\">
    <li>
    <a href=\"/inv/chest\"><img src=\"/images/icons/bag.png\" width=\"16\" height=\"16\" alt=\"\"> Показать сундуки</a>
    </li>
    </div>
    ".($count_silver_all != 0 ? "
    <div class=\"dotted\"></div>
    <div class=\"menu\">
    <li>
    <a href=\"?sell_all\">
    <img src=\"/images/icons/reward.png\" width=\"16\" height=\"16\" alt=\"\"> Продать всё за
    <img src=\"/images/icons/silver.png\" width=\"16\" height=\"16\" alt=\"\"> {$count_silver_all}
    </a>
    </li>
    </div>" : false)."
    </div>";

    include "./system/f.php";