} $attr_info = cw_query_first("SELECT * FROM cw_attributes WHERE field='{$ef_colname}' AND item_type='P' AND addon in ('', 'custom_saratogawine_magazines','custom_saratogawine_backorder', 'clean_urls')"); $attr_id = $attr_info['attribute_id']; if ($attr_id) { if ($attr_info['type'] == 'selectbox') { $id_ef_colname = $ef_colname . "_id"; cw_csvxc_logged_query("ALTER TABLE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES ADD COLUMN `{$id_ef_colname}` int(11) NOT NULL DEFAULT 0"); cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_default cad SET tlpefv.`{$id_ef_colname}`=cad.attribute_value_id WHERE cad.attribute_id='{$attr_id}' AND cad.value=tlpefv.`{$ef_colname}`"); cw_csvxc_logged_query("INSERT INTO cw_attributes_default (value, attribute_id, active, facet) SELECT distinct(`{$ef_colname}`), {$attr_id}, 1, {$attr_info['facet']} FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE `{$id_ef_colname}`=0"); cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_default cad SET tlpefv.`{$id_ef_colname}`=cad.attribute_value_id WHERE cad.attribute_id='{$attr_id}' AND cad.value=tlpefv.`{$ef_colname}` AND tlpefv.`{$id_ef_colname}`=0"); cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_values cav SET tlpefv.ref_is_new=0 WHERE tlpefv.PRODUCTID=cav.item_id AND cav.attribute_id='{$attr_id}' AND cav.item_type='P'", "{$ef_colname} "); cw_csvxc_logged_query("UPDATE cw_attributes_values cav, tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv SET cav.value=tlpefv.`{$id_ef_colname}` WHERE tlpefv.ref_is_new=0 AND tlpefv.PRODUCTID=cav.item_id AND cav.item_type='P' AND cav.attribute_id='{$attr_id}'", ' '); cw_csvxc_logged_query("INSERT INTO cw_attributes_values (item_id, attribute_id, value, code, item_type) SELECT PRODUCTID, {$attr_id}, `{$id_ef_colname}`, 'EN', 'P' FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE ref_is_new=1", ' '); } else { cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_values cav SET tlpefv.ref_is_new=0 WHERE tlpefv.PRODUCTID=cav.item_id AND cav.attribute_id='{$attr_id}' AND cav.item_type='P'", "{$ef_colname} "); cw_csvxc_logged_query("UPDATE cw_attributes_values cav, tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv SET cav.value=tlpefv.`{$ef_colname}` WHERE tlpefv.ref_is_new=0 AND tlpefv.PRODUCTID=cav.item_id AND cav.item_type='P' AND cav.attribute_id='{$attr_id}'", ' '); cw_csvxc_logged_query("INSERT INTO cw_attributes_values (item_id, attribute_id, value, code, item_type) SELECT PRODUCTID, {$attr_id}, `{$ef_colname}`, 'EN', 'P' FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE ref_is_new=1", ' '); } cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES SET ref_is_new=1", ' '); } } } } if (cw_csvxc_is_table_exists('tmp_load_DETAILED_IMAGES') && $csvxc_allowed_sections['tmp_load_DETAILED_IMAGES']) { cw_csvxc_set_col_exist_flag('tmp_load_DETAILED_IMAGES'); cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://www.thestainlesssteelstore.com/images','')"); cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://www.justaddressplaques.com/images','')"); cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://eplanters.com/images', '')"); cw_csvxc_delete_old_images("SELECT cw_products_detailed_images.image_path AS img_full_path, cw_products_detailed_images.id AS img_key_fld FROM cw_products_detailed_images, tmp_load_PRODUCTS WHERE tmp_load_PRODUCTS.PRODUCTID=cw_products_detailed_images.id AND tmp_load_PRODUCTS.PRODUCT!=''", 'products_detailed_images'); cw_csvxc_transfer_import_images('tmp_load_DETAILED_IMAGES', 'IMAGE', 'PRODUCTID'); }
function cw_csvxc_restoretable($tabname) { if (cw_csvxc_is_table_exists("csvxcbak_{$tabname}")) { cw_csvxc_logged_query("DELETE FROM `{$tabname}`"); cw_csvxc_logged_query("INSERT INTO `{$tabname}` SELECT * FROM `csvxcbak_{$tabname}`"); cw_csvxc_logged_query("DROP TABLE IF EXISTS `csvxcbak_{$tabname}`"); } }