[iceeedr]

Originally Posted by Natsheh here give this a try and show the outputs

Made some minor edits to proceed with the compilation.

PHP Code:

#include <amxmodx>
#include <sqlx>
#pragma defclasslib sqlite sqlite

#define PLUGIN  "New Plug-In"
#define VERSION "1.0"
#define AUTHOR  "Author"

#define CREATE "CREATE TABLE IF NOT EXISTS example (steamid varchar(32), name varchar(32));"
#define CREATE2 "CREATE TABLE IF NOT EXISTS example (steamid TEXT, name TEXT);"
#define CREATE3 "CREATE TABLE IF NOT EXISTS stats (steamid TEXT, name TEXT);"

#define SQLITEFILE "SQLITE"
#define SQLITEFILESTATS "SQLITESTATS"


#define HOST "localhost"
#define USER "user"
#define PASS "PASSWORD"
#define DB_INFO "DB INFO"

new Handle:g_iTuple = Empty_Handle, QueryNum;
new QueryError[512]

public plugin_init()
{
        register_plugin(PLUGIN, VERSION, AUTHOR)

        set_task(2.0, "InitMYSQLQueries")
}

public InitMYSQLQueries()
{
        PrepareTuple();

        DoBasicInfo("mysql");

        new szQuery[128]
        new szData[3];

        formatex(szQuery, charsmax(szQuery), CREATE);
        server_print("Adding to %i queue at: %f", ++QueryNum, get_gametime())
        szData[0] = QueryNum;
        SQL_ThreadQuery(g_iTuple,"InitialMySQL_Handler",szQuery, szData, sizeof(szData))

        DoBasicInfo("sqlite");

        formatex( szQuery, charsmax(szQuery), CREATE2)
        server_print("Adding to %i queue at: %f", ++QueryNum, get_gametime())
        szData[0] = QueryNum;
        SQL_ThreadQuery(g_iTuple,"InitialMySQL_Handler", szQuery, szData, sizeof(szData))

        formatex(szQuery, charsmax(szQuery), CREATE3)
        server_print("Adding to %i queue at: %f", ++QueryNum, get_gametime())
        szData[0] = QueryNum;
        SQL_ThreadQuery(g_iTuple,"InitialMySQL_Handler", szQuery, szData, sizeof(szData))
}

DoBasicInfo(const wanted_type[]="mysql")
{
    new affinity[12];

    SQL_GetAffinity(affinity, charsmax(affinity))

    server_print("SQLX Affinity: %s", affinity)
    server_print("SQLX Wanted: %s", wanted_type)

    if (!equal(wanted_type, affinity))
    {
        if(g_iTuple != Empty_Handle)
        {
            SQL_FreeHandle(g_iTuple)
            g_iTuple = Empty_Handle
        }

        new res = SQL_SetAffinity(wanted_type)
        server_print("Setting affinity from %s to %s: %s",
                        affinity,
                        wanted_type,
                        res ? "Success" : "Failed")
        SQL_GetAffinity(affinity, 11)
        PrepareTuple();
        server_print("Verification: %s", affinity)
    }
}

PrepareTuple()
{
    g_iTuple = SQL_MakeDbTuple(HOST,USER,PASS,DB_INFO);
}

public InitialMySQL_Handler(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:queuetime)
{
        server_print(" --> Resolved query %d, took %f seconds", Data[0], queuetime)

        if(FailState == TQUERY_CONNECT_FAILED)
                log_amx("Load - Could not connect to SQL database.  [%d] %s", Errcode, Error)
        else if(FailState == TQUERY_QUERY_FAILED)
        {
                SQL_GetQueryString(Query,QueryError,charsmax(QueryError))
                log_amx("Could not execute query ^"%s^"",QueryError)
        }

        if(!SQL_NumRows(Query))
        {
                server_print("No Results.")
        }
        else
                server_print("Created.")
}