Linux From Scratch Security Advisories
\n"; print " HTML; if ( strlen($pop_message) > 0 ) DisplayErrorMessage( $pop_message ); if ( strlen($list_packages) > 0 ) printf( "%s
", $list_packages );
}
function search()
{
main();
global $list_packages;
global $pop_message;
$search_type = $_POST['stype'];
$severity = ( isset($_POST['severity']) ) ? $_POST['severity'] : "";
switch ( $search_type )
{
case "Book":
search_by_book( $severity );
break;
case "package":
search_by_package( $severity );
break;
case "all":
display_all( $severity );
break;
}
if ( strlen($pop_message) > 0 )
DisplayErrorMessage( $pop_message );
else
printf( "%s
", $list_packages );
}
function search_by_book( $severity )
{
global $pop_message;
global $list_packages;
$book = $_POST['book'];
$release = $_POST['release'];
$query = "SELECT id, name, entry_date, severity, description " .
"FROM advisories WHERE " .
"SUBSTRING( id, 4, 4) = '$release'";
if ( $severity != "" )
{
$level = $_POST['level'];
$query .= " AND severity='$level'";
}
$query .= " ORDER BY id DESC, entry_date DESC, name";
$result = query_db( $query );
if ( $result->num_rows == 0 )
{
$pop_message = "No results found.";
return;
}
$list_packages = "| ID | Package | DateID | Severity | \n"; # $severity is reused here while ( list( $id, $name, $entry_date, $severity, $description ) = $result->fetch_row() ) { $list_packages .= format_advisory( $name, $id, $entry_date, $severity, $description ); } $list_packages .= "
|---|
"; return; } } $query = "SELECT id, name, entry_date, severity, description " . "FROM advisories " . "WHERE name LIKE '%$pkg%' "; if ( $severity != "" ) { $level = $_POST['level']; $query .=" AND severity='$level' "; } $query .= "ORDER BY id DESC, entry_date DESC, name"; //print $query; $result = query_db( $query ); if ( $result->num_rows == 0 ) { $pop_message = "No results found."; return; } $list_packages = "
| ID | Package | DateID | Severity | \n"; # $severity is reused here while ( list( $id, $name, $entry_date, $severity, $description ) = $result->fetch_row() ) { $list_packages .= format_advisory( $name, $id, $entry_date, $severity, $description ); } $list_packages .= "
|---|
| ID | Package | DateID | Severity | \n"; # $severity is reused here while ( list( $id, $name, $entry_date, $severity, $description ) = $result->fetch_row() ) { $list_packages .= format_advisory( $name, $id, $entry_date, $severity, $description ); } $list_packages .= "
|---|