Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-funcs.sh @ 181:fcfed35ca6d8
Gecos column of NEWS table switched to gecos instead of id
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Fri, 26 Feb 2016 23:12:16 +0859 |
| parents | 59bd085848ec |
| children | 5ba50e0850c9 |
comparison
equal
deleted
inserted
replaced
| 180:59bd085848ec | 181:fcfed35ca6d8 |
|---|---|
| 1368 sum(case when l.time is null then 1 | 1368 sum(case when l.time is null then 1 |
| 1369 when l.time < ctime then 1 | 1369 when l.time < ctime then 1 |
| 1370 else 0 | 1370 else 0 |
| 1371 end) "新着", | 1371 end) "新着", |
| 1372 count(id) "総数", ctime, title, | 1372 count(id) "総数", ctime, title, |
| 1373 owner gecos -- (select gecos from gecoses where name=bl.owner) gecos | 1373 /* owner gecos */ |
| 1374 (select gecos from gecoses where name=bl.owner) gecos | |
| 1374 from blogall bl left join acclog_user l | 1375 from blogall bl left join acclog_user l |
| 1375 on bl.rowid=round(l.tblrowid) | 1376 on bl.rowid=round(l.tblrowid) |
| 1376 where case when (select name from user where owner=name) is not null | 1377 where case when (select name from user where owner=name) is not null |
| 1377 then 1 /* user's diary is always readable */ | 1378 then 1 /* user's diary is always readable */ |
| 1378 when (select val from grp_s | 1379 when (select val from grp_s |
