Page 1 of 1

skip to the 2nd pic in a gallery

Posted: Tue Dec 29, 2009 6:23 pm
by arteweb
Hi to all,
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 );