[worldspawn]

So i tested this query and it works perfect
here it is

PHP Code:

#include <amxmodx> 
#include <amxmisc> 
#include <sqlx> 

new Handle:g_h_Sql, Handle:g_h_Sql_Connect, bool:g_b_Connected_SQL = false

public SQL_Connection(id) 
{ 
    new s_Error[128], i_Error 

    g_h_Sql = SQL_MakeDbTuple("--host--", "--dbuser--", "--dbpass--", "--dbname--") 
    g_h_Sql_Connect = SQL_Connect(g_h_Sql, i_Error, s_Error, charsmax(s_Error)) 

    if (g_h_Sql_Connect == Empty_Handle) 
    { 
        client_print(id, print_chat,"Can't connect to MySQL, error:") 
        client_print(id, print_chat,"%s", s_Error) 
        log_amx("Can't connect to MySQL, error: %s", s_Error) 

        return PLUGIN_HANDLED 
    }else{
    g_b_Connected_SQL = true 
    }
    return PLUGIN_CONTINUE 
}

public get_wins(id)
{
    if (g_b_Connected_SQL)
    {
        new Handle:query, authid[32], s_Error[128]

        get_user_authid(id, authid, charsmax(authid))

        query = SQL_PrepareQuery(g_h_Sql_Connect, "SELECT --column-- FROM --table-- WHERE (authid='%s')", authid)

        if (!SQL_Execute(query))
        {
            SQL_QueryError(query, s_Error, charsmax(s_Error))
            server_print("Can't execute MySQL query, error: %s", s_Error)
            log_amx("Can't execute MySQL query, error: %s", s_Error)
        }else{
            new i_Something, s_Something[32]

            i_Wins = SQL_FieldNameToNum(query, "--column--")
            if(i_Wins < 0)
            {
            }else{
                while (SQL_MoreResults(query))
                {
                    SQL_ReadResult(query, i_Something, s_Something, 3)

                    if (equal(s_Something, ""))
                    {
                        client_print(id, print_chat,"Yor result: nothing")
                    }else{
                        client_print(id, print_chat,"Yor result: %s", s_Something)
                    }

                    SQL_NextRow(query)
                }
            
                SQL_FreeHandle(query)
            }
        }
    }
}

public plugin_end() 
{ 
    SQL_FreeHandle(g_h_Sql_Connect) 
    SQL_FreeHandle(g_h_Sql) 
} 


[Arkshine]

You should have kept your problem and the solution, it could have help others people.

[worldspawn]

so, sql query (or request)at first post now!

[worldspawn]

sorry, double post

[xPaw]

Non-steam?

[worldspawn]

STEAM_0:0:20800076
i'm in steam - epileptick
u think lots of russians have non-steam products?

[xPaw]

No, i used asked it because youre using IP instead of Steam, wich is stupid.

[worldspawn]

if you don't know how to help, please don't post here

[hleV]

That's right, xPaw, GTFO.

[worldspawn]

only for you changed to authid
so anybody knows is it the right way to get result from sql?