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

9 10 11 12 13
#
# Standard Testbed Header
#
PAGEHEADER("New Project Approved");

14
#
15
# Only known and logged in users can do this.
16
#
17
$uid = GETLOGIN();
18 19 20 21 22
LOGGEDINORDIE($uid);

#
# Of course verify that this uid has admin privs!
#
23 24
$isadmin = ISADMIN($uid);
if (! $isadmin) {
Chad Barb's avatar
Chad Barb committed
25
    USERERROR("You do not have admin privileges to approve projects!", 1);
26 27
}

28 29 30 31 32
#
# See if we are in an initial Emulab setup.
#
$FirstInitState = (TBGetFirstInitState() == "approveproject");

33
echo "<center><h1>
34
      Approving Project '$pid' ...
35 36 37
      </h1></center>";

#
38
# Grab the head_uid for this project. This verifies it is a valid project.
39
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
40 41
$query_result = 
    DBQueryFatal("SELECT head_uid from projects where pid='$pid'");
42 43 44 45
if (($row = mysql_fetch_row($query_result)) == 0) {
    TBERROR("Unknown project $pid", 1);
}
$headuid = $row[0];
46

47 48 49 50 51 52 53 54 55 56 57
#
# If the user wanted to change the head uid, do that now (we change both
# the head_uid and the leader of the default project)
#
if (isset($head_uid) && strcmp($head_uid,"")) {
    $headuid = $head_uid;
    DBQueryFatal("UPDATE projects set head_uid='$headuid' where pid='$pid'");
    DBQueryFatal("UPDATE groups set leader='$headuid' where pid='$pid' and " .
	    "gid='$pid'");
}

58 59 60 61 62
if (!isset($user_interface) ||
    !in_array($user_interface, $TBDB_USER_INTERFACE_LIST)) {
    $user_interface = TBDB_USER_INTERFACE_EMULAB;
}

63 64 65 66 67 68 69 70 71 72
#
# Get the current status for the headuid, which we might need to change
# anyway, and to verify that the user is a valid user. We also need
# the email address to let the user know what happened.
#
# We change the status only if this person is starting his first project.
# In this case, the status will be either "newuser" or "unapproved",
# and we will change it to "unapproved" or "active", respectively.
# If the status is "active", we leave it alone. 
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
73 74 75
$query_result = 
    DBQueryFatal("SELECT status,usr_email,usr_name from users ".
		 "where uid='$headuid'");
76 77 78 79 80 81
if (mysql_num_rows($query_result) == 0) {
    TBERROR("Unknown user $headuid", 1);
}
$row = mysql_fetch_row($query_result);
$curstatus     = $row[0];
$headuid_email = $row[1];
82
$headname      = $row[2];
83
#echo "Status = $curstatus, Email = $headuid_email<br>\n";
84

85
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
86 87
# Then we check that the headuid is really listed in the group_membership
# table (default group), just to be sure. 
88
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
89 90 91
$query_result =
    DBQueryFatal("SELECT trust from group_membership where ".
		 "uid='$headuid' and pid='$pid' and gid='$pid'");
92 93 94
if (mysql_num_rows($query_result) == 0) {
    USERERROR("User $headuid is not the leader of project $pid.", 1);
}
95

96 97 98 99 100
#
# Well, looks like everything is okay. Change the project approval
# value appropriately.
#
if (strcmp($approval, "postpone") == 0) {
101 102
    if (isset($message) && strcmp($message, "")) {
	USERERROR("You requested postponement for $pid, but there is a ".
103 104 105
		  "message in the text box which will vanish. If that is ".
		  "not what you intended, the back button will give you ".
		  "another chance, with text intact.", 1);
106
    }
107 108 109 110 111 112
    echo "<p><h3>
             Project approval for project $pid (User: $headuid) was
             postponed for later decision.
          </h3>\n";
}
elseif (strcmp($approval, "moreinfo") == 0) {
113 114
    TBMAIL("$headname '$headuid' <$headuid_email>",
         "Project '$pid' Approval Postponed",
115 116
         "\n".
         "This message is to notify you that your project application\n".
117 118
         "for $pid has been postponed until we have more information.\n".
         "You can just reply to this message to provide more information.\n".
119 120 121
         "\n$message".
         "\n\n".
         "Thanks,\n".
122
         "Testbed Operations\n",
123 124
         "From: $TBMAIL_APPROVAL\n".
         "Bcc: $TBMAIL_APPROVAL\n".
125 126 127 128 129 130 131 132
         "Errors-To: $TBMAIL_WWW");

    echo "<p><h3>
             Project approval for project $pid (User: $headuid) was
             postponed pending the reception of more information.
          </h3>\n";
}
elseif ((strcmp($approval, "deny") == 0) ||
133
	(strcmp($approval, "annihilate") == 0) ||
134
	(strcmp($approval, "destroy") == 0)) {
135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
    SUEXEC($uid, $TBADMINGROUP, "rmproj $pid", 1);
    
    if (strcmp($approval, "annihilate")) {
	TBMAIL("$headname '$headuid' <$headuid_email>",
	       "Project '$pid' Denied",
	       "\n".
	       "This message is to notify you that your project application\n".
	       "for $pid has been denied.\n".
	       "\n$message".
	       "\n\n".
	       "Thanks,\n".
	       "Testbed Operations\n",
	       "From: $TBMAIL_APPROVAL\n".
	       "Bcc: $TBMAIL_APPROVAL\n".
	       "Errors-To: $TBMAIL_WWW");
    }
151 152

    #
153
    # Well, if the "destroy" option was given, kill the users account.
154
    #
155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171
    if ((strcmp($approval, "annihilate") == 0) ||
	(strcmp($approval, "destroy") == 0)) {
	SUEXEC($uid, $TBADMINGROUP, "webrmuser $headuid", 1); 
	
	if (strcmp($approval, "annihilate")) {
	    TBMAIL("$headname '$headuid' <$headuid_email>",
		   "Account '$headuid' Terminated",
		   "\n".
		   "This message is to notify you that your account has \n".
		   "been terminated because your project $pid was denied.\n".
		   "\n\n".
		   "Thanks,\n".
		   "Testbed Operations\n",
		   "From: $TBMAIL_APPROVAL\n".
		   "Bcc: $TBMAIL_APPROVAL\n".
		   "Errors-To: $TBMAIL_WWW");
	}
172
    }
173

174 175 176 177 178
    echo "<h3><p>
              Project $pid (User: $headuid) has been denied.
          </h3>\n";
}
elseif (strcmp($approval, "approve") == 0) {
179 180 181 182 183 184 185 186 187 188 189 190 191 192

    #
    # Change the status if necessary. This only happens for new users
    # being approved in their first project. After this, the status is
    # going to be "active", and we just leave it that way.
    #
    if (strcmp($curstatus, "active")) {
        if (strcmp($curstatus, "unapproved") == 0) {
	    $newstatus = "active";
        }
        else {
	    TBERROR("Invalid $headuid status $curstatus in ".
                    "approveproject.php3", 1);
        }
193 194
	DBQueryFatal("UPDATE users set status='$newstatus', ".
		     "       user_interface='$user_interface' ".
195 196 197
		     "WHERE uid='$headuid'");
    }

198
    #
199
    # Set the project "approved" field to true. 
200
    #
201 202 203
    DBQueryFatal("update projects set approved='1', ".
		 "       default_user_interface='$user_interface' ".
		 "where pid='$pid'");
204

205 206 207 208 209 210 211
    #
    # XXX
    # Temporary Plab hack.
    #
    $pcremote_ok = array();
    if (isset($pcplab_okay) &&
	!strcmp($pcplab_okay, "Yep")) {
212
	    $pcremote_ok[] = "pcplabphys";
213
    }
214
    # RON implies pcwa too.
215 216 217
    if (isset($ron_okay) &&
	!strcmp($ron_okay, "Yep")) {
	    $pcremote_ok[] = "pcron";
218
	    $pcremote_ok[] = "pcwa";
219 220 221 222 223 224 225
    }
    if (count($pcremote_ok)) {
	    $foo = implode(",", $pcremote_ok);
	    DBQueryFatal("UPDATE projects set pcremote_ok='$foo' ".
			 "WHERE pid='$pid'");
    }

226 227
    TBMAIL("$headname '$headuid' <$headuid_email>",
         "Project '$pid' Approval",
228
         "\n".
229 230 231 232
	 "This message is to notify you that your project '$pid'\n".
	 "has been approved.  We recommend that you save this link so that\n".
	 "you can send it to people you wish to have join your project.\n".
	 "Otherwise, tell them to go to ${TBBASE} and join it.\n".
233 234 235 236 237
	 "\n".
	 "    ${TBBASE}/joinproject.php3?target_pid=$pid\n".
         "\n".
	 "$message\n".
         "\n".
238
         "Thanks,\n".
239
         "Testbed Operations\n",
240 241
         "From: $TBMAIL_APPROVAL\n".
         "Bcc: $TBMAIL_APPROVAL\n".
242
         "Errors-To: $TBMAIL_WWW");
243

244
    #
245 246
    # Invoke the script. This does it all. If it fails, we will find out
    # about it.
247
    #
248 249 250 251 252 253
    echo "<br>
          Project '$pid' is being created!<br><br>
          This will take a minute or two. <b>Please</b> do not click the Stop
          button during this time. If you do not receive notification within
          a reasonable amount of time, please contact $TBMAILADDR.\n";
    flush();
254

255
    SUEXEC($uid, $TBADMINGROUP, "webmkproj $pid", SUEXEC_ACTION_DIE); 
256

257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281
    if (!$FirstInitState) {
	echo "<p><b>
                 Project $pid (User: $headuid) has been approved.
                </b>\n";
    }
    else {
	echo "<br><br><font size=+1>\n";
	echo "Congratulations! You have successfully setup your initial Emulab
              Project. You should now ".
	      "<a href=login.php3?vuid=$headuid>login</a>
              using the account you just
              created so that you can continue setting up your new Emulab!
              </font><br>\n";
        #
 	# Freeze the initial user.
        #
        DBQueryFatal("update users set ".
                     "  status='" . TBDB_USERSTATUS_FROZEN . "' ".
	             "where uid='$FIRSTUSER'");

        #
        # Move to next phase. 
        # 
        TBSetFirstInitState("Ready");
    }
282 283
}
else {
284 285 286
    TBERROR("Invalid approval value $approval in approveproject.php3.", 1);
}

287 288 289 290
#
# Standard Testbed Footer
# 
PAGEFOOTER();
291
?>