[quark]

PHP Code:

public Load_MySql(id)
{
    new szSteamId[32], szTemp[512]
    get_user_authid(id, szSteamId, charsmax(szSteamId))
    
    new Data[1]
    Data[0] = id
    
    format(szTemp,charsmax(szTemp),"SELECT skill, nick FROM %s WHERE steamID = '%s'",Table,Table,szSteamId)
    SQL_ThreadQuery(g_SqlTuple,"register_client",szTemp,Data,1)
}

public register_client(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(FailState == TQUERY_CONNECT_FAILED)
    {
        log_amx("Load - Could not connect to SQL database.  [%d] %s", Errcode, Error)
    }
    else if(FailState == TQUERY_QUERY_FAILED)
    {
        log_amx("Load Query failed. [%d] %s", Errcode, Error)
    }
    
    new id
    id = Data[0]
    
    if(SQL_NumResults(Query) < 1) 
    {
        client_print(id, print_chat, "hsaeiasurkahe")
    } 
    else 
    {
        Skill[ id ] = SQL_ReadResult( Query, 0 )
        nick[ id ] = SQL_ReadResult( Query, 1 )
    }
    
    return PLUGIN_HANDLED
} 


So, this is not working. Any suggest? :/

EDIT* It doesn't load neither skill, or nick.

[YamiKaitou]

PHP Code:

format(szTemp,charsmax(szTemp),"SELECT skill, nick FROM %s WHERE steamID = '%s'",Table,Table,szSteamId) 


->

PHP Code:

format(szTemp,charsmax(szTemp),"SELECT skill, nick FROM %s WHERE steamID = '%s'",Table,szSteamId) 


[quark]

F*cking stupid errors -.-'

Doesn't work anyway :/

[YamiKaitou]

Is the data you are trying to obtain strings or numbers? The way you have it coded is as if they were numbers.

How about any error messages? Are you sure the query is even being executed correctly and there actually is valid data in the database?

[quark]

Originally Posted by YamiKaitou Is the data you are trying to obtain strings or numbers? The way you have it coded is as if they were numbers.

Nick are letters, but skill are numbers.

Originally Posted by YamiKaitou How about any error messages? Are you sure the query is even being executed correctly and there actually is valid data in the database?

Yes, in the database is everything ok.

[YamiKaitou]

SQL_ReadResult

[quark]

Thank you btw.

[quark]

F*ck this. I can't figure out how to do it

[Alka]

Did you take a look at what Yami posted?

PHP Code:

SQL_ReadResult(Query, 1, nick[id], 31); 


i assume that nick[] it's a string and it's properly declared. Replace 31 with your string size...

[quark]

SOLVED

MY Solution:

PHP Code:

format(szTemp,charsmax(szTemp),"SELECT `nick` FROM `%s` WHERE `steamID` = '%s'",Table,szSteamId)

SQL_ReadResult(Query, 0, nick[id], 32)