def get_rank(uniqueid): ggDB = Database() # Get the current number of wins for the uniqueid currentWins = ggDB.select( 'gg_wins', 'wins', 'where uniqueid = "%s"' % uniqueid) # Return -1 if the player has no wins if currentWins == None: return -1 # Return the count + 1 of players who have more wins than the uniqueid return ggDB.select( "gg_wins", ("COUNT(*)"), "WHERE ABS(wins) > %s" % currentWins) + 1
def get_rank(uniqueid): ggDB = Database() # Get the current number of wins for the uniqueid currentWins = ggDB.select('gg_wins', 'wins', 'where uniqueid = "%s"' % uniqueid) # Return -1 if the player has no wins if currentWins == None: return -1 # Return the count + 1 of players who have more wins than the uniqueid return ggDB.select("gg_wins", ("COUNT(*)"), "WHERE ABS(wins) > %s" % currentWins) + 1
def get_winners_list(n=10): ''' Returns an ordered list dicts of (n) player names in order from highest to lowest win count. ''' if not str(n).isdigit(): raise ValueError('Expected digit, and got a str() (%s)' % n) n = int(n) ggDB = Database() winner_list = ggDB.select('gg_wins', ('name', 'uniqueid', 'wins'), 'ORDER BY ABS(wins) DESC', True, n) if winner_list: return winner_list return []
def get_winners_list(n=10): ''' Returns an ordered list dicts of (n) player names in order from highest to lowest win count. ''' if not str(n).isdigit(): raise ValueError('Expected digit, and got a str() (%s)' % n) n = int(n) ggDB = Database() winner_list = ggDB.select('gg_wins', ('name', 'uniqueid', 'wins'), 'ORDER BY ABS(wins) DESC', True, n) if winner_list: return winner_list return []