s4

changeset 39:5ed3caba8dd1

report-closed + user mode -> hidden to other user
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 22 Jul 2015 15:52:01 +0900
parents 1f04814e7dad
children 8cb89ace6110
files s4-funcs.sh
diffstat 1 files changed, 5 insertions(+), 2 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Wed Jul 22 13:28:20 2015 +0900
     1.2 +++ b/s4-funcs.sh	Wed Jul 22 15:52:01 2015 +0900
     1.3 @@ -371,8 +371,11 @@
     1.4  	then (select user from grp_adm where \
     1.5  		gname=(select val from getowner) and \
     1.6  		user='$1')\
     1.7 -	else 'user' end;"
     1.8 -  err isfilereadable: sql="$sql"
     1.9 +	when (select author from article where\
    1.10 +		id=(select id from $2 where rowid=$3))='$1'
    1.11 +	then 'user+author'
    1.12 +	else '' end;"
    1.13 +  err isfilereadable: sql="`echo $sql`"
    1.14    # caseのネストで内側のcaseがスカラーtrueを返しても外側はtrue扱いにならない
    1.15    result=`query "$sql"`
    1.16    [ -n "$result" ] && return 0