mysql ban

// ==========================================
// ========= [ DevoXx Scripting ] ===========
//        [ FilterScript - MySQL Ban ]
//            ---| Uživajte | ---
// ==========================================

// #3 (Druga Filter Scripta)

// --- [Includes] ---
#include <a_samp>
#include <a_mysql>
#include <sscanf2>
#include <zcmd>

// --- [Ostalo] ---
#define NARANDZASTA 0xFF9900AA
#define SCM  SendClientMessage

// --- [Databaza] ---
#define MySQL_HOST "localhost"
#define MySQL_DATABASE "databaza_imebaze"
#define MySQL_USER "root"
#define MySQL_PASS ""

// --------- [Ostale Definicije] ---------
public OnFilterScriptInit()
{
        mysql_connect(MySQL_HOST, MySQL_USER, MySQL_PASS, MySQL_DATABASE); // Ucitavanje databaze
        return 1;
}

public OnFilterScriptExit()
{
        mysql_close();
        return 1;
}
public OnPlayerConnect(playerid)
{
        new BananIP[32];
        GetPlayerIp(playerid, BananIP, sizeof BananIP);
        new query[255];
        format(query, sizeof query, "SELECT `razlog`, `datum`, `adminbanovao` FROM `banovi` WHERE `nickigraca` = '%s' OR `ip` = '%s'", ImeIgraca(playerid), BananIP);
        mysql_query(query);
        mysql_store_result();
        if(mysql_num_rows())
        {
            	new razlog[32], str[165], datum[32], adminbanovao[32];
                mysql_fetch_row(str);
                sscanf(str, "p<|>s[32]s[32]s[32]", razlog, datum, adminbanovao);
                format(str, sizeof str, "{FFFFFF}|ISKLJUCENJE SA SERVERA| {FF0000}Vi ste banovani sa ovog servera. Razlog: {FFFFFF}%s. {FF0000}Danasnji Datum: {FFFFFF}%s. {FF0000}Admin: %s", razlog, datum, adminbanovao);
                SCM(playerid, NARANDZASTA, str);
                Kick(playerid);
        }
        mysql_free_result();
        return 1;
}
ImeIgraca(playerid)
{
         new igrac[MAX_PLAYER_NAME];
         GetPlayerName(playerid, igrac, sizeof(igrac));
         return igrac;
}
stock Banovani(playerid, adminbanovao[], razlog[])
{
        new BananIP[32], dan, mjesec, godina, sat, minuta;
        getdate(godina, mjesec, dan);
        gettime(sat, minuta);
        GetPlayerIp(playerid, BananIP, sizeof BananIP);
        new query[255];
        format(query, sizeof query, "INSERT INTO `banovi` (`nickigraca`, `ip`, `datum`, `razlog`, `adminbanovao`) VALUES ('%s', '%s', '%d.%d.%d, %d:%d', '%s', '%s')", ImeIgraca(playerid), BananIP, dan, mjesec, godina, sat, minuta, razlog, adminbanovao);
        mysql_query(query);
        new str[95];
        format(str, sizeof str, "[Vi ste Banovani sa naseg servera] {FFFFFF}Vasa IP Adresa: %s", BananIP);
        SCM(playerid, NARANDZASTA, str);
        SetTimerEx("IzbaciIgraca", 100, false, "d", playerid);
}
CMD:ban(playerid, params[])
{
        if(!IsPlayerAdmin(playerid)) return SCM(playerid, NARANDZASTA, "(INFO) Niste autorizovani da koristite ovu komandu!"); // RCON Admin
        new igrac, razlog[138];
        if(sscanf(params, "ds[100]", igrac, razlog)) return SCM(playerid, NARANDZASTA, "Koristite: {FFFFFF}/ban [ID Igraca] [Razlog]");
        new string[138];
        format(string, sizeof string, "{FF0000}BAN | Igrac %s je banovan od Admina %s, Razlog: %s", ImeIgraca(igrac), ImeIgraca(playerid), razlog);
        SendClientMessageToAll(-1, string);
        Banovani(igrac, ImeIgraca(playerid), razlog);
        return 1;
}

forward IzbaciIgraca(playerid);
public IzbaciIgraca(playerid)
{
        Kick(playerid);
        return 1;
}


// ------------ [ Kraj, Nadam se da ce nekima da pomogne, Uzivajte ] ------------