def findPlayer(targetID): global cursor if cursor == None: cursor = SQLHelper.connectToSource().cursor() query = """select PlayerID from Players where PlayerID = %s or PlayerID =%s%s or GamerTag like %s order by missions desc limit 1""" prefix = cfg.getConfigString("ID Prefix") data = (targetID, prefix, targetID, '%%%s%%' % (targetID)) cursor.execute(query, data) result = cursor.fetchone() if result != None and len(result) == 1: return result[0] return "0-0-0"
from DBG import DBG import math import ConfigHelper as cfg import SQLHelper import colorama from colorama import Fore, Back import feedbackQueue from psycopg2 import sql #: last 5 games' stats #: Blobs, month to month. #: Top achievement in terms of rarity #: most recent achievements #: Places visited conn = SQLHelper.connectToSource() cursor = conn.cursor() colorama.init() #https://codegolf.stackexchange.com/questions/4707/outputting-ordinal-numbers-1st-2nd-3rd#answer-4712 ordinal = [ '0th', '%s%s1st%s%s' % (Fore.BLACK, Back.YELLOW, Fore.YELLOW, Back.BLACK), '%s%s2nd%s%s' % (Fore.BLACK, Back.WHITE, Fore.YELLOW, Back.BLACK), '%s%s3rd%s%s' % (Fore.BLACK, Back.RED, Fore.YELLOW, Back.BLACK), '4th', '5th', '6th', '7th', '8th', '9th', '10th', '11th', '12th', '13th', '14th', '15th', '16th', '17th', '18th', '19th', '20th', '21st', '22nd', '23rd', '24th', '25th', '26th', '27th', '28th', '29th', '30th', '31st', '32nd', '33rd', '34th', '35th', '36th', '37th', '38th', '39th', '40th', '41st', '42nd', '43rd', '44th', '45th', '46th', '47th', '48th', '49th', '50th' ]