equal
deleted
inserted
replaced
35 import CoreTypes |
35 import CoreTypes |
36 import Utils |
36 import Utils |
37 |
37 |
38 |
38 |
39 dbQueryAccount = |
39 dbQueryAccount = |
40 "SELECT users.pass, \ |
40 "SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, \ |
41 \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), \ |
41 \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), \ |
42 \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) \ |
42 \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) \ |
43 \ FROM users WHERE users.name = ?" |
43 \ FROM users WHERE users.name = ?" |
44 |
44 |
45 dbQueryStats = |
45 dbQueryStats = |