BF1942 Map Alert Bot

A powerful Discord bot for your Battlefield 1942 community. Never miss your favorite map again.

How it Works

Get set up in less than a minute. You must have "Manage Server" permissions in Discord.

Use the 'Add to Discord' button on this page to start the process.

Choose the server you want to add the bot to from the Discord dropdown menu.

Grant the bot the required permissions. It only needs to create slash commands and send messages.

The bot uses Discord's built-in slash commands. Just type `/` to see the list.

/serversProvides a live list of the top 25 active BF1942 servers. It queries the servers table for all servers marked ACTIVE or EMPTY and sorts them by the highest player count, showing each server's name, current map, and player count.
/playingFinds all online servers that are currently playing a specific map. This command uses an autocomplete to help you find a map name, then queries the servers table for all active servers where the current_map matches your selection.
/findgametypeFinds all online servers running a specific gametype (like Conquest, CTF, etc.). It uses an autocomplete to show you available gametypes, then queries the servers table to list all matching servers, sorted by player count.
/findLocates a specific player on any active server. It queries the live_player_snapshot table for an exact, case-sensitive player name, then joins with the servers table to return the server name and the player's current stats (score, kills, deaths).
/seedHelps you find servers that need seeding. It queries the servers table for ACTIVE servers that have between 1 and 5 players, then lists them sorted with the lowest player count first.
/serverinfoGives you a detailed, live scoreboard for a single server. It joins the servers and live_server_snapshot tables to get all server info, then grabs all players from live_player_snapshot for that server, displaying teams, tickets, and sorted player lists.

/subscribeSubscribes you to an alert for a specific map on a specific server. It saves your user_id, the server_name, and the map_name into the subscriptions table so the bot can alert you.
/subscribe_serverSubscribes you to alerts for any map change on a specific server. It works just like /subscribe but uses a special map_name value (*all*) to signify a server-wide subscription.
/listPrivately lists all of your active subscriptions. It queries the subscriptions table for your user_id and displays all your alerts, showing if they are for a specific map or all maps, and whether they are paused.
/unsubscribeRemoves all of your subscriptions at once. This command finds and deletes all entries from the subscriptions table that match your user_id.
/pause_alertsTemporarily pauses or unpauses all of your map alerts. This command updates all your entries in the subscriptions table, setting the is_paused column to true or false.

/dnd setSets a 'Do Not Disturb' schedule to block all alerts. It takes a start hour, end hour, a list of days, and your timezone, converts it all to UTC, and saves it in the user_dnd_rules table.
/dnd viewShows your current DND schedule. It reads the rules from the user_dnd_rules table, converts the UTC times back to your saved timezone, and displays your 'do not disturb' hours and days.
/dnd clearClears your DND schedule. It finds and deletes your entry from the user_dnd_rules table, allowing all alerts to resume.

/alert_statsShows a public, Top 10 list of the most popular maps and servers based on all user subscriptions. It queries the subscriptions table, groups by map and server, and counts the results to build the lists.