Technique, Technology, Design & Development
Product Video/ Featured Video for Oscommerce
Thanks for checking out this oscommerce contribution.
This oscommerce cotribution let you show embed videos of your product. Once you done the basic customization You can use this contribution to display featured videos of your product.
Run this in your mysql
ALTER TABLE `products` ADD `products_embed_movie` text default NULL;
ALTER TABLE `products` ADD `products_featured_movie` tinyint(1) default NULL AFTER `products_embed_movie`;
admin/categories.php
FIND->
$parameters = array(‘products_name’ => ”,
‘products_description’ => ”,
ADD AFTER->
‘products_embed_movie’ => ”,
‘products_featured_movie’ => 0,
FIND->(there may be more than one, add affter all)
$products_name = $HTTP_POST_VARS['products_name'];
$products_description = $HTTP_POST_VARS['products_description'];
$products_url = $HTTP_POST_VARS['products_url'];
ADD AFTER->
$products_embed_movie = $HTTP_POST_VARS['products_embed_movie'];
$products_featured_movie = $HTTP_POST_VARS['products_featured_movie'];
FIND->p.products_model, in
$product_query = tep_db_query(“select pd.products_name, pd.products_description,
ADD BEFORE->
p.products_embed_movie,p.products_featured_movie,
FIND->
if (!isset($pInfo->products_status)) $pInfo->products_status = ’1′;
switch ($pInfo->products_status) {
case ’0′: $in_status = false; $out_status = true; break;
case ’1′:
default: $in_status = true; $out_status = false;
}
ADD AFTER->
if (!isset($pInfo->products_featured_movie)) $pInfo->products_featured_movie = ’1′;
switch ($pInfo->products_featured_movie) {
case ’0′: $in_moviefeaturedstatus = false; $out_moviefeaturedstatus = true; break;
case ’1′:
default: $in_moviefeaturedstatus = true; $out_moviefeaturedstatus = false;
}
FIND ->
<tr bgcolor=”#ebebff”>
<td><?php echo TEXT_PRODUCTS_PRICE_NET; ?></td>
<td><?php echo tep_draw_separator(‘pixel_trans.gif’, ’24′, ’15′) . ‘ ’ . tep_draw_input_field(‘products_price’, $pInfo->products_price, ‘onKeyUp=”updateGross()”‘); ?></td>
</tr>
ADD AFTER->
<tr>
<td><?php echo TEXT_EMBED_MOVIE; ?></td>
<td>
<table border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<td valign=”top”>
<?php echo tep_draw_textarea_field(‘products_embed_movie’, ‘soft’, ’60′, ’8′,$pInfo->products_embed_movie); ?>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor=”#ebebff”>
<td><?php echo TEXT_SETMOVIE_AS_FEATURED; ?></td>
<td><?php echo tep_draw_separator(‘pixel_trans.gif’, ’24′, ’15′) . ‘ ’ . tep_draw_radio_field(‘products_featured_movie’, ’1′, $in_status) . ‘ ’ . TEXT_YES . ‘ ’ . tep_draw_radio_field(‘products_featured_movie’, ’0′, $out_status) . ‘ ’ . TEXT_NO; ?></td>
</tr>
FIND->
echo tep_draw_hidden_field(‘products_image’, stripslashes($products_image_name));
ADD AFTER->
echo tep_draw_hidden_field(‘products_embed_movie’, stripslashes($products_embed_movie));
echo tep_draw_hidden_field(‘products_featured_movie’, stripslashes($products_featured_movie));
FIND->
<td><?php echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, ‘align=”right” hspace=”5″ vspace=”5″‘) . $pInfo->products_description; ?></td>
</tr>
ADD AFTER->
<tr>
<td><?php echo $pInfo->products_embed_movie?></td>
</tr>
FIND->
tep_db_query(“insert into ” . TABLE_PRODUCTS . ” (products_quantity, products_model,products_image, products_retail_price, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values (‘” . tep_db_input($product['products_quantity']) . “‘, ‘” . tep_db_input($product['products_model']) . “‘, ‘” . tep_db_input($product['products_image']) . “‘, ‘” . tep_db_input($product['products_retail_price']) . “‘, ‘” . tep_db_input($product['products_price']) . “‘, now(), ” . (empty($product['products_date_available']) ? “null” : “‘” . tep_db_input($product['products_date_available']) . “‘”) . “, ‘” . tep_db_input($product['products_weight']) . “‘, ’0′, ‘” . (int)$product['products_tax_class_id'] . “‘, ‘” . (int)$product['manufacturers_id'] . “‘)”);
REPLACEWITH->
tep_db_query(“insert into ” . TABLE_PRODUCTS . ” (products_quantity, products_model,products_image, products_retail_price, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id,products_embed_movie,products_featured_movie) values (‘” . tep_db_input($product['products_quantity']) . “‘, ‘” . tep_db_input($product['products_model']) . “‘, ‘” . tep_db_input($product['products_image']) . “‘, ‘” . tep_db_input($product['products_retail_price']) . “‘, ‘” . tep_db_input($product['products_price']) . “‘, now(), ” . (empty($product['products_date_available']) ? “null” : “‘” . tep_db_input($product['products_date_available']) . “‘”) . “, ‘” . tep_db_input($product['products_weight']) . “‘, ’0′, ‘” . (int)$product['products_tax_class_id'] . “‘, ‘” . (int)$product['manufacturers_id'] . “‘, ‘” . tep_db_input($product['products_embed_movie']) . “‘, ‘” . tep_db_input($product['products_featured_movie']) . “‘)”);
FIND->
$sql_data_array = array(‘products_quantity’ => (int)tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
‘products_model’ => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
‘products_price’ => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
‘products_retail_price’ => tep_db_prepare_input($HTTP_POST_VARS['products_retail_price']),
‘products_date_available’ => $products_date_available,
‘products_weight’ => (float)tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
‘products_status’ => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
‘products_tax_class_id’ => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
ADD AFTER->
‘products_embed_movie’ => tep_db_prepare_input($HTTP_POST_VARS['products_embed_movie']),
‘products_featured_movie’ => tep_db_prepare_input($HTTP_POST_VARS['products_featured_movie']),
admin/includes/langauge/english.php
ADD TO BOTTOM
define(‘TEXT_EMBED_MOVIE’,'Embed Movie’);
define(‘TEXT_SETMOVIE_AS_FEATURED’,'Movie Featured’);
define(‘TEXT_YES’,'Yes’);
define(‘TEXT_NO’,'No’);
includes/langauge/english.php
//Modifyed from here for coderaustralia FEATURED VIDEO
define(‘TEXT_FEATURED’, ‘Video of the Month’);
FOLLOWING CODING IS OPTIONAL AND DEPEND ON YOUR SITE
TO SHOW VIDEO IN FEATURED PRODUCT VIDEO
index.php
if( !empty($random_product['products_featured_movie']) && !empty($random_product['products_embed_movie']) ){
$embed_video=$random_product['products_embed_movie'];
} else {
$featured_query = tep_db_query(“select p.products_id,pd.products_name, p.products_embed_movie from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd where p.products_status = ’1′ and pd.products_id = p.products_id and pd.language_id = ‘” . (int)$languages_id . “‘ and p.products_embed_movie<>” and p.products_featured_movie= ’1′”);
$featured_embed = tep_db_fetch_array($featured_query);
$embed_video=$featured_embed['products_embed_movie'];
}
if( !empty($embed_video) ){?>
<?php echo $embed_video;?>
<?php } ?>
SHOW VIDEO IN PRODUCT LISTING PAGE
product_info.php
FIND->
$product_info_query = tep_db_query(“select p.products_id, pd.products_name, pd.products_description, p.products_model,
ADD AFTER
p.products_embed_movie, p.products_featured_movie,
ADD THIS WHERE YOU NEED THE VIDEO
<?php if( !empty($product_info['products_featured_movie']) && !empty($product_info['products_embed_movie']) ){ ?>
<p style=”margin:0 auto;text-align:center;”><?php echo $product_info['products_embed_movie'] ?></p>
<?php } ?>
| Print article | This entry was posted by nuwinda on December 6, 2010 at 5:42 am, and is filed under Php Programming, Through WWW. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
