GetName(playerid) // this is usefull
{
	new uName[MAX_PLAYER_NAME];
	GetPlayerName(playerid,uName,24);
	return uName;
}

public OnPlayerConnect(playerid)
{
	TogglePlayerSpectating(playerid, true);

//  MYSQL Checking if player has account.
    new query[128];
    mysql_format(mysql, query, sizeof(query), "SELECT `Password`, `Name` FROM `accounts` WHERE `Name` = '%e' LIMIT 1",GetName(playerid));
    mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
//  MYSQL Updating players account
    new query[128];
	mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `AdminLevel` = '%d' WHERE `Name` = '%e'",PlayerInfo[playerid][pAdminLevel],GetName(playerid));
	mysql_tquery(mysql, query, "", "");
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    switch(dialogid)
    {
        case LoginDialog:
        {
            if(!response) Kick(playerid);

            new hashpass[129], query[100];
            WP_Hash(hashpass, sizeof(hashpass), inputtext);
            if(!strcmp(hashpass, PlayerInfo[playerid][Password]))
            {
                mysql_format(mysql, query, sizeof(query), "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1",GetName(playerid));
                mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);
            }
            else
            {
                SendClientMessage(playerid, -1, "You have specified an incorrect password!");
                ShowPlayerDialog(playerid, LoginDialog, DIALOG_STYLE_INPUT, "Login", "Welcome player!\nYour account has been found in our database. Please fill in your password:", "Login", "Quit");
            }
        }
        case RegisterDialog:
        {
            if(!response) return Kick(playerid);
            if(strlen(inputtext) < 5)
            {
                SendClientMessage(playerid, -1, "Your password must at least contain more than 4 characters.");
                return ShowPlayerDialog(playerid, RegisterDialog, DIALOG_STYLE_INPUT, "Register", "Welcome player!\nYour account has not been registered yet. Please fill in your desired password:", "Register", "Quit");
            }
            new
                query[512];


            WP_Hash(PlayerInfo[playerid][Password], 129, inputtext);
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `AdminLevel`) VALUES ('%e', '%e', 0)",GetName(playerid), PlayerInfo[playerid][Password]);
            mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
        }
    }
    return 1;
}

public OnAccountLoad(playerid)
{
    PlayerInfo[playerid][pAdminLevel] = cache_get_field_content_int(0, "AdminLevel");
    TogglePlayerSpectating(playerid, false);
    SpawnPlayer(playerid);

    SendClientMessage(playerid, -1, "You have successfully logged in.");
    return 1;
}

public OnAccountCheck(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        cache_get_field_content(0, "Password", PlayerInfo[playerid][Password], mysql, 129);
        ShowPlayerDialog(playerid, LoginDialog, DIALOG_STYLE_INPUT, "Login", "Welcome player!\nYour account has been found in our database. Please fill in your password:", "Login", "Quit");
    }
    else
    {
        ShowPlayerDialog(playerid, RegisterDialog, DIALOG_STYLE_INPUT, "Register", "Welcome player!\nYour account has not been registered yet. Please fill in your desired password:", "Register", "Quit");
    }
    return 1;
}

public OnAccountRegister(playerid)
{
    printf("[Registration] New account registered.");
    TogglePlayerSpectating(playerid, false);
    SpawnPlayer(playerid);
    return 1;
}