Code:
if(SQL_NumResults(Query) > 0)
{
new pName[32], UnbanTime[32];
for(new i; i < SQL_NumResults(Query); i++)
{
SQL_ReadResult(Query, 1, pName, charsmax(pName))
UnbanTime[i] = SQL_ReadResult(Query, 5);
if(UnbanTime[i] == 0)
{
SCM(0, GREEN, "%s %s got unbanned.", TAG, pName);
}
SQL_NextRow(Query)
}
SQL_ThreadQuery(Handler, "IgnoreHandle", "DELETE FROM `bans` WHERE `UnbanTime` = '0'");
}
return PLUGIN_HANDLED;