function get_location($sip_adr, &$errors){
global $config;
static $reg;
$reg = new Creg();
$domainname=$reg->get_domainname($sip_adr);
switch($this->container_type){
case 'sql':
$q="select location from ".$config->data_sql->table_netgeo_cache.
" where domainname='".$domainname."'";
$res=$this->db->query($q);
/* if this query failed netgeo is probably not installed -- ignore */
if (DB::isError($res)) {return "n/a";}
$row = $res->fetchRow(DB_FETCHMODE_OBJECT);
$res->free();
if (!$row) return "n/a";
return $row->location;
case 'ldap':
die('NOT IMPLEMENTED: '.__FILE__.":".__LINE__);
}
}
exit(1);
}
while ($row = MySQL_Fetch_Object($res)) {
//for each user get contacts
$q = "select contact from " . $config->table_location . " where username='******'";
$res2 = mySQL_query($q);
if (!$res2) {
echo "error in SQL query, line: " . __LINE__ . "\n";
continue;
}
$send_na = true;
unset($user_icao_cache);
$user_icao_cache = array();
//for each contact get meter data and send it
while ($row2 = MySQL_Fetch_Object($res2)) {
$domain = $reg->get_domainname($row2->contact);
//get icao for domain
$q = "select icao from " . $config->table_netgeo_cache . " where domainname='{$domain}'";
$res3 = MySQL_query($q);
if (!$res3) {
echo "error in SQL query, line: " . __LINE__ . "\n";
continue;
}
$row3 = MySQL_Fetch_Object($res3);
if (!$row3) {
continue;
}
$icao = $row3->icao;
// if domain isn't in cache, continue with next contact
if (!$icao) {
continue;
