log("$username : " . $_SERVER['PHP_SELF'] . " : Accessed Page", PEAR_LOG_DEBUG); echo "
|
Welcome $username System Status "; $query="select count(id) from plugins"; $result=$dbconn->execute($query); list($plugincount)=$result->fields; echo "There are $plugincount Nessus plugins in the database. "; $query = "select count(id) from nessus_plugins where TO_DAYS(now()) - TO_DAYS(created) <7"; $result = $dbconn->execute($query); list($plugincount)=$result->fields; if ($plugincount>0) { echo ""; } echo "$plugincount"; if ($plugincount>0) { echo ""; } echo " new plugin"; if ($plugincount!=1) { echo "s"; } echo " added within last 7 days. "; $query="select count(sched_id) from nessus_scan as n inner join nessus_schedule as s on n.sched_id=s.id where n.server_id>0 and n.status='R'"; $result=$dbconn->execute($query); list($scancounttotal)=$result->fields; $query.=" and s.username='$username'"; $result=$dbconn->execute($query); list($scancount)=$result->fields; $query="select count(sched_id) from nessus_scan as n inner join nessus_schedule as s on n.sched_id=s.id where n.server_id=0"; $result=$dbconn->execute($query); list($numstill2btestedtotal)=$result->fields; $query.=" and s.username='$username'"; $result=$dbconn->execute($query); list($numstill2btested)=$result->fields; echo "You have: "; if ($scancount>0) { echo ""; } echo "$scancount"; if ($scancount>0) { echo ""; } echo " Nessus scan"; if ($scancount!=1) { echo "s"; } echo " currently running. "; if ($numstill2btested>0) { echo ""; } echo "$numstill2btested"; if ($numstill2btested>0) { echo ""; } echo " Nessus scan"; if ($numstill2btested!=1) { echo "s"; } echo " currently queued for scanning. "; echo " Inprotect has: "; if ($scancount>0) { echo ""; } echo "$scancount"; if ($scancount>0) { echo ""; } echo " Nessus scan"; if ($scancount!=1) { echo "s"; } echo " currently running. "; if ($numstill2btestedtotal>0) { echo ""; } echo "$numstill2btestedtotal"; if ($numstill2btestedtotal>0) { echo ""; } echo " Nessus scan"; if ($numstill2btestedtotal!=1) { echo "s"; } echo " currently queued for scanning."; echo " News | Your Vulnerability Scans Summary: "; //////////////////////////////// $result=$dbconn->Execute("SELECT count(risk) as count, risk FROM `nessus_results` where username='$username' and falsepositive<>'Y' and scriptid <> 10180 and msg<>'' group by risk"); #$result=$dbconn->Execute("SELECT count(risk) as count, risk FROM `nessus_results` where username='$username' and falsepositive<>'Y' and scriptid <> 10180 group by risk"); $totalrisk=0; $prevrisk=0; $chartimg="graph1.php?graph=1"; while (list($riskcount, $risk)=$result->fields) { for ($i=0;$i<$risk-$prevrisk-1;$i++) { $missedrisk=$prevrisk+$i+1; $chartimg.="&risk$missedrisk=0"; } $prevrisk=$risk; $chartimg.="&risk$risk=$riskcount"; $totalrisk=$totalrisk+$riskcount; $result->MoveNext(); } if($totalrisk>0) {echo " Scanned $syscount systems"; $query="select count(distinct scantime, sched_id) from nessus_results where username='$username'"; $result=$dbconn->execute($query); list ($syscount) = $result->fields; echo ", $syscount times."; if ($acl=="Y") { echo " Total Vulnerability Scans Summary: "; //////////////////////////////// $result=$dbconn->Execute("SELECT count(risk) as count, risk FROM `nessus_results` where falsepositive<>'Y' and scriptid <> 10180 and msg<>'' group by risk"); # $result=$dbconn->Execute("SELECT count(risk) as count, risk FROM `nessus_results` where falsepositive<>'Y' and scriptid <> 10180 group by risk"); $totalrisk=0; $prevrisk=0; $chartimg="graph1.php?graph=1"; while (list($riskcount, $risk)=$result->fields) { for ($i=0;$i<$risk-$prevrisk-1;$i++) { $missedrisk=$prevrisk+$i+1; $chartimg.="&risk$missedrisk=0"; } $prevrisk=$risk; $chartimg.="&risk$risk=$riskcount"; $totalrisk=$totalrisk+$riskcount; $result->MoveNext(); } if($totalrisk>0) {echo " Scanned $syscount systems"; $query="select count(distinct scantime, sched_id) from nessus_results"; $result=$dbconn->execute($query); list ($syscount) = $result->fields; echo ", $syscount times."; } echo " |