import discord
from discord.ext import commands
import json
import sqlite3

startup_extensions = ['moderator']

conn = sqlite3.connect('database.db')
c = conn.cursor()

c.execute("""CREATE TABLE IF NOT EXISTS mod_log(
            action TEXT,
            user INTEGER,
            reason BLOB
            )""")

conn.commit()

with open('settings.json') as db:
    db = json.load(db)

PREFIX = db['prefix']
DESCRIPTION = db['des']
TOKEN = db['token']

bot = commands.Bot(command_prefix=PREFIX, description=DESCRIPTION)
bot.remove_command('help')

@bot.event
async def on_ready():
    print("Up and running!")
    print("User ID:" + bot.user.id)
    print("Logged in as: " + bot.user.name)

@bot.event
async def on_message(message):
    if message.content.upper().startswith('--WELCOME'):
        E = discord.Embed(title="Thanks!", description="I'm Imperial King and this is my server.", color = 0xFFFF00)
        E.set_footer(text = "This bot is created by Layoffin#9724")
        await bot.send_message(message.channel, embed = E)
        await bot.process_commands(message)

@bot.event
async def on_member_join(member: discord.Member):
    logs = member.server.get_channel("426253928955379712")
    E = discord.Embed(title="Member Joined!", description="{} just joined! Make sure you read the rules and Follow them.".format(member.mention), color=0x00FF00)
    E.set_thumbnail(url=member.avatar_url)
    await bot.send_message(logs, embed = E)

@bot.event
async def on_member_remove(member: discord.Member):
    logs = member.server.get_channel("426253928955379712")
    E = discord.Embed(title="Member Left!", description="{} just left us! sad :(".format(member))
    E.set_thumbnail(url=member.avatar_url)
    await bot.send_message(logs, embed = E)


if __name__ == '__main__':
    for extension in startup_extensions:
        try:
            bot.load_extension(extension)
        except Exception as e:
            ex = '{}: {}'.format(type(e).__name__, e)
            print("Failed to load extension {} \n {}".format(extension, ex))

bot.run(TOKEN)