<?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><img src="<?php echo $siteurl; ?>/images/category.gif" with="100" height="100" title="<?php echo $categoryName; ?>" alt="<?php echo $categoryName; ?>" border="0"/></td><td><a href="<?php echo categoryurl($catId,$categoryName); ?>" target="_self"><?php echo $categoryName; ?></a></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");
?>