getGeneralStats()

Complexity

Conditions	42
Paths	1040

Size

Total Lines	146
Code Lines	106

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
function getGeneralStats()
{
    global $xoopsDB, $stats_secure_const, $xoopsStatConfig;

    /* Get the Browser data */
    $user_agent = $stats_secure_const['user_agent'];

    $botarray = $xoopsStatConfig['stats_botidentities'];
    if (!is_array($botarray)) { // make sure it's an array
        // something went wrong, initialize as an array
        $botarray = [];
    }

    $pipesepbots = '/' . implode('|', $botarray) . '/i';

    if (preg_match($pipesepbots, $user_agent)) {
        $browser = 'Bot';
    } elseif (preg_match('/Nav|Gold|X11|Netscape/', $user_agent) && (false === preg_match('/MSIE|Konqueror|Slurp|AppleWeb|Firefox|Firebird|Opera/', $user_agent))) {
        $browser = 'Netscape';
    } elseif (preg_match('/Opera/', $user_agent)) {
        $browser = 'Opera';
    } elseif (preg_match('/Lynx/', $user_agent)) {
        $browser = 'Lynx';
    } elseif (preg_match('/WebTV/', $user_agent)) {
        $browser = 'WebTV';
    } elseif (preg_match('/Konqueror/', $user_agent)) {
        $browser = 'Konqueror';
    } elseif (preg_match('/AppleWeb/', $user_agent)) {
        $browser = 'AppleWeb';
    } elseif (preg_match('/Firefox/', $user_agent)) {
        $browser = 'Firefox';
    } elseif (preg_match('/Deepnet/', $user_agent)) {
        $browser = 'Deepnet';
    } elseif (preg_match('/Avant/', $user_agent)) {
        $browser = 'Avant';
    } elseif (preg_match('/MSIE/', $user_agent)) {
        $browser = 'MSIE';
    } elseif (preg_match('/Mozilla/', $user_agent)) {
        $browser = 'Mozilla';
    } else {
        $browser = 'Other';
    }

    /* Get the Operating System data */

    if (preg_match('/Win/', $user_agent)) {
        $os = 'Windows';
    } elseif (preg_match('/Mac|PPC/', $user_agent)) {
        $os = 'Mac';
    } elseif (preg_match('/Linux/', $user_agent)) {
        $os = 'Linux';
    } elseif (preg_match('/FreeBSD/', $user_agent)) {
        $os = 'FreeBSD';
    } elseif (preg_match('/SunOS/', $user_agent)) {
        $os = 'SunOS';
    } elseif (preg_match('/IRIX/', $user_agent)) {
        $os = 'IRIX';
    } elseif (preg_match('/BeOS/', $user_agent)) {
        $os = 'BeOS';
    } elseif (preg_match('/OS/2/', $user_agent)) {
        $os = 'OS/2';
    } elseif (preg_match('/AIX/', $user_agent)) {
        $os = 'AIX';
    } else {
        $os = 'Other';
    }

    /* Save the obtained values */
    $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('counter') . " SET count=count+1 WHERE (type='total' AND var='hits') OR (var='$browser' AND type='browser') OR (var='$os' AND type='os')");

    /* Start Detailed Statistics */

    $dot        = date('d-m-Y-H');
    $now        = explode('-', $dot);
    $nowHour    = $now[3];
    $nowYear    = $now[2];
    $nowMonth   = $now[1];
    $nowDate    = $now[0];
    $sql        = 'SELECT year FROM ' . $xoopsDB->prefix('stats_year') . " WHERE year='$nowYear'";
    $resultyear = $xoopsDB->queryF($sql);
    $jml        = $xoopsDB->getRowsNum($resultyear);
    if ($jml <= 0) {
        $sql = 'INSERT INTO ' . $xoopsDB->prefix('stats_year') . " VALUES ('$nowYear','0')";
        $xoopsDB->queryF($sql);
        for ($i = 1; $i <= 12; ++$i) {
            $xoopsDB->queryF('INSERT INTO ' . $xoopsDB->prefix('stats_month') . " VALUES ('$nowYear','$i','0')");
            if (1 == $i) {
                $TotalDay = 31;
            }
            if (2 == $i) {
                if (true === date('L')) {
                    $TotalDay = 29;
                } else {
                    $TotalDay = 28;
                }
            }
            if (3 == $i) {
                $TotalDay = 31;
            }
            if (4 == $i) {
                $TotalDay = 30;
            }
            if (5 == $i) {
                $TotalDay = 31;
            }
            if (6 == $i) {
                $TotalDay = 30;
            }
            if (7 == $i) {
                $TotalDay = 31;
            }
            if (8 == $i) {
                $TotalDay = 31;
            }
            if (9 == $i) {
                $TotalDay = 30;
            }
            if (10 == $i) {
                $TotalDay = 31;
            }
            if (11 == $i) {
                $TotalDay = 30;
            }
            if (12 == $i) {
                $TotalDay = 31;
            }
            for ($k = 1; $k <= $TotalDay; ++$k) {

The variable $TotalDay does not seem to be defined for all execution paths leading up to this point.

                $xoopsDB->queryF('INSERT INTO ' . $xoopsDB->prefix('stats_date') . " VALUES ('$nowYear','$i','$k','0')");
            }
        }
    }

    $sql     = 'SELECT hour FROM ' . $xoopsDB->prefix('stats_hour') . " WHERE (year='$nowYear') AND (month='$nowMonth') AND (date='$nowDate')";
    $result  = $xoopsDB->queryF($sql);
    $numrows = $xoopsDB->getRowsNum($result);

    if ($numrows <= 0) {
        for ($z = 0; $z <= 23; ++$z) {
            $xoopsDB->queryF('INSERT INTO ' . $xoopsDB->prefix('stats_hour') . " VALUES ('$nowYear','$nowMonth','$nowDate','$z','0')");
        }
    }

    $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('stats_year') . " SET hits=hits+1 WHERE year='$nowYear'");
    $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('stats_month') . " SET hits=hits+1 WHERE (year='$nowYear') AND (month='$nowMonth')");
    $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('stats_date') . " SET hits=hits+1 WHERE (year='$nowYear') AND (month='$nowMonth') AND (date='$nowDate')");
    $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('stats_hour') . " SET hits=hits+1 WHERE (year='$nowYear') AND (month='$nowMonth') AND (date='$nowDate') AND (hour='$nowHour')");
}