GieGieMan's questions

调用该命令时C.send，server.db 数据库应该添加到选定的 id + 1 计数，但这不会发生。可能是什么问题？

import discord
import random
import time
from datetime import datetime,timedelta
from discord.ext import commands
from discord.ext.commands import MissingPermissions
from discord.utils import get
from discord.ext.commands import cooldown, BucketType
import asyncio
import sqlite3
import functools
import operator


bot = commands.Bot(command_prefix = "C.",intents = discord.Intents.all())

@bot.event 
async def on_ready():
       print("Hi!\nBot {NAME} is ready!")
       print('------------------')         
       db = sqlite3.connect('server.db')
       sql = db.cursor()       
       sql.execute("""CREATE TABLE IF NOT EXISTS users (
       id INT,
       name TEXT,
       count INT,
       server_id INT
               
       )""")
       db.commit()
                                                    
       for guild in bot.guilds:     
        guild_id = guild.id
        guild = bot.get_guild(guild_id)
        for member in guild.members:
            role = discord.utils.get(guild.roles, name="role_create")           
            if role not in guild.roles:
                await guild.create_role(name="role_create")
                print(f'Роль для {guild.name} создана!')
                
            if role in member.roles:                
                if sql.execute(f'SELECT id FROM users WHERE id = {member.id}').fetchone() is None:
                    sql.execute(f"INSERT INTO users VALUES ({member.id}, '{member}', 0,  {member.guild.id})")                                                       
                    db.commit()
       else:
        user_id_to_random = []
        for value in sql.execute("SELECT * FROM users"):
            print(value)      
        for user_id_in_sql in sql.execute(f"SELECT id FROM users"):         
            convert = functools.reduce(operator.add, (user_id_in_sql))
            user_id_to_random.append(convert)
        else:                                   
            global r
            r = random.choice(user_id_to_random)


@bot.command()
async def send(ctx):
    sql.execute(f"UPDATE users SET count = count + 1 WHERE id = {r} ")
    db.commit()

bot.run(TOKEN)  

我想让一个人不能向 3 个频道的类别发送超过 1 条消息。这是代码：

nabor1_channel_id = 970768863622995968
nabor2_channel_id = 970768884858761247
nabor3_channel_id = 970768911941398579


nabor = [nabor1_channel_id,
nabor2_channel_id, nabor3_channel_id]


@bot.listen('on_message')
async def on_message_four(message):
    if message.channel.id in nabor:
        if message.author == bot.user:
            pass
        else:
            
            if len(message.content) > 1: # проблема в этой строчке
                await message.delete()
                await message.channel.send(f"Не спамь!")

我怎样才能message.content使它只适用于我选择的 3 个频道？我希望你明白这个问题。

我正在练习python编程。试图为“坏词”创建过滤器我遇到了一个问题。我的代码中有@bot.event，它将所有消息从服务器复制到另一个通道。所以，它不起作用。虽然当我分别运行这两个@bot.event 时，它们工作正常。但它们一起冲突。它可以与什么连接？

import discord
from discord.ext import commands
TOKEN = 'censored'
badWord = ['bad1', 'bad2','Bad1','Bad2']
bot = commands.Bot(command_prefix='!') 

@bot.event 
async def on_ready(): 
    print(f"Bot App1 is ready") #a message about the bot's readiness, output to the console

@bot.event
async def on_message(message):
     if message.content in badWord:
      pass
      print(f"{message.author}: Bad word is detected")
     else:      
      if message.author == bot.user:
          return
      print(message.author,message.content)
      channel = bot.              get_channel(861546679676567594)
      await channel.send('{}: {}'.format(message.author, message.content)) #the bot reads all messages written on the server and copies them to a special chat

@bot.event
async def on_message(message):
    msg_content = message.content.lower()
    if any(word in msg_content for word in badWord):
        await message.delete()
        await message.channel.send(f"{message.author.mention} Bad word is deleted.")
        print('Bad word is deleted',message.author)

bot.run(TOKEN)