vpd-discord-bot/VPD_BOT/main.py

import os
from dotenv import load_dotenv
import discord
from discord.ext import commands
from discord.commands import Option
from discord.commands import slash_command
from datetime import datetime
import configparser
import mysql.connector


intents = discord.Intents.default()
intents.message_content = True
intents.members = True
intents.guilds = True
intents.reactions = True

client = discord.Client(intents=intents)
#------#
#Load .env file

load_dotenv()
token = os.getenv("TOKEN")
if token is None:
    raise ValueError("TOKEN not found in .env file")

debug_guilds_up = []
server_token = os.getenv("SERVER").split(",")
for i in range(len(server_token)):
    debug_guilds_up.append(int(server_token[i]))

dbhost = os.getenv("HOST")
if token is None:
    raise ValueError("HOST not found in .env file")
dbname = os.getenv("NAME")
if token is None:
    raise ValueError("NAME not found in .env file")
dbpsswd = os.getenv("PASSWORD")
if token is None:
    raise ValueError("PASSWORD not found in .env file")
dbdb = os.getenv("DATABASE")
if token is None:
    raise ValueError("DATABASE not found in .env file")

#------#
#ConfigParser

config = configparser.RawConfigParser()
configFilePath = r'config.cfg'
config.read_file(open(configFilePath))

label_rules = config.get('Reactionroles Rules', 'label_rules')
role_rules = config.get('Reactionroles Rules', 'rules_role')

channel_log = config.get('Logs', 'channel_log')
channel_banlog = config.get('Logs', 'ban_log')

#------#
#SQL initialization
conn = mysql.connector.connect(
    host=dbhost,
    user=dbname,
    password=dbpsswd
)
cursor = conn.cursor()
conn.database = str(dbdb)

cursor.execute("""
CREATE TABLE IF NOT EXISTS User (
    id INT AUTO_INCREMENT PRIMARY KEY,
    discordid INTEGER(20)
    name VARCHAR(100),
    roles INTEGER(250)
)
""")

cursor.execute("""
CREATE TABLE IF NOT EXISTS Warns (
    id INT AUTO_INCREMENT PRIMARY KEY,
    userid INTEGER(20),
    username VARCHAR(100),
    moderatorname VARCHAR(100),
    reason VARCHAR(250),
    date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
""")

#------#
#Initialize Bot

bot = commands.Bot(
    command_prefix=commands.when_mentioned_or("!"),
    description="VicePD Bot",
    intents=intents,
    debug_guilds=debug_guilds_up if debug_guilds_up else None
)

async def load_extensions():
    for filename in os.listdir("cogs"):
        if filename.endswith(".py"):
            bot.load_extension(f"cogs.{filename[:-3]}")   



class Admin(commands.Cog):
    def __init__(self, bot):
        self.bot = bot


#---------------------------------#
#Bot Online Console

@bot.event
async def on_ready():
    print(f"{bot.user} ist online")
    if bot.guilds:
        channel = discord.utils.get(bot.guilds[0].channels, id=int(channel_log))
        if channel:
            await channel.send(f"{bot.user} ist online")
    await load_extensions()
    bot.add_view(PersistentRoleView()) #loading reactionrole memory
#---------------------------------------------------------------------------------------#
#DONT Touch anything above this line, unless you know what you are doing!#
#---------------------------------------------------------------------------------------#

#---------------------------------#
## Greet
@bot.slash_command(description="Greet a User")
async def greet(ctx, user: str = Option(discord.User, "The user, you want to greet")):
    await ctx.respond(f"Hello {user.mention}")
#---------------------------------#

#---------------------------------#
## Say
@bot.slash_command(description="Let the bot send a message")
async def say(
        ctx,
        text: str = Option(description="Input the text you want to send"),
        channel_input: discord.TextChannel = Option(description="Select the channel,where you want to send the message.")
):  
    channel= discord.utils.get(ctx.guild.channels, id = int(channel_input[2:-1]))
    await channel.send(text)
    await ctx.respond("Message sent", ephemeral=True)
#---------------------------------#

#---------------------------------#
## Userinfo
@bot.slash_command(name="userinfo", description="Show informations of a user from this server")
async def userinfo(
        ctx,
        user: str = Option(discord.User, "Select User"),
    ):
    if user is None:
        user = ctx.author
    elif user not in ctx.guild.members:
        await ctx.respond("The selected user is not a member on this Server!", ephemeral=True)
        return
    elif user == bot.user:
        await ctx.respond(f"This is me - the {bot.user}", ephemeral=True)
        return

    embed = discord.Embed(
        title=f"Information about *{user.name}*",
        description=f"Here you see all details about {user.mention}",
        color=discord.Color.blue()
    )

    time = discord.utils.format_dt(user.created_at, "R")

    embed.add_field(name="Account creation date", value=time, inline=False)
    if len(user.roles) >= 2:
        embed.add_field(name="Roles", value=", ".join([role.mention for role in user.roles if role.name != "@everyone"]), inline=False)
    else:
        embed.add_field(name="Roles", value="User has no roles", inline=False)
    embed.add_field(name="Server join date", value=discord.utils.format_dt(user.joined_at, "R"), inline=False)
    embed.add_field(name="User ID", value=user.id)

    embed.set_thumbnail(url=user.display_avatar.url)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    await ctx.respond(embed=embed)
#---------------------------------#


#_________________________________#
#BAN SYSTEM

#---------------------------------#
##Ban
@bot.slash_command(name="ban", description="Ban a user from this Server")
async def ban(
    ctx,
    user: Option(discord.User, description = "Select User", required=True), # type: ignore
    reason: Option(str, description = "Reason for the ban", default="No reason provided") # type: ignore
    
):
    if not ctx.author.guild_permissions.ban_members:
        await ctx.respond("Error: You don't have the permission to ban Members!", ephemeral=True)
        return
    
    if user == bot.user:
        await ctx.respond("Error: I can't ban myself!", ephemeral=True)
        return
    if user == ctx.author:
        await ctx.respond("Error: You can't ban yourself!", ephemeral=True)
        return
    
    channel= discord.utils.get(ctx.guild.channels, id = int(channel_banlog))

    embed = discord.Embed(
        title=f"Ban of **{user.name}**",
        description=f"User {user.mention} has been banned from the Server",
        color=discord.Color.red()
    )
    time = discord.utils.format_dt(datetime.now(), "f")
    embed.add_field(name="Ban Date", value=time, inline=False)
    embed.add_field(name="Moderator", value=f"{ctx.author}", inline=False)
    embed.add_field(name="Reason", value=reason, inline=False)

    embed.add_field(name="User ID", value=user.id)

    embed.set_thumbnail(url=user.display_avatar.url)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    try:
        await ctx.guild.ban(user, reason=reason)
        await ctx.respond(f"User {user.mention} has been banned from this Server!", ephemeral=True)
        await channel.send(embed=embed)

    except discord.Forbidden:
        await ctx.respond("Error: I don't have permission to ban this user.", ephemeral=True)
    except discord.HTTPException as e:
        await ctx.respond(f"Error: Could not ban User {user.mention}. Reason: {e}", ephemeral=True)
    except Exception as e:
        await ctx.respond(f"Unexpected error: {e}", ephemeral=True)

#---------------------------------#
#Unban
@bot.slash_command(name="unban", description="Unban a user from this Server")
async def unban(
    ctx,
    user: Option(discord.User, description = "Insert User ID", required=True), # type: ignore
    reason: Option(str, description = "Reason for the unbanning", default="No reason provided") # type: ignore
    
):
    if not ctx.author.guild_permissions.ban_members:
        await ctx.respond("Error: You don't have the permission to unban Members!", ephemeral=True)
        return
    
    if user == bot.user:
        await ctx.respond("Error: I can't unban myself!", ephemeral=True)
        return
    if user == ctx.author:
        await ctx.respond("Error: You can't unban yourself!", ephemeral=True)
        return
    if user in ctx.guild.members:
        await ctx.respond("Error: This user is not banned!", ephemeral=True)
        return
    
    channel= discord.utils.get(ctx.guild.channels, id = int(channel_banlog))

    embed = discord.Embed(
        title=f"Unban of **{user.name}**",
        description=f"User {user.mention} was unbanned from this server.",
        color=discord.Color.green()
    )
    time = discord.utils.format_dt(datetime.now(), "f")
    embed.add_field(name="Unban Date", value=time, inline=False)
    embed.add_field(name="Moderator", value=f"{ctx.author}", inline=False)
    embed.add_field(name="Reason", value=reason, inline=False)

    embed.add_field(name="User ID", value=user.id)

    embed.set_thumbnail(url=user.display_avatar.url)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    try:
        await ctx.guild.unban(user, reason=reason)
        await ctx.respond(f"User {user.mention} is now unbanned!", ephemeral=True)
        await channel.send(embed=embed)

    except discord.Forbidden:
        await ctx.respond("Error: I don't have permission to unban this user.", ephemeral=True)
    except discord.HTTPException as e:
        await ctx.respond(f"Error: Could not unban User {user.mention}. Reason: {e}", ephemeral=True)
    except Exception as e:
        await ctx.respond(f"Unexpected error: {e}", ephemeral=True)

#---------------------------------#
#_________________________________#


#---------------------------------#
#Kick
@bot.slash_command(name="kick", description="Kick a user from this Server")
async def kick(
    ctx,
    user: Option(discord.User, description = "Select User", required=True), # type: ignore
    reason: Option(str, description = "Reason for the ban", default="No reason provided") # type: ignore
    
):
    if not ctx.author.guild_permissions.kick_members:
        await ctx.respond("Error: You don't have the permission to kick Members!", ephemeral=True)
        return
    
    if user == bot.user:
        await ctx.respond("Error: I can't kick myself!", ephemeral=True)
        return
    if user == ctx.author:
        await ctx.respond("Error: You can't kick yourself!", ephemeral=True)
        return
    

    try:
        await ctx.guild.kick(user, reason=reason)
        await ctx.respond(f"User {user.mention} has been kick from this Server!", ephemeral=True)

    except discord.Forbidden:
        await ctx.respond("Error: I don't have permission to kick this user.", ephemeral=True)
    except discord.HTTPException as e:
        await ctx.respond(f"Error: Could not kick User {user.mention}. Reason: {e}", ephemeral=True)
    except Exception as e:
        await ctx.respond(f"Unexpected error: {e}", ephemeral=True)

#---------------------------------#

#---------------------------------#
#Warn
@bot.slash_command(name="warn", description="Warn a user from this Server")
async def warn(
    ctx,
    user: Option(discord.User, description = "Select User", required=True), # type: ignore
    reason: Option(str, description = "Reason for the warn", default="No reason provided") # type: ignore
):
    if not ctx.author.guild_permissions.kick_members:
        await ctx.respond("Error: You don't have the permission to warn Members!", ephemeral=True)
        return
    
    if user == bot.user:
        await ctx.respond("Error: I can't warn myself!", ephemeral=True)
        return
    if user == ctx.author:
        await ctx.respond("Error: You can't warn yourself!", ephemeral=True)
        return

    cursor.execute("""
    INSERT INTO Warns (userid, username, moderatorname, reason)
    VALUES (%s, %s, %s, %s)
    """, (user.id, str(user), str(ctx.author), reason))
    conn.commit()

    await ctx.respond(f"User {user.mention} has been warned for: {reason}", ephemeral=True)


#_________________________________#
## Reaction role system

#---------------------------------#
#reaction role verfiy

class PersistentRoleView(discord.ui.View):
    def __init__(self):
        super().__init__(timeout=None)

    @discord.ui.button(
        label=label_rules, 
        style=discord.ButtonStyle.success, 
        emoji="✅", 
        custom_id="persistent_view:role_verify" 
    )
    async def verify_callback(self, button: discord.ui.Button, interaction: discord.Interaction):
        role = interaction.guild.get_role(int(role_rules))
        
        if role is None:
            await interaction.response.send_message("Fehler: Die konfigurierte Rolle wurde nicht gefunden.", ephemeral=True)
            return

        if role in interaction.user.roles:
            await interaction.user.remove_roles(role)
            await interaction.response.send_message(f"Rolle **{role.name}** wurde entfernt.", ephemeral=True)
        else:
            await interaction.user.add_roles(role)
            await interaction.response.send_message(f"Du hast die Rolle **{role.name}** erhalten!", ephemeral=True)



@bot.slash_command(name="verify_message", description="Sendet die persistente Reaction-Role Nachricht")
async def setup_rr(
    ctx: discord.ApplicationContext,
    channel: discord.TextChannel, 
    title: str,
    description: str
):

    if not ctx.author.guild_permissions.administrator:
        await ctx.respond("Keine Berechtigung.", ephemeral=True)
        return

    embed = discord.Embed(
        title=title,
        description=description,
        color=discord.Color.red()
    )

    try:
        await channel.send(embed=embed, view=PersistentRoleView())
        await ctx.respond(f"Nachricht erfolgreich in {channel.mention} gesendet!", ephemeral=True)
    except discord.Forbidden:
        await ctx.respond("Ich darf in diesem Kanal nicht schreiben.", ephemeral=True)
#---------------------------------#
#_________________________________#


#_________________________________#
## Help System

#---------------------------------#
#How to team

@bot.slash_command(name="how_to_team", description= "Get Infos")
async def how_to_team(
    ctx,
):
    server = ctx.guild
    embed = discord.Embed(
        title=f"__How to join the Team on {server.name}__",
        description=f"If you want to join the Serverteam open a ticket in #ticket.",
        color=discord.Color.yellow()
    )


    embed.set_thumbnail(url=server.icon)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    await ctx.respond(embed=embed, ephemeral=True)

#---------------------------------#
#How to start
@bot.slash_command(name="how_to_start", description= "Get Infos")
async def how_to_start(
    ctx,
):
    server = ctx.guild
    embed = discord.Embed(
        title=f"__How to start__",
        description=f"Hallo {ctx.author.mention}, um auf unserem Server spielen zu können, ließ dir zuerst das Regelwerk in in #regelwerk durch. Um einem Department beizutreten wähle in #how-to-start eine Einweisungsrolle aus. Melde dich anschließend für eine Einweisung an. **Wichtig: gehe erst krz vor der Einweisung auf den Server!**",
        color=discord.Color.yellow()
    )


    embed.set_thumbnail(url=server.icon)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    await ctx.respond(embed=embed, ephemeral=True)

#---------------------------------#
#Help_cache
@bot.slash_command(name="help_cache", description= "Get Infos")
async def help_cache(
    ctx,
):
    server = ctx.guild
    embed = discord.Embed(
        title=f"__How to clear your game cache__",
        description=f"Follow the follwing steps to clear your game cache:",
        color=discord.Color.yellow()
    )

    embed.add_field(name="Close Game", value="Close FiveM completely", inline=False)
    embed.add_field(name="Press keys", value="Win + R", inline=False)
    embed.add_field(name="Go to the folder", value="\Local\FiveM\FiveM.app\data", inline=False)
    embed.add_field(name="Delete the folders", value="cache, server-cache, server-cache-priv", inline=False)
    embed.add_field(name="Restart Game", value="Restart the game and download the resources again.", inline=False)


    embed.set_thumbnail(url=server.icon)
    embed.set_author(name="VicePD", icon_url="https://i.imgur.com/6QteFrg.png")
    embed.set_footer(text="VicePD - Bot | Made by BaumSplitter41")

    await ctx.respond(embed=embed, ephemeral=True)
#---------------------------------#
#_________________________________#


#---------------------------------#
#Run function
bot.run(token)
#---------------------------------#