onArcade scriptini biliyosunuzdur. Bu script kategoriler sayfasında isme göre dizilim yapıyor ve benim yapmak istediğim bu kategori seviyesinde .......... kategorisinde en popüler x oyun şeklinde bir eklenti yapmak istiyorum. PHP bilgim zayıf olduğu için çok kurcalamama rağmen çözümü sağlayamadım.
Kaynak kodlar;
<?php
session_start();
include ("includes/config.php");
$page = $_GET[page];
if (empty($page) || !is_numeric($page)) {
$page = "1";
}
$kategori = $_GET[c];
$idal = mysql_query("SELECT * FROM categories WHERE kategori = '$kategori'");
$idalindi = mysql_fetch_array($idal);
$categoryId = $idalindi['catid'];
if (!is_numeric($categoryId)){
header("Location: ".$siteurl."/");
exit();
}
$sql = mysql_query("SELECT catid, name, kategori, description, keywords, permissions, parentcategory FROM categories WHERE catid = '$categoryId' && status = '1'");
if (mysql_num_rows($sql)) {
$row = mysql_fetch_array($sql);
$categoryname = $row['name'];
$categoryId = $row['catid'];
$kategori = $row['kategori'];
$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,$kategori) {
global $siteurl,$filesperpage,$sefriendly;
$result = mysql_query("SELECT title, oyunadi, icon, iconlocation, fileid, description, timesplayed FROM files WHERE category = '$categoryId' && status ='1'");
if (mysql_num_rows($result) == '0') {
echo "<span style='color:#333333;'>Bu kategoriye en kısa sürede oyun eklenecektir</span>";
} 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 .= "<span class=aktif>$pagen</span>";
} else {
if ($pagen >= $page - 5 && $pagen <= $page + 5) {
if ($sefriendly == '1') {
$nav .= " <a href=\"".categoryurl($kategori)."/index".$pagen.".html\">".$pagen."</a>";
} else {
$nav .= " <a href=\"".categoryurl($kategori)."&page=".$pagen."\">".$pagen."</a>";
}
}
}
}
if ($page > 1) {
$pagen = $page - 1;
if ($sefriendly == '1') {
$prev = "<a href=\"".categoryurl($kategori)."/index".$pagen.".html\">« geri</a>";
} else {
$prev = "<a href=\"".categoryurl($kategori)."&page=".$pagen."\">« geri</a>";
}
} else {
$prev = "<span class=aktif> « önceki </span>";
}
if ($page < $pagescount) {
$pagen = $page + 1;
if ($sefriendly == '1') {
$next = " <a href=\"".categoryurl($kategori)."/index".$pagen.".html\">sonraki »</a>";
} else {
$next = " <a href=\"".categoryurl($kategori)."&page=".$pagen."\">sonraki »</a>";
}
} else {
$next = "<span class=aktif> sonraki » </span>";
}
// Display page numbers
if ($pagescount > '1') {
echo "";
}
$result2 = mysql_query("SELECT fileid, oyunadi, 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'];
$oyunadi = $row['oyunadi'];
if (strlen($filetitle) > '18') {
$filetitle = substr("$filetitle",0,18)."";
}
$ffiletitle = $row['title'];
$oyunadi = $row['oyunadi'];
$filedescription = $row['description'];
$fileicon = $row['icon'];
$siteurlimg = 'files/image';
$iconlocation = $row['iconlocation'];
$timesplayed = number_format($row['timesplayed']);
if ($iconlocation == '1') {
$imageurl = $siteurlimg."/".$fileicon;
} else {
$imageurl = $fileicon;
}
if (strlen($filedescription) > '40') {
$filedescription = substr("$filedescription",0,37)."...";
}
if ($fileinrow == '1') {
echo "";
}
?>
<li><a href="<?php echo fileurl($oyunadi); ?>"><img src="<?php echo $imageurl; ?>" title="<?php echo $ffiletitle; ?>" alt="<?php echo $ffiletitle; ?>" border="0" /><br />
<?php echo $filetitle; ?></a></li>
<?php
if ($fileinrow == '0') {
echo "";
$fileinrow = "0";
}
$fileinrow++;
}
if ($fileinrow == '0') {
echo "";
} elseif ($fileinrow == '0') {
echo "";
}
// Display page numbers
if ($pagescount > '1') {
echo "<!-- sayfa no baslar [+] --><div class='clear'></div><div class='sayfano'>".$prev.$nav.$next."</div><!-- sayfa no biter [-] -->";
}
}
}
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">
Subcategories
</div>
<div class="boxestext">
<?php
while($row = mysql_fetch_array($result)) {
$categoryName = $row['name'];
$catId = $row['catid'];
?>
<img src="<?php echo $siteurl; ?>/images/category.gif" with="16" height="16" title="<?php echo $categoryName; ?>" alt="<?php echo $categoryName; ?>" border="0"/> <a href="<?php echo categoryurl($catId,$categoryName); ?>" target="_self"><?php echo $categoryName; ?></a><br />
<?php
}
?>
</div>
</div>
<?php
}
}
$sitename2 = $categoryname." ".$page." | ".$sitename;
$sitedescription = $categorydescription;
$sitekeywords = $sitekeywords.", ".$categorykeywords;
$anahtar = $categoryname." ".$page;
$fileTitlefoot = $categoryname;
// Load template files
include ("templates/".$template."/ust.html");
include ("templates/".$template."/kategori.html");
include ("templates/".$template."/alt.html");
?>Yardımcı olan arkadaşlarıma çok teşekkür ediyorum şimdiden.