import sqlite3
import logging
import logging.handlers
import random
from time import sleep
from config import config

import irc

bold        = '\x02'
italic      = '\x1D'
underline   = '\x1F'
reverse     = '\x16'
reset       = '\x0f'
white       = '00'
black       = '01'
blue        = '02'
green       = '03'
red         = '04'
brown       = '05'
purple      = '06'
orange      = '07'
yellow      = '08'
light_green = '09'
cyan        = '10'
light_cyan  = '11'
light_blue  = '12'
pink        = '13'
grey        = '14'
light_grey  = '15'


def createtable():
    c.execute('''CREATE TABLE if not exists users (
        name text unique,
        level integer,
        experience integer,
        health integer,
        attack integer,
        defense integer,
        money integer,
        healthmax integer
    
)''')
    c.execute('''CREATE TABLE if not exists weapons (
        name text unique,
        weaponheld integer,
        clip integer,
        ammunition integer,
        expire integer
    
)''')    
    c.execute('''CREATE TABLE if not exists items (
        name text unique,
        bandages integer
    )''')
    c.execute('''CREATE TABLE if not exists stats (
        name text unique,
        kills integer,
        deaths integer
    )''')


def color(msg: str, foreground: str, background: str='') -> str:
    '''
    Color a string with the specified foreground and background colors.
    
    :param msg: The string to color.
    :param foreground: The foreground color to use.
    :param background: The background color to use.
    '''
    return f'\x03{foreground},{background}{msg}{reset}' if background else f'\x03{foreground}{msg}{reset}'


class Users:
    def __init__(self, name, level, experience, health, attack, defense, money, healthmax):
        self.name = name
        self.level = level
        self.experience =  experience
        self.health = health
        self.attack = attack
        self.defense = defense 
        self.money = money
        self.healthmax = healthmax
        
class Weapons:
    def __init__(self, name, weaponheld, clip, ammunition):
        self.name = name
        self.weaponheld = weaponheld
        self.clip = clip
        self.ammunition = ammunition
        self.expire = 0
class Items:
    def __init__(self, name, bandages):
        self.name = name
        self.bandages = bandages

conn = sqlite3.connect('data.db')
c = conn.cursor()         
async def checkexist(player):
    c.execute(f"SELECT rowid FROM users WHERE name=(:name)", {'name': player})
        
    data=c.fetchone()
    
    if data is None:
        return f'Invalid Player: %s'%player
    else:
        return True   
async def addkillstat(name):
    c.execute(f'SELECT rowid FROM stats WHERE name=(:name)', {'name': name})
    checkrow=c.fetchone()
    if checkrow == None:
        kills = 1
        deaths = 0
        c.execute(f'INSERT OR REPLACE INTO stats VALUES (:name, :kills, :deaths)', {'name': name, 'kills': kills, 'deaths': deaths})  
        conn.commit()
        await irc.bot.sendmsg(config.irc.channel, f'[Player {color(name, light_green)} has a total of {color(kills, red)} kills!]')
         
    else:
        c.execute(f'SELECT * FROM stats WHERE name=(:name)', {'name': name})
        getkills=c.fetchall()
        for retrieve in getkills:
            kills = retrieve[1] + 1
            
        c.execute(f'UPDATE stats SET KILLS = (:kills) WHERE name=(:name)', {'kills': kills, 'name': name})
        conn.commit()
    
        await irc.bot.sendmsg(config.irc.channel, f'[Player {color(name, light_green)} has a total of {color(kills, red)} kills!]')

async def adddeathstat(name):
    c.execute(f'SELECT rowid FROM stats WHERE name=(:name)', {'name': name})
    checkrow=c.fetchone()
    if checkrow == None:
        kills = 0
        deaths = 1
        c.execute(f'INSERT OR REPLACE INTO stats VALUES (:name, :kills, :deaths)', {'name': name, 'kills': kills, 'deaths': deaths})  
        conn.commit()
        
        await irc.bot.sendmsg(config.irc.channel, f'[Opponent Player {color(name, red)} has died {color(deaths, red)} times!]')
         
    else:
        c.execute(f'SELECT * FROM stats WHERE name=(:name)', {'name': name})
        getkills=c.fetchall()
        for retrieve in getkills:
            kills = retrieve[1]
            deaths = retrieve[2] + 1
            
        c.execute(f'UPDATE stats SET DEATHS = (:deaths) WHERE name=(:name)', {'deaths': deaths, 'name': name})
        conn.commit()
        sleep(3)
        await irc.bot.sendmsg(config.irc.channel, f'[Player {color(name, red)} has died {color(deaths, red)} times!]')

                 
async def buybandages(name, amount):
    if amount == 0 or amount == None:
        return f'[Must specify how many bandages you want... !buy bandages <amount>]'
    c.execute(f'SELECT rowid FROM items WHERE name=(:name)', {'name': name})
    checkrow=c.fetchone()
    if checkrow == None:
        bandages = 0
        c.execute(f'INSERT OR REPLACE INTO items VALUES (:name, :bandages)', {'name': name, 'bandages': bandages})
        conn.commit()
    shopamount = amount * 50
    c.execute(f'SELECT * FROM items WHERE name=(:name)', {'name': name})
    look = c.fetchall()
    
    for band in look:
        bandages = band[1]
        
    c.execute(f'SELECT * FROM users WHERE name=(:name)', {'name': name})
    usermoney = c.fetchall()
    for grabmoney in usermoney:
        money = grabmoney[6]
        if money >= shopamount:
            bandages = band[1]
            bandagestotal = bandages + amount
            c.execute(f'UPDATE ITEMS set BANDAGES = (:bandages) WHERE NAME = (:name)', {'bandages': bandagestotal, 'name': name})
            conn.commit()
            money = money - shopamount
            c.execute(f'UPDATE users set MONEY = (:money) WHERE NAME = (:name)', {'money': money, 'name': name})   
            conn.commit()

            return f'[You have enough money [${money:,}] to purchase [{amount}] bandages! Cost is ${shopamount:,}]'
        else:
            return f'[You do {color("NOT", red)} have enough funds!]'
            return

async def heal(name):


    c.execute(f'SELECT * from USERS WHERE name= (:name)', {'name': name})
    newtest=c.fetchall()
    for userinfo in newtest:
        health = userinfo[3]
        if health <= 0:
            return f'[You are dead... !revive to bring yourself back]'
        
        c.execute(f'SELECT rowid FROM items WHERE name = (:name)', {'name': name})
        havebandages=c.fetchone()
        if havebandages == None:
            return f'[You do not have any bandages... !buy bandages <amount number>]'
        
        c.execute(f'SELECT * FROM items WHERE name = (:name)', {'name': name})
        bandaids = c.fetchall()
        for bandages in bandaids:
            if bandages[1] <= 0:
                return f'[You do not have any bandages... !buy bandages <amount number>]'
            
        maxhealth = userinfo[7]
        if health == maxhealth:
            return f'[You already at FULL HEALTH]'
        
        newhealth = health + 25
        if newhealth >= maxhealth:
            health = maxhealth
            c.execute(f'UPDATE USERS set HEALTH = (:health) where NAME = (:name)', {'health': health, 'name': name})
            conn.commit()
            return f'[Player healed {color("+25", light_green)} to MAX health {color(health, light_green)}]'
        else:
            c.execute(f'UPDATE USERS set HEALTH = (:health) where NAME = (:name)', {'health': newhealth, 'name': name})
            conn.commit()
            return f'[Player healed {color("+25", light_green)} to health {color(newhealth, light_green)}]'
            
        
    c.execute(f'SELECT * FROM items WHERE name=(:name)', {'name': name})
    bandaids=c.fetchall()        
    for checkitems in bandaids:
        bandages = checkitems[1]
        bandages = bandages - 1
        c.execute(f'UPDATE ITEMS set BANDAGES = (:bandages) WHERE name = (:name)', {'bandages': bandages, 'name': name})
        conn.commit()            

async def testfunction(name):
    c.execute(f'SELECT * FROM items WHERE name=(:name)', {'name': name})
    bandaids=c.fetchall()        
    for checkitems in bandaids:
        bandages = checkitems[1]
        bandages = bandages - 1    
        return f'[Player {color(bandages, light_green)} has a total of {color("0", red)} kills!]'

async def reload(nick):
    c.execute(f"SELECT rowid FROM users WHERE name=(:name)", {'name': nick})
    data=c.fetchone()
    
    if data == None:
        logging.debug('User is trying to reload without having an account')
        await irc.bot.sendmsg(config.irc.channel, f'[User {nick} does not have an account]')
        return
    
    c.execute(f"SELECT * FROM weapons WHERE name=(:name)", {'name': nick})
    data=c.fetchall()
    name = nick
    for check in data:
        hasweapon = check[1]
        if hasweapon == False:
            logging.debug('User does not have weapon')
            await irc.bot.sendmsg(config.irc.channel, f'[You do not currently have a weapon.. !buy weapon]')
            return
    
        maxclip = 30
        clip = check[2]
        ammunition = check[3]
        if ammunition <= 0:
            return f'!buy ammo'
            
        clipadd = 30 - clip
        if ammunition >= clipadd:
            ammunition = ammunition - clipadd
            clip = clip + clipadd
        else:
            clip = clip + ammunition
            ammunition = 0
            
        logging.debug(f'[Current clip ammunition is at {clip} rounds and backup ammunition is at {ammunition} magazine rouunds!]')
        
        await irc.bot.sendmsg(config.irc.channel, f'[Current clip has {clip} rounds out of {maxclip} mag ammo size and {ammunition} in the arsenal!]')
        c.execute(f"UPDATE WEAPONS set CLIP = (:clip) WHERE NAME = (:name)", {'clip': clip, 'name': nick})
        conn.commit()
        c.execute(f"UPDATE WEAPONS set AMMUNITION = (:ammunition) WHERE NAME = (:name)", {'ammunition': ammunition, 'name': name})
        conn.commit()



async def shoot(player, nick):
    check = await checkexist(player)
    if check != True:
        return
    else:  
        if player == nick:
            logging.debug('Player cannot attack oneself')
            await irc.bot.sendmsg(config.irc.channel, f'[Error: {1}]'.format(0,color('Cannot Attack Yourself', red)))
        
        c.execute(f'SELECT rowid FROM weapons WHERE name=(:name)', {'name': nick})
        checkrow=c.fetchone()
        if checkrow == None:
            await irc.bot.sendmsg(config.irc.channel, f'[Error: {color("No Weapons", red)}] - !buy weapon')
        
        c.execute(f"SELECT * FROM users WHERE name=(:name)", {'name': nick})
        healthcheck = c.fetchall()
        for checkalive in healthcheck:
            alive = checkalive[3]
            if alive <= 0:
                await irc.bot.sendmsg(config.irc.channel, f'[Error: {color("You Are Dead... !revive", red)}]')
            
        c.execute(f"SELECT * FROM users WHERE name=(:name)", {'name': player})
        playerhealthcheck = c.fetchall()
        for checkalive in playerhealthcheck:
            health = checkalive[3]
            if health <= 0:
                logging.debug('Player targeted is DEAD')
                await irc.bot.sendmsg(config.irc.channel, f'[Player targeted is {color("DEAD", light_blue)}]')
        
        c.execute(f"SELECT * FROM weapons WHERE name=(:name)", {'name': nick})
        weapons = c.fetchall()
        for reg in weapons:
                
            name = nick
            weaponheld = reg[1]
            expire = reg[4]
            c.execute(f"SELECT rowid FROM weapons WHERE name=(:name)", {'name': name})

            if weaponheld == 0:
                await irc.bot.sendmsg(config.irc.channel, f'You do not own a weapon!')
                return
            clip = reg[2]
            
            ammunition = reg[3]
            
            if clip == 0:
                logging.debug('Weapon out of ammo! !buy ammo and !reload')
                c.execute("INSERT OR REPLACE INTO weapons VALUES (:name, :weaponheld, :clip, :ammunition, :expire)", {'name': nick, 'weaponheld': weaponheld, 'clip': clip, 'ammunition': ammunition, 'expire': expire})

                conn.commit()
                await irc.bot.sendmsg(config.irc.channel, f'{color("OUT OF AMMO - !reload", red)}')
                return
            else:
                c.execute("SELECT * FROM weapons WHERE name=(:name)", {'name': name})
                checkexpire=c.fetchall()
                for expiring in checkexpire:
                    expires = expiring[4]
                    if expires == 300:
                        logging.debug('User weapon has expired Weapon and Ammo Purged. !buy weapon')
                        c.execute('''UPDATE WEAPONS set WEAPONHELD = False,
                                  CLIP = 0,
                                  AMMUNITION = 0,
                                  EXPIRE = 0
                                  WHERE name = (:name)''', {'name': name})
                        conn.commit()
                        await irc.bot.sendmsg(config.irc.channel, f'[Player weapon has expired... purging weapon! <!buy weapon> for a new one]')

                    
                clip = clip - 3
                c.execute("INSERT OR REPLACE INTO weapons VALUES (:name, :weaponheld, :clip, :ammunition, :expire)", {'name': nick, 'weaponheld': weaponheld, 'clip': clip, 'ammunition': ammunition, 'expire': expire})

                conn.commit()
                    
                shooter = c.execute("SELECT * FROM users WHERE name=(:name)", {'name': player})
                for reg in shooter:
                    playerhealth = reg[3]
                    damage = random.randint(80, 120)
                    damage = min(damage, int(playerhealth))
        
                    playerhealth = int(playerhealth) - int(damage)
                    expire = expire + 1
                    c.execute("UPDATE WEAPONS set EXPIRE = (:expire) where NAME = (:name)", {'expire': expire, 'name': name})
                    conn.commit()
                    if playerhealth <= 0:
                        await addmoney(nick) 

                        playerhealth = 0
                        c.execute('UPDATE USERS set HEALTH = (:health) where NAME = (:name)', {'health': playerhealth, 'name': player})
                        conn.commit()
                        await irc.bot.sendmsg(config.irc.channel, '[Player {1} killed {2} and did {3} damage]'.format(0, color(nick, light_green), color(player, red), color(int(damage), light_green)))
                        await addkillstat(nick) 
                        await adddeathstat(player)
                        return
                    c.execute('UPDATE USERS set HEALTH = (:health) where NAME = (:name)', {'health': playerhealth, 'name': player})
                    conn.commit()
                    #return f'[{player} health is now {playerhealth} and took {damage} damage!]')
                    await irc.bot.sendmsg(config.irc.channel, '[Character: {1}] shot at [{2}] with an M16 and did [{3}] damage!'.format(0, color(nick, light_green), color(player, red), color(int(damage), green)))
 

                await irc.bot.sendmsg(config.irc.channel, f'[Remaining clip magazine rounds: {clip}]')
                return
async def shop():
    logging.debug('Printing shop items!')
    return f'[Shop Accessories]\r\n[!buy weapon - purchase a 3-round burst gun (note: weapon has a quality of 300 trigger limit)]\r\n[!buy ammo - buy ammunition (+60 rounds) for your weapon]\r\n[!buy bandages <amount>]\r\n'

  #  return f'[!buy bandages - buys bandages for health] {color("* not done yet", red)}')
async def buyammo(nick):
    c.execute(f"SELECT * FROM weapons WHERE name=:name", {'name': nick})
    weapons = c.fetchall()
    c.execute(f"SELECT * FROM users WHERE name=:name", {'name': nick})
    user = c.fetchall() 
    for reg in user:
       name = nick
       money = reg[6]
       newmoney = money - 50
       c.execute("UPDATE USERS set MONEY = (:money) where NAME = (:name)", {'money': newmoney, 'name': name})
       conn.commit()
       await irc.bot.sendmsg(config.irc.channel, f'[Player {name} purchased 60 rounds of ammunition!]')
    for weps in weapons:   
       
       ammunition = weps[3]
       weaponheld = weps[1]
       clip = weps[2]
       ammunition += 60
       expire = weps[4]
       c.execute("INSERT OR REPLACE INTO weapons VALUES (:name, :weaponheld, :clip, :ammunition, :expire)", {'name': nick, 'weaponheld': weaponheld, 'clip': clip, 'ammunition': ammunition, 'expire': expire})
       conn.commit()
       await irc.bot.sendmsg(config.irc.channel, f'[Player {nick} weapon ammunition is now {ammunition}]')
        
async def removeweapon(nick):
    remweapon = Weapons(nick, 0, 0, 0)

    c.execute("UPDATE WEAPONS set WEAPONHELD = (:weaponheld) where NAME = (:name)", {'weaponheld': 0, 'name': nick})
    conn.commit()
    logging.debug('Removed weapon')
    return f'[Player {nick} has been revoked of his/her weapon!]'   
async def buyweapon(nick):
    c.execute(f"SELECT * FROM weapons WHERE name=:name", {'name': nick})
    weapons = c.fetchall()
    c.execute(f"SELECT * FROM users WHERE name=:name", {'name': nick})
    user = c.fetchall()
    for regs in user:
       name = nick
       money = regs[6]
       for weapon in weapons:
         weaponheld = weapon[1]           
         if weaponheld == 1:
           logging.debug('Weapon is already held, returning')
           
           return f'[Weapon is already held, !buy ammo for more ammunition]'
           
    clip = 30
    ammunition = 60
    money = money - 500
       
    c.execute("UPDATE USERS set MONEY = (:money) where NAME = (:name)", {'money': money, 'name': nick})
    conn.commit()
    logging.debug(f'Attempting to buy Weapon for {nick}') 
    weaponheld = True
    logging.debug('Buying weapon')
    expire = 0
    c.execute("INSERT OR REPLACE INTO weapons VALUES (:name, :weaponheld, :clip, :ammunition, :expire)", {'name': nick, 'weaponheld': weaponheld, 'clip': clip, 'ammunition': ammunition, 'expire': expire})
    conn.commit()
    return f'[Player: {nick} has purchased a gun for $500! Loaded clip of {clip} rounds!]'


async def removeuser(nick):
    logging.debug(f'Removing user {nick}')
    name = nick
    c.execute('''DELETE FROM users WHERE name=?''',(name,))
    conn.commit() 
    c.execute('''DELETE FROM items WHERE name=?''',(name,))
    conn.commit() 
    c.execute('''DELETE FROM weapons WHERE name=?''',(name,))
    conn.commit() 
    c.execute('''DELETE FROM stats WHERE name=?''',(name,))
    conn.commit() 
    logging.debug(f'Removed user {nick}')

async def createuser(nick):
    
    logging.debug(f'Attemping to create user {nick}')
    reguser = Users(nick, 1, 500, 500, 100, 100, 5000, 500)
    
    logging.debug(f'User {nick} added to database')
    
    c.execute("INSERT OR REPLACE INTO users VALUES (:name, :level, :experience, :health, :attack, :defense, :money, :healthmax)", {'name': nick, 'level': reguser.level, 'experience': reguser.experience, 'health': reguser.health, 'attack': reguser.attack, 'defense': reguser.defense, 'money': reguser.money, 'healthmax': reguser.healthmax})
    conn.commit()
    c.execute(f'SELECT rowid FROM stats WHERE name=(:name)', {'name': nick})
    checkrow=c.fetchone()
    if checkrow == None:
        kills = 0
        deaths = 0
        c.execute(f'INSERT OR REPLACE INTO stats VALUES (:name, :kills, :deaths)', {'name': nick, 'kills': kills, 'deaths': deaths})  
        conn.commit()
        #return f'[Player {color(name, light_green)} has a total of {color(kills, red)} kills!]')
async def setlevel(nick, level):
    if level == '1':
        experience = '500'
        health = '500'
        attack = '100'
        defense = '100'
        healthmax = '500'
        c.execute(f'''UPDATE USERS set LEVEL = (:level),
                  EXPERIENCE = (:experience), 
                  HEALTH = (:health), 
                  ATTACK = (:attack), 
                  DEFENSE = (:defense),
                  HEALTHMAX = (:healthmax)
                  where NAME = (:name)''', {'level': level, 'experience': experience, 'health': health, 'attack': attack, 'defense': defense, 'name': nick, 'healthmax': healthmax})
        conn.commit()
        return f"[Player: {nick} is now level {color(level, red)}]"
   
    elif level == '2':
        experience = '1000'
        health = '1000'
        attack = '150'
        defense = '150'
        healthmax = '1000'
        c.execute(f'''UPDATE USERS set LEVEL = (:level),
                  EXPERIENCE = (:experience), 
                  HEALTH = (:health), 
                  ATTACK = (:attack), 
                  DEFENSE = (:defense),
                  HEALTHMAX = (:healthmax)
                  where NAME = (:name)''', {'level': level, 'experience': experience, 'health': health, 'attack': attack, 'defense': defense, 'name': nick, 'healthmax': healthmax})
        conn.commit()
        return f"[Player: {nick} is now level {color(level, red)}]"

     
    elif level == '3':
        experience = '2000'
        health = '1500'
        attack = '175'
        defense = '175'
        healthmax = '1500'
        c.execute(f'''UPDATE USERS set LEVEL = (:level),
                  EXPERIENCE = (:experience), 
                  HEALTH = (:health), 
                  ATTACK = (:attack), 
                  DEFENSE = (:defense),
                  HEALTHMAX = (:healthmax)
                  where NAME = (:name)''', {'level': level, 'experience': experience, 'health': health, 'attack': attack, 'defense': defense, 'name': nick, 'healthmax': healthmax})
        conn.commit()
        return f"[Player: {nick} is now level {color(level, red)}]"

    elif level == '4':
        experience = '3000'
        health = '2000'
        attack = '200'
        defense = '200'
        healthmax = '2000'
        c.execute(f'''UPDATE USERS set LEVEL = (:level),
                  EXPERIENCE = (:experience), 
                  HEALTH = (:health), 
                  ATTACK = (:attack), 
                  DEFENSE = (:defense),
                  HEALTHMAX = (:healthmax)
                  where NAME = (:name)''', {'level': level, 'experience': experience, 'health': health, 'attack': attack, 'defense': defense, 'name': nick, 'healthmax': healthmax})
        conn.commit()
        return f"[Player: {nick} is now level {color(level, red)}]"
  
    elif level == '5':
        experience = '5000'
        health = '3000'
        attack = '225'
        defense = '225'
        healthmax = '3000'
        c.execute(f'''UPDATE USERS set LEVEL = (:level),
                  EXPERIENCE = (:experience), 
                  HEALTH = (:health), 
                  ATTACK = (:attack), 
                  DEFENSE = (:defense),
                  HEALTHMAX = (:healthmax)
                  where NAME = (:name)''', {'level': level, 'experience': experience, 'health': health, 'attack': attack, 'defense': defense, 'name': nick, 'healthmax': healthmax})
        conn.commit()
        return f"[Player: {nick} is now level {color(level, red)}]"
    elif int(level) > 5:
        return "[Error: Invalid Level]"
        

async def closesql():  
    conn.close()
class combat:
    class attacker:
        name = ''
        attack = ''
    class defender:
        name = ''
        defense = ''
        health = ''
        
async def punch(player, nick):
    check = await checkexist(player)
    if check is False:
        return
    else:
        for name in (nick):
            c.execute(f"SELECT * FROM users WHERE name=:name", {'name': nick})
            attacker = c.fetchall()
            c.execute(f"SELECT * FROM users WHERE name=:name", {'name': player})
            defender = c.fetchall()
        if nick == player:
            await irc.bot.sendmsg(config.irc.channel, '[Error: {1}]'.format(0,color('Cannot Attack Yourself', red)))
            return
        for att in attacker:
            combat.attacker.name = att[0]
            combat.attacker.attack = att[4]
            combat.attacker.health = att[3]
            if combat.attacker.health == 0:
                await irc.bot.sendmsg(config.irc.channel, '[Error: You Are {1}!]'.format(0, color('Dead', red)))
                return
        for defend in defender:
            combat.defender.name = defend[0]
            combat.defender.defense = defend[5]
            combat.defender.health = defend[3]
        playerhealth = combat.defender.health

        if combat.defender.health <= 0:
                await irc.bot.sendmsg(config.irc.channel, f'[Player targeted is {color("DEAD", light_blue)}]')
                return
        playerdef = combat.defender.defense
        playerattack = combat.attacker.attack
        critical_multiplier = 1.1 if random.random() < 0.10 else 1.0
        effective_defense = int(playerdef) * random.uniform(0.9, 1.1)
        effective_attack = int(playerattack) * random.uniform(1.0, 1.1)
        damage = effective_attack * (50 / (50 + effective_defense)) * critical_multiplier
        damage = min(damage, int(playerhealth))
    
        combat.defender.health = int(playerhealth) - int(damage)
        c.execute(f'''UPDATE USERS set HEALTH = (:health) where NAME = (:name)''', {'health': combat.defender.health, 'name': combat.defender.name})
 
        conn.commit()
        if combat.defender.health <= 0:
            await irc.bot.sendmsg(config.irc.channel, '[Player {1} killed {2} and did {3} damage]'.format(0, color(nick, light_green), color(player, red), color(int(damage), light_green)))
            await addmoney(nick)
            await addkillstat(nick) 
            await adddeathstat(player)
            combat.defender.health = 0
            return
        await irc.bot.sendmsg(config.irc.channel, '[Character: {1}] Punched [{2}] and did [{3}] damage!'.format(0, color(nick, light_green), color(player, red), color(int(damage), green)))
 

        c.execute(f'''UPDATE USERS set HEALTH = (:health) where NAME = (:name)''', {'health': combat.defender.health, 'name': combat.defender.name})
 
        conn.commit()
       
async def profile(nick):
    
    name = nick
    check = await checkexist(nick)
    
    if check != True:
        return
    try:
        c.execute(f"SELECT * FROM users WHERE name=(:name)", {'name': nick})
        reg = c.fetchall()
        for regs in reg:
              name = regs[0]
              level = regs[1]
              experience = regs[2]
              health = regs[3]
              attack = regs[4]
              defense = regs[5]
              money = regs[6]
              healthmax = regs[7]
        c.execute(f'SELECT * FROM stats WHERE name=(:name)', {'name': name})
        grabstats=c.fetchall()
        for stats in grabstats:
            kills = stats[1]
            deaths = stats[2]
        return f'[Player: {color(name, light_green)}] [Level: {color(level, red)}] [Experience: {color(experience, blue)}] [Health: {color(health, light_green)}/{color(healthmax, green)}] [Att/Def: {color(attack, light_green)}/{color(defense, red)}] [Money: {color(money, light_blue)}] [Kills: {color(kills, light_blue)}] [Deaths: {color(deaths, red)}]'
 
    except Exception as ex:
       print('Error {0}'.format(0, ex))
       #bot.sendmsg(config.irc.channel, '[Error: No Such User]')

async def revive(nick):
    check = await checkexist(nick)
    if check != True:
        return
     
    c.execute("SELECT * FROM users WHERE name=(:name)", {'name': nick})

    checkhealth=c.fetchall()

    for amount in checkhealth:
        health = amount[3]
        max = amount[7]
        if health <= 0:
            c.execute("UPDATE USERS set HEALTH = (:health) WHERE NAME = (:name)", {'health': max, 'name': nick})
            logging.debug('test')
            conn.commit()
            return f'[Player {color(nick,light_green)} has been revived!]'
        else:
            return f'[You are not DEAD! No reviving the living!]'


async def getmoney(nick):
    c.execute(f"SELECT * FROM users WHERE name=(:name)", {'name': nick})
    moneygrab = c.fetchall()
    for money in moneygrab:
        moneyamount = money[6]
        writemoney = f'{moneyamount:,}'
        return f'[Bank Balance: ${color(writemoney, light_blue)}]'
async def getbandages(nick):
    name = nick
    c.execute(f'SELECT rowid FROM items WHERE name=(:name)', {'name': nick})
    data=c.fetchone()
    if data is None:
        bandages = 0
        c.execute(f'INSERT OR REPLACE INTO items VALUES (:name, :bandages)', {'name': name, 'bandages': bandages})
        conn.commit()
    c.execute(f"SELECT * FROM items WHERE name=(:name)", {'name': nick})
    bandages = c.fetchall()
    for bandage in bandages:
        bandageamount = bandage[1]
        if bandageamount == None:
            logging.debug('test')
            bandageamount = 0
        writebandageamount = f'{bandageamount:,}'
        return f'[Bandages: {color(writebandageamount, red)}]'
        
async def ammo(nick):
    c.execute(f'SELECT rowid FROM users WHERE name=(:name)', {'name': nick})
    exist = c.fetchone()
    
    if exist is None:
        return f'[User {nick} does not have an account!]'
        
    c.execute(f"SELECT * FROM weapons WHERE name=(:name)", {'name': nick})
    checkammo = c.fetchall()
    
    for ammo in checkammo:
        hasweapon =  ammo[1]
        if hasweapon == False:
            return f'[You do not currently have a weapon.. !buy weapon]'
            
        ammoclipcount = ammo[2]
        ammomagcount = ammo[3]
    return f"[Ammo Count] [Current Clip Holding: {ammoclipcount}] [Arsenal Magazine Rounds: {ammomagcount}]"
async def addmoney(nick):
    c.execute(f"SELECT * FROM users WHERE name=:name", {'name': nick})
    
    moneygrab = c.fetchall()
    
    for money in moneygrab:
        moneyamount = money[6]
        profit = 500
        moneyamount += profit
        moneyamountformat = f'{moneyamount:,}'
        c.execute(f'''UPDATE USERS set MONEY = (:money) where NAME = (:name)''', {'money': moneyamount, 'name': nick})
        conn.commit()
                           
        return f'[You gained ${color(profit, blue)}!] [Bank Balance: ${color(moneyamountformat, light_blue)}]'