<!--script language="JavaScript">
var tool = java.awt.Toolkit;
var size = new
java.awt.Dimension(tool.getDefaultToolkit().getScreenSize());
var myWidth = size.width;
var myHeight = size.height;
</script-->
<?php
$now = date("m/j/y h:i:s",time());
include "../connect.php";
$now = date("j/m/y h:i:s",time());
?>
<html>
<head>
<title>Host List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#F9F3E0" text="#000000">
<form name="Host_list" method="post" action="pickedit.php">
<input type="hidden" name="Height" value='<? print '<script>';
print 'document.write(document.body.offsetHeight);';
print '</script>'; ?>'>
<p> Please select the labs you wish
<select name="LABlist[]" size="8" multiple>
<?
$stmt = "Select * FROM LAB;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
echo '<option value="' . $row->SERIAL . '">' . $row->LAB . '</option>';
}
?>
</select>
</p>
<p>And/Or Select Subnets
<select name="SUBNET[]" size="4" multiple>
<?
$stmt = "Select distinct SUBNET from ARP_TABLE order by IPNUM;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
echo '<option value="' . $row->SUBNET . '">' . $row->SUBNET . '</option>';
}
?>
</select>
</p>
<p>And/Or select an OS.
<select name="OSlist[]" size="8" multiple>
<?
ibase_free_result($sth);
$stmt = "Select distinct OS FROM ARP_TABLE;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
if ($row->OS != ''){
echo '<option value="' . $row->OS . '">' . $row->OS . '</option>';
}
}
ibase_free_result($sth);
ibase_close($dbh);
?>
</select>
</p>
<p>
Select Group Order
<select name="sortorder">
<option value="LAB" selected>LAB</option>
<option value="OS">OS</option>
</select>
</p>
<p>
<input type="submit" name="Submit" value="Generate List">
<input type="submit" name="Submit3" value="No Green">
<input type="submit" name="Submit4" value="On Update Server">
<input type="submit" name="Submit5" value="Not On Update Server">
<input type="submit" name="Submit6" value="Not On NAV Server">
<input type="submit" name="Submit7" value="VIRUS FOUND">
<input type="submit" name="Submit8" value="VIRUS FOUND2">
<input type="submit" name="Submit9" value="CAC INSTALLED">
<input type="submit" name="Submit10" value="NO CAC">
<input type="submit" name="Submit11" value="CRD2">
<input type="reset" name="Submit2" value="Reset">
</p>
IASO                                                                        SA/End User<br>
<Select name="IASO[]" size="5" multiple>
<?
$stmt2 = "SELECT O3.DISPLAY_NAME , O3.SERIAL, o3.phone FROM OWNER o3, IASO i, LAB l WHERE (I.LIASO_NO = L.SERIAL) AND (I.USER_NO = O3.SERIAL) order by display_name";
$sth2 = ibase_query($dbh, $stmt2);
while ($row2 = ibase_fetch_object($sth2)) {
if ($row2->SERIAL != '14122') {
print '<option value="' . $row2->SERIAL . '"';
print '>' . $row2->DISPLAY_NAME . ' (' . $row2->PHONE . ')' . '</option>';
}
}
?> </select>
<Select name="SA[]" size="5" multiple>
<?
$stmt2 = "SELECT O3.DISPLAY_NAME , O3.SERIAL, o3.phone FROM OWNER o3 WHERE (serial in (select distinct owner from arp_table)) or (serial in (select distinct system_user from arp_table)) order by display_name";
$sth2 = ibase_query($dbh, $stmt2);
while ($row2 = ibase_fetch_object($sth2)) {
if ($row2->SERIAL != '14122') {
print '<option value="' . $row2->SERIAL . '"';
print '>' . $row2->DISPLAY_NAME . ' (' . $row2->PHONE . ')' . '</option>';
}
}
?> </select>
</form>
</body>
</html>