Product Extra Fields for text, pdfs and flash

can you give me examples of what you found? And did you use one in the contribution section or one I hosted briefly on my website?

delia:

can you give me examples of what you found? And did you use one in the contribution section or one I hosted briefly on my website?

In the admin -> includes -> modules -> product, I had too many edited files, so I removed all of them and put from the standard copy of ZC the original ones and then I replaced them by using your package from the Add-ons.

I have the copies of your links as well but I used here the Add-on (contribution) package made by you.

Also the database had still the product_extra_description_extra table that was not needed anymore and I removed it. It hadn't got removed earlier because I didn't realise to put my prefix in the sql in phpmyadmin.

Now looking the idea for hiding the extra field when having the price hidden with the idea you said earlier. Is it the template file where this "switch" should be?

For hiding the extra field (or any of these extras would be ok for now) when having the customer detail for authorization in "2" or "3" and the customer shop status as "2" as well, I tried to change the code like this for tpl_product_info_display.php:

But now my product part of the page goes blank, so there is some error in this structure.
I noted that the hiding prices (standard solution) is not done inside the template file, so maybe there is another way to do this as well.

I still get a blank page issue with my code, couldn't find what is wrong with that.
There must be some error in this structure. I haven't changed anything else than the above part for the file tpl_product_info_display.php.

Any ideas to solve this?

Thanks!

Elli

You've got a php error in the do nothing line - use of and instead of && - but I'm not a php wizard!

"and" and "&&" are practically interchangeable, as are "or" and "||". There are subtle differences in precedence, but they will both work. Depending on precedence rules for organizing multiple logic tests is not generally a good idea anyway - better to make the order explicit with parentheses.

thanks Glenn. There's definitely an error there somewhere in his code. Please check it!

Looking at the posted code with PHP highlighting...```php

There is one PHP error:

if(isset($extra_field)) and (CUSTOMERS_APPROVAL == 2 and $_SESSION['customer_id'] == '') or (STORE_STATUS == '1')) {

has an extra ) that makes PHP think the conditional test is done too soon.
There is also a logic error that could result in outputting a bare <li> with null content. Moving the $extra_field code to inside the products_file_1_link loop should eliminate that possibility.

<div class="files">
<?php if(isset($products_file_1_link) || isset($products_file_2_link) || isset($products_file_3_link) || isset($products_file_4_link) || isset($video_file_link) || isset($extra_field)) {
  echo '<div class="filesHead">'.TEXT_PRODUCT_MORE_INFO.'</div><ul>';
?>
<?php 
  if(isset($extra_field) and (CUSTOMERS_APPROVAL == 2 and $_SESSION['customer_id'] == '') or (STORE_STATUS == '1')) {
    // do nothing
  }
  else {
    echo '<li>'.$extra_field . '</li>';
  }
}// /if prod_file_1 ?>

delia:

You've got a php error in the do nothing line - use of and instead of && - but I'm not a php wizard!

hmmm... tried that too, no success so far but definitely it is some structural error in the php. :(
That line of "do nothing" has been used elsewhere in the ZC itself. It can be found via developers tool.

Elli

Editing: I got all the other answers after Delia's only after posting that even if I have refreshed the forum. Funny.
But thanks very much. Time to go to sleep but I'll try tomorrow! :)

Hi all,

Does anyone know why I'm getting the following UL list appear when I dont add any additional files? :

Downloadable Datasheets

* NULL
* NULL
* NULL
* NULL
* NULL

Any products where I HAVE added additional files are fine. I've removed the mod for the time being, but really want to get it working as our customers need PDF's.

Fantastic contribution by the way Delia! Thank you! :clap: I just hope i can get it working properly

Looks like you have put NULL in the database field. Did you add this into an cart with existing products? Or are these fields created by the sql that came with the mod?

The solution is to clean up those fields and I can give you a sql statement you can run to do that but we need to figure out how this happened.

Hi Delia

Thanks for your reply.. yes there were products in there in the 1st place. I've spoken to our techy/servery type guy.. and he admits he may not have copied the tables properly in the database!

He's going to take a look at it in the next few days, i'll let you know how I get on

Thank you! :smile:

hi, thanx for this great mod. The only problem I have is when I try and copy a product. Please can you confirm that this works?

When I copy a product at the moment, the new item just gives me errors:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/cashback/public_html/....../includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/cashback/public_html/....../admin/includes/classes/object_info.php on line 30

Hi
Well this contribution.
When you delete an item, the field in the table "product_extra_field" is not deleted.
A solution?
Thank you
Patrick

Will someone who has this installed try copying a product and see if you get the same results as jezjones29?

Nope, it's not added into the delete file - when I get a chance I'll do that and probably attend to the copy function as well.

Just trying to populate finally the old products in the shop to have their id in the product_extra_fields

• so, reading above, should I not put NULL in those fields I have nothing? I made an example, took the db structure out from the database and I've been building all hundreds of products like this in a spreadsheet: (1044, '<br />', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

• if the product id needs to be in the table product_extra_fields, can I update the site anymore with Easy Populate?!

Elli

The fields should be left empty if there's nothing there. And no, easy populate will not populate these fields - it will still work however, no changes to the rest of the product database setup.

delia:

The fields should be left empty if there's nothing there. And no, easy populate will not populate these fields - it will still work however, no changes to the rest of the product database setup.

Maybe there is a way to make the Easy Populate to populate this too or what is the wisest to fix that the populated once would work too?
Otherwise comes on error I guess (like now with the old products).

can be coded, yes, but it would not simple.