Selge Fun

#include <a_samp>
#include <zcmd>
#include <sscanf2>
#include <a_mysql>
#include <foreach>
#include <streamer>
#include <removebuilding>

#define SCM SendClientMessage

#define COLOR_WHITE 0xFFFFFFFF

#define MYSQL_USER "xxxx"
#define MYSQL_PASS "xxxxx"
#define MYSQL_DB "xxxx"
#define MYSQL_HOST "xxxx"

enum {
    DIALOG_LOGI,
    DIALOG_REGA,
}

new db;

enum pInfo {
    mID,
    mRaha,
    mAdmin,
    mSkoor,
    mLogitud,
}
new KasutajaInfo[MAX_PLAYERS][pInfo];

native WP_Hash(buffer[], len, const str[]);
native IsValidVehicle(vehicleid);

main() { }

public OnGameModeInit()
{
    ShowPlayerMarkers(1);
    DisableInteriorEnterExits();
    SetGameModeText("Selge Fun v0.1");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
    mysql_debug(1);
    if (mysql_ping())
    {
        print("MySQL ühendus õnnestus!");
    }
    else
    {
        print("MySQL ühendus ebaõnnestus!");
    }
    SetTimer("SalvestaKasutajad", 1000, 1);
    return 1;
}

forward SalvestaKasutajad();
public SalvestaKasutajad()
{
    foreach (Player, i)
    {
        if (!IsPlayerConnected(i) || !KasutajaInfo[i][mLogitud]) continue;
        ResetPlayerMoney(i);
        GivePlayerMoney(i, KasutajaInfo[i][mRaha]);
        new string[256], nimi[24];
        GetPlayerName(i, nimi, 24);
        mysql_format(db, string, "UPDATE `kasutajad` SET `raha` = %i, `skoor` = %i, `adminlvl` = %i WHERE `kasutaja` = '%s'",
        KasutajaInfo[i][mRaha], KasutajaInfo[i][mSkoor], KasutajaInfo[i][mAdmin], nimi);
        mysql_function_query(db, string, false, "", "");
    }
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    return 1;
}

forward LeiaKasutaja(playerid);
public LeiaKasutaja(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);
    if (rows)
    {
        ShowPlayerDialog(playerid, DIALOG_LOGI, DIALOG_STYLE_PASSWORD, "Sisselogimine",
        "Tere tulemat Selge Fun serverisse! \n\n Sisesta alljärgnevasse kasti enda parool.", "Logi sisse!", "Lahku");
    }
    else
    {
        ShowPlayerDialog(playerid, DIALOG_REGA, DIALOG_STYLE_PASSWORD, "Registreerumine",
        "Tere tulemast Selge Fun serverisse! \n\n Teil puudub serverist kasutaja. \n Sisesta alljärgnevasse kasti enda tulevane parool.",
        "Registreeru!", "Lahku");
    }
}

public OnPlayerConnect(playerid)
{
    KasutajaInfo[playerid][mID] = 0;
    KasutajaInfo[playerid][mRaha] = 0;
    KasutajaInfo[playerid][mAdmin] = 0;
    KasutajaInfo[playerid][mSkoor] = 0;
    KasutajaInfo[playerid][mLogitud] = 0;
    new string[256], nimi[24];
    GetPlayerName(playerid, nimi, 24);
    mysql_format(db, string, "SELECT * FROM `kasutajad` WHERE `kasutaja`='%s' LIMIT 1", nimi);
    mysql_function_query(db, string, true, "LeiaKasutaja", "d", playerid);
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    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[])
{
    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)
{
    if (KasutajaInfo[playerid][mLogitud] == 0) return 0;
    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_LOGI:
        {
            new pass[129], nimi[24], string[256];
            GetPlayerName(playerid, nimi, 24);
            WP_Hash(pass, 129, inputtext);
            mysql_format(db, string, "SELECT * FROM `kasutajad` WHERE `kasutaja` = '%s' AND `parool` = '%s'", nimi, pass);
            mysql_function_query(db, string, true, "LogiKontroll", "d", playerid);
        }
        case DIALOG_REGA:
        {
            if (strlen(inputtext) < 6) return ShowPlayerDialog(playerid, DIALOG_REGA, DIALOG_STYLE_PASSWORD, "Registreerumine",
            "Parooli pikkus peab olema vähemalt 6 tähemärki. \n\n Proovi uuesti!", "Registreeru!", "Lahku");
            new pass[129], nimi[24], string[256];
            GetPlayerName(playerid, nimi, 24);
            WP_Hash(pass, 129, inputtext);
            mysql_format(db, string, "INSERT INTO kasutajad (kasutaja, parool) VALUES ('%s', '%s')", nimi, pass);
            mysql_function_query(db, string, false, "", "");
            SCM(playerid, COLOR_WHITE, "Sinu kasutaja on registreeritud!");
            KasutajaInfo[playerid][mLogitud] = 1;
            SpawnPlayer(playerid);
        }
    }
    return 1;
}

forward LogiKontroll(playerid);
public LogiKontroll(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);
    if (rows)
    {
        SCM(playerid, COLOR_WHITE, "Olete edukalt sisse logitud!");
        new cache[24];
        cache_get_row(0, 0, cache);
        KasutajaInfo[playerid][mID] = strval(cache);
        cache_get_row(0, 3, cache);
        KasutajaInfo[playerid][mRaha] = strval(cache);
        cache_get_row(0, 4, cache);
        KasutajaInfo[playerid][mSkoor] = strval(cache);
        cache_get_row(0, 7, cache);
        KasutajaInfo[playerid][mAdmin] = strval(cache);
        KasutajaInfo[playerid][mLogitud] = 1;
        SpawnPlayer(playerid);
    }
    else
    {
        ShowPlayerDialog(playerid, DIALOG_LOGI, DIALOG_STYLE_PASSWORD, "Sisselogimine",
        "Sisestasid vigase parooli. \n\n Proovi uuesti!", "Logi sisse!", "Lahku");
    }
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}
CMD:masin(playerid, p[])
{
    new model, c1, c2;
    if (sscanf(p, "iI(1)I(1)", model, c1, c2)) return SCM(playerid, COLOR_WHITE, "KASUTUS: /masin <Mudeli ID> <Värv 1> <Värv 2>");
    new Float:x, Float:y, Float:z, Float:a;
    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    new id = CreateVehicle(model, x, y, z, a, c1, c2, 0);
    PutPlayerInVehicle(playerid, id, 0);
    SCM(playerid, COLOR_WHITE, "Sõiduk tekitatud!");
    return 1;
}
CMD:ls(playerid)
{
    SendClientMessage(playerid, 0xFFFFFFFF, "Oled teleporditud Los Santosesse!");
    SetPlayerPos(playerid, 1524.4299,-1678.3191,13.2316);
    return 1;
}

CMD:lv(playerid)
{
    SendClientMessage(playerid, 0xFFFFFFFF, "Oled teleporditud Las Venturasesse!");
    SetPlayerPos(playerid, 2108.3521,1171.1936,10.5474);
    return 1;
}

CMD:sf(playerid)
{
    SendClientMessage(playerid, 0xFFFFFFFF, "Oled teleporditud San Fierrosse!");
    SetPlayerPos(playerid, -1989.9741,138.8005,27.2662);
    return 1;
}