offlwarn

CMD:offlwarn(playerid, params[])
{
	IsAdmin(6);
	else if(!gAdminLogged[playerid]) return SendClientMessage(playerid, COLOR_GREY, YouAreNotLoggedInAsAdmin);
	new playername[MAX_PLAYER_NAME], reason[32];
	if(sscanf(params, "s[24]s[32]", playername, reason)) return SendClientMessage(playerid, COLOR_WHITE, "Введите: /offlwarn [ник игрока] [причина]");
	else if(CheckExceptionName(playername) != 0) return AttemptRemoveChiefAdmin(playerid, "оффлайн заварнить", playername);
    else if(IsAIP(reason)) return 0;
	else if(CheckString(reason, 1)) return AdminAntisliv(playerid, reason);
	else if(GetPlayerID(playername) != INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_GREY, "Игрок в сети, используйте команду /lwarn");
    string_replace(reason, ''', ' ');
	mysql_query_string[0] = EOS;
	format(mysql_query_string, sizeof(mysql_query_string), "SELECT memberwarn,ip,id FROM "T_ACCOUNTS" WHERE name = '%s'", playername);
	mysql_tquery(dbHandle, mysql_query_string, "@OnPlayerOfflwarn", "iss", playerid, playername, reason);
	return 1;
}

@OnPlayerOfflwarn(playerid, name[], reason[]);
@OnPlayerOfflwarn(playerid, name[], reason[])
{
	new rows, fields;
    cache_get_data(rows, fields);
    if(rows)
	{
	    new string[144], fwarns;
	    fwarns = cache_get_row_int(0, 0);
	    if((fwarns+1) < 3)
		{
			format(string, sizeof(string), "Администратор %s выдал оффлайн выговор лидеру %s [%d/3]. Причина: %s", GetName(playerid), name, (fwarns+1), reason);
            mysql_query_string[0] = EOS;
			format(mysql_query_string, sizeof(mysql_query_string), "UPDATE "T_ACCOUNTS" SET memberwarn = %d WHERE name = '%s'", (fwarns+1), name);
			mysql_tquery(dbHandle, mysql_query_string, "", "");
		}
		else
		{
		    new playerip[16];
			cache_get_row(0, 1, playerip, dbHandle);
			format(string, sizeof(string), "Администратор %s выдал оффлайн выговор лидеру %s [%3/3].", GetName(playerid), name, (fwarns+1), reason);
			mysql_query_string[0] = EOS;
			format(mysql_query_string, sizeof(mysql_query_string), "UPDATE "T_ACCOUNTS" SET member = 0, memberskin = 0, memberwarn = 0, leader = 0, templeader = 0, rank = 0, job = 0, spawnchange = 0 WHERE name = '%s'", name);
			mysql_tquery(dbHandle, mysql_query_string, "", "");
		}
	    WriteLog("offlwarn", string);
	}
	else SendClientMessage(playerid, COLOR_GREY, "Игрок не найден!");
	return 1;
}