- // For display on MyGames or Hall: no need for moves or chats
- getByUser: function(uid, excluded, cb)
- {
- // Some fields are not required when showing a games list:
- const getOneLight = (id, cb2) => {
+ // For display on Hall: no need for moves or chats
+ getObserved: function(uid, cursor, cb) {
+ db.serialize(function() {
+ let query =
+ "SELECT id, vid, cadence, created, score, white, black " +
+ "FROM Games " +
+ "WHERE created < " + cursor + " ";
+ if (uid > 0) {
+ query +=
+ " AND white <> " + uid + " " +
+ " AND black <> " + uid + " ";
+ }
+ query +=
+ "ORDER BY created DESC " +
+ "LIMIT 20"; //TODO: 20 hard-coded...
+ db.all(query, (err, games) => {
+ // Query players names
+ let pids = {};
+ games.forEach(g => {
+ if (!pids[g.white]) pids[g.white] = true;
+ if (!pids[g.black]) pids[g.black] = true;
+ });
+ UserModel.getByIds(Object.keys(pids), (err2, users) => {
+ let names = {};
+ users.forEach(u => { names[u.id] = u.name; });
+ cb(
+ err,
+ games.map(
+ g => {
+ return {
+ id: g.id,
+ vid: g.vid,
+ cadence: g.cadence,
+ created: g.created,
+ score: g.score,
+ players: [
+ { id: g.white, name: names[g.white] },
+ { id: g.black, name: names[g.black] }
+ ]
+ };
+ }
+ )
+ );
+ });
+ });
+ });
+ },
+
+ // For display on MyGames: registered user only
+ getRunning: function(uid, cb) {
+ db.serialize(function() {