offunlwarn

CMD:offunlwarn(playerid, params[])
{
	IsAdmin(6);
	else if(!gAdminLogged[playerid]) return SendClientMessage(playerid, COLOR_GREY, YouAreNotLoggedInAsAdmin);
	new playername[MAX_PLAYER_NAME];
	if(sscanf(params, "s[24]", playername)) return SendClientMessage(playerid, COLOR_WHITE, "Введите: /offunlwarn [ник игрока]");
	else if(GetPlayerID(playername) != INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_GREY, "Игрок в сети, используйте команду /unlwarn");
	mysql_query_string[0] = EOS;
	format(mysql_query_string, sizeof(mysql_query_string), "SELECT memberwarn FROM "T_ACCOUNTS" WHERE name = '%s'", playername);
	mysql_tquery(dbHandle, mysql_query_string, "@OnPlayerOffunwarn", "is", playerid, playername);
	return 1;
}

@OnPlayerOffunlwarn(playerid,name[]);
@OnPlayerOffunlwarn(playerid,name[])
{
	new rows,fields;
	cache_get_data(rows,fields);
	if(rows)
	{
	    new string[144], fwarns;
		fwarns = cache_get_row_int(0,0);
		if(fwarns <1) return SendClientMessage(playerid,COLOR_GREY,"У данного лидера нет выговоров");
		format(string,sizeof(string),"<ADM> %s[%d] снял выговор лидеру %s в оффлайне",GetName(playerid),playerid,name);
		SendAdminMessage(COLOR_GREY, string);
		mysql_query_string[0] = EOS;
		format(mysql_query_string,150,"UPDATE "T_ACCOUNTS" SET memberwarn = %d WHERE name = '%s'",fwarns-1,name);
		mysql_tquery(dbHandle,mysql_query_string,"","");
	}
	else SendClientMessage(playerid,COLOR_GREY,"Игрок не найден!");
	return 1;
}