"WHERE players.player_name=%s AND levels.level_id=%s", (player_name, level_number))
best_score = [(row[0]) for row in cursor.fetchall()]
# If length isn't greater than 0 there is no existing best score
if len(best_score) > 0:
return best_score[0]
else:
return None
if __name__ == "__main__":
# Turn on debug mode
cgitb.enable()
# Print necessary headers
print("Content-Type: text/html; charset=utf-8\n\n")
form = cgi.FieldStorage()
player_name = processing.get_player_name(form)
level_number = processing.get_level_number(form)
if player_name is not None and level_number is not None:
best_score = get_best_score(player_name, level_number)
if best_score is not None:
print(json.dumps(best_score))
else:
# If score doesn't exist for that player/level
print(json.dumps(None))
else:
# If player/level not provided
print(json.dumps(None))
