#include <a_samp>
#include <mysql>

//==========MySLQ Defines==========

#define SQL_HOST "184.82.169.84"
#define SQL_USER "1393_main "
#define SQL_PASS "fatlard"
#define SQL_DB   "1393_main "

//=======Server Setting Defines======
#define DIALOG_LOGIN      100
#define DIALOG_REGISTER   101
#define SERVERNAME        "Server"
//=====Colors====
#define cGREEN           0x33AA33AA
#define cRED             0xAA3333AA
#define cYELLOW          0xFFFF00AA
#define cLIGHTBLUE       0x33CCFFAA
#define cORANGE          0xFF9900AA

enum pInfo
{
    Id,
    username[25],
    Password[50],
    Money,
    Score,
    PlayerIP[20],
}


new PlayerInfo[MAX_PLAYERS][pInfo];

main()
{
    print("\n----------------------------------");
    print(" Blank Gamemode by your name here");
    print("----------------------------------\n");
}

public OnGameModeInit()
{
    SetGameModeText("Server");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    return 1;
}

InitMysqlConnection( );

stock InitMysqlConnection()
{
        mysql_init(LOG_ONLY_ERRORS, 1);
        mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DB);
}

public OnPlayerConnect(playerid)
{
if(CheckUser(playerid))
{
    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, SERVERNAME, "Please enter your password to login", "Login", "Cancel");
}


else
{
    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, SERVERNAME, "Please enter a password to register", "Register", "Cancel");
}
}

//========Dialogs=======

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if(dialogid == DIALOG_LOGIN)
    {
        if(CheckUserLogin(playerid,inputtext))
        {
            LoginUser(playerid);
        }
        else
        {
         Kick(playerid);
         }
    }
    if(dialogid == DIALOG_REGISTER && response)
            {
                    if(strlen(inputtext) >= 3 && strlen(inputtext) <= 15)
                    {
                            CreateUser(playerid, inputtext);
                    }
                    else
                    {
                            SendClientMessage(playerid, cYELLOW, "Password has to contain between 3 and 15 letters / numbers.");
                            ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, SERVERNAME, "Please insert a password with between 3 and 15 characters!", "Register", "Cancel");
                    }
                    return 1;
            }

    return 0;
}

//======= Stocks========
stock GetName(playerid)
{
    new pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));
    return pName;
}

stock CheckUser(playerid)
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';",GetName(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock LoginUser(playerid)
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';",GetName(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_fetch_row(Query,"|")) {
        sscanf(Query, "p<|>e<is[25]s[50]s[8]iiiiiiiiiiiiis[100]iii>", PlayerInfo[playerid]);
    }
    //PlayerInfo[playerid][LoggedIn] = 1;
    GivePlayerMoney(playerid, PlayerInfo[playerid][Money]);
    SetPlayerScore(playerid, PlayerInfo[playerid][Score]);
    SendClientMessage(playerid, cGREEN, "Successfully logged in.");
    GetPlayerIp(playerid, PlayerInfo[playerid][PlayerIP], 20);
}

stock CheckUserLogin(playerid, password[])
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s' AND password = MD5('%s');",GetName(playerid), password);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock CreateUser(playerid, password[])
{
    new Query[200]; format(Query, sizeof(Query), "INSERT INTO users (id, username, password, ip) VALUES (NULL, '%s', MD5('%s'), '%s');",GetName(playerid), password, PlayerInfo[playerid][PlayerIP]);
    mysql_query(Query);
    SendClientMessage(playerid, cYELLOW, "Account created, you should be logged in any second now.");
    LoginUser(playerid);
}
//=======sscanf=======
stock sscanf(string[], format[], {Float,_}:...)
{
    #if defined isnull
        if (isnull(string))
    #else
        if (string[0] == 0 || (string[0] == 1 && string[1] == 0))
    #endif
        {
            return format[0];
        }
    #pragma tabsize 4
    new
        formatPos = 0,
        stringPos = 0,
        paramPos = 2,
        paramCount = numargs(),
        delim = ' ';
    while (string[stringPos] && string[stringPos] <= ' ')
    {
        stringPos++;
    }
    while (paramPos < paramCount && string[stringPos])
    {
        switch (format[formatPos++])
        {
            case '\0':
            {
                return 0;
            }
            case 'i', 'd':
            {
                new
                    neg = 1,
                    num = 0,
                    ch = string[stringPos];
                if (ch == '-')
                {
                    neg = -1;
                    ch = string[++stringPos];
                }
                do
                {
                    stringPos++;
                    if ('0' <= ch <= '9')
                    {
                        num = (num * 10) + (ch - '0');
                    }
                    else
                    {
                        return -1;
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num * neg);
            }
            case 'h', 'x':
            {
                new
                    num = 0,
                    ch = string[stringPos];
                do
                {
                    stringPos++;
                    switch (ch)
                    {
                        case 'x', 'X':
                        {
                            num = 0;
                            continue;
                        }
                        case '0' .. '9':
                        {
                            num = (num << 4) | (ch - '0');
                        }
                        case 'a' .. 'f':
                        {
                            num = (num << 4) | (ch - ('a' - 10));
                        }
                        case 'A' .. 'F':
                        {
                            num = (num << 4) | (ch - ('A' - 10));
                        }
                        default:
                        {
                            return -1;
                        }
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num);
            }
            case 'c':
            {
                setarg(paramPos, 0, string[stringPos++]);
            }
            case 'f':
            {

                new changestr[16], changepos = 0, strpos = stringPos;
                while(changepos < 16 && string[strpos] && string[strpos] != delim)
                {
                    changestr[changepos++] = string[strpos++];
                    }
                changestr[changepos] = '\0';
                setarg(paramPos,0,_:floatstr(changestr));
            }
            case 'p':
            {
                delim = format[formatPos++];
                continue;
            }
            case '\'':
            {
                new
                    end = formatPos - 1,
                    ch;
                while ((ch = format[++end]) && ch != '\'') {}
                if (!ch)
                {
                    return -1;
                }
                format[end] = '\0';
                if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1)
                {
                    if (format[end + 1])
                    {
                        return -1;
                    }
                    return 0;
                }
                format[end] = '\'';
                stringPos = ch + (end - formatPos);
                formatPos = end + 1;
            }
            case 'u':
            {
                new
                    end = stringPos - 1,
                    id = 0,
                    bool:num = true,
                    ch;
                while ((ch = string[++end]) && ch != delim)
                {
                    if (num)
                    {
                        if ('0' <= ch <= '9')
                        {
                            id = (id * 10) + (ch - '0');
                        }
                        else
                        {
                            num = false;
                        }
                    }
                }
                if (num && IsPlayerConnected(id))
                {
                    setarg(paramPos, 0, id);
                }
                else
                {
                    #if !defined foreach
                        #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
                        #define __SSCANF_FOREACH__
                    #endif
                    string[end] = '\0';
                    num = false;
                    new
                        name[MAX_PLAYER_NAME];
                    id = end - stringPos;
                    foreach (Player, playerid)
                    {
                        GetPlayerName(playerid, name, sizeof (name));
                        if (!strcmp(name, string[stringPos], true, id))
                        {
                            setarg(paramPos, 0, playerid);
                            num = true;
                            break;
                        }
                    }
                    if (!num)
                    {
                        setarg(paramPos, 0, INVALID_PLAYER_ID);
                    }
                    string[end] = ch;
                    #if defined __SSCANF_FOREACH__
                        #undef foreach
                        #undef __SSCANF_FOREACH__
                    #endif
                }
                stringPos = end;
            }
            case 's', 'z':
            {
                new
                    i = 0,
                    ch;
                if (format[formatPos])
                {
                    while ((ch = string[stringPos++]) && ch != delim)
                    {
                        setarg(paramPos, i++, ch);
                    }
                    if (!i)
                    {
                        return -1;
                    }
                }
                else
                {
                    while ((ch = string[stringPos++]))
                    {
                        setarg(paramPos, i++, ch);
                    }
                }
                stringPos--;
                setarg(paramPos, i, '\0');
            }
            default:
            {
                continue;
            }
        }
        while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ')
        {
            stringPos++;
        }
        while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' '))
        {
            stringPos++;
        }
        paramPos++;
    }
    do
    {
        if ((delim = format[formatPos++]) > ' ')
        {
            if (delim == '\'')
            {
                while ((delim = format[formatPos++]) && delim != '\'') {}
            }
            else if (delim != 'z')
            {
                return delim;
            }
        }
    }
    while (delim > ' ');
    return 0;
}