s4
changeset 203:c120ade0c9c3
Change table header ID to LINK
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 25 Apr 2016 09:23:34 +0859 |
parents | f103e36953d3 |
children | 71a2c840cfd7 |
files | s4-funcs.sh |
diffstat | 1 files changed, 4 insertions(+), 3 deletions(-) [+] |
line diff
1.1 --- a/s4-funcs.sh Sun Apr 24 17:21:57 2016 +0859 1.2 +++ b/s4-funcs.sh Mon Apr 25 09:23:34 2016 +0859 1.3 @@ -1367,7 +1367,7 @@ 1.4 from blog_title_owner b, article_ctime ac 1.5 on b.id=ac.blogid 1.6 ) 1.7 - select rowid ID, 1.8 + select rowid LINK, 1.9 sum(case when l.time is null then 1 1.10 when l.time < ctime then 1 1.11 else 0 1.12 @@ -1452,7 +1452,8 @@ 1.13 # Display Most Recent Entry 1.14 shortval=${dumpcollen:+"substr(val, 0, $dumpcollen)"} 1.15 shortval=${shortval:-val} 1.16 - DT_SQL="SELECT b.rowid, ctime, 1.17 + DT_SQL="SELECT b.rowid LINK, 1.18 + ctime, 1.19 (SELECT $shortval FROM blog_s WHERE key='title' AND id=b.id) title, 1.20 (SELECT gecos FROM gecoses 1.21 WHERE name=(SELECT val FROM blog_s 1.22 @@ -2210,7 +2211,7 @@ 1.23 done 1.24 #case author when '$user' then a.rowid else '---' end as ID, 1.25 sql=${DT_SQL:-"select \ 1.26 -a.rowid as ID,\ 1.27 +a.rowid as LINK,\ 1.28 $cnt\ 1.29 $scols from $2 a left join\ 1.30 (select $pk,$eav,