{* category navigation tree *}

{section name=i loop=$categories_tree}

  {section name=j loop=$categories_tree max=($categories_tree[i][2]-2)}{assign var="sub" value=1}{/section}

  {if $categoryID == $categories_tree[i][0]}
    {* selected node => point category and don't make a link *}
    <br><li><b><font color=green>{$categories_tree[i][1]}</font></b><br>

  {else}
    {* not selected node => make a link to a category *}
    <a href="index.php?categoryID={$categories_tree[i][0]}" {if $categories_tree[i][2] > 0}class=category_child {/if}>{if $sub==1}&nbsp;&nbsp;&nbsp;&nbsp; {$categories_tree[i][1]}{else}{$categories_tree[i][1]}{/if}</a>

  {/if}
{assign var="sub" value=0}
{/section}

<?php    
    $result = array();
    $q2 = db_query("SELECT productID, name, picture, Price, brief_description FROM  ".PRODUCTS_TABLE." ORDER BY productID DESC LIMIT 5");
    while ($row2 = db_fetch_row($q2))
    {
        if (trim($row2[2])!="" && file_exists("./products_pictures/$row2[2]"))
        {
            $row2[3] = show_price($row2[3]);
            $result[] = $row2;
        }
    }
    $smarty->assign("lastnew_offers",$result);    
?>

{* hot new products *}
<!--hot-products-->
<div id="new-products"><em class="heading">New products</em>
   <div id="newproducts">
      <ul>
        {section name=i loop=$lastnew_offers}    
       <li>    
          <h2>{$lastnew_offers[i][1]}</h2>
          <a href="index.php?productID={$lastnew_offers[i][0]}"><img alt="{$lastnew_offers[i][1]}" border="0" id="img_{$lastnew_offers[i][2]}" style="cursor:hand;cursor:pointer; vertical-align:middle; float:left;" src="product_images/{$lastnew_offers[i][2]}" /></a>
          <p>{$lastnew_offers[i][4]}</p>
          <a href="index.php?productID={$lastnew_offers[i][0]}" class="hotnewlink" style="color:#ff063b;">More of {$lastnew_offers[i][1]}</a>
            </li>
    {/section}
      </ul> 
   </div>   
</div>
{* end of hot new products *}