<?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>  
		<tr>
   <?php  
    $yanyana = 0;  
    while($row = mysql_fetch_array($result)) {  
    $categoryName = $row['name'];  
    $catId = $row['catid']; 
	$yanyana = $yanyana + 1; 
    ?>  
                <td><table><tr><td><img src="<?php echo $siteurl; ?>/images/category.gif" with="100" height="100" title="<?php echo $categoryName; ?>" alt="<?php echo $categoryName; ?>" border="0"/><br /><a href="<?php echo categoryurl($catId,$categoryName); ?>" target="_self"><?php echo $categoryName; ?></a></td></tr></table></td>  
    <?php 
    if ($yanyana % 5 == 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");  
?>