[jonhson123]

Всем привет!
Хочу сделать что бы при подключение забаненного игрока ему показывался диалог с тем кто забанил когда и за что
Мой OnPlayerConnect

тык [Показать]

public OnPlayerConnect(playerid) {
	if (playerid == 65535)
		return Kick(playerid);
	GetPlayerName(playerid, player_name[playerid], sizeof (player_name[]));
	
	//Streamer_VisibleItems(STREAMER_TYPE_OBJECT, 1000, playerid);
	
	if (GetString(player_name[playerid], "Quick_Logic")) return Kick(playerid);
	strmid(player_RP_name[playerid], player_name[playerid], 0, strlen(player_name[playerid]), sizeof (player_name[]));

    for (new i = 0, len = strlen(player_RP_name[playerid]); i < len; i++) {
        if (player_RP_name[playerid][i] == '_') player_RP_name[playerid][i] = ' ';
	}
	if (IsLoginInvalid(player_name[playerid])) return Kick(playerid);

	SetPlayerVirtualWorld(playerid, playerid + 1);
	GetPlayerIp(playerid, player_ip_check[playerid], 16);

	to_default(playerid);
/*
	#if defined _sampvoice_included
	if(SvGetVersion(playerid) == SV_NULL) {
		SendClientMessage(playerid, -1, "Íå óäàëîñü îáíàðóæèòü ïëàãèí sampvoice");
	}
	else if(SvHasMicro(playerid) == SV_FALSE) {
		SendClientMessage(playerid, -1, "Íå óäàëîñü îáíàðóæèòü ìèêðîôîí");
	}
	else {
		if(gstream != SV_NULL) {
			SvAttachListenerToStream(gstream, playerid);
			SvAddKey(playerid, SV_KEY_B);
		}
	}
	#endif
*/
	#if defined _casino_included
		casino_OnPlayerConnect(playerid);
	#endif
	#if defined _ghetto_included
		ghetto_OnPlayerConnect(playerid);
	#endif

	static const f_check_ip_ban[] = "\
	SELECT * FROM `"TABLE_BANIP"` WHERE `IP` = '%s' LIMIT 1";

	new str_check_ip_ban[sizeof(f_check_ip_ban) + (-2 + 16)];
	format(str_check_ip_ban, sizeof(str_check_ip_ban), f_check_ip_ban, player_ip_check[playerid]);
	mysql_tquery(connects, str_check_ip_ban, "check_ip_ban", "i", playerid);
	
	for(new i=0; i<6; i++) {
		TextDrawShowForPlayer(playerid, logo_TD[i]);
	}

	GangZoneShowForPlayer(playerid, SFa, COLOR_YELLOW2);
	GangZoneShowForPlayer(playerid, Army, COLOR_YELLOW2);

	//if ((strcmp(player_ip_check[playerid], "127.0.0.1", true) && strcmp(player_ip_check[playerid], "192.168.1.111", true)) && GetServerVarAsInt("port") == 4444)
	RemoveBuildings(playerid);
	PlayerFixDiceCount[playerid] = 2;
	PlayerClearDelay[playerid] = 0;

	/*if (PlayerSecondTimer[playerid] != -1) {
		KillTimer(PlayerSecondTimer[playerid]);
		PlayerSecondTimer[playerid] = -1;
	}*/
	#if defined _INC_WEAPON_CONFIG
		// SetDamageFeedForPlayer(playerid, 0);
	#endif
	#if defined _flymode_inc
		flymode_OnPlayerConnect(playerid);
	#endif

	if (!PI[playerid][pID])
	{
		TI[playerid][tJoined] = true;
		ac_1{playerid} = true;

		MYSQL_GLOBAL[0] = EOS;
		mysql_format(connects, MYSQL_GLOBAL, sizeof (MYSQL_GLOBAL), "SELECT `pID`, `pKey`, `pKeyip`, `GoogleCode`, `pGoogle`, `pvIp` FROM `accounts` WHERE `Name` = '%s' LIMIT 1", player_name[playerid]);
		mysql_tquery(connects, MYSQL_GLOBAL, "OnPlayerRequestDetect", "d", playerid);
	}
	PlayerSecondTimer[playerid] = SetTimerEx("OnPlayerSecondUpdate", 1000, false, "i", playerid);

	return true;
}

CB:check_banned(playerid) [Показать]

CB:check_banned(playerid)
{
	new rows;
	cache_get_row_count(rows);
	if (!rows) return 1;

	new NAME_ADMIN[24], NAME_PLAYER[24], BAN_REASON[32], UNBAN_DATA = 0;

	cache_get_value_index(0, 1, NAME_PLAYER, 24);
	cache_get_value_index(0, 2, NAME_ADMIN, 24);
	cache_get_value_index(0, 3, BAN_REASON, 24);
	cache_get_value_index_int(0, 4, UNBAN_DATA);
	if (UNBAN_DATA > gettime())
	{
		new date_ban[6];
		gmtime(UNBAN_DATA + 10800, date_ban[0], date_ban[1], date_ban[2], date_ban[3], date_ban[4], date_ban[5]);

		STRING_GLOBAL[0] = EOS;
		format(STRING_GLOBAL, sizeof(STRING_GLOBAL), ""W"Ваш игровой аккаунт:\t"NO"%s\n\
	"W"Разблокировка:\t\t"NO"%02d/%02d/%04d %02d:%02d:%02d\n\
	"W"Причина:"NO"\t\t\t%s\n\
	"W"Заблокировал:"NO"\t\t%s", NAME_PLAYER, date_ban[2], date_ban[1], date_ban[0], date_ban[3], date_ban[4], date_ban[5], BAN_REASON, NAME_ADMIN);
		ShowPlayerDialog(playerid, DIALOG_BAN, DSM, ""P"Этот аккаунт заблокирован", STRING_GLOBAL, "Закрыть", "");
		Kick(playerid);
		return 1;
	}
	else
	{

		MYSQL_GLOBAL[0] = EOS;
		mysql_format(connects, MYSQL_GLOBAL, sizeof(MYSQL_GLOBAL), "DELETE FROM `ban` WHERE `Name` = '%s' LIMIT 1", player_name[playerid]);
		mysql_tquery(connects, MYSQL_GLOBAL);
	}
	return 1;
}

CB:check_ip_ban(playerid)
{
	new rows, reason[35];
	cache_get_row_count(rows);
	if (rows)
	{
		cache_get_value_name(0, "reason", reason, 30);
		if (strlen(reason) == 0)
		{
			STRING_GLOBAL[0] = EOS;
			format(STRING_GLOBAL, sizeof(STRING_GLOBAL), "Ваш IP адрес заблокирован. Причина: Неизвестно", reason);
			ErrorMessage(playerid, STRING_GLOBAL);
		}
		else
		{
			STRING_GLOBAL[0] = EOS;
			format(STRING_GLOBAL, sizeof(STRING_GLOBAL), "Ваш IP адрес заблокирован. Причина: %s", reason);
			ErrorMessage(playerid, STRING_GLOBAL);
		}
		Kick(playerid);
	}
	else
	{
		MYSQL_GLOBAL[0] = EOS;
		mysql_format(connects, MYSQL_GLOBAL, sizeof(MYSQL_GLOBAL), "SELECT * FROM `"TABLE_BAN"` WHERE `Name` = '%e' LIMIT 1", player_name[playerid]);
		mysql_tquery(connects, MYSQL_GLOBAL, "check_banned", "i", playerid);
	}
}

Сообщение отредактировал jonhson123: 24 ноября 2022 - 13:49

[jonhson123]

TABLE_BAN(ТАБлица с баном в бд)

[jonhson123]

UP