PHP cw_csvxc_is_table_exists Beispiele

Beispiel #1

Datei: tmp_tables_load.php Projekt: CartworksPlatform/cartworksplatform

            }
            $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');
}

Beispiel #2

Datei: func.import.csvxcart.php Projekt: CartworksPlatform/cartworksplatform

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}`");
    }
}