Leaderboards

/leaderboard season:Current

const leaderboardFields = topEntries.map((entry, index) => {
    const medals = ["🥇", "🥈", "🥉"];
    const medal = index < 3 ? medals[index] : `**${index + 1}th**`;
    
    return {
        name: `${medal} - ${entry.username}`,
        value: `**${entry.replies} replies**`,
        inline: false,
    };
});

const groups = entry.groups ? entry.groups.split(",").map((group) => group.trim()) : [];
const owner = groups.includes("Owner") ? EMOJIS.ActiveDeveloper : "";
const programmer = groups.includes("Programmer") ? EMOJIS.ico_wrench : "";
const helper = groups.includes("Helper") ? EMOJIS.ico_helper : "";
const s1winner = groups.includes("S1W") ? EMOJIS.Season_1_Winner : "";
const s2winner = groups.includes("S2W") ? EMOJIS.Season_2_Winner : "";

db.get(
    `SELECT userID FROM current WHERE userID = ?`,
    [userID],
    (selectErr, row) => {
        if (row) {
            // User exists - increment their count
            db.run(
                `UPDATE current SET replies = replies + 1 WHERE userID = ?`,
                [userID]
            );
        } else {
            // New user - insert with count of 1
            db.run(
                `INSERT INTO current (username, userID, replies) VALUES (?, ?, 1)`,
                [userTag, userID]
            );
        }
    }
);

CREATE TABLE IF NOT EXISTS current (
    username TEXT,
    userID TEXT PRIMARY KEY,
    replies INTEGER DEFAULT 0,
    groups TEXT
)

db.run(
    `CREATE TABLE IF NOT EXISTS current (
        username TEXT,
        userID INTEGER,
        replies INTEGER,
        groups TEXT
    )`,
    (err) => {
        if (err) {
            return Error(`Error creating table: ${err.message}`);
        }
    }
);

Leaderboard current found

if (leaderboard.length === 0) {
    const emptyEmbed = ErrorEmbed(`Leaderboard is empty.`);
    return interaction.reply({ embeds: [emptyEmbed], ephemeral: true });
}

const sortedLeaderboard = leaderboard.sort(
    (a, b) => b.replies - a.replies
);
const topEntries = sortedLeaderboard.slice(0, 10);