--- a/rust/hedgewars-server/src/server/database.rs Tue Dec 17 18:54:17 2019 +0300
+++ b/rust/hedgewars-server/src/server/database.rs Thu Dec 19 23:13:58 2019 +0300
@@ -7,8 +7,7 @@
const CHECK_ACCOUNT_EXISTS_QUERY: &str =
r"SELECT 1 FROM users WHERE users.name = :username LIMIT 1";
-const GET_ACCOUNT_QUERY: &str =
- r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END,
+const GET_ACCOUNT_QUERY: &str = r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END,
(SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3),
(SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13)
FROM users WHERE users.name = :username";