editgroup.php3 8.25 KB
Newer Older
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1
<?php
Leigh B. Stoller's avatar
Leigh B. Stoller committed
2 3
#
# EMULAB-COPYRIGHT
4
# Copyright (c) 2000-2003 University of Utah and the Flux Group.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
5 6
# All rights reserved.
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
7 8 9 10
include("defs.php3");
include("showstuff.php3");

#
11
# No testbed header since we spit out a redirect.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
12
#
13
ignore_user_abort(1);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

#
# Only known and logged in users.
#
$uid = GETLOGIN();
LOGGEDINORDIE($uid);

#
# First off, sanity check page args.
#
if (!isset($pid) ||
    strcmp($pid, "") == 0) {
    USERERROR("Must provide a Project ID!", 1);
}
if (!isset($gid) ||
    strcmp($gid, "") == 0) {
    USERERROR("Must privide a Group ID!", 1);
}

#
34
# The default group membership cannot be changed, but the trust levels can.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
35
#
36
$defaultgroup = 0;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
37
if (strcmp($gid, $pid) == 0) {
38
    $defaultgroup = 1;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
39 40 41 42 43
}

#
# Verify permission. 
#
44
if (! TBProjAccessCheck($uid, $pid, $gid, $TB_PROJECT_EDITGROUP)) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
45 46 47 48
    USERERROR("You do not have permission to edit group $gid in ".
	      "project $pid!", 1);
}

49 50 51 52 53 54 55 56
#
# See if user is allowed to add non-members to group.
# 
$grabusers = 0;
if (TBProjAccessCheck($uid, $pid, $gid, $TB_PROJECT_GROUPGRABUSERS)) {
    $grabusers = 1;
}

Leigh B. Stoller's avatar
Leigh B. Stoller committed
57 58
#
# Grab the current user list for the group. The group leader cannot be
59 60
# removed! Do not include members that have not been approved to main
# group either! This will force them to go through the approval page first.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
61 62 63 64 65
#
$curmembers_result =
    DBQueryFatal("select distinct m.uid from group_membership as m ".
		 "left join groups as g on g.pid=m.pid and g.gid=m.gid ".
		 "where m.pid='$pid' and m.gid='$gid' and ".
66
		 "      m.uid!=g.leader and m.trust!='none'");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
67 68 69

#
# Grab the user list from the project. These are the people who can be
70 71 72
# added. Do not include people in the above list, obviously! Do not
# include members that have not been approved to main group either! This
# will force them to go through the approval page first.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
73 74
# 
$nonmembers_result =
75
    DBQueryFatal("select m.uid from group_membership as m ".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
76 77
		 "left join group_membership as a on ".
		 "     a.uid=m.uid and a.pid=m.pid and a.gid='$gid' ".
78 79
		 "where m.pid='$pid' and m.gid=m.pid and a.uid is NULL ".
		 "      and m.trust!='none'");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
80

81 82
function TBCheckTrustConsistency($user, $pid, $gid, $newtrust)
{
83 84
    global $TBDB_TRUST_USER;
    
85 86
    #
    # If changing default group trust level, then compare levels.
87 88
    # A user may not have root privs in the project and user privs
    # in the group; make no sense to do that and can violate trust.
89 90 91
    #
    if (strcmp($pid, $gid)) {
	$projtrust = TBProjTrust($user, $pid);
92 93 94

	if (TBTrustConvert($newtrust) == $TBDB_TRUST_USER &&
	    $projtrust > $TBDB_TRUST_USER) {
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135
	    USERERROR("User $user may not have a higher trust level in ".
		      "the default group of $pid, than in subgroup $gid!", 1);
	}
    }
    else
	$projtrust = TBTrustConvert($newtrust);

    #
    # Get all the subgroups not equal to the subgroup being changed.
    # 
    $query_result =
	DBQueryFatal("select trust,gid from group_membership ".
		     "where uid='$user' and pid='$pid' and trust!='none' ".
		     " and gid!=pid and gid!='$gid'");

    while ($row = mysql_fetch_array($query_result)) {
	$grptrust = $row[0];
	$ogid     = $row[1];

	if ($projtrust > TBTrustConvert($grptrust)) {
	    USERERROR("User $user may not have a higher trust level in ".
		      "the default group of $pid, than in subgroup $ogid!", 1);
	}

	if (strcmp($pid, $gid)) {
            #
            # Check to make sure new trust is same as all other subgroup trust.
            # 
	    if (strcmp($newtrust, $grptrust)) {
		USERERROR("User $user may not have different trust levels in ".
			  "different subgroups of $pid!", 1);
	    }
	}
    }
    return 1;
}

#
# First pass does checks. Second pass does the real thing. 
#

Leigh B. Stoller's avatar
Leigh B. Stoller committed
136 137 138
#
# Go through the list of current members. For each one, check to see if
# the checkbox for that person was checked. If not, delete the person
139 140
# from the group membership. Otherwise, look to see if the trust level
# has been changed.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
141 142 143
# 
if (mysql_num_rows($curmembers_result)) {
    while ($row = mysql_fetch_array($curmembers_result)) {
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
	$user = $row[0];
	$foo  = "change_$user";

	#
	# Is member to be deleted?
	# 
	if (!$defaultgroup && !isset($$foo)) {
	    # Yes.
	    continue;
	}

        #
        # There should be a corresponding trust variable in the POST vars.
        # Note that we construct the variable name and indirect to it.
        #
        $foo      = "$user\$\$trust";
	$newtrust = $$foo;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
161
	
162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179
	if (!$newtrust || strcmp($newtrust, "") == 0) {
	    TBERROR("Error finding trust for $user in editgroup.php3", 1);
	}

	if (strcmp($newtrust, "user") &&
	    strcmp($newtrust, "local_root") &&
	    strcmp($newtrust, "group_root")) {
	    TBERROR("Invalid trust $newtrust for $user in editgroup.php3.", 1);
	}

	TBCheckTrustConsistency($user, $pid, $gid, $newtrust);
    }
}

#
# Go through the list of non members. For each one, check to see if
# the checkbox for that person was checked. If so, add the person
# to the group membership, with the trust level specified.
180 181 182 183
# Only do this if user has permission to grab users. 
#

if ($grabusers && !$defaultgroup && mysql_num_rows($nonmembers_result)) {
184 185 186 187 188
    while ($row = mysql_fetch_array($nonmembers_result)) {
	$user = $row[0];
	$foo  = "add_$user";
	
	if (isset($$foo)) {
189 190 191 192 193
	    #
	    # There should be a corresponding trust variable in the POST vars.
	    # Note that we construct the variable name and indirect to it.
	    #
	    $bar      = "$user\$\$trust";
194
	    $newtrust = $$bar;
195
	    
196 197 198 199
	    if (!$newtrust || strcmp($newtrust, "") == 0) {
		TBERROR("Error finding trust for $user in editgroup.php3",
			1);
	    }
200
	    
201 202 203 204 205 206
	    if (strcmp($newtrust, "user") &&
		strcmp($newtrust, "local_root") &&
		strcmp($newtrust, "group_root")) {
		TBERROR("Invalid trust $newtrust for $user in editgroup.php3.",
			1);
	    }
207
	    
208 209 210 211 212 213
	    TBCheckTrustConsistency($user, $pid, $gid, $newtrust);
	}
    }
}

#
214 215
# Now do the second pass, which makes the changes. Record the user IDs
# that are changed so that we can pass that to setgroups below.
216
#
217
$modusers = "";
218 219 220 221 222 223 224 225 226 227 228 229 230

#
# Go through the list of current members. For each one, check to see if
# the checkbox for that person was checked. If not, delete the person
# from the group membership. Otherwise, look to see if the trust level
# has been changed.
#
if (mysql_num_rows($curmembers_result)) {
    mysql_data_seek($curmembers_result, 0);
    
    while ($row = mysql_fetch_array($curmembers_result)) {
	$user = $row[0];
	$foo  = "change_$user";
231

232
	if (!$defaultgroup && !isset($$foo)) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
233
	    DBQueryFatal("delete from group_membership ".
234 235
			 "where pid='$pid' and gid='$gid' and uid='$user'");

236
	    $modusers = "$modusers $user";
237
	    continue;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
238
	}
239 240 241 242 243 244 245 246 247
        #
        # There should be a corresponding trust variable in the POST vars.
        # Note that we construct the variable name and indirect to it.
        #
        $foo      = "$user\$\$trust";
	$newtrust = $$foo;
	
	DBQueryFatal("update group_membership set trust='$newtrust' ".
		     "where pid='$pid' and gid='$gid' and uid='$user'");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
248 249 250 251 252 253
    }
}

#
# Go through the list of non members. For each one, check to see if
# the checkbox for that person was checked. If so, add the person
254
# to the group membership, with the trust level specified.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
255
# 
256

257 258 259
if ($grabusers && !$defaultgroup && mysql_num_rows($nonmembers_result)) {
    mysql_data_seek($nonmembers_result, 0);
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
260
    while ($row = mysql_fetch_array($nonmembers_result)) {
261 262
	$user = $row[0];
	$foo  = "add_$user";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
263 264
	
	if (isset($$foo)) {
265 266 267 268 269
	    #
	    # There should be a corresponding trust variable in the POST vars.
	    # Note that we construct the variable name and indirect to it.
	    #
	    $bar      = "$user\$\$trust";
270
	    $newtrust = $$bar;
271
	    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
272
	    DBQueryFatal("insert into group_membership ".
273 274 275
			 "(uid, pid, gid, trust, ".
			 " date_applied,date_approved) ".
			 "values ('$user','$pid','$gid', '$newtrust', ".
Leigh B. Stoller's avatar
Leigh B. Stoller committed
276
			 "        now(), now())");
277 278
	    
	    $modusers = "$modusers $user";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
279 280 281 282 283 284 285 286 287 288 289 290 291 292
	}
    }
}

#
# Grab the unix GID for running scripts.
#
TBGroupUnixInfo($pid, $pid, $unix_gid, $unix_name);

#
# Run the script. This will do the account stuff for all the people
# in the group. This is the same script that gets run when the group
# is first created.
#
293
SUEXEC($uid, $unix_gid, "websetgroups -p $pid $modusers", 1);
294

Leigh B. Stoller's avatar
Leigh B. Stoller committed
295
#
296 297
# Spit out a redirect so that the history does not include a post
# in it. The back button skips over the post and to the form.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
298
# 
299
header("Location: showgroup.php3?pid=$pid&gid=$gid");
300

301
# No Testbed footer.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
302
?>