db_fetch_row($q); return $r; } // ***************************************************************************** // Purpose deletes Zone // Inputs id // Remarks // Returns nothing function znDeleteZone($zoneID) { $tax_classes = taxGetTaxClasses(); foreach( $tax_classes as $classr ) taxDeleteZoneRate( $classr["classID"], $zoneID ); db_query("update ".CUSTOMER_ADDRESSES_TABLE." set zoneID=NULL where zoneID=".(int)$zoneID); db_query("delete from ".ZONES_TABLE." where zoneID=".(int)$zoneID); } // ***************************************************************************** // Purpose updates Zone // Inputs $zoneID - id // $zone_name - zone name // $zone_code - code zone // Remarks // Returns nothing function znUpdateZone( $zoneID, $zone_name, $zone_code, $countryID ) { db_query("update ".ZONES_TABLE." set ". " zone_name='".xToText(trim($zone_name))."', ". " zone_code='".xToText(trim($zone_code))."', ". " countryID=".(int)$countryID. " where zoneID=".(int)$zoneID); } // ***************************************************************************** // Purpose adds zone // Inputs // $zone_name - zone name // $zone_code - code zone // Remarks // Returns nothing function znAddZone( $zone_name, $zone_code, $countryID ) { db_query("insert into ".ZONES_TABLE. "( zone_name, zone_code, countryID )". "values( '".xToText(trim($zone_name))."', '".xToText(trim($zone_code))."', ".(int)$countryID." )" ); return db_insert_id(); } ?>