| Sylwester |
02-21-2013 19:27 |
Re: Mysql result ?
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 } }
|