import re
import sqlite3

def do_karma(bot, user, channel, karma):
    if karma[1] == '++':
        k = 1
    else:
        k = -1

    conn = sqlite3.connect('karma.db')
    c = conn.cursor()
    t = (karma[0],)
    c.execute('select * from karma where word=?', t)
    res = c.fetchone()

    if res != None:
        u = k + res[2]
        q = (u,karma[0],)
        c.execute('update karma set karma = ? where word=?', q)
    else:
        u = k
        q = (karma[0],u,)
        c.execute('insert into karma (word, karma) VALUES (?,?)',q)
    
    conn.commit()
        
  
    return bot.say(channel, "Karma for %s is now %s" % (karma[0], u))


def handle_privmsg(bot, user, reply, msg):
    """Grab karma changes from the messages and handle them"""

    m = re.findall('([a-zA-Z0-9.-_]*)(\+\+|\-\-)', msg)
    if len(m) == 0: return None

    for k in m:
        do_karma(bot, user, reply, k)

    return


import re
import sqlite3

def do_karma(bot, user, channel, karma):
    if karma[1] == '++':
        k = 1
    else:
        k = -1

    conn = sqlite3.connect('karma.db')
    c = conn.cursor()
    t = (karma[0],)
    c.execute('select * from karma where word=?', t)
    res = c.fetchone()

    if res != None:
        u = k + res[2]
        q = (u,karma[0].lower(),)
        c.execute('update karma set karma = ? where word=?', q)
    else:
        u = k
        q = (karma[0].lower(),u,)
        c.execute('insert into karma (word, karma) VALUES (?,?)',q)
    
    conn.commit()
        
  
    return bot.say(channel, "Karma for %s is now %s" % (karma[0], u))


def handle_privmsg(bot, user, reply, msg):
    """Grab karma changes from the messages and handle them"""

    m = re.findall('([a-zA-Z0-9.-_]*)(\+\+|\-\-)', msg)
    if len(m) == 0: return None

    for k in m:
        do_karma(bot, user, reply, k)

    return


Add .tolower() when adding to DB to avoid potential issues
Add .tolower() when adding to DB to avoid potential issues

  import re
  import sqlite3
  
  def do_karma(bot, user, channel, karma):
      if karma[1] == '++':
          k = 1
      else:
          k = -1
  
      conn = sqlite3.connect('karma.db')
      c = conn.cursor()
      t = (karma[0],)
      c.execute('select * from karma where word=?', t)
      res = c.fetchone()
  
      if res != None:
          u = k + res[2]
-         q = (u,karma[0],)
+         q = (u,karma[0].lower(),)
          c.execute('update karma set karma = ? where word=?', q)
      else:
          u = k
-         q = (karma[0],u,)
+         q = (karma[0].lower(),u,)
          c.execute('insert into karma (word, karma) VALUES (?,?)',q)
      
      conn.commit()
          
    
      return bot.say(channel, "Karma for %s is now %s" % (karma[0], u))
  
  
  def handle_privmsg(bot, user, reply, msg):
      """Grab karma changes from the messages and handle them"""
  
      m = re.findall('([a-zA-Z0-9.-_]*)(\+\+|\-\-)', msg)
      if len(m) == 0: return None
  
      for k in m:
          do_karma(bot, user, reply, k)
  
      return
  
  
Add .tolower() when adding to DB to avoid potential issues
## Code Before:
import re
import sqlite3

def do_karma(bot, user, channel, karma):
    if karma[1] == '++':
        k = 1
    else:
        k = -1

    conn = sqlite3.connect('karma.db')
    c = conn.cursor()
    t = (karma[0],)
    c.execute('select * from karma where word=?', t)
    res = c.fetchone()

    if res != None:
        u = k + res[2]
        q = (u,karma[0],)
        c.execute('update karma set karma = ? where word=?', q)
    else:
        u = k
        q = (karma[0],u,)
        c.execute('insert into karma (word, karma) VALUES (?,?)',q)
    
    conn.commit()
        
  
    return bot.say(channel, "Karma for %s is now %s" % (karma[0], u))


def handle_privmsg(bot, user, reply, msg):
    """Grab karma changes from the messages and handle them"""

    m = re.findall('([a-zA-Z0-9.-_]*)(\+\+|\-\-)', msg)
    if len(m) == 0: return None

    for k in m:
        do_karma(bot, user, reply, k)

    return


## Instruction:
Add .tolower() when adding to DB to avoid potential issues
## Code After:
import re
import sqlite3

def do_karma(bot, user, channel, karma):
    if karma[1] == '++':
        k = 1
    else:
        k = -1

    conn = sqlite3.connect('karma.db')
    c = conn.cursor()
    t = (karma[0],)
    c.execute('select * from karma where word=?', t)
    res = c.fetchone()

    if res != None:
        u = k + res[2]
        q = (u,karma[0].lower(),)
        c.execute('update karma set karma = ? where word=?', q)
    else:
        u = k
        q = (karma[0].lower(),u,)
        c.execute('insert into karma (word, karma) VALUES (?,?)',q)
    
    conn.commit()
        
  
    return bot.say(channel, "Karma for %s is now %s" % (karma[0], u))


def handle_privmsg(bot, user, reply, msg):
    """Grab karma changes from the messages and handle them"""

    m = re.findall('([a-zA-Z0-9.-_]*)(\+\+|\-\-)', msg)
    if len(m) == 0: return None

    for k in m:
        do_karma(bot, user, reply, k)

    return

