equal
deleted
inserted
replaced
5 use crate::handlers::{AccountInfo, Sha1Digest}; |
5 use crate::handlers::{AccountInfo, Sha1Digest}; |
6 |
6 |
7 const CHECK_ACCOUNT_EXISTS_QUERY: &str = |
7 const CHECK_ACCOUNT_EXISTS_QUERY: &str = |
8 r"SELECT 1 FROM users WHERE users.name = :username LIMIT 1"; |
8 r"SELECT 1 FROM users WHERE users.name = :username LIMIT 1"; |
9 |
9 |
10 const GET_ACCOUNT_QUERY: &str = |
10 const GET_ACCOUNT_QUERY: &str = r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, |
11 r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, |
|
12 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), |
11 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), |
13 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) |
12 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) |
14 FROM users WHERE users.name = :username"; |
13 FROM users WHERE users.name = :username"; |
15 |
14 |
16 const STORE_STATS_QUERY: &str = r"INSERT INTO gameserver_stats |
15 const STORE_STATS_QUERY: &str = r"INSERT INTO gameserver_stats |