<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/hitsayfalar/hitsayfalar.php
Version=121
Updated=2007
Type=Plugin
Author=Kaan
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=hitsayfalar
Part=main
File=hitsayfalar
Hooks=header.tags
Tags=header.tpl: {Plugin_Kaan_Ntka_Org}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]

==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

require_once("plugins/hitsayfalar/lang/hitsayfalar.tr.lang.php");
$plugin_title = $L['plu_title'];

// Top pages

$sql = sed_sql_query("SELECT page_id, page_cat, page_title, page_count FROM $db_pages WHERE page_state='0' ORDER by page_count DESC LIMIT ".$cfg['plugin']['hitsayfalar']['maxlines']);

$plugin_hitsayfalar .= "<h4>".$L['plu_title_pages']."</h4><table class=\"cells\"><tr>";
$plugin_hitsayfalar .= "<td style=\"width:5%;\" class=\"coltop\">No</td>";
$plugin_hitsayfalar .= "<td style=\"width:60%;\" class=\"coltop\">".$L['Page']."</td>";
$plugin_hitsayfalar .= "<td style=\"width:10%;\" class=\"coltop\">Hit</td></tr>";

$ii = 1;

while ($row = sed_sql_fetcharray($sql))
{
$plugin_hitsayfalar .= "<tr><td style=\"text-align:center;\">".$ii."</td>";
$plugin_hitsayfalar .= "<td><a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), 23))."</a></td>";

$plugin_hitsayfalar .= "<td style=\"text-align:center;\">".$row['page_count']."</td></tr>";
$ii++;
}

$plugin_hitsayfalar .= "</table>";




// Top Downloads

$sql = sed_sql_query("SELECT page_id, page_cat, page_title, page_filecount FROM $db_pages WHERE  page_file='1' AND page_state='0' ORDER by page_filecount DESC LIMIT ".$cfg['plugin']['hitsayfalar']['maxlines']);

$plugin_hitsayfalar .= "<h4>".$L['plu_title_downloads']."</h4><table class=\"cells\"><tr>";
$plugin_hitsayfalar .= "<td style=\"width:5%;\" class=\"coltop\">No</td>";
$plugin_hitsayfalar .= "<td style=\"width:60%;\" class=\"coltop\">".$L['File']."</td>";
$plugin_hitsayfalar .= "<td style=\"width:10%;\" class=\"coltop\">Hit</td></tr>";

$ii = 1;
while ($row = sed_sql_fetcharray($sql))
{
$plugin_hitsayfalar .= "<tr><td style=\"text-align:center;\">".$ii."</td>";
$plugin_hitsayfalar .= "<td><a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), 20))."</a>";
$plugin_hitsayfalar .= " (<a href=\"page.php?id=".$row['page_id']."&amp;a=dl\">".$L['Download']."</a>)";
$plugin_hitsayfalar .= "<td style=\"text-align:center;\">".$row['page_filecount']."</td></tr>";
$ii++;
}


$plugin_body .= "</table>";


// Top pages rated

$sql1 = sed_sql_query("SELECT rating_code, rating_average FROM $db_ratings WHERE rating_code LIKE 'p%' ORDER by rating_average DESC LIMIT ".$cfg['plugin']['hitsayfalar']['maxlines']);




$plugin_hitsayfalar .= "<table class=\"cells\"><tr><h4>".$L['plu_title_rated']."</h4>";
$plugin_hitsayfalar .= "<td style=\"width:5%;\" class=\"coltop\">No</td>";
$plugin_hitsayfalar .= "<td style=\"width:20%;\" class=\"coltop\">".$L['Page']."</td>";
$plugin_hitsayfalar .= "<td style=\"width:5%;\" class=\"coltop\">Hit</td></tr>";

$ii = 1;
while ($row1 = sed_sql_fetcharray($sql1))
{
$rating_code = $row1['rating_code'];
$rating_average = $row1['rating_average'];
$rating_image = "<img src=\"skins/$skin/img/system/vote".round($rating_average,0).".gif\" alt=\"\">";
$id = substr ($rating_code,1,strlen($rating_code)-1);

$sql = sed_sql_query("SELECT page_id, page_cat, page_title FROM $db_pages WHERE page_id='$id' LIMIT 1", "Plugin/toprated");

$row = sed_sql_fetcharray($sql);

if (empty($cat) || (!empty($cat) && $page_cat== $cat))
{
$plugin_hitsayfalar .= "<tr><td style=\"text-align:center;\">".$ii."</td>";
$plugin_hitsayfalar .= "<td><a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), 23))."</a></td>";



$plugin_hitsayfalar .= "<td>".$rating_average."</td></tr>";
$ii++;
}
}

$plugin_hitsayfalar .= "</table>";


$t-> assign(array(
"Plugin_Kaan_Ntka_Org" => $plugin_hitsayfalar));

?>