<table width="645"  border="0" cellpadding="0" cellspacing="0" bgcolor="#FFA800">
	<tr>
	<p style=" float:left; text-align:left; line-height:12px; padding-left:5px; padding-right:5px">Welcome to <u>Www.Upowerbiz.Com </u> -onetop Consumer Electronic Accessories Retail And wholesale marketplace !<br>
	  <br>
Our Promise:<br>
We are an online marketplace of consumer electronic accessories. We warrant that all products sold in our websites are 100% brand new and free from defects in material and workmanship under normal conditions of use. Shopping with us is safe and secure. If you are not satisfied with our products for any reason, please don't hesitate to contact us, we will reply you within 24 hours. Our goal is 100% customer satisfaction. <br><br>
Thank you for stopping by and hope you have an enjoyable shopping experience!<br>
</p>

		<td align="left"><a href="products_new.php"> &nbsp; &nbsp; &nbsp; &nbsp; <b>New Products</b> </a></td>
	</tr>
</table>

<table width="645" border="0" cellpadding="0" cellspacing="0" bgcolor="#FCD9BB">
            <tr>
	<?php
$listing_sql = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from products p, products_description pd where p.products_id = pd.products_id  and p.products_status=1 and pd.language_id=".(int)$languages_id." and p.products_quantity>0 order by p.products_date_added desc limit 4";
$products_query=tep_db_query($listing_sql);
//$products_query=tep_db_query($listing_sql);
	for($j = 1; $j <= 4; $j++)
	{
		$row = tep_db_fetch_array($products_query);
		//echo $row['products_name'];
		$tepproducts_name=str_replace('+',' + ',$row['products_name']);
		$tepproducts_name=str_replace('/',' / ',$tepproducts_name);
		$tepproducts_name=str_replace('  /  ',' / ',$tepproducts_name);
		$tepproducts_name=str_replace('  +  ',' + ',$tepproducts_name);
		if(strlen($tepproducts_name)>60){
			$pos=strpos($tepproducts_name," ",61);
			if ($pos)
			{
				$str_product_name=substr_replace($tepproducts_name," ...",$pos);
			}
			else
			{
				$str_product_name=$tepproducts_name;
			}
		
		}
		else{
			$str_product_name=$tepproducts_name;
		}
		

?>
              <td width="25%"><table  border="0" align="center" cellpadding="0" cellspacing="0" class="pro_table" >
                <tr>
                  <td valign="top"onMouseOver="this.style.background='url(images/onpicbg.gif)'" onMouseOut="this.style.background='url(images/bgpic.gif)'" style="text-align:center" >
                    <div class="piccss"><a href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $row['products_id']);?>"><img src="images/products_images/<? echo $row[products_image];?>" alt="<? echo $row[products_name];?>" width="90" height="90" vspace="8" border="0"></a> </div>
                    <div style="text-align:center;"><a href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $row['products_id']);?>"  title="<?=$row[products_name]?>" class="titilecss"><?=$str_product_name?></a></div>
					<div class="pricecss"><?php echo $currencies->display_price($row['products_price'], tep_get_tax_rate($row['products_tax_class_id']));?></div>
                    <div class="addtocartcss" style="text-align:right; margin:6px;"><a href="<? echo tep_href_link(FILENAME_DEFAULT, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'sort=2a&action=buy_now&products_id=' . $row['products_id']);?>"><img src="<?=DIR_WS_LANGUAGES.$language?>/images/addtocart.gif" border="0" /></a></div></td>
                </tr>
              </table></td>
			  <?
}
?>
            </tr>
 </table>
        <br />
		<table width="645"  border="0" cellpadding="0" cellspacing="0" bgcolor="#FFA800" >
          <tr>
            <td align="left"><a href="specials.php">&nbsp; &nbsp; &nbsp; &nbsp; <b>Featured Items</b> </a></td>
          </tr>
        </table>
		<?php
		$listing_sql = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC limit 20";
		//echo '<br>'.$listing_sql.'<br>';
		$products_query=tep_db_query($listing_sql);

	for($i = 1; $i <= 5; $i++)
	{
?>
<table width="645" border="0" cellpadding="0" cellspacing="0" bgcolor="#F9E5D4">
  <tr>
    <?php
	for($j = 1; $j <= 4; $j++)
	{
		
		$rows = tep_db_fetch_array($products_query);
		
		$tepproducts_name=$rows['products_name'];
		
		
		//echo $rows['products_name'] . '<br>';
		$tepproducts_name=str_replace('+',' + ',$tepproducts_name);
		$tepproducts_name=str_replace('/',' / ',$tepproducts_name);
		$tepproducts_name=str_replace('  /  ',' / ',$tepproducts_name);
		$tepproducts_name=str_replace('  +  ',' + ',$tepproducts_name);
		
		
		
		if(strlen($tepproducts_name)>45)
		{
			$str_product_name=substr($tepproducts_name,0,45);
			$pos=strrpos($str_product_name,' ');
			//echo $pos.'<br>';
			if ($pos)
			{
				$str_product_name=substr_replace($str_product_name," ...",$pos);
			}
			else
			{
				$str_product_name=$str_product_name;
			}
		
		}
		else
		{
			$str_product_name=$tepproducts_name;
		}
		/*
		echo $rows['products_id'].':'.$rows['products_name'].'<br>';
		//echo $rows['products_id'].':'.$str_product_name ."<br>";
		echo $rows['products_id'].':'.$str_product_name ."<br>";<br />
		*/
		
?>
    <td width="25%"><table  border="0" align="center" cellpadding="0" cellspacing="0" class="spa_table" >
      <tr>
        <td valign="top"onmouseover="this.style.background='url(images/onpicbg2.gif)'" onmouseout="this.style.background='url(images/bg2pic.gif)'" style="text-align:center" ><div class="piccss"><a href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $rows['products_id']);?>">
<img src="images/products_images/<? echo $rows[products_image];?>" alt="<? echo $rows[products_name];?>" width="90" height="90" vspace="7" border="0"></a></div>
            <div style="width:158px;word-wrap: break-word;overflow:hidden !important; text-align:center;"><a class="spa_namea" href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $rows['products_id']);?>" title="<?=$rows[products_name]?>"> <? echo $str_product_name;?></a></div>
          <div> <span class="spa_oldprice">
            <?=BOX_SPECIALS_RRP?>
            <?php echo '<s>' . $currencies->display_price($rows['products_price'], tep_get_tax_rate($rows['products_tax_class_id'])).'</s>';?></span><br />
              <span class="newpricecss"><?php echo $currencies->display_price($rows['specials_new_products_price'], tep_get_tax_rate($rows['products_tax_class_id']));?></span><br />
              <span class="savecss">
              <?=BOX_SPECIALS_SAVE_F?>
                <?php echo $currencies->display_price($rows[products_price]-$rows['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id']));?><?=BOX_SPECIALS_SAVE_B?>
            </span></div>
          <div class="addtocartcss" style="text-align:right; margin:6px;"><a href="<? echo tep_href_link(FILENAME_DEFAULT, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'sort=2a&action=buy_now&products_id=' . $rows['products_id']);?>"><img src="<?=DIR_WS_LANGUAGES.$language?>/images/addtocart.gif" border="0" /></a></div></td>
      </tr>
    </table>
    </td>
    <?
}
?>
  </tr>
</table>
<?
}
?>
