You can do it without getting data from mysql like this:
PHP Code:
new Handle:g_sql_tuple
public sql_init()
{
new sqlhostname[35], sqluser[35], sqlpass[35], sqldbname[35], errcode, error[128];
get_cvar_string("amx_sql_host", sqlhostname, 34);
get_cvar_string("amx_sql_user", sqluser, 34);
get_cvar_string("amx_sql_pass", sqlpass, 34);
get_cvar_string("amx_sql_db", sqldbname, 34);
g_sql_tuple = SQL_MakeDbTuple(sqlhostname, sqluser, sqlpass, sqldbname);
db = SQL_Connect(g_sql_tuple, errcode, error, charsmax(error));
return PLUGIN_CONTINUE;
}
public end_notemap()
{
new players[32], playerscount;
get_players(players, playerscount, "ch");
for(new i; i < playerscount; i++)
{
new id = players[i];
menu_cancel(id);
}
new cache[512]
formatex(cache, sizeof(cache)-1, "UPDATE `cs_notemap` SET `verygood`=`verygood`+'%d', `good`=`good`+'%d', `bad`=`bad`+'%d', `verybad`=`verybad`+'%d', `none`=`none`+'%d' WHERE `map`='%s'", result[0], result[1], result[2], result[3], result[4], g_mapname);
SQL_ThreadQuery(g_sql_tuple, "qh_ignore", cache)
}
public qh_ignore(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState)
{
log_amx("SQL Error: %s", Error)
return
}
}
__________________