XoopsModules25x / statistics

hits.php

<?php
/*
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */

/**
 * @copyright      {@link https://xoops.org/ XOOPS Project}
 * @license        {@link https://www.gnu.org/licenses/gpl-2.0.html GNU GPL 2 or later}
 * @package
 * @since
 * @author         XOOPS Development Team
 */


use XoopsModules\Statistics\Utility;

/** @var Helper $helper */

require_once dirname(dirname(__DIR__)) . '/mainfile.php';
$GLOBALS['xoopsOption']['template_main'] = 'hits.tpl';
require_once XOOPS_ROOT_PATH . '/header.php';
//require_once __DIR__ . '/include/statutils.php';

$now      = date('d-m-Y');
$dot      = explode('-', $now);
$nowdate  = $dot[0];
$nowmonth = $dot[1];
$nowyear  = $dot[2];

$xoopsTpl->assign('lang_stat_hitdetail', STATS_HITDETAIL);
$xoopsTpl->assign('lang_stat_thissite', $_SERVER['HTTP_HOST']);

$result = $xoopsDB->queryF('SELECT count FROM ' . $xoopsDB->prefix('counter') . " WHERE type='total'");
[$count] = $xoopsDB->fetchRow($result);
$xoopsTpl->assign('lang_stat_recvtotal', $count);

$xoopsTpl->assign('lang_stat_werereceived', STATS_WERERECEIVED);
$xoopsTpl->assign('lang_stat_pageviews', STATS_PAGEVIEWS);
$xoopsTpl->assign('lang_stat_todayis', STATS_TODAYIS);
$xoopsTpl->assign('lang_stat_nowdate', "$nowmonth/$nowdate/$nowyear");

$result = $xoopsDB->queryF('SELECT year, month, hits FROM ' . $xoopsDB->prefix('stats_month') . ' ORDER BY hits DESC LIMIT 0,1');
[$year, $month, $hits] = $xoopsDB->fetchRow($result);
$month = Utility::getMonth($month);
$xoopsTpl->assign('lang_stat_mostmonth', STATS_MOSTMONTH);
$xoopsTpl->assign('lang_stat_mmdata', "$month $year ($hits " . STATS_HITS . ')');

$result = $xoopsDB->queryF('SELECT year, month, date, hits FROM ' . $xoopsDB->prefix('stats_date') . ' ORDER BY hits DESC LIMIT 0,1');
[$year, $month, $date, $hits] = $xoopsDB->fetchRow($result);
$month = Utility::getMonth($month);
$xoopsTpl->assign('lang_stat_mostday', STATS_MOSTDAY);
$xoopsTpl->assign('lang_stat_mddata', "$month $date, $year ($hits " . STATS_HITS . ')');

$result = $xoopsDB->queryF('SELECT year, month, date, hour, hits FROM ' . $xoopsDB->prefix('stats_hour') . ' ORDER BY hits DESC LIMIT 0,1');
[$year, $month, $date, $hour, $hits] = $xoopsDB->fetchRow($result);
$month = Utility::getMonth($month);
$hour  = ($hour < 10 ? "0$hour:00 - 0$hour:59" : "$hour:00 - $hour:59");
$xoopsTpl->assign('lang_stat_mosthour', STATS_MOSTHOUR);
$xoopsTpl->assign('lang_stat_mhdata', "$hour " . STATS_ON . " $month $date, $year ($hits " . STATS_HITS . ')');

$l_size = getimagesize('assets/images/leftbar.gif');
$m_size = getimagesize('assets/images/mainbar.gif');
$r_size = getimagesize('assets/images/rightbar.gif');

// get year stats and display
$resulttotal = $xoopsDB->queryF('SELECT sum(hits) AS totalhitsyear FROM ' . $xoopsDB->prefix('stats_year'));
[$totalhitsyear] = $xoopsDB->fetchRow($resulttotal);

This list assign is not used and could be removed.

$xoopsDB->freeRecordSet($resulttotal);
$result = $xoopsDB->queryF('SELECT year,hits FROM ' . $xoopsDB->prefix('stats_year') . ' ORDER BY year');
$xoopsTpl->assign('lang_stat_yearlystats', STATS_YEARLYSTATS);
$xoopsTpl->assign('lang_stat_yearhead', STATS_YEAR);
$xoopsTpl->assign('lang_stat_pagesviewed', STATS_PAGESVIEWED);
$yearlist = [];
$i        = 0;
while (list($year, $hits) = $xoopsDB->fetchRow($result)) {
    $yearlist[$i]['year'] = $year;
    $yearlist[$i]['hits'] = $hits;
    if ($year != $nowyear) {
        $yearlist[$i]['link'] = "<a href=\"statdetails.php?op=yearlystats&amp;year=$year\">$year</a>";
    } else {
        $yearlist[$i]['link'] = '';
    }
    $midbarsize              = mb_substr(100 * $hits / $count, 0, 5);
    $yearlist[$i]['percent'] = $midbarsize . '%';
    $yearlist[$i]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$year - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$year - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$year - $hits\">";
    ++$i;
}
$xoopsDB->freeRecordSet($result);
$xoopsTpl->assign('yearlist', $yearlist);

Utility::getMonthlyStats($nowyear);
Utility::getDailyStats($nowyear, $nowmonth);
Utility::getHourlyStats($nowyear, $nowmonth, $nowdate);

require_once XOOPS_ROOT_PATH . '/footer.php';