function task_area()
{
include_once PATH_MODULES . 'voip/voip.inc.php';
$db =& DB();
$didArea = new didArea();
$sql = sqlSelect($db, "voip_pool", "*", "areacode is null or areacode=0");
$rs = $db->Execute($sql);
if ($rs && $rs->RecordCount()) {
while (!$rs->EOF) {
$n = $rs->fields['npa'] . $rs->fields['nxx'] . $rs->fields['station'];
if (($area = $didArea->determineArea($rs->fields['country_code'], $n)) !== false) {
#echo "DID=".$n." has an area of $area = ".$didArea->getName($rs->fields['country_code'],$area)."<br>";
$f = array('areacode' => $db->qstr($area));
$sql = sqlUpdate($db, "voip_pool", $f, "id=" . $rs->fields['id']);
#echo "plugin_id=".$rs->fields['voip_did_plugin_id']."<br>";
#echo $sql."<br>";
$db->Execute($sql);
}
$rs->MoveNext();
}
}
}
