<?PHP

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

[BEGIN_SED]
File=plugins/quickstats/quickstats.php
Version=
Updated=
Type=Plugin
Author=
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=quickstats
Part=main
File=quickstats
Hooks=header.tags
Tags=header.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_sections = sed_sql_rowcount($db_forum_sections);
$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"]));

$banliuye= 0;
$sql = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='3' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$banliuye++;
}
$onaysiz= 0;
$sql = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='2' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$onaysiz++;
}

$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++;
}

$timeback = $sys['now_offset'] - (7 * 86400); // 7 days
$timeback_stats = 15; // 15 days

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_users WHERE user_regdate>'$timeback'");
$newusers = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_date >'$timeback'");
$newpages = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_topics WHERE ft_creationdate>'$timeback'");
$newtopics = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_updated>'$timeback'");
$newposts = sed_sql_result($sql, 0, "COUNT(*)");

$plu_quickstats = "<font color=yellow>></font>  <font color=red><b> Toplam ?yemiz =></b></font> <strong> ".$plu_count_users."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Banlanm?? ?yeler => <strong> ".$banliuye."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Onay Bekleyen ?yeler => <strong> ".$onaysiz."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Son ?yemiz => <strong>".$latestuser."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Kategorisi => <strong>".$plu_count_sections."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Konusu => <strong>".$plu_count_topics."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Mesaj? => <strong>".$plu_count_posts."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Sayfalar => <strong>".$iii."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  A?ili? Tarihi => <strong>18 Ekim 2009</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam G?sterim => <strong>".$plu_count_tpages."</strong><br /><br />";
$plu_quickstats .= "<font color=yellow>></font><strong><font color=\"#FF0000\"><b>Son 7 G?nde</b></font></strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni ?yeler => <strong>".$newusers ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Sayfalar => <strong>".$newpages ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Konular? => <strong>".$newtopics ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Mesajlar? => <strong>".$newposts ."</strong><br />";

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


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

?>