<?PHP

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

[BEGIN_SED]
File=plugins/quickstats.php
Version=121
Updated=2004-apr-02
Type=Plugin.Index
Author=Neocrome
Description=Will display some stats in the home page.
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=quickstats
Part=main
File=quickstats
Hooks=index.tags
Tags=index.tpl:{INDEX_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_pages = sed_sql_rowcount($db_pages);
$plu_count_news = sed_sql_rowcount($db_news);
$plu_count_comments = sed_sql_rowcount($db_com);
$plu_count_links = sed_sql_rowcount($db_links);
$plu_count_users = sed_sql_rowcount($db_users);
$plu_count_tpages = sed_sql_getstat('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 += mysql_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 += mysql_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 = mysql_fetch_array($sqltmp);
$plu_since = $rowtmp['stat_name'];


$plu_quickstats .= "<center>»Site when«<strong><br /></strong></center><br />";
$plu_quickstats .= "» qqqq <strong>".$plu_count_users."</strong><br />";
$plu_quickstats .= "» qqqq <strong>".$plu_count_topics."</strong><br />";
$plu_quickstats .= "» message <strong>".$plu_count_posts."</strong><br />";
$plu_quickstats .= "» totalhit <strong>".$plu_count_tpages."</strong><br />";
$plu_quickstats .= "» qq <strong>".$plu_count_pages."</strong><br />";
$plu_quickstats .= "» qqqqq <strong>".$plu_count_news."</strong><br />";
$plu_quickstats .= "» aaaaaaaaak <strong>".$plu_count_links."</strong><br />";
$plu_quickstats .= "» aaaaa <strong>".$plu_count_comments."</strong><br />";

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

error:Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
$t-> assign(array(
"INDEX_QUICKSTATS" => $plu_quickstats
));

?>

INSERT INTO sed_stats (stat_name, stat_value) VALUES ('totalpages', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('totalmailsent', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('totalmailpmnot', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('totalpms', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('totalantihammer', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('textboxerprev', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('version', '121');