<?php
require "Config.php";
$mode = $_POST['mode'];
$target = $_POST['target'];
$value = $_POST['value'];
$mail = $_POST['mail'];
$password = $_POST['password'];
$base = connect();
$user = $base->query("SELECT id FROM `Users` WHERE `email` = $mail AND `password` = $password");
if(!$user)
{
    error($base->error);
}
$user = $user->fetch_assoc();
if(count($user) === 0)
{
    error("Имя или пароль введены не верно");
}
$user = $user['id'];
switch ($target)
{
    case "NAME":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `username` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET":
            {
                $base->query("UPDATE `Users` SET `username` = $value WHERE `Users`.`id` = $user");
                break;
            }
        }
        break;
    }
    case "PASS":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `password` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET":
            {
                $base->query("UPDATE `Users` SET `password` = $value WHERE `Users`.`id` = $user");
                break;
            }
        }
        break;
    }
    case "ROLE":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `role` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET":
            {
                $base->query("UPDATE `Users` SET `role` = $value WHERE `Users`.`id` = $user");
                break;
            }
            case "ADD":
            {
                $base->query("UPDATE `Users` SET `role` = role+':'+$value WHERE `Users`.`id` = $user");
                break;
            }
        }
        break;
    }
    case "MAIL":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `email` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET": {
                $base->query("UPDATE `Users` SET `email` = $value WHERE `Users`.`id` = $user");
                break;
            }
        }
        break;
    }
    case "CONTACTS":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `contacts` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET":
            {
                $base->query("UPDATE `Users` SET `contacts` = $value WHERE `Users`.`id` = $user");
                break;
            }
            case "ADD":
            {
                $base->query("UPDATE `Users` SET `contacts` = contacts+':'+$value WHERE `Users`.`id` = $user");
                break;
            }
            case "REMOVE":
            {
                $result = $base->query("SELECT `contacts` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                $contacts = explode(":", $result['contacts']);
                $ret = "";
                foreach($contacts as $s)
                {
                    if($s !== $value)
                    {
                        $ret .= $s;
                    }
                }
                if($ret === $result['contacts'])
                {
                    echo "NOTFOUND";
                }
                else
                {
                    $base->query("UPDATE `Users` SET `contacts` = $ret WHERE `Users`.`id` = $user");
                    echo "SUCCES";
                }
            }
        }
        break;
    }
    case "ABOUT":
    {
        switch ($mode)
        {
            case "GET":
            {
                $result = $base->query("SELECT `about` FROM `Users` WHERE `id` = $user");
                if(!$result)
                {
                    error($base->error);
                }
                $result = $result->fetch_assoc();
                echo $result['username'];
                break;
            }
            case "SET":
            {
                $base->query("UPDATE `Users` SET `about` = $value WHERE `Users`.`id` = $user");
                break;
            }
        }
        break;
    }
}