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; }