require('inc/commoninc.php');

  require('inc/functions.php');

  require('inc/appinc.php');  

  konekDB();



  //{info}

  $q = "SELECT * FROM ecommerce_info";

  $vq = mysql_query($q) or die(mysql_error()."<br>".$q);

  $rq = mysql_fetch_array($vq);

  $vinfo = str_replace(chr(10), "<BR>", $rq['info']);

  $vinfo = substr($rq['info'], 0, 500);

  $vinfo .= "... <a href=\"info.php\">more info</a><br><br>"; 

  

  //{bestseller}            

  $q = "SELECT * FROM ecommerce_products WHERE type='Best Buy' ORDER BY id DESC LIMIT 5";

  $vq = mysql_query($q) or die(mysql_error()."<br>".$q);

  while ($rq = mysql_fetch_array($vq)){

	$vbestseller .= '

	<table WIDTH="345" BORDER="0" CELLPADDING="0" CELLSPACING="0">

		<tr>

			<td width="301" height="21" valign="bottom"><span class="text2"><a href="catalog.php?id='.$rq['id'].'">'.$rq['title'].'</a> <font color="#448EC1">('.format_harga($rq['price']).')</font></span></td>

            <td rowspan=2><a href="buy.php?id='.$rq['id'].'" title="buy '.$rq['title'].'"><img SRC="tpl/images/img04.gif" width="44" height="31" border="0"></a></td>

        </tr>

		<tr>

            <td colspan=3><img SRC="tpl/images/img05.gif" width="301" height="10"></td>

		</tr>

	</table>';	

  } 	



  //{product}            

  $q = "SELECT * FROM ecommerce_products WHERE type='Feature Stuff' ORDER BY id DESC LIMIT 2";

  $vq = mysql_query($q) or die(mysql_error()."<br>".$q);

  while ($rq = mysql_fetch_array($vq)){

	$vtimestamp = $rq['timestamp'];

	$nmfolder = substr($vtimestamp,0,7);

	$nmfolder = str_replace("-","",$nmfolder);

	$folder = "img/".$nmfolder."/";   

	$picture = $folder.$rq['jpg1'];

	$vproduct .= '

	<tr>

		<td bgcolor="#E6E7E8" width="110" height="136" align="center" valign="top"><a href="catalog.php?id='.$rq['id'].'"><img SRC="'.$picture.'" width="100" height="100" border="0"></a></td>

		<td align="left" width="270" valign="top" bgcolor="#E6E7E8">

			<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber3">

				<tr>

					<td width="100%" align="left" valign="top" colspan="2"><p class="text">'.$rq['short'].'</p></td>

                </tr>

				<tr>

                    <td width="50%" align="left" valign="top"><p class="text"><b>PRICE: '.format_harga($rq['price']).'</b></td>

                    <td width="50%" align="center" valign="top"><p class="Links"><a href="catalog.php?id='.$rq['id'].'">more info</a></td>

				</tr>

			</table>

        </td>

		<td background="tpl/images/tile1.gif" width="26">&nbsp;</td>

	</tr>';	

  }  

  

  $isinya = Bacalah("tpl/tpl.html");

  $isinya = str_replace("{info}", $vinfo, $isinya );

  $isinya = str_replace("{bestseller}", $vbestseller, $isinya );

  $isinya = str_replac