Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-funcs.sh @ 174:fe8a381f9483
Column "rowid" in acclog renamed to tblrowid
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Fri, 19 Feb 2016 18:03:37 +0859 |
parents | 31e63d173d38 |
children | 3d12521876f2 |
comparison
equal
deleted
inserted
replaced
173:31e63d173d38 | 174:fe8a381f9483 |
---|---|
2105 _t=${DT_CHLD%:*} _i=${DT_CHLD#*:} | 2105 _t=${DT_CHLD%:*} _i=${DT_CHLD#*:} |
2106 cntall="(select count($_i) from $_t where $_i=a.id)" | 2106 cntall="(select count($_i) from $_t where $_i=a.id)" |
2107 cntnew="(select count(val) from ${_t}_s where key='ctime' \ | 2107 cntnew="(select count(val) from ${_t}_s where key='ctime' \ |
2108 and id in (select id from $_t where $_i=a.id) \ | 2108 and id in (select id from $_t where $_i=a.id) \ |
2109 and val > coalesce((select time from acclog where \ | 2109 and val > coalesce((select time from acclog where \ |
2110 user='$user' and tbl='$2' and rowid=a.rowid),\ | 2110 user='$user' and tbl='$2' and tblrowid=a.rowid),\ |
2111 '1970-01-01'))" | 2111 '1970-01-01'))" |
2112 cnt="$cntnew as '新着', $cntall as '総数'," | 2112 cnt="$cntnew as '新着', $cntall as '総数'," |
2113 dt_class=" td2r td3r" | 2113 dt_class=" td2r td3r" |
2114 fi | 2114 fi |
2115 # Construct join expression | 2115 # Construct join expression |