8Hzf7yxh

1import discord
2import sqlite3
3
4client = discord.Client()
5conn = sqlite3.connect("bot_data.db")
6c = conn.cursor()
7
8
9@client.event
10async def on_ready():
11    print("We have logged in as {0.user}".format(client))
12
13    c.execute("""
14    CREATE TABLE IF NOT EXISTS commands (
15            id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
16            author TEXT NOT NULL,
17            message TEXT NOT NULL,
18            created_at DATE DEFAULT (datetime('now','localtime')) 
19    );
20    """)
21
22
23@client.event
24async def on_message(message):
25    if message.author == client.user:
26        return
27
28    if message.content.startswith("!input"):
29        message_content = message.content.replace("!input", "")
30        message_author = message.author
31
32        c.execute("""
33        INSERT INTO commands (author, message)
34        VALUES (?,?)
35        """, (message_author, message_content))
36
37        conn.commit()
38
39        await message.channel.send(message_content)
40
41
42client.run()
43