#include <a_samp>
#include <mysql>
#define SQL_HOST "HOST"
#define SQL_USER "USER"
#define SQL_PASS "PASSWORD"
#define SQL_DB "DATABASE"

#define COLOR_GRAD1 0xB4B5B7FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_GRAD3 0xCBCCCEFF
#define COLOR_GRAD4 0xD8D8D8FF
#define COLOR_GRAD5 0xE3E3E3FF
#define COLOR_GRAD6 0xF0F0F0FF
#define COLOR_GREY 0xAFAFAFAA
#define COLOR_GREEN 0x33AA33AA
#define COLOR_RED 0xAA3333AA
#define COLOR_LIGHTRED 0xFF6347AA
#define COLOR_LIGHTBLUE 0x33CCFFAA
#define COLOR_LIGHTGREEN 0x9ACD32AA
#define COLOR_YELLOW 0xFFFF00AA
#define COLOR_YELLOW2 0xF5DEB3AA
#define COLOR_WHITE 0xFFFFFFAA
#define COLOR_MAGENTA 0xFF00FFFF
#define COLOR_FADE1 0xE6E6E6E6
#define COLOR_FADE2 0xC8C8C8C8
#define COLOR_FADE3 0xAAAAAAAA
#define COLOR_FADE4 0x8C8C8C8C
#define COLOR_FADE5 0x6E6E6E6E
#define COLOR_PURPLE 0xC2A2DAAA
#define COLOR_DBLUE 0x2641FEAA
#define COLOR_ALLDEPT 0xFF8282AA
#define COLOR_NEWS 0xFFA500AA
#define COLOR_OOC 0xE0FFFFAA


new playername[MAX_PLAYERS];
new message[500];
forward ContinueLogin(playerid);
forward ClearChatbox(playerid);
public OnGameModeInit()
{
    mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB);

    AddStaticVehicle(596,1535.70483398,-1677.16125488,13.20281219,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(596,1535.75085449,-1667.09130859,13.20281219,180.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(596,1526.48278809,-1643.69128418,5.71062469,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(596,1530.41894531,-1644.20751953,5.71062469,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(596,1534.69519043,-1643.82495117,5.71062469,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(599,1546.00292969,-1650.62683105,6.27575159,270.00000000,-1,1); //Police Ranger
    AddStaticVehicle(599,1546.27221680,-1659.49011230,6.27575159,270.00000000,-1,1); //Police Ranger
    AddStaticVehicle(599,1546.63183594,-1667.44714355,6.27575159,270.00000000,-1,1); //Police Ranger
    AddStaticVehicle(427,1545.36462402,-1676.98181152,6.13862514,270.00000000,-1,1); //Enforcer
    AddStaticVehicle(427,1545.39001465,-1684.78588867,6.13862514,270.00000000,-1,1); //Enforcer
    AddStaticVehicle(523,1559.18896484,-1711.55224609,5.55100250,0.00000000,-1,1); //HPV1000
    AddStaticVehicle(523,1570.96154785,-1710.52270508,5.55100250,0.00000000,-1,1); //HPV1000
    AddStaticVehicle(523,1579.00646973,-1710.04772949,5.55100250,0.00000000,-1,1); //HPV1000
    AddStaticVehicle(596,1565.59521484,-1710.73254395,5.71062469,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(427,1574.89282227,-1710.42224121,6.13862514,180.00000000,-1,1); //Enforcer
    AddStaticVehicle(596,1590.94970703,-1710.38659668,5.71062469,0.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(596,1600.97814941,-1695.46960449,5.71062469,90.00000000,-1,1); //Police Car (LSPD)
    AddStaticVehicle(599,1600.80590820,-1683.59716797,6.27575159,90.00000000,-1,1); //Police Ranger

    return 1;
}

public OnPlayerConnect(playerid)
{
    GetPlayerName(playerid, playername[playerid], sizeof(playername));
    if (CheckAccount(playername[playerid]))
    {
        format(message, sizeof(message), "Dear %s,\nWelcome to ***!\nOur system detected that your character name is already registered.\nIf this is your account, you can login here!\n\nPassword:", playername[playerid]);
        ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT, "Welcome", message, "Login", "Quit");
    }
    else
    {
        format(message, sizeof(message), "Dear %s,\nWelcome to ***!\nOur system detected that your character name is not registered yet.\nIn order to play ***, please fill in the field below.\n\nPassword for your new account:", playername[playerid]);
        ShowPlayerDialog(playerid, 2, DIALOG_STYLE_INPUT, "Welcome", message, "Register", "Quit");
    }
    return 1;
}

stock CheckAccount(username[])
{
    new query[500];
    format(query, sizeof(query), "SELECT id FROM players WHERE username='%s'", username);
    mysql_query(query);
    mysql_store_result();
    if (mysql_num_rows() == 1)
    {
        mysql_free_result();
        return 1;
    }
    else
    {
        mysql_free_result();
        return 0;
    }
}

stock CheckPassword(username[], password[])
{
    new query[500];
    format(query, sizeof (query), "SELECT id FROM players WHERE username='%s' AND password='%s'", username, password);
    mysql_query(query);
    mysql_store_result();
    if (mysql_num_rows() == 1)
    {
        mysql_free_result();
        return 1;
    }
    else
    {
        mysql_free_result();
        return 0;
    }
}

stock CreateAccount(username[], password[])
{
    new query[500];
    format(query, sizeof (query), "INSERT INTO players (username, password, rank, money, status) VALUES ('%s', '%s', 1, 500, 1)", username, password);
    mysql_query(query);
}

public ContinueLogin(playerid)
{
    new data[200];
    new field[100][30];
    new query[200];
    format(query, sizeof (query), "SELECT px, py, pz FROM players WHERE id=2");
    mysql_query(query);
    mysql_store_result();
    while (mysql_fetch_row(data, "|"))
    {
        split(data, field, '|');
    }
    mysql_free_result();
    SpawnPlayer(playerid);
    SetPlayerPos(playerid, floatstr(field[0]), floatstr(field[1]), floatstr(field[2]));
    format(message, sizeof(message), "x: %s, y: %s, z:%s", field[0], field[1], field[2]);
    SendClientMessage(playerid, COLOR_RED, message);
    return 1;
}

public ClearChatbox(playerid)
{
    if (IsPlayerConnected(playerid))
    {
        for(new i=0; i<10; i++)
        {
            SendClientMessage(playerid, COLOR_RED, " ");
        }
    }
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if (dialogid == 1)
    {
        if (response)
        {
            if (CheckPassword(playername[playerid], inputtext))
            {
                ContinueLogin(playerid);
            }
            else
            {
                SendClientMessage(playerid, COLOR_RED, "Invalid login details! Please try again.");
                format(message, sizeof(message), "Dear %s,\nWelcome to *** v2.0!\nOur system detected that your character name is already registered.\nIf this is your account, you can login here!\n\nPassword:", playername[playerid]);
                ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT, "Welcome", message, "Login", "Quit");
            }
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, "You are now kicked from the server!");
            Kick(playerid);
        }
    }
    else if (dialogid == 2)
    {
        if (response)
        {
            if (strlen(inputtext) < 6)
            {
                SendClientMessage(playerid, COLOR_RED, "Registration failed! Your password has to got 6 or more characters!");
                format(message, sizeof(message), "Dear %s,\nWelcome to *** v2.0!\nOur system detected that your character name is not registered yet.\nIn order to play ***, please fill in the field below.\n\nPassword for your new account:", playername[playerid]);
                ShowPlayerDialog(playerid, 2, DIALOG_STYLE_INPUT, "Welcome", message, "Register", "Quit");
            }
            else
            {
                CreateAccount(playername[playerid], inputtext);
            }
        }
        else
        {
            Kick(playerid);
        }
    }
    return 1;
}

public OnPlayerDisconnect(playerid)
{
    new query[100];
    new Float:px;
    new Float:py;
    new Float:pz;
    GetPlayerPos(playerid, px, py, pz);
    format(query, sizeof (query), "UPDATE players SET px='%f', py='%f', pz='%f' WHERE id=2", px, py, pz);
    mysql_query(query);
    mysql_free_result();
    return 1;
}