showstuff.php3 52.9 KB
Newer Older
1
2
<?php
#
Leigh B. Stoller's avatar
Leigh B. Stoller committed
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
7
# All rights reserved.
#
#
8
9
10
11
12
13
14
15
16
17
18
# This is an included file. No headers or footers.
#
# Functions to dump out various things.  
#

#
# A project
#
function SHOWPROJECT($pid, $thisuid) {
    global $TBDBNAME;

19
20
    $query_result =
	DBQueryFatal("SELECT * FROM projects WHERE pid='$pid'");
21
22
    $row = mysql_fetch_array($query_result);

23
24
25
    echo "<center>
          <h3>Project Profile</h3>
          </center>
26
          <table align=center cellpadding=2 border=1>\n";
27
    
28
    $proj_created	= $row[created];
29
    #$proj_expires	= $row[expires];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
30
    $proj_name		= stripslashes($row[name]);
31
    $proj_URL		= $row[URL];
32
    $proj_public        = $row[public];
33
    $proj_funders	= stripslashes($row[funders]);;
34
35
36
    $proj_head_uid	= $row[head_uid];
    $proj_members       = $row[num_members];
    $proj_pcs           = $row[num_pcs];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
37
38
    $proj_ronpcs        = $row[num_ron];
    $proj_plabpcs       = $row[num_pcplab];
39
    $proj_why           = nl2br($row[why]);
40
    $control_node	= $row[control_node];
41
    $approved           = $row[approved];
42
43
    $expt_count         = $row[expt_count];
    $expt_last          = $row[expt_last];
44

45
46
47
48
49
50
51
    if ($proj_public) {
	$proj_public = "Yes";
    }
    else {
	$proj_public = "No";
    }

52
53
54
55
    if (!$expt_last) {
	$expt_last = "&nbsp";
    }

56
57
58
59
60
    #
    # Generate the table.
    # 
    echo "<tr>
              <td>Name: </td>
61
62
              <td class=\"left\">
                <a href='showproject.php3?pid=$pid'>$pid</a></td>
63
64
65
66
67
68
69
70
71
72
          </tr>\n";
    
    echo "<tr>
              <td>Long Name: </td>
              <td class=\"left\">$proj_name</td>
          </tr>\n";
    
    echo "<tr>
              <td>Project Head: </td>
              <td class=\"left\">
73
                <A href='showuser.php3?target_uid=$proj_head_uid'>
74
75
76
77
78
79
80
81
82
                     $proj_head_uid</A></td>
          </tr>\n";
    
    echo "<tr>
              <td>URL: </td>
              <td class=\"left\">
                  <A href='$proj_URL'>$proj_URL</A></td>
          </tr>\n";
    
83
84
85
86
87
    echo "<tr>
              <td>Publicly Visible: </td>
              <td class=\"left\">$proj_public</td>
          </tr>\n";
    
88
89
90
91
92
    echo "<tr>
              <td>Funders: </td>
              <td class=\"left\">$proj_funders</td>
          </tr>\n";

93
94
95
96
97
98
99
100
101
102
103
    echo "<tr>
              <td>#Project Members: </td>
              <td class=\"left\">$proj_members</td>
          </tr>\n";
    
    echo "<tr>
              <td>#PCs: </td>
              <td class=\"left\">$proj_pcs</td>
          </tr>\n";
    
    echo "<tr>
104
105
106
107
108
109
110
              <td>#Planetlab PCs: </td>
              <td class=\"left\">$proj_plabpcs</td>
          </tr>\n";
    
    echo "<tr>
              <td>#RON PCs: </td>
              <td class=\"left\">$proj_ronpcs</td>
111
112
113
114
115
116
117
          </tr>\n";
    
    echo "<tr>
              <td>Created: </td>
              <td class=\"left\">$proj_created</td>
          </tr>\n";
    
118
119
120
121
    #echo "<tr>
    #          <td>Expires: </td>
    #          <td class=\"left\">$proj_expires</td>
    #      </tr>\n";
122
    
123
124
125
126
127
128
129
130
131
132
    echo "<tr>
              <td>Experiments Created:</td>
              <td class=\"left\">$expt_count</td>
          </tr>\n";
    
    echo "<tr>
              <td>Date of last experiment:</td>
              <td class=\"left\">$expt_last</td>
          </tr>\n";
    
133
134
135
136
137
138
139
140
141
142
    echo "<tr>
              <td>Approved?: </td>\n";
    if ($approved) {
	echo "<td class=left><img alt=\"Y\" src=\"greenball.gif\"></td>\n";
    }
    else {
	echo "<td class=left><img alt=\"N\" src=\"redball.gif\"></td>\n";
    }
    echo "</tr>\n";

143
    echo "<tr>
144
              <td colspan='2'>Why?:</td>
145
146
147
148
149
150
151
152
153
          </tr>\n";
    
    echo "<tr>
              <td colspan='2' width=600>$proj_why</td>
          </tr>\n";
    
    echo "</table>\n";
}

Leigh B. Stoller's avatar
Leigh B. Stoller committed
154
155
156
157
#
# A Group
#
function SHOWGROUP($pid, $gid) {
158
159
    global $OURDOMAIN;
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
160
161
162
163
    $query_result =
	DBQueryFatal("SELECT * FROM groups WHERE pid='$pid' and gid='$gid'");
    $row = mysql_fetch_array($query_result);

164
165
166
167
    echo "<center>
          <h3>Group Profile</h3>
          </center>
          <table align=center border=1>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
168
169
170

    $leader	= $row[leader];
    $created	= $row[created];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
171
    $description= stripslashes($row[description]);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
172
173
174
175
176
    $expt_count = $row[expt_count];
    $expt_last  = $row[expt_last];
    $unix_gid   = $row[unix_gid];
    $unix_name  = $row[unix_name];

177
178
179
180
181
    if (strcmp($pid,$gid))
	$mail = "$pid-$gid" . "-users@" . $OURDOMAIN;
    else
	$mail = "$pid" . "-users@" . $OURDOMAIN;

Leigh B. Stoller's avatar
Leigh B. Stoller committed
182
183
184
185
186
187
188
189
190
    if (!$expt_last) {
	$expt_last = "&nbsp";
    }

    #
    # Generate the table.
    # 
    echo "<tr>
              <td>GID: </td>
191
              <td class=\"left\">
Chad Barb's avatar
   
Chad Barb committed
192
                <a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
193
194
195
196
          </tr>\n";
    
    echo "<tr>
              <td>PID: </td>
197
198
              <td class=\"left\">
                <a href='showproject.php3?pid=$pid'>$pid</a></td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
          </tr>\n";
    
    echo "<tr>
              <td>Description: </td>
              <td class=\"left\">$description</td>
          </tr>\n";
    
    echo "<tr>
              <td>Unix GID: </td>
              <td class=\"left\">$unix_gid</td>
          </tr>\n";
    
    echo "<tr>
              <td>Unix Group Name: </td>
              <td class=\"left\">$unix_name</td>
          </tr>\n";
    
    echo "<tr>
              <td>Group Leader: </td>
              <td class=\"left\">
                <A href='showuser.php3?target_uid=$leader'>$leader</A></td>
          </tr>\n";
    
222
223
224
225
226
    echo "<tr>
              <td>Email List: </td>
              <td class=\"left\">$mail</td>
          </tr>\n";
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
    echo "<tr>
              <td>Created: </td>
              <td class=\"left\">$created</td>
          </tr>\n";
    
    echo "<tr>
              <td>Experiments Created:</td>
              <td class=\"left\">$expt_count</td>
          </tr>\n";
    
    echo "<tr>
              <td>Date of last experiment:</td>
              <td class=\"left\">$expt_last</td>
          </tr>\n";
    
    echo "</table>\n";
}

#
# A list of Group members.
#
248
function SHOWGROUPMEMBERS($pid, $gid, $prived = 0) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
249
250
251
252
253
254
255
256
    $query_result =
	DBQueryFatal("SELECT m.*,u.* FROM group_membership as m ".
		     "left join users as u on u.uid=m.uid ".
		     "WHERE pid='$pid' and gid='$gid'");
    
    if (! mysql_num_rows($query_result)) {
	return;
    }
257
    $showdel = (($prived && !strcmp($pid, $gid)) ? 1 : 0);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
258

259
260
261
262
263
264
265
266
    echo "<center>\n";
    if (strcmp($pid, $gid)) {
	echo "<h3>Group Members</h3>\n";
    }
    else {
	echo "<h3>Project Members</h3>\n";
    }
    echo "</center>
267
          <table align=center border=1 cellpadding=1 cellspacing=2>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
268
269

    echo "<tr>
270
271
272
273
274
              <th>Name</th>\n";
    if (strcmp($pid, $gid)) {
	echo "<th>Email</th>\n";
    }
    echo "    <th>UID</th>
275
276
277
278
279
              <th>Privs</th>\n";
    if ($showdel) {
	echo "<th>Remove</th>\n";
    }
    echo "</tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
280
281
282
283

    while ($row = mysql_fetch_array($query_result)) {
        $target_uid = $row[uid];
	$usr_name   = $row[usr_name];
284
	$usr_email  = $row[usr_email];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
285
286
287
	$trust      = $row[trust];

        echo "<tr>
288
289
290
291
292
                  <td>$usr_name</td>\n";
	if (strcmp($pid, $gid)) {
	    echo "<td>$usr_email</td>\n";
	}
	echo "    <td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
293
294
                    <A href='showuser.php3?target_uid=$target_uid'>
                       $target_uid</A>
295
296
297
298
                  </td>\n";
	
	if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) {
	    echo "<td>$trust</td>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
299
300
	}
	else {
301
302
303
	    echo "<td><font color=red>$trust</font></td>\n";
	}
	if ($showdel) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
304
	    echo "<td align=center>
305
306
307
		      <A href='deleteuser.php3?target_uid=$target_uid";
	    echo         "&target_pid=$pid'>
                         <img alt=N src=redball.gif></td>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
308
309
310
311
312
313
	}
	echo "</tr>\n";
    }
    echo "</table>\n";
}

314
315
316
317
#
# A list of groups for a user.
#
function SHOWGROUPMEMBERSHIP($uid) {
318
319
    $none = TBDB_TRUSTSTRING_NONE;
    
320
321
    $query_result =
	DBQueryFatal("SELECT * FROM group_membership ".
322
323
		     "WHERE uid='$uid' and trust!='$none' ".
		     "order by pid");
324
325
326
327
328
329
330
331
332
333
334
    
    if (! mysql_num_rows($query_result)) {
	return;
    }

    echo "<center>
          <h3>Group Membership</h3>
          </center>
          <table align=center border=1 cellpadding=1 cellspacing=2>\n";

    echo "<tr>
Chad Barb's avatar
   
Chad Barb committed
335
336
337
              <th>PID</th>
              <th>GID</th>
              <th>Privs</th>
338
339
340
341
342
343
344
          </tr>\n";

    while ($row = mysql_fetch_array($query_result)) {
	$pid   = $row[pid];
	$gid   = $row[gid];
	$trust = $row[trust];

345
346
	if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) {
	    echo "<tr>
347
348
349
              <td><a href='showproject.php3?pid=$pid'>$pid</a></td>
              <td><a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
              <td>$trust</td>\n";
350
351
	    echo "</tr>\n";
	}
352
353
354
355
    }
    echo "</table>\n";
}

356
357
358
359
360
#
# A User
#
function SHOWUSER($uid) {
    global $TBDBNAME;
361
362
363

    $userinfo_result =
	DBQueryFatal("SELECT * from users where uid='$uid'");
364
365

    $row	= mysql_fetch_array($userinfo_result);
366
    #$usr_expires = $row[usr_expires];
367
368
    $usr_email   = $row[usr_email];
    $usr_URL     = $row[usr_URL];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
369
    $usr_addr    = stripslashes($row[usr_addr]);
370
371
372
373
    $usr_addr2   = stripslashes($row[usr_addr2]);
    $usr_city    = stripslashes($row[usr_city]);
    $usr_state   = stripslashes($row[usr_state]);
    $usr_zip     = stripslashes($row[usr_zip]);
Chad Barb's avatar
   
Chad Barb committed
374
    $usr_country = stripslashes($row[usr_country]);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
375
    $usr_name    = stripslashes($row[usr_name]);
376
    $usr_phone   = $row[usr_phone];
Chad Barb's avatar
   
Chad Barb committed
377
    $usr_shell   = stripslashes($row[usr_shell]);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
378
379
    $usr_title   = stripslashes($row[usr_title]);
    $usr_affil   = stripslashes($row[usr_affil]);
380
    $status      = $row[status];
381
382
    $admin       = $row[admin];
    $adminoff    = $row[adminoff];
383

384
385
386
387
388
389
390
391
    if (!strcmp($usr_addr2, ""))
	$usr_addr2 = "&nbsp";
    if (!strcmp($usr_city, ""))
	$usr_city = "&nbsp";
    if (!strcmp($usr_state, ""))
	$usr_state = "&nbsp";
    if (!strcmp($usr_zip, ""))
	$usr_zip = "&nbsp";
Chad Barb's avatar
   
Chad Barb committed
392
393
    if (!strcmp($usr_country, ""))
	$usr_country = "&nbsp";
394

395
396
397
398
399
    #
    # Last Login info.
    #
    if (($lastweblogin = LASTWEBLOGIN($uid)) == 0)
	$lastweblogin = "&nbsp";
400
    if (($lastuserslogininfo = TBUsersLastLogin($uid)) == 0)
401
402
403
	$lastuserslogin = "N/A";
    else {
	$lastuserslogin = $lastuserslogininfo["date"] . " " .
404
		          $lastuserslogininfo["time"];
405
406
407
408
409
410
411
412
413
    }
    
    if (($lastnodelogininfo = TBUidNodeLastLogin($uid)) == 0)
	$lastnodelogin = "N/A";
    else {
	$lastnodelogin = $lastnodelogininfo["date"] . " " .
		         $lastnodelogininfo["time"] . " " .
                         "(" . $lastnodelogininfo["node_id"] . ")";
    }
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
    
    echo "<table align=center border=1>\n";
    
    echo "<tr>
              <td>Username:</td>
              <td>$uid</td>
          </tr>\n";
    
    echo "<tr>
              <td>Full Name:</td>
              <td>$usr_name</td>
          </tr>\n";
    
    echo "<tr>
              <td>Email Address:</td>
              <td>$usr_email</td>
          </tr>\n";
    
    echo "<tr>
              <td>Home Page URL:</td>
              <td><A href='$usr_URL'>$usr_URL</A></td>
          </tr>\n";
    
437
438
439
440
    #echo "<tr>
    #          <td>Expiration date:</td>
    #          <td>$usr_expires</td>
    #      </tr>\n";
441
442
    
    echo "<tr>
443
              <td>Address 1:</td>
444
445
446
              <td>$usr_addr</td>
          </tr>\n";
    
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
    echo "<tr>
              <td>Address 2:</td>
              <td>$usr_addr2</td>
          </tr>\n";
    
    echo "<tr>
              <td>City:</td>
              <td>$usr_city</td>
          </tr>\n";
    
    echo "<tr>
              <td>State:</td>
              <td>$usr_state</td>
          </tr>\n";
    
    echo "<tr>
Chad Barb's avatar
   
Chad Barb committed
463
              <td>ZIP:</td>
464
465
              <td>$usr_zip</td>
          </tr>\n";
Chad Barb's avatar
   
Chad Barb committed
466
467
468
469
470

    echo "<tr>
              <td>Country:</td>
              <td>$usr_country</td>
          </tr>\n";
471
    
472
473
474
475
    echo "<tr>
              <td>Phone #:</td>
              <td>$usr_phone</td>
          </tr>\n";
Chad Barb's avatar
   
Chad Barb committed
476
477
478
479
480

    echo "<tr>
	      <td>Shell:</td>
	      <td>$usr_shell</td>
          </tr>\n";
481
482
483
484
485
486
487
488
489
490
491
    
    echo "<tr>
              <td>Title/Position:</td>
              <td>$usr_title</td>
         </tr>\n";
    
    echo "<tr>
              <td>Institutional Affiliation:</td>
              <td>$usr_affil</td>
          </tr>\n";
    
492
493
494
495
    echo "<tr>
              <td>Status:</td>
              <td>$status</td>
          </tr>\n";
496
497
498
499
500

    if ($admin) {
	$onoff = ($adminoff ? "Off" : "On");
	$flip  = ($adminoff ? 0 : 1);
	echo "<tr>
501
502
503
504
              <td>Admin (on/off):</td>
              <td>Yes
              <a href=toggle.php?target_uid=$uid&type=adminoff&value=$flip>
              ($onoff)</td>
505
506
              </tr>\n";
    }
507
    
508
509
510
511
512
513
514
515
516
517
    echo "<tr>
              <td>Last Web Login:</td>
              <td>$lastweblogin</td>
          </tr>\n";
    
    echo "<tr>
              <td>Last Users Login:</td>
              <td>$lastuserslogin</td>
          </tr>\n";
    
518
519
520
521
522
    echo "<tr>
              <td>Last Node Login:</td>
              <td>$lastnodelogin</td>
          </tr>\n";
    
523
524
525
526
    echo "</table>\n";

}

527
528
529
#
# Show an experiment.
#
530
function SHOWEXP($pid, $eid, $edit=0) {
531
    global $TBDBNAME, $TBDOCBASE;
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
    $nodecounts  = array();

    # Node counts, by class. 
    $query_result =
	DBQueryFatal("select nt.class,count(*) from reserved as r ".
		     "left join nodes as n on n.node_id=r.node_id ".
		     "left join node_types as nt on n.type=nt.type ".
		     "where pid='$pid' and eid='$eid' group by nt.class");

    while ($row = mysql_fetch_array($query_result)) {
	$class = $row[0];
	$count = $row[1];
	
	$nodecounts[$class] = $count;
    }
547
		
Leigh B. Stoller's avatar
Leigh B. Stoller committed
548
    $query_result =
549
550
551
	DBQueryFatal("select e.*, round(minimum_nodes+.1,0) as min_nodes ".
		     " from experiments as e ".
		     "where e.pid='$pid' and e.eid='$eid'");
552
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
553
554
555
    if (($exprow = mysql_fetch_array($query_result)) == 0) {
	TBERROR("Experiment $eid in project $pid is gone!\n", 1);
    }
556

Leigh B. Stoller's avatar
Leigh B. Stoller committed
557
    $exp_gid     = $exprow[gid];
558
    #$exp_expires = $exprow[expt_expires];
559
    $exp_name_safe= htmlspecialchars(stripslashes($exprow[expt_name]));
Leigh B. Stoller's avatar
Leigh B. Stoller committed
560
    $exp_name    = stripslashes($exprow[expt_name]);
561
    $exp_created = $exprow[expt_created];
562
    $exp_swapped = $exprow[expt_swapped];
563
    $exp_swapuid = $exprow[expt_swap_uid];
564
565
566
    $exp_end     = $exprow[expt_end];
    $exp_created = $exprow[expt_created];
    $exp_head    = $exprow[expt_head_uid];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
567
    $exp_status  = $exprow[state];
568
    $exp_shared  = $exprow[shared];
569
570
571
572
    $exp_path    = $exprow[path];
    $batchmode   = $exprow[batchmode];
    $attempts    = $exprow[attempts];
    $batchstate  = $exprow[batchstate];
573
574
    $priority    = $exprow[priority];
    $swappable   = $exprow[swappable];
575
576
577
    $noswap_reason_safe =
	htmlspecialchars(stripslashes($exprow[noswap_reason]));
    $noswap_reason = stripslashes($exprow[noswap_reason]);
578
579
    $idleswap    = $exprow[idleswap];
    $idleswap_timeout = $exprow[idleswap_timeout];
580
581
582
    $noidleswap_reason_safe =
	htmlspecialchars(stripslashes($exprow[noidleswap_reason]));
    $noidleswap_reason = stripslashes($exprow[noidleswap_reason]);
583
584
    $autoswap    = $exprow[autoswap];
    $autoswap_timeout = $exprow[autoswap_timeout];
585
    $idle_ignore = $exprow[idle_ignore];
586
587
    $swapreqs    = $exprow[swap_requests];
    $lastswapreq = $exprow[last_swap_req];
588
    $minnodes    = $exprow["min_nodes"];
589

590
591
592
593
594
    $autoswap_hrs= ($autoswap_timeout/60.0);
    $idleswap_hrs= ($idleswap_timeout/60.0);
    if ($edit) {
	# make this a form too
	echo "<form action=\"showexp.php3?pid=$pid&eid=$eid\" method=POST>\n";
595
596

	$noswap_form = "Why: <input type=text ".
597
	    "name=noswap value=\"$noswap_reason\" size=30>";
598
	$noidleswap_form = "Why: <input type=text ".
599
	    "name=noidleswap value=\"$noidleswap_reason\" size=30>";
600
	$autoswap_form= "<input type=text size=3 name=autoswap ".
601
	    "value=\"$autoswap_hrs\"> hour".($autoswap_hrs==1 ? "" : "s");
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
	$toggle = "<font size=-2 face=\"Verdana,Arial,sans-serif\">Toggle</font>";
	$expttag = "pid=$pid&eid=$eid&edit=1";

	if ($swappable)
	    $swappable = "Yes
<a href=\"toggle.php?type=swappable&value=0&$expttag\">$toggle</a>
$noswap_form";
	else
	    $swappable = "<b>No</b>
<a href=\"toggle.php?type=swappable&value=1&$expttag\">$toggle</a>
$noswap_form";
	
	$idleswap_form= "<input type=text size=3 name=idleswap ".
	    "value=\"$idleswap_hrs\"> hour".($idleswap_hrs==1 ? "" : "s");
	
	if ($idleswap)
	    $idleswap = "Yes
<a href=\"toggle.php?type=idleswap&value=0&$expttag\">$toggle</a>
(after $idleswap_form) <br> $noidleswap_form";
	else
	    $idleswap = "<b>No</b>
<a href=\"toggle.php?type=idleswap&value=1&$expttag\">$toggle</a>
(after $idleswap_form) <br> $noidleswap_form";
	
	if ($autoswap)
	    $autoswap = "<b>Yes</b>
<a href=\"toggle.php?type=autoswap&value=0&$expttag\">$toggle</a>
(after $autoswap_form)";
	else
	    $autoswap = "No
<a href=\"toggle.php?type=autoswap&value=1&$expttag\">$toggle</a>
(after $autoswap_form)";

        if ($idle_ignore)
	    $idle_ignore = "<b>Yes</b>
<a href=\"toggle.php?type=idle_ignore&value=0&$expttag\">$toggle</a>";
        else
	    $idle_ignore = "No
<a href=\"toggle.php?type=idle_ignore&value=1&$expttag\">$toggle</a>";

642
    } else {
643
644
	$noswap = "($noswap_reason)";
	$noidleswap = "($noidleswap_reason)";
645
	$autoswap_str= $autoswap_hrs." hour".($autoswap_hrs==1 ? "" : "s");
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
        $idleswap_str= $idleswap_hrs." hour".($idleswap_hrs==1 ? "":"s");

	if ($swappable)
	    $swappable = "Yes";
	else
	    $swappable = "<b>No</b> $noswap";

	if ($idleswap)
	    $idleswap = "Yes (after $idleswap_str)";
	else
	    $idleswap = "<b>No</b> $noidleswap";

	if ($autoswap)
	    $autoswap = "<b>Yes</b> (after $autoswap_str)";
	else
	    $autoswap = "No";

        if ($idle_ignore)
	    $idle_ignore = "<b>Yes</b>";
        else
	    $idle_ignore = "No";

668
    }
669
    
670
671
672
    #
    # Generate the table.
    #
Chad Barb's avatar
   
Chad Barb committed
673
    echo "<table align=center cellpadding=2 cellspacing=2 border=1>\n";
674
675
676

    echo "<tr>
            <td>Name: </td>
677
            <td class=left>$eid</td>
678
679
          </tr>\n";

680
    if ($edit) {
681
682
	$exp_name_str =
	    "<input type=text name=exp_name size=30 value=\"$exp_name_safe\">";
683
684
685
    } else {
	$exp_name_str = $exp_name;
    }
686
687
    echo "<tr>
            <td>Long Name: </td>
688
            <td class=\"left\">$exp_name_str</td>
689
690
691
692
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
693
            <td class=\"left\">
694
              <a href='showproject.php3?pid=$pid'>$pid</a></td>
695
696
          </tr>\n";

Leigh B. Stoller's avatar
Leigh B. Stoller committed
697
698
699
    echo "<tr>
            <td>Group: </td>
            <td class=\"left\">
700
              <a href='showgroup.php3?pid=$pid&gid=$exp_gid'>$exp_gid</a></td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
701
702
          </tr>\n";

703
704
705
    echo "<tr>
            <td>Experiment Head: </td>
            <td class=\"left\">
706
              <a href='showuser.php3?target_uid=$exp_head'>$exp_head</a></td>
707
708
709
710
711
712
713
          </tr>\n";

    echo "<tr>
            <td>Created: </td>
            <td class=\"left\">$exp_created</td>
          </tr>\n";

714
715
716
717
718
719
    if ($exp_swapped) {
        echo "<tr>
                <td>Last Swap/Modify: </td>
                <td class=\"left\">$exp_swapped ($exp_swapuid)</td>
              </tr>\n";
    }
720

721
722
    if (ISADMIN()) {
	echo "<tr>
723
724
725
            <td><a
            href='$TBDOCBASE/docwrapper.php3?docname=swapping.html#swapping'>
            Swappable:</a></td>
726
727
            <td class=\"left\">$swappable</td>
          </tr>\n";
728
729
    }
    
730
731
732
733
734
735
736
737
738
739
    echo "<tr>
            <td><a
            href='$TBDOCBASE/docwrapper.php3?docname=swapping.html#idleswap'>
            Idle-Swap:</a></td>
            <td class=\"left\">$idleswap</td>
          </tr>\n";

    echo "<tr>
            <td><a 
            href='$TBDOCBASE/docwrapper.php3?docname=swapping.html#autoswap'>
740
            Max. Duration:</a></td>
741
742
743
            <td class=\"left\">$autoswap</td>
          </tr>\n";

744
    if (ISADMIN()) {
745
746
747
748
749
750
	echo "<tr>
            <td>Idle Ignore:</td>
            <td class=\"left\">$idle_ignore</td>
          </tr>\n";
    }
    
751
752
753
754
755
756
757
758
759
760
761
762
    echo "<tr>
            <td>Shared: </td>
            <td class=\"left\">";
    if ($exp_shared) {
	echo "<A href='expaccess_form.php3?pid=$pid&eid=$eid'>Yes</a>";
    }
    else {
	echo "No";
    }
    echo "   </td>
          </tr>\n";

763
764
765
766
767
    echo "<tr>
            <td>Path: </td>
            <td class=left>$exp_path</td>
          </tr>\n";

768
769
770
771
772
    echo "<tr>
            <td>Status: </td>
            <td class=\"left\">$exp_status</td>
          </tr>\n";

773
    if (count($nodecounts)) {
774
	echo "<tr>
775
            <td>Reserved Nodes: </td>
776
777
778
779
780
            <td class=\"left\">\n";
	while (list ($class, $count) = each($nodecounts)) {
	    echo "$count ($class) &nbsp ";
	}
	echo "</td>
781
          </tr>\n";
782
    } else {
783
784
	if ($minnodes!="") {
	    echo "<tr>
785
            <td>Minumum Nodes: </td>
786
            <td class=\"left\"><font color=green>
787
788
               $minnodes (estimate)</font></td>
          </tr>\n";
789
790
791
792
793
794
795
	} else {
	    echo "<tr>
            <td>Minumum Nodes: </td>
            <td class=\"left\"><font color=green>
               Unknown</font></td>
          </tr>\n";
	}
796
    }
797

798
799
    $lastact = TBGetExptLastAct($pid,$eid);
    $idletime = TBGetExptIdleTime($pid,$eid);
800
801
    $stale = TBGetExptIdleStale($pid,$eid);
    
802
803
    if ($lastact != -1) {
	echo "<tr>
804
805
806
807
            <td>Last Activity: </td>
            <td class=\"left\">$lastact</td>
          </tr>\n";

808
809
	if ($stale) { $str = "(stale)"; } else { $str = ""; }
	
810
	echo "<tr>
811
            <td>Idle Time: </td>
812
            <td class=\"left\">$idletime hours $str</td>
813
          </tr>\n";
814
    }
815

816
817
818
819
820
821
822
823
824
825
826
827
    if (! ($swapreqs=="" || $swapreqs==0)) {
	echo "<tr>
            <td>Swap Requests: </td>
            <td class=\"left\">$swapreqs</td>
          </tr>\n";

	echo "<tr>
            <td>Last Swap Req.: </td>
            <td class=\"left\">$lastswapreq</td>
          </tr>\n";
    }
    
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
    if ($batchmode) {
	    echo "<tr>
                    <td>Batch Mode: </td>
                    <td class=\"left\">Yes</td>
                  </tr>\n";

	    echo "<tr>
                    <td>Batch Status: </td>
                    <td class=\"left\">$batchstate</td>
                  </tr>\n";

	    echo "<tr>
                    <td>Start Attempts: </td>
                    <td class=\"left\">$attempts</td>
                  </tr>\n";
    }

845
846
847
848
849
850
851
    if ($edit) {
	echo "<tr><td colspan=2 align=center>
		<input type=submit name=submit value=\"Submit Changes\">
		<input type=submit name=reset value=\"Reset\">
	      </td></tr>\n";
    }

852
    echo "</table>\n";
853
854

    if ($edit) { echo "</form>\n"; }
855
856
}

857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
#
# Show a listing of experiments by user/pid/gid
#
function SHOWEXPLIST($type,$id) {
    if ($type == "USER") {
	$where = "expt_head_uid='$id'";
	$title = "Current";
    } elseif ($type == "PROJ") {
	$where = "e.pid='$id'";
	$title = "Project";
	$nopid = 1;
    } elseif ($type == "GROUP") {
	$where = "e.gid='$id'";
	$title = "Group";
	$nopid = 1;
    } else {
	$where = "e.eid='$id'";
	$title = "Bad id '$id'!";
    }
    
    $query_result =
	DBQueryFatal("select e.*,count(r.node_id) as nodes, ".
		     "round(minimum_nodes+.1,0) as min_nodes ".
		     "from experiments as e ".
		     "left join reserved as r on e.pid=r.pid and e.eid=r.eid ".
		     "where $where ".
		     "group by e.pid,e.eid order by e.state,e.eid");
    
    if (mysql_num_rows($query_result)) {
	echo "<center>
          <h3>$title Experiments</h3>
          </center>
          <table align=center border=1 cellpadding=2 cellspacing=2>\n";

	if ($nopid) {
	    $pidrow="";
	} else {
	    $pidrow="\n<th>PID</th>";
	}
	
	echo "<tr>$pidrow
              <th>EID</th>
              <th>State</th>
900
901
              <th align=center>Nodes [1]</th>
              <th align=center>Hours Idle [2]</th>
902
903
904
              <th>Description</th>
          </tr>\n";

905
906
907
	$idlemark = "<b>*</b>";
	$stalemark = "<b>?</b>";
	
908
909
910
911
912
913
914
	while ($row = mysql_fetch_array($query_result)) {
	    $pid  = $row[pid];
	    $eid  = $row[eid];
	    $state= $row[state];
	    $nodes= $row["nodes"];
	    $minnodes = $row["min_nodes"];
	    $idlehours = TBGetExptIdleTime($pid,$eid);
915
916
	    $stale = TBGetExptIdleStale($pid,$eid);
	    $ignore = $row["idle_ignore"];
917
918
	    $name = stripslashes($row[expt_name]);
	    if ($nodes==0) {
919
		$nodes = "<font color=green>$minnodes</font>";
920
921
	    } elseif ($row[swap_requests] > 0) {
		$nodes .= $idlemark;
922
923
924
925
926
927
928
929
	    }

	    if ($nopid) {
		$pidrow="";
	    } else {
		$pidrow="\n<td>".
		    "<A href='showproject.php3?pid=$pid'>$pid</A></td>";
	    }
930
931
932
933
934
935

	    $idlestr = $idlehours;
	    if ($idlehours > 0) {
		if ($stale) { $idlestr .= $stalemark; }
		if ($ignore) { $idlestr = "($idlestr)"; $parens=1; }
	    } elseif ($idlehours == -1) { $idlestr = "&nbsp;"; }
936
937
938
939
940
	    
	    echo "<tr>$pidrow
                 <td><A href='showexp.php3?pid=$pid&eid=$eid'>$eid</A></td>
		 <td>$state</td>
                 <td align=center>$nodes</td>
941
                 <td align=center>$idlestr</td>
942
943
944
945
                 <td>$name</td>
             </tr>\n";
	}
	echo "</table>\n";
946
947
948
	echo "<table align=center cellpadding=0 class=stealth><tr>\n".
	    "<td class=stealth align=left><font size=-1><ol>\n".
	    "<li>Node counts in <font color=green><b>green</b></font>\n".
949
	    "show a rough estimate of the minimum number of \n".
950
951
952
953
954
955
956
957
958
959
960
961
	    "nodes <br>required to swap in.\n".
	    "They account for delay nodes, but not for node types, etc.\n".
	    "<li>A $stalemark indicates that the data is stale, and ".
	    "at least one node in the experiment has not <br>reported ".
	    "on its proper schedule.\n"; 
	if ($parens) {
            # don't show this unless we did it... most users shouldn't ever
	    # need to know that some expts have their idleness ignored
	    echo "Values are in parenthesis for idle-ignore experiments.\n";
	}
	echo "</ol></font></td></tr></table>\n";

962
963
964
    }   
}

965
966
967
968
969
#
# Show Node information for an experiment.
#
function SHOWNODES($pid, $eid) {
    global $TBDBNAME;
970
    global $TBOPSPID;
971
972
973
    global $altnodesort;
    global $SCRIPT_NAME;
    
974
975
976
    $reserved_result =
	DBQueryFatal("SELECT * FROM reserved WHERE ".
		     "eid='$eid' and pid='$pid'");
977
    
978
979
980
981
    # If this is an expt in emulab-ops, we don't care about vname,
    # since it won't be defined. But we do want to know when the node
    # entered the experiment, since it won't match the experiment's
    # swapin date.
982
983
    $nodename="<a href=\"$SCRIPT_NAME?pid=$pid&eid=$eid&altnodesort=1\">".
	"Node Name</a>";
984
985
    $vnamefield="vname";
    if (!strcmp($pid, $TBOPSPID)) {
986
987
      $nodename="<a href=\"$SCRIPT_NAME?pid=$pid&eid=$eid&altnodesort=2\">".
	  "Reserve Time</a>";
988
      $vnamefield="rsrvtime";
989
      if (!isset($altnodesort)) { $altnodesort = 2; }
990
    }
991

992
    if (mysql_num_rows($reserved_result)) {
993
994
995

	if (!isset($altnodesort)) { $altnodesort = 1; }
	
996
997
998
999
1000
	echo "<center>
              <h3>Reserved Nodes</h3>
              </center>
              <table align=center border=1>
              <tr>
1001
1002
                <th><a href=\"$SCRIPT_NAME?pid=$pid&eid=$eid&altnodesort=0\">".
	            "Node ID</a></th>
Chad Barb's avatar
   
Chad Barb committed
1003
1004
                <th>$nodename</th>
                <th>Type</th>
1005
1006
                <th>Default OSID</th>
                <th>Node<br>Status</th>
1007
1008
1009
                <th>Hours<br>Idle[<b>1</b>]</th>
                <th>Startup<br>Status[<b>2</b>]</th>
                <th>Ready<br>Status[<b>3</b>]</th>
1010
              </tr>\n";
1011
1012
1013
1014

	$sort = "type,priority";
	if ($altnodesort==1) {
	    $sort = "vname";
1015
1016
	} elseif ($altnodesort==2) {
	    $sort = "rsrvtime";
1017
1018
	} # Can add other alt sorts here too
	
1019
	
1020
	$query_result =
1021
	    DBQueryFatal("SELECT nodes.*,reserved.*,ns.status as nodestatus, ".
1022
	        "date_format(rsrv_time,\"%Y-%m-%d&nbsp;%T\") as rsrvtime ".
1023
1024
1025
	        "FROM nodes LEFT JOIN node_activity ".
		"on nodes.node_id=node_activity.node_id ".
		"LEFT JOIN reserved ON nodes.node_id=reserved.node_id ".
1026
		"LEFT JOIN node_status as ns ON ns.node_id=nodes.node_id ".
1027
	        "WHERE reserved.eid=\"$eid\" and reserved.pid=\"$pid\" ".
1028
	        "ORDER BY $sort");
1029

1030
1031
	$stalemark = "<b>?</b>";

1032
1033
	while ($row = mysql_fetch_array($query_result)) {
	    $node_id = $row[node_id];
1034
	    $vname   = $row[$vnamefield];
1035
	    $type    = $row[type];
1036
1037
1038
	    $def_boot_osid = $row[def_boot_osid];
	    $startstatus   = $row[startstatus];
	    $readystatus   = $row[ready];
1039
	    $status        = $row[nodestatus];
1040
	    $bootstate     = $row[eventstate];
1041
1042
1043
1044
1045
1046
1047
1048
	    $idlehours = TBGetNodeIdleTime($node_id);
	    $stale = TBGetNodeIdleStale($node_id);

	    $idlestr = $idlehours;
	    if ($idlehours > 0) {
		if ($stale) { $idlestr .= $stalemark; }
		if ($ignore) { $idlestr = "($idlestr)"; $parens=1; }
	    } elseif ($idlehours == -1) { $idlestr = "&nbsp;"; }
1049

1050
1051
	    if (!$vname)
		$vname = "--";
1052
1053
1054
1055
	    if ($readystatus)
		$readylabel = "Yes";
	    else
		$readylabel = "No";
1056
1057

	    echo "<tr>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1058
1059
                    <td><A href='shownode.php3?node_id=$node_id'>$node_id</a>
                        </td>
1060
                    <td>$vname</td>
1061
                    <td>$type</td>\n";
1062
1063
1064
1065
1066
	    if ($def_boot_osid) {
		echo "<td>";
		SPITOSINFOLINK($def_boot_osid);
		echo "</td>";
	    }
1067
1068
	    else
		echo "<td>&nbsp</td>\n";
1069
1070
1071
1072
1073
1074

	    if ($bootstate != "ISUP") {
		echo "  <td>$status ($bootstate)</td>\n";
	    } else {
		echo "  <td>$status</td>\n";
	    }
1075
	    
1076
	    echo "  <td>$idlestr</td>
1077
                    <td align=center>$startstatus</td>
1078
                    <td align=center>$readylabel</td>
1079
                   </tr>\n";
1080
1081
	}
	echo "</table>\n";
1082
1083
	echo "<h4><blockquote><blockquote><blockquote>
              <ol>
1084
1085
	        <li>A $stalemark indicates that the data is stale, and
	            the node has not reported on its proper schedule. 
1086
                <li>Exit value of the node startup command. A value of
1087
                        666 indicates a testbed internal error.
1088
1089
1090
                <li>User application ready status, reported via TMCC.
              </ol>
              </blockquote></blockquote></blockquote></h4>\n";
1091
1092
1093
    }
}

1094
1095
1096
1097
1098
1099
#
# Show OS INFO record.
#
function SHOWOSINFO($osid) {
    global $TBDBNAME;
		
1100
1101
    $query_result =
	DBQueryFatal("SELECT * FROM os_info WHERE osid='$osid'");
1102
1103
1104

    $osrow = mysql_fetch_array($query_result);

Leigh B. Stoller's avatar
Leigh B. Stoller committed
1105
    $os_description = stripslashes($osrow[description]);
1106
1107
1108
1109
1110
    $os_OS          = $osrow[OS];
    $os_version     = $osrow[version];
    $os_path        = $osrow[path];
    $os_magic       = $osrow[magic];
    $os_osfeatures  = $osrow[osfeatures];
1111
    $os_op_mode     = $osrow[op_mode];
1112
    $os_pid         = $osrow[pid];
1113
1114
    $os_shared      = $osrow[shared];
    $os_osname      = $osrow[osname];
1115
1116
    $creator        = $osrow[creator];
    $created        = $osrow[created];
1117
    $mustclean      = $osrow[mustclean];
1118
    $nextosid       = $osrow[nextosid];
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129

    if (!$os_description)
	$os_description = "&nbsp";
    if (!$os_version)
	$os_version = "&nbsp";
    if (!$os_path)
	$os_path = "&nbsp";
    if (!$os_magic)
	$os_magic = "&nbsp";
    if (!$os_osfeatures)
	$os_osfeatures = "&nbsp";
1130
1131
    if (!$os_op_mode)
	$os_op_mode = "&nbsp";
1132
1133
    if (!$created)
	$created = "N/A";
1134
1135
1136
1137
1138
1139
1140

    #
    # Generate the table.
    #
    echo "<table align=center border=1>\n";

    echo "<tr>
1141
1142
1143
1144
1145
1146
            <td>Name: </td>
            <td class=\"left\">$os_osname</td>
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
1147
1148
            <td class=\"left\">
              <a href='showproject.php3?pid=$os_pid'>$os_pid</a></td>
1149
1150
          </tr>\n";

1151
1152
    echo "<tr>
            <td>Creator: </td>
1153
1154
            <td class=left>
              <a href='showuser.php3?target_uid=$creator'>$creator</a></td>
1155
1156
1157
1158
1159
1160
1161
 	  </tr>\n";

    echo "<tr>
            <td>Created: </td>
            <td class=left>$created</td>
 	  </tr>\n";

1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
    echo "<tr>
            <td>Description: </td>
            <td class=\"left\">$os_description</td>
          </tr>\n";

    echo "<tr>
            <td>Operating System: </td>
            <td class=\"left\">$os_OS</td>
          </tr>\n";

    echo "<tr>
            <td>Version: </td>
            <td class=\"left\">$os_version</td>
          </tr>\n";

    echo "<tr>
            <td>Path: </td>
            <td class=\"left\">$os_path</td>
          </tr>\n";

    echo "<tr>
            <td>Magic (uname -r -s): </td>
            <td class=\"left\">$os_magic</td>
          </tr>\n";

    echo "<tr>
1188
1189
            <td>Features: </td>
            <td class=\"left\">$os_osfeatures</td>
1190
1191
          </tr>\n";

1192
1193
1194
1195
1196
    echo "<tr>
            <td>Operational Mode: </td>
            <td class=\"left\">$os_op_mode</td>
          </tr>\n";

1197
    echo "<tr>
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
            <td>Shared?: </td>
            <td class=left>\n";

    if ($os_shared)
	echo "Yes";
    else
	echo "No";
    
    echo "  </td>
          </tr>\n";

1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
    echo "<tr>
            <td>Must Clean?: </td>
            <td class=left>\n";

    if ($mustclean)
	echo "Yes";
    else
	echo "No";
    
    echo "  </td>
          </tr>\n";

1221
1222
1223
1224
1225
1226
1227
1228
    if ($nextosid) {
	echo "<tr>
                <td>Next Osid: </td>
                <td class=left>
                    <A href='showosinfo.php3?osid=$nextosid'>$nextosid</A></td>
              </tr>\n";
    }

1229
1230
1231
    echo "<tr>
            <td>Internal ID: </td>
            <td class=\"left\">$osid</td>
1232
1233
1234
1235
1236
          </tr>\n";

    echo "</table>\n";
}

1237
1238
1239
#
# Show ImageID record.
#
1240
function SHOWIMAGEID($imageid, $edit, $isadmin = 0) {
1241
1242
    global $TBDBNAME;
		
1243
1244
    $query_result =
	DBQueryFatal("select * from images where imageid='$imageid'");
1245
1246
1247

    $row = mysql_fetch_array($query_result);

1248
1249
    $imagename   = $row[imagename];
    $pid         = $row[pid];
1250
    $gid         = $row[gid];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1251
    $description = stripslashes($row[description]);
1252
1253
1254
1255
1256
1257
1258
1259
1260
    $loadpart	 = $row[loadpart];
    $loadlength	 = $row[loadlength];
    $part1_osid	 = $row[part1_osid];
    $part2_osid	 = $row[part2_osid];
    $part3_osid	 = $row[part3_osid];
    $part4_osid	 = $row[part4_osid];
    $default_osid= $row[default_osid];
    $path 	 = $row[path];
    $loadaddr	 = $row[load_address];
1261
    $shared	 = $row[shared];
1262
    $globalid	 = $row["global"];
1263
1264
    $creator     = $row[creator];
    $created     = $row[created];
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280

    if ($edit) {
	if (!$description)
	    $description = "";
	if (!$path)
	    $path = "";
	if (!$loadaddr)
	    $loadaddr = "";
    }
    else {
	if (!$description)
	    $description = "&nbsp";
	if (!$path)
	    $path = "&nbsp";
	if (!$loadaddr)
	    $loadaddr = "&nbsp";
1281
1282
	if (!$created)
	    $created = "N/A";
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
    }
    
    #
    # Generate the table.
    #
    echo "<table align=center border=2 cellpadding=2 cellspacing=2>\n";

    if ($edit) {
	$imageid_encoded = rawurlencode($imageid);
	
	echo "<form action='editimageid.php3?imageid=$imageid_encoded'
                    method=post>\n";
    }

    echo "<tr>
1298
1299
1300
1301
1302
1303
            <td>Image Name: </td>
            <td class=\"left\">$imagename</td>
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
1304
1305
            <td class=\"left\">
              <a href='showproject.php3?pid=$pid'>$pid</a></td>
1306
          </tr>\n";
1307

1308
1309
1310
1311
1312
1313
    echo "<tr>
              <td>Group: </td>
              <td class=\"left\">
                <a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
          </tr>\n";
    
1314
1315
1316
1317
1318
1319
1320
1321
1322
    echo "<tr>
            <td>Creator: </td>
            <td class=left>$creator</td>
 	  </tr>\n";

    echo "<tr>
            <td>Created: </td>
            <td class=left>$created</td>
 	  </tr>\n";