Product Extra Fields for text, pdfs and flash

[BillsWebBiz]

Hi Delia,

I installed this but unfortunately, I was using ZC 1.39g. There is now ZC 1.39h released. Do you know yet if your addon will work with it?

Also, after installing this, where are we supposed to see your extra fields? In the product editing area? As of now, I don't see any extra fields.

Thanks,
Bill

[Lowie]

is it possible to show the SWF (flash) upload in a lightbox/fancybox mode? To make it a little more fancy instead of a popup.

Thanks!

[Lowie]

Nevermind i found the solution

[Lowie]

People who also want to show the flash file in a dynamic popup (example: http://www.devuurwerkhandel.nl/kruit...hots-p-26.html)

- Download Fancybox: http://fancybox.net/
- Upload the following files into: includes/templates/YOURTEMPLATEFOLDER/templates
- the map fancybox (drag and drop)
- the file jquery-1.4.3.min.js

- Open de example index.html file included in the .rar file
- now copy the javascript out of it (you can also copy this one):

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
	<script>
		!window.jQuery && document.write('<script src="http://www.URL.nl/includes/templates/TEMPLATE/templates/jquery-1.4.3.min.js"><\/script>');
	</script>
	<script type="text/javascript" src="http://www.URL.nl/includes/templates/TEMPLATE/templates//fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
	<script type="text/javascript" src="http://www.URL.nl/includes/templates/TEMPLATE/templates//fancybox//jquery.fancybox-1.3.3.pack.js"></script>
	<link rel="stylesheet" type="text/css" href="http://www.URL.nl/includes/templates/TEMPLATE/templates//fancybox/jquery.fancybox-1.3.3.css" media="screen" />
	<script type="text/javascript">
		$(document).ready(function() {
			/*
			*   Examples - images
			*/

			$("a#example1").fancybox();

			$("a#example2").fancybox({
				'overlayShow'	: false,
				'transitionIn'	: 'elastic',
				'transitionOut'	: 'elastic'
			});

			$("a#example3").fancybox({
				'transitionIn'	: 'none',
				'transitionOut'	: 'none'	
			});

			$("a#example4").fancybox({
				'opacity'		: true,
				'overlayShow'	: false,
				'transitionIn'	: 'elastic',
				'transitionOut'	: 'none'
			});

			$("a#example5").fancybox();

			$("a#example6").fancybox({
				'titlePosition'		: 'outside',
				'overlayColor'		: '#000',
				'overlayOpacity'	: 0.9
			});

			$("a#example7").fancybox({
				'titlePosition'	: 'inside'
			});

			$("a#example8").fancybox({
				'titlePosition'	: 'over'
			});

			$("a[rel=example_group]").fancybox({
				'transitionIn'		: 'none',
				'transitionOut'		: 'none',
				'titlePosition' 	: 'over',
				'titleFormat'		: function(title, currentArray, currentIndex, currentOpts) {
					return '<span id="fancybox-title-over">Image ' + (currentIndex + 1) + ' / ' + currentArray.length + (title.length ? ' &nbsp; ' + title : '') + '</span>';
				}
			});

			/*
			*   Examples - various
			*/

			$("#various1").fancybox({
				'titlePosition'		: 'inside',
				'transitionIn'		: 'none',
				'transitionOut'		: 'none'
			});

			$("#various2").fancybox();

			$("#various3").fancybox({
				'width'			: '80%',
				'height'			: '80%',
				'autoScale'			: false,
				'transitionIn'		: 'none',
				'transitionOut'		: 'none',
				'type'				: 'iframe'
			});

			$("#various4").fancybox({
				'padding'			: 0,
				'autoScale'			: false,
				'transitionIn'		: 'none',
				'transitionOut'		: 'none'
			});
		});
	</script>

Be sure to edit the URLS at the top of this script. Then copy the whole script into your tpl_products_info_display.php page somewhere at the top.

- You now need to edit the link that opens the flash file/video:
- go to: includes/modules/pages/product_info/main_template_vars_product_type.php
- edit this line:
<a href="javascriptopupWindow(\''.zen_href_link(FILENAME_FLASH).'&id='.$_GET[products_id]. '\') ">'. $products_video_title . '</a>

into this:
if (!empty($products_video)) $products_video_link = '<a id="various3" href="'.zen_href_link(FILENAME_FLASH).'&id='.$_GET[products_id]. ' ">'. $products_video_title . '</a>';

Thats it!

Please keep in mind this is just a quick solution and not very smart. I just needed this done asap. When you use lightbox (or slimbox) for your product images to enlarge, fancybox will possibly disable that.

You need to use fancybox for your images also by doing this:
go to includes/templates/yourtemplatefolder/templates/tpl_modules_main_product_image.php and add id="example1" to the <a> functions. Very easy.

[Lowie]

When i try to upload a flash movie i get the same error over and over!

Anyone know whats wrong?

1054 Unknown column 'pe.products_code' in 'field list'
in:
[select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, pe.products_code, pe.file_1, pe.file_2, pe.file_3, pe.file_4, pe.file_1_title, pe.file_2_title, pe.file_3_title, pe.file_4_title, pe.video,pe.video_title, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd, product_extra_fields pe where p.products_id = pd.products_id and p.products_id = pe.products_id and p.products_id = '0']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields

[delia]

Now that's just bizarre, Lowie. I'm not sure how that happened because no one has reported that error before but it sure is an error.

I've updated to the 1.3.9h version and corrected the bug. I just uploaded it to contributions so you won't be able to see it yet.

[BillsWebBiz]

Now that's just bizarre, Lowie. I'm not sure how that happened because no one has reported that error before but it sure is an error.

I've updated to the 1.3.9h version and corrected the bug. I just uploaded it to contributions so you won't be able to see it yet.

Hi Delia,

How long does it take before we will see it?

Thanks!

[delia]

I can't forecast - depends on when they get to it.

[BillsWebBiz]

Thanks!

[Lowie]

Well this is for another website with version 1.38 and i never had the error before untill some days back!