/*
BASE ADMIN = abcdfjgk
BASE VIP = o
0 AA/VIP = BASE ADMIN / BASE VIP
1 GAA = BASE ADMIN + CUSTOM6
2 GAS = BASE ADMIN + CUSTOM6
3 GSS = BASE ADMIN + UNBAN + CUSTOM6
4 RSP = BASE ADMIN + UNBAN + CUSTOM6

*/

#pragma semicolon 1

#define PLUGIN_AUTHOR "Kupah"
#define PLUGIN_VERSION "1.00"

#include <sourcemod>
#include <sdktools>
#include <morecolors>

#pragma newdecls required

Database connection;
ConVar cvar_url;

int sid = 1; // ID DU GAME
int id[MAXPLAYERS + 1] = -1;
int lvl[MAXPLAYERS + 1] = -1;
int imu[MAXPLAYERS + 1] = -1;

bool vip[MAXPLAYERS + 1] = false;
bool admin[MAXPLAYERS + 1] = false;

public Plugin myinfo =  {
    name = "",
    author = PLUGIN_AUTHOR,
    description = "",
    version = PLUGIN_VERSION,
    url = "recrutement.crazybro.net"
};

public void OnPluginStart() {
    cvar_url = CreateConVar("website_url", "http://recrutement.crazybro.net/", "Website url");
    AutoExecConfig(true, "boutique");

    RegConsoleCmd("sm_vip", Command_VIP);
    RegConsoleCmd("sm_autoadmin", Command_VIP);
    RegConsoleCmd("sm_check", cmd_droits);
}

public void OnClientPostAdminCheck(int client) {
    CreateTimer(1.0, Refresh, client);
}

public int OnRebuildAdminCache(AdminCachePart part) {
    if (part == AdminCache_Admins) {
        for (int i = 1; i <= MaxClients; i++)
        CreateTimer(1.0, Refresh, i);
    }
}

public Action Refresh(Handle timer, int client) {
    if (!client || !IsClientInGame(client) || IsFakeClient(client))
        return;
    refresh(client);
}

void refresh(int client) {
    char sql[364];
    char steamid[64];
    GetClientAuthId(client, AuthId_Steam2, steamid, sizeof(steamid));

    admin[client] = false;
    vip[client] = false;
    RemoveUserFlags(client, Admin_Custom1, Admin_Reservation, Admin_Generic, Admin_Kick, Admin_Ban, Admin_Slay, Admin_Chat, Admin_Custom6, Admin_Unban, Admin_Changemap, Admin_Vote);

    Format(sql, sizeof(sql), "SELECT id, level FROM rct_users WHERE steamid = '%s'", steamid);
    connection.Query(CallbackClientID, sql, client);
}

public void CallbackClientID(Database db, DBResultSet result, char[] error, any client) {
    if (result == null) {
        LogError("[BDD] Erreur SQL(CLIENTID): %s", error);
        return;
    }
    else if (result.RowCount <= 0)
        return;

    char sql[364];

    result.FetchRow();
    id[client] = result.FetchInt(0);
    lvl[client] = result.FetchInt(1);

    if (lvl[client] == 0)
        imu[client] = 1;
    else if (lvl[client] == 1)
        imu[client] = 10;
    else if (lvl[client] == 2)
        imu[client] = 20;
    else if (lvl[client] == 3)
        imu[client] = 30;
    else if (lvl[client] == 4)
        imu[client] = 40;
    else if (lvl[client] == 5)
        imu[client] = 100;

    Format(sql, sizeof(sql), "SELECT type, end FROM rct_droits WHERE id = '%i' AND game_id = '%i'", id[client], sid);
    connection.Query(CallbackClientInfo, sql, client);
}

public void CallbackClientInfo(Database db, DBResultSet result, char[] error, any client) {
    if (result == null) {
        LogError("[BDD] Erreur SQL(CLIENTINFO): %s", error);
        return;
    }
    else if (result.RowCount <= 0) {
        return;
    }

    int type = -1;
    int end = -1;
    while (result.FetchRow()) {
        type = result.FetchInt(0);
        end = result.FetchInt(1);

        int timeleft = end - GetTime();
        if (timeleft <= 0)
            DeleteClient(client, type);
        else {
            if (type == 1)
                admin[client] = true;
            else if (type == 0)
                vip[client] = true;
        }
    }
    AddClient(client);
}

public Action Command_VIP(int client, int args) {
    QueryClientConVar(client, "cl_disablehtmlmotd", motd_access);
}

public int Nothing(Handle menu, MenuAction action, int param1, int param2) {  }

public void motd_access(QueryCookie cookie, int client, ConVarQueryResult result, const char[] cvarName, const char[] cvarValue) {
    char steamid[64];
    char url[364];
    char website[256];
    char msg[1024];

    GetClientAuthId(client, AuthId_Steam2, steamid, sizeof(steamid));
    cvar_url.GetString(website, sizeof(website));

    if (!StrEqual(cvarValue, "0")) {
        Handle Paide = CreatePanel();
        Format(msg, sizeof(msg), "________________\n   - AIDE -   \n¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯\nVous devez activer les MOTDs HTML, appuyez sur ECHAP\n \nOptions -> Onglet 'Multijoueurs' -> Appuyez sur le bouton 'Avancé...'\nDécochez ensuite 'Désactiver les MOTDs HTML.'\nCliquez sur OK.\n \n Vous pouvez maintenant retaper !vip\nSi vous ne souhaitez pas activer vos messages du jour, vous pouvez vous inscrire depuis le site %sindex.php \n0 - Fermer", website);
        DrawPanelText(Paide, msg);
        SetPanelCurrentKey(Paide, 10);
        SendPanelToClient(Paide, client, Nothing, 30);
    } else {
        Format(url, sizeof(url), "%sindex.php?steamid=%s&name=%N", website, steamid, client);
        ShowMOTDPanel(client, "CrazyBro", url, 2);
    }
}

void DeleteClient(int client, int type) {
    char sql[364];
    Format(sql, sizeof(sql), "DELETE FROM rct_droits WHERE id = '%i' AND game_id = '%i' AND type = '%i'", id[client], sid, type);
    connection.Query(CallbackDroitsDelete, sql, client);
}

public void CallbackDroitsDelete(Database db, DBResultSet result, char[] error, any client) {
    if (result == null) {
        LogError("[BDD] Erreur SQL(DELETE): %s", error);
        return;
    }
    RemoveUserFlags(client, Admin_Custom1, Admin_Reservation, Admin_Generic, Admin_Kick, Admin_Ban, Admin_Slay, Admin_Chat, Admin_Custom6, Admin_Unban, Admin_Changemap, Admin_Vote);
}

public void CallbackTotalUpdate(Database db, DBResultSet result, char[] error, any data) {
    if (result == null) {
        LogError("[BDD] Erreur SQL(UPDATE): %s", error);
        return;
    }
}

void AddClient(int client) {
    if (!client || !IsClientInGame(client) || IsFakeClient(client))
        return;

    int Flags = GetUserFlagBits(client);
    AdminId aid = GetUserAdmin(client);

    if (aid == INVALID_ADMIN_ID) {
        aid = CreateAdmin();
        SetUserAdmin(client, aid, true);
    }

    if (vip[client])
        Flags |= ADMFLAG_CUSTOM1;
    if (admin[client]) {
        Flags |= ADMFLAG_GENERIC | ADMFLAG_KICK | ADMFLAG_BAN | ADMFLAG_SLAY | ADMFLAG_CHAT | ADMFLAG_CHANGEMAP | ADMFLAG_VOTE;
        if (lvl[client] >= 1)
            Flags |= ADMFLAG_CUSTOM6 | ADMFLAG_RCON;
        if (lvl[client] >= 3)
            Flags |= ADMFLAG_RESERVATION | ADMFLAG_UNBAN;
        if (lvl[client] == 5)
            Flags |= ADMFLAG_ROOT;
    }
    SetUserFlagBits(client, Flags);
    SetAdminImmunityLevel(aid, imu[client]);
}

// DEV CMD

public Action cmd_droits(int client, int args) {
    if (!client || !IsClientInGame(client) || IsFakeClient(client) || !(GetUserFlagBits(client) & ADMFLAG_ROOT))
        return;

    int imun = GetAdminImmunityLevel(GetUserAdmin(client));

    PrintToChat(client, "GAME_ID : %i", sid);
    PrintToChat(client, "USER_ID : %i", id[client]);
    PrintToChat(client, "LEVEL : %i", lvl[client]);
    PrintToChat(client, "IMUNITY : %i", imu[client]);
    PrintToChat(client, "IMUN : %i", imun);
    if (vip[client])
        PrintToChat(client, "VIP");
    if (admin[client]) {
        PrintToChat(client, "AA");
        if (lvl[client] >= 1)
            PrintToChat(client, "GAA,GAS,GSS");
        if (lvl[client] >= 3)
            PrintToChat(client, "RSP,LEADER");
        if (lvl[client] == 5)
            PrintToChat(client, "FONDA");
    }
}