#include <a_samp>
#include <sscanf2>
#include <a_mysql>

main()
{
    print("\n----------------------------------");
    print(" gamemode");
    print("----------------------------------\n");
}

enum PlayerStats {
    Name[126],
    Password[126],
    Float: Position[3],
}
new Player[MAX_PLAYERS][PlayerStats];

public OnGameModeInit()
{
    mysql_debug(1);
    mysql_connect("Hostname ", "Usernam", "Password", "Database");

    SetGameModeText("LLA:RP");
    AddPlayerClass(299, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query[126], pName[MAX_PLAYER_NAME];

    GetPlayerName(playerid, pName, sizeof(pName));

    format(query, sizeof(query), "SELECT * FROM accounts WHEERE name = '%s'", pName);
    mysql_query(query);
    mysql_store_result();

    if(mysql_num_rows() == 1)
    {
        SendClientMessage(playerid, -1, "That username is registered!");
        ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "{0000FF}Login", "Please login with the Password you made.", "Login", "Cancel");

    }
    else
    {
        SendClientMessage(playerid, -1, "That username is not registered. You may register it");
        ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "{0000FF}Register", "Please register with a password you will remember", "Register", "Cancel");
    }

    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SavePlayer(playerid);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{
    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    switch(dialogid)
    {
        case 0:
        {
            if(response)
            {
                new query[126], pName[MAX_PLAYER_NAME];
                GetPlayerName(playerid, pName, sizeof(pName));

                format(query, sizeof(query), "SELECT * FROM accounts WHERE name = '%s' AND password = '%s'", pName, inputtext);
                mysql_query(query);
                mysql_store_result();

                if(mysql_num_rows() == 1)
                {
                    LoginPlayer(playerid);
                }
            }   else
            {
                SendClientMessage(playerid, 0xAA0000FF, "Incorrect Password!");
                ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "Login", "Please login with the password you made", "Login", "Cancel");
            }
        }
        case 1:
        {
            if(response)
            {
                new query[126], pName[MAX_PLAYER_NAME];
                GetPlayerName(playerid, pName, sizeof(pName));

                format(query, sizeof(query), "INSERT INTO accounts VALUES ('%s', '%s')", pName, inputtext);
                mysql_query(query);

                SendClientMessage(playerid, -1, "You have registered!");

                SetSpawnInfo(playerid, 0, 299, 1,2,3,1,1,999,1,999,1,999);
                SpawnPlayer(playerid);
            }
        }
    }

    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}


stock LoginPlayer(playerid)
{
    new query[126], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));
    format(query, sizeof(query), "SELECT * FROM accounts WHERE Name = '%s'", pName);
    mysql_query(query);
    mysql_store_result();

    while(mysql_fetch_row_format(query, "|"))
    {
        mysql_fetch_field_row(Player[playerid][Name], "Name");
        mysql_fetch_field_row(Player[playerid][Password], "Password");
        mysql_fetch_field_row(query, "PlayerX"); Player[playerid][Position][0] = floatstr(query);
        mysql_fetch_field_row(query, "PlayerY"); Player[playerid][Position][1] = floatstr(query);
        mysql_fetch_field_row(query, "PlayerZ"); Player[playerid][Position][2] = floatstr(query);

    }
    SetSpawnInfo(playerid, 0, 299, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
    SpawnPlayer(playerid);

}

stock SavePlayer(playerid)
{
    new query[126], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));

    GetPlayerPos(playerid, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2]);

    format(query, sizeof(query), "UPDATE `accounts` SET Name = '%s', Password = '%s', PlayerX = '%f', PlayerY = '%f', PlayerZ = '%f' WHERE `name` = '%s'", pName, Player[playerid][Password], Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], pName);
    mysql_query(query);
    printf("Player ID %d (%s)has been saved", playerid, pName);
}