I have embed a mini slideshow gallery (Phatfusion) after the product details of a Virtuemart store (v.1.1.4) in a Joomla website (v.1.5.14)
I would like to skip the first thumb and the first fullview image to the second pic.
In fact the first image ("101 Film di fantascienza", it has also a bad resize) is identical to the main one at the top-left of the page.
In other words it's possible to delete from gallery the first pic and let it begin the slideshow from the second one?
I spent many hours last night on the code trying with (LIMIT 1,5) and something other (I'm not a PHPer), but without results (first image disappears but the second doesn't load)
Any help will be appreciated!
>>>>>>The website<<<<<<
The code:
Code: Select all
// Custom code for phatfusion slideshow
$path = 'components/com_virtuemart/shop_image/product/';
$db_k= new ps_DB();
$db_k->query( "SELECT * FROM `#__{vm}_product` WHERE `product_id`=".intval($product_id));
$full = $path . $db_k->f('product_full_image');
$thumb = $path . $db_k->f('product_thumb_image');
$db_jk = new ps_DB();
$more='';
$db_jk->query( "SELECT * FROM `#__{vm}_product_files` WHERE `file_product_id`=".intval($product_id). " AND `file_is_image`=1 AND `file_published`=1 ORDER BY file_id ASC");
while( $db_jk->next_record() ) {
$mfull = ltrim($db_jk->f('file_name'),'/');
$mthumb = ereg_replace('product','product/resized',ltrim($db_jk->f('file_name'),'/'));
$mext = '_'. $db_jk->f('file_image_thumb_height'). 'x'. $db_jk->f('file_image_thumb_width'). '.'.$db_jk->f('file_extension');
$ereg = '.'. $db_jk->f('file_extension');
$mthumb = ereg_replace($ereg, $mext, $mthumb);
$more .= ';'. $mfull . ',' . $mthumb;
}
$product_image = '{phatfusionslideshow '. $full .','. $thumb . $more .'}';
$product_image = vmCommonHTML::ParseContentByPlugins( $product_image );// Custom code for phatfusion slideshow
$path = 'components/com_virtuemart/shop_image/product/';
$db_k= new ps_DB();
$db_k->query( "SELECT * FROM `#__{vm}_product` WHERE `product_id`=".intval($product_id));
$full = $path . $db_k->f('product_full_image');
$thumb = $path . $db_k->f('product_thumb_image');
$db_jk = new ps_DB();
$more='';
$db_jk->query( "SELECT * FROM `#__{vm}_product_files` WHERE `file_product_id`=".intval($product_id). " AND `file_is_image`=1 AND `file_published`=1 ORDER BY file_id ASC");
while( $db_jk->next_record() ) {
$mfull = ltrim($db_jk->f('file_name'),'/');
$mthumb = ereg_replace('product','product/resized',ltrim($db_jk->f('file_name'),'/'));
$mext = '_'. $db_jk->f('file_image_thumb_height'). 'x'. $db_jk->f('file_image_thumb_width'). '.'.$db_jk->f('file_extension');
$ereg = '.'. $db_jk->f('file_extension');
$mthumb = ereg_replace($ereg, $mext, $mthumb);
$more .= ';'. $mfull . ',' . $mthumb;
}
$product_image = '{phatfusionslideshow '. $full .','. $thumb . $more .'}';
$product_image = vmCommonHTML::ParseContentByPlugins( $product_image );