X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=30d29c7317972b55886c6a9718cd4a2b5af5c298;hb=88667455b8793075a0266d4477fa0f4d03257cb0;hp=23a74e81ed7140baadd5aabac8c569f5eb16e39c;hpb=625022fdcf750f0aff8fcd699f7e9b89730e1d10;p=vchess.git

diff --git a/server/models/Game.js b/server/models/Game.js
index 23a74e81..30d29c73 100644
--- a/server/models/Game.js
+++ b/server/models/Game.js
@@ -30,7 +30,7 @@ const GameModel =
 	// mainTime and increment in milliseconds
 	create: function(vid, fen, mainTime, increment, players, cb)
 	{
-		db.serialize({
+		db.serialize(function() {
 			let query =
 				"INSERT INTO Games (vid, fen, mainTime, addTime) " +
 				"VALUES (" + vid + ",'" + fen + "'," + mainTime + "," + increment + ")";
@@ -94,14 +94,14 @@ const GameModel =
 		});
 	},
 
-	getByUser: function(uid, cb)
+	getByUser: function(uid, excluded, cb)
 	{
 		db.serialize(function() {
 			// Next query is fine because a player appear at most once in a game
 			const query =
 				"SELECT gid " +
 				"FROM Players " +
-				"WHERE uid = " + uid;
+				"WHERE uid " + (excluded ? "<>" : "=") + " " + uid;
 			db.run(query, (err,gameIds) => {
 				if (!!err)
 					return cb(err);