is there any way i can return integer values or text according to a query?
we usually do this
PHP Code:
public SqlGetUserIndex(id)
{
SQL_ThreadQuery(handle, "_SqlGetUserIndex", "SELECT id FROM users WHERE authid = 'STEAM_XXXXXXXX'")
}
public _SqlGetUserIndex(fail_state, Handle:query, error[], error_code, data[], data_size)
{
// check fails, etc....
new id
if(SQL_NumResults(query))
{
id = SQL_ReadResult(xQuery, 0)
}
else
{
id = -1
}
}
I wanted to do something like that.:
return straight into function
PHP Code:
public SqlGetUserIndex(id)
{
SQL_ThreadQuery(handle, "XXXXXX", "SELECT id FROM users WHERE authid = 'STEAM_XXXXXXXX'")
new id
if(SQL_NumResults(query))
{
id = SQL_ReadResult(xQuery, 0)
}
else
{
id = -1
}
return id
}
like
PHP Code:
new user_id = SqlGetUserIndex(id)
out: 1
there must be a way? or it is not possible to do this at the moment.