import discord import os import threading from discord.ext import commands import json import datetime import requests import os.path import gspread import gradio_client import gradio as gr from gradio_client import Client DISCORD_TOKEN = os.environ.get("DISCORD_TOKEN", None) intents = discord.Intents.all() bot = commands.Bot(command_prefix='!', intents=intents) """""" XP_PER_MESSAGE = 10 # 100k messages = 1M exp = lvl 100 """""" service_account = json.loads(os.environ.get('KEY')) file_path = 'service_account.json' with open(file_path, 'w') as json_file: json.dump(service_account, json_file) gspread_bot = gspread.service_account(filename='service_account.json') worksheet = gspread_bot.open("levelbot").sheet1 """""" API_URL = "https://api-inference.huggingface.co/models/mariagrandury/roberta-base-finetuned-sms-spam-detection" HF_TOKEN = os.environ.get("HF_TOKEN", None) headers = {"Authorization": f"Bearer {HF_TOKEN}"} """ def query(payload): response = requests.post(API_URL, headers=headers, json=payload) return response.json() """ """""" @bot.event async def on_ready(): print(f'Logged in as {bot.user.name}') print(f"XP_PER_MESSAGE: {XP_PER_MESSAGE}") def calculate_level(xp): return int(xp ** (1.0 / 3.0)) def calculate_xp(level): return (int(level ** 3)) @bot.event async def on_message(message): try: if message.author != bot.user: #output = query({"inputs": f"{message.content}",}) #print(output) bot_ids = [1166392942387265536, 1158038249835610123, 1130774761031610388, 1155489509518098565, 1155169841276260546, 1152238037355474964, 1154395078735953930] try: if message.author.id not in bot_ids: #if message.author.id == 811235357663297546: # get level guild = bot.get_guild(879548962464493619) lvl1 = guild.get_role(1171861537699397733) lvl2 = guild.get_role(1171861595115245699) lvl3 = guild.get_role(1171861626715115591) lvl4 = guild.get_role(1171861657975259206) lvl5 = guild.get_role(1171861686580412497) lvl6 = guild.get_role(1171861900301172736) lvl7 = guild.get_role(1171861936258941018) lvl8 = guild.get_role(1171861968597024868) lvl9 = guild.get_role(1171862009982242836) lvl10 = guild.get_role(1164188093713223721) lvl11 = guild.get_role(1171524944354607104) lvl12 = guild.get_role(1171524990257082458) lvl13 = guild.get_role(1171525021928263791) lvl14 = guild.get_role(1171525062201966724) lvl15 = guild.get_role(1171525098465918996) # does a record already exist? cell = worksheet.find(str(message.author.id)) length = len(worksheet.col_values(1)) if cell is None: print(f"creating new record for {message.author}") # if not, create new record string_member_id = str(message.author.id) xp = 10 worksheet.update(values=[[string_member_id, message.author.name, xp, level]], range_name=f'A{length+1}:D{length+1}') else: if cell: print(f"updating record for {message.author}") # if so, update that row... # update exp, can only be in a positive direction # read xp = worksheet.cell(cell.row, cell.col+2).value xp = int(xp) + XP_PER_MESSAGE current_level = calculate_level(xp) print(current_level) # write with added xp worksheet.update(values=[[xp, current_level]], range_name=f'C{cell.row}:D{cell.row}') if current_level == 2: if lvl2 not in message.author.roles: await message.author.add_roles(lvl2) print(f"Gave {message.author} {lvl2}") await message.author.remove_roles(lvl1) print(f"Removed {lvl1} from {message.author}") if current_level == 3: if lvl3 not in message.author.roles: await message.author.add_roles(lvl3) print(f"Gave {message.author} {lvl3}") await message.author.remove_roles(lvl2) print(f"Removed {lvl2} from {message.author}") if current_level == 4: if lvl4 not in message.author.roles: await message.author.add_roles(lvl4) print(f"Gave {message.author} {lvl4}") await message.author.remove_roles(lvl3) print(f"Removed {lvl3} from {message.author}") if current_level == 5: if lvl5 not in message.author.roles: await message.author.add_roles(lvl5) print(f"Gave {message.author} {lvl5}") await message.author.remove_roles(lvl4) print(f"Removed {lvl4} from {message.author}") if current_level == 6: if lvl6 not in message.author.roles: await message.author.add_roles(lvl6) print(f"Gave {message.author} {lvl6}") await message.author.remove_roles(lvl5) print(f"Removed {lvl5} from {message.author}") if current_level == 7: if lvl7 not in message.author.roles: await message.author.add_roles(lvl7) print(f"Gave {message.author} {lvl7}") await message.author.remove_roles(lvl6) print(f"Removed {lvl6} from {message.author}") if current_level == 8: if lvl8 not in message.author.roles: await message.author.add_roles(lvl8) print(f"Gave {message.author} {lvl8}") await message.author.remove_roles(lvl7) print(f"Removed {lvl7} from {message.author}") if current_level == 9: if lvl9 not in message.author.roles: await message.author.add_roles(lvl9) print(f"Gave {message.author} {lvl9}") await message.author.remove_roles(lvl8) print(f"Removed {lvl8} from {message.author}") if current_level == 10: if lvl10 not in message.author.roles: await message.author.add_roles(lvl10) print(f"Gave {message.author} {lvl10}") await message.author.remove_roles(lvl9) print(f"Removed {lvl9} from {message.author}") if current_level == 11: if lvl11 not in message.author.roles: await message.author.add_roles(lvl11) print(f"Gave {message.author} {lvl11}") await message.author.remove_roles(lvl10) print(f"Removed {lvl10} from {message.author}") if current_level == 12: if lvl12 not in message.author.roles: await message.author.add_roles(lvl12) print(f"Gave {message.author} {lvl12}") await message.author.remove_roles(lvl11) print(f"Removed {lvl11} from {message.author}") if current_level == 13: if lvl13 not in message.author.roles: await message.author.add_roles(lvl13) print(f"Gave {message.author} {lvl13}") await message.author.remove_roles(lvl12) print(f"Removed {lvl12} from {message.author}") if current_level == 14: if lvl14 not in message.author.roles: await message.author.add_roles(lvl14) print(f"Gave {message.author} {lvl14}") await message.author.remove_roles(lvl13) print(f"Removed {lvl13} from {message.author}") if current_level == 15: if lvl15 not in message.author.roles: await message.author.add_roles(lvl15) print(f"Gave {message.author} {lvl15}") await message.author.remove_roles(lvl14) print(f"Removed {lvl14} from {message.author}") """ value = cell.value row_number = cell.row column_number = cell.col """ except Exception as e: print(f"Error: {e}") await bot.process_commands(message) except Exception as e: print(f"Error: {e}") @bot.command() async def level(ctx): if ctx.author.id == 811235357663297546: try: user_data = [] for author_id_str, xp_value in xp_data.items(): try: current_level = calculate_level(xp_value) author_id = int(author_id_str) user = bot.get_user(author_id) user_data.append((user, xp_value, current_level)) except Exception as e: print(f"Error for user {author_id}: {e}") sorted_user_data = sorted(user_data, key=lambda x: x[1], reverse=True) for user, xp, level in sorted_user_data: print(f"user: {user} | xp: {xp} | level: {level}") except Exception as e: print(f"Error: {e}") """ if author_id in xp_data: xp = xp_data[author_id] level = calculate_level(xp) await ctx.send(f'You are at level {level} with {xp} XP.') else: await ctx.send('You have not earned any XP yet.') # show top users by level / exp """ @bot.command() async def count(ctx): """Count total messages per user in all channels.""" if ctx.author.id == 811235357663297546: message_counts = {} for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None): message_counts[message.author] = message_counts.get(message.author, 0) + 1 except discord.Forbidden: # Handle the Forbidden error #await ctx.send(f"Missing access to read messages in {channel.name}") print(f"Missing access to read messages in {channel.name}") sorted_users = sorted(message_counts.items(), key=lambda x: x[1], reverse=True) top_list = "\n".join([f"{member.name}: {count}" for member, count in sorted_users[:50]]) #await ctx.send(f"Message count per user in all text channels:\n{top_list}") print(f"Message count per user in all text channels:\n{top_list}") @bot.command() async def count_messages1(ctx): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=1) message_count = 0 for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_messages7(ctx): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=7) message_count = 0 for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_messages14(ctx): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=14) message_count = 0 for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_messages30(ctx): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=30) message_count = 0 for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_messages60(ctx): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=60) message_count = 0 for channel in ctx.guild.text_channels: try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_messages(ctx, time: int): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=time) message_count = 0 for channel in ctx.guild.text_channels: print(channel.name) try: async for message in channel.history(limit=None, after=start_date, before=end_date): message_count += 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") print(f'Total messages between {start_date} and {end_date}: {message_count}') @bot.command() async def count_threads(ctx, time: int): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=time) thread_message_count = 0 for channel in ctx.guild.text_channels: print(f"CHANNELNAME: {channel.name}") for thread in channel.threads: print(channel.name) print(thread.name) async for message in thread.history(limit=None, after=start_date, before=end_date): thread_message_count += 1 print(f'Total thread_messages between {start_date} and {end_date}: {thread_message_count}') @bot.command() async def count_forum_threads(ctx, time: int): if ctx.author.id == 811235357663297546: end_date = datetime.datetime.utcnow() # Current date and time start_date = end_date - datetime.timedelta(days=time) forum_thread_message_count = 0 for forum in ctx.guild.forums: print(f"FORUMNAME: {forum.name}") for thread in forum.threads: print(forum.name) print(thread.name) async for message in thread.history(limit=None, after=start_date, before=end_date): print(f"THREAD NAME: {thread.name}") forum_thread_message_count += 1 """ async for thread in forum.archived_threads(limit=None, before=end_date): print(f"ARCHIVED THREAD NAME: {thread.name}") forum_thread_message_count += 1 """ print(f'Total forum_thread_messages between {start_date} and {end_date}: {forum_thread_message_count}') @bot.command() async def top_gradio(ctx, channel_id): if ctx.author.id == 811235357663297546: message_counts = {} try: channel = await bot.fetch_channel(channel_id) async for message in channel.history(limit=None): message_counts[message.author] = message_counts.get(message.author, 0) + 1 except discord.Forbidden: print(f"Missing access to read messages in {channel.name}") sorted_users = sorted(message_counts.items(), key=lambda x: x[1], reverse=True) top_list = "\n".join([f"{member.name}: {count}" for member, count in sorted_users[:50]]) print(f"Message count per user in the channel:\n{top_list}") @bot.command() async def top_gradio_threads(ctx, channel_id): if ctx.author.id == 811235357663297546: message_counts = {} channel = await bot.fetch_channel(channel_id) print(channel) threads = channel.threads print(threads) for thread in threads: print(f"Thread Name: {thread.name}, Thread ID: {thread.id}, Parent ID: {thread.parent_id}") async for message in thread.history(limit=None): message_counts[message.author] = message_counts.get(message.author, 0) + 1 async for thread in channel.archived_threads(limit=None): print(f"ARCHIVED Thread Name: {thread.name}, ARCHIVED Thread ID: {thread.id}, Parent ID: {thread.parent_id}") async for message in thread.history(limit=None): message_counts[message.author] = message_counts.get(message.author, 0) + 1 sorted_users = sorted(message_counts.items(), key=lambda x: x[1], reverse=True) top_list = "\n".join([f"[{member.id}]{member.name}: {count}" for member, count in sorted_users[:50]]) print(f"Message count per user in the channel:\n{top_list}") """""" DISCORD_TOKEN = os.environ.get("DISCORD_TOKEN", None) def run_bot(): bot.run(DISCORD_TOKEN) threading.Thread(target=run_bot).start() def greet(name): return "Hello " + name + "!" demo = gr.Interface(fn=greet, inputs="text", outputs="text") demo.launch()