WordPress.org

Plugin Directory

Changeset 610732


Ignore:
Timestamp:
10/11/12 09:10:42 (19 months ago)
Author:
garyc40
Message:

Fix: Outdated country codes and currency codes.

  • Display warning messages if the following outdated country codes are

being used as base country: YU, UK, AN, TP

  • Fix various bugs in WPSC_Country class
  • Use WPSC_Country class for updating tasks rather than SQL queries.
  • New upgrade routines that create new records for countries according

to ISO 3166, and also update outdated currency / country codes.

  • All country dropdown functions now use a common helper function

to output dropdown element: wpsc_get_country_dropdown().

Fixes issue 594.
Fixes issue 1120.

Location:
wp-e-commerce/branches/branch-3.8
Files:
1 added
12 edited

Legend:

Unmodified
Added
Removed
  • wp-e-commerce/branches/branch-3.8/wpsc-admin/admin.php

    r610724 r610732  
    10841084 * @return html 
    10851085 */ 
    1086 function wpsc_gb_deprecated_notice() { 
    1087     if ( 'GB' == get_option( 'base_country' ) ) 
    1088         echo '<div id="wpsc-warning" class="error"><p>' . sprintf( __( '<strong>We have deprecated Great Britain as a store option</strong>. <br /> We highly recommend changing your <em>Base Country</em> to the United Kingdom on the <a href="%1$s">General Settings</a> page.', 'wpsc' ), admin_url( 'options-general.php?page=wpsc-settings&tab=general' ) ) . '</p></div>'; 
    1089 } 
    1090  
    1091 add_action( 'admin_notices', 'wpsc_gb_deprecated_notice' ); 
     1086function _wpsc_action_admin_notices_deprecated_countries_notice() { 
     1087    $base_country = get_option( 'base_country' ); 
     1088 
     1089    if ( ! in_array( $base_country, WPSC_Country::get_outdated_isocodes() ) ) 
     1090        return; 
     1091 
     1092    switch ( $base_country ) { 
     1093        case 'YU': 
     1094            $message = __( 'Yugoslavia is no longer a valid official country name according to <a href="%1$s">ISO 3166</a> while both Serbia and Montenegro have been added to the country list.<br /> As a result, we highly recommend changing your <em>Base Country</em> to reflect this change on the <a href="%2$s">General Settings</a> page.', 'wpsc' ); 
     1095            break; 
     1096        case 'UK': 
     1097            $message = __( 'Prior to WP e-Commerce 3.8.9, in your database, United Kingdom\'s country code is UK and you have already selected that country code as the base country. However, now that you\'re using WP e-Commerce version %3$s, it is recommended that you change your base country to the official "GB" country code, according to <a href="%1$s">ISO 3166</a>.<br /> Please go to <a href="%2$s">General Setings</a> page to make this change.<br />The legacy "UK" item will be marked as "U.K. (legacy)" on the country drop down list. Simply switch to the official "United Kingdom (ISO 3166)" to use the "GB" country code.' , 'wpsc' ); 
     1098            break; 
     1099        case 'AN': 
     1100            $message = __( 'Netherlands Antilles is no longer a valid official country name according to <a href="%1$s">ISO 3166</a>.<br />Please consider changing your <em>Base Country</em> to reflect this change on the <a href="%2$s">General Settings</a> page.', 'wpsc' ); 
     1101        case 'TP': 
     1102            $message = __( 'Prior to WP e-Commerce 3.8.9, in your database, East Timor\'s country code is TP and you have already selected that country code as the base country. However, now that you\'re using WP e-Commerce version %3$s, it is recommended that you change your base country to the official "TL" country code, according to <a href="%1$s">ISO 3166</a>.<br /> Please go to <a href="%2$s">General Setings</a> page to make this change.<br />The legacy "TP" item will be marked as "East Timor (legacy)" on the country drop down list. Simply switch to the official "Timor-Leste (ISO 3166)" to use the "TL" country code.' , 'wpsc' ); 
     1103            break; 
     1104    } 
     1105 
     1106    $message = sprintf( 
     1107        /* message */ $message, 
     1108        /* %1$s    */ 'http://en.wikipedia.org/wiki/ISO_3166-1', 
     1109        /* %2$s    */ admin_url( 'options-general.php?page=wpsc-settings&tab=general' ), 
     1110        /* %3$s    */ WPSC_VERSION 
     1111    ); 
     1112    echo '<div id="wpsc-warning" class="error"><p>' . $message . '</p></div>'; 
     1113} 
     1114 
     1115add_action( 'admin_notices', '_wpsc_action_admin_notices_deprecated_countries_notice' ); 
    10921116add_action( 'permalink_structure_changed' , '_wpsc_action_permalink_structure_changed' ); 
    10931117add_action( 'wp_ajax_category_sort_order', 'wpsc_ajax_set_category_order' ); 
  • wp-e-commerce/branches/branch-3.8/wpsc-admin/db-upgrades/routines/1.php

    r586468 r610732  
    2222 
    2323function _wpsc_fix_mexico_currency_sign() { 
    24     global $wpdb; 
    25     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    26         array( 
    27             'currency'    => __( 'Mexican Peso', 'wpsc' ), 
    28             'symbol'      => __( '$', 'wpsc' ), 
    29             'symbol_html' => __( '&#036;', 'wpsc' ), 
    30             'has_regions' => '1' 
    31         ), 
    32         array( 
    33             'id' => '141' 
    34         ) 
    35     ); 
     24    $country = new WPSC_Country( 'MX', 'isocode' ); 
     25    $country->set( array( 
     26        'currency'    => __( 'Mexican Peso', 'wpsc' ), 
     27        'symbol'      => __( '$', 'wpsc' ), 
     28        'symbol_html' => __( '&#036;', 'wpsc' ), 
     29        'has_regions' => '1' 
     30    ) ); 
     31    $country->save(); 
    3632} 
    3733 
     
    7773 
    7874function _wpsc_fix_colombia_currency() { 
    79     global $wpdb; 
    80     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    81         array( 
    82             'symbol'      => __( '$', 'wpsc' ), 
    83             'symbol_html' => __( '&#036;', 'wpsc' ), 
    84         ), 
    85         array( 
    86             'id' => 90, 
    87         ) 
    88     ); 
     75    $country = new WPSC_Country( 'CO', 'isocode' ); 
     76    $country->set( array( 
     77        'symbol'      => __( '$', 'wpsc' ), 
     78        'symbol_html' => __( '&#036;', 'wpsc' ), 
     79    ) ); 
     80    $country->save(); 
    8981} 
    9082 
    9183function _wpsc_fix_ukraine_currency() { 
    92     global $wpdb; 
    93     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    94         array( 
    95             'code'        => __( 'UAH', 'wpsc' ), 
    96             'symbol'      => __( '₴', 'wpsc' ), 
    97             'symbol_html' => __( '&#8372;', 'wpsc' ), 
    98         ), 
    99         array( 
    100             'id' => '225', 
    101         ) 
    102      ); 
     84    $country = new WPSC_Country( 'UA', 'isocode' ); 
     85    $country->set( array( 
     86        'code'        => __( 'UAH', 'wpsc' ), 
     87        'symbol'      => __( '₴', 'wpsc' ), 
     88        'symbol_html' => __( '&#8372;', 'wpsc' ), 
     89    ) ); 
     90    $country->save(); 
    10391} 
    10492 
    10593function _wpsc_fix_russia_currency() { 
    106     global $wpdb; 
    107     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    108         array( 
    109             'code' => __( 'RUB', 'wpsc' ), 
    110         ), 
    111         array( 
    112             'id' => '180', 
    113         ) 
    114      ); 
     94    $country = new WPSC_Country( 'RU', 'isocode' ); 
     95    $country->set( 'code', __( 'RUB', 'wpsc' ) ); 
     96    $country->save(); 
    11597} 
    11698 
    11799function _wpsc_fix_belarus_currency() { 
    118     global $wpdb; 
    119     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    120         array( 
    121             'code'    => __( 'BYR', 'wpsc' ) 
    122         ), 
    123         array( 
    124             'id' => '117' 
    125         ) 
    126      ); 
     100    $country = new WPSC_Country( 'BY', 'isocode' ); 
     101    $country->set( 'code', __( 'BYR', 'wpsc' ) ); 
     102    $country->save(); 
    127103} 
    128104 
    129105function _wpsc_fix_estonia_currency() { 
    130     global $wpdb; 
    131     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    132         array( 
    133             'currency'    => __( 'Euro', 'wpsc' ), 
    134             'symbol'      => __( '€', 'wpsc' ), 
    135             'symbol_html' => __( '&#8364;', 'wpsc' ), 
    136             'code'        => __( 'EUR', 'wpsc' ) 
    137         ), 
    138         array( 
    139             'id' => '70' 
    140         ) 
    141      ); 
     106    $country = new WPSC_Country( 'EE', 'isocode' ); 
     107    $country->set( array( 
     108        'currency'    => __( 'Euro', 'wpsc' ), 
     109        'symbol'      => __( '€', 'wpsc' ), 
     110        'symbol_html' => __( '&#8364;', 'wpsc' ), 
     111        'code'        => __( 'EUR', 'wpsc' ) 
     112    ) ); 
     113    $country->save(); 
    142114} 
    143115 
    144116function _wpsc_fix_slovenia_currency() { 
    145     global $wpdb; 
    146     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    147         array( 
    148             'currency'    => __( 'Euro', 'wpsc' ), 
    149             'symbol'      => __( '€', 'wpsc' ), 
    150             'symbol_html' => __( '&#8364;', 'wpsc' ), 
    151             'code'        => __( 'EUR', 'wpsc' ) 
    152         ), 
    153         array( 
    154             'id' => '196' 
    155         ) 
    156      ); 
     117    $country = new WPSC_Country( 'SI', 'isocode' ); 
     118    $country->set( array( 
     119        'currency'    => __( 'Euro', 'wpsc' ), 
     120        'symbol'      => __( '€', 'wpsc' ), 
     121        'symbol_html' => __( '&#8364;', 'wpsc' ), 
     122        'code'        => __( 'EUR', 'wpsc' ) 
     123    ) ); 
     124    $country->save(); 
    157125} 
    158126 
    159127function _wpsc_fix_sudan_currency() { 
    160     global $wpdb; 
    161     $wpdb->update( WPSC_TABLE_CURRENCY_LIST, 
    162         array( 
    163             'currency'    => __( 'Sudanese Pound', 'wpsc' ), 
    164             'code' => __( 'SDG', 'wpsc' ) 
    165         ), 
    166         array( 
    167             'id' => '203' 
    168         ) 
    169      ); 
     128    $country = new WPSC_Country( 'SD', 'isocode' ); 
     129    $country->set( array( 
     130        'currency' => __( 'Sudanese Pound', 'wpsc' ), 
     131        'code'     => __( 'SDG', 'wpsc' ) 
     132    ) ); 
     133    $country->save(); 
    170134} 
    171135 
    172136function _wpsc_create_south_sudan() { 
    173     global $wpdb; 
    174     $wpdb->insert( WPSC_TABLE_CURRENCY_LIST, 
    175         array( 
    176             'id'        => '242', 
    177             'country'   => __( 'South Sudan', 'wpsc' ), 
    178             'isocode'   => __( 'SS', 'wpsc' ), 
    179             'currency'  => __( 'South Sudanese Pound', 'wpsc' ), 
    180             'code'      => __( 'SSP', 'wpsc' ), 
    181             'continent' => 'africa', 
    182         ) 
    183      ); 
     137    $country = new WPSC_Country( array( 
     138        'id'        => '242', 
     139        'country'   => __( 'South Sudan', 'wpsc' ), 
     140        'isocode'   => __( 'SS', 'wpsc' ), 
     141        'currency'  => __( 'South Sudanese Pound', 'wpsc' ), 
     142        'code'      => __( 'SSP', 'wpsc' ), 
     143        'continent' => 'africa', 
     144    ) ); 
     145    $country->save(); 
    184146} 
  • wp-e-commerce/branches/branch-3.8/wpsc-admin/display-options-settings.page.php

    r586449 r610732  
    2323    WPSC_Settings_Page::get_instance()->output_tabs(); 
    2424} 
    25  
    26 function country_list( $selected_country = null ) { 
    27     global $wpdb; 
    28  
    29     $output       = ''; 
    30     $output      .= "<option value=''></option>"; 
    31     $country_data = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_CURRENCY_LIST . "` ORDER BY `country` ASC", ARRAY_A ); 
    32  
    33     foreach ( (array)$country_data as $country ) { 
    34         $selected = ''; 
    35  
    36         // As of 3.8.9, we deprecated Great Britain as a country in favor of the UK. 
    37         // See http://code.google.com/p/wp-e-commerce/issues/detail?id=1079 
    38         if ( 'GB' == $country['isocode'] && 'GB' != get_option( 'base_country' ) ) 
    39             continue; 
    40  
    41         if ( $selected_country == $country['isocode'] ) 
    42             $selected = "selected='selected'"; 
    43  
    44         $output .= "<option value='" . $country['isocode'] . "' $selected>" . htmlspecialchars( $country['country'] ) . "</option>"; 
    45     } 
    46  
    47     return $output; 
    48 } 
    49  
    5025 
    5126function wpsc_settings_page_update_notification() { 
  • wp-e-commerce/branches/branch-3.8/wpsc-admin/includes/settings-tabs/general.php

    r610695 r610732  
    4545                <th scope="row"><?php esc_html_e( 'Base Country/Region', 'wpsc' ); ?>: </th> 
    4646                <td> 
    47                     <select id="wpsc-base-country-drop-down" name='wpsc_options[base_country]'> 
    48                         <?php echo country_list( esc_attr( get_option( 'base_country' ) ) ); ?> 
    49                     </select> 
     47                    <?php 
     48                        wpsc_country_dropdown( array( 
     49                            'id'       => 'wpsc-base-country-drop-down', 
     50                            'name'     => 'wpsc_options[base_country]', 
     51                            'selected' => get_option( 'base_country' ), 
     52                        ) ); 
     53                    ?> 
    5054                    <span id='wpsc-base-region-drop-down'> 
    5155                        <?php $this->display_region_drop_down(); ?> 
  • wp-e-commerce/branches/branch-3.8/wpsc-core/wpsc-constants.php

    r610691 r610732  
    11<?php 
    2  
    32// Left Overs 
    43$wpsc_currency_data = array(); 
     
    3534    define( 'WPSC_MINOR_VERSION', '571548' ); 
    3635    define( 'WPSC_PRESENTABLE_VERSION', '3.8.9-beta' ); 
    37     define( 'WPSC_DB_VERSION', 1 ); 
     36    define( 'WPSC_DB_VERSION', 2 ); 
    3837 
    3938    // Define Debug Variables for developers 
     
    284283    $cart = maybe_unserialize( wpsc_get_customer_meta( 'cart' ) ); 
    285284 
    286     if ( is_object( $cart ) ) 
     285    if ( is_object( $cart ) && is_wp_error( $cart ) ) 
    287286        $GLOBALS['wpsc_cart'] = $cart; 
    288287    else 
  • wp-e-commerce/branches/branch-3.8/wpsc-core/wpsc-deprecated.php

    r610706 r610732  
    726726   } 
    727727} 
     728 
     729/** 
     730 * @deprecated since 3.8.9. Use _wpsc_country_dropdown_options instead. 
     731 * @param  string $selected_country ISO code of selected country 
     732 * @return string                   output 
     733 */ 
     734function country_list( $selected_country = null ) { 
     735    return _wpsc_country_dropdown_options( array( 'selected' => $selected_country ) ); 
     736} 
  • wp-e-commerce/branches/branch-3.8/wpsc-core/wpsc-functions.php

    r610712 r610732  
    16261626        $id = wpsc_get_current_customer_id(); 
    16271627 
     1628    // error_log( "customer id: " . $id ); 
     1629 
    16281630    if ( ! $id ) 
    16291631        return new WP_Error( 'wpsc_customer_meta_invalid_customer_id', __( 'Invalid customer ID', 'wpsc' ), $id ); 
  • wp-e-commerce/branches/branch-3.8/wpsc-includes/checkout.class.php

    r610697 r610732  
    456456    $acceptable_countries = wpsc_get_acceptable_countries(); 
    457457 
    458     $output .= "<select name='country' id='current_country' " . $js . " >"; 
    459  
    460     foreach ( $country_data as $country ) { 
    461         if ( $selected_country == $country['isocode'] ) 
    462             $selected = "selected='selected'"; 
    463  
    464         // As of 3.8.9, we deprecated Great Britain as a country in favor of the UK. 
    465         // See http://code.google.com/p/wp-e-commerce/issues/detail?id=1079 
    466         if ( 'GB' == $country['isocode'] && 'GB' != get_option( 'base_country' ) ) 
    467             continue; 
    468  
    469         if ( $acceptable_countries && ! is_array( $acceptable_countries ) ) 
    470             $disabled = ''; 
    471         elseif ( is_array( $acceptable_countries ) ) 
    472             $disabled = ! in_array( $country['id'], $acceptable_countries ) ? ' disabled = "disabled"' : ''; 
    473         else 
    474             $disabled = ''; 
    475  
    476         $output .= "<option value='" . $country['isocode'] . "' ". selected( $selected_country, $country['isocode'], false ) . $disabled .">" . esc_html( $country['country'] ) . "</option>"; 
    477     } 
    478  
    479     $output .= "</select>"; 
     458    $output .= wpsc_get_country_dropdown( array( 
     459        'name'                  => 'country', 
     460        'id'                    => 'current_country', 
     461        'additional_attributes' => $js, 
     462        'acceptable_ids'        => $acceptable_countries, 
     463        'selected'              => $selected_country, 
     464        'placeholder'           => '', 
     465    ) ); 
    480466 
    481467    $output .= wpsc_shipping_region_list( $selected_country, $selected_region, $shippingdetails ); 
  • wp-e-commerce/branches/branch-3.8/wpsc-includes/country.class.php

    r586470 r610732  
    1515    ); 
    1616 
     17    private static $outdated_isocodes = array( 
     18        'YU', 
     19        'UK', 
     20        'AN', 
     21        'TP', 
     22        'GF', 
     23    ); 
     24 
     25    private static $default_values = array( 
     26        'country'     => '', 
     27        'isocode'     => '', 
     28        'currency'    => '', 
     29        'symbol'      => '', 
     30        'symbol_html' => '', 
     31        'code'        => '', 
     32        'has_regions' => '', 
     33        'tax'         => '', 
     34        'continent'   => '', 
     35        'visible'     => '1', 
     36    ); 
     37 
    1738    private $args = array( 
    1839        'col' => '', 
     
    2243    private $data = array(); 
    2344 
    24     public static function &query( $args ) { 
    25         // when this is a custom post type, we'll have a separate WP_Query instance that handles this 
    26         $args = wp_parse_args( $args ); 
    27         if ( array_key_exists( 'id', $args ) ) { 
    28             $country = new WPSC_Country( $args['id'] ); 
    29             return array( $country ); 
    30         } elseif ( array_key_exists( 'isocode', $args ) ) { 
    31             $country = new WPSC_Country( $args['isocode'], 'isocode' ); 
    32             return array( $country ); 
    33         } 
     45    private $exists = false; 
     46 
     47    private $fetched = false; 
     48 
     49    public static function get_outdated_isocodes() { 
     50        return self::$outdated_isocodes; 
     51    } 
     52 
     53    public static function get_all() { 
     54        global $wpdb; 
     55 
     56        $cache = wp_cache_get( 'all', 'wpsc_countries' ); 
     57 
     58        if ( $cache ) 
     59            return $cache; 
     60 
     61        $sql = "SELECT * FROM " . WPSC_TABLE_CURRENCY_LIST . " ORDER BY country"; 
     62        $db_results = $wpdb->get_results( $sql, ARRAY_A ); 
     63        $list = array(); 
     64 
     65        foreach ( $db_results as $row ) { 
     66            self::update_cache( $row ); 
     67 
     68            if ( in_array( $row['isocode'], self::$outdated_isocodes ) && $row['isocode'] != get_option( 'base_country' ) ) 
     69                continue; 
     70 
     71            $list[] = new WPSC_Country( $row['id'] ); 
     72        } 
     73 
     74        wp_cache_set( 'all', $list, 'wpsc_countries' ); 
     75 
     76        return $list; 
    3477    } 
    3578 
     
    5093        } 
    5194 
    52         return wp_cache_get( $value, 'id' ); 
    53     } 
    54  
    55     public static function update_cache( $country ) { 
    56         $id = $country->get( 'id' ); 
    57         wp_cache_set( $id, $country->data, 'wpsc_countries' ); 
    58         wp_cache_set( $country->get( 'isocode' ), $id, 'wpsc_country_isocodes' ); 
     95        return wp_cache_get( $value, 'wpsc_countries' ); 
     96    } 
     97 
     98    public static function update_cache( $data ) { 
     99        wp_cache_set( $data['id'], $data, 'wpsc_countries' ); 
     100        wp_cache_set( $data['isocode'], $data['id'], 'wpsc_country_isocodes' ); 
    59101    } 
    60102 
     
    66108 
    67109        $country = new WPSC_Country( $value, $col ); 
    68         wp_cache_delete( $country->id, 'wpsc_countries' ); 
    69         wp_cache_delete( $country->isocode, 'wpsc_country_isocodes' ); 
     110        wp_cache_delete( $country->get( 'id' ), 'wpsc_countries' ); 
     111        wp_cache_delete( $country->get( 'isocode' ), 'wpsc_country_isocodes' ); 
    70112    } 
    71113 
    72114    public function __construct( $value = null, $col = 'id' ) { 
    73115        global $wpdb; 
     116 
     117        if ( is_array( $value ) ) { 
     118            $data = wp_parse_args( $value, self::$default_values ); 
     119            $this->set( $data ); 
     120            return; 
     121        } 
    74122 
    75123        if ( is_null( $value ) && $col == 'id' ) 
     
    84132        ); 
    85133 
    86         if ( $this->data = self::get_cache( $value, $col ) ) 
     134        $cache = self::get_cache( $value, $col ); 
     135 
     136        if ( $cache ) { 
     137            $this->data = $cache; 
     138            $this->exists = true; 
     139            $this->fetched = true; 
     140        } 
     141    } 
     142 
     143    private function fetch() { 
     144        global $wpdb; 
     145 
     146        if ( $this->fetched ) 
     147            return; 
     148 
     149        $col = $this->args['col']; 
     150        $value = $this->args['value']; 
     151 
     152        if ( empty( $col ) || empty( $value ) ) 
    87153            return; 
    88154 
     
    90156 
    91157        $sql = $wpdb->prepare( "SELECT * FROM " . WPSC_TABLE_CURRENCY_LIST . " WHERE {$col} = {$format}", $value ); 
    92         $this->data = $wpdb->get_row( $sql, ARRAY_A ); 
    93  
    94         self::update_cache( $this ); 
     158 
     159        $data = $wpdb->get_row( $sql, ARRAY_A ); 
     160 
     161        if ( ! empty( $data ) ) { 
     162            $this->exists = true; 
     163            $this->data = $data; 
     164            self::update_cache( $this->data ); 
     165        } 
     166 
     167        $this->fetched = true; 
    95168    } 
    96169 
    97170    public function get( $key ) { 
     171        if ( ! $this->fetched ) 
     172            $this->fetch(); 
     173 
    98174        if ( array_key_exists( $key, $this->data ) ) 
    99175            return $this->data[$key]; 
     
    102178    } 
    103179 
    104     public function set( $key, $value ) { 
     180    public function set( $key, $value = '' ) { 
     181        if ( is_array( $key ) ) { 
     182            foreach ( $key as $col => $value ) { 
     183                $this->set( $col, $value ); 
     184            } 
     185 
     186            return; 
     187        } 
     188 
    105189        $this->data[$key] = $value; 
    106190    } 
     
    108192    public function save() { 
    109193        global $wpdb; 
     194 
     195        $where_col = $this->args['col']; 
     196        $result = false; 
     197 
    110198        $format = array(); 
    111199        foreach ( $this->data as $key => $value ) { 
     
    113201        } 
    114202        $where_format = in_array( $this->args['col'], self::$string_cols ) ? '%s' : '%d'; 
    115         $wpdb->update( WPSC_TABLE_CURRENCY_LIST, $this->data, array( $this->args['col'] => $this->args['value'] ), $format, $where_format ); 
    116         self::delete_cache( $this->args['value'], $this->args['col'] ); 
    117     } 
    118 } 
     203 
     204        if ( $where_col ) { 
     205            $result = $wpdb->update( WPSC_TABLE_CURRENCY_LIST, $this->data, array( $this->args['col'] => $this->args['value'] ), $format, $where_format ); 
     206            self::delete_cache( $this->args['value'], $this->args['col'] ); 
     207        } else { 
     208            $result = $wpdb->insert( WPSC_TABLE_CURRENCY_LIST, $this->data, $format ); 
     209 
     210            if ( $result ) { 
     211                $this->set( 'id', $wpdb->insert_id ); 
     212 
     213                $this->args = array( 
     214                    'col'   => 'id', 
     215                    'value' => $wpdb->insert_id, 
     216                ); 
     217 
     218                $this->fetched = false; 
     219            } 
     220        } 
     221 
     222        return $result; 
     223    } 
     224 
     225    public function exists() { 
     226        return $this->exists; 
     227    } 
     228} 
     229 
     230function _wpsc_is_country_disabled( $country, $args ) { 
     231    extract( $args, EXTR_SKIP ); 
     232 
     233    $isocode = $country->get( 'isocode' ); 
     234    $id      = $country->get( 'id' ); 
     235 
     236    if ( is_array( $acceptable ) && ! in_array( $isocode, $acceptable ) ) 
     237        return true; 
     238 
     239    if ( is_array( $acceptable_ids ) && ! in_array( $id, $acceptable_ids ) ) 
     240        return true; 
     241 
     242    if ( is_array( $disabled ) && in_array( $isocode, $disabled ) ) 
     243        return true; 
     244 
     245    if ( is_array( $disabled_ids ) && in_array( $id, $disabled_ids ) ) 
     246        return true; 
     247 
     248    return false; 
     249} 
     250 
     251function _wpsc_country_dropdown_options( $args = '' ) { 
     252    $defaults = array( 
     253        'acceptable'     => null, 
     254        'acceptable_ids' => null, 
     255        'selected'       => '', 
     256        'disabled'       => null, 
     257        'disabled_ids'   => null, 
     258        'placeholder'   => __( 'Please select', 'wpsc' ), 
     259    ); 
     260 
     261    $args = wp_parse_args( $args, $defaults ); 
     262 
     263    $output = ''; 
     264 
     265    if ( $args['placeholder'] ) 
     266        $output .= "<option value=''>" . esc_html( $args['placeholder'] ) . "</option>"; 
     267 
     268    $countries = WPSC_Country::get_all(); 
     269    $base_country = get_option( 'base_country' ); 
     270 
     271    foreach ( $countries as $country ) { 
     272        $isocode = $country->get( 'isocode' ); 
     273        $name = $country->get( 'country' ); 
     274 
     275        // if we're in admin area, and the legacy country code "UK" or "TP" is selected as the 
     276        // base country, we should display both this and the more proper "GB" or "TL" options 
     277        // and distinguish these choices somehow 
     278        if ( is_admin() ) { 
     279            if ( in_array( $base_country, array( 'TP', 'UK' ) ) ) 
     280                /* translators: This string will mark the legacy isocode "UK" and "TP" in the country selection dropdown as "legacy" */ 
     281                $name = sprintf( __( '%s (legacy)', 'wpsc' ), $name ); 
     282            elseif ( in_array( $isocode, array( 'GB', 'TL' ) ) ) 
     283                /* translators: This string will mark the legacy isocode "GB" and "TL" in the country selection dropdown as "ISO 3166" */ 
     284                $name = sprintf( __( '%s (ISO 3166)', 'wpsc' ), $name ); 
     285        } 
     286 
     287        $output .= sprintf( 
     288            '<option value="%1$s" %2$s %3$s>%4$s</option>', 
     289            /* %1$s */ esc_attr( $isocode ), 
     290            /* %2$s */ selected( $args['selected'], $isocode, false ), 
     291            /* %3$s */ disabled( _wpsc_is_country_disabled( $country, $args ), true, false ), 
     292            /* %4$s */ esc_html( $name ) 
     293        ); 
     294    } 
     295 
     296    return $output; 
     297} 
     298 
     299function wpsc_get_country_dropdown( $args = '' ) { 
     300    static $count = 0; 
     301    $count ++; 
     302 
     303    $defaults = array( 
     304        'name'                  => 'wpsc_countries', 
     305        'id'                    => "wpsc-country-dropdown-{$count}", 
     306        'class'                 => 'wpsc_country_dropdown', 
     307        'additional_attributes' => '', 
     308    ); 
     309 
     310    $args = wp_parse_args( $args, $defaults ); 
     311 
     312    $output = sprintf( 
     313        '<select name="%1$s" id="%2$s" class="%3$s" %4$s>', 
     314        /* %1$s */ esc_attr( $args['name'] ), 
     315        /* %2$s */ esc_attr( $args['id'] ), 
     316        /* %3$s */ esc_attr( $args['class'] ), 
     317        /* %4$s */ $args['additional_attributes'] 
     318    ); 
     319 
     320    $output .= _wpsc_country_dropdown_options( $args ); 
     321 
     322    $output .= '</select>'; 
     323 
     324    return $output; 
     325} 
     326 
     327function wpsc_country_dropdown( $args = '' ) { 
     328    echo wpsc_get_country_dropdown( $args ); 
     329} 
  • wp-e-commerce/branches/branch-3.8/wpsc-includes/form-display.functions.php

    r586517 r610732  
    22 
    33function nzshpcrt_country_list( $selected_country = null ) { 
    4     global $wpdb; 
    5  
    6     $output = ''; 
    7  
    8     if ( $selected_country == null ) 
    9         $output = "<option value=''>" . __( 'Please select', 'wpsc' ) . "</option>"; 
    10  
    11     $country_data = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_CURRENCY_LIST . "` ORDER BY `country` ASC", ARRAY_A ); 
    12  
    13     foreach ( $country_data as $country ) { 
    14         $selected = ''; 
    15         if ( $selected_country == $country['isocode'] ) 
    16             $selected = "selected='selected'"; 
    17  
    18         $output .= "<option value='" . $country['isocode'] . "' ".$selected.">" . $country['country'] . "</option>"; 
    19     } 
    20  
    21     return $output; 
     4    return _wpsc_country_dropdown_options( array( 
     5        'selected' => $selected_country, 
     6    ) ); 
    227} 
    238 
  • wp-e-commerce/branches/branch-3.8/wpsc-includes/shopping_cart_functions.php

    r586511 r610732  
    9898        $html_form_id = 'region_country_form'; 
    9999 
    100     if ( $supplied_form_id != null ) 
    101         $supplied_form_id = "id='$supplied_form_id'"; 
    102  
    103100    if ( $checkoutfields ) { 
    104101        $js = "onchange='set_shipping_country(\"$html_form_id\", \"$form_id\");'"; 
     
    110107 
    111108    $country_data = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_CURRENCY_LIST . "` ORDER BY `country` ASC", ARRAY_A ); 
     109    $additional_attributes = "title='{$title}' {$js}"; 
    112110    $output .= "<div id='$html_form_id'>\n\r"; 
    113     $output .= "<select $supplied_form_id title='$title' name='collected_data[" . $form_id . "][0]' class='current_country' $js >\n\r"; 
    114  
    115     foreach ( $country_data as $country ) { 
    116         $selected = ''; 
    117  
    118         // As of 3.8.9, we deprecated Great Britain as a country in favor of the UK. 
    119         // See http://code.google.com/p/wp-e-commerce/issues/detail?id=1079 
    120         if ( 'GB' == $country['isocode'] && 'GB' != get_option( 'base_country' ) ) 
    121             continue; 
    122  
    123         if ( $country['visible'] == '1' ) { 
    124             if ( $selected_country == $country['isocode'] ) { 
    125                 $selected = "selected='selected'"; 
    126             } 
    127             $output .= "<option value='" . $country['isocode'] . "' $selected>" . esc_html( $country['country'] ) . "</option>\n\r"; 
    128         } 
    129     } 
    130  
    131     $output .= "</select>\n\r"; 
    132  
     111    $output .= wpsc_get_country_dropdown( array( 
     112        'id'                    => $supplied_form_id, 
     113        'name'                  => "collected_data[{$form_id}][0]", 
     114        'class'                 => 'current_country', 
     115        'selected'              => $selected_country, 
     116        'additional_attributes' => $additional_attributes, 
     117        'placeholder'           => '', 
     118    ) ); 
    133119 
    134120    $region_list    = $wpdb->get_results( $wpdb->prepare( "SELECT `" . WPSC_TABLE_REGION_TAX . "`.* FROM `" . WPSC_TABLE_REGION_TAX . "`, `" . WPSC_TABLE_CURRENCY_LIST . "`  WHERE `" . WPSC_TABLE_CURRENCY_LIST . "`.`isocode` IN(%s) AND `" . WPSC_TABLE_CURRENCY_LIST . "`.`id` = `" . WPSC_TABLE_REGION_TAX . "`.`country_id`", $selected_country ), ARRAY_A ); 
  • wp-e-commerce/branches/branch-3.8/wpsc-updates/currency_list.php

    r586467 r610732  
    22$currency_sql="INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (1, '" . __( 'Mauritania', 'wpsc' ) ."', 'MR', '" . __('Mauritanian Ouguiya', 'wpsc') ."', '', '', '" . __('MRO', 'wpsc') . "', '0', '0','africa','1'); 
    33INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (2, '" . __( 'Martinique (French)', 'wpsc' ) ."', 'MQ', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','southamerica','1'); 
    4 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (3, '" . __( 'Malta', 'wpsc' ) ."', 'MT', '" . __('Maltese Lira', 'wpsc') ."', '', '', '" . __('MTL', 'wpsc') . "', '0', '0' ,'europe','1'); 
     4INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (3, '" . __( 'Malta', 'wpsc' ) ."', 'MT', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0' ,'europe','1'); 
    55INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (4, '" . __( 'Marshall Islands', 'wpsc' ) ."', 'MH', '" . __('US Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0' ,'asiapacific','1'); 
    66INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (5, '" . __( 'Mali', 'wpsc' ) ."', 'ML', '" . __('CFA Franc BCEAO', 'wpsc') ."', '', '', '" . __('XOF', 'wpsc') . "', '0', '0' ,'africa','1'); 
     
    88INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (7, '" . __( 'Malaysia', 'wpsc' ) ."', 'MY', '" . __('Malaysian Ringgit', 'wpsc') ."', '', '', '" . __('MYR', 'wpsc') . "', '0', '0', 'asiapacific','1'); 
    99INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (8, '" . __( 'Malawi', 'wpsc' ) ."', 'MW', '" . __('Malawi Kwacha', 'wpsc') ."', '', '', '" . __('MWK', 'wpsc') . "', '0', '0','africa','1'); 
    10 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (9, '" . __( 'Madagascar', 'wpsc' ) ."', 'MG', '" . __('Malagasy Franc', 'wpsc') ."', '', '', '" . __('MGF', 'wpsc') . "', '0', '0','africa','1'); 
     10INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (9, '" . __( 'Madagascar', 'wpsc' ) ."', 'MG', '" . __('Malagasy Ariary', 'wpsc') ."', '', '', '" . __('MGA', 'wpsc') . "', '0', '0','africa','1'); 
    1111INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (10, '" . __( 'Macau', 'wpsc' ) ."', 'MO', '" . __('Macau Pataca', 'wpsc') ."', '', '', '" . __('MOP', 'wpsc') . "', '0', '0', 'asiapacific','1'); 
    1212INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (11, '" . __( 'Macedonia', 'wpsc' ) ."', 'MK', '" . __('Denar', 'wpsc') ."', '', '', '" . __('MKD', 'wpsc') . "', '0', '0','europe','1'); 
     
    3434INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (33, '" . __( 'Italy', 'wpsc' ) ."', 'IT', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    3535INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (34, '" . __( 'Isle of Man', 'wpsc' ) ."', 'IM', '" . __('Pound Sterling', 'wpsc') ."', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '0','europe','1'); 
    36 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (35, '" . __( 'Israel', 'wpsc' ) ."', 'IL', '" . __('Israeli New Shekel', 'wpsc') ."', '', '', '" . __('ILS', 'wpsc') . "', '0', '0',  'asiapacific','1'); 
     36INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (35, '" . __( 'Israel', 'wpsc' ) ."', 'IL', '" . __('Israeli New Shekel', 'wpsc') ."', '" . __( '₪', 'wpsc' ) . "', '" . __( '&#8362;', 'wpsc' ) . "', '" . __('ILS', 'wpsc') . "', '0', '0',  'asiapacific','1'); 
    3737INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (36, '" . __( 'Ireland', 'wpsc' ) ."', 'IE', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    3838INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (37, '" . __( 'Iraq', 'wpsc' ) ."', 'IQ', '" . __('Iraqi Dinar', 'wpsc') ."', '', '', '" . __('IQD', 'wpsc') . "', '0', '0',  'asiapacific','1'); 
     
    4747INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (46, '" . __( 'Haiti', 'wpsc' ) ."', 'HT', '" . __('Haitian Gourde', 'wpsc') ."', '', '', '" . __('HTG', 'wpsc') . "', '0', '0', 'southamerica','1'); 
    4848INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (47, '" . __( 'Guyana', 'wpsc' ) ."', 'GY', '" . __('Guyana Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('GYD', 'wpsc') . "', '0', '0', 'southamerica','1'); 
    49 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (48, '" . __( 'Guinea Bissau', 'wpsc' ) ."', 'GW', '" . __('Guinea-Bissau Peso', 'wpsc') ."', '', '', '" . __('GWP', 'wpsc') . "', '0', '0' ,'africa','1'); 
     49INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (48, '" . __( 'Guinea Bissau', 'wpsc' ) ."', 'GW', '" . __('CFA Franc BEAC', 'wpsc') ."', '', '', '" . __('XAF', 'wpsc') . "', '0', '0' ,'africa','1'); 
    5050INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (49, '" . __( 'Guinea', 'wpsc' ) ."', 'GN', '" . __('Guinea Franc', 'wpsc') ."', '', '', '" . __('GNF', 'wpsc') . "', '0', '0','africa','1'); 
    51 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (50, '" . __( 'Guernsey', 'wpsc' ) ."', 'GF', '" . __('Pound Sterling', 'wpsc') ."', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '0' ,'europe','1'); 
    52 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (51, '" . __( 'Guatemala', 'wpsc' ) ."', 'GT', '" . __('Guatemalan Quetzal', 'wpsc') ."', '', '', '" . __('QTQ', 'wpsc') . "', '0', '0', 'southamerica','1'); 
     51INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (50, '" . __( 'Guernsey', 'wpsc' ) ."', 'GG', '" . __('Pound Sterling', 'wpsc') ."', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '0' ,'europe','1'); 
     52INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (51, '" . __( 'Guatemala', 'wpsc' ) ."', 'GT', '" . __('Guatemalan Quetzal', 'wpsc') ."', '', '', '" . __('GTQ', 'wpsc') . "', '0', '0', 'southamerica','1'); 
    5353INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (52, '" . __( 'Guam (USA)', 'wpsc' ) ."', 'GU', '" . __('US Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0', 'asiapacific','1'); 
    5454INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (53, '" . __( 'Grenada', 'wpsc' ) ."', 'GD', '" . __('East Carribean Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('XCD', 'wpsc') . "', '0', '0','africa','1'); 
     
    5757INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (56, '" . __( 'Greece', 'wpsc' ) ."', 'GR', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '19','europe','1'); 
    5858INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (57, '" . __( 'Gibraltar', 'wpsc' ) ."', 'GI', '" . __('Gibraltar Pound', 'wpsc') ."', '', '', '" . __('GIP', 'wpsc') . "', '0', '0', 'europe','1'); 
    59 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (58, '" . __( 'Ghana', 'wpsc' ) ."', 'GH', '" . __('Ghanaian Cedi', 'wpsc') ."', '', '', '" . __('GHC', 'wpsc') . "', '0', '0','africa','1'); 
     59INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (58, '" . __( 'Ghana', 'wpsc' ) ."', 'GH', '" . __('Ghanaian Cedi', 'wpsc') ."', '', '', '" . __('GHS', 'wpsc') . "', '0', '0','africa','1'); 
    6060INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (59, '" . __( 'Germany', 'wpsc' ) ."', 'DE', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    6161INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (60, '" . __( 'Georgia', 'wpsc' ) ."', 'GE', '" . __('Georgian Lari', 'wpsc') ."', '', '', '" . __('GEL', 'wpsc') . "', '0', '0','europe','1'); 
     
    7272INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (71, '" . __( 'Eritrea', 'wpsc' ) ."', 'ER', '" . __('Eritrean Nakfa', 'wpsc') ."', '', '', '" . __('ERN', 'wpsc') . "', '0', '0','africa','1'); 
    7373INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (72, '" . __( 'Equatorial Guinea', 'wpsc' ) ."', 'GQ', '" . __('CFA Franc BEAC', 'wpsc') ."', '', '', '" . __('XAF', 'wpsc') . "', '0', '0','africa','1'); 
    74 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (73, '" . __( 'El Salvador', 'wpsc' ) ."', 'SV', '" . __('El Salvador Colon', 'wpsc') ."', '', '', '" . __('SVC', 'wpsc') . "', '0', '0','southamerica','1'); 
     74INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (73, '" . __( 'El Salvador', 'wpsc' ) ."', 'SV', '" . __('US Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','southamerica','1'); 
    7575INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (74, '" . __( 'Egypt', 'wpsc' ) ."', 'EG', '" . __('Egyptian Pound', 'wpsc') ."', '', '', '" . __('EGP', 'wpsc') . "', '0', '0','africa','1'); 
    7676INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (75, '" . __( 'Ecuador', 'wpsc' ) ."', 'EC', '" . __('Ecuador Sucre', 'wpsc') ."', '', '', '" . __('ECS', 'wpsc') . "', '0', '0','southamerica','1'); 
    77 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (76, '" . __( 'East Timor', 'wpsc' ) ."', 'TP', '" . __('Timor Escudo', 'wpsc') ."', '', '', '" . __('TPE', 'wpsc') . "', '0', '0','asiapacific','1'); 
     77INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (76, '" . __( 'Timor-Leste', 'wpsc' ) ."', 'TL', '" . __('US Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','asiapacific','1'); 
    7878INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (77, '" . __( 'Dominican Republic', 'wpsc' ) ."', 'DO', '" . __('Dominican Peso', 'wpsc') ."', '', '', '" . __('DOP', 'wpsc') . "', '0', '0','southamerica','1'); 
    7979INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (78, '" . __( 'Dominica', 'wpsc' ) ."', 'DM', '" . __('East Caribbean Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('XCD', 'wpsc') . "', '0', '0','southamerica','1'); 
     
    8282INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (81, '" . __( 'Democratic Republic of Congo', 'wpsc' ) ."', 'CD', '" . __('Francs', 'wpsc') ."', '', '', '" . __('CDF', 'wpsc') . "', '0', '0','africa','1'); 
    8383INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (82, '" . __( 'Czech Rep.', 'wpsc' ) ."', 'CZ', '" . __('Czech Koruna', 'wpsc') ."', '', '', '" . __('CZK', 'wpsc') . "', '0', '0','europe','1'); 
    84 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (83, '" . __( 'Cyprus', 'wpsc' ) ."', 'CY', '" . __('Cyprus Pound', 'wpsc') ."', '', '', '" . __('CYP', 'wpsc') . "', '0', '0','europe','1'); 
     84INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (83, '" . __( 'Cyprus', 'wpsc' ) ."', 'CY', '" . __('Euro', 'wpsc') ."', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    8585INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (84, '" . __( 'Cuba', 'wpsc' ) ."', 'CU', '" . __('Cuban Peso', 'wpsc') ."', '', '', '" . __('CUP', 'wpsc') . "', '0', '0','northamerica','1'); 
    8686INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (85, '" . __( 'Croatia', 'wpsc' ) ."', 'HR', '" . __('Croatian Kuna', 'wpsc') ."', '', '', '" . __('HRK', 'wpsc') . "', '0', '0','europe','1'); 
    8787INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (86, '" . __( 'Costa Rica', 'wpsc' ) ."', 'CR', '" . __('Costa Rican Colon', 'wpsc') ."', '', '', '" . __('CRC', 'wpsc') . "', '0', '0','southamerica','1'); 
    8888INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (87, '" . __( 'Cook Islands', 'wpsc' ) ."', 'CK', '" . __('New Zealand Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('NZD', 'wpsc') . "', '0', '0' ,'asiapacific','1'); 
    89 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (88, '" . __( 'Congo', 'wpsc' ) ."', 'CG', '" . __('CFA Franc BEAC', 'wpsc') ."', '', '', '" . __('XAF', 'wpsc') . "', '0', '0','africa','1'); 
     89INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (88, '" . __( 'Republic of the Congo', 'wpsc' ) ."', 'CG', '" . __('CFA Franc BEAC', 'wpsc') ."', '', '', '" . __('XAF', 'wpsc') . "', '0', '0','africa','1'); 
    9090INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (89, '" . __( 'Comoros', 'wpsc' ) ."', 'KM', '" . __('Comoros Franc', 'wpsc') ."', '', '', '" . __('KMF', 'wpsc') . "', '0', '0','africa','1'); 
    9191INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (90, '" . __( 'Colombia', 'wpsc' ) ."', 'CO', '" . __('Colombian Peso', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('COP', 'wpsc') . "', '0', '0','southamerica','1'); 
     
    121121INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (120, '" . __( 'Bahrain', 'wpsc' ) ."', 'BH', '" . __('Bahraini Dinar', 'wpsc') . "', '', '', '" . __('BHD', 'wpsc') . "', '0', '0','asiapacific','1'); 
    122122INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (121, '" . __( 'Bahamas', 'wpsc' ) ."', 'BS', '" . __('Bahamian Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('BSD', 'wpsc') . "', '0', '0','northamerica','1'); 
    123 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (122, '" . __( 'Azerbaijan', 'wpsc' ) ."', 'AZ', '" . __('Azerbaijanian Manat', 'wpsc') . "', '', '', '" . __('AZM', 'wpsc') . "', '0', '0','asiapacific','1'); 
     123INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (122, '" . __( 'Azerbaijan', 'wpsc' ) ."', 'AZ', '" . __('Azerbaijani Manat', 'wpsc') . "', '" . _x( 'm', 'azerbaijani manat symbol', 'wpsc' ) . "', '" . _x( 'm', 'azerbaijani manat symbol html', 'wpsc' ) . "', '" . __('AZN', 'wpsc') . "', '0', '0','asiapacific','1'); 
    124124INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (123, '" . __( 'Austria', 'wpsc' ) ."', 'AT', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    125 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (124, '" . __( 'Aruba', 'wpsc' ) ."', 'AW', '" . __('Aruban Guilder', 'wpsc') . "', '', '', '" . __('AWG', 'wpsc') . "', '0', '0','southamerica','1'); 
     125INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (124, '" . __( 'Aruba', 'wpsc' ) ."', 'AW', '" . __('Aruban Florin', 'wpsc') . "', '" . __( 'Afl.', 'wpsc' ) . "', '" . __( 'Afl.', 'wpsc' ) . "', '" . __('AWG', 'wpsc') . "', '0', '0','southamerica','1'); 
    126126INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (125, '" . __( 'Armenia', 'wpsc' ) ."', 'AM', '" . __('Armenian Dram', 'wpsc') . "', '', '', '" . __('AMD', 'wpsc') . "', '0', '0','asiapacific','1'); 
    127127INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (126, '" . __( 'Argentina', 'wpsc' ) ."', 'AR', '" . __('Argentine Peso', 'wpsc') . "', '', '', '" . __('ARS', 'wpsc') . "', '0', '0','southamerica','1'); 
     
    129129INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (128, '" . __( 'Antarctica', 'wpsc' ) ."', 'AQ', '" . __('Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('ATA', 'wpsc') . "', '0', '0','antarctica','1'); 
    130130INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (129, '" . __( 'Anguilla', 'wpsc' ) ."', 'AI', '" . __('East Caribbean Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('XCD', 'wpsc') . "', '0', '0','northamerica','1'); 
    131 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (130, '" . __( 'Angola', 'wpsc' ) ."', 'AO', '" . __('Angolan New Kwanza', 'wpsc') . "', '', '', '" . __('AON', 'wpsc') . "', '0', '0','africa','1'); 
     131INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (130, '" . __( 'Angola', 'wpsc' ) ."', 'AO', '" . __('Angolan Kwanza', 'wpsc') . "', '" . __( 'Kz', 'wpsc' ) . "', '" . __( 'Kz', 'wpsc' ) . "', '" . __('AOA', 'wpsc') . "', '0', '0','africa','1'); 
    132132INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (131, '" . __( 'Andorra', 'wpsc' ) ."', 'AD', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    133133INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (132, '" . __( 'American Samoa', 'wpsc' ) ."', 'AS', '" . __('US Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','asiapacific','1'); 
     
    146146INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (146, '" . __( 'Montserrat', 'wpsc' ) ."', 'MS', '" . __('East Caribbean Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('XCD', 'wpsc') . "', '0', '0','africa','1'); 
    147147INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (147, '" . __( 'Morocco', 'wpsc' ) ."', 'MA', '" . __('Moroccan Dirham', 'wpsc') . "', '', '', '" . __('MAD', 'wpsc') . "', '0', '0','africa','1'); 
    148 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (148, '" . __( 'Mozambique', 'wpsc' ) ."', 'MZ', '" . __('Mozambique Metical', 'wpsc') . "', '', '', '" . __('MZM', 'wpsc') . "', '0', '0','africa','1'); 
     148INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (148, '" . __( 'Mozambique', 'wpsc' ) ."', 'MZ', '" . __('Mozambique Metical', 'wpsc') . "', '', '', '" . __('MZN', 'wpsc') . "', '0', '0','africa','1'); 
    149149INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (149, '" . __( 'Myanmar', 'wpsc' ) ."', 'MM', '" . __('Myanmar Kyat', 'wpsc') . "', '', '', '" . __('MMK', 'wpsc') . "', '0', '0','asiapacific','1'); 
    150150INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (150, '" . __( 'Namibia', 'wpsc' ) ."', 'NA', '" . __('Namibian Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('NAD', 'wpsc') . "', '0', '0','africa','1'); 
     
    152152INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (152, '" . __( 'Nepal', 'wpsc' ) ."', 'NP', '" . __('Nepalese Rupee', 'wpsc') . "', '', '', '" . __('NPR', 'wpsc') . "', '0', '0','asiapacific','1'); 
    153153INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (153, '" . __( 'Netherlands', 'wpsc' ) ."', 'NL', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    154 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (154, '" . __( 'Netherlands Antilles', 'wpsc' ) ."', 'AN', '" . __('Netherlands Antillean Guilder', 'wpsc') . "', '', '', '" . __('ANG', 'wpsc') . "', '0', '0','africa','1'); 
     154INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (154, '" . __( 'Netherlands Antilles', 'wpsc' ) ."', 'AN', '" . __('Netherlands Antillean Guilder', 'wpsc') . "', '" . __( 'ƒ', 'wpsc' ) . "', '" . __( '&#402;', 'wpsc' ) . "', '" . __('ANG', 'wpsc') . "', '0', '0','africa','1'); 
    155155INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (155, '" . __( 'New Caledonia (French)', 'wpsc' ) ."', 'NC', '" . __('CFP Franc', 'wpsc') . "', '', '', '" . __('XPF', 'wpsc') . "', '0', '0','asiapacific','1'); 
    156156INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (156, '" . __( 'New Zealand', 'wpsc' ) ."', 'NZ', '" . __('New Zealand Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('NZD', 'wpsc') . "', '0', '12.5','asiapacific','1'); 
    157 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (157, '" . __( 'Nicaragua', 'wpsc' ) ."', 'NI', '" . __('Nicaraguan Cordoba Oro', 'wpsc') . "', '', '', '" . __('NIC', 'wpsc') . "', '0', '0','northamerica','1'); 
     157INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (157, '" . __( 'Nicaragua', 'wpsc' ) ."', 'NI', '" . __('Nicaraguan Cordoba Oro', 'wpsc') . "', '', '', '" . __('NIO', 'wpsc') . "', '0', '0','northamerica','1'); 
    158158INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (158, '" . __( 'Niger', 'wpsc' ) ."', 'NE', '" . __('CFA Franc BCEAO', 'wpsc') . "', '', '', '" . __('XOF', 'wpsc') . "', '0', '0','africa','1'); 
    159159INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (159, '" . __( 'Nigeria', 'wpsc' ) ."', 'NG', '" . __('Nigerian Naira', 'wpsc') . "', '', '', '" . __('NGN', 'wpsc') . "', '0', '0','africa','1'); 
     
    177177INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (177, '" . __( 'Qatar', 'wpsc' ) ."', 'QA', '" . __('Qatari Rial', 'wpsc') . "', '', '', '" . __('QAR', 'wpsc') . "', '0', '0','asiapacific','1'); 
    178178INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (178, '" . __( 'Reunion (French)', 'wpsc' ) ."', 'RE', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    179 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (179, '" . __( 'Romania', 'wpsc' ) ."', 'RO', '" . __('Romanian Leu', 'wpsc') . "', '', '', '" . __('RON', 'wpsc') . "', '0', '0','europe','1'); 
     179INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (179, '" . __( 'Romania', 'wpsc' ) ."', 'RO', '" . __('Romanian New Leu', 'wpsc') . "', '', '', '" . __('RON', 'wpsc') . "', '0', '0','europe','1'); 
    180180INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (180, '" . __( 'Russia', 'wpsc' ) ."', 'RU', '" . __('Russian Ruble', 'wpsc') . "', '', '', '" . __('RUB', 'wpsc') . "', '0', '0','europe','1'); 
    181181INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (181, '" . __( 'Rwanda', 'wpsc' ) ."', 'RW', '" . __('Rwanda Franc', 'wpsc') . "', '', '', '" . __('RWF', 'wpsc') . "', '0', '0','africa','1'); 
     
    186186INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (186, '" . __( 'Saint Vincent & Grenadines', 'wpsc' ) ."', 'VC', '" . __('East Caribbean Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('XCD', 'wpsc') . "', '0', '0','northamerica','1'); 
    187187INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (187, '" . __( 'Samoa', 'wpsc' ) ."', 'WS', '" . __('Samoan Tala', 'wpsc') . "', '', '', '" . __('WST', 'wpsc') . "', '0', '0','asiapacific','1'); 
    188 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (188, '" . __( 'San Marino', 'wpsc' ) ."', 'SM', '" . __('Italian Lira', 'wpsc') . "', '', '', '" . __('ITL', 'wpsc') . "', '0', '0','europe','1'); 
     188INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (188, '" . __( 'San Marino', 'wpsc' ) ."', 'SM', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    189189INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (189, '" . __( 'Sao Tome and Principe', 'wpsc' ) ."', 'ST', '" . __('Dobra', 'wpsc') . "', '', '', '" . __('STD', 'wpsc') . "', '0', '0','africa','1'); 
    190190INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (190, '" . __( 'Saudi Arabia', 'wpsc' ) ."', 'SA', '" . __('Saudi Riyal', 'wpsc') . "', '', '', '" . __('SAR', 'wpsc') . "', '0', '0','asiapacific','1'); 
     
    196196INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (196, '" . __( 'Slovenia', 'wpsc' ) ."', 'SI', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    197197INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (197, '" . __( 'Solomon Islands', 'wpsc' ) ."', 'SB', '" . __('Solomon Islands Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', 'SBD', '0', '0','asiapacific','1'); 
    198 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (198, '" . __( 'Somalia', 'wpsc' ) ."', 'SO', '" . __('Somali Shilling', 'wpsc') . "', '', '', '" . __('SOD', 'wpsc') . "', '0', '0','africa','1'); 
     198INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (198, '" . __( 'Somalia', 'wpsc' ) ."', 'SO', '" . __('Somali Shilling', 'wpsc') . "', '', '', '" . __('SOS', 'wpsc') . "', '0', '0','africa','1'); 
    199199INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (199, '" . __( 'South Africa', 'wpsc' ) ."', 'ZA', '" . __('South African Rand', 'wpsc') . "', '', '', '" . __('ZAR', 'wpsc') . "', '0', '0','africa','1'); 
    200200INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (200, '" . __( 'South Georgia & South Sandwich Islands', 'wpsc' ) ."', 'GS', '" . __('Pound Sterling', 'wpsc') . "', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '0','southamerica','1'); 
     
    202202INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (202, '" . __( 'Sri Lanka', 'wpsc' ) ."', 'LK', '" . __('Sri Lanka Rupee', 'wpsc') . "', '', '', '" . __('LKR', 'wpsc') . "', '0', '0','asiapacific','1'); 
    203203INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (203, '" . __( 'Sudan', 'wpsc' ) ."', 'SD', '" . __('Sudanese Pound', 'wpsc') . "', '', '', '" . __('SDG', 'wpsc') . "', '0', '0','africa','1'); 
    204 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (242, '" . __( 'South Sudan', 'wpsc' ) ."', 'SS', '" . __('South Sudanese Pound', 'wpsc') . "', '', '', '" . __('SSP', 'wpsc') . "', '0', '0','africa','1'); 
    205 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (204, '" . __( 'Suriname', 'wpsc' ) ."', 'SR', '" . __('Surinam Guilder', 'wpsc') . "', '', '', '" . __('SRG', 'wpsc') . "', '0', '0','southamerica','1'); 
     204INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (204, '" . __( 'Suriname', 'wpsc' ) ."', 'SR', '" . __('Surinamese Dollar', 'wpsc') . "', '', '', '" . __('SRD', 'wpsc') . "', '0', '0','southamerica','1'); 
    206205INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (205, '" . __( 'Svalbard and Jan Mayen Islands', 'wpsc' ) ."', 'SJ', '" . __('Norwegian Krone', 'wpsc') . "', '', '', '" . __('NOK', 'wpsc') . "', '0', '0','','1'); 
    207206INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (206, '" . __( 'Swaziland', 'wpsc' ) ."', 'SZ', '" . __('Swaziland Lilangeni', 'wpsc') . "', '', '', '" . __('SZL', 'wpsc') . "', '0', '0','africa','1'); 
     
    209208INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (208, '" . __( 'Switzerland', 'wpsc' ) ."', 'CH', '" . __('Swiss Franc', 'wpsc') . "', '', '', '" . __('CHF', 'wpsc') . "', '0', '0','europe','1'); 
    210209INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (209, '" . __( 'Syria', 'wpsc' ) ."', 'SY', '" . __('Syrian Pound', 'wpsc') . "', '', '', '" . __('SYP', 'wpsc') . "', '0', '0','europe','1'); 
    211 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (210, '" . __( 'Taiwan', 'wpsc' ) ."', 'TW', '" . __('Taiwan Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('TWD', 'wpsc') . "', '0', '0','asiapacific','1'); 
    212 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (211, '" . __( 'Tajikistan', 'wpsc' ) ."', 'TJ', '" . __('Tajik Ruble', 'wpsc') . "', '', '', '" . __('TJR', 'wpsc') . "', '0', '0','asiapacific','1'); 
     210INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (210, '" . __( 'Taiwan', 'wpsc' ) ."', 'TW', '" . __('New Taiwan Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('TWD', 'wpsc') . "', '0', '0','asiapacific','1'); 
     211INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (211, '" . __( 'Tajikistan', 'wpsc' ) ."', 'TJ', '" . __('Tajik Somoni', 'wpsc') . "', '', '', '" . __('TJS', 'wpsc') . "', '0', '0','asiapacific','1'); 
    213212INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (212, '" . __( 'Tanzania', 'wpsc' ) ."', 'TZ', '" . __('Tanzanian Shilling', 'wpsc') . "', '', '', '" . __('TZS', 'wpsc') . "', '0', '0','africa','1'); 
    214213INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (213, '" . __( 'Thailand', 'wpsc' ) ."', 'TH', '" . __('Thai Baht', 'wpsc') . "', '', '', '" . __('THB', 'wpsc') . "', '0', '0','asiapacific','1'); 
     
    217216INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (216, '" . __( 'Tonga', 'wpsc' ) ."', 'TO', '" . __('Tongan Pa&#699;anga', 'wpsc') . "', '', '', '" . __('TOP', 'wpsc') . "', '0', '0','asiapacific','1'); 
    218217INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (217, '" . __( 'Trinidad and Tobago', 'wpsc' ) ."', 'TT', '" . __('Trinidad and Tobago Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('TTD', 'wpsc') . "', '0', '0','africa','1'); 
    219 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (218, '" . __( 'Tunisia', 'wpsc' ) ."', 'TN', '" . __('Tunisian Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('TND', 'wpsc') . "', '0', '0','africa','1'); 
    220 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (219, '" . __( 'Turkey', 'wpsc' ) ."', 'TR', '" . __('Turkish Lira', 'wpsc') . "', '', '', '" . __('TRL', 'wpsc') . "', '0', '0','asiapacific','1'); 
     218INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (218, '" . __( 'Tunisia', 'wpsc' ) ."', 'TN', '" . __('Tunisian Dinar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('TND', 'wpsc') . "', '0', '0','africa','1'); 
     219INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (219, '" . __( 'Turkey', 'wpsc' ) ."', 'TR', '" . __('Turkish Lira', 'wpsc') . "', '', '', '" . __('TRY', 'wpsc') . "', '0', '0','asiapacific','1'); 
    221220INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (220, '" . __( 'Turkmenistan', 'wpsc' ) ."', 'TM', '" . __('Manat', 'wpsc') . "', '', '', '" . __('TMM', 'wpsc') . "', '0', '0','asiapacific','1'); 
    222221INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (221, '" . __( 'Turks and Caicos Islands', 'wpsc' ) ."', 'TC', '" . __('US Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0', 'northamerica','1'); 
    223222INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (222, '" . __( 'Tuvalu', 'wpsc' ) ."', 'TV', '" . __('Australian Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('AUD', 'wpsc') . "', '0', '0','asiapacific','1'); 
    224 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (223, '" . __( 'U.K.', 'wpsc' ) ."', 'UK', '" . __('Pound Sterling', 'wpsc') . "', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '17.5','europe','1'); 
    225 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (224, '" . __( 'Uganda', 'wpsc' ) ."', 'UG', '" . __('Uganda Shilling', 'wpsc') . "', '', '', '" . __('UGS', 'wpsc') . "', '0', '0','africa','1'); 
     223INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (223, '" . __( 'United Kingdom', 'wpsc' ) ."', 'GB', '" . __('Pound Sterling', 'wpsc') . "', '" . __('£', 'wpsc') . "', '" . __('&#163;', 'wpsc') . "', '" . __('GBP', 'wpsc') . "', '0', '17.5','europe','1'); 
     224INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (224, '" . __( 'Uganda', 'wpsc' ) ."', 'UG', '" . __('Uganda Shilling', 'wpsc') . "', '', '', '" . __('UGX', 'wpsc') . "', '0', '0','africa','1'); 
    226225INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (225, '" . __( 'Ukraine', 'wpsc' ) ."', 'UA', '" . __('Ukraine Hryvnia', 'wpsc') . "', '". __( '₴', 'wpsc' )."', '". __( '&#8372;', 'wpsc' ) ."', '" . __('UAH', 'wpsc') . "', '0', '0','europe','1'); 
    227226INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (226, '" . __( 'United Arab Emirates', 'wpsc' ) ."', 'AE', '" . __('Arab Emirates Dirham', 'wpsc') . "', '', '', '" . __('AED', 'wpsc') . "', '0', '0','asiapacific','1'); 
    228 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (227, '" . __( 'Uruguay', 'wpsc' ) ."', 'UY', '" . __( 'Uruguayan Peso', 'wpsc' ) . "', '', '', '" . __('UYP', 'wpsc') . "', '0', '0','southamerica','1'); 
     227INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (227, '" . __( 'Uruguay', 'wpsc' ) ."', 'UY', '" . __( 'Uruguayan Peso', 'wpsc' ) . "', '', '', '" . __('UYU', 'wpsc') . "', '0', '0','southamerica','1'); 
    229228INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (228, '" . __( 'USA Minor Outlying Islands', 'wpsc' ) ."', 'UM', '" . __('US Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','','1'); 
    230229INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (229, '" . __( 'Uzbekistan', 'wpsc' ) ."', 'UZ', '" . __('Uzbekistan Sum', 'wpsc') . "', '', '', '" . __('UZS', 'wpsc') . "', '0', '0','asiapacific','1'); 
    231230INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (230, '" . __( 'Vanuatu', 'wpsc' ) ."', 'VU', '" . __('Vanuatu Vatu', 'wpsc') . "', '', '', '" . __('VUV', 'wpsc') . "', '0', '0','asiapacific','1'); 
    232231INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (231, '" . __( 'Vatican', 'wpsc' ) ."', 'VA', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
    233 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (232, '" . __( 'Venezuela', 'wpsc' ) ."', 'VE', '" . __('Venezuelan Bolivar', 'wpsc') . "', '', '', '" . __('VUB', 'wpsc') . "', '0', '0','asiapacific','1'); 
     232INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (232, '" . __( 'Venezuela', 'wpsc' ) ."', 'VE', '" . __('Venezuelan Bolivar Fuerte', 'wpsc') . "', '', '', '" . __('VEF', 'wpsc') . "', '0', '0','asiapacific','1'); 
    234233INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (233, '" . __( 'Vietnam', 'wpsc' ) ."', 'VN', '" . __('Vietnamese Dong', 'wpsc') . "', '', '', '" . __('VND', 'wpsc') . "', '0', '0','asiapacific','1'); 
    235234INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (234, '" . __( 'Virgin Islands (British)', 'wpsc' ) ."', 'VG', '" . __('US Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','northamerica','1'); 
     
    238237INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (237, '" . __( 'Western Sahara', 'wpsc' ) ."', 'EH', '" . __('Moroccan Dirham', 'wpsc') . "', '', '', '" . __('MAD', 'wpsc') . "', '0', '0','africa','1'); 
    239238INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (238, '" . __( 'Yemen', 'wpsc' ) ."', 'YE', '" . __('Yemeni Rial', 'wpsc') . "', '', '', '" . __('YER', 'wpsc') . "', '0', '0','asiapacific','1'); 
    240 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (239, '" . __( 'Yugoslavia', 'wpsc' ) ."', 'YU', '" . __('Yugoslav New Dinar', 'wpsc') . "', '', '', '" . __('YUN', 'wpsc') . "', '0', '0','europe','1'); 
    241239INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (240, '" . __( 'Zambia', 'wpsc' ) ."', 'ZM', '" . __('Zambian Kwacha', 'wpsc') . "', '', '', '" . __('ZMK', 'wpsc') . "', '0', '0','africa','1'); 
    242 INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (241, '" . __( 'Zimbabwe', 'wpsc' ) ."', 'ZW', '" . __('Zimbabwe Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('ZWD', 'wpsc') . "', '0', '0','africa','1');"; ?> 
     240INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (241, '" . __( 'Zimbabwe', 'wpsc' ) ."', 'ZW', '" . __('US Dollar', 'wpsc') . "', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','africa','1'); 
     241INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (242, '" . __( 'South Sudan', 'wpsc' ) . "', 'SS', '" . __( 'South Sudanese Pound', 'wpsc' ) . "', '', '', '" . __( 'SSP', 'wpsc' ) . "', '0', '0', 'africa', '1'); 
     242INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (243, '" . __( 'Serbia', 'wpsc' ) ."', 'RS', '" . __('Serbian Dinar', 'wpsc') . "', '', '', '" . __('RSD', 'wpsc') . "', '0', '0','europe','1'); 
     243INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (244, '" . __( 'Montenegro', 'wpsc' ) ."', 'ME', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
     244INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (246, '" . __( 'Aland Islands', 'wpsc' ) ."', 'AX', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
     245INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (247, '" . __( 'Saint Barthelemy', 'wpsc' ) ."', 'BL', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','europe','1'); 
     246INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (248, '" . __( 'Bonaire, Sint Eustatius and Saba', 'wpsc' ) ."', 'BQ', '" . __('US Dollar', 'wpsc') ."', '" . __('$', 'wpsc') . "', '" . __('&#036;', 'wpsc') . "', '" . __('USD', 'wpsc') . "', '0', '0','southamerica','1'); 
     247INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (249, '" . __( 'Curacao', 'wpsc' ) . "', 'CW', '" . __( 'Netherlands Antillean Guilder', 'wpsc' ) . "', '" . __( 'ƒ', 'wpsc' ) . "', '" . __( '&#402;', 'wpsc' ) . "', '" . __( 'ANG', 'wpsc' ) . "', '0', '0', 'southamerica', '1'); 
     248INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (250, '" . __( 'Saint Martin (French Part)', 'wpsc' ) ."', 'MF', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','southamerica','1'); 
     249INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (251, '" . __( 'Palestinian Territories', 'wpsc' ) ."', 'PS', '" . __('Israeli New Shekel', 'wpsc') ."', '" . __( '₪', 'wpsc' ) . "', '" . __( '&#8362;', 'wpsc' ) . "', '" . __('ILS', 'wpsc') . "', '0', '0',  'asiapacific','1'); 
     250INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (252, '" . __( 'Sint Maarten (Dutch Part)', 'wpsc' ) ."', 'SX', '" . __('Netherlands Antillean Guilder', 'wpsc') . "', '" . __( 'ƒ', 'wpsc' ) . "', '" . __( '&#402;', 'wpsc' ) . "', '" . __('ANG', 'wpsc') . "', '0', '0','africa','1'); 
     251INSERT INTO `".WPSC_TABLE_CURRENCY_LIST."` VALUES (253, '" . __( 'French Guiana', 'wpsc' ) ."', 'GF', '" . __('Euro', 'wpsc') . "', '" . __('€', 'wpsc') . "', '" . __('&#8364;', 'wpsc') . "', '" . __('EUR', 'wpsc') . "', '0', '0','southamerica','1');"; 
Note: See TracChangeset for help on using the changeset viewer.