equal
deleted
inserted
replaced
1 use mysql; |
1 use mysql; |
2 use mysql::{error::DriverError, error::Error, from_row_opt, params}; |
2 use mysql::{error::DriverError, error::Error, from_row_opt, params}; |
3 use openssl::sha::sha1; |
3 use openssl::sha::sha1; |
4 |
4 |
5 use crate::{ |
5 use crate::handlers::{AccountInfo, Sha1Digest}; |
6 handlers::{Sha1Digest, AccountInfo} |
|
7 }; |
|
8 |
6 |
9 const GET_ACCOUNT_QUERY: &str = |
7 const GET_ACCOUNT_QUERY: &str = |
10 r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, |
8 r"SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, |
11 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), |
9 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), |
12 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) |
10 (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) |