Issues in Utility.php (master) - Issues in master - XoopsModules25x/statistics - Measure and Improve Code Quality continuously with Scrutinizer

Issues (132)

Security Analysis not enabled

File Inclusion

File Inclusion enables an attacker to inject custom files into PHP's file loading mechanism, either explicitly passed to include, or for example via PHP's auto-loading mechanism.

Regex Injection

Regex Injection enables an attacker to execute arbitrary code in your PHP process.

SQL Injection

SQL Injection enables an attacker to execute arbitrary SQL code on your database server gaining access to user data, or manipulating user data.

Response Splitting

Response Splitting can be used to send arbitrary responses.

File Manipulation

File Manipulation enables an attacker to write custom data to files. This potentially leads to injection of arbitrary code on the server.

Object Injection

Object Injection enables an attacker to inject an object into PHP code, and can lead to arbitrary code execution, file exposure, or file manipulation attacks.

File Exposure

File Exposure allows an attacker to gain access to local files that he should not be able to access. These files can for example include database credentials, or other configuration files.

XML Injection

XML Injection enables an attacker to read files on your local filesystem including configuration files, or can be abused to freeze your web-server process.

Code Injection

Code Injection enables an attacker to execute arbitrary code on the server.

Variable Injection

Variable Injection enables an attacker to overwrite program variables with custom data, and can lead to further vulnerabilities.

XPath Injection

XPath Injection enables an attacker to modify the parts of XML document that are read. If that XML document is for example used for authentication, this can lead to further vulnerabilities similar to SQL Injection.

Other Vulnerability

This category comprises other attack vectors such as manipulating the PHP runtime, loading custom extensions, freezing the runtime, or similar.

Command Injection

Command Injection enables an attacker to inject a shell command that is execute with the privileges of the web-server. This can be used to expose sensitive data, or gain access of your server.

LDAP Injection

LDAP Injection enables an attacker to inject LDAP statements potentially granting permission to run unauthorized queries, or modify content inside the LDAP tree.

Cross-Site Scripting

Cross-Site Scripting enables an attacker to inject code into the response of a web-request that is viewed by other users. It can for example be used to bypass access controls, or even to take over other users' accounts.

Header Injection

Unfortunately, the security analysis is currently not available for your project. If you are a non-commercial open-source project, please contact support to gain access.

class/Utility.php (6 issues)

Labels

Severity

Minor 6

<?php

namespace XoopsModules\Statistics;

use XoopsModules\Statistics;
use XoopsModules\Statistics\Common;
use XoopsModules\Statistics\Constants;

/**
 * Class Utility
 */
class Utility extends Common\SysUtility
{
    //--------------- Custom module methods -----------------------------

public static function getMonthlyStats($year)
    {
        global $xoopsDB, $xoopsTpl;

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

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

        // get monthly stats and display
        $resultmonth = $xoopsDB->queryF('select sum(hits) as totalhitsmonth from ' . $xoopsDB->prefix('stats_month') . " where year='$year'");
        [$totalhitsmonth] = $xoopsDB->fetchRow($resultmonth);
        $xoopsDB->freeRecordSet($resultmonth);
        $result = $xoopsDB->queryF('select month,hits from ' . $xoopsDB->prefix('stats_month') . " where year='$year'");
        $xoopsTpl->assign('lang_stat_monthlystats', STATS_MONTHLYSTATS . '&nbsp;-&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_monthhead', STATS_MONTH);
        $resulttotal = $xoopsDB->queryF('select hits from ' . $xoopsDB->prefix('stats_year') . " where year='$year'");
        [$hitsforyear] = $xoopsDB->fetchRow($resulttotal);
        $monthlist = [];
        $i         = 0;
        while (list($month, $hits) = $xoopsDB->fetchRow($result)) {
            $monthlist[$i]['month'] = getMonth($month);
            $monthlist[$i]['hits']  = $hits;
            if ($month != $nowmonth) {
                $monthlist[$i]['link'] = "<a href=\"statdetails.php?op=monthlystats&year=$year&month=$month\">" . $monthlist[$i]['month'] . '</a>';
            } else {
                $monthlist[$i]['link'] = '';
            }

            $midbarsize               = mb_substr(100 * $hits / $hitsforyear, 0, 5);
            $monthlist[$i]['percent'] = $midbarsize . '%';
            $m_name                   = getMonth($month);
            $monthlist[$i]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$m_name - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$m_name - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$m_name - $hits\">";
            ++$i;
        }
        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('monthlist', $monthlist);
    }

public static function getDailyStats($year, $month)
    {
        global $xoopsDB, $xoopsTpl;

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

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

        // get the daily stats and show
        $resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitsdate from ' . $xoopsDB->prefix('stats_date') . " where year='$year' and month='$month'");
        [$totalhitsdate] = $xoopsDB->fetchRow($resulttotal);
        $xoopsDB->freeRecordSet($resulttotal);
        $result = $xoopsDB->queryF('select year,month,date,hits from ' . $xoopsDB->prefix('stats_date') . " where year='$year' and month='$month' order by date");
        $total  = $xoopsDB->getRowsNum($result);

        $xoopsTpl->assign('lang_stat_dailystats', STATS_DAILYSTATS . '&nbsp;-&nbsp;' . getMonth($month) . '&nbsp;-&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_dailyhead', STATS_DAILY);
        $dailylist = [];
        $i         = 0;
        while (list($year, $month, $date, $hits) = $xoopsDB->fetchRow($result)) {
            $dailylist[$i]['year']  = $year;
            $dailylist[$i]['month'] = getMonth($month);
            $dailylist[$i]['date']  = $date;
            $dailylist[$i]['hits']  = $hits;
            if ($date != $nowdate) {
                $dailylist[$i]['link'] = "<a href=\"statdetails.php?op=dailystats&year=$year&month=$month&date=$date\">" . $date . '</a>';
            } else {
                $dailylist[$i]['link'] = '';
            }
            $midbarsize               = mb_substr(100 * $hits / $totalhitsdate, 0, 5);
            $dailylist[$i]['percent'] = $midbarsize . '%';
            $dailylist[$i]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$date - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$date - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$date - $hits\">";
            ++$i;
        }
        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('dailylist', $dailylist);
    }

public static function getHourlyStats($year, $month, $date)
    {
        global $xoopsDB, $xoopsTpl;

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

        $now = date('d-m-Y');

        // show hourly stats and display
        $resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitshour from ' . $xoopsDB->prefix('stats_hour') . " where year='$year' and month='$month' and date='$date'");
        [$totalhitshour] = $xoopsDB->fetchRow($resulttotal);
        $xoopsDB->freeRecordSet($resulttotal);
        $date_arr = explode('-', $now);

        $xoopsTpl->assign('lang_stat_hourlystats', STATS_HOURLYSTATS . '&nbsp;-&nbsp;' . getMonth($month) . '&nbsp;' . $date . '&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_hourlyhead', STATS_HOURLY);
        $hourlist = [];

        for ($k = 0; $k <= 23; ++$k) {
            $result = $xoopsDB->queryF('select hour,hits from ' . $xoopsDB->prefix('stats_hour') . " where year='$year' and month='$month' and date='$date' and hour='$k'");
            if (0 == $xoopsDB->getRowsNum($result)) {
                $hits = 0;
                $hour = $k;
            } else {
                [$hour, $hits] = $xoopsDB->fetchRow($result);
            }

            $a                    = (($k < 10) ? "0$k" : $k);
            $hourlist[$k]['hour'] = "$a:00 - $a:59";

            $a = '';


            $midbarsize              = ((0 == $hits) ? 0 : mb_substr(100 * $hits / $totalhitshour, 0, 5));
            $hourlist[$k]['hits']    = $hits;
            $hourlist[$k]['percent'] = $midbarsize . '%';
            $hourlist[$k]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$hour - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$hour - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$hour - $hits\">";
        }

        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('hourlist', $hourlist);
    }

public static function getBlockedMonthlyStats($year)
    {
        global $xoopsDB, $xoopsTpl;

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

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

        // get monthly stats and display
        $resultmonth = $xoopsDB->queryF('select sum(hits) as totalhitsmonth from ' . $xoopsDB->prefix('stats_blockedmonth') . " where year='$year'");
        [$totalhitsmonth] = $xoopsDB->fetchRow($resultmonth);
        $xoopsDB->freeRecordSet($resultmonth);
        $result = $xoopsDB->queryF('select month,hits from ' . $xoopsDB->prefix('stats_blockedmonth') . " where year='$year'");
        $xoopsTpl->assign('lang_stat_monthlystats', STATS_BLOCKEDMONTHLYSTATS . '&nbsp;-&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_monthhead', STATS_MONTH);
        $resulttotal = $xoopsDB->queryF('select hits from ' . $xoopsDB->prefix('stats_blockedyear') . " where year='$year'");
        [$hitsforyear] = $xoopsDB->fetchRow($resulttotal);
        $monthlist = [];
        $i         = 0;
        while (list($month, $hits) = $xoopsDB->fetchRow($result)) {
            $monthlist[$i]['month'] = getMonth($month);
            $monthlist[$i]['hits']  = $hits;
            if ($month != $nowmonth) {
                $monthlist[$i]['link'] = "<a href=\"statdetails.php?op=b_monthlystats&year=$year&month=$month\">" . $monthlist[$i]['month'] . '</a>';
            } else {
                $monthlist[$i]['link'] = '';
            }

            $midbarsize               = mb_substr(100 * $hits / $hitsforyear, 0, 5);
            $monthlist[$i]['percent'] = $midbarsize . '%';
            $m_name                   = getMonth($month);
            $monthlist[$i]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$m_name - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$m_name - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$m_name - $hits\">";
            ++$i;
        }
        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('monthlist', $monthlist);
    }

public static function getBlockedDailyStats($year, $month)
    {
        global $xoopsDB, $xoopsTpl;

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

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

        // get the daily stats and show
        $resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitsdate from ' . $xoopsDB->prefix('stats_blockeddate') . " where year='$year' and month='$month'");
        [$totalhitsdate] = $xoopsDB->fetchRow($resulttotal);
        $xoopsDB->freeRecordSet($resulttotal);
        $result = $xoopsDB->queryF('select year,month,date,hits from ' . $xoopsDB->prefix('stats_blockeddate') . " where year='$year' and month='$month' order by date");
        $total  = $xoopsDB->getRowsNum($result);

        $xoopsTpl->assign('lang_stat_dailystats', STATS_BLOCKEDDAILYSTATS . '&nbsp;-&nbsp;' . getMonth($month) . '&nbsp;-&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_dailyhead', STATS_DAILY);
        $dailylist = [];
        $i         = 0;
        while (list($year, $month, $date, $hits) = $xoopsDB->fetchRow($result)) {
            $dailylist[$i]['year']  = $year;
            $dailylist[$i]['month'] = getMonth($month);
            $dailylist[$i]['date']  = $date;
            $dailylist[$i]['hits']  = $hits;
            if ($date != $nowdate) {
                $dailylist[$i]['link'] = "<a href=\"statdetails.php?op=b_dailystats&year=$year&month=$month&date=$date\">" . $date . '</a>';
            } else {
                $dailylist[$i]['link'] = '';
            }
            $midbarsize               = mb_substr(100 * $hits / $totalhitsdate, 0, 5);
            $dailylist[$i]['percent'] = $midbarsize . '%';
            $dailylist[$i]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$date - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$date - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$date - $hits\">";
            ++$i;
        }
        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('dailylist', $dailylist);
    }

public static function getBlockedHourlyStats($year, $month, $date)
    {
        global $xoopsDB, $xoopsTpl;

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

        $now = date('d-m-Y');

        // show hourly stats and display
        $resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitshour from ' . $xoopsDB->prefix('stats_blockedhour') . " where year='$year' and month='$month' and date='$date'");
        [$totalhitshour] = $xoopsDB->fetchRow($resulttotal);
        $xoopsDB->freeRecordSet($resulttotal);
        $date_arr = explode('-', $now);

        $xoopsTpl->assign('lang_stat_hourlystats', STATS_BLOCKEDHOURLYSTATS . '&nbsp;-&nbsp;' . getMonth($month) . '&nbsp;' . $date . '&nbsp;' . $year);
        $xoopsTpl->assign('lang_stat_hourlyhead', STATS_HOURLY);
        $hourlist = [];

        for ($k = 0; $k <= 23; ++$k) {
            $result = $xoopsDB->queryF('select hour,hits from ' . $xoopsDB->prefix('stats_blockedhour') . " where year='$year' and month='$month' and date='$date' and hour='$k'");
            if (0 == $xoopsDB->getRowsNum($result)) {
                $hits = 0;
                $hour = $k;
            } else {
                [$hour, $hits] = $xoopsDB->fetchRow($result);
            }

            $a                    = (($k < 10) ? "0$k" : $k);
            $hourlist[$k]['hour'] = "$a:00 - $a:59";

            $a = '';


            $midbarsize              = ((0 == $hits) ? 0 : mb_substr(100 * $hits / $totalhitshour, 0, 5));
            $hourlist[$k]['hits']    = $hits;
            $hourlist[$k]['percent'] = $midbarsize . '%';
            $hourlist[$k]['graph']   = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$hour - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$hour - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$hour - $hits\">";
        }

        $xoopsDB->freeRecordSet($result);
        $xoopsTpl->assign('hourlist', $hourlist);
    }

public static function getMonth($month)
    {
        switch ($month) {
            case 1:
                return STATS_JANUARY;
            case 2:
                return STATS_FEBRUARY;
            case 3:
                return STATS_MARCH;
            case 4:
                return STATS_APRIL;
            case 5:
                return STATS_MAY;
            case 6:
                return STATS_JUNE;
            case 7:
                return STATS_JULY;
            case 8:
                return STATS_AUGUST;
            case 9:
                return STATS_SEPTEMBER;
            case 10:
                return STATS_OCTOBER;
            case 11:
                return STATS_NOVEMBER;
            default:
                return STATS_DECEMBER;
        }
    }

    /**
     * adminmenu()
     *
     * @param string       $header optional : You can gice the menu a nice header
     * @param string       $extra  optional : You can gice the menu a nice footer
     * @param array|string $menu   required : This is an array of links. U can
     * @param int          $scount required : This will difine the amount of cells long the menu will have.
     *                             NB: using a value of 3 at the moment will break the menu where the cell colours will be off display.
     */
public static function stats_adminmenu($header = '', $extra = '', $menu = '', $scount = 4)
    {
        global $xoopsConfig, $xoopsModule;

        if (empty($menu)) {
            /**
             * You can change this part to suit your own module. Defining this here will save you form having to do this each time.
             */

            $menu = [
                STATS_ADMENU1  => XOOPS_URL . '/modules/system/admin.php?fct=preferences&amp;op=showmod&amp;mod=' . $xoopsModule->getVar('mid'),
                STATS_ADMENU2  => 'index.php?op=' . INFO_GENERAL,
                STATS_ADMENU3  => 'index.php?op=' . INFO_CREDITS,
                STATS_ADMENU4  => 'index.php?op=' . INFO_CONFIGURATION,
                STATS_ADMENU5  => 'index.php?op=' . INFO_MODULES,
                STATS_ADMENU6  => 'index.php?op=' . INFO_ENVIRONMENT,
                STATS_ADMENU7  => 'index.php?op=' . INFO_VARIABLES,
                STATS_ADMENU8  => 'index.php?op=' . INFO_LICENSE,
                STATS_ADMENU9  => 'index.php?op=' . INFO_ALL,
                STATS_ADMENU10 => 'index.php?op=remote_addr',
                STATS_ADMENU11 => 'index.php?op=refer',
                STATS_ADMENU12 => 'index.php?op=userscreen',
            ];
        }

        $oddnum = [1 => '1', 3 => '3', 5 => '5', 7 => '7', 9 => '9', 11 => '11', 13 => '13'];

        /**
         * the amount of cells per menu row
         */
        $count = 0;
        /**
         * Set up the first class
         */
        $class = 'even';
        /**
         * Sets up the width of each menu cell
         */

        echo '<h3>' . $header . '</h3>';
        echo "<table width = '100%' cellpadding= '2' cellspacing= '1' class='outer'><tr>";

        /**
         * Check to see if $menu is and array
         */
        if (is_array($menu)) {
            foreach ($menu as $menutitle => $menulink) {
                ++$count;
                $width = 100 / $scount;
                $width = round($width);
                /**
                 * Menu table begin
                 */
                echo "<td class='$class' align='center' valign='middle' width= $width%>";
                echo "<a href='" . $menulink . "'>" . $menutitle . '</a></td>';

                /**
                 * Break menu cells to start a new row if $count > $scount
                 */
                if ($count >= $scount) {
                    /**
                     * If $class is the same for the end and start cells, invert $class
                     */
                    $class = ('odd' === $class && in_array($count, $oddnum)) ? 'even' : 'odd';
                    echo '</tr>';
                    $count = 0;
                } else {
                    $class = ('even' === $class) ? 'odd' : 'even';
                }
            }
            /**
             * checks to see if there are enough cell to fill menu row, if not add empty cells
             */
            if ($count >= 1) {
                $counter = 0;
                while ($counter < $scount - $count) {
                    echo '<td class="' . $class . '">&nbsp;</td>';
                    $class = ('even' === $class) ? 'odd' : 'even';
                    ++$counter;
                }
            }
            echo '</table><br>';
        }
        if ($extra) {
            echo "<div>$extra</div>";
        }
    }

}


1			<?php
2
3			namespace XoopsModules\Statistics;
4
5			use XoopsModules\Statistics;
6			use XoopsModules\Statistics\Common;
7			use XoopsModules\Statistics\Constants;
8
9			/**
10			* Class Utility
11			*/
12			class Utility extends Common\SysUtility
13			{
14			//--------------- Custom module methods -----------------------------
15
16			public static function getMonthlyStats($year)
17			{
18			global $xoopsDB, $xoopsTpl;
19
20			$now = date('d-m-Y');
21			$dot = explode('-', $now);
22			$nowmonth = $dot[1];
23
24			$l_size = getimagesize('assets/images/leftbar.gif');
25			$m_size = getimagesize('assets/images/mainbar.gif');
26			$r_size = getimagesize('assets/images/rightbar.gif');
27
28			// get monthly stats and display
29			$resultmonth = $xoopsDB->queryF('select sum(hits) as totalhitsmonth from ' . $xoopsDB->prefix('stats_month') . " where year='$year'");
30			[$totalhitsmonth] = $xoopsDB->fetchRow($resultmonth);
31			$xoopsDB->freeRecordSet($resultmonth);
32			$result = $xoopsDB->queryF('select month,hits from ' . $xoopsDB->prefix('stats_month') . " where year='$year'");
33			$xoopsTpl->assign('lang_stat_monthlystats', STATS_MONTHLYSTATS . ' - ' . $year);
34			$xoopsTpl->assign('lang_stat_monthhead', STATS_MONTH);
35			$resulttotal = $xoopsDB->queryF('select hits from ' . $xoopsDB->prefix('stats_year') . " where year='$year'");
36			[$hitsforyear] = $xoopsDB->fetchRow($resulttotal);
37			$monthlist = [];
38			$i = 0;
39			while (list($month, $hits) = $xoopsDB->fetchRow($result)) {
40			$monthlist[$i]['month'] = getMonth($month);
41			$monthlist[$i]['hits'] = $hits;
42			if ($month != $nowmonth) {
43			$monthlist[$i]['link'] = "<a href=\"statdetails.php?op=monthlystats&year=$year&month=$month\">" . $monthlist[$i]['month'] . '</a>';
44			} else {
45			$monthlist[$i]['link'] = '';
46			}
47
48			$midbarsize = mb_substr(100 * $hits / $hitsforyear, 0, 5);
49			$monthlist[$i]['percent'] = $midbarsize . '%';
50			$m_name = getMonth($month);
51			$monthlist[$i]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$m_name - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$m_name - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$m_name - $hits\">";
52			++$i;
53			}
54			$xoopsDB->freeRecordSet($result);
55			$xoopsTpl->assign('monthlist', $monthlist);
56			}
57
58			public static function getDailyStats($year, $month)
59			{
60			global $xoopsDB, $xoopsTpl;
61
62			$now = date('d-m-Y');
63			$dot = explode('-', $now);
64			$nowdate = $dot[0];
65
66			$l_size = getimagesize('assets/images/leftbar.gif');
67			$m_size = getimagesize('assets/images/mainbar.gif');
68			$r_size = getimagesize('assets/images/rightbar.gif');
69
70			// get the daily stats and show
71			$resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitsdate from ' . $xoopsDB->prefix('stats_date') . " where year='$year' and month='$month'");
72			[$totalhitsdate] = $xoopsDB->fetchRow($resulttotal);
73			$xoopsDB->freeRecordSet($resulttotal);
74			$result = $xoopsDB->queryF('select year,month,date,hits from ' . $xoopsDB->prefix('stats_date') . " where year='$year' and month='$month' order by date");
75			$total = $xoopsDB->getRowsNum($result);
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$total` is dead and can be removed. Loading history...
76			$xoopsTpl->assign('lang_stat_dailystats', STATS_DAILYSTATS . ' - ' . getMonth($month) . ' - ' . $year);
77			$xoopsTpl->assign('lang_stat_dailyhead', STATS_DAILY);
78			$dailylist = [];
79			$i = 0;
80			while (list($year, $month, $date, $hits) = $xoopsDB->fetchRow($result)) {
81			$dailylist[$i]['year'] = $year;
82			$dailylist[$i]['month'] = getMonth($month);
83			$dailylist[$i]['date'] = $date;
84			$dailylist[$i]['hits'] = $hits;
85			if ($date != $nowdate) {
86			$dailylist[$i]['link'] = "<a href=\"statdetails.php?op=dailystats&year=$year&month=$month&date=$date\">" . $date . '</a>';
87			} else {
88			$dailylist[$i]['link'] = '';
89			}
90			$midbarsize = mb_substr(100 * $hits / $totalhitsdate, 0, 5);
91			$dailylist[$i]['percent'] = $midbarsize . '%';
92			$dailylist[$i]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$date - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$date - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$date - $hits\">";
93			++$i;
94			}
95			$xoopsDB->freeRecordSet($result);
96			$xoopsTpl->assign('dailylist', $dailylist);
97			}
98
99			public static function getHourlyStats($year, $month, $date)
100			{
101			global $xoopsDB, $xoopsTpl;
102
103			$l_size = getimagesize('assets/images/leftbar.gif');
104			$m_size = getimagesize('assets/images/mainbar.gif');
105			$r_size = getimagesize('assets/images/rightbar.gif');
106
107			$now = date('d-m-Y');
108
109			// show hourly stats and display
110			$resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitshour from ' . $xoopsDB->prefix('stats_hour') . " where year='$year' and month='$month' and date='$date'");
111			[$totalhitshour] = $xoopsDB->fetchRow($resulttotal);
112			$xoopsDB->freeRecordSet($resulttotal);
113			$date_arr = explode('-', $now);
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$date_arr` is dead and can be removed. Loading history...
114			$xoopsTpl->assign('lang_stat_hourlystats', STATS_HOURLYSTATS . ' - ' . getMonth($month) . ' ' . $date . ' ' . $year);
115			$xoopsTpl->assign('lang_stat_hourlyhead', STATS_HOURLY);
116			$hourlist = [];
117
118			for ($k = 0; $k <= 23; ++$k) {
119			$result = $xoopsDB->queryF('select hour,hits from ' . $xoopsDB->prefix('stats_hour') . " where year='$year' and month='$month' and date='$date' and hour='$k'");
120			if (0 == $xoopsDB->getRowsNum($result)) {
121			$hits = 0;
122			$hour = $k;
123			} else {
124			[$hour, $hits] = $xoopsDB->fetchRow($result);
125			}
126
127			$a = (($k < 10) ? "0$k" : $k);
128			$hourlist[$k]['hour'] = "$a:00 - $a:59";
129
130			$a = '';
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$a` is dead and can be removed. Loading history...
131
132			$midbarsize = ((0 == $hits) ? 0 : mb_substr(100 * $hits / $totalhitshour, 0, 5));
133			$hourlist[$k]['hits'] = $hits;
134			$hourlist[$k]['percent'] = $midbarsize . '%';
135			$hourlist[$k]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$hour - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$hour - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$hour - $hits\">";
136			}
137
138			$xoopsDB->freeRecordSet($result);
139			$xoopsTpl->assign('hourlist', $hourlist);
140			}
141
142			public static function getBlockedMonthlyStats($year)
143			{
144			global $xoopsDB, $xoopsTpl;
145
146			$now = date('d-m-Y');
147			$dot = explode('-', $now);
148			$nowmonth = $dot[1];
149
150			$l_size = getimagesize('assets/images/leftbar.gif');
151			$m_size = getimagesize('assets/images/mainbar.gif');
152			$r_size = getimagesize('assets/images/rightbar.gif');
153
154			// get monthly stats and display
155			$resultmonth = $xoopsDB->queryF('select sum(hits) as totalhitsmonth from ' . $xoopsDB->prefix('stats_blockedmonth') . " where year='$year'");
156			[$totalhitsmonth] = $xoopsDB->fetchRow($resultmonth);
157			$xoopsDB->freeRecordSet($resultmonth);
158			$result = $xoopsDB->queryF('select month,hits from ' . $xoopsDB->prefix('stats_blockedmonth') . " where year='$year'");
159			$xoopsTpl->assign('lang_stat_monthlystats', STATS_BLOCKEDMONTHLYSTATS . ' - ' . $year);
160			$xoopsTpl->assign('lang_stat_monthhead', STATS_MONTH);
161			$resulttotal = $xoopsDB->queryF('select hits from ' . $xoopsDB->prefix('stats_blockedyear') . " where year='$year'");
162			[$hitsforyear] = $xoopsDB->fetchRow($resulttotal);
163			$monthlist = [];
164			$i = 0;
165			while (list($month, $hits) = $xoopsDB->fetchRow($result)) {
166			$monthlist[$i]['month'] = getMonth($month);
167			$monthlist[$i]['hits'] = $hits;
168			if ($month != $nowmonth) {
169			$monthlist[$i]['link'] = "<a href=\"statdetails.php?op=b_monthlystats&year=$year&month=$month\">" . $monthlist[$i]['month'] . '</a>';
170			} else {
171			$monthlist[$i]['link'] = '';
172			}
173
174			$midbarsize = mb_substr(100 * $hits / $hitsforyear, 0, 5);
175			$monthlist[$i]['percent'] = $midbarsize . '%';
176			$m_name = getMonth($month);
177			$monthlist[$i]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$m_name - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$m_name - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$m_name - $hits\">";
178			++$i;
179			}
180			$xoopsDB->freeRecordSet($result);
181			$xoopsTpl->assign('monthlist', $monthlist);
182			}
183
184			public static function getBlockedDailyStats($year, $month)
185			{
186			global $xoopsDB, $xoopsTpl;
187
188			$now = date('d-m-Y');
189			$dot = explode('-', $now);
190			$nowdate = $dot[0];
191
192			$l_size = getimagesize('assets/images/leftbar.gif');
193			$m_size = getimagesize('assets/images/mainbar.gif');
194			$r_size = getimagesize('assets/images/rightbar.gif');
195
196			// get the daily stats and show
197			$resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitsdate from ' . $xoopsDB->prefix('stats_blockeddate') . " where year='$year' and month='$month'");
198			[$totalhitsdate] = $xoopsDB->fetchRow($resulttotal);
199			$xoopsDB->freeRecordSet($resulttotal);
200			$result = $xoopsDB->queryF('select year,month,date,hits from ' . $xoopsDB->prefix('stats_blockeddate') . " where year='$year' and month='$month' order by date");
201			$total = $xoopsDB->getRowsNum($result);
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$total` is dead and can be removed. Loading history...
202			$xoopsTpl->assign('lang_stat_dailystats', STATS_BLOCKEDDAILYSTATS . ' - ' . getMonth($month) . ' - ' . $year);
203			$xoopsTpl->assign('lang_stat_dailyhead', STATS_DAILY);
204			$dailylist = [];
205			$i = 0;
206			while (list($year, $month, $date, $hits) = $xoopsDB->fetchRow($result)) {
207			$dailylist[$i]['year'] = $year;
208			$dailylist[$i]['month'] = getMonth($month);
209			$dailylist[$i]['date'] = $date;
210			$dailylist[$i]['hits'] = $hits;
211			if ($date != $nowdate) {
212			$dailylist[$i]['link'] = "<a href=\"statdetails.php?op=b_dailystats&year=$year&month=$month&date=$date\">" . $date . '</a>';
213			} else {
214			$dailylist[$i]['link'] = '';
215			}
216			$midbarsize = mb_substr(100 * $hits / $totalhitsdate, 0, 5);
217			$dailylist[$i]['percent'] = $midbarsize . '%';
218			$dailylist[$i]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$date - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$date - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$date - $hits\">";
219			++$i;
220			}
221			$xoopsDB->freeRecordSet($result);
222			$xoopsTpl->assign('dailylist', $dailylist);
223			}
224
225			public static function getBlockedHourlyStats($year, $month, $date)
226			{
227			global $xoopsDB, $xoopsTpl;
228
229			$l_size = getimagesize('assets/images/leftbar.gif');
230			$m_size = getimagesize('assets/images/mainbar.gif');
231			$r_size = getimagesize('assets/images/rightbar.gif');
232
233			$now = date('d-m-Y');
234
235			// show hourly stats and display
236			$resulttotal = $xoopsDB->queryF('select sum(hits) as totalhitshour from ' . $xoopsDB->prefix('stats_blockedhour') . " where year='$year' and month='$month' and date='$date'");
237			[$totalhitshour] = $xoopsDB->fetchRow($resulttotal);
238			$xoopsDB->freeRecordSet($resulttotal);
239			$date_arr = explode('-', $now);
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$date_arr` is dead and can be removed. Loading history...
240			$xoopsTpl->assign('lang_stat_hourlystats', STATS_BLOCKEDHOURLYSTATS . ' - ' . getMonth($month) . ' ' . $date . ' ' . $year);
241			$xoopsTpl->assign('lang_stat_hourlyhead', STATS_HOURLY);
242			$hourlist = [];
243
244			for ($k = 0; $k <= 23; ++$k) {
245			$result = $xoopsDB->queryF('select hour,hits from ' . $xoopsDB->prefix('stats_blockedhour') . " where year='$year' and month='$month' and date='$date' and hour='$k'");
246			if (0 == $xoopsDB->getRowsNum($result)) {
247			$hits = 0;
248			$hour = $k;
249			} else {
250			[$hour, $hits] = $xoopsDB->fetchRow($result);
251			}
252
253			$a = (($k < 10) ? "0$k" : $k);
254			$hourlist[$k]['hour'] = "$a:00 - $a:59";
255
256			$a = '';
			0 ignored issues – show Unused Code introduced 2020-11-12 04:31 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$a` is dead and can be removed. Loading history...
257
258			$midbarsize = ((0 == $hits) ? 0 : mb_substr(100 * $hits / $totalhitshour, 0, 5));
259			$hourlist[$k]['hits'] = $hits;
260			$hourlist[$k]['percent'] = $midbarsize . '%';
261			$hourlist[$k]['graph'] = "<img src=\"assets/images/leftbar.gif\" height=\"$l_size[1]\" width=\"$l_size[0]\" Alt=\"$hour - $hits\"><img src=\"assets/images/mainbar.gif\" Alt=\"$hour - $hits\" height=\"$m_size[1]\" width=\"$midbarsize\"><img src=\"assets/images/rightbar.gif\" height=\"$r_size[1]\" width=\"$r_size[0]\" Alt=\"$hour - $hits\">";
262			}
263
264			$xoopsDB->freeRecordSet($result);
265			$xoopsTpl->assign('hourlist', $hourlist);
266			}
267
268			public static function getMonth($month)
269			{
270			switch ($month) {
271			case 1:
272			return STATS_JANUARY;
273			case 2:
274			return STATS_FEBRUARY;
275			case 3:
276			return STATS_MARCH;
277			case 4:
278			return STATS_APRIL;
279			case 5:
280			return STATS_MAY;
281			case 6:
282			return STATS_JUNE;
283			case 7:
284			return STATS_JULY;
285			case 8:
286			return STATS_AUGUST;
287			case 9:
288			return STATS_SEPTEMBER;
289			case 10:
290			return STATS_OCTOBER;
291			case 11:
292			return STATS_NOVEMBER;
293			default:
294			return STATS_DECEMBER;
295			}
296			}
297
298			/**
299			* adminmenu()
300			*
301			* @param string $header optional : You can gice the menu a nice header
302			* @param string $extra optional : You can gice the menu a nice footer
303			* @param array\|string $menu required : This is an array of links. U can
304			* @param int $scount required : This will difine the amount of cells long the menu will have.
305			* NB: using a value of 3 at the moment will break the menu where the cell colours will be off display.
306			*/
307			public static function stats_adminmenu($header = '', $extra = '', $menu = '', $scount = 4)
308			{
309			global $xoopsConfig, $xoopsModule;
310
311			if (empty($menu)) {
312			/**
313			* You can change this part to suit your own module. Defining this here will save you form having to do this each time.
314			*/
315
316			$menu = [
317			STATS_ADMENU1 => XOOPS_URL . '/modules/system/admin.php?fct=preferences&op=showmod&mod=' . $xoopsModule->getVar('mid'),
318			STATS_ADMENU2 => 'index.php?op=' . INFO_GENERAL,
319			STATS_ADMENU3 => 'index.php?op=' . INFO_CREDITS,
320			STATS_ADMENU4 => 'index.php?op=' . INFO_CONFIGURATION,
321			STATS_ADMENU5 => 'index.php?op=' . INFO_MODULES,
322			STATS_ADMENU6 => 'index.php?op=' . INFO_ENVIRONMENT,
323			STATS_ADMENU7 => 'index.php?op=' . INFO_VARIABLES,
324			STATS_ADMENU8 => 'index.php?op=' . INFO_LICENSE,
325			STATS_ADMENU9 => 'index.php?op=' . INFO_ALL,
326			STATS_ADMENU10 => 'index.php?op=remote_addr',
327			STATS_ADMENU11 => 'index.php?op=refer',
328			STATS_ADMENU12 => 'index.php?op=userscreen',
329			];
330			}
331
332			$oddnum = [1 => '1', 3 => '3', 5 => '5', 7 => '7', 9 => '9', 11 => '11', 13 => '13'];
333
334			/**
335			* the amount of cells per menu row
336			*/
337			$count = 0;
338			/**
339			* Set up the first class
340			*/
341			$class = 'even';
342			/**
343			* Sets up the width of each menu cell
344			*/
345
346			echo '<h3>' . $header . '</h3>';
347			echo "<table width = '100%' cellpadding= '2' cellspacing= '1' class='outer'><tr>";
348
349			/**
350			* Check to see if $menu is and array
351			*/
352			if (is_array($menu)) {
353			foreach ($menu as $menutitle => $menulink) {
354			++$count;
355			$width = 100 / $scount;
356			$width = round($width);
357			/**
358			* Menu table begin
359			*/
360			echo "<td class='$class' align='center' valign='middle' width= $width%>";
361			echo "<a href='" . $menulink . "'>" . $menutitle . '</a></td>';
362
363			/**
364			* Break menu cells to start a new row if $count > $scount
365			*/
366			if ($count >= $scount) {
367			/**
368			* If $class is the same for the end and start cells, invert $class
369			*/
370			$class = ('odd' === $class && in_array($count, $oddnum)) ? 'even' : 'odd';
371			echo '</tr>';
372			$count = 0;
373			} else {
374			$class = ('even' === $class) ? 'odd' : 'even';
375			}
376			}
377			/**
378			* checks to see if there are enough cell to fill menu row, if not add empty cells
379			*/
380			if ($count >= 1) {
381			$counter = 0;
382			while ($counter < $scount - $count) {
383			echo '<td class="' . $class . '"> </td>';
384			$class = ('even' === $class) ? 'odd' : 'even';
385			++$counter;
386			}
387			}
388			echo '</table><br>';
389			}
390			if ($extra) {
391			echo "<div>$extra</div>";
392			}
393			}
394
395			}
396

XoopsModules25x / statistics

Issues (132)

Security Analysis not enabled

class/Utility.php (6 issues)

Labels

Severity

Introduced By

Duplication Side-by-Side

Filter issues like