Hi all, so I wrote this script:
Code:
query = SQL_PrepareQuery(sql, "SELECT ...", ip, port)
if(!SQL_Execute(query))
{
SQL_QueryError(query, error, 127)
server_print("SQL error: can't load admins: '%s'!", error)
} else if(!SQL_NumResults(query)) {
server_print("No admins found on this server...")
} else {
new szFlags[2], szAccess[25]
g_aNum = 0
while(SQL_MoreResults(query))
{
SQL_ReadResult(query, 1, g_aName[g_aNum], 31)
SQL_ReadResult(query, 2, g_aPassword[g_aNum], 15)
SQL_ReadResult(query, 3, szAccess, 24)
SQL_ReadResult(query, 4, szFlags, 1)
SQL_ReadResult(query, 5, g_aDate[g_aNum], 11)
SQL_ReadResult(query, 6, g_aLife[g_aNum], 11)
g_aAccess[g_aNum] = read_flags(szAccess)
g_aFlags[g_aNum] = read_flags(szFlags)
++g_aNum
SQL_NextRow(query)
}
error in line
SQL_ReadResult(query, 6, g_aLife[g_aNum], 11)
Here he writes:
Code:
L 09/27/2012 - 20:33:55: [MySQL] Invalid column: 6
L 09/27/2012 - 20:33:55: [AMXX] Displaying debug trace (plugin "admin.amxx")
L 09/27/2012 - 20:33:55: [AMXX] Run time error 10: native error (native "SQL_ReadResult")
L 09/27/2012 - 20:33:55: [AMXX] [0] admin.sma::adminSql (line 88)
L 09/27/2012 - 20:33:55: [AMXX] [1] admin.sma::cmdReload (line 109)
How to fix it?