showstuff.php3 41.3 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>
Chad Barb's avatar
   
Chad Barb committed
270
271
              <th>Name</th>
              <th>UID</th>
272
273
274
275
276
              <th>Privs</th>\n";
    if ($showdel) {
	echo "<th>Remove</th>\n";
    }
    echo "</tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
277
278
279
280
281
282
283
284
285
286
287

    while ($row = mysql_fetch_array($query_result)) {
        $target_uid = $row[uid];
	$usr_name   = $row[usr_name];
	$trust      = $row[trust];

        echo "<tr>
                  <td>$usr_name</td>
                  <td>
                    <A href='showuser.php3?target_uid=$target_uid'>
                       $target_uid</A>
288
289
290
291
                  </td>\n";
	
	if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) {
	    echo "<td>$trust</td>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
292
293
	}
	else {
294
295
296
	    echo "<td><font color=red>$trust</font></td>\n";
	}
	if ($showdel) {
Leigh B. Stoller's avatar
Leigh B. Stoller committed
297
	    echo "<td align=center>
298
299
300
		      <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
301
302
303
304
305
306
	}
	echo "</tr>\n";
    }
    echo "</table>\n";
}

307
308
309
310
#
# A list of groups for a user.
#
function SHOWGROUPMEMBERSHIP($uid) {
311
312
    $none = TBDB_TRUSTSTRING_NONE;
    
313
314
    $query_result =
	DBQueryFatal("SELECT * FROM group_membership ".
315
316
		     "WHERE uid='$uid' and trust!='$none' ".
		     "order by pid");
317
318
319
320
321
322
323
324
325
326
327
    
    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
328
329
330
              <th>PID</th>
              <th>GID</th>
              <th>Privs</th>
331
332
333
334
335
336
337
          </tr>\n";

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

338
339
	if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) {
	    echo "<tr>
340
341
342
              <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";
343
344
	    echo "</tr>\n";
	}
345
346
347
348
    }
    echo "</table>\n";
}

349
350
351
352
353
#
# A User
#
function SHOWUSER($uid) {
    global $TBDBNAME;
354
355
356

    $userinfo_result =
	DBQueryFatal("SELECT * from users where uid='$uid'");
357
358

    $row	= mysql_fetch_array($userinfo_result);
359
    #$usr_expires = $row[usr_expires];
360
361
    $usr_email   = $row[usr_email];
    $usr_URL     = $row[usr_URL];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
362
    $usr_addr    = stripslashes($row[usr_addr]);
363
364
365
366
    $usr_addr2   = stripslashes($row[usr_addr2]);
    $usr_city    = stripslashes($row[usr_city]);
    $usr_state   = stripslashes($row[usr_state]);
    $usr_zip     = stripslashes($row[usr_zip]);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
367
    $usr_name    = stripslashes($row[usr_name]);
368
    $usr_phone   = $row[usr_phone];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
369
370
    $usr_title   = stripslashes($row[usr_title]);
    $usr_affil   = stripslashes($row[usr_affil]);
371
    $status      = $row[status];
372
373
    $admin       = $row[admin];
    $adminoff    = $row[adminoff];
374

375
376
377
378
379
380
381
382
383
    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";

384
385
386
387
388
    #
    # Last Login info.
    #
    if (($lastweblogin = LASTWEBLOGIN($uid)) == 0)
	$lastweblogin = "&nbsp";
389
    if (($lastuserslogininfo = TBUsersLastLogin($uid)) == 0)
390
391
392
	$lastuserslogin = "N/A";
    else {
	$lastuserslogin = $lastuserslogininfo["date"] . " " .
393
		          $lastuserslogininfo["time"];
394
395
396
397
398
399
400
401
402
    }
    
    if (($lastnodelogininfo = TBUidNodeLastLogin($uid)) == 0)
	$lastnodelogin = "N/A";
    else {
	$lastnodelogin = $lastnodelogininfo["date"] . " " .
		         $lastnodelogininfo["time"] . " " .
                         "(" . $lastnodelogininfo["node_id"] . ")";
    }
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
    
    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";
    
426
427
428
429
    #echo "<tr>
    #          <td>Expiration date:</td>
    #          <td>$usr_expires</td>
    #      </tr>\n";
430
431
    
    echo "<tr>
432
              <td>Address 1:</td>
433
434
435
              <td>$usr_addr</td>
          </tr>\n";
    
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
    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>
              <td>Zip:</td>
              <td>$usr_zip</td>
          </tr>\n";
    
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
    echo "<tr>
              <td>Phone #:</td>
              <td>$usr_phone</td>
          </tr>\n";
    
    echo "<tr>
              <td>Title/Position:</td>
              <td>$usr_title</td>
         </tr>\n";
    
    echo "<tr>
              <td>Institutional Affiliation:</td>
              <td>$usr_affil</td>
          </tr>\n";
    
471
472
473
474
    echo "<tr>
              <td>Status:</td>
              <td>$status</td>
          </tr>\n";
475
476
477
478
479
480
481
482
483
484
485

    if ($admin) {
	$onoff = ($adminoff ? "Off" : "On");
	$flip  = ($adminoff ? 0 : 1);
	echo "<tr>
                  <td>Admin (on/off):</td>
                  <td>Yes
                      <a href=adminmode.php3?target_uid=$uid&adminoff=$flip>
                         ($onoff)</td>
              </tr>\n";
    }
486
    
487
488
489
490
491
492
493
494
495
496
    echo "<tr>
              <td>Last Web Login:</td>
              <td>$lastweblogin</td>
          </tr>\n";
    
    echo "<tr>
              <td>Last Users Login:</td>
              <td>$lastuserslogin</td>
          </tr>\n";
    
497
498
499
500
501
    echo "<tr>
              <td>Last Node Login:</td>
              <td>$lastnodelogin</td>
          </tr>\n";
    
502
503
504
505
    echo "</table>\n";

}

506
507
508
509
#
# Show an experiment.
#
function SHOWEXP($pid, $eid) {
510
    global $TBDBNAME, $TBDOCBASE;
511
		
Leigh B. Stoller's avatar
Leigh B. Stoller committed
512
    $query_result =
513
514
515
516
517
	DBQueryFatal("select e.*,count(r.node_id) from experiments as e ".
		     "left join reserved as r on e.pid=r.pid and e.eid=r.eid ".
		     "where e.pid='$pid' and e.eid='$eid' ".
		     "group by e.eid order by eid");
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
518
519
520
    if (($exprow = mysql_fetch_array($query_result)) == 0) {
	TBERROR("Experiment $eid in project $pid is gone!\n", 1);
    }
521

Leigh B. Stoller's avatar
Leigh B. Stoller committed
522
    $exp_gid     = $exprow[gid];
523
    #$exp_expires = $exprow[expt_expires];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
524
    $exp_name    = stripslashes($exprow[expt_name]);
525
526
    $exp_created = $exprow[expt_created];
    $exp_start   = $exprow[expt_start];
527
    $exp_swapped = $exprow[expt_swapped];
528
529
530
    $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
531
    $exp_status  = $exprow[state];
532
    $exp_shared  = $exprow[shared];
533
534
535
536
    $exp_path    = $exprow[path];
    $batchmode   = $exprow[batchmode];
    $attempts    = $exprow[attempts];
    $batchstate  = $exprow[batchstate];
537
538
    $priority    = $exprow[priority];
    $swappable   = $exprow[swappable];
539
540
    $swapreqs    = $exprow[swap_requests];
    $lastswapreq = $exprow[last_swap_req];
541
    $nodes       = $exprow["count(r.node_id)"];
542
543
544
545
546

    if ($swappable)
	$swappable = "Yes";
    else
	$swappable = "No";
547
548
549
550

    #
    # Generate the table.
    #
Chad Barb's avatar
   
Chad Barb committed
551
    echo "<table align=center cellpadding=2 cellspacing=2 border=1>\n";
552
553
554

    echo "<tr>
            <td>Name: </td>
555
            <td class=left>$eid</td>
556
557
558
559
560
561
562
563
564
          </tr>\n";

    echo "<tr>
            <td>Long Name: </td>
            <td class=\"left\">$exp_name</td>
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
565
            <td class=\"left\">
566
              <a href='showproject.php3?pid=$pid'>$pid</a></td>
567
568
          </tr>\n";

Leigh B. Stoller's avatar
Leigh B. Stoller committed
569
570
571
    echo "<tr>
            <td>Group: </td>
            <td class=\"left\">
572
              <a href='showgroup.php3?pid=$pid&gid=$exp_gid'>$exp_gid</a></td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
573
574
          </tr>\n";

575
576
577
    echo "<tr>
            <td>Experiment Head: </td>
            <td class=\"left\">
578
              <a href='showuser.php3?target_uid=$exp_head'>$exp_head</a></td>
579
580
581
582
583
584
585
          </tr>\n";

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

586
587
588
589
    #echo "<tr>
    #        <td>Expires: </td>
    #        <td class=\"left\">$exp_expires</td>
    #      </tr>\n";
590
591

    echo "<tr>
592
593
            <td>Started: </td>
            <td class=\"left\">$exp_start</td>
594
595
          </tr>\n";

596
597
598
599
600
    echo "<tr>
            <td>Last Swapped (in or out): </td>
            <td class=\"left\">$exp_swapped</td>
          </tr>\n";

601
    echo "<tr>
602
            <td><a href='$TBDOCBASE/faq.php3#UTT-Swapping'>Swappable:</a></td>
603
604
605
606
607
608
609
610
            <td class=\"left\">$swappable</td>
          </tr>\n";

    echo "<tr>
            <td>Priority: (0 is highest) </td>
            <td class=\"left\">$priority</td>
          </tr>\n";

611
612
613
614
615
616
617
618
619
620
621
622
    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";

623
624
625
626
627
    echo "<tr>
            <td>Path: </td>
            <td class=left>$exp_path</td>
          </tr>\n";

628
629
630
631
632
    echo "<tr>
            <td>Status: </td>
            <td class=\"left\">$exp_status</td>
          </tr>\n";

633
634
635
636
637
    echo "<tr>
            <td>Reserved Nodes: </td>
            <td class=\"left\">$nodes</td>
          </tr>\n";

638
639
640
    $lastact = TBGetExptLastAct($pid,$eid);
    $idletime = TBGetExptIdleTime($pid,$eid);

641
642
    if ($lastact != -1) {
	echo "<tr>
643
644
645
646
            <td>Last Activity: </td>
            <td class=\"left\">$lastact</td>
          </tr>\n";

647
	echo "<tr>
648
649
650
            <td>Idle Time: </td>
            <td class=\"left\">$idletime hours</td>
          </tr>\n";
651
    }
652

653
654
655
656
657
658
659
660
661
662
663
664
    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";
    }
    
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
    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";
    }

682
683
684
685
686
687
688
689
    echo "</table>\n";
}

#
# Show Node information for an experiment.
#
function SHOWNODES($pid, $eid) {
    global $TBDBNAME;
690
    global $TBOPSPID;
691
		
692
693
694
    $reserved_result =
	DBQueryFatal("SELECT * FROM reserved WHERE ".
		     "eid='$eid' and pid='$pid'");
695
    
696
697
698
699
700
701
702
703
704
705
706
    # 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.
    $nodename="Node Name";
    $vnamefield="vname";
    if (!strcmp($pid, $TBOPSPID)) {
      $nodename="Reserve Time";
      $vnamefield="rsrvtime";
    }
    
707
708
709
710
711
712
    if (mysql_num_rows($reserved_result)) {
	echo "<center>
              <h3>Reserved Nodes</h3>
              </center>
              <table align=center border=1>
              <tr>
Chad Barb's avatar
   
Chad Barb committed
713
714
715
                <th>Node ID</th>
                <th>$nodename</th>
                <th>Type</th>
716
717
                <th>Default OSID</th>
                <th>Node<br>Status</th>
718
                <th>Hours<br>Idle</th>
719
720
                <th>Startup<br>Status[<b>1</b>]</th>
                <th>Ready<br>Status[<b>2</b>]</th>
721
722
              </tr>\n";
	
723
724
	$query_result =
	    DBQueryFatal("SELECT nodes.*,reserved.vname, ".
725
	        "date_format(rsrv_time,\"%Y-%m-%d&nbsp;%T\") as rsrvtime ".
726
727
728
	        "FROM nodes LEFT JOIN node_activity ".
		"on nodes.node_id=node_activity.node_id ".
		"LEFT JOIN reserved ON nodes.node_id=reserved.node_id ".
729
	        "WHERE reserved.eid=\"$eid\" and reserved.pid=\"$pid\" ".
730
	        "ORDER BY type,priority");
731
732
733

	while ($row = mysql_fetch_array($query_result)) {
	    $node_id = $row[node_id];
734
	    $vname   = $row[$vnamefield];
735
	    $type    = $row[type];
736
737
738
739
740
	    $def_boot_osid = $row[def_boot_osid];
	    $startstatus   = $row[startstatus];
	    $readystatus   = $row[ready];
	    $status        = $row[status];
	    $bootstate     = $row[eventstate];
741
	    $idlehrs       = TBGetNodeIdleTime($node_id);
742

743
744
	    if (!$vname)
		$vname = "--";
745
746
747
748
	    if ($readystatus)
		$readylabel = "Yes";
	    else
		$readylabel = "No";
749
750

	    echo "<tr>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
751
752
                    <td><A href='shownode.php3?node_id=$node_id'>$node_id</a>
                        </td>
753
                    <td>$vname</td>
754
                    <td>$type</td>\n";
755
756
757
758
759
	    if ($def_boot_osid) {
		echo "<td>";
		SPITOSINFOLINK($def_boot_osid);
		echo "</td>";
	    }
760
761
	    else
		echo "<td>&nbsp</td>\n";
762
763
764
765
766
767

	    if ($bootstate != "ISUP") {
		echo "  <td>$status ($bootstate)</td>\n";
	    } else {
		echo "  <td>$status</td>\n";
	    }
768
	    
769
	    echo "  <td>$idlehrs</td>
770
                    <td align=center>$startstatus</td>
771
                    <td align=center>$readylabel</td>
772
                   </tr>\n";
773
774
	}
	echo "</table>\n";
775
776
777
	echo "<h4><blockquote><blockquote><blockquote>
              <ol>
                <li>Exit value of the node startup command. A value of
778
                        666 indicates a testbed internal error.
779
780
781
                <li>User application ready status, reported via TMCC.
              </ol>
              </blockquote></blockquote></blockquote></h4>\n";
782
783
784
    }
}

785
786
787
788
789
790
#
# Show OS INFO record.
#
function SHOWOSINFO($osid) {
    global $TBDBNAME;
		
791
792
    $query_result =
	DBQueryFatal("SELECT * FROM os_info WHERE osid='$osid'");
793
794
795

    $osrow = mysql_fetch_array($query_result);

Leigh B. Stoller's avatar
Leigh B. Stoller committed
796
    $os_description = stripslashes($osrow[description]);
797
798
799
800
801
    $os_OS          = $osrow[OS];
    $os_version     = $osrow[version];
    $os_path        = $osrow[path];
    $os_magic       = $osrow[magic];
    $os_osfeatures  = $osrow[osfeatures];
802
    $os_op_mode     = $osrow[op_mode];
803
    $os_pid         = $osrow[pid];
804
805
    $os_shared      = $osrow[shared];
    $os_osname      = $osrow[osname];
806
807
    $creator        = $osrow[creator];
    $created        = $osrow[created];
808
    $mustclean      = $osrow[mustclean];
809
    $nextosid       = $osrow[nextosid];
810
811
812
813
814
815
816
817
818
819
820

    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";
821
822
    if (!$os_op_mode)
	$os_op_mode = "&nbsp";
823
824
    if (!$created)
	$created = "N/A";
825
826
827
828
829
830
831

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

    echo "<tr>
832
833
834
835
836
837
            <td>Name: </td>
            <td class=\"left\">$os_osname</td>
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
838
839
            <td class=\"left\">
              <a href='showproject.php3?pid=$os_pid'>$os_pid</a></td>
840
841
          </tr>\n";

842
843
    echo "<tr>
            <td>Creator: </td>
844
845
            <td class=left>
              <a href='showuser.php3?target_uid=$creator'>$creator</a></td>
846
847
848
849
850
851
852
 	  </tr>\n";

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

853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
    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>
879
880
            <td>Features: </td>
            <td class=\"left\">$os_osfeatures</td>
881
882
          </tr>\n";

883
884
885
886
887
    echo "<tr>
            <td>Operational Mode: </td>
            <td class=\"left\">$os_op_mode</td>
          </tr>\n";

888
    echo "<tr>
889
890
891
892
893
894
895
896
897
898
899
            <td>Shared?: </td>
            <td class=left>\n";

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

900
901
902
903
904
905
906
907
908
909
910
911
    echo "<tr>
            <td>Must Clean?: </td>
            <td class=left>\n";

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

912
913
914
915
916
917
918
919
    if ($nextosid) {
	echo "<tr>
                <td>Next Osid: </td>
                <td class=left>
                    <A href='showosinfo.php3?osid=$nextosid'>$nextosid</A></td>
              </tr>\n";
    }

920
921
922
    echo "<tr>
            <td>Internal ID: </td>
            <td class=\"left\">$osid</td>
923
924
925
926
927
          </tr>\n";

    echo "</table>\n";
}

928
929
930
#
# Show ImageID record.
#
931
function SHOWIMAGEID($imageid, $edit, $isadmin = 0) {
932
933
    global $TBDBNAME;
		
934
935
    $query_result =
	DBQueryFatal("select * from images where imageid='$imageid'");
936
937
938

    $row = mysql_fetch_array($query_result);

939
940
    $imagename   = $row[imagename];
    $pid         = $row[pid];
941
    $gid         = $row[gid];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
942
    $description = stripslashes($row[description]);
943
944
945
946
947
948
949
950
951
    $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];
952
    $shared	 = $row[shared];
953
    $globalid	 = $row["global"];
954
955
    $creator     = $row[creator];
    $created     = $row[created];
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971

    if ($edit) {
	if (!$description)
	    $description = "";
	if (!$path)
	    $path = "";
	if (!$loadaddr)
	    $loadaddr = "";
    }
    else {
	if (!$description)
	    $description = "&nbsp";
	if (!$path)
	    $path = "&nbsp";
	if (!$loadaddr)
	    $loadaddr = "&nbsp";
972
973
	if (!$created)
	    $created = "N/A";
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
    }
    
    #
    # 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>
989
990
991
992
993
994
            <td>Image Name: </td>
            <td class=\"left\">$imagename</td>
          </tr>\n";

    echo "<tr>
            <td>Project: </td>
995
996
            <td class=\"left\">
              <a href='showproject.php3?pid=$pid'>$pid</a></td>
997
          </tr>\n";
998

999
1000
1001
1002
1003
1004
    echo "<tr>
              <td>Group: </td>
              <td class=\"left\">
                <a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
          </tr>\n";
    
1005
1006
1007
1008
1009
1010
1011
1012
1013
    echo "<tr>
            <td>Creator: </td>
            <td class=left>$creator</td>
 	  </tr>\n";

    echo "<tr>
            <td>Created: </td>
            <td class=left>$created</td>
 	  </tr>\n";
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040

    echo "<tr>
            <td>Description: </td>
            <td class=left>\n";

    if ($edit) {
	echo "<input type=text name=description size=60
                     maxlength=256 value='$description'>";
    }
    else {
	echo "$description";
    }
    echo "   </td>
 	  </tr>\n";

    echo "<tr>
            <td>Load Partition: </td>
            <td class=\"left\">$loadpart</td>
          </tr>\n";

    echo "<tr>
            <td>Load Length: </td>
            <td class=\"left\">$loadlength</td>
          </tr>\n";

    if ($part1_osid) {
	echo "<tr>
1041
1042
1043
1044
                 <td>Partition 1 OS: </td>
                 <td class=\"left\">";
	SPITOSINFOLINK($part1_osid);
	echo "   </td>
1045
1046
1047
1048
1049
              </tr>\n";
    }

    if ($part2_osid) {
	echo "<tr>
1050
1051
1052
1053
                 <td>Partition 2 OS: </td>
                 <td class=\"left\">";
	SPITOSINFOLINK($part2_osid);
	echo "   </td>
1054
1055
1056
1057
1058
              </tr>\n";
    }

    if ($part3_osid) {
	echo "<tr>
1059
1060
1061
1062
                 <td>Partition 3 OS: </td>
                 <td class=\"left\">";
	SPITOSINFOLINK($part3_osid);
	echo "   </td>
1063
1064
1065
1066
1067
              </tr>\n";
    }

    if ($part4_osid) {
	echo "<tr>
1068
1069
1070
1071
                 <td>Partition 4 OS: </td>
                 <td class=\"left\">";
	SPITOSINFOLINK($part4_osid);
	echo "   </td>
1072
1073
1074
1075
1076
              </tr>\n";
    }

    if ($default_osid) {
	echo "<tr>
1077
1078
1079
1080
                 <td>Boot OS: </td>
                 <td class=\"left\">";
	SPITOSINFOLINK($default_osid);
	echo "   </td>
1081
1082
1083
1084
              </tr>\n";
    }

    echo "<tr>
1085
            <td>Filename: </td>
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
            <td class=left>\n";

    if ($edit) {
	echo "<input type=text name=path size=60
                     maxlength=256 value='$path'>";
    }
    else {
	echo "$path";
    }
    echo "  </td>
          </tr>\n";

1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
    if (! $edit) {
	echo "<tr>
                  <td>Types: </td>
                  <td class=left>\n";

	$types_result =
	    DBQueryFatal("select distinct type from osidtoimageid ".
			 "where imageid='$imageid'");

	if (mysql_num_rows($types_result)) {
	    while ($row = mysql_fetch_array($types_result)) {
		$type = $row[type];
		echo "$type &nbsp ";
	    }
	}
	else {
	    echo "&nbsp";
	}
	echo "  </td>
              </tr>\n";
    }

    echo "<tr>
            <td>Shared?: </td>
            <td class=left>\n";

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

1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
    echo "<tr>
            <td>Global?: </td>
            <td class=left>\n";

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

1144
1145
1146
1147
1148
    echo "<tr>
            <td>Internal ID: </td>
            <td class=left>$imageid</td>
          </tr>\n";

1149
1150
1151
1152
    echo "<tr>
            <td>Load Address: </td>
            <td class=left>\n";

1153
    if ($edit && $isadmin) {
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
	echo "<input type=text name=loadaddr size=20
                     maxlength=256 value='$loadaddr'>";
    }
    else {
	echo "$loadaddr";
    }
    echo "  </td>
          </tr>\n";

    if ($edit) {
	echo "<tr>
                 <td colspan=2 align=center>
                     <b><input type=submit value=Submit></b>
                 </td>
              </tr>
              </form>\n";
    }

    echo "</table>\n";
}

Leigh B. Stoller's avatar
Leigh B. Stoller committed
1175
1176
1177
1178
1179
#
# Show node record.
#
function SHOWNODE($node_id) {
    $query_result =
1180
1181
1182
	DBQueryFatal("select n.*,na.*,r.vname,r.pid,r.eid,i.IP, ".
		     "greatest(last_tty_act,last_net_act,last_cpu_act,".
		     "last_ext_act) as last_act, ".
1183
1184
		     " t.isvirtnode,t.isremotenode ".
		     " from nodes as n ".
1185
		     "left join reserved as r on n.node_id=r.node_id ".
1186
		     "left join node_activity as na on n.node_id=na.node_id ".
1187
1188
1189
		     "left join node_types as t on t.type=n.type ".
		     "left join interfaces as i on i.card=t.control_net ".
		     " and i.node_id=n.node_id ".
1190
		     "where n.node_id='$node_id'");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1191
1192
1193
1194
1195
1196
1197
    
    if (mysql_num_rows($query_result) == 0) {
	TBERROR("The node $node_id is not a valid nodeid!", 1);
    }
		
    $row = mysql_fetch_array($query_result);

1198
    $phys_nodeid        = $row[phys_nodeid]; 
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1199
    $type               = $row[type];
1200
    $vname		= $row[vname];
1201
1202
    $pid 		= $row[pid];
    $eid		= $row[eid];
1203
    $bios               = $row[bios_version];
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1204
1205
1206
1207
1208
1209
1210
1211
1212
    $def_boot_osid      = $row[def_boot_osid];
    $def_boot_path      = $row[def_boot_path];
    $def_boot_cmd_line  = $row[def_boot_cmd_line];
    $next_boot_osid     = $row[next_boot_osid];
    $next_boot_path     = $row[next_boot_path];
    $next_boot_cmd_line = $row[next_boot_cmd_line];
    $rpms               = $row[rpms];
    $tarballs           = $row[tarballs];
    $startupcmd         = $row[startupcmd];
1213
    $routertype         = $row[routertype];
1214
1215
    $eventstate         = $row[eventstate];
    $state_timestamp    = $row[state_timestamp];
1216
1217
    $allocstate         = $row[allocstate];
    $allocstate_timestamp= $row[allocstate_timestamp];
1218
1219
    $op_mode            = $row[op_mode];
    $op_mode_timestamp  = $row[op_mode_timestamp];
1220
    $IP                 = $row[IP];
1221
1222
1223
1224
1225
    $isvirtnode         = $row[isvirtnode];
    $isremotenode       = $row[isremotenode];
    $ipport_low		= $row[ipport_low];
    $ipport_next	= $row[ipport_next];
    $ipport_high	= $row[ipport_high];
1226
1227
1228
1229
1230
1231
1232
    $last_act           = $row[last_act];
    $last_tty_act       = $row[last_tty_act];
    $last_net_act       = $row[last_net_act];
    $last_cpu_act       = $row[last_cpu_act];
    $last_ext_act       = $row[last_ext_act];
    $last_report        = $row[last_report];
    
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
    if (!$def_boot_cmd_line)
	$def_boot_cmd_line = "&nbsp";
    if (!$def_boot_path)
	$def_boot_path = "&nbsp";
    if (!$next_boot_path)
	$next_boot_path = "&nbsp";
    if (!$next_boot_cmd_line)
	$next_boot_cmd_line = "&nbsp";
    if (!$rpms)
	$rpms = "&nbsp";
    if (!$tarballs)
	$tarballs = "&nbsp";
    if (!$startupcmd)
	$startupcmd = "&nbsp";
1247
1248
    if (!$bios)
	$bios = "&nbsp";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1249
1250
1251
1252
1253
1254
1255

    echo "<table border=2 cellpadding=0 cellspacing=2
                 align=center>\n";

    echo "<tr>
              <td>Node ID:</td>
              <td class=left>$node_id</td>
1256
1257
          </tr>\n";

1258
1259
1260
1261
1262
1263
1264
1265
1266
    if ($isvirtnode) {
	if (strcmp($node_id, $phys_nodeid)) {
	    echo "<tr>
                      <td>Phys ID:</td>
                      <td class=left>
	   	          <A href='shownode.php3?node_id=$phys_nodeid'>
                             $phys_nodeid</a></td>
                  </tr>\n";
	}
1267
1268
    }

1269
1270
1271
1272
1273
1274
    if ($vname) {
	echo "<tr>
                  <td>Virtual Name:</td>
                  <td class=left>$vname</td>
              </tr>\n";
    }
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1275

1276
1277
1278
1279
    if ($pid) {
	echo "<tr>
                <td>Project: </td>
                <td class=\"left\">
1280
                    <a href='showproject.php3?pid=$pid'>$pid</a></td>
1281
1282
1283
1284
              </tr>\n";

	echo "<tr>
                  <td>Experiment:</td>
1285
                  <td><a href='showexp.php3?pid=$pid&eid=$eid'>$eid</a></td>
1286
1287
1288
               </tr>\n";
    }

Leigh B. Stoller's avatar
Leigh B. Stoller committed
1289
1290
1291
1292
1293
1294
    echo "<tr>
              <td>Node Type:</td>
              <td class=left>$type</td>
          </tr>\n";

    echo "<tr>
1295
1296
1297
1298
              <td>Def Boot OS:</td>
              <td class=left>";
    SPITOSINFOLINK($def_boot_osid);
    echo "    </td>
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1299
1300
          </tr>\n";

1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
    if ($eventstate) {
	$when = strftime("20%y-%m-%d %H:%M:%S", $state_timestamp);
	echo "<tr>
                 <td>EventState:</td>
                 <td class=left>$eventstate ($when)</td>
              </tr>\n";
    }

    if ($op_mode) {
	$when = strftime("20%y-%m-%d %H:%M:%S", $op_mode_timestamp);
	echo "<tr>
                 <td>Operating Mode:</td>
                 <td class=left>$op_mode ($when)</td>
              </tr>\n";
    }

    if ($allocstate) {
	$when = strftime("20%y-%m-%d %H:%M:%S", $allocstate_timestamp);
	echo "<tr>
                 <td>AllocState:</td>
                 <td class=left>$allocstate ($when)</td>
              </tr>\n";
    }

    #
    # We want the last login for this node, but only if its *after* the
    # experiment was created (or swapped in).
    #
    if ($lastnodeuidlogin = TBNodeUidLastLogin($node_id)) {

	$foo = $lastnodeuidlogin["date"] . " " .
	       $lastnodeuidlogin["time"] . " " .
	       "(" . $lastnodeuidlogin["uid"] . ")";
	
	echo "<tr>
                  <td>Last Login:</td>
                  <td class=left>$foo</td>
             </tr>\n";
    }

    if ($last_act) {
        echo "<tr>
                  <td>Last Activity:</td>
                  <td class=left>$last_act</td>
              </tr>\n";

	$idletime = TBGetNodeIdleTime($node_id);
	echo "<tr>
                  <td>Idle Time:</td>
                  <td class=left>$idletime hours</td>
              </tr>\n";

        echo "<tr>
                  <td>Last Act. Report:</td>
                  <td class=left>$last_report</td>
              </tr>\n";

        echo "<tr>
                  <td>Last TTY Act.:</td>
                  <td class=left>$last_tty_act</td>
              </tr>\n";

        echo "<tr>
                  <td>Last Net. Act.:</td>
                  <td class=left>$last_net_act</td>
              </tr>\n";

        echo "<tr>
                  <td>Last CPU Act.:</td>
                  <td class=left>$last_cpu_act</td>
              </tr>\n";

        echo "<tr>
                  <td>Last Ext. Act.:</td>
                  <td class=left>$last_ext_act</td>
              </tr>\n";

    }
    
1380
1381
1382
1383
1384
    if (!$isvirtnode && !$isremotenode) {
        echo "<tr>
                  <td>Def Boot Path:</td>
                  <td class=left>$def_boot_path</td>
              </tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1385

1386
        echo "<tr>
1387
                  <td>Def Boot Command&nbsp;Line:</td>
1388
1389
                  <td class=left>$def_boot_cmd_line</td>
              </tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1390

1391
1392
1393
        echo "<tr>
                  <td>Next Boot OS:</td>
                  <td class=left>";
1394
    
1395
1396
1397
1398
        if ($next_boot_osid)
	    SPITOSINFOLINK($next_boot_osid);
	else
	    echo "&nbsp";
1399

1400
1401
	echo "    </td>
              </tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1402

1403
1404
1405
1406
	echo "<tr>
                 <td>Next Boot Path:</td>
                 <td class=left>$next_boot_path</td>
              </tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1407

1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
	echo "<tr>
                  <td>Next Boot Command Line:</td>
                  <td class=left>$next_boot_cmd_line</td>
              </tr>\n";
    }
    elseif ($isvirtnode) {
	echo "<tr>
                  <td>IP Port Low:</td>
                  <td class=left>$ipport_low (sshd port)</td>
              </tr>\n";

	echo "<tr>
                  <td>IP Port Next:</td>
                  <td class=left>$ipport_next</td>
              </tr>\n";

	echo "<tr>
                  <td>IP Port High:</td>
                  <td class=left>$ipport_high</td>
              </tr>\n";
    }
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1429
1430
1431
1432
1433
1434
1435
1436
1437

    echo "<tr>
              <td>Startup Command:</td>
              <td class=left>$startupcmd</td>
          </tr>\n";

    echo "<tr>
              <td>Tarballs:</td>
              <td class=left>$tarballs</td>
1438
          </tr>\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1439

1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
    if (!$isvirtnode && !$isremotenode) {
	echo "<tr>
                  <td>RPMs:</td>
                  <td class=left>$rpms</td>
              </tr>\n";
    }

    if (!$isvirtnode && !$isremotenode) {
	echo "<tr>
                  <td>Router Type:</td>
                  <td class=left>$routertype</td>
          </tr>\n";
    }
1453

1454
1455
1456
1457
    echo "<tr>
              <td>Control Net IP:</td>
              <td class=left>$IP</td>
          </tr>\n";
1458

1459
1460
1461
1462
    echo "<tr>
              <td>Bios Version:</td>
              <td class=left>$bios</td>
          </tr>\n";
1463

1464
1465
1466
1467
1468
1469
1470
1471
    if ($isremotenode) {
	if ($isvirtnode) {
	    SHOWWIDEAREANODE($phys_nodeid, 1);
	}
	else {
	    SHOWWIDEAREANODE($node_id, 1);
	}
    }
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1472
1473
1474
    echo "</table>\n";
}

1475
#
1476
# Show log.
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
# 
function SHOWNODELOG($node_id)
{
    $query_result =
	DBQueryFatal("select * from nodelog where node_id='$node_id'".
		     "order by reported");

    if (! mysql_num_rows($query_result)) {
	echo "<br>
              <center>
               There are no entries in the log for node $node_id.
              </center>\n";

	return;
    }

    echo "<br>
          <center>
            Log for node $node_id.
          </center><br>\n";

    echo "<table border=1 cellpadding=2 cellspacing=2 align='center'>\n";

    echo "<tr>
Chad Barb's avatar
   
Chad Barb committed
1501
1502
1503
1504
1505
1506
             <th>Delete?</th>
             <th>Date</th>
             <th>ID</th>
             <th>Type</th>
             <th>Reporter</th>
             <th>Entry</th>
1507
1508
1509
1510
1511
1512
1513
          </tr>\n";

    while ($row = mysql_fetch_array($query_result)) {
	$type       = $row[type];
	$log_id     = $row[log_id];
	$reporter   = $row[reporting_uid];
	$date       = $row[reported];
1514
	$entry      = stripslashes($row[entry]);
1515
1516

	echo "<tr>
1517
1518
1519
 	         <td align=center>
                  <A href='deletenodelog.php3?node_id=$node_id&log_id=$log_id'>
                     <img alt='o' src='redball.gif'></A></td>
1520
1521
1522
1523
1524
1525
1526
1527
1528