Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Now Available: Extra Product Fields 2.3


wdepot

Recommended Posts

  • 2 weeks later...

Hi All,

 

I woner if you guys could help with install, how do i merge the

 

 

In the install doc, 15i catalog/admin/categories.php

// description copy modified to work with Extra Product Fields

           $description_query = tep_db_query("select * from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id 

= '" . (int)$products_id . "'");

           while ($description = tep_db_fetch_array($description_query)) {

             $description['products_id'] = $dup_products_id;

             $description['products_viewed'] = 0;

             tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $description);

           }

// end Extra Product Fields

 

With .....

My catalog/admin/categories.php looks like

  $description_query = tep_db_query ("select language_id, 
                                                      products_name, 
                                                      products_description, 
                                                      products_url, 
                                                      products_tab_1, 
                                                      products_tab_2, 
                                                      products_tab_3, 
                                                      products_tab_4, 
                                                      products_tab_5, 
                                                      products_tab_6 
                                             from " . TABLE_PRODUCTS_DESCRIPTION . " 
                                             where products_id = '" . (int) $products_id . "'
                                           ");
           while ($description = tep_db_fetch_array ($description_query) ) {
// Products Specifications
             tep_db_query ("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6, 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']) . "', '" . tep_db_input ($description['products_tab_1']) . "', '" . tep_db_input ($description['products_tab_2']) . "', '" . tep_db_input ($description['products_tab_3']) . "', '" . tep_db_input ($description['products_tab_4']) . "', '" . tep_db_input ($description['products_tab_5']) . "', '" . tep_db_input ($description['products_tab_6']) . "', '0')");
           }

           tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')");

// Start Products Specifications
           $specifications_query = tep_db_query ("select specifications_id, 
                                                         language_id, 
                                                         specification 
                                                  from " . TABLE_PRODUCTS_SPECIFICATIONS . " 
                                                  where products_id = '" . (int)$products_id . "'
                                                ");
           while ($specifications = tep_db_fetch_array ($specifications_query) ) {
             tep_db_query ("insert into " . TABLE_PRODUCTS_SPECIFICATIONS . " (
                                        products_id,
                                        specifications_id, 
                                        language_id, 
                                        specification) values (
                                        '" . (int) $dup_products_id . "', 
                                        '" . (int) $specifications['specification_description_id'] . "', 
                                        '" . (int)$specifications['language_id'] . "', 
                                        '" . tep_db_input ($specifications['specification']) . "')
                          ");
           } // while ($specifications
// End Products Specifications

 

This is a merge of the extra fields contrib and the product spec contrib.

Any help welcome!!!!

 

 

Simon

Link to comment
Share on other sites

Hi, I have installed epf 2.13 and everything functions correctly however, I am getting the following errors in my log.

 

Thanks

 

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

 

Date / Time: 18-12-2010 12:24:58

Error Type: [E_NOTICE] Undefined variable: epf

On line 193

File index.php

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

 

Date / Time: 18-12-2010 12:24:58

Error Type: [E_WARNING] Invalid argument supplied for foreach()

On line 193

File index.php

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

192 $restrict_by = '';

193 foreach ($epf as $e) {

194 if ($e['restrict']) {

195 if (isset($_GET[$e['field']]) && is_numeric($_GET[$e['field']])) {

196 $restrict_by .= ' and (pd.' . $e['field'] . ' in (' . (int)$_GET[$e['field']] .

197 tep_list_epf_children($_GET[$e['field']]) . '))';

}

Link to comment
Share on other sites

  • 3 months later...
  • 1 month later...
  • 8 months later...

Hi all,

 

i installed Extra Product Fields v3_01 on a new installation ( oscommerce 2.2 ) but I got the next ERROR : "Fatal error: Call to undefined function epf_build_ptype_pulldown() in /shop/admin/extra_fields.php on line 26" . I check the installation again but cant find the reason.

Thanks for helping me fixing this error.

Link to comment
Share on other sites

i start all over again with Extra Product Fields v2_31 that works well except when clicking on a result of a search I got ; Product not found!

i check the code but cant find the reason.

Then I make the upgrade to 3_01 which is working except the same search result error.

Link to comment
Share on other sites

1/ when i search on a word without using the Text category and the Text Manufacturer I get results but when clicking a result the product_info.php says Product Not Found!

 

 

2/ when i search on a word using the Text category box I get results but when clicking a result the product_info.php says Product Not Found!

 

 

3/ when i search on a word using the Text Manufacturer box I get results and when clicking a result the product_info.php says displays the product.

4/ I have the same problem in Advanced Search Results

So ONLY when I choose a Manufacturer i got results that could be found.

Link to comment
Share on other sites

I am trying to install EPF 3.01 on oscommerce 2.3.1. I am finding that in the index.php and the product_listing.php some of the items are either not found or are really close, but the syntax is not exactly the same.

 

An example is in the instructions for product_listing.php, 6a is specifying a case 'product_list_name' code change, but the file is not exactly the same as what is listed in the instructions. I saw that v2_31 is supposed to work with the 2.3 core, however the instructions are the same for this section.

 

Is there a version for OSC 2.3.1? if not can anyone point me to a contribution that will do the same for 2.3.1?

Link to comment
Share on other sites

  • 2 weeks later...
  • 4 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...