<?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
https://seditio.org
[BEGIN_SED]
File=plugins/adminqv/adminqv.php
Version=179
Updated=2022-jul-15
Type=Plugin
Author=Seditio Team
Description=
[END_SED]
[BEGIN_SED_EXTPLUGIN]
Code=adminqv
Part=main
File=adminqv
Hooks=admin.home
Tags=
Order=10
[END_SED_EXTPLUGIN]
==================== */
if (!defined('SED_CODE')) { die('Wrong URL.'); }
require_once(SED_ROOT . '/plugins/adminqv/lang/adminqv.'.$usr['lang'].'.lang.php');
$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(*)");
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_com WHERE com_date>'$timeback'");
$newcomments = sed_sql_result($sql, 0, "COUNT(*)");
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_date>'$timeback'");
$newpms = sed_sql_result($sql, 0, "COUNT(*)");
$sql = sed_sql_query("SELECT * FROM $db_stats WHERE stat_name LIKE '20%' ORDER BY stat_name DESC LIMIT ".$timeback_stats);
while ($row = sed_sql_fetchassoc($sql))
{
$ty = mb_substr($row['stat_name'], 0, 4);
$tm = mb_substr($row['stat_name'], 5, 2);
$td = mb_substr($row['stat_name'], 8, 2);
$dat = @date('d D', mktime(0,0,0,$tm,$td,$ty));
$hits_d[$dat] = $row['stat_value'];
}
$hits_d_max = max($hits_d);
$sql = sed_sql_query("SHOW TABLES");
while ($row = sed_sql_fetchrow($sql))
{
$table_name = $row[0];
$status = sed_sql_query("SHOW TABLE STATUS LIKE '$table_name'");
$status1 = sed_sql_fetcharray($status);
$tables[] = $status1;
}
$total_length = 0;
$total_rows = 0;
$total_index_length = 0;
$total_fragmented = 0;
$total_data_length = 0;
foreach ($tables as $i => $dat)
{
$table_length = $dat['Index_length']+$dat['Data_length'];
$total_length += $table_length;
$total_rows += $dat['Rows'];
$total_index_length += $dat['Index_length'];
$total_fragmented += $dat['Data_free'];
$total_data_length += $dat['Data_length'];
}
$qv = new XTemplate(SED_ROOT . '/plugins/adminqv/adminqv.tpl');
if (!$cfg['disablereg'])
{
$qv-> assign(array(
"QV_NEWUSERS" => $newusers,
"QV_NEWUSERS_URL" => sed_url("users", "f=all&s=regdate&w=desc")
));
$qv->parse("ADMIN_QV.ADMIN_QV_NEWUSERS");
}
if (!$cfg['disable_page'])
{
$qv-> assign(array(
"QV_NEWPAGES" => $newpages,
"QV_NEWPAGES_URL" => sed_url("admin", "m=page")
));
$qv->parse("ADMIN_QV.ADMIN_QV_NEWPAGES");
}
if (!$cfg['disable_forums'])
{
$qv-> assign(array(
"QV_NEWTOPICS" => $newtopics,
"QV_NEWPOSTS" => $newposts,
"QV_NEWFORUMS_URL" => sed_url("forums")
));
$qv->parse("ADMIN_QV.ADMIN_QV_NEWONFORUMS");
}
if (!$cfg['disable_comments'])
{
$qv-> assign(array(
"QV_NEWCOMMENTS" => $newcomments,
"QV_NEWCOMMENTS_URL" => sed_url("admin", "m=comments")
));
$qv->parse("ADMIN_QV.ADMIN_QV_NEWCOMMENTS");
}
if (!$cfg['disable_pm'])
{
$qv-> assign(array(
"QV_NEWPMS" => $newcomments
));
$qv->parse("ADMIN_QV.ADMIN_QV_NEWPMS");
}
$qv-> assign(array(
"QV_DB_ROWS" => $total_rows,
"QV_DB_INDEXSIZE" => number_format(($total_index_length/1024),1,'.',' '),
"QV_DB_DATASSIZE" => number_format(($total_data_length/1024),1,'.',' '),
"QV_DB_TOTALSIZE" => number_format(($total_length/1024),1,'.',' '),
"QV_DB_TOTALFRAGMENTED" => number_format(($total_fragmented/1024),1,'.',' ')
));
$qv->parse("ADMIN_QV.ADMIN_QV_DB");
if (!$cfg['disablehitstats'])
{
foreach ($hits_d as $day => $hits)
{
$qv-> assign(array(
"QV_HITS_PERCENTBAR" => floor(($hits / $hits_d_max) * 100),
"QV_HITS_DAY" => $day,
"QV_HITS_COUNT" => $hits,
"QV_HITS_URL" => sed_url("admin", "m=hits")
));
$qv->parse("ADMIN_QV.ADMIN_QV_HITS.ADMIN_QV_HITS_DAYLIST");
}
$qv->parse("ADMIN_QV.ADMIN_QV_HITS");
}
$qv->parse("ADMIN_QV");
$t->assign("ADMIN_QV", $qv->text("ADMIN_QV"));
?>