Mercurial > hgrepos > hgweb.cgi > s4
changeset 507:145fb3cca3fb
User email values are in user_m, not user_s.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Wed, 06 Mar 2019 14:15:53 +0900 |
parents | 36c4d7ea464d |
children | 944739c3ac5c |
files | s4-funcs.sh |
diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Mon Jan 14 02:10:34 2019 +0900 +++ b/s4-funcs.sh Wed Mar 06 14:15:53 2019 +0900 @@ -1282,9 +1282,9 @@ useremails AS ( SELECT user.rowid rid, user.name, val email FROM user - LEFT JOIN user_s - ON user.name=user_s.name AND user_s.key='email') - SELECT DISTINCT coalesce(g.email, u.name) + LEFT JOIN user_m + ON user.name=user_m.name AND user_m.key='email') + SELECT DISTINCT coalesce(g.email, u.email, u.name) FROM useremails u LEFT JOIN grpemails g ON u.name=g.user WHERE u.rid in ($uids);"