From: Alexis Laferrière <alexis.laf@xymus.net>
Date: Wed, 6 Apr 2016 15:40:54 +0000 (-0400)
Subject: contrib/benitlux: fix superstring in benitlux_social
X-Git-Url: http://nitlanguage.org

contrib/benitlux: fix superstring in benitlux_social

Signed-off-by: Alexis Laferrière <alexis.laf@xymus.net>
---

diff --git a/contrib/benitlux/src/benitlux_social.nit b/contrib/benitlux/src/benitlux_social.nit
index 70ee217..bdd83b4 100644
--- a/contrib/benitlux/src/benitlux_social.nit
+++ b/contrib/benitlux/src/benitlux_social.nit
@@ -312,9 +312,10 @@ GROUP BY beer0, beer1""") else
 	# List reciprocal friends of `user_id`
 	fun followed_followers(user_id: Int): nullable Array[User]
 	do
-		var stmt = select("ROWID, name FROM users WHERE " +
-			"ROWID in (SELECT user_from FROM follows WHERE user_to = {user_id}) AND " +
-			"ROWID in (SELECT user_to FROM follows WHERE user_from = {user_id})")
+		var stmt = select("""
+ROWID, name FROM users WHERE
+	users.ROWID in (SELECT user_from FROM follows WHERE user_to = {{{user_id}}}) AND
+	users.ROWID in (SELECT user_to FROM follows WHERE user_from = {{{user_id}}})""")
 		assert stmt != null else print_error "Select 'followed_followers' failed with: {error or else "?"}"
 
 		var users = new Array[User]
@@ -514,8 +515,8 @@ ORDER BY average LIMIT 1""")
 		var sql = """
 ROWID, name FROM users
 WHERE 1 in (SELECT is_in FROM checkins WHERE user = users.ROWID ORDER BY ROWID DESC LIMIT 1)
-	AND ROWID in (SELECT user_from FROM follows WHERE user_to = {user_id})
-	AND ROWID in (SELECT user_to FROM follows WHERE user_from = {user_id})"""
+	AND ROWID in (SELECT user_from FROM follows WHERE user_to = {{{user_id}}})
+	AND ROWID in (SELECT user_to FROM follows WHERE user_from = {{{user_id}}})"""
 
 		var stmt = select(sql)
 		if stmt == null then