X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FGame.js;fp=server%2Fmodels%2FGame.js;h=e6c26168749d2726605715d0617a3f7ffc13435a;hp=4a8c517a19b136e612977aba5853cb12427ddb32;hb=9f9e9a0588d4b28a1825a56ae53553d89bf0c65f;hpb=26580d874deaea68cfb1b926549b1ee2720e9ec9 diff --git a/server/models/Game.js b/server/models/Game.js index 4a8c517a..e6c26168 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -85,9 +85,10 @@ const GameModel = { let query = "SELECT " + "g.id, g.fen, g.fenStart, g.cadence, g.created, " + - "g.white, g.black, g.score, g.scoreMsg, " + - "g.chatReadWhite, g.chatReadBlack, " + - "g.drawOffer, g.rematchOffer, v.name AS vname " + + "g.white, g.black, g.randomness, g.score, g.scoreMsg, " + + "g.chatReadWhite, g.chatReadBlack, g.drawOffer, " + + // TODO: vid and vname are redundant + "g.rematchOffer, v.id as vid, v.name AS vname " + "FROM Games g " + "JOIN Variants v " + " ON g.vid = v.id " +