1.1 --- a/s4-funcs.sh	Mon Apr 25 19:46:25 2016 +0859
     1.2 +++ b/s4-funcs.sh	Mon Apr 25 19:47:27 2016 +0859
     1.3 @@ -27,6 +27,8 @@
     1.4  thumbxy=96x96
     1.5  maximagexy=1600x1600
     1.6  ### maximagexy=400x400
     1.7 +file_accept='accept="image/*,application/vnd.*,application/pdf,text/*"'
     1.8 +
     1.9  tconfs=""
    1.10  imgcached=imgcache.`date +%Y/%m`
    1.11  conftbl=_tblconf
    1.12 @@ -1945,8 +1947,8 @@
    1.13  <h4>$grp 参加者一覧</h4>
    1.14  <table>
    1.15  `sq $db -html "$sql"`
    1.16 +</table>
    1.17  `cgi_hidden grp $grid`
    1.18 -</table>
    1.19  EOF
    1.20  }
    1.21  editheading() {	# $1=rowid-of-heading
    1.22 @@ -2216,8 +2218,7 @@
    1.23  $scols from $2 a left join\
    1.24   (select $pk,$eav,
    1.25  	max(case key when 'owner'
    1.26 -	 then coalesce((select val from user_s us
    1.27 -		 where us.key='gecos' and us.name=c.val), val) end) as gecos
    1.28 +	 then (SELECT gecos FROM gecoses WHERE name=val) END) as gecos
    1.29   from ${2}_s c group by $pk) b on a.$pk=b.$pk $4;"}
    1.30    err SQL=`echo "$sql"`
    1.31    cat<<EOF | sed "s,\(<TR><TD>\)\([1-9][0-9]*\)</TD>,\1$elink$dvlink</TD>,"