search

DoubleV37 / ft_transcendence

4 stars 0 forks source link

feature/Dashboard/Back #74

Closed ji2myji2my closed 4 months ago

ji2myji2my commented 5 months ago

Over view db to DashBoard:

image

ji2myji2my commented 4 months ago

SELECT * FROM "Game_usergame" JOIN "Game_games" ON "Game_usergame"."game_id" = "Game_games"."id" WHERE "user_id"=2 ORDER BY "user_id"

ji2myji2my commented 4 months ago

SELECT opponent."score" AS "opponent score", "Game_usergame"., "Game_games".

FROM "Game_usergame" JOIN "Game_games" ON "Game_usergame"."game_id" = "Game_games"."id" JOIN "Game_usergame" AS opponent ON "Game_usergame"."game_id" = opponent."game_id" WHERE "Game_usergame"."user_id" = 2 AND opponent."user_id" != 2 ORDER BY "Game_usergame"."user_id";

ji2myji2my commented 4 months ago

Bug found. It was caused by an unmanaged merge conflict. The IA name was changed to IA-Ochen and this change was not made.