Jump to content

erik1432

Members
  • Content count

    4
  • Joined

  • Last visited

  1. erik1432

    Add More Fields

    Dear Jack, I got the contribution working now for couple of days. Seems to work verry good! Thank you for that. I found only one problem when deleting extra fields. When i deleted two fields the easypopulate.php file seems to be not correct. ----------------------------------------------------------------------------------------------------------------------- $custom_fields[TABLE_PRODUCTS] = array(,,'Verzendkosten' => 'Verzendkosten','Levertijd' => 'Levertijd','gtin' => 'gtin'); // this line is used if you have no custom fields to import/export $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export ------------------------------------------------------------------------------------------------------------------------- When i deleted the two ,, before 'verzendkosten' everything is working again. I don't know a lot about php but i thought maybe this will help out others. Thanks again.
  2. erik1432

    Add More Fields

    Dear Jack, Is this contribution working with your other contribution 'Header Tags SEO' ? Some pieces of the code that needs to be replaced are already been replaced with Header Tags SEO code. For example: FIND (around line 283): 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id])); ADD BENEATH: /**** Begin Add More Fields ****/ $addedFieldsArray = GetAddedProductFields($_GET['pID'], $_GET['cPath']); if (count($addedFieldsArray) > 0) { foreach ($addedFieldsArray as $fields) { if ($fields['table_name'] == TABLE_PRODUCTS_DESCRIPTION) { $addedFields = array($fields['field_name'] => tep_db_prepare_input($_POST[$fields['field_name']][$language_id])); $sql_data_array = array_merge($sql_data_array, $addedFields); } } } /**** End Add More Fields ****/ My piece of the code looks like this: $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $language_id = $languages[$i]['id']; /*** Begin Header Tags SEO ***/ $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), 'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]), 'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_title_tag'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))), 'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id])))); /*** End Header Tags SEO ***/ if ($action == 'insert_product') { $insert_sql_data = array('products_id' => $products_id, 'language_id' => $language_id); As you can see this piece of code is already replaced by your other contribution. The next step in your install file is the same story: FIND (around line 332): } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); $description_query = tep_db_query("select language_id, products_name, products_description, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0')"); } If i replace this piece of code the code that has been already replaced by Header Tags SEO will be lost. Can you please check and let me know how to proceed ? Thanks!
  3. erik1432

    Add More Fields

    Thanks Jack for all the cool addons you make for oscommerce! I use Header Tags SEO and Google XML SEO and they are both working perfectly. I do not know much about PHP but with your very clear install instructions it always worked out. The 'add more fields' addon that your working on sounds great. I already tried to install another extra field contribution but that seems to be not working with your Header Tags SEO contribution. Some pieces of the code that i need to replace are already replaced with your contribution. Do you have a estimate timeline when the install instructions will be ready ? Thanks again and please keep up the good work! I think there will be much Oscommerce shops that are using your contributions.
  4. Hi Same problem here. Only thing is that i am already stuck on step 15b With this step there is also a piece of code to be replaced that is already been used by Header Tag SEO Hope that there is some one that can help with our problem :)
×