<?php 
session_start(); 
include ("includes/config.php"); 
$page = $_GET[page]; 
if (empty($page) || !is_numeric($page)) { 
        $page = "1"; 
} 
$categoryId = $_GET[c]; 
if (!is_numeric($categoryId)){ 
    header("Location: ".$siteurl."/"); 
    exit(); 
} 
        $sql = mysql_query("SELECT name, description, keywords, permissions, parentcategory FROM categories WHERE catid = '$categoryId' && status = '1'"); 
        if (mysql_num_rows($sql)) { 
            $row = mysql_fetch_array($sql); 
                $categoryname = $row['name']; 
                $categorydescription = $row['description']; 
                $categorykeywords = $row['keywords']; 
                $cpermissions = $row['permissions']; 
                $cparentcategory = $row['parentcategory']; 
                if ($cparentcategory != '0') { 
                    $category_sql = mysql_query("SELECT name FROM categories WHERE catid = '$cparentcategory'"); 
                        $category_row = mysql_fetch_array($category_sql); 
                        $cparentcategoryname = $category_row['name']; 
                        $cparentcategoryname = "<a href=\"".categoryurl($cparentcategory,$cparentcategoryname)."\" class=\"contentheaderlink\">".$cparentcategoryname."</a> > "; 
                } else { 
                    $cparentcategoryname = ""; 
                } 
    } else { 
            header("Location: ".$siteurl."/"); 
                exit(); 
    } 
// Display games 
function displaygames($categoryId,$page,$categoryname) { 
        global $siteurl,$filesperpage,$sefriendly; 
        $result = mysql_query("SELECT title, icon, iconlocation, fileid, description, timesplayed FROM files WHERE category = '$categoryId' && status ='1'"); 
        if (mysql_num_rows($result) == '0') { 
                echo "There are no files in this category"; 
        } else { 
                // Get number of pages 
                $numrows = mysql_num_rows($result); 
                $offset = ($page - 1) * $filesperpage; 
                $pagescount = ceil($numrows/$filesperpage); 
                for ($pagen = 1; $pagen <= $pagescount; $pagen++) { 
                        if ($pagen == $page) { 
                                $nav .= " <b>$pagen</b>"; 
            } else { 
                if ($pagen >= $page - 5 && $pagen <= $page + 5) { 
                                    if ($sefriendly == '1') { 
                                            $nav .= " <a href=\"".categoryurl($categoryId,$categoryname)."/".$pagen.".html\">".$pagen."</a>"; 
                                        } else { 
                                            $nav .= " <a href=\"".categoryurl($categoryId,$categoryname)."&page=".$pagen."\">".$pagen."</a>"; 
                                        } 
                            } 
                } 
        } 
        if ($page > 1) { 
                $pagen = $page - 1; 
                if ($sefriendly == '1') { 
                        $prev = "<a href=\"".categoryurl($categoryId,$categoryname)."/1.html\"><<</a> <a href=\"".categoryurl($categoryId,$categoryname)."/".$pagen.".html\"><</a>"; 
                    } else { 
                            $prev = "<a href=\"".categoryurl($categoryId,$categoryname)."&page=1\"><<</a> <a href=\"".categoryurl($categoryId,$categoryname)."&page=".$pagen."\"><</a>"; 
                        } 
            } else { 
                    $prev  = ""; 
                } 
                if ($page < $pagescount) { 
                        $pagen = $page + 1; 
                        if ($sefriendly == '1') { 
                        $next = " <a href=\"".categoryurl($categoryId,$categoryname)."/".$pagen.".html\">></a> <a href=\"".categoryurl($categoryId,$categoryname)."/".$pagescount.".html\">>></a>"; 
                    } else { 
                            $next = " <a href=\"".categoryurl($categoryId,$categoryname)."&page=".$pagen."\">></a> <a href=\"".categoryurl($categoryId,$categoryname)."&page=".$pagescount."\">>></a>"; 
                        } 
                } else { 
                        $next = ""; 
                } 
    // Display page numbers 
    if ($pagescount > '1') { 
            echo "<tr><td colspan='3' class='pagenumbers'>".$prev.$nav.$next."</td></tr>"; 
    } 
        $result2 = mysql_query("SELECT fileid, title, description, icon, iconlocation, timesplayed FROM files WHERE category = '$categoryId' && status ='1' ORDER BY title LIMIT $offset, $filesperpage"); 
                $fileinrow="1"; 
    while($row = mysql_fetch_array($result2)) { 
            $fileid = $row['fileid']; 
        $filetitle = $row['title']; 
        $filedescription = $row['description']; 
        $fileicon = $row['icon']; 
        $iconlocation = $row['iconlocation']; 
        $timesplayed = number_format($row['timesplayed']); 
        if ($iconlocation == '1') { 
                $imageurl = $siteurl."/files/image/".$fileicon; 
        } else { 
                $imageurl = $fileicon; 
        } 
        if (strlen($filedescription) > '40') { 
                $filedescription = substr("$filedescription",0,37)."..."; 
        } 
        if ($fileinrow == '1') { 
             echo "<tr>"; 
        } 
    ?> 
    <td width="33%" valign="top"> 
      <table class="browsegamesbox"> 
        <tr> 
          <td width="71"> 
          <a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self"><img src="<?php echo $imageurl; ?>" width="70" height="59" title="<?php echo $filetitle; ?>" alt="<?php echo $filetitle; ?>" border="0"></a> 
          </td> 
          <td valign="top"> 
          <a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self" class="gamelink"><?php echo $filetitle; ?></a><br /> 
          <?php echo $filedescription; ?><br /> 
          <span class="played">(Oynandi: <?php echo $timesplayed; ?> Kere)</span> 
          </td> 
        </tr> 
      </table> 
    </td> 
    <?php 
        if ($fileinrow == '3') { 
             echo "</tr>"; 
             $fileinrow = "0"; 
        } 
        $fileinrow++; 
    } 
    if ($fileinrow == '2') { 
            echo "<td width=\"33%\"></td><td width=\"33%\"></td></tr>"; 
    } elseif ($fileinrow == '3') { 
            echo "<td width=\"33%\"></td></tr>"; 
    } 
    // Display page numbers 
    if ($pagescount > '1') { 
            echo "<tr><td colspan='3' class='pagenumbers'>".$prev.$nav.$next."</td></tr>"; 
    } 
    } 
} 
function subcategories($categoryId,$userStatus) { 
  global $siteurl; 
  if ($userStatus == '1') { 
                $result = mysql_query("SELECT name, catid FROM categories WHERE status = '1' && parentcategory = '$categoryId' ORDER BY catorder, name"); 
        } else { 
                $result = mysql_query("SELECT name, catid FROM categories WHERE status = '1' && permissions = '1' && parentcategory = '$categoryId' ORDER BY catorder, name"); 
        } 
        if (mysql_num_rows($result)) { 
  ?> 
 <div class="contentbox"> 
  <div class="contentheader"> 
   Alt Kategoriler 
  </div> 
   <div class="boxestext"> 
   <table> 
   <?php 
    $yanyana = 0; 
    $yanyana = $yanyana + 1; 
    while($row = mysql_fetch_array($result)) { 
    $categoryName = $row['name']; 
    $catId = $row['catid']; 
    ?> 
        <tr> 
                <td><P align=justify><img src="<?php echo $siteurl; ?>/images/category.gif" with="100" height="100" title="<?php echo $categoryName; ?>" alt="<?php echo $categoryName; ?>" border="0"/><a href="<?php echo categoryurl($catId,$categoryName); ?>" target="_self"><?php echo $categoryName; ?></a></p></td> 
    <?php 
    if ($yanyana % 2 == 0) 
{ 
echo "</tr></tr>"; 
} 
    } 
    ?> 
        </div> 
        </div> 
  <?php 
  } 
} 
        $sitename2 = $sitename." - ".$categoryname; 
        $sitedescription = $categorydescription; 
        $sitekeywords = $sitekeywords.", ".$categorykeywords; 
        // Load template files 
include ("templates/".$template."/header.html"); 
if ($cpermissions == '2' && $userStatus == '0') { 
    include ("templates/".$template."/logintosee.html"); 
} else { 
    include ("templates/".$template."/browse.html"); 
} 
include ("templates/".$template."/footer.html"); 
?>