<?php
/*
ArabCart, Free E-Commerce Solutions
http://www.arabcart.info
Copyright (c) 2005 Mhd Zaher Ghaibeh
Released under the GNU General Public License
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
USA.
*/
$sql_picture="select pro.id as pid , pro.name as name , thu.thumb_img as img from products pro, img_thumb thu where pro.id=thu.product_id ORDER BY RAND()";
$query_picture=mysql_query($sql_picture)or die(mysql_error());
$i=1;
if(mysql_num_rows($query_picture)!=0)
{
$template -> setAttribute("gallery", "visibility", "visible");
$template -> AddVar("gallery","PRODUCT-GALLERY",prog);
while($row_pic=mysql_fetch_object($query_picture))
{
$arry_max[$i]['pic']=$row_pic->img;
$arry_max[$i]['pid']=$row_pic->pid;
$arry_max[$i]['name']=$row_pic->name;
$i++;
}
for($rand_img=1 ; $rand_img<5 ; $rand_img++)
{
$template -> AddVar("images","PRO-IMG",$arry_max[$rand_img]['pic']);
$template -> AddVar("images","PRO-NAME",$arry_max[$rand_img]['name']);
$template -> AddVar("images","PRO-ID",$arry_max[$rand_img]['pid']);
$template -> AddVar("images","SID",$PHPSESSID);
$template -> parseTemplate("images","a");
}
}
elseif(mysql_num_rows($sql_gallery)==0)
{
$template -> setAttribute("gallery", "visibility", "hidden");
}
?>