<?php
/* -----------------------------------------------------------------------------------------
   $Id: xtc_get_countries.inc.php 4200 2013-01-10 19:47:11Z Tomcraft1980 $   


   modified eCommerce Shopsoftware
   http://www.modified-shop.org

   Copyright (c) 2009 - 2013 [www.modified-shop.org]
   -----------------------------------------------------------------------------------------
   based on: 
   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
   (c) 2002-2003 osCommerce(general.php,v 1.225 2003/05/29); www.oscommerce.com 
   (c) 2003	 nextcommerce (xtc_get_countries.inc.php,v 1.3 2003/08/13); www.nextcommerce.org
   (c) 2006 xt:Commerce; www.xt-commerce.com

   Released under the GNU General Public License 
   ---------------------------------------------------------------------------------------*/
define('TABLE_COUNTRIES_I18N', 'i18n_countries');  // todo: move to database_tables.php

  function xtc_get_countriesList($countries_id = '', $with_iso_codes = false) {
    $countries_array = array();
    $no_france_fx = " AND c.countries_iso_code_2 != 'FX' ";
	$current_language_id = $_SESSION['languages_id'];
	
    if (xtc_not_null($countries_id)) {
      if ($with_iso_codes == true) {
			$countries = xtc_db_query("SELECT i18n_c.countries_name countries_name, c.countries_iso_code_2 countries_iso_code_2, c.countries_iso_code_3 countries_iso_code_3
									FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
									ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
									INNER JOIN " . TABLE_LANGUAGES . " lng
									ON (lng.code = i18n_c.language_code)
									WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') AND (c.countries_id = '" . (int)$countries_id . "') "
									.$no_france_fx."
									ORDER BY countries_name
									");
        $countries_values = xtc_db_fetch_array($countries);
        $countries_array = array('countries_name' => $countries_values['countries_name'],
                                 'countries_iso_code_2' => $countries_values['countries_iso_code_2'],
                                 'countries_iso_code_3' => $countries_values['countries_iso_code_3']);
      } else {
			$countries = xtc_db_query("SELECT i18n_c.countries_name countries_name
									FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
									ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
									INNER JOIN " . TABLE_LANGUAGES . " lng
									ON (lng.code = i18n_c.language_code)
									WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') AND (c.countries_id = '" . (int)$countries_id . "')"
									.$no_france_fx);
        $countries_values = xtc_db_fetch_array($countries);
        $countries_array = array('countries_name' => $countries_values['countries_name']);
      }
    } else {
		$countries = xtc_db_query("SELECT c.countries_id countries_id,
								i18n_c.countries_name countries_name
								FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
								ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
								INNER JOIN " . TABLE_LANGUAGES . " lng
								ON (lng.code = i18n_c.language_code)
								WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') "
								.$no_france_fx." 
								ORDER BY i18n_c.countries_name ASC");
		/*$countries = xtc_db_query("SELECT c.countries_id countries_id,
								c.countries_iso_code_2 countries_iso_code_2, c.countries_iso_code_3 countries_iso_code_3, c.address_format_id address_format_id, c.status status, c.required_zones required_zones, c.timezone timezone,
								i18n_c.countries_name countries_name,
								lng.languages_id languages_id
								FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
								ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
								INNER JOIN " . TABLE_LANGUAGES . " lng
								ON (lng.code = i18n_c.language_code)
								WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1')
								".$no_france_fx." 
								ORDER BY i18n_c.countries_name ASC");*/

      while ($countries_values = xtc_db_fetch_array($countries)) {
        $countries_array[] = array('countries_id' => $countries_values['countries_id'],
                                   'countries_name' => $countries_values['countries_name']);
      }
    }

    return $countries_array;
  }

/* Original function 2.0 Rev. 9678

	function xtc_get_countriesList($countries_id = '', $with_iso_codes = false) {
	$countries_array = array();
	$no_france_fx = " AND countries_iso_code_2 != 'FX' ";
	if (xtc_not_null($countries_id)) {
		if ($with_iso_codes == true) {
			$countries = xtc_db_query("SELECT countries_name, countries_iso_code_2, countries_iso_code_3 
                                     FROM " . TABLE_COUNTRIES . " 
                                    WHERE countries_id = '" . (int)$countries_id . "' 
                                      AND status = '1'
                                          ".$no_france_fx."
                                 ORDER BY countries_name
                                  ");
			$countries_values = xtc_db_fetch_array($countries);
			$countries_array = array('countries_name' => $countries_values['countries_name'],
				'countries_iso_code_2' => $countries_values['countries_iso_code_2'],
				'countries_iso_code_3' => $countries_values['countries_iso_code_3']);
		} else {
			$countries = xtc_db_query("SELECT countries_name 
                                     FROM " . TABLE_COUNTRIES . " 
                                    WHERE countries_id = '" . (int)$countries_id . "'
                                          ".$no_france_fx."                                    
                                      AND status = '1'
                                  ");
			$countries_values = xtc_db_fetch_array($countries);
			$countries_array = array('countries_name' => $countries_values['countries_name']);
		}
	} else {
		$countries = xtc_db_query("SELECT countries_id, countries_name 
                                   FROM " . TABLE_COUNTRIES . " 
                                  WHERE status = '1'
                                        ".$no_france_fx."                                  
                               ORDER BY countries_name");
		while ($countries_values = xtc_db_fetch_array($countries)) {
			$countries_array[] = array('countries_id' => $countries_values['countries_id'],
				'countries_name' => $countries_values['countries_name']);
		}
	}

	return $countries_array;
}
*/
 ?>