Hallo liebe Community,
ich bräuchte Eure Hilfe… Ich habe bis jetzt Versand nur innerhalb DE angeboten (4,90 € für Bestellwert bis 70 €, sonst kostenlos). Ich habe dafür „Pauschale Versandkosten“ genutzt und alles was wunderbar…
Jetzt wollte ich es auf EU erweitern:
- DE nach wie vor 4,90 € bis 70 € Bestellwert, danach kostenlos
- Andere EU Länder 9,90 € bis 70 € Bestellwert, danach kostenlos
Ich habe mich deswegen für die „Tabellarische Versandkosten“ entschieden (richtig, oder?
). Dafür brav habe ich ein Versandmodul kopiert (laut
Tutorial: Kopieren eines Versandmoduls), die Preise eingetragen und … ich bekomme folgende Meldung:
1146 - Table 'usr_web22_1.TABLE2_ZONES_TO_GEO_ZONES' doesn't exist
select zone_id from TABLE2_ZONES_TO_GEO_ZONES where geo_zone_id = '6' and zone_country_id = '' order by zone_id
[XT SQL Error]
Ich habe bereits Info über ähnlichen Problem gefunden - Versandkosten wie richtig?
http://www.modified-shop.org/forum/index.php?topic=6815.msg68306;topicseen#msg68306, aber es hilft mir nicht so wirklich weiter.
Weißt Ihr was da falsch sein könnte?
class table2
{ var $code, $title, $description, $icon, $enabled; function table2
() { global $order; $this->code = 'table2'; $this->title = MODULE_SHIPPING_TABLE2_TEXT_TITLE
; $this->description = MODULE_SHIPPING_TABLE2_TEXT_DESCRIPTION
; $this->sort_order = MODULE_SHIPPING_TABLE2_SORT_ORDER
; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_TABLE2_TAX_CLASS
; $this->enabled = ((MODULE_SHIPPING_TABLE2_STATUS
== 'True') ?
true : false); if ( ($this->enabled == true) && ((int
)MODULE_SHIPPING_TABLE2_ZONE
> 0) ) { $check_flag = false; $check_query = xtc_db_query
("select zone_id from " . TABLE2_ZONES_TO_GEO_ZONES
. " where geo_zone_id = '" . MODULE_SHIPPING_TABLE2_ZONE
. "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = xtc_db_fetch_array
($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } function quote
($method = '') { global $order, $shipping_weight, $shipping_num_boxes,$xtPrice; if (MODULE_SHIPPING_TABLE2_MODE
== 'price') { $order_total = $xtPrice->xtcRemoveCurr($_SESSION['cart']->show_total()); } else { $order_total = $shipping_weight; } $table2_cost = preg_split("/[:,]/" , MODULE_SHIPPING_TABLE2_COST
); // Hetfield - 2009-08-18 - replaced deprecated function split with preg_split to be ready for PHP >= 5.3 $size = sizeof($table2_cost); for ($i=0, $n=$size; $i<$n; $i+=2) { if ($order_total <= $table2_cost[$i]) { $shipping = $table2_cost[$i+1]; break; } } if (MODULE_SHIPPING_TABLE2_MODE
== 'weight') { $shipping = $shipping * $shipping_num_boxes; } $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_TABLE2_TEXT_TITLE
, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_TABLE2_TEXT_WAY
, 'cost' => $shipping + MODULE_SHIPPING_TABLE2_HANDLING
))); if ($this->tax_class > 0) { $this->quotes['tax'] = xtc_get_tax_rate
($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (xtc_not_null
($this->icon)) $this->quotes['icon'] = xtc_image
($this->icon, $this->title); return $this->quotes; } function check
() { if (!isset($this->_check
)) { $check_query = xtc_db_query
("select configuration_value from " . TABLE_CONFIGURATION
. " where configuration_key = 'MODULE_SHIPPING_TABLE2_STATUS'"); $this->_check
= xtc_db_num_rows
($check_query); } return $this->_check
; } function install
() { xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) VALUES ('MODULE_SHIPPING_TABLE2_STATUS', 'True', '6', '0', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_ALLOWED', '', '6', '0', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_COST', '25:8.50,50:5.50,10000:0.00', '6', '0', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_MODE', 'weight', '6', '0', 'xtc_cfg_select_option(array(\'weight\', \'price\'), ', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_HANDLING', '0', '6', '0', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_TAX_CLASS', '0', '6', '0', 'xtc_get_tax_class_title', 'xtc_cfg_pull_down_tax_classes(', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_SHIPPING_TABLE2_ZONE', '0', '6', '0', 'xtc_get_zone_class_title', 'xtc_cfg_pull_down_zone_classes(', now())"); xtc_db_query
("insert into " . TABLE_CONFIGURATION
. " (configuration_key, configuration_value, configuration_group_id, sort_order, date_added) values ('MODULE_SHIPPING_TABLE2_SORT_ORDER', '0', '6', '0', now())"); } function remove
() { xtc_db_query
("delete from " . TABLE_CONFIGURATION
. " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys
() { return array('MODULE_SHIPPING_TABLE2_STATUS', 'MODULE_SHIPPING_TABLE2_COST', 'MODULE_SHIPPING_TABLE2_MODE', 'MODULE_SHIPPING_TABLE2_HANDLING','MODULE_SHIPPING_TABLE2_ALLOWED', 'MODULE_SHIPPING_TABLE2_TAX_CLASS', 'MODULE_SHIPPING_TABLE2_ZONE', 'MODULE_SHIPPING_TABLE2_SORT_ORDER'); } }?> Sonnige Grüße,
Meli
Linkback: https://www.modified-shop.org/forum/index.php?topic=15362.0