Quote:
Originally Posted by wilian159
so there's no way to do what I want?
does this make no sense here?
PHP Code:
new VarTest
public SqlGetUserIndex(id)
{
SQL_ThreadQuery(handle, "_SqlGetUserIndex", "SELECT id FROM users WHERE authid = 'STEAM_XXXXXXXX'")
return VarTest
}
public _SqlGetUserIndex(fail_state, Handle:query, error[], error_code, data[], data_size)
{
// check fails, etc....
if(SQL_NumResults(query))
{
VarTest = SQL_ReadResult(xQuery, 0)
}
else
{
VarTest = -1
}
}
|
Yes, there is a way, using SQL_Execute. HamletEagle explained the difference between this and SQL_ThreadQuery.
No, it won't work, because the callback is executed after the SqlGetUserIndex() function ends. Test it by yourself by adding debug messages.
PHP Code:
new VarTest
public SqlGetUserIndex(id)
{
SQL_ThreadQuery(handle, "_SqlGetUserIndex", "SELECT id FROM users WHERE authid = 'STEAM_XXXXXXXX'")
server_print("SqlGetUserIndex() function")
return VarTest
}
public _SqlGetUserIndex(fail_state, Handle:query, error[], error_code, data[], data_size)
{
// check fails, etc....
if(SQL_NumResults(query))
{
VarTest = SQL_ReadResult(xQuery, 0)
}
else
{
VarTest = -1
}
server_print("_SqlGetUserIndex() function")
}
__________________