Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-funcs.sh @ 1018:2fd483245e8e draft
Delete user from grp_adm* table as well as from grp_mem*.
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Sun, 27 Aug 2023 08:52:32 +0859 |
| parents | b47c4aa5f7a4 |
| children | 4952d9b79b7d |
comparison
equal
deleted
inserted
replaced
| 1017:f5b97df8d824 | 1018:2fd483245e8e |
|---|---|
| 3033 if [ x"$rm" = x"yes" ]; then | 3033 if [ x"$rm" = x"yes" ]; then |
| 3034 if [ "$isowner" ]; then | 3034 if [ "$isowner" ]; then |
| 3035 if [ x"$rm$cfm" = x"yesyes" ]; then | 3035 if [ x"$rm$cfm" = x"yesyes" ]; then |
| 3036 # Eliminate | 3036 # Eliminate |
| 3037 cond="where gname=(select gname from grp where rowid=$grid) and user in (select name from user where rowid in ($uids))" | 3037 cond="where gname=(select gname from grp where rowid=$grid) and user in (select name from user where rowid in ($uids))" |
| 3038 for tbl in grp_mem grp_mem_s grp_mem_m; do | 3038 for tbl in grp_mem grp_mem_s grp_mem_m grp_adm grp_adm_s grp_adm_m |
| 3039 do | |
| 3039 sql="delete from $tbl $cond;" | 3040 sql="delete from $tbl $cond;" |
| 3040 # echo "sql=$sql" | 3041 # echo "sql=$sql" |
| 3041 query "$sql" | 3042 query "$sql" |
| 3042 err rmGRPuser "$sql" | 3043 err rmGRPuser "$sql" |
| 3043 done | 3044 done |
