<?

$r=getenv("PATH_INFO");
$var_array = explode("/",$r);

$heel_height=urldecode($var_array[1]);
if(!$var_array[1]) $heel_height="1";

    if(is_numeric($var_array[2])) {
        $heel_style = $var_array[2];
    }


    if(is_numeric($var_array[3])) {
        $page=urldecode($var_array[3]);
    }
include ("includes/database.php");

if(($heel_height)&&(!$heel_style)){
$result_query="
SELECT
    t4.primary_id,
    t4.product_name,
    t4.product_sku,
    t4.product_short_desc ,
    t4.product_thumb_image thumb1,
    t4.product_price,
    t4.meta_words,
    t4.product_publish,
    t1.height
FROM
    products t4,
    height_xref as t2,
    heel_height as t1
WHERE t4.product_publish ='1'
    AND t1.height_id ='$heel_height'
    AND t2.height_id=t1.height_id
    AND t4.product_sku=t2.product_sku
GROUP BY product_name
ORDER BY product_sku";
}

if(($heel_height)&& ($heel_style)){
$result_query="
SELECT
    t4.primary_id,
    t4.product_name,
    t4.product_sku,
    t4.product_short_desc ,
    t4.product_thumb_image thumb1,
    t4.product_full_image,
    t4.product_price,
    t4.meta_words,
    t4.product_publish,
    t1.height
FROM
    products t4,
    heel_height as t1,
    height_xref as t2,
    heels as t5,
    heels_xref as t6
WHERE t4.product_publish ='1'
    AND t1.height_id ='$heel_height'
    AND t5.heel_id= '$heel_style'
    AND t2.height_id=t1.height_id
    AND t6.heel_id=t5.heel_id
    AND t6.product_sku=t4.product_sku
    AND t4.product_sku=t2.product_sku
GROUP BY product_name
ORDER BY product_name";
}
$result_mysql=mysql_query($result_query);
$num_rows=mysql_num_rows($result_mysql);


$count=0;
 // Number of entries per page
$per_page = 16;
 
 // Set page #, if no page is specified, assume page 1
 if (!$page) {
    $page = 1;
	}  
	
 $prev_page = $page - 1;
 $next_page = $page + 1;

// Set up specified page
$page_start = ($per_page * $page) - $per_page;

if (!$result_query){
echo("Sorry .. No Matches!");
}else{
 if ($num_rows <= $per_page) {
    $num_pages = 1;
 } else if (($num_rows % $per_page) == 0){
    $num_pages = ($num_rows / $per_page);
 } else {
    $num_pages = ($num_rows / $per_page) + 1;
 } 
 $num_pages = intval($num_pages);
 if (($page > $num_pages) || ($page < 0)) {
$pageError=1;
 } 

$ext=" LIMIT $page_start, $per_page";
$result_final=$result_query.$ext;
$resultfinal=mysql_query($result_final);

$limit=16;

if ($heel_style){
$heelquery=mysql_query("
SELECT height
FROM heel_height
WHERE height_id='$heel_height'",$dblink) or die(mysql_error());

while ($cat=mysql_fetch_object($heelquery))
{
if(!$heel_style){
$category_name=$cat->height." Heel Shoes";
}else{
$category_name=$cat->height;
}
if ($heel_height==1) $category_name="Under 4 inch";
}


$stylequery=mysql_query("
SELECT heel 
FROM heels 
WHERE heel_id='$heel_style'",$dblink) or die(mysql_error());

while ($cat=mysql_fetch_object($stylequery))
{
$category_name=$category_name." ".$cat->heel ." Shoes";
//$metawords= $cat->meta_words;
//$metadescription=$cat->meta_desc;
}


}else{
$heelquery=mysql_query("
SELECT height 
FROM heel_height 
WHERE height_id='$heel_height'",$dblink) or die(mysql_error());

while ($cat=mysql_fetch_object($heelquery))
{
$category_name=$cat->height." heel Shoes";
}


}
$category_name=$category_name;

				$catpage= trim($category_name);
                $catpage= str_replace("/","-",$catpage);
                $catpage= str_replace("\\","-",$catpage);
                $catpage= str_replace(",","",$catpage);
                $catpage= str_replace(" ","-",$catpage );
                $catpage= str_replace("?","",$catpage );
                $catpage= str_replace("(","-",$catpage );
                $catpage= str_replace(")","-",$catpage );
                $catpage= str_replace("^","",$catpage );
                $catpage= str_replace("$","",$catpage );
                $catpage= str_replace(" - ","-",$catpage );
                $catpage= str_replace("-","-",$catpage );
                $catpage= str_replace("'","",$catpage );
                $catpage= str_replace("&#39;","",$catpage );
                $catpage= str_replace("&quot;","inch",$catpage);
                $catpage= str_replace("&#34;","inch",$catpage);
                $catpage= str_replace("&amp;","-",$catpage );
                $catpage= str_replace("&","-",$catpage );
                $catpage= str_replace("--","-",$catpage);
                $catpage= str_replace("--","-",$catpage);

?>
<html>
<head>
<title><? echo $category_name ?></title>
<meta name="keywords" content="<? echo $metawords;?>">
<meta name="description" content="<? if (!empty($metadescription)) {echo trim(strip_tags($metadescription));}else{ echo trim(strip_tags($category_desc));}?>">
<META NAME="resource-type" content="document">
<META NAME="Content-Language" content="en-US">
<META HTTP-EQUIV="imagetoolbar" CONTENT="no">
<META NAME="copyright" content="<?echo  $hn; ?>">
<META name="robots" content="index,follow">
<META name="distribution" content="Global">
<META name="Abstract" content="Online store">
<META name="Expires" content="<? echo  date("F j, Y, g:i a T", mktime (0,0,0,date("m"),date("d")+45,  date("Y")));?>">
<META name="Revisit-After" content="7 Days">
<LINK REL="stylesheet" TYPE="text/css" HREF="/style.css">
<?  if ($dead){ ?>
<SCRIPT LANGUAGE="JavaScript">
function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=0,location=0,statusbar=1,menubar=0,resizable=0,width=384,height=184');");
}
</script>
<?}?>
</HEAD>
<BODY>

<? include ("includes/top.inc"); ?>

<td valign=top width=600>
<P>&nbsp;<p>

<P>&nbsp;<p>
<div align="center"><h3><?= $category_name ?></h3></div>
<p><blockquote><b><?= $category_desc ?></b></blockquote>

<?
if ($num_rows<1)echo "<div align=center>\n<P>&nbsp;</p><h2>\n New products are coming!\n</h2>\n<p>check back soon!</div>\n<P>&nbsp;</p> <P>&nbsp;</p> <P>&nbsp;</p> ";
if ($pageError)echo "<div align=center>\n<P>&nbsp;</p><h2>\n An error occurred while getting that page!\n</h2>\n<p>Please use the navigation to the left to browse our products, Thanks!</div>\n<P>&nbsp;</p> <P>&nbsp;</p> <P>&nbsp;</p> ";
?>
<table width=100%>
    <tr>
        <td align=LEFT><FONT class=one>
<? $viewstyle=getenv("REQUEST_URI");
if($num_rows>0){
 if (stristr($viewstyle,shoeshowcase)){
echo "<a href=\"/footwear$PATH_INFO\"><B>View the $category_name <BR> with summaries</B></a>";
}else{
echo "<a href=\"/shoeshowcase$PATH_INFO\"><B>View the $category_name <BR> as thumbnail images</B></a>";
}

echo "<P><FONT class=one>$num_rows Items in this category";
}
?>
		</td>
		<td align=right>
&nbsp;
		</td>
	</tr>
</table>

<?
echo "<BR>
<table border=0 cellspacing=0 cellpadding=0 width=\"100%\"> \n";
 //start loop 

$counter=0;

while ($result=mysql_fetch_object($resultfinal)){

                $pagename= str_replace("&#39;","",$result->product_name);
                $pagename= str_replace("\"","",$pagename);
                $pagename= str_replace(",","",$pagename);
                $pagename= str_replace("&quot;","",$pagename);
                $pagename= str_replace("&#34;","",$pagename);
                $pagename= str_replace("&amp;","_",$pagename );
                $pagename= str_replace("&","-",$pagename );
                $pagename= str_replace("--","-",$pagename);
                $pagename= str_replace(" ","-",$pagename);
                $pagename= str_replace("'","",$pagename);

$search_term=($result->product_sku);


$sizequery=mysql_query("SELECT size
FROM sizes s1, size_xref s2
WHERE s2.product_sku='$search_term'
AND s1.size_id=s2.size_id
Order BY size",$dblink) OR die(mysql_error());

$colorquery=mysql_query("SELECT color
FROM colors c1, color_xref c2
WHERE c2.product_sku='$search_term'
AND c1.color_id=c2.color_id
ORDER BY color",$dblink) OR die(mysql_error());

$numcolor=mysql_num_rows($colorquery);
$numsize=mysql_num_rows($sizequery);

if (($numcolor>1)&&($numsize>1)) {
   $cSpan=4;
}else{
   $cSpan=3; 
}

$counter = $counter+1;
if($counter%2==1) echo "<tr>";

?>
	<td valign=top width=325>
<hr>
	<table border=0 cellspacing=2 cellpadding=0 width=325>
	<tr>
		<td colspan=<?= $cSpan ?> width=325 class=catheader valign=bottom>
<A href="/details/1/<?= $result->primary_id ?>/1/<?= $pagename?>.html">
<b><h2><?= ucwords(strtolower($result->product_name)); ?></h2></b></a>
</td>
</tr>
<tr> 
	<td align="center" rowspan=2 width=25%><br>
		<?
if ($result->thumb1){
echo "<A href=\"/details/1/$result->primary_id/1/".$pagename.".html\"
onmouseout=\"window.status ='';return true\"
onmouseover=\"window.status='$pagename'; return true\">
<img src=\"/sexyclothes/$result->thumb1\" alt=\"$result->product_name\" border=0></a>
<br><font class=small>Click image for<br>more detail</font>
";
}else{
echo "no image";
}
		 ?>
	</td>
	<td align="Left" valign=center colspan=3 height=100 bgcolor=#DDDDDD>
				<table width=100% cellpadding=3>
					<tr>
						<td><?
if ($result->product_short_desc2){
echo $result->product_short_desc2;
}else{
echo $result->product_short_desc;
}
?>
<P>
$<?= $result->product_price?>
<P>
<a href="/details/1/<?= $result->primary_id?>/1/<?= $pagename?>.html">more...</a>
<div align=right>
<FONT CLASS=zero>(ref #<?= $result->primary_id ?>)</FONT>

</td>
					</tr>
				</table>
	</td>
</tr>
		
<?
$formname=randomFormName(8);

                $productname= str_replace("&#39;","",$result->product_name);
                $productname= str_replace("&quot;","",$productname);
                $productname= str_replace("&#34;","",$productname);
                $productname= str_replace("&amp;","_",$productname );
                $productname= str_replace("&","_",$productname );
                $productname= str_replace("__","_",$productname);
                $productname= str_replace("__","_",$productname);
				$productname= str_replace("\"","",$productname);
echo "\n\n";
?>

<form method = "post" action = "http://www.paymentclearing.org/cgi-bin/store/index.cgi" name="<?= $formname ?>" >
<input type="hidden" name="continue_shopping_url" value="http://<?= getenv('HTTP_HOST').getenv("REQUEST_URI")?>">
<input type="hidden" name="client_id" value="55242">

<?

if (($numsize>1)||($numcolor>1)){
echo "<tr>
        <td colspan=3 align=LEFT>
<font class=redsmall><b>PLEASE SELECT:</b></font>
        </td>
    </tr>";
}else{
echo "<tr>
        <td colspan=3 align=LEFT>
&nbsp;
        </td>
    </tr>";
}
?>


<tr>
    <td>&nbsp;
    </td>
    <td align=right>
    <font class=zero>Quantity</font>
<SELECT name="item-<?= $result->product_sku ?>|<?= $result->product_price?>|<?= str_replace("\"","",$productname) ?>||||<?= $result->product_price ?>" size="1">
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
</SELECT>
</td>
<?
if ($numsize<2){
echo "<INPUT TYPE=HIDDEN NAME=\"option|1|$result->product_sku\" VALUE=\"size:one size\">
        ";
}else{?>
<td right>
    <select name="option|1|<?= $result->product_sku ?>">
    <option value="<font color=red><b>no size chosen!</b></font>|">Select Size</option>
<?
                    While ($sizeresult=mysql_fetch_object($sizequery)){
                        $sizearray[] = $sizeresult->size;
                    }
                            asort ($sizearray);
                            reset ($sizearray);

                    while (list ($key, $val) = each ($sizearray)) {
                            echo"<option value=\"size:$val|\"> $val</option>\n";
                    }
                    echo"\n</select>
</td>";
}
?>

<?
if ($numcolor>1){
?><td>
  <select name="option|2|<?= $result->product_sku ?>">
  <option value="<font color=red><b>no color chosen!</Font><b>|">Select Color</option>
<?
              While ($colorresult=mysql_fetch_object($colorquery)){
                        $colorarray[] = $colorresult->color;
                    }
                        asort ($colorarray);
                        reset ($colorarray);
                    while (list ($key, $val) = each ($colorarray)) {
              echo"<option value=\"color:$val|\"> $val</option>\n";
                    }
                    echo"\n</select>\n</td>";

}else{
echo "<INPUT TYPE=HIDDEN NAME=\"option|2|$result->product_sku\" VALUE=\"size:as shown\">\n";
}
echo "<INPUT TYPE=HIDDEN NAME=\"option|3|$result->product_sku\" VALUE=\"$ck\">\n";
        ?>


          </tr>
            <tr>

            <td colspan=4 align=right><BR>
<input type="IMAGE" name="add_to_cart_button" value="Add To Cart" src="/images/add.jpg" border="0"
onmouseout="window.status ='';return true"
onmouseover="window.status='Add to your cart'; return true">
&nbsp;
&nbsp;
&nbsp;

            </td>
            </tr>
          </form>

        </td>
        </tr>
        </table>
        </td>
<?
if($counter%2==1) echo "<td width=2>&nbsp;&nbsp;</td>";
if($counter%2==0) echo "</tr>";
$sizearray="";
$colorarray="";

}
?>
                    </table><BR>


<?                // This displays the previous, next, and direct links to each page.
if(!$heel_style){
$heel_style=0;
}
                if (($num_pages<=20)){
                  $pagebreak=20;
                }else{
                  $pagebreak=15;
                }
if ($num_pages>1){

echo "<center>\n
  <table border=\"0\" cellpadding=\"2\" bgcolor=\"#c0c0c0\" cellspacing=\"0\" bordercolor=\"#c0c0c0\">
    <tr>
      <td>";
// Previous
if ($prev_page)  {

  echo "                <table>
                      <tr>
                        <td rowspan=\"5\" bgcolor=\"#c0c0c0\" align=\"center\">&nbsp;&nbsp;
						 <a href=\"/footwear/$heel_height/$heel_style/$prev_page/$catpage$prev_page.html\"
                          onmouseout=\"window.status ='';return true\"
                          onmouseover=\"window.status='Go to Page $prev_page'; return true\">
                          Prev</a>&nbsp;&nbsp;
                        </td>
                      </tr>
                    </table>
      </td>\n";
}
  echo "<td>

  <table border=\"0\" cellpadding=\"4\"cellspacing=\"0\">
    <tr>";
      for ($i = 1; $i <= $num_pages; $i++) {
          if ($i != $page) {
             echo "<td bgcolor=\"#c0c0c0\" align=\"center\">
                <a href=\"/footwear/$heel_height/$heel_style/$i/$catpage$i.html\"
              onmouseout=\"window.status ='';return true\"
              onmouseover=\"window.status='Jump to Page $i'; return true\"
              > $i</a>
              </td>";
              if($i%$pagebreak==0) echo "</tr><tr>";
          } else {
               echo "
              <td bgcolor=\"#000000\" align=\"center\" bordercolor=\"#ff00ff\">
                  <font color=#FFFFFF> <b>$i</b>
            </td>";
             if($i%$pagebreak==0) {
             echo " </tr>
                <tr>";
                }
        }
      }

      if ($i>$pagebreak){
       $plug=intval(($pagebreak-($i%$pagebreak)+1));
        echo "<td colspan=\"$plug\" bgcolor=\"#c0c0c0\">&nbsp;</td>";
      }

echo "
        </tr>
      </table>
    </td>";


  if ($page != $num_pages){
    echo "
    <td>
      <table>
        <tr>
          <td rowspan=\"5\" bgcolor=\"#c0c0c0\" align=\"center\">&nbsp;&nbsp;
		 <a href=\"/footwear/$heel_height/$heel_style/$next_page/$catpage$next_page.html\"
          onmouseout=\"window.status ='';return true\"
          onmouseover=\"window.status='View Next Page'; return true\"
          >Next</a>&nbsp;&nbsp;
          </td>
        </tr>
      </table>
    </td>";
  }
?>


</td></tr>
<table>
<BR>
</td></tr>
<table>
<? } ?>
</td></tr>
<table>
<? }?>                     
					   </BLOCKQUOTE>
                        <P ALIGN="center">
                        </P>
                     </TD>
                  </TR>
               </TABLE>
</td></tr></table>
<? include ("includes/footer.inc"); ?>
<P>&nbsp;</p>
</body>
</HTML>