在discord.py中使用字典

import discord
from discord.ext import commands

intents = discord.Intents.default()
intents.messages = True

bot = commands.Bot(command_prefix='!', intents=intents)

# 创建一个字典来存储用户的发言次数
user_message_count = {}

@bot.event
async def on_ready():
    print(f'Bot is ready. Connected to {len(bot.guilds)} guilds.')

@bot.event
async def on_message(message):
    if message.author.bot:  # 忽略其他 bot 的消息
        return

    # 更新用户的发言次数
    if message.author.id in user_message_count:
        user_message_count[message.author.id] += 1
    else:
        user_message_count[message.author.id] = 1

    print(f'{message.author.name} has sent {user_message_count[message.author.id]} messages.')

    await bot.process_commands(message)

bot.run('YOUR_BOT_TOKEN')

user_data = {
    message.author.id: {
        'message_count': 1,
        'last_active': datetime.now()
    }
}

import sqlite3

conn = sqlite3.connect('user_data.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS user_data (user_id INTEGER PRIMARY KEY, message_count INTEGER)''')

# 更新数据库
c.execute('INSERT OR IGNORE INTO user_data (user_id, message_count) VALUES (?, ?)', (message.author.id, 1))
c.execute('UPDATE user_data SET message_count = message_count + 1 WHERE user_id = ?', (message.author.id,))
conn.commit()