[Sputnik53]

Originally Posted by |PJ| Shorty a function like in php is not accessable. you have to save the results manually like: new g_var[10][36] ... SQL_ReadResult(Query,0,g_var[0],35); SQL_ReadResult(Query,1,g_var[1],35); SQL_ReadResult(Query,2,g_var[2],35); ... and so on example for strings...

Oh alright thanks.

[Sputnik53]

Well I tried creating a function to read the full row but ran into a problem when returning the array through the function.

PHP Code:

public sql_row(Handle:con, const sql[]) {
    new Handle:query, result;
    new row[33][128];
    query = SQL_PrepareQuery(con,sql);
    if(!SQL_Execute(query)) {
        server_print("%s :: MySQL query failed, stopping plugin", PLUGIN);
        SQL_QueryError(query,sql_error,511);
        set_fail_state(sql_error);
    }
    for(new i = 0; i < SQL_NumColumns(query); i++) {
        SQL_ReadResult(query,i,row[i],127);
    }
    SQL_FreeHandle(query);
    return row; // doesn't quite works this way I guess :(
} 


[Styles]

No, SQLx will take it's time in querying and come back, that is sorta the point so it doesn't hang. I mean it's fast but if there is some sort of hang for the server to talk to it, it wont wait up, the rest of the plugin goes, or that's how Hawk explained it and it seems right.

--- Random ---
This was my 1337 Post LOL! WIN!

[Exolent[jNr]]

Did you try this:

new row[33][128] = sql_row(...);