[SQLX] SQL_MakeStdTuple() doesn't work in listen server

-hi- · **Author**

When connecting to the database using SQL_MakeStdTuple(), it doesn't use the password for some reason. The error message said access denied for root@localhost [using password: NO]. I do have sql.cfg set up correctly.

MaximusBrood · 09-14-2006 , 15:57 Re: [SQLX] SQL_MakeStdTuple() doesn't work in listen server

SQL_MakeStdTuple? Does that function exist?

teame06 · 09-14-2006 , 16:19 Re: [SQLX] SQL_MakeStdTuple() doesn't work in listen server

@ MaximusBrood

Yes, there is a SQL_MakeStdTuple. It is a stock in the sqlx.inc

@ Hi

SQL_MakeStdTuple uses the standard cvar of amxmodx\configs\sql.cfg. So you need to fill those out before using that stock. As you can see in the stock.

Code:

stock Handle:SQL_MakeStdTuple()
{
    static host[64], user[32], pass[32], db[128]
    static get_type[12], set_type[12]
    
    get_cvar_string("amx_sql_host", host, 63)
    get_cvar_string("amx_sql_user", user, 31)
    get_cvar_string("amx_sql_pass", pass, 31)
    get_cvar_string("amx_sql_type", set_type, 11)
    get_cvar_string("amx_sql_db", db, 127)
    
    SQL_GetAffinity(get_type, 12)
    
    if (!equali(get_type, set_type))
    {
        if (!SQL_SetAffinity(set_type))
        {
            log_amx("Failed to set affinity from %s to %s.", get_type, set_type)
        }
    }
    
    return SQL_MakeDbTuple(host, user, pass, db)
}