<?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=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'];

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

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

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

$plu_quickstats = "<table border='0' class=\"cells\" width='100%' cellspacing='0' cellpadding='1' align='center'>";
$plu_quickstats .= "<tr><td class=\"coltop\"><center>Site Kuruluş Tarihi: <br /> <strong>28 Haziran 2008 </strong> </center><br /></tr></td>";
$plu_quickstats .= "<tr><td>» Toplam: <strong>".$plu_count_users." Kayıtlı Üye</strong><br />";
$plu_quickstats .= "» Yasaklı: <strong>".$banliuye." </strong>Üye<br />";
$plu_quickstats .= "» Toplam Gösterim: <strong>".$plu_count_tpages."</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 .= "</tr></td></table>";

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


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

?>