<?php


	require_once("include/server_config.php");

			
	$rsHomeProds = $db->createRecordset("SELECT p.*

										   FROM products p

										  WHERE p.show_on_home = 'Yes'

										  LIMIT 0,9");

	$products    = $db->fetchAll($rsHomeProds);									  

	
	$last  = array();

	$first = array();

	for ($i = 0; $i < sizeof($products); $i++) {

		if (!$products[$i]["thumb_size"]) {

		    $products[$i]["thumb_size"] = image_getSizeForHTML($products[$i]["thumb_url"]);

			$db->updateField("products", "product_id", $products[$i]["product_id"], "thumb_size", $products[$i]["thumb_size"]);

		}

		if ($i > 5 ) {

		    $last[] = $products[$i];

		}else {

			$first[] = $products[$i];

		}

	}

	
	$page["title"]          = TITLE;

	$page["description"]    = META_DESCRIPTION;	

	$page["keywords"]       = META_KEYWORDS;		

	$page["alt_header_img"] = ALT_HEADER_IMG;

	$page["alt_logo"]       = ALT_LOGO;	

	$page["alt_footer_img"] = ALT_FOOTER_IMG;

	page_top($page);

	
	$smarty->assign("prods", $first);

	$smarty->assign("last", $last);

	$smarty->assign("content_r", array("index.tpl"));

	$smarty->display("main.tpl");			   
	

?>