ilch Forum » Ilch CMS 2.X » Fehlersuche und Probleme » [ERLEDIGT] Statistik

Geschlossen
  1. #1
    User Pic
    BleckHall Mitglied
    Registriert seit
    11.11.2014
    Beiträge
    244
    Beitragswertungen
    4 Beitragspunkte
    Wenn ich in der Satistik Box auf z.B. Monat drücke kommt dies.

    An unexpected error occurred:
    MySQL Error: 'DB3059543.ilch_visits_stats.date' isn't in GROUP BY
    in Query: SELECT
    DATE (`date`) `date_full`,
    YEAR(`date`) `date_year`,
    MONTH(`date`) `date_month`,
    COUNT(`id`) AS `visits`
    FROM `ilch_visits_stats` WHERE YEAR(`date`) = YEAR("2017-08-01") AND MONTH(`date`) = MONTH("2017-08-01") GROUP BY `date_year`, `date_month`, `date_full`
    ORDER BY `date` DESC


    verwendete ilch Version: 2.x

    betroffene Homepage: galgenboschtrolle-rhm.de
    0 Mitglieder finden den Beitrag gut.
  2. #2
    User Pic
    blackcoder Entwickler
    Registriert seit
    22.05.2014
    Beiträge
    2.278
    Beitragswertungen
    356 Beitragspunkte
    Leider kann ich den Fehler (außer auf deiner Seite) nicht nachvollziehen.

    Seit wann ist die Seite mit Ilch 2 denn online?
    0 Mitglieder finden den Beitrag gut.
  3. #3
    User Pic
    dastiii Mitglied
    Registriert seit
    27.12.2005
    Beiträge
    2.354
    Beitragswertungen
    84 Beitragspunkte
    Reproduzierbar.

    ilch.dev/index.php/statistic/index/show/year/2017/month/08

    An unexpected error occurred:
    MySQL Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ilch.ilch_visits_stats.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    in Query: SELECT 
                    DATE (`date`) `date_full`,
                    YEAR(`date`) `date_year`,
                    MONTH(`date`) `date_month`,
                    COUNT(`id`) AS `visits`
                    FROM `ilch_visits_stats` WHERE YEAR(`date`) = YEAR("2017-08-01") AND MONTH(`date`) = MONTH("2017-08-01") GROUP BY `date_year`, `date_month`, `date_full`
                    ORDER BY `date` DESC


    MySQL 5.7.19-0ubuntu0.16.04.1
    ilch 2.0.1
    0 Mitglieder finden den Beitrag gut.
  4. #4
    User Pic
    corian Entwickler
    Registriert seit
    16.06.2011
    Beiträge
    1.096
    Beitragswertungen
    122 Beitragspunkte
    Fixe ich heute Abend zwinker
    0 Mitglieder finden den Beitrag gut.
  5. #5
    User Pic
    alexteam Mitglied
    Registriert seit
    17.05.2007
    Beiträge
    26
    Beitragswertungen
    0 Beitragspunkte
    Hallo,

    in der Box Statistik kommt folgender Fehler wenn auf Monat / Gesamt geklickt wird

    ZitatZitat
    An unexpected error occurred:

    MySQL Error: 'db_267002_3.ilch_visits_stats.date' isn't in GROUP BY
    in Query: SELECT
    DATE (`date`) `date_full`,
    YEAR(`date`) `date_year`,
    MONTH(`date`) `date_month`,
    COUNT(`id`) AS `visits`
    FROM `ilch_visits_stats` WHERE YEAR(`date`) = YEAR("2017-08-01") AND MONTH(`date`) = MONTH("2017-08-01") GROUP BY `date_year`, `date_month`, `date_full`
    ORDER BY `date` DESC


    verwendete ilch Version: 2.x

    Homepage: zschau.12hp.de


    Zuletzt modifiziert von alexteam am 04.08.2017 - 23:24:30
    0 Mitglieder finden den Beitrag gut.
  6. #6
    User Pic
    corian Entwickler
    Registriert seit
    16.06.2011
    Beiträge
    1.096
    Beitragswertungen
    122 Beitragspunkte
    Bitte mal die Datei öffnen

    application\modules\statistic\mappers\Statistic.php


    und den gesamten Inhalt durch diesen hier ersätzen, dann einfach feedback geben ob es funktioniert, danke.

    <?php
    /**
     * @copyright Ilch 2.0
     * @package ilch
     */
    
    namespace Modules\Statistic\Mappers;
    
    use Modules\Statistic\Models\Statistic as StatisticModel;
    use Modules\User\Mappers\User as UserMapper;
    
    class Statistic extends \Ilch\Mapper
    {
        /**
         * Returns all online users.
         *
         * @return []|\Modules\User\Models\User[]
         */
        public function getVisitsOnlineUser()
        {
            $userMapper = new UserMapper();
            $date = new \Ilch\Date();
            $date->modify('-5 minutes');
    
            $sql = 'SELECT *
                    FROM `[prefix]_visits_online`
                    WHERE `date_last_activity` > "'.$date->format("Y-m-d H:i:s", true).'"
                    AND `user_id` > 0';
    
            $rows = $this->db()->queryArray($sql);
    
            $users = [];
            foreach ($rows as $row) {
                if ($userMapper->getUserById($row['user_id'])) {
                    $users[] = $userMapper->getUserById($row['user_id']);
                }
            }
    
            return $users;
        }
    
        /**
         * Returns all online visits.
         *
         * @return null|\Modules\Statistic\Models\Statistic[]
         */
        public function getVisitsOnline()
        {
            $date = new \Ilch\Date();
            $date->modify('-5 minutes');
    
            $sql = 'SELECT *
                    FROM `[prefix]_visits_online`
                    WHERE `date_last_activity` > "'.$date->format("Y-m-d H:i:s", true).'"
                    ORDER BY date_last_activity DESC';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setUserId($entries['user_id']);
                $statisticModel->setSite($entries['site']);
                $statisticModel->setIPAdress($entries['ip_address']);
                $statisticModel->setOS($entries['os']);
                $statisticModel->setOSVersion($entries['os_version']);
                $statisticModel->setBrowser($entries['browser']);
                $statisticModel->setBrowserVersion($entries['browser_version']);
                $statisticModel->setDateLastActivity($entries['date_last_activity']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsHour($year = null, $month = null)
        {
            $sql = 'SELECT
                    HOUR (`date`) `date_hour`,
                    COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } elseif ($year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            }
            $sql .= ' GROUP BY `date_hour`
                    ORDER BY `date_hour` DESC';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setDate($entries['date_hour']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsDay($year = null, $month = null)
        {
            $sql = 'SELECT
                MAX(DATE (`date`)) AS `date_full`,
                WEEKDAY(`date`) AS `date_week`,
                    COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } elseif ($year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            }
    				$sql .= ' GROUP BY WEEKDAY(`date`)
                    ';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setDate($entries['date_full']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsYearMonthDay($year = null, $month = null)
        {
            $sql = 'SELECT 
                    DATE (`date`) as `date_full`,
                    YEAR(`date`) as  `date_year`,
                    MONTH(`date`) as `date_month`,
                    COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } else {
                $sql .= ' WHERE YEAR(`date`) = YEAR(CURDATE()) AND MONTH(`date`) = MONTH(CURDATE())';
            }
            $sql .= ' GROUP BY YEAR(`date`), MONTH(`date`), DATE (`date`)
                    ';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setDate($entries['date_full']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsYearMonth($year = null)
        {
            $sql = 'SELECT YEAR(`date`) AS `date_year`, MONTH(`date`) AS `date_month`, COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            } else {
                $sql .= ' WHERE YEAR(`date`) = YEAR(CURDATE())';
            }
            $sql .= ' GROUP BY `date_year`,`date_month`
                    ORDER BY MONTH(`date`) DESC';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setDate($entries['date_year'].'-'.$entries['date_month'].'-01');
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsYear($year = null)
        {
            $sql = 'SELECT YEAR(`date`) AS `year_full`, COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            }
            $sql .= ' GROUP BY `year_full`
                      ORDER BY `year_full` DESC';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setDate($entries['year_full'].'-01-01');
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsBrowser($year = null, $month = null, $browser = null)
        {
            $sql = 'SELECT `browser`, COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null AND $browser != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'") AND browser = "'.$browser.'"
                          GROUP BY `browser`
                          ORDER BY `visits` DESC';
            } elseif ($month == null AND $year != null AND $browser != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND browser = "'.$browser.'"
                          GROUP BY `browser`
                          ORDER BY `visits` DESC';
            } elseif ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")
                          GROUP BY `browser`
                          ORDER BY `visits` DESC';
            } elseif ($month == null AND $year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")
                          GROUP BY `browser`
                          ORDER BY `visits` DESC';
            }
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setBrowser($entries['browser']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsLanguage($year = null, $month = null)
        {
            $sql = 'SELECT
                    YEAR(`date`) `date_year`,
                    MONTH(`date`) `date_month`,
                    `lang`,
                    COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } else if ($month == null AND $year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            }
            $sql .= ' GROUP BY `lang`, `date_year`, `date_month`
                    ORDER BY `visits` DESC';
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setLang($entries['lang']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        public function getVisitsOS($year = null, $month = null, $os = null)
        {
            $sql = 'SELECT 
                    YEAR(`date`) `date_year`,
                    MONTH(`date`) `date_month`,
                    `os_version`,
                    `os`,
                    COUNT(`id`) AS `visits`
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null AND $os != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'") AND os = "'.$os.'"
                          GROUP BY `os_version`, `date_year`, `date_month`, `os`
                          ORDER BY `visits` DESC';
            } elseif ($month == null AND $year != null AND $os != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND os = "'.$os.'"
                          GROUP BY `os_version`, `date_year`, `date_month`, `os`
                          ORDER BY `visits` DESC';
            } elseif ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")
                          GROUP BY `os`, `date_year`, `date_month`, `os_version`
                          ORDER BY `visits` DESC';
            } elseif ($month == null AND $year != null) {
                $date = $year.'-01-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")
                          GROUP BY `os`, `date_year`, `date_month`, `os_version`
                          ORDER BY `visits` DESC';
            }
    
            $entryArray = $this->db()->queryArray($sql);
    
            if (empty($entryArray)) {
                return null;
            }
    
            $entry = [];
            foreach ($entryArray as $entries) {
                $statisticModel = new StatisticModel();
                $statisticModel->setVisits($entries['visits']);
                $statisticModel->setOS($entries['os']);
                $statisticModel->setOSVersion($entries['os_version']);
                $entry[] = $statisticModel;
            }
    
            return $entry;
        }
    
        /**
         * @return integer
         */
        public function getVisitsCountOnline()
        {
            $date = new \Ilch\Date();
            $date->modify('-5 minutes');
    
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_visits_online`
                    WHERE `date_last_activity` > "'.$date->format("Y-m-d H:i:s", true).'"';
    
            $visits = $this->db()->queryCell($sql);
    
            return $visits;
        }
    
        public function getArticlesCount()
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_articles`';
    
            $entries = $this->db()->queryCell($sql);
    
            return $entries;
        }
    
        public function getCommentsCount()
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_comments`';
    
            $entries = $this->db()->queryCell($sql);
    
            return $entries;
        }
    
        public function getModulesCount()
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_modules`
                    WHERE `system` = 0';
    
            $entries = $this->db()->queryCell($sql);
    
            return $entries;
        }
    
        public function getRegistUserCount()
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_users`
                    WHERE `confirmed` = 1';
    
            $entries = $this->db()->queryCell($sql);
    
            return $entries;
        }
    
        public function getRegistNewUser()
        {
            $sql = 'SELECT MAX(id)
                    FROM `[prefix]_users`
                    WHERE `confirmed` = 1';
    
            $entries = $this->db()->queryCell($sql);
    
            return $entries;
        }
    
        /**
         * @return integer
         */
        public function getVisitsCount($date = null, $year = null, $month = null)
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01 00:00:00';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } elseif ($month == null AND $year != null) {
                $date = $year.'-01-01 00:00:00';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'")';
            } elseif ($date != null) {
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'") AND DAY(`date`) = DAY("'.$date.'")';
            }
    
            $visits = $this->db()->queryCell($sql);
    
            return $visits;
        }
    
        public function getVisitsMonthCount($year = null, $month = null)
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_visits_stats`';
            if ($month != null AND $year != null) {
                $date = $year.'-'.$month.'-01';
                $sql .= ' WHERE YEAR(`date`) = YEAR("'.$date.'") AND MONTH(`date`) = MONTH("'.$date.'")';
            } else {
                $sql .= ' WHERE YEAR(`date`) = YEAR(CURDATE()) AND MONTH(`date`) = MONTH(CURDATE())';
            }
    
            $visits = $this->db()->queryCell($sql);
    
            return $visits;
        }
    
        public function getVisitsYearCount()
        {
            $sql = 'SELECT COUNT(*)
                    FROM `[prefix]_visits_stats`
                    WHERE YEAR(`date`) = YEAR(CURDATE())';
    
            $visits = $this->db()->queryCell($sql);
    
            return $visits;
        }
    
        public function getPercent($count, $totalcount)
        {
            $percent = round(($count / $totalcount) * 100);
    
            return $percent;
        }
    
        public function getOS($name = null, $version = null) {
            $useragent = $_SERVER['HTTP_USER_AGENT'];
    
            if ($name != null) {
                $osArray = [
                    'Windows' => '=Windows NT|Windows Server 2003|Windows XP x64|Windows 98|Windows Phone|Windows 95=',
                    'Android' => '=Android=',
                    'Linux' => '=Linux|Ubuntu|X11=',
                    'SunOs' => '=SunOS=',
                    'iPhone' => '=iPhone=',
                    'iPad' => '=iPad=',
                    'Mac OS X' => '=Mac OS X=',
                    'Mac OS' => '=Mac OS=',
                    'Macintosh' => '=Mac_PowerPC|Macintosh='
                ];
            } elseif ($version != null) {
                $osArray = [
                    '7.x' => '=Android 7=',
                    '6.x' => '=Android 6=',
                    '5.x' => '=Android 5=',
                    '4.4' => '=Android 4.4=',
                    '4.x' => '=Android 4.1|Android 4.2|Android 4.3=',
                    '4.0' => '=Android 4.0=',
                    '3.x' => '=Android 3=',
                    '2.3' => '=Android 2.3=',
                    '2.2' => '=Android 2.2=',
                    'XP' => '=Windows NT 5.1|Windows XP=',
                    'Vista' => '=Windows NT 6.0|Windows Vista=',
                    '7' => '=Windows NT 6.1|Windows 7=',
                    '8' => '=Windows NT 6.2|Windows 8=',
                    '8.1' => '=Windows NT 6.3|Windows 8.1=',
                    '10' => '=Windows NT 10.0|Windows 10=',
                    '2000' => '=Windows NT 5.0|Windows 2000=',
                    'Server 2003' => '=Windows NT 5\.2|Windows Server 2003|Windows XP x64=',
                    'NT' => '=Windows NT 4|WinNT4=',
                    'Phone 7.x' => '=Windows Phone OS 7=',
                    'Phone 8.0' => '=Windows Phone 8=',
                    'Phone 8.1' => '=Windows Phone 8.1=',
                    '10 Mobile' => '=Windows Phone 10=',
                    '98' => '=Windows 98=',
                    '95' => '=Windows 95=',
                    '10.8' => '=Mac OS X 10.8|Mac OS X 10_8=',
                    '10.9' => '=Mac OS X 10.9|Mac OS X 10_9=',
                    '10.10' => '=Mac OS X 10.10|Mac OS X 10_10=',
                    '10.11' => '=Mac OS X 10.11|Mac OS X 10_11=',
                    '10.12' => '=Mac OS X 10.12|Mac OS X 10_12=',
                ];
            }
    
            foreach ($osArray as $os => $regex) {
                if (preg_match($regex, $useragent)) {
                    return $os;
                }
            }
    
            return "";
        }
    
        public function getBrowser($version = null) {
            $useragent = $_SERVER['HTTP_USER_AGENT'];
    
            if ($version != null) {
                if (preg_match("=Firefox/([\.a-zA-Z0-9]*)=", $useragent)) {
                    return ("Firefox");
                } elseif (preg_match("=MSIE ([0-9]{1,2})\.[0-9]{1,2}=", $useragent)) {
                    return "Internet Explorer";
                } elseif (preg_match("=rv:([0-9]{1,2})\.[0-9]{1,2}=", $useragent)) {
                    return "Internet Explorer";
                } elseif (preg_match("=Opera[/ ]([0-9\.]+)=", $useragent)) {
                    return "Opera";
                } elseif (preg_match("=OPR\/([0-9\.]*)=", $useragent)) {
                    return "Opera";
                } elseif (preg_match("=Edge/([0-9\.]*)=", $useragent)) {
                    return "Edge";
                } elseif (preg_match("=Chrome/([0-9\.]*)=", $useragent)) {
                    return "Chrome";
                } elseif (preg_match('=Safari/=', $useragent)) {
                    return "Safari";
                } elseif (preg_match("=Konqueror=", $useragent)) {
                    return "Konqueror";
                } elseif (preg_match("=Netscape|Navigator=", $useragent)) {
                    return "Netscape";
                } else {
                    return "";
                }
            } else {
                if (preg_match("=Firefox/([\.a-zA-Z0-9]*)=", $useragent, $browser)) {
                    return $browser[1];
                } elseif (preg_match("=MSIE ([0-9]{1,2})\.[0-9]{1,2}=", $useragent, $browser)) {
                    return $browser[1];
                } elseif (preg_match("=rv:([0-9]{1,2})\.[0-9]{1,2}=", $useragent, $browser)) {
                    return $browser[1];
                } elseif (preg_match("=Opera[/ ]([0-9\.]+)=", $useragent, $browser)) {
                    return $browser[1];
                } elseif (preg_match("=OPR\/([0-9\.]*)=", $useragent, $browser)) {
                    $tmp = explode('.', $browser[1]);
                    if (count($tmp) > 2) {
                        $browser[1] = $tmp[0] . '.' . $tmp[1];
                    }
                    return $browser[1];
                } elseif (preg_match("=Edge/([0-9\.]*)=", $useragent, $browser)) {
                    $tmp = explode('.', $browser[1]);
                    if (count($tmp) > 2) {
                        $browser[1] = $tmp[0] . '.' . $tmp[1];
                    }
                    return $browser[1];
                } elseif (preg_match("=Chrome/([0-9\.]*)=", $useragent, $browser)) {
                    $tmp = explode('.', $browser[1]);
                    if (count($tmp) > 2) {
                        $browser[1] = $tmp[0] . '.' . $tmp[1];
                    }
                    return $browser[1];
                } elseif (preg_match('=Safari/=', $useragent)) {
                    if (preg_match('=Version/([\.0-9]*)=', $useragent, $browser)) {
                        $version = $browser[1];
                    } else {
                        return "";
                    }
                    return $version;
                } else {
                    return "";
                }
            }
        }
    
        /**
         * @param array $row
         */
        public function saveVisit($row)
        {
            $date = new \Ilch\Date();
            $visitId = (int) $this->db()->select('id')
                ->from('visits_online')
                ->where(['user_id' => $row['user_id'], 'ip_address' => $row['ip']])
                ->execute()
                ->fetchCell();
    
            if ($visitId) {
                $this->db()->update('visits_online')
                    ->values(['site' => $row['site'], 'os' => $row['os'], 'os_version' => $row['os_version'], 'browser' => $row['browser'], 'browser_version' => $row['browser_version'], 'lang' => $row['lang'], 'date_last_activity' => $date->format('Y-m-d H:i:s', true)])
                    ->where(['id' => $visitId])
                    ->execute();
    
                if ($row['user_id']) {
                    $this->db()->update('users')
                        ->values(['date_last_activity' => $date->format('Y-m-d H:i:s', true)])
                        ->where(['id' => $row['user_id']])
                        ->execute();
                }
            } else {
                $this->db()->insert('visits_online')
                    ->values(['user_id' => $row['user_id'], 'site' => $row['site'], 'os' => $row['os'], 'os_version' => $row['os_version'], 'browser' => $row['browser'], 'browser_version' => $row['browser_version'], 'ip_address' => $row['ip'], 'lang' => $row['lang'], 'date_last_activity' => $date->format('Y-m-d H:i:s', true)])
                    ->execute();
            }
    
            $sql = 'SELECT id
                    FROM `[prefix]_visits_stats`
                    WHERE ip_address = "'.$row['ip'].'" AND YEAR(`date`) = YEAR(CURDATE()) AND MONTH(`date`) = MONTH(CURDATE()) AND DAY(`date`) = DAY(CURDATE())';
    
            $uniqueUser = $this->db()->queryCell($sql);
    
            if ($uniqueUser) {
                $this->db()->update('visits_stats')
                    ->values(['os' => $row['os'], 'os_version' => $row['os_version'], 'browser' => $row['browser'], 'browser_version' => $row['browser_version'], 'lang' => $row['lang']])
                    ->where(['id' => $uniqueUser])
                    ->execute();
            } else {
                $this->db()->insert('visits_stats')
                    ->values(['referer' => $row['referer'], 'os' => $row['os'], 'os_version' => $row['os_version'], 'browser' => $row['browser'], 'browser_version' => $row['browser_version'], 'ip_address' => $row['ip'], 'lang' => $row['lang'], 'date' => $date->format('Y-m-d H:i:s', true)])
                    ->execute();
            }
        }
    
        /**
         * Deletes a user from list of online users.
         *
         * @param  int $userId
         */
        public function deleteUserOnline($userId) {
            $this->db()->delete('visits_online')
                ->where(['user_id' => $userId])
                ->execute();
        }
    }
    0 Mitglieder finden den Beitrag gut.
  7. #7
    User Pic
    alexteam Mitglied
    Registriert seit
    17.05.2007
    Beiträge
    26
    Beitragswertungen
    0 Beitragspunkte
    Hallo ja hat super funktioniert. Danke!
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Fehlersuche und Probleme

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten