connection, cursor = processing.connect_to_database() # Change the appropriate username cursor.execute("UPDATE players SET player_name=%s" "WHERE player_id=%s", (username, player_id)) connection.commit() 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() current_name = processing.get_player_name(form) new_name = processing.get_new_name(form) if current_name is not None and new_name is not None: player_id = processing.get_player_id(current_name) if player_id is not None and processing.username_is_unique(new_name): change_player_name(new_name, player_id) print(json.dumps(new_name)) else: # If player doesn't exist in database or new name isn't unique print(json.dumps(None)) else: # If original name/new name not provided or new name already taken print(json.dumps(None))
# Insert the score cursor.execute("INSERT INTO scores VALUES(%s, %s, %s)", (player_id, level_number, score)) connection.commit() if __name__ == "__main__": 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) score = processing.get_score(form) if player_name != None and level_number != None and score != None: if not level_exists(level_number): processing.add_level(level_number) player_id = processing.get_player_id(player_name) if player_id != None and score_empty(player_id, level_number): add_score(player_id, level_number, score) print(json.dumps([player_name, level_number, score])) else: # If score already exists or player not in database print(json.dumps(None)) else: # If player/level/score not provided print(json.dumps(None))