<?PHP

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

[BEGIN_SED]
File=plugins/quickstats/quickstats.php
Version=122
Updated=12.11.2008
Type=Plugin
Author=Aragorn-pc
Description=Aragorn-pc
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=quickstats
Part=main
File=quickstats
Hooks=index.tags
Tags=index.tpl:{PLUGIN_QUICKSTATS}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */

if ( !defined('SED_CODE') ) { die("Hacking attempt."); }

$evil_p = sed_import('plu_quickstats','P','HTM');
$evil_g = sed_import('plu_quickstats','G','HTM');

if (!$plu_quickstats || !empty($evil_g) || !empty($evil_p))
{
$plu_count_users = sed_sql_rowcount($db_users);
$plu_count_tpages = sed_stat_get('totalpages');
$plu_count_topics = sed_sql_rowcount($db_forum_topics);
$plu_count_posts = sed_sql_rowcount($db_forum_posts);
$sqltmp = sed_sql_query("SELECT SUM(fs_topiccount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_topics += sed_sql_result($sqltmp, 0, "SUM(fs_topiccount_pruned)");
$sqltmp = sed_sql_query("SELECT SUM(fs_postcount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_posts += sed_sql_result($sqltmp, 0, "SUM(fs_postcount_pruned)");
$sqltmp = sed_sql_query("SELECT stat_name FROM $db_stats WHERE stat_name LIKE '20%' ORDER BY stat_name ASC LIMIT 1", "Plugin/statistics");
$rowtmp = sed_sql_fetcharray($sqltmp);
$plu_since = $rowtmp['stat_name'];
$sqltmp = sed_sql_query("SELECT user_name,user_id FROM $db_users WHERE user_maingrp!=2 ORDER by user_regdate DESC LIMIT 1");
$row=sed_sql_fetcharray($sqltmp);
$latestuser = sed_build_user($row["user_id"], stripslashes($row["user_name"]));
$plu_since = $rowtmp['stat_name'];
$totaldbpages = sed_sql_rowcount($db_pages);
$totaldbcomments = sed_sql_rowcount($db_com);
$totalmailsent = sed_stat_get('totalmailsent');
$ii = 0;
$sql = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='1' AND page_state='0' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$ii++;
}

$iii = 0;
$sql = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='0' AND page_state='0' AND page_cat NOT LIKE 'news' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$iii++;
}
$siirler = 0;
$sql = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='0' AND page_state='0' AND page_cat NOT LIKE 'siirler' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$siirler++;
}

$haber= 0;
$sql = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='0' AND page_state='0' AND page_cat='news' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$haber++;
}



$plu_quickstats = "<table border='0' class=\"cells\" width='100%' cellspacing='0' cellpadding='2'>";
$plu_quickstats .= "<tr><td><b>  Son ?yemiz: <strong>".$L['fbs_newestmember']." ".$latestuser."<br /></b>";
$plu_quickstats .= "".$L['fbs_mostonline']."<b> Online Rekoru: <strong>".$maxusers."</strong><br />";
$plu_quickstats .= " Forum Konusu: <strong>".$plu_count_topics."</strong><br />";
$plu_quickstats .= " Forum Mesaj?: <strong>".$plu_count_posts."</strong><br />";
$plu_quickstats .= " Toplam Haber: <strong>".$haber."</strong><br />";
$plu_quickstats .= " Toplam Dosya: <strong>".$ii."</strong><br />";
$plu_quickstats .= " Toplam D?k?man: <strong>".$iii."</strong><br />";
$plu_quickstats .= " Toplam ?iir: <strong>382</strong><br />";
$plu_quickstats .= " Toplam ?ye: <strong><a href='uye.php'>".$plu_count_users."</strong></a><br />";
$plu_quickstats .= " Toplam Sayfalar: <strong>".$totaldbpages."</strong><br />";
$plu_quickstats .= " Top.G?n.Mail: <strong>".$totalmailsent."</strong><br />";
$plu_quickstats .= " Toplam G?sterim: <strong>".$plu_count_tpages."</strong><br />";
$plu_quickstats .= "A?ili? Tarihi: <strong>".$plu_since."</strong></tr>";
$plu_quickstats .= "</tr></td></table>";

sed_cache_store('plu_quickstats', $plu_quickstats, 1200);
}


$t-> assign(array(
"PLUGIN_QUICKSTATS" => $plu_quickstats,
));

?>