Product Extra Fields for text, pdfs and flash

Hello Thanks for work.
I use 1.5.1
I need this plugin only to add 3 fields of text, is it possible with this plugin?
I don't try to see video swf attached...
I try to read instructions but I didn't find any instructions, I upload all files and then run sql is true?
Last thing if I would to unistall can you say to me what sql command I have to run?
thanks in advance
:blush:

I need this plugin only to add 3 fields of text, is it possible with this plugin?
----Only one text field is provided specifically with this version.
I don't try to see video swf attached...
----Everything is provided that is necesary.
I try to read instructions but I didn't find any instructions, I upload all files and then run sql is true?
----Information in the readme.txt file
Last thing if I would to unistall can you say to me what sql command I have to run?
----Not provided but the install sql installs a new table so there's nothing to remove from the default zen cart tables.

thanks for fast reply ;-)

This contribution is a big help thanks!

Any way I can get the extra field to show as a column in the product list after clicking a category?

Cheers.

Hey,

I am using the add-on and its working great, I altered some code to allow it show a size guide on some of our products - now if you click on it the size guide will display in a lightbox popup - check it out! http://www.rockfrocks.com/50s-style-dresses/classy-vintage-style-dress-w-bow-detail-black

However, I now find that when we go into the product details page in the admin, the values in each of the extra field get wiped and appear as blank. This means that each time we update a product description, we have to add the details for product extra fields again. Has anybody else experienced this and is there a solution?

did you alter the admin code? I wouldn't think that you would have if you are just adding the lightbox feature. If you didn't then your edits are not at fault and something else is.

Hey, no I didnt actually. I just edited the product info page. I might be able to restore just the admin page from a previous version. That seems like such an obvious solution now but it never even crossed my mind! Thanks for the pointer!

Hi, Where is the install sql ? It does not appear to be in the zip file at the download here at the zen plugin section. I have uploaded all the files but now cannot access my product page in the admin.

Well, that's bizarre. I can't believe no one has noticed this before! Here's the sql```
DROP TABLE IF EXISTS product_extra_fields;
CREATE TABLE product_extra_fields (
products_id int(11) NOT NULL default '0',
extra_field text default '',
file_1 varchar(50) default NULL,
file_2 varchar(50) default NULL,
file_3 varchar(50) default NULL,
file_4 varchar(50) default NULL,
file_1_title varchar(100) default NULL,
file_2_title varchar(100) default NULL,
file_3_title varchar(100) default NULL,
file_4_title varchar(100) default NULL,
video varchar(150) default NULL,
video_title varchar(50) default NULL,
height smallint(6) default NULL,
width smallint(6) default NULL,
PRIMARY KEY (products_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO product_extra_fields (products_id)
SELECT products_id FROM products where products_type = 1;

Just copy and paste that into your admin > tools > Install SQL patches.

I'll put up the next version and be sure to include the sql. It will be different in the next version.

Thank you so much. It seems to be working fine. appreciate your work on this. I wish there were a way to just add fields where you want them to show up on the Product page. The Numinix module for that I just can't get to work but your uploaded and so far no errors. Great contrib. Thank you again.

I just uploaded version 2 of this mod updated to 1.5.4. I do not know when it will be available.

Now included are 2 more text fields. I also added in an htaccess file for the product_extra_fields folder that limits the types of files allowed and protects the folder (see instructions). I have included sql files for installation, deletion and upgrade this time!

I looked at adding these fields into the search but simply didn't get far enough along that path. I plan on it later.

Anyone grabbing the new files, please let me know immediately if you run into any problems.

Hi,

Thanks for the great mod. I am using it to show an advice centre in a sidebox. I have a problem though if anybody can help me? The sidebox was working fine until I put it in the same column as another sidebox, doing that causes the entire page layout to mess up.
I'm not very good with coding so I am thinking I have messed up the code in the sidebox template file.
Can anybody tell me how to put this code into a sidebox template file to make it work please?:

<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($extra_field!='') { 
    echo '<li>'.$extra_field . '</li>';
} ?>
 
<?php if(isset($products_video_link)) { 
    echo '<li>'.$products_video_link . '</li>';
} ?> 
<?php if(isset($products_file_1_link)) { 
    echo '<li>'.$products_file_1_link . '</li>';
} ?>    
<?php if(isset($products_file_2_link)) {
    echo '<li>'.$products_file_2_link . '</li>';
} ?>    
<?php if(isset($products_file_3_link)) {
    echo '<li>'.$products_file_3_link. '</li>';
}  ?>
<?php if(isset($products_file_4_link)) {
    echo '<li>'.$products_file_4_link;
} 
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 '</ul>';
}
?>
</div>

I am using the editable sidebox module as a template, so here is the template I need to insert it into:

<?php
/**
 * editable sidebox - allows a sidebox editable with the define pages editor to be added to your site
 *
 * @package templateSystem
 * @copyright 2007 Kuroi Web Design
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: blank_sidebox.php 2007-08-10 kuroi $
 */

  $content = '';
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">';

  // this is where the content that you have via the Admin is pulled in.
  $content .= file_get_contents($define_sidebox);

  $content .= '</div>';
?>

Thanks

If it was working before you moved it then perhaps you need to look at the other sideboxes. Sounds like something is missing a div tag and I don't see that in the code you've posted.

Hi
Yeah, that's what I thought originally. So I turned off and on the sideboxes, including standard zen cart sideboxes, and it doesn't work with any of the sideboxes. I also had a look at the stylesheet to see if there are any problems there, but there is nothing amiss.

I know the sidebox templates follow a different format from what I have read, it doesn't just work by copying and pasting the product_info template code that you kindly provided, but I am having a hard time translating it into the sidebox template.

This is the code that I came up with:

<?php
/**
 * editable sidebox - allows a sidebox editable with the define pages editor to be added to your site
 *
 * @package templateSystem
 * @copyright 2007 Kuroi Web Design
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: blank_sidebox.php 2007-08-10 kuroi $
 */
$content = '';
$content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">';
$content = file_get_contents($define_sidebox);
$content .= '<div class="adbox">'.$extra_field .'</div>';
$content .= '<div class="adbox">' .$current_categories_description_sub .'</div>' ;
$content .= '<div class="adbox">'.$products_file_1_link . '</div>' ;
$content .= '<div class="adbox">'.$products_file_2_link . '</div>' ;
$content .= '<div class="adbox">'.$products_file_3_link . '</div>' ;
$content .= '<div class="adbox">'.$products_file_4_link . '</div>' ;


  // this is where the content that you have via the Admin is pulled in.
$content .= '</div>';
?>  

But I have no idea if it is right, or has any errors? I just know that it breaks when I put the sidebox in the same column as any other sidebox.

Thanks

So you have never gotten the sidebox itself working, just the code on the product info page? You don't want that sidebox showing on any other page so that also requires a bit of coding otherwise it will show a blank box on other pages.

If the sidebox was showing correctly then it would not need editing. If you'll put it back where it was working, I can take a look at the page.

Hi,
Thanks for the help, I have managed to get it working now :smile: You was right about the div tag, there was an extra closing div tag in the source code, so I deleted the last div tag in the editable sidebox module and it is now working on the test site.
Thanks again

I just sent my newest version for approval. You can now display these extra fields on a tab if you are using Tabbed Products Pro v.1.10. If you want the files before they are approved, pm me.

I don't see anything referring to the admin directory.

I renamed the admin directory to my admin folder name as well as the custom template. My admin was no longer accessible, and have now restored from backup.

ZC1.5.4

When you say that the admin was "no longer accessible", what symptoms were you seeing? Were there any debug-log files generated?

lat9:

When you say that the admin was "no longer accessible", what symptoms were you seeing? Were there any debug-log files generated?

My admin crashed - it was like I had corrupted the admin directory and the "site" didn't exist. I didn't take a screenshot., sorry.

Where might I find the debug-log files?