Ticket #419: xtc_get_countries.inc.php

File xtc_get_countries.inc.php, 6.5 KB (added by Volker Strähle, 9 years ago)
Line 
1<?php
2/* -----------------------------------------------------------------------------------------
3 $Id: xtc_get_countries.inc.php 4200 2013-01-10 19:47:11Z Tomcraft1980 $
4
5
6 modified eCommerce Shopsoftware
7 http://www.modified-shop.org
8
9 Copyright (c) 2009 - 2013 [www.modified-shop.org]
10 -----------------------------------------------------------------------------------------
11 based on:
12 (c) 2000-2001 The Exchange Project (earlier name of osCommerce)
13 (c) 2002-2003 osCommerce(general.php,v 1.225 2003/05/29); www.oscommerce.com
14 (c) 2003 nextcommerce (xtc_get_countries.inc.php,v 1.3 2003/08/13); www.nextcommerce.org
15 (c) 2006 xt:Commerce; www.xt-commerce.com
16
17 Released under the GNU General Public License
18 ---------------------------------------------------------------------------------------*/
19define('TABLE_COUNTRIES_I18N', 'i18n_countries'); // todo: move to database_tables.php
20
21 function xtc_get_countriesList($countries_id = '', $with_iso_codes = false) {
22 $countries_array = array();
23 $no_france_fx = " AND c.countries_iso_code_2 != 'FX' ";
24 $current_language_id = $_SESSION['languages_id'];
25
26 if (xtc_not_null($countries_id)) {
27 if ($with_iso_codes == true) {
28 $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
29 FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
30 ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
31 INNER JOIN " . TABLE_LANGUAGES . " lng
32 ON (lng.code = i18n_c.language_code)
33 WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') AND (c.countries_id = '" . (int)$countries_id . "') "
34 .$no_france_fx."
35 ORDER BY countries_name
36 ");
37 $countries_values = xtc_db_fetch_array($countries);
38 $countries_array = array('countries_name' => $countries_values['countries_name'],
39 'countries_iso_code_2' => $countries_values['countries_iso_code_2'],
40 'countries_iso_code_3' => $countries_values['countries_iso_code_3']);
41 } else {
42 $countries = xtc_db_query("SELECT i18n_c.countries_name countries_name
43 FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
44 ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
45 INNER JOIN " . TABLE_LANGUAGES . " lng
46 ON (lng.code = i18n_c.language_code)
47 WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') AND (c.countries_id = '" . (int)$countries_id . "')"
48 .$no_france_fx);
49 $countries_values = xtc_db_fetch_array($countries);
50 $countries_array = array('countries_name' => $countries_values['countries_name']);
51 }
52 } else {
53 $countries = xtc_db_query("SELECT c.countries_id countries_id,
54 i18n_c.countries_name countries_name
55 FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
56 ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
57 INNER JOIN " . TABLE_LANGUAGES . " lng
58 ON (lng.code = i18n_c.language_code)
59 WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1') "
60 .$no_france_fx."
61 ORDER BY i18n_c.countries_name ASC");
62 /*$countries = xtc_db_query("SELECT c.countries_id countries_id,
63 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,
64 i18n_c.countries_name countries_name,
65 lng.languages_id languages_id
66 FROM (" . TABLE_COUNTRIES . " c INNER JOIN " . TABLE_COUNTRIES_I18N . " i18n_c
67 ON (c.countries_iso_code_2 = i18n_c.countries_iso_code_2))
68 INNER JOIN " . TABLE_LANGUAGES . " lng
69 ON (lng.code = i18n_c.language_code)
70 WHERE (lng.languages_id = '".$current_language_id."') AND (c.status = '1')
71 ".$no_france_fx."
72 ORDER BY i18n_c.countries_name ASC");*/
73
74 while ($countries_values = xtc_db_fetch_array($countries)) {
75 $countries_array[] = array('countries_id' => $countries_values['countries_id'],
76 'countries_name' => $countries_values['countries_name']);
77 }
78 }
79
80 return $countries_array;
81 }
82
83/* Original function 2.0 Rev. 9678
84
85 function xtc_get_countriesList($countries_id = '', $with_iso_codes = false) {
86 $countries_array = array();
87 $no_france_fx = " AND countries_iso_code_2 != 'FX' ";
88 if (xtc_not_null($countries_id)) {
89 if ($with_iso_codes == true) {
90 $countries = xtc_db_query("SELECT countries_name, countries_iso_code_2, countries_iso_code_3
91 FROM " . TABLE_COUNTRIES . "
92 WHERE countries_id = '" . (int)$countries_id . "'
93 AND status = '1'
94 ".$no_france_fx."
95 ORDER BY countries_name
96 ");
97 $countries_values = xtc_db_fetch_array($countries);
98 $countries_array = array('countries_name' => $countries_values['countries_name'],
99 'countries_iso_code_2' => $countries_values['countries_iso_code_2'],
100 'countries_iso_code_3' => $countries_values['countries_iso_code_3']);
101 } else {
102 $countries = xtc_db_query("SELECT countries_name
103 FROM " . TABLE_COUNTRIES . "
104 WHERE countries_id = '" . (int)$countries_id . "'
105 ".$no_france_fx."
106 AND status = '1'
107 ");
108 $countries_values = xtc_db_fetch_array($countries);
109 $countries_array = array('countries_name' => $countries_values['countries_name']);
110 }
111 } else {
112 $countries = xtc_db_query("SELECT countries_id, countries_name
113 FROM " . TABLE_COUNTRIES . "
114 WHERE status = '1'
115 ".$no_france_fx."
116 ORDER BY countries_name");
117 while ($countries_values = xtc_db_fetch_array($countries)) {
118 $countries_array[] = array('countries_id' => $countries_values['countries_id'],
119 'countries_name' => $countries_values['countries_name']);
120 }
121 }
122
123 return $countries_array;
124}
125*/
126 ?>