Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-funcs.sh @ 233:1ad7ef38c0a0
Display gecos correctly in listentry(user)
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Fri, 24 Jun 2016 22:28:31 +0859 |
parents | 4511cecade55 |
children | 014f459543d5 |
comparison
equal
deleted
inserted
replaced
232:4511cecade55 | 233:1ad7ef38c0a0 |
---|---|
1630 coalesce(b.$gcs, a.$nm) as nick, | 1630 coalesce(b.$gcs, a.$nm) as nick, |
1631 coalesce(b.gecos, a.$nm) /* If group, concat (Nusers) */ | 1631 coalesce(b.gecos, a.$nm) /* If group, concat (Nusers) */ |
1632 || case when a.$nm in (select gname from grp) | 1632 || case when a.$nm in (select gname from grp) |
1633 then printf('(%d名)', | 1633 then printf('(%d名)', |
1634 (select count(user) from grp_mem where gname=a.$nm)) | 1634 (select count(user) from grp_mem where gname=a.$nm)) |
1635 else '<a.$nm>' | 1635 else ' <'||a.$nm||'>' |
1636 end | 1636 end |
1637 as name, | 1637 as name, |
1638 b.tag, | 1638 b.tag, |
1639 case when a.$nm in (select user from grp_adm | 1639 case when a.$nm in (select user from grp_adm |
1640 where gname=$getgrp) then '(管理者)' | 1640 where gname=$getgrp) then '(管理者)' |