Intenta probando asi.. por lo que veo esta bien.
PHP Code:
public Load(id)
{
static szQuery[199];
Checks()
formatex(szQuery, charsmax(szQuery), "SELECT 'ip' FROM `servers_online` WHERE (`ip` = '%s')", s_IP)
SQL_ThreadQuery(g_SqlTuple, "LoadHandler", szQuery);
}
public LoadHandler(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
static szQuery[199];
if( iFailState != TQUERY_SUCCESS )
return log_amx("SQL Error #%d - %s", iErrnum, szError)
if (!SQL_NumResults(hQuery))
{
formatex(szQuery, charsmax(szQuery), "INSERT INTO `servers_online` VALUES ('%s','%s','%s/%s','%s');", s_IP, s_MapName,s_nPlayers,g_iMaxPlayers,s_Hostname) //seguro que tenes que guardar solo strings aca? (lo digo por g_IImaxplayers ..
SQL_ThreadQuery(g_SqlTuple,"QueryHandle", szQuery)
return PLUGIN_HANDLED;
}
else
{
formatex(szQuery, charsmax(szQuery),"UPDATE `servers_online` SET `map` = '%s', `online` = '%s/%s', `name` = '%s' WHERE `ip` = '%s'", s_MapName,s_nPlayers,g_iMaxPlayers,s_Hostname,s_IP)
SQL_ThreadQuery(g_SqlTuple,"QueryHandle", szQuery);
return PLUGIN_HANDLED;
}
return PLUGIN_CONTINUE;
}
public QueryHandle(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
if( iFailState != TQUERY_SUCCESS )
{
return log_amx("SQL Error #%d - %s", iErrnum, szError)
}
return PLUGIN_CONTINUE
}
__________________