Product videos from youtube [Support Thread]

Hello, if you have z-index problems add the red marked in the tpl_modules_youtube.php

<object width="<?=$dimentions[0];?>" height="<?=$dimentions[1];?>">
	<param name="movie" value="http://www.youtube.com/v/<?=$youtube_id;?>"></param>
    <param name="allowFullScreen" value="true"></param>
    <param name="allowscriptaccess" value="always"></param>
	<param name="wmode" value="opaque" />
    <embed src="http://www.youtube.com/v/<?=$youtube_id;?>" type="application/x-shockwave-flash" allowscriptaccess="always" wmode="opaque" allowfullscreen="true" width="<?=$dimentions[0];?>" height="<?=$dimentions[1];?>"></embed>
</object>

Hi

Im really new here and looking at the fix of the mysqlprefix.
Would any one tell me where do you enter the prefix like:

admin/product_video_youtube.php
LINE 18
insert your table prefix before "products_videos"

Please explaing if you can in details where and what line from the congif.php do i need to put?

Here is the prefix for me just dont know where to enter it?
define('DB_SERVER_USERNAME', 'choices2_zc1');

It would be great is some one writes both update files so just to upload them.

Many thanks in advanced.

Daniel.

How do you add multiple videos for one product page? Please let me know thanks! :)

danielnika, I'll try to help...

There are 2 files to upload and 3 ZC files to modify, along with one small sql patch.

I modified the sql patch from the original of:

CREATE TABLE IF NOT EXISTS products_videos ( id int(5) NOT NULL auto_increment, PRIMARY KEY (id), products_id int(11) NOT NULL, youtube_id text, dimentions varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

to this:

CREATE TABLE IF NOT EXISTS YOUR-DB-PREFIX_products_videos ( id int(5) NOT NULL auto_increment, PRIMARY KEY (id), products_id int(11) NOT NULL, youtube_id text, dimentions varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE latin1_general_ci AUTO_INCREMENT=1;

Add your database prefix to products_videos in the above code. I also changed the Engine type and CHARSET type to those used in my database.

Next, add your database prefix to all > products_videos references in the files to upload (product_video_youtube.php, tpl_modules_youtube.php, and collect_info.php).

Upload your files, patch the database. I moved the display code to a different location in my tpl_product_info_display.php file than recommended in the instructions and used my css to do some formatting.

I am testing it on a site I am setting up. It can be seen (for now!) at:

http://remoteworldsupply.com/index.php?main_page=product_info&cPath=14&products_id=8

Using: v. 1.3.9g

Hope this helps! -john

jnb41578:

I haven't tried this, but I would think you would have to add another database to the mix, using a different table name, and duplicating the code (using that name) in your modified/added ZC files, including adding another div id="productMainImage2" to the div id="productMainImage" already there.

In the above reply: "add another database to the mix" should read:

add another database table to the mix

Hello, i'm still trying to make the addon to work I followed all the steps but I still get this error when I enter the youtube video ID.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/86/6666286/html/fx/adminurrhtcqq/product_video_youtube.php on line 19
Inserted Successfully

Can someone HELP ME PLEASE!

plalande:

Hello, i'm still trying to make the addon to work I followed all the steps but I still get this error when I enter the youtube video ID.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/86/6666286/html/fx/adminurrhtcqq/product_video_youtube.php on line 19
Inserted Successfully

Can someone HELP ME PLEASE!

I was having the same trouble until I change the engine and charset to match my database

ENGINE=MyISAM
CHARSET=utf8

this got the add/update function working and the video showing up in my product but I'm still showing the error in cache

PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/user/public_html/mysite.com/zc_admin/includes/modules/product/collect_info.php on line 1020

and the video doesn't show in preview.

buildingblocks,

My collect_info.php has only 556 lines, even after the added code plus my modifications, yet the error message reports an error on line 1020. Unless you have added bunches of other code to this file could it be that you may have inadvertently copy/pasted the entire file into the original or perhaps the text instructions along with the needed code?

On my home server it works fine with the collation set at 'latin1_swedish_ci', but at my online host I had to change the collation to 'latin1_general_ci' for some reason before it would work.
That error makes me thimk (yes, thimk) that the sql table structure for products_videos has an error in it... should look like the attached screenshot.

Attachment #9516

Apparently the video does not show up in the 'preview' page.

Could anybody help me figure out why these won't load on my site?

I don't seem to be having any prefix issues mentioned earlier in this thread; the table shows fine in my database and I can add and update the video ids through my product editing page in the admin, but they don't display at all on my catalog page.

If I view the source of the page all that is displayed is this:

The tpl_modues_youtube.php template that displays the youtube vid simply isn't showing up at all for some reason. :blink:

Hmmm.... sounds like maybe your tpl_modues_youtube.php is in the wrong place:

..**/includes/templates/your_theme/templates/**tpl_modues_youtube.php

is working for me, both online and at my local server. Have you edited your tpl_product_inf_display.php file to include the line

AND placed it in includes/templates/your_template/templates/ ?

Thanks for your helpful reply; I've downloaded the latest version 1.3 of this mod and reinstalled everything in the correct locations and I can add all kinds of videos through the admin that are visible in the database phpMyAdmin panel, but still no love.

The /includes/templates/my template/templates/tpl_modules_youtube.php simply refuses to load into the /includes/templates/my template/templates/tpl_product_info_display.php page, no matter where I place the code. It just gets stripped out when the page loads, leaving this unhelpful bit of code behind:

sigh. I've never had this problem with a mod before - it's rather perplexing.

I've even added youtube.com to my .htaccess and crossdomain.xml files just incase it was being blocked that way, but no luck.

Oh well, thanks for the reply. I'm glad others are able to use this at least.

If anybody else is having the same issues I've had getting this mod to work, I found an alternate method to getting YouTube videos in your product page:

http://mydigitalfixation.com/how-to-add-youtube-video

It's essentially just pasting YouTube's iframe embed code directly into the product description text editor form (in HTML mode) on the product editing page in Admin.

Works fine, and you also have the added flexibility to select YouTube's extra embedding options such as using https to avoid error messages and the no-cookie viewer for increased customer privacy. :smile:

I have installed the add on to https://www.irishshopper.co.uk and it is working OK but it does not work on https://www.irishshopper.com even though it is accepting the Yourtube 11 character code OK.

The test clip we have is on the same procuct on both sites

The Plain Tweed Walking Hat

http://www.irishshopper.co.uk/ZenCart/index.php?main_page=product_info&cPath=7&products_id=34

Is there anyway you can get the clip to show in the middle of the Shopping Cart rather than left aligned ? I have enclosed the code in <center> and </center> but it made no difference

Hello,

Just was wondering if any of you guys have thought about making youtube video pop up in a light box...???

If yes, could you please share with me the code or module you used.

If no, I think that it's definitely worth trying.

Here are some great ideas: http://embedyoutubevideo.com/lightbox-youtube-joomla.html

Hi All,

could someone please tell me if this is suitable for zen cart 138.a (YouTube Video on Product Info Page)

http://www.zen-cart.com/downloads.php?do=file&id=1340 (if not could you please give me a link to one that is)

Many Thanks
Renz

Renz:

Hi All,

could someone please tell me if this is suitable for zen cart 138.a (YouTube Video on Product Info Page)

http://www.zen-cart.com/downloads.php?do=file&id=1340 (if not could you please give me a link to one that is)

Many Thanks
Renz

Far more compatible with 1.3.8 are nasty HACKER SCRIPTS.

You should be paying attention to upgrading, not silly entertainment videos for customers.

Hi, I'm using zen-cart v1.3.9h. I was wondering what happens when the video ends in this addon. Does anybody know if recommended videos show up after the video ends or does the video just end and show a black screen. I do not want other recommended videos from youtube to show up on my product listing.

Thank you for your help.

Derrick

i use iframe in the html editor...

Hello All,

Does this mod work with version 1.5.0 please let me know as i'd like to have this great feature for my site. I thank you for your time and response!!