def sign_up():
# on récupère le json envoyé par le client
formulaire_inscription = (request.get_json())
# on récupère l'email
email = formulaire_inscription["email"]
# on check si l'email existe, si oui on envoie une erreur
sql_request = f'''SELECT * FROM players WHERE players_email = "{email}"'''
players_avec_cette_email = sql_select(sql_request)
if len(players_avec_cette_email) > 0:
return "Email déjà existant", 503
# on ajoute le joueur
sql_request = f'''INSERT INTO players(players_pseudo, players_email, players_password)
VALUES("{formulaire_inscription["pseudo"]}",
"{formulaire_inscription["email"]}",
"{formulaire_inscription["password"]}")'''
players_id = sql_insert(sql_request)
add_room(players_id, 0, 0, formulaire_inscription["seed"])
return "OK", 200
def add_room(players_id, pos_x, pos_y, seed):
request_sql = f'''SELECT * FROM rooms WHERE rooms.players_id = {players_id} AND rooms.rooms_position_x = {pos_x} AND rooms.rooms_position_y = {pos_y}'''
checkroom = sql_select(request_sql)
if len(checkroom) > 0:
return "Il y a deja une salle à cet endroit", 404
else:
request_sql = f'''INSERT INTO rooms(players_id, rooms_position_x, rooms_position_y, rooms_seed)
VALUES ('{players_id}', '{pos_x}', '{pos_y}', '{seed}')'''
room_build = sql_insert(request_sql)
return jsonify({"id": room_build})
def add_room(players_id, pos_x, pos_y, seed):
sql_request = f'''SELECT * FROM rooms
WHERE players_id = "{players_id}"
AND rooms_position_x = "{pos_x}"
AND rooms_position_x = "{pos_y}"'''
player_rooms_info = sql_select(sql_request)
if len(player_rooms_info) > 0:
return "Il y a déjà une room ici", 403
else:
sql_request = f'''INSERT INTO rooms (rooms_position_x, rooms_position_y, rooms_seed, players_id)
VALUES("{pos_x}", "{pos_y}", "{seed}", "{players_id}")'''
execute = sql_insert(sql_request)
return {"id": execute}, 200
def add_room(players_id, pos_x, pos_y, seed):
sql_request = f'''SELECT * FROM rooms
WHERE rooms.players_id = "{players_id}"
AND rooms.rooms_position_x = "{pos_x}"
AND rooms.rooms_position_y = "{pos_y}"'''
checkroom = sql_select(sql_request)
if len(checkroom) > 0:
return "il y a deja une room ici", 404
else:
sql_request = f'''INSERT INTO rooms (players_id, rooms_position_x, rooms_position_y, rooms_seed)
VALUES("{players_id}", "{pos_x}", "{pos_y}", "{seed}")'''
room_build = sql_insert(sql_request)
return jsonify({"id": room_build}), 200
def add_room(players_id, pos_x, pos_y, seed):
# Requête pour créer une nouvelle ligne dans la table rooms
sql_request = f'''INSERT INTO `rooms`
(`rooms_id`, `rooms_position_x`, `rooms_position_y`, `rooms_seed`, `players_id`)
VALUES (NULL, '{pos_x}', '{pos_y}', '{seed}', '{players_id}');'''
# On check s'il existe déjà une salle à l'endroit désiré
sql_request2 = f'''SELECT rooms_position_x,rooms_position_y FROM `rooms` WHERE players_id = {players_id}'''
rooms_positions = sql_select(sql_request2)
for rooms in rooms_positions:
if pos_x == rooms["rooms_position_x"] and pos_y == rooms["rooms_position_y"]:
return "Il y a déjà une salle à cette position", 403
# On insert la nouvelle salle dans la BDD et on renvoit l"id de la salle.
new_room = sql_insert(sql_request)
new_room_dico = {"id": new_room}
return jsonify(new_room_dico), 200
def add_room(players_id, pos_x, pos_y, seed):
#check si une room existe déja a cette position
sql_request = f'''SELECT * FROM rooms
WHERE player_id = "{players_id}"
AND rooms_position_x = "{pos_x}"
AND rooms_position_y = "{pos_y}"'''
player_rooms_info = sql_select(sql_request)
if len(player_rooms_info) > 0
return "une room éxiste déja ici", 403
else:
sql_request = f'''INSERT INTO rooms(rooms_position_y, rooms_seed, player_id)
VALUES("{pos_x}", "{pos_y}", "{seed}", "{players_id}")'''
execute = sql_insert(sql_request)
return {"id": execute}, 200
def add_room(players_id, pos_x, pos_y, seed):
sql_request = f'''SELECT * FROM rooms
WHERE players_id = {players_id}
AND rooms_position_x ={pos_x}
AND rooms_position_y ={pos_y}
'''
player_rooms_info = sql_select(sql_request)
if len(player_rooms_info) > 0:
return "Une Salle existe deja à ces coordonnées", 501
else:
sql_request = f'''INSERT INTO rooms(rooms_position_x, rooms_position_y, rooms_seed, players_id)
VALUES({pos_x}, {pos_y}, {seed}, {players_id})'''
add = sql_insert(sql_request)
return {"id": add}, 200