<?
if($ty==1)
{
   $sheading="Latest Pictures";
   $sql="select * from members,photos where members.username=photos.username and approved='Y'  and active=1 order by photos.upldate desc";
   $size=getSetting("LATESTPICSIZE");
}
else if($ty==2)
{
   $sheading="Top 10";
   $sql="select * from members,photos,ratings where members.username=photos.username and photos.photosid=ratings.photosid and numvotes>0  and approved='Y'  and active=1 order by avgrating desc limit 0,10";
}
else if($ty==3)
{
   $sheading="Top Rated Pictures(Men)";
   $sql="select * from members,photos,ratings where members.username=photos.username and photos.photosid=ratings.photosid and numvotes>0 and gender='M'  and approved='Y'  and active=1 order by avgrating desc";
   $size=getSetting("TOPRATEDSIZE");
}
else if($ty==4)
{
   $sheading="Top Rated Pictures(Women)";
   $sql="select * from members,photos,ratings where members.username=photos.username and photos.photosid=ratings.photosid and numvotes>0 and gender='F'  and approved='Y'  and active=1 order by avgrating desc";
   $size=getSetting("TOPRATEDSIZE");
}

$result = mysql_query($sql);
$count=mysql_num_rows($result);

$page="index.php?cmd=10&ty=$ty$lextra";

if(!isset($startindex))$startindex=0;
if($count!=0)$sindex=$startindex+1;else $sindex=0;
if(($startindex+$size)<$count)$eindex=$startindex+$size;else $eindex=$count;

if($startindex>0)$links=$links."<a href='$page&startindex=".($startindex-$size)."$catextra'>Previous $size</a>";else $links=$links."Previous $size";
$links=$links. " | ";
if(($startindex+$size)<$count)$links=$links."<a href='$page&startindex=".($startindex+$size)."$catextra'>Next $size</a>";else $links=$links."Next $size";

$ph="$sindex-$eindex of $count";
if($ty==2)
{
   $links="";
}
else
{
   $sql=$sql. " limit $startindex,$size";
}
?>
<script language="JavaScript">
<!--
function checkall(chktype)
 {
   if (chktype=="1")
   {
   var flag=1;
   }
   else
   {
   if(chktype=="0")
   {
      var flag=0;
   }
   else
   {
   if(document.myform.chkall.checked==true)
    {
      var flag=1;
   }
   else
    {
      var flag=0;
   }    
}}
l=document.myform;
      n=l.elements.length;
   var i=0;
   var j=0;
   for(i=0;i<n;i++)
    {
      ch = "chk["+j+"]";
      if(l.elements[i].name==ch)
       {
         j++;
         l.elements[i].checked=flag;               
       }
    }
 }

function checkifvalid(){
}
</script>
<TABLE width="98%" cellspacing="0" cellpadding="0">
<TBODY>
<TR>
<TD>
<FIELDSET><LEGEND><b><? print $sheading;?></b></LEGEND>
<div>
<div align="center">
<center>
<table width="98%" height="100%" border="0" cellpadding="3" cellspacing="0">
<tr> 
  <td height="20" class="normal">

<table width="95%" border="0" cellpadding="0" cellspacing="0" class="mytable">
        <tr> 
          <td valign="top"> <div align="center"> 
              <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
                <tr class="picsheader" > 
                  <td height="25" >&nbsp;</td>
                  <td width="99" align="left" >Name</td>
                  <td width="99" align="left" >Gender</td>
                  <td width="141" >Profile</td>
                  <td width="157" height="25" align="left" >Rating</td>
                </tr>
                <?
              if($count>0)
              {
               $res=mysql_query($sql);
               $i=0;
               while($obj=mysql_fetch_object($res))
               {
               $username="<a href='index.php?username=$obj->username&phid=$obj->photosid'>$obj->username</a>";
			   $userphoto="<a href='index.php?username=$obj->username&phid=$obj->photosid'><img src='pics/".$obj->filename." ' width='120' height='120' /></a>";
               if($obj->gender=="F")$gender="Female";else $gender="Male";
               $profile="<a href='index.php?cmd=20&username=$obj->username'>View Profile</a>";              
               if($i==0)$altheader="altbg1"; else $altheader="altbg2";
               $photoid=$obj->photosid;
              ?>
                <tr class="<? print $altheader; ?>"> 
                  <td width="1" height="20" >&nbsp;</td>
                  <td width="99" align="left" ><?=$userphoto;?>
                    <? print $username;?></td>
                  <td width="99" align="left" ><? print $gender;?></td>
                  <td width="141" ><? print $profile;?></td>
                  <td width="157" height="20" align="left" ><? print getRating($photoid);?></td>
                </tr>
                <?
              $i++;
              if($i==2)$i=0;
               }
               if($links!="")
               {
               ?>
                <tr > 
                  <td width="1" height="25" class="normal">&nbsp;</td>
                  <td height="25" colspan="2" align="left" valign="middle" class="normal">&nbsp; 
                  </td>
                  <td height="25" colspan="2" align="right" valign="middle" class="normal"><? print $ph;?>&nbsp;&nbsp;&nbsp;&nbsp;<? print $links;?></td>
                </tr>
                <?
              }
              }
              else
              {
              ?>
                <tr > 
                  <td width="1" class="normal">&nbsp;</td>
                  <td colspan="4" class="normal">No Pictures Found!</td>
                </tr>
                <?
              }
              ?>
              </table>
            </div></td>
        </tr>
      </table>


</td>
</tr>
</table>
</center>
</div>
</div>
 </FIELDSET>
      </TD> 
    </TR> 
  </TBODY>
</TABLE>