[allenwr]

Everytime I run the script on my server, when I join and check the server console, it returns everything is ok, even when the steam id isnt in the table.

I need help finding when the script doesn't find a row containing the steam id.

this was my source of info. http://wiki.alliedmods.net/SQL_(SourceMod_Scripting)

PHP Code:

public OnClientPutInServer (client) {
    decl String:authid[32]
    GetClientAuthString(client, authid, sizeof(authid))
    new String:query1format[255]
    Format(query1format, sizeof(query1format), "SELECT * FROM points WHERE Steam_ID = '%s'",authid)
    new Handle:query1 = SQL_Query(db, query1format)
    if(query1 == INVALID_HANDLE) {
        PrintToServer("Failed to get steam id, %s",authid)
    } else {
        PrintToServer("Everything is OK")
    }
    CloseHandle(query1)
} 


[pRED*]

http://wiki.alliedmods.net/SQL_(Sour...essing_Results

[allenwr]

I am not trying to be dumb, but I have already read that page. I haven't a clue on how to find out when zero info is returned. INVALID_HANDLE isn't being returned and then goes and does they second half of the script.

[pRED*]

SQL_FetchRow(query)

[SirLamer]

So what pRED means is that you use SQL_FetchRow to begin browsing the query results. The function returns false when there are no more results. If it returns false on the first try, then the steam id is not found.

[allenwr]

Thank you sir, a return of false would have been easier, I was still looking for an invalid_handle.

[SirLamer]

Remember that a query handle, without being processed, basically says "blah blah blah gdgssdgharfhjnfafwsg" to your code. You need to use the SQL functions to bring out results.

If the handle were to equal INVALID_HANDLE then that would mean that the query failed to complete, but that is different than a query returning no results.