function get_indicators_from_map($conn, $map)
{
Ossim_db::check_connection($conn);
$indicators = array();
$query = "SELECT * FROM risk_indicators WHERE map = UNHEX(?)";
$params = array($map);
$rs = $conn->Execute($query, $params);
if (!$rs) {
Av_exception::throw_error(Av_exception::DB_ERROR, $conn->ErrorMsg());
}
while (!$rs->EOF) {
if (is_indicator_allowed($conn, $rs->fields['type'], $rs->fields['type_name'])) {
$id = $rs->fields['id'];
$indicators[$id] = format_indicator($conn, $rs->fields);
}
$rs->MoveNext();
}
return $indicators;
}
/**
* This function gets the first allowed map available
*
* @param object $conn Database access object
*
* @return string
*/
function get_first_map_available($conn)
{
$map = NULL;
Ossim_db::check_connection($conn);
$query = "SELECT HEX(map) AS map, perm, name FROM risk_maps";
$rs = $conn->Execute($query);
while (!$rs->EOF) {
if (file_exists("maps/map" . $rs->fields['map'] . ".jpg") && is_map_allowed($rs->fields['perm'])) {
$map = $rs->fields['map'];
break;
}
$rs->MoveNext();
}
return $map;
}