osCommerce / oscommerce2

////

// Returns the zone (State/Province) name

// TABLES: zones

  function tep_get_zone_name($country_id, $zone_id, $default_zone) {

    $OSCOM_Db = Registry::get('Db');

    $Qzone = $OSCOM_Db->prepare('select zone_name from :table_zones where zone_country_id = :zone_country_id and zone_id = :zone_id');

    $Qzone->bindInt(':zone_country_id', $country_id);

    $Qzone->bindInt(':zone_id', $zone_id);

    $Qzone->execute();

    if ($Qzone->fetch() !== false) {

      return $Qzone->value('zone_name');

    } else {

      return $default_zone;

    }

  }

////

// Returns the zone (State/Province) code

////

// Returns the zone (State/Province) code

// TABLES: zones

  function tep_get_zone_code($country_id, $zone_id, $default_zone) {

    $OSCOM_Db = Registry::get('Db');

    $Qzone = $OSCOM_Db->prepare('select zone_code from :table_zones where zone_country_id = :zone_country_id and zone_id = :zone_id');

    $Qzone->bindInt(':zone_country_id', $country_id);

    $Qzone->bindInt(':zone_id', $zone_id);

    $Qzone->execute();

    if ($Qzone->fetch() !== false) {

      return $Qzone->value('zone_code');

    } else {

      return $default_zone;

    }

  }

////

// Wrapper function for round()

////

// Returns the address_format_id for the given country

// TABLES: countries;

  function tep_get_address_format_id($country_id) {

    $OSCOM_Db = Registry::get('Db');

    $format_id = 1;

    $Qformat = $OSCOM_Db->prepare('select address_format_id from :table_countries where countries_id = :countries_id');

    $Qformat->bindInt(':countries_id', $country_id);

    $Qformat->execute();

    if ($Qformat->fetch() !== false) {

      $format_id = $Qformat->valueInt('address_format_id');

    }

    return $format_id;

  }

////

// Return a formatted address