Hi Peter,
für eine Anleitung wären wir dir alle bestimmt sehr dankbar, besonders ich
Gruß
Ronny
für eine Anleitung wären wir dir alle bestimmt sehr dankbar, besonders ich
Gruß
Ronny
ALTER TABLE `shop1_categories`ADD `categories_status1` TINYINT NOT NULL DEFAULT '0' AFTER `categories_status`
ALTER TABLE `shop1_products`ADD `products_status1` TINYINT NOT NULL DEFAULT '0' AFTER `products_status`
CREATE VIEW shop2_categories1 AS SELECT categories_id, categories_image, parent_id, sort_order, date_added, last_modified, categories_status1 AS categories_status FROM shop1_categories
CREATE VIEW shop2_products1 AS SELECT products_id, products_type, products_quantity, products_model, products_image, products_price,products_virtual, products_date_added, Products_last_modified,products_date_available, Products_weight, products_status1 AS products_status,products_tax_class_id, manufacturers_id, products_ordered,products_quantity_order_min, products_quantity_order_units,products_priced_by_attribute, product_is_free, product_is_call,products_quantity_mixed, product_is_always_free_shipping,products_qty_box_status, products_quantity_order_max, products_sort_order,products_discount_type , products_discount_type_from, products_price_sorter,master_categories_id, products_mixed_discount_quantity, metatags_title_status,metatags_products_name_status, metatags_model_status, metatags_price_status, metatags_title_tagline_statusFROM shop1_products
define('DB_PREFIX', 'shop2_');
define('DB_PREFIX', 'shop2_'); [COLOR=red]define('DB_PREFIX1', 'shop1_');[/COLOR]
if (!defined('DB_PREFIX')) define('DB_PREFIX', '');
if (!defined('DB_PREFIX')) define('DB_PREFIX', ''); [COLOR=red]if (!defined('DB_PREFIX1')) define('DB_PREFIX1', '');[/COLOR]
define('TABLE_CATEGORIES', DB_PREFIX . 'categories'); define('TABLE_CATEGORIES_DESCRIPTION', DB_PREFIX . 'categories_description');
define('TABLE_CATEGORIES', DB_PREFIX . [COLOR=red]'categories1'[/COLOR]); define('TABLE_CATEGORIES_DESCRIPTION', [COLOR=red]DB_PREFIX1[/COLOR] . 'categories_description');
define('TABLE_PRODUCTS', DB_PREFIX . 'products'); define('TABLE_PRODUCT_TYPES', DB_PREFIX . 'product_types'); define('TABLE_PRODUCT_TYPE_LAYOUT', DB_PREFIX . 'product_type_layout'); define('TABLE_PRODUCT_TYPE_LAYOUT_LANGUAGE', DB_PREFIX . 'product_type_layout_language'); define('TABLE_PRODUCT_TYPES_TO_CATEGORY', DB_PREFIX . 'product_types_to_category'); define('TABLE_PRODUCTS_ATTRIBUTES', DB_PREFIX . 'products_attributes'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', DB_PREFIX . 'products_attributes_download'); define('TABLE_PRODUCTS_DESCRIPTION', DB_PREFIX . 'products_description'); define('TABLE_PRODUCTS_DISCOUNT_QUANTITY', DB_PREFIX . 'products_discount_quantity'); define('TABLE_PRODUCTS_NOTIFICATIONS', DB_PREFIX . 'products_notifications'); define('TABLE_PRODUCTS_OPTIONS', DB_PREFIX . 'products_options'); define('TABLE_PRODUCTS_OPTIONS_VALUES', DB_PREFIX . 'products_options_values'); define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', DB_PREFIX . 'products_options_values_to_products_options'); define('TABLE_PRODUCTS_OPTIONS_TYPES', DB_PREFIX . 'products_options_types'); define('TABLE_PRODUCTS_TO_CATEGORIES', DB_PREFIX . 'products_to_categories');
define('TABLE_PRODUCTS', DB_PREFIX . [COLOR=red]'products1'[/COLOR]); define('TABLE_PRODUCT_TYPES', [COLOR=red]DB_PREFIX1[/COLOR] . 'product_types'); define('TABLE_PRODUCT_TYPE_LAYOUT', [COLOR=red]DB_PREFIX1[/COLOR] . 'product_type_layout'); define('TABLE_PRODUCT_TYPE_LAYOUT_LANGUAGE', [COLOR=red]DB_PREFIX1[/COLOR] . 'product_type_layout_language'); define('TABLE_PRODUCT_TYPES_TO_CATEGORY', [COLOR=red]DB_PREFIX1[/COLOR] . 'product_types_to_category'); define('TABLE_PRODUCTS_ATTRIBUTES', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_attributes'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_attributes_download'); define('TABLE_PRODUCTS_DESCRIPTION', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_description'); define('TABLE_PRODUCTS_DISCOUNT_QUANTITY', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_discount_quantity'); define('TABLE_PRODUCTS_NOTIFICATIONS', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_notifications'); define('TABLE_PRODUCTS_OPTIONS', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_options'); define('TABLE_PRODUCTS_OPTIONS_VALUES', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_options_values'); define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS',[COLOR=red]DB_PREFIX1[/COLOR] . 'products_options_values_to_products_options'); define('TABLE_PRODUCTS_OPTIONS_TYPES', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_options_types'); define('TABLE_PRODUCTS_TO_CATEGORIES', [COLOR=red]DB_PREFIX1[/COLOR] . 'products_to_categories');
<?php
$template_dir = "free_blue";
define('SITE_NAME','site1');
?>
<?php
$template_dir = "vienabright";
define('SITE_NAME','site2');
?>
Kommentar