$this->db->query("INSERT INTO " . DB_PREFIX . "geo_zone SET name = '" . $this->db->escape($data['name']) . "', description = '" . $this->db->escape($data['description']) . "', date_added = NOW()");
$geo_zone_id = $this->db->getLastId();
if (isset($data['zone_to_geo_zone'])) {
foreach ($data['zone_to_geo_zone'] as $value) {
$this->db->query("INSERT INTO " . DB_PREFIX . "zone_to_geo_zone SET country_id = '" . (int)$value['country_id'] . "', zone_id = '" . (int)$value['zone_id'] . "', geo_zone_id = '" .(int)$geo_zone_id . "', date_added = NOW()");
}
}
$this->cache->delete('geo_zone');
