Pomoc

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

#define DIALOG_REGISTER 0
#define DIALOG_LOGIN 1

forward CheckPlayer(playerid);
forward LoginPlayer(playerid, password);
forward OnQueryFinish(gQuery[]);

enum pinfo
{
    pAdmin,
    pKills,
    pDeaths
}
new PlayerInfo[pinfo][MAX_PLAYERS];

//New's
new Query[1000];
new string[128];
new gConnectionHandle;

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

public OnGameModeInit()
{
    gConnectionHandle = mysql_connect("localhost", "root", "samp", "");
    mysql_debug(1);
    SetGameModeText("Blank Script");
    AddPlayerClass(0, 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)
{
    mysql_format(gConnectionHandle, Query, "SELECT * FROM `users` WHERE `username` = '%s'", GetName(playerid));
    mysql_function_query(gConnectionHandle, Query, false, "CheckPlayer", "d", playerid);
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    mysql_format(gConnectionHandle, Query, "UPDATE `users` SET `Money` = %d, `Score` = %d, `Admin` = %d, `Kills` = %d, `Deaths` = %d", GetPlayerMoney(playerid), GetPlayerScore(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pKills],
    PlayerInfo[playerid][pDeaths]);
    mysql_function_query(gConnectionHandle, Query, false, "OnQueryFinish", "s", Query);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    if(killerid != INVALID_PLAYER_ID) PlayerInfo[killerid][pKills]++;
    PlayerInfo[playerid][pDeaths]++;
    return 1;
}

public OnVehicleSpawn(vehicleid)
{
    return 1;
}

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

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

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 DIALOG_LOGIN:
        {
            if(!response) return Kick(playerid);
            mysql_format(gConnectionHandle, Query, "SELECT * FROM  `users` WHERE Username = '%e' AND Password = md5('%e')", GetName(playerid), inputtext);
            mysql_function_query(gConnectionHandle, Query, false, "LoginPlayer", "ds", playerid, inputtext);
        }
        case DIALOG_REGISTER:
        {
            if(!response) return Kick(playerid);
            new IP[50];
            GetPlayerIp(playerid, IP, sizeof(IP));
            mysql_format(gConnectionHandle, Query, "INSERT INTO `users` (`Username`, `Password`, `Money`,  `Score`, `Admin`, `Kills`, `Deaths`, `IP`) VALUES ('%e', md5('%e'), 500, 1, 0, 0, 0, '%e')", GetName(playerid), inputtext, IP);
            mysql_function_query(gConnectionHandle, Query, false, "OnQueryFinish", "s", Query);
        }
    }
    return 1;
}

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

public OnQueryFinish(gQuery[])
{
    printf("Query %s se uspesno izvrseo", gQuery);
    return 1;
}

public CheckPlayer(playerid)
{
    mysql_store_result();
    if(mysql_num_rows() == 1)
    {
        format(string, sizeof(string), "Dobrodosao %s\nMolimo vas da se prijavite", GetName(playerid));
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Prijava", string, "Login","Izlaz");
    }
    else
    {
        format(string, sizeof(string), "Dobrodosao %s\nMolimo da se registrujete", GetName(playerid));
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registracija", string, "Reg", "Izlaz");
    }
    mysql_free_result();
    return 1;
}

public LoginPlayer(playerid, password)
{
    mysql_store_result();
    if(mysql_num_rows(gConnectionHandle) == 1)
    {
        if(mysql_retrieve_row())
        {
            mysql_fetch_field_row(string, "Money"); GivePlayerMoney(playerid, strval(string));
            mysql_fetch_field_row(string, "Score"); SetPlayerScore(playerid, strval(string));
            mysql_fetch_field_row(string, "Admin"); PlayerInfo[playerid][pAdmin] = strval(string);
            mysql_fetch_field_row(string, "Kills"); PlayerInfo[playerid][pKills] = strval(string);
            mysql_fetch_field_row(string, "Deaths"); PlayerInfo[playerid][pDeaths] = strval(string);
            SendClientMessage(playerid, -1, "Uspesno ste se prijavili");
        }
        else
        {
            SetPVarInt(playerid, "WrongPas", GetPVarInt(playerid, "WrongPass") + 1);
            if(GetPVarInt(playerid, "WrongPass") == 3)
            {
                SendClientMessage(playerid, -1, "Pogresno ste upisali lozinku 3 puta, izbaceni ste sa servera");
                return Kick(playerid);
            }
            format(string, sizeof(string), "Dobrodosao %s\nMolimo vas da se prijavite", GetName(playerid));
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Prijava", string, "Login","Izlaz");
            SendClientMessage(playerid, -1, "Pogresno upisana lozinka");

        }
    }
    mysql_free_result();
    return 1;
}

stock GetName(playerid)
{
    new Ime[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Ime, MAX_PLAYER_NAME);
    return Ime;
}