ok, got the database part but where do I insert the if statement code? Here is my home.tpl:
Code:
{* $Id: home.tpl,v 1.7 2003/04/11 05:05:27 svowl Exp $ *}
{ config_load file="$skin_config" }
<html>
<head>
<title>Welcome to Ely Mall.
{if $main eq "catalog"}
- Home
{elseif $main eq "help"}
- Help section
{elseif $main eq "cart"}
- Your Shopping Cart
{elseif $main eq "checkout"}
- Checkout
{elseif $main eq "order_message"}
- Thank you for your order
{/if}
</title>
{ include file="meta.tpl" }
<link rel="stylesheet" href="{$SkinDir}/{#CSSFile#}">
</head>
<body LEFTMARGIN=0 TOPMARGIN=0 RIGHTMARGIN=0 BOTTOMMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
{ include file="rectangle_top.tpl" }
{ include file="head.tpl" }
<table border=0 width="760" cellpadding=0 cellspacing=0 align="center">
<tr>
<td class=VertMenuBox width=150 valign=top>
{ include file="customer/categories.tpl" }
{if $active_modules.Bestsellers ne "" and $config.Modules.bestsellers_menu eq "Y"}
{ include file="modules/Bestsellers/menu_bestsellers.tpl" }
{/if}
{if $active_modules.Gift_Certificates ne "" or $active_modules.Product_Configurator ne ""}
{ include file="customer/special.tpl" }
{/if}
{if $login eq "" }
{ include file="auth.tpl" }
{else}
{ include file="menu_profile.tpl" }
{/if}
{ include file="customer/menu_cart.tpl" }
{if $login eq "" }
{ include file="news.tpl" }
{else}
{ include file="authbox.tpl" }
{/if}
{if $active_modules.Interneka ne ""}
{ include file="modules/Interneka/menu_interneka.tpl" }
{/if}
{ include file="help.tpl" }
</td>
<td width=20></td>
<td valign=top>
{include file="customer/home_main.tpl"}
</td>
</tr>
</table>
{ include file="rectangle_bottom.tpl" }
</body>
</html>