tweetcord's People

Contributors

Stargazers

Watchers

tweetcord's Issues

Display a list of registered users

I'm using Tweetcord! Thanks for the convenient repository!

I tried to make the bot display the list of registered users only on the server where the command was executed.

Additional code

cogs/ListUsers.py

import discord
from discord import app_commands
from discord.ext import commands
import sqlite3
import os

class ListUsersCog(commands.Cog):

    def __init__(self, bot):
        self.bot = bot

    @app_commands.command(
        name='list_users',
        description='Lists registered Twitter usernames and their associated channels'
    )
    @commands.has_permissions(administrator=True)
    async def list_users(self, itn: discord.Interaction):
        
        server_id = itn.guild_id

        db_path = os.path.join(os.getenv('DATA_PATH', ''), 'tracked_accounts.db')
        conn = sqlite3.connect(db_path)
        cursor = conn.cursor()

        cursor.execute("""
            SELECT user.username, channel.id
            FROM user
            JOIN notification
            ON user.id = notification.user_id
            JOIN channel
            ON notification.channel_id = channel.id
            WHERE notification.server_id = ?
        """, (str(server_id),))
        user_channel_data = cursor.fetchall()

        conn.close()

        formatted_data = [f"{i+1}. ```{username}``` <#{channel_id}>" for i, (username, channel_id) in enumerate(user_channel_data)]

        embed = discord.Embed(
            title=f'Notice Add List ',
            description='\n'.join(formatted_data),
            color=0x778899
        )

        await itn.response.send_message(embed=embed)




async def setup(bot):
    await bot.add_cog(ListUsersCog(bot))

Modified code

notification.py add to changed 63line

add

@add_group.command(name='notifier')

server_id = str(itn.guild_id)
mention_str = mention.mention if mention else ''

changed

cursor.execute('INSERT INTO notification (user_id, channel_id, role_id) VALUES (?, ?, ?)', (str(new_user.id), str(channel.id), roleID))

cursor.execute('INSERT INTO notification (user_id, channel_id, role_id, mention, server_id) VALUES (?, ?, ?, ?, ?)', (str(new_user.id), str(channel.id), roleID, mention_str, server_id))