Mercurial > hgrepos > hgweb.cgi > s4
changeset 647:a8a5e6437f1a
Fix for member listing in group home
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Fri, 08 May 2020 17:08:49 +0900 |
| parents | d9bce34a863b |
| children | 8ec02e0fd1d5 |
| files | s4-funcs.sh |
| diffstat | 1 files changed, 4 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Thu May 07 23:03:33 2020 +0900 +++ b/s4-funcs.sh Fri May 08 17:08:49 2020 +0900 @@ -2216,11 +2216,9 @@ qtag=`sqlquote "$tag"` cond2="tag=$qtag" fi - if [ -n "$cond1$cond2$3" ]; then - cond="$cond1${cond2:+ AND $cond2}${3:+ AND ($3)}" - cond=${cond# AND } - cond=${cond% AND } - cond=${cond:+WHERE $cond} + if [ -n "$cond1$cond2" ]; then + cond="$cond1${cond2:+ AND $cond2}" + cond="WHERE ${cond# AND }" fi # XX: これ複雑すぎるかな。もっとシンプルにしたい。$3条件も。2015-07-08 @@ -2269,7 +2267,7 @@ max(case key when 'wtime' then val end) as wtime, max(case key when 'login' then val end) as login from ${tbl}_s group by $nm) - b on a.$nm=b.name $cond /* $3 */ + b on a.$nm=b.name $cond $3 order by b.wtime desc, b.login desc, b.mtime desc, b.tag desc, a.rowid asc" # Give precedence to newer maintained groups (2016-09-24)
