So I did this:
Code:
new qcolAuth = SQL_FieldNameToNum(query, "username")
new qcolPass = SQL_FieldNameToNum(query, "password")
new qcolAccess = SQL_FieldNameToNum(query, "access")
new qcolFlags = SQL_FieldNameToNum(query, "flags")
new qcolDate = SQL_FieldNameToNum(query, "adddate")
new qcolTime = SQL_FieldNameToNum(query, "timelife")
server_print("SQL qcolAuth %d", qcolAuth)
server_print("SQL qcolPass %d", qcolPass)
server_print("SQL qcolAccess %d", qcolAccess)
server_print("SQL qcolFlags %d", qcolFlags)
server_print("SQL qcolDate %d", qcolDate)
server_print("SQL qcolTime %d", qcolTime)
while(SQL_MoreResults(query))
{
SQL_ReadResult(query, qcolAuth, g_aName[g_aNum], 31)
SQL_ReadResult(query, qcolPass, g_aPassword[g_aNum], 15)
SQL_ReadResult(query, qcolAccess, szAccess, 24)
SQL_ReadResult(query, qcolFlags, szFlags, 1)
SQL_ReadResult(query, qcolDate, g_aDate[g_aNum], 11)
SQL_ReadResult(query, qcolTime, g_aLife[g_aNum], 11)
g_aAccess[g_aNum] = read_flags(szAccess)
g_aFlags[g_aNum] = read_flags(szFlags)
++g_aNum
SQL_NextRow(query)
}
And I found:
Quote:
qcolAuth 0
SQL qcolPass 1
SQL qcolAccess 2
SQL qcolFlags 3
SQL qcolDate 4
SQL qcolTime 5
|
MySQL reads a field from 0?