等級系統不起作用
@bot.event
async def on_message(message):
user = message.author.id
conn = sqlite3.connect('server.db')
cur = conn.cursor()
cur.execute('SELECT xp, lvl FROM users WHERE id = ?')
results = cur.fetchone()
row = results[0]
old_xp = row[0]
old_level = row[1]
new_xp = old_xp 1
if new_xp == 2:
new_level = 1
else:
new_level = old_level
cur.execute('UPDATE users SET xp = ?, level = ? WHERE id = ?', (new_xp, new_level, user)
)
conn.commit()
conn.close()
錯誤：
cur.execute('SELECT xp, lvl FROM users WHERE id = ?')
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 0 supplied.
uj5u.com熱心網友回復：
您需要為id.
@bot.event
async def on_message(message):
user = message.author.id
conn = sqlite3.connect('server.db')
cur = conn.cursor()
cur.execute('SELECT xp, lvl FROM users WHERE id = ?', (user,))
results = cur.fetchone()
請注意，您需要在此處輸入逗號：(user,)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/446898.html
標籤：Python sql sqlite 不和谐.py 水平
上一篇：django/加入查詢