new Float:g_flSqlDelay;
new Handle:g_hSqlTuple, Handle:g_hSqlConnection;


public plugin_cfg()
{
    InitSQL();
}

public plugin_end()
{
    SQL_FreeHandle(g_hSqlTuple);
    if(g_hSqlConnection) SQL_FreeHandle(g_hSqlConnection);
}





public InitSQL()
{
    g_hSqlTuple = SQL_MakeDbTuple(g_Cvars[HOST], g_Cvars[USER], g_Cvars[PASS], g_Cvars[DB]);
    SQL_SetCharset(g_hSqlTuple, "utf-8");

    new iError, szError[128];
    g_hSqlConnection = SQL_Connect(g_hSqlTuple, iError, szError, charsmax(szError));

    if(g_hSqlConnection == Empty_Handle)
    {
        set_fail_state("%s %d", szError, iError);
        return;
    }
    ExecuteForward(g_hForwards[FORWARD_CONNECTION], _, g_hSqlTuple, g_hSqlConnection);

    new szQuery[1024];
    new cData[1]; cData[0] = SQL_TABLE;
    formatex(szQuery, charsmax(szQuery), "\
        CREATE TABLE IF NOT EXISTS `%s` \
        ( \
            `id`            INT(11) NOT NULL auto_increment PRIMARY KEY, \
            `clan_name`     VARCHAR(16) DEFAULT 'N/A', \
            `clan_slots`    SMALLINT(6) DEFAULT 1, \
            `clan_maxslots` SMALLINT(10) DEFAULT 0, \
            `clan_exp`      INT(10) DEFAULT 0, \
            `clan_created`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP \
        ); \
        CREATE TABLE IF NOT EXISTS `%s` \
        ( \
            `id`               INT(11) NOT NULL auto_increment PRIMARY KEY, \
            `clan_id`          INT(11) DEFAULT 0, \
            `player_name`      VARCHAR(32) DEFAULT 'N/A', \
            `player_steamid`   VARCHAR(32) DEFAULT 'N/A', \
            `player_ip`        VARCHAR(22) DEFAULT 'N/A', \
            `player_access`    SMALLINT(6) DEFAULT 0, \
            `player_last_seen` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP \
        );", g_Cvars[TABLE_CLANS], g_Cvars[TABLE_PLAYERS]);
    g_flSqlDelay = get_gametime();
    SQL_ThreadQuery(g_hSqlTuple, "QueryHandler", szQuery, cData, sizeof(cData));
    SQL_Clear();
}