<?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");
?>şimdi kontrol et bakalım benim test etme imkanım olmadığından kodları yazıp attım umarım olur..
)
