Product videos from youtube [Support Thread]

[info1]

Hello mates,
Thanks for choosing this addon. if you experience any problems regarding the addon 'PRODUCT VIDEOS FROM YOUTUBE' please post here. I can help you.

Link to Plugin: http://www.zen-cart.com/downloads.php?do=file&id=1152

[info1]

Future Updates :
- access to change the size of player and color
- pull videos from other video portals

Regards,
Vj

[jjrmy1]

I installed your mod and am getting the following error upon hitting the "add/update button

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jjrmy1/public_html/bpthingsbackoffice/update.php on line 18
Inserted Successfully

I'd love to be able to use this mod.
Here's the bottom of the collect_info.php file:

<?php
    }
?>
          <tr>
            <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td>
            <td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_weight', $pInfo->products_weight); ?></td>
          </tr>
          <tr>
            <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SORT_ORDER; ?></td>
            <td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_sort_order', $pInfo->products_sort_order); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
      </tr>
<?php
		//////////////////////////youtube code starts here///////////////////////// ?> 
		<tr>
				<td bgcolor="#e5e5ff">Select Video Player Size</td>
				<td bgcolor="#e5e5ff"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15');?>
				<label>
				  <input type="radio" name="vsize" value="320x240" checked="checked" />320 x 240 </label>
				
				  <label>
				  <input type="radio" name="vsize" value="560x340" />560 x 340</label>
				    
				  <label>
				  <input type="radio" name="vsize" value="640x385" />640 x 385</label>
				
				  <label>
				  <input type="radio" name="vsize" value="853x505" />853 x 505</label>
				    
				  <label>
				  <input type="radio" name="vsize" value="1280x745" />1280 x 745</label>
				</td>
			</tr>
			<tr>
			      <td colspan="2" bgcolor="#e5e5ff"><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
			</tr>
          <tr>
            <td class="main" vaign="top" bgcolor="#e5e5ff">
			<?php 
				$sql = mysql_query("select youtube_id from products_videos where products_id = \"$pid\" ");
					if(mysql_num_rows($sql)){
						$row = mysql_fetch_array($sql);
						$youid = "value=".$row['youtube_id'];
					}
					else{
						$youid = "";
					}
				
				echo "Youtube Video Id"; ?> ex: '6cKIPvfvxKo'</td>
            <td class="main" bgcolor="#e5e5ff"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15');?><input type="text" id="youtube_id" <?=$youid?> /> 
			<span style="background-color:#d1f5ff; border:solid 1px #89c0d0; padding:3px;"><a href="javascript:void(0)" style="text-decoration:none;" onclick="loadXMLDoc()">Add / Update</span> </a><br><?php echo zen_draw_separator('pixel_trans.gif', '24', '18');?>
			<div id="myDiv"></div>
          </tr>
	
	<?php
		//////////////////////////youtube code ends here///////////////////////// ?>
      <tr>
        <td class="main" align="right"><?php echo zen_draw_hidden_field('products_date_added', (zen_not_null($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . ( (isset($_GET['search']) && !empty($_GET['search'])) ? zen_draw_hidden_field('search', $_GET['search']) : '') . ( (isset($_POST['search']) && !empty($_POST['search']) && empty($_GET['search'])) ? zen_draw_hidden_field('search', $_POST['search']) : '') . zen_image_submit('button_preview.gif', IMAGE_PREVIEW) . '&nbsp;&nbsp;<a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '') . ( (isset($_GET['search']) && !empty($_GET['search'])) ? '&search=' . $_GET['search'] : '') . ( (isset($_POST['search']) && !empty($_POST['search']) && empty($_GET['search'])) ? '&search=' . $_POST['search'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
      </tr>
    </table></form>

Thanks a lot in advance for the help
jjrmy1

[jjrmy1]

I manually input the values into the database and no video shows on the product page. Sounds like it would be a great mod but it does need some work. The database input doesn't work, neither does the display. installed according to the directions.

[jjrmy1]

Never mind. I had to change the table prefixes.

[sigung]

Never mind. I had to change the table prefixes.

I am struggling to get this to work, what did you mean you had to change the table prefiixes? What tables are you talking about and what did you change them to please?

[sigung]

Never mind. I had to change the table prefixes.

I emailed Jeremy and asked him what specifically he did to fix this. Here is his fix, I've implemented it, and it works perfectly.


admin/product_video_youtube.php
LINE 18
insert your table prefix before "products_videos"
LINE 21
insert your table prefix before "products_videos"
LINE 24
insert your table prefix before "products_videos"
includes/templates/your template/templates/tpl_modules_youtube.php
LINE 14
insert your table prefix before "products_videos"
For example. The prefix for my ZenCart tables is "cart_" So mine looks like this: cart_products_videos.

You must change both files.

[flexiblelove]

Future Updates :
- access to change the size of player and color
- pull videos from other video portals

Regards,
Vj

Great add-on! Terribly easy to install and a wonderful addition to my site! Thanks very much!

flexiblelove.ca

[pcsdesign]

Copied this codde to the SQL patch - results below

<?php
$sql = mysql_query("select youtube_id, dimentions from products_videos where products_id = \"$pid\" ");
if(mysql_num_rows($sql)){
$row = mysql_fetch_array($sql);
$youid = $row['youtube_id'];
$dimentions = $row['dimentions'];
}else{ $youid = ""; }
?>
<tr><td colspan="2"><?php echo zen_draw_separator('pixel_black.gif', '100%', '3'); ?></td></tr>
<tr>
<td bgcolor="#e5e5ff">Select Video Player Size</td>
<td bgcolor="#e5e5ff"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15');?>
<label><input type="radio" name="vsize" value="230x140" <?php if($dimentions=="230x140"){ echo "checked=\"checked\""; }?>/>230 x 140</label>
<label><input type="radio" name="vsize" value="330x200" <?php if($dimentions=="330x200"){ echo "checked=\"checked\""; }?>/>330 x 200</label>
<label><input type="radio" name="vsize" value="430x260" <?php if($dimentions=="430x260"){ echo "checked=\"checked\""; }?>/>430 x 260</label>
<label><input type="radio" name="vsize" value="530x320" <?php if($dimentions=="530x320"){ echo "checked=\"checked\""; }?>/>530 x 320</label>
</td>
</tr>
<tr><td colspan="2" bgcolor="#e5e5ff"><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td></tr>
<tr>
<td class="main" vaign="top" bgcolor="#e5e5ff">Youtube Video Id ex: '6cKIPvfvxKo'</td>
<td class="main" bgcolor="#e5e5ff">
<?php echo zen_draw_separator('pixel_trans.gif', '24', '15');?>
<input type="text" id="youtube_id" value="<?=$youid;?>" />
<span style="background-color:#d1f5ff; border:solid 1px #89c0d0; padding:3px;">
<a href="javascript:void(0)" style="text-decoration:none;" onclick="loadXMLDoc()">Add / Update</a>
</span>
<br>
<?php echo zen_draw_separator('pixel_trans.gif', '24', '18');?>
<div id="myDiv"></div>
</td>
</tr>

************** Results ******************
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in:
[<?php $sql = mysql_query("select youtube_id, dimentions from products_videos where products_id = \"$pid\" ");]
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.
*** End of Results ************

[essentiality]

Hi,

Will this module work for version 1.3.8?

Thanks