Jump to content
Sign in to follow this  
wdepot

Now Available: Extra Product Fields 2.3

Recommended Posts

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

Share this post


Link to post
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']]) . '))';

}

Share this post


Link to post
Share on other sites

I have installed this mod, but was wondering: How can I make the extra field a clickable link?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.

Share this post


Link to post
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.

Share this post


Link to post
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?

Share this post


Link to post
Share on other sites

if you read carefully you will read that there is one version for osc 2.3 ! EPF 2.3.1 or 3.01 is NOT for OSC2.3 !

Share this post


Link to post
Share on other sites

Is there somebody succesfully using Extra Product Fields AND a multi image addon?

 

Thanks to guide me to the right and compactible addon

Share this post


Link to post
Share on other sites

any contribution which has multiple errors and is an impossible mission to install should be avoided. i learnt the hardway last time.

 

hacking the core code to death will make you suffer! trust me, i know full well.

 

i would avoid it all costs.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×