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