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,