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))
