def getPP(userID, gameMode): """ Get userID's PP relative to gameMode userID -- user return -- gameMode number """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch("SELECT pp_{} FROM users_stats WHERE id = ?".format(modeForDB), [userID])["pp_{}".format(modeForDB)]
def getPlaycount(userID, gameMode): """ Get userID's playcount relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- playcount """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch("SELECT playcount_"+modeForDB+" FROM users_stats WHERE id = ?", [userID])["playcount_"+modeForDB]
def getAccuracy(userID, gameMode): """ Get userID's average accuracy relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- accuracy """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch("SELECT avg_accuracy_"+modeForDB+" FROM users_stats WHERE id = ?", [userID])["avg_accuracy_"+modeForDB]
def getTotalScore(userID, gameMode): """ Get userID's total score relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- total score """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch("SELECT total_score_"+modeForDB+" FROM users_stats WHERE id = ?", [userID])["total_score_"+modeForDB]
def getUserRankedScore(userID, gameMode): """ Get userID's ranked score relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- ranked score """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch("SELECT ranked_score_"+modeForDB+" FROM users_stats WHERE osu_id = ?", [userID])["ranked_score_"+modeForDB]
def getPP(userID, gameMode): """ Get userID's PP relative to gameMode userID -- user return -- gameMode number """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch( "SELECT pp_{} FROM users_stats WHERE id = ?".format(modeForDB), [userID])["pp_{}".format(modeForDB)]
def getPlaycount(userID, gameMode): """ Get userID's playcount relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- playcount """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch( "SELECT playcount_" + modeForDB + " FROM users_stats WHERE id = ?", [userID])["playcount_" + modeForDB]
def getAccuracy(userID, gameMode): """ Get userID's average accuracy relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- accuracy """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch( "SELECT avg_accuracy_" + modeForDB + " FROM users_stats WHERE id = ?", [userID])["avg_accuracy_" + modeForDB]
def getTotalScore(userID, gameMode): """ Get userID's total score relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- total score """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch( "SELECT total_score_" + modeForDB + " FROM users_stats WHERE id = ?", [userID])["total_score_" + modeForDB]
def getUserRankedScore(userID, gameMode): """ Get userID's ranked score relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- ranked score """ modeForDB = gameModes.getGameModeForDB(gameMode) return glob.db.fetch( "SELECT ranked_score_" + modeForDB + " FROM users_stats WHERE osu_id = ?", [userID])["ranked_score_" + modeForDB]
def getGameRank(userID, gameMode): """ Get userID's **in-game rank** (eg: #1337) relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- game rank """ modeForDB = gameModes.getGameModeForDB(gameMode) result = glob.db.fetch("SELECT position FROM leaderboard_"+modeForDB+" WHERE user = ?", [userID]) if result == None: return 0 else: return result["position"]
def getGameRank(userID, gameMode): """ Get userID's **in-game rank** (eg: #1337) relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- game rank """ modeForDB = gameModes.getGameModeForDB(gameMode) result = glob.db.fetch( "SELECT position FROM leaderboard_" + modeForDB + " WHERE user = ?", [userID]) if result == None: return 0 else: return result["position"]
def getRankedScore(userID, gameMode): """ Get userID's ranked score relative to gameMode userID -- userID gameMode -- int value, see gameModes return -- ranked score """ modeForDB = gameModes.getGameModeForDB(gameMode) if str(modeForDB) == "std": # We want to make sure users with some ranked scores but 0 pp won't see score intead of pp # Also we want to make sure you see the pp grind instead of ranked-score grind after submitting return 0 else: return glob.db.fetch( "SELECT ranked_score_" + modeForDB + " FROM users_stats WHERE id = ?", [userID])["ranked_score_" + modeForDB]