Gecko [ dp-client.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
0.2.10.php	2.44 KB	-rw-r--r--
0.2.12.php	1.07 KB	-rw-r--r--
0.2.13.php	1.11 KB	-rw-r--r--
0.2.24.php	1.1 KB	-rw-r--r--
0.2.27.php	3.15 KB	-rw-r--r--
0.2.32.php	1.15 KB	-rw-r--r--
0.2.33.php	1.57 KB	-rw-r--r--
0.2.35.php	842 B	-rw-r--r--
0.2.37.php	1.01 KB	-rw-r--r--
0.4.1.php	958 B	-rw-r--r--
0.4.2.php	1.29 KB	-rw-r--r--
0.4.4.php	704 B	-rw-r--r--
0.4.php	1.46 KB	-rw-r--r--
0.5.4.php	2.18 KB	-rw-r--r--
0.5.5.php	1.62 KB	-rw-r--r--
0.5.php	1.97 KB	-rw-r--r--
0.6-rc1.php	3.76 KB	-rw-r--r--
0.6.3.php	1.48 KB	-rw-r--r--
0.7.php	845 B	-rw-r--r--
0.9.1.php	1.74 KB	-rw-r--r--
1.1.php	1015 B	-rw-r--r--
1.10-b4.php	575 B	-rw-r--r--
1.10.1.php	566 B	-rw-r--r--
1.10.2-b1.php	851 B	-rw-r--r--
1.10.2-b2.php	861 B	-rw-r--r--
1.11-b1.php	574 B	-rw-r--r--
1.12-b1.php	936 B	-rw-r--r--
1.12-b15.php	496 B	-rw-r--r--
1.12-b16.php	841 B	-rw-r--r--
1.2-rc1.php	7.44 KB	-rw-r--r--
1.2-rc2.php	478 B	-rw-r--r--
1.2.3.php	1.57 KB	-rw-r--r--
1.2.5-rc1.php	1.19 KB	-rw-r--r--
1.2.5-rc7.php	836 B	-rw-r--r--
1.4-rc1.php	1017 B	-rw-r--r--
1.4-rc2.php	1.95 KB	-rw-r--r--
1.5-b1.php	2.47 KB	-rw-r--r--
1.5-b2.php	1.4 KB	-rw-r--r--
1.5-b3.php	1.55 KB	-rw-r--r--
1.5-b4.php	832 B	-rw-r--r--
1.5-b5.php	1003 B	-rw-r--r--
1.5-rc6.php	476 B	-rw-r--r--
1.6-b1.php	1.93 KB	-rw-r--r--
1.6-rc1.php	472 B	-rw-r--r--
1.7-b1.php	1.04 KB	-rw-r--r--
1.7.2-rc5.php	934 B	-rw-r--r--
1.7.2-rc7.php	1.77 KB	-rw-r--r--
1.8.3-b1.php	4.55 KB	-rw-r--r--
1.8.4-b1.php	6.8 KB	-rw-r--r--
1.9-b16.php	1.56 KB	-rw-r--r--
1.9-b19.php	1.05 KB	-rw-r--r--
1.9-b9.php	1.83 KB	-rw-r--r--
1.9.1-b2.php	1021 B	-rw-r--r--
1.9.3-b10.php	573 B	-rw-r--r--
1.9.3-b3.php	731 B	-rw-r--r--
1.9.3-b8.php	921 B	-rw-r--r--
2.0-a12.php	1.5 KB	-rw-r--r--
2.0-a13.php	2.75 KB	-rw-r--r--
2.0-a17.php	1.01 KB	-rw-r--r--
2.0-a7.php	1011 B	-rw-r--r--
2.0-b10.php	448 B	-rw-r--r--
2.0-b13.php	1 KB	-rw-r--r--
2.0-b3.php	1.33 KB	-rw-r--r--
2.0-b9.php	922 B	-rw-r--r--
2.0-rc1.php	469 B	-rw-r--r--
2.0.3-b7.php	1.8 KB	-rw-r--r--
2.0.4-b5.php	2.75 KB	-rw-r--r--
2.0.4-b7.php	1.63 KB	-rw-r--r--
2.0.4-b8.php	2.04 KB	-rw-r--r--
2.1.1-b11.php	5.85 KB	-rw-r--r--
2.10.0-b10.php	1.43 KB	-rw-r--r--
2.10.0-b4.php	552 B	-rw-r--r--
2.10.0-b5.php	10.37 KB	-rw-r--r--
2.10.0-b7.php	1.41 KB	-rw-r--r--
2.10.0-b8.php	508 B	-rw-r--r--
2.11.0-b2.php	2.3 KB	-rw-r--r--
2.11.0-b4.php	1.43 KB	-rw-r--r--
2.11.0-b5.php	796 B	-rw-r--r--
2.11.1-b4.php	900 B	-rw-r--r--
2.13.0-b3.php	803 B	-rw-r--r--
2.13.1.php	1.36 KB	-rw-r--r--
2.14.0-b1.php	1.01 KB	-rw-r--r--
2.14.0-b2.php	1.12 KB	-rw-r--r--
2.14.2.php	4.45 KB	-rw-r--r--
2.15.0-b12.php	1.08 KB	-rw-r--r--
2.15.0-b16.php	1.05 KB	-rw-r--r--
2.15.0-b17.php	1.03 KB	-rw-r--r--
2.15.0-b20.php	1010 B	-rw-r--r--
2.15.0-b3.php	854 B	-rw-r--r--
2.15.0.php	795 B	-rw-r--r--
2.16.2-b2.php	686 B	-rw-r--r--
2.16.2-rc2.php	737 B	-rw-r--r--
2.16.3-b1.php	458 B	-rw-r--r--
2.16.3-b2.php	532 B	-rw-r--r--
2.16.3-rc2.php	483 B	-rw-r--r--
2.16.5.php	1.2 KB	-rw-r--r--
2.2.3-b6.php	469 B	-rw-r--r--
2.4.0-b1.php	661 B	-rw-r--r--
2.4.0-b3.php	739 B	-rw-r--r--
2.4.0-b4.php	770 B	-rw-r--r--
2.4.0-b6.php	512 B	-rw-r--r--
2.4.0-b8.php	834 B	-rw-r--r--
2.5.0-b1.php	894 B	-rw-r--r--
2.5.0-rc2.php	1.98 KB	-rw-r--r--
2.5.0-rc4.php	492 B	-rw-r--r--
2.6.0-b1.php	690 B	-rw-r--r--
2.7.0-b2.php	808 B	-rw-r--r--
2.7.0-b4.php	590 B	-rw-r--r--
2.9.0-b1.php	3.03 KB	-rw-r--r--
2.9.0-b7.php	2.02 KB	-rw-r--r--
3.0.0-b1.php	17.12 KB	-rw-r--r--
3.0.0-b3.php	1.78 KB	-rw-r--r--
3.0.0-b4.php	2.48 KB	-rw-r--r--
3.0.1-b1.php	652 B	-rw-r--r--
3.10.0-b2.php	894 B	-rw-r--r--
3.10.0-rc5.php	895 B	-rw-r--r--
3.11.0-b1.php	936 B	-rw-r--r--
3.12.0-b1.php	1.06 KB	-rw-r--r--
3.12.0-b7.php	1005 B	-rw-r--r--
3.13.1-b2.php	1.65 KB	-rw-r--r--
3.13.4-b1.php	567 B	-rw-r--r--
3.13.5-rc1.php	1.42 KB	-rw-r--r--
3.5.0-b2.php	1.92 KB	-rw-r--r--
3.5.0-b4.php	995 B	-rw-r--r--
3.5.0-rc2.php	574 B	-rw-r--r--
3.5.1-b1.php	2 KB	-rw-r--r--
3.6.0-b2.php	4.04 KB	-rw-r--r--
3.6.0-b3.php	1.25 KB	-rw-r--r--
3.6.0-b4.php	1.41 KB	-rw-r--r--
3.6.1-b2.php	942 B	-rw-r--r--
3.6.1-b3.php	910 B	-rw-r--r--
3.7.0-b1.php	976 B	-rw-r--r--
3.8.0-b3.php	2.02 KB	-rw-r--r--
3.8.0-b4.php	1.55 KB	-rw-r--r--
4.0.0-b1.php	14.21 KB	-rw-r--r--
4.0.0-b3.php	1.49 KB	-rw-r--r--
4.0.0-rc3.php	937 B	-rw-r--r--
4.0.0-rc4.php	1.82 KB	-rw-r--r--
4.0.1-b1.php	1.17 KB	-rw-r--r--
4.0.4-b1.php	2.29 KB	-rw-r--r--
4.1.2-b1.php	2.74 KB	-rw-r--r--
4.1.2-b2.php	1.04 KB	-rw-r--r--
4.10.0-b1.php	1.32 KB	-rw-r--r--
4.11.0-b1.php	1.05 KB	-rw-r--r--
4.11.0-rc2.php	3.18 KB	-rw-r--r--
4.12.0-b1.php	1 KB	-rw-r--r--
4.12.0-b2.php	1.17 KB	-rw-r--r--
4.12.0-b3.php	1.52 KB	-rw-r--r--
4.12.0-b4.php	1018 B	-rw-r--r--
4.3.0-b3.php	930 B	-rw-r--r--
4.3.0-b4.php	1.27 KB	-rw-r--r--
4.3.0-rc2.php	930 B	-rw-r--r--
4.4.0-b1.php	914 B	-rw-r--r--
4.5.0-b1.php	882 B	-rw-r--r--
4.6.0-b1.php	852 B	-rw-r--r--
4.6.0-b4.php	4.15 KB	-rw-r--r--
4.6.2-rc2.php	779 B	-rw-r--r--
4.7.0-b2.php	1.76 KB	-rw-r--r--
4.7.1-b1.php	1.38 KB	-rw-r--r--
5.0.0-b1.php	2.52 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : 2.10.0-b5.php

<?php
/**
 * Matomo - free/libre analytics platform
 *
 * @link https://matomo.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 *
 */

namespace Piwik\Updates;

use Piwik\Common;
use Piwik\DataAccess\ArchiveTableCreator;
use Piwik\Db;
use Piwik\Updater;
use Piwik\Updates;
use Piwik\Plugins\Dashboard\Model as DashboardModel;
use Piwik\Updater\Migration\Factory as MigrationFactory;

/**
 * This Update script will update all browser and os archives of UserSettings and DevicesDetection plugin
 *
 * In the future only DevicesDetection will handle browser and os archives, so we try to rename all existing archives
 * of UserSettings plugin to their corresponding archive name in DevicesDetection plugin:
 * - *UserSettings_browser* will now be *DevicesDetection_browserVersions*
 * - *UserSettings_os* will now be *DevicesDetection_osVersions*
 *
 * Unlike DevicesDetection plugin, the UserSettings plugin did not store archives holding the os and browser data without
 * their version number. The "version-less" reports were always generated out of the "version-containing" archives .
 * For big archives (month/year) that meant that some of the data was truncated, due to the datatable entry limit.
 * To avoid that data loss / inaccuracy in the future, DevicesDetection plugin will also store archives without the version.
 * For data archived after DevicesDetection plugin was enabled, those archive already exist. As we are removing the
 * UserSettings reports, there is a fallback in DevicesDetection API to build the report out of the datatable with versions.
 *
 * NOTE: Some archives might not contain "all" data.
 * That might have happened directly after the day DevicesDetection plugin was enabled. For the days before, there were
 * no archives calculated. So week/month/year archives will only contain data for the days, where archives were generated
 * To find a date after which it is safe to use DevicesDetection archives we need to find the first day-archive that
 * contains DevicesDetection data. Day archives will always contain full data, but week/month/year archives may not.
 * So we need to recreate those week/month/year archives.
 */
class Updates_2_10_0_b5 extends Updates
{
    public static $archiveBlobTables;

/**
     * @var MigrationFactory
     */
    private $migration;

public function __construct(MigrationFactory $factory)
    {
        $this->migration = $factory;
    }

public function getMigrations(Updater $updater)
    {
        $migrations = array('# ATTENTION: This update script will execute some more SQL queries than that below as it is necessary to rebuilt some archives #' => false);

// update scheduled reports to use new plugin
        $reportsToReplace = array(
            'UserSettings_getBrowserVersion' => 'DevicesDetection_getBrowserVersions',
            'UserSettings_getBrowser' => 'DevicesDetection_getBrowsers',
            'UserSettings_getOSFamily' => 'DevicesDetection_getOsFamilies',
            'UserSettings_getOS' => 'DevicesDetection_getOsVersions',
            'UserSettings_getMobileVsDesktop' => 'DevicesDetection_getType',
            'UserSettings_getBrowserType' => 'DevicesDetection_getBrowserEngines',
            'UserSettings_getWideScreen' => 'UserSettings_getScreenType',
        );

$reportTable = Common::prefixTable('report');
        foreach ($reportsToReplace as $old => $new) {
            $migrations[] = $this->migration->db->sql("UPDATE $reportTable SET reports = REPLACE(reports, '".$old."', '".$new."')");
        }

// update dashboard to use new widgets
        $oldWidgets = array(
            array('module' => 'UserSettings', 'action' => 'getBrowserVersion', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getBrowser', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getOSFamily', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getOS', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getMobileVsDesktop', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getBrowserType', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getWideScreen', 'params' => array()),
        );

$newWidgets = array(
            array('module' => 'DevicesDetection', 'action' => 'getBrowserVersions', 'params' => array()),
            array('module' => 'DevicesDetection', 'action' => 'getBrowsers', 'params' => array()),
            array('module' => 'DevicesDetection', 'action' => 'getOsFamilies', 'params' => array()),
            array('module' => 'DevicesDetection', 'action' => 'getOsVersions', 'params' => array()),
            array('module' => 'DevicesDetection', 'action' => 'getType', 'params' => array()),
            array('module' => 'DevicesDetection', 'action' => 'getBrowserEngines', 'params' => array()),
            array('module' => 'UserSettings', 'action' => 'getScreenType', 'params' => array()),
        );

$allDashboards = Db::get()->fetchAll(sprintf("SELECT * FROM %s", Common::prefixTable('user_dashboard')));

$dashboardTable = Common::prefixTable('user_dashboard');
        $dashboardQuery = "UPDATE $dashboardTable SET layout = ? WHERE iddashboard = ?";

foreach ($allDashboards as $dashboard) {
            $dashboardLayout = json_decode($dashboard['layout']);

$dashboardLayout = DashboardModel::replaceDashboardWidgets($dashboardLayout, $oldWidgets, $newWidgets);

$newLayout = json_encode($dashboardLayout);
            if ($newLayout != $dashboard['layout']) {
                $migrations[] = $this->migration->db->boundSql($dashboardQuery, array($newLayout, $dashboard['iddashboard']));
            }
        }

return $migrations;
    }

public function doUpdate(Updater $updater)
    {
        $updater->executeMigrations(__FILE__, $this->getMigrations($updater));

// DeviceDetection upgrade in beta1 timed out on demo #6750
        $archiveBlobTables = self::getAllArchiveBlobTables();

foreach ($archiveBlobTables as $table) {
            self::updateBrowserArchives($table);
            self::updateOsArchives($table);
        }
    }

/**
     * Returns all available archive blob tables
     *
     * @return array
     */
    public static function getAllArchiveBlobTables()
    {
        if (empty(self::$archiveBlobTables)) {
            $archiveTables = ArchiveTableCreator::getTablesArchivesInstalled();

self::$archiveBlobTables = array_filter($archiveTables, function ($name) {
                return ArchiveTableCreator::getTypeFromTableName($name) == ArchiveTableCreator::BLOB_TABLE;
            });

// sort tables so we have them in order of their date
            rsort(self::$archiveBlobTables);
        }

return (array) self::$archiveBlobTables;
    }

/**
     * Find the first day on which DevicesDetection archives were generated
     *
     * @return int    Timestamp
     */
    public static function getFirstDayOfArchivedDeviceDetectorData()
    {
        static $deviceDetectionBlobAvailableDate;

if (empty($deviceDetectionBlobAvailableDate)) {
            $archiveBlobTables = self::getAllArchiveBlobTables();

$deviceDetectionBlobAvailableDate = null;
            foreach ($archiveBlobTables as $table) {

// Look for all day archives and try to find that with the lowest date
                $deviceDetectionBlobAvailableDate = Db::get()->fetchOne(sprintf("SELECT date1 FROM %s WHERE name = 'DevicesDetection_browserVersions' AND period = 1 ORDER BY date1 ASC LIMIT 1", $table));

if (!empty($deviceDetectionBlobAvailableDate)) {
                    break;
                }
            }

$deviceDetectionBlobAvailableDate = strtotime($deviceDetectionBlobAvailableDate);
        }

return $deviceDetectionBlobAvailableDate;
    }

/**
     * Updates all browser archives to new structure
     * @param string $table
     * @throws \Exception
     */
    public static function updateBrowserArchives($table)
    {
        // rename old UserSettings archives where no DeviceDetection archives exists
        Db::exec(sprintf("UPDATE IGNORE %s SET name='DevicesDetection_browserVersions' WHERE name = 'UserSettings_browser'", $table));

/*
         * check dates of remaining (non-day) archives with calculated safe date
         * archives before or within that week/month/year of that date will be replaced
         */
        $oldBrowserBlobs = Db::get()->fetchAll(sprintf("SELECT * FROM %s WHERE name = 'UserSettings_browser' AND `period` > 1", $table));
        foreach ($oldBrowserBlobs as $blob) {

// if start date of blob is before calculated date us old usersettings archive instead of already existing DevicesDetection archive
            if (strtotime($blob['date1']) < self::getFirstDayOfArchivedDeviceDetectorData()) {
                Db::get()->query(sprintf("DELETE FROM %s WHERE idarchive = ? AND name = ?", $table), array($blob['idarchive'], 'DevicesDetection_browserVersions'));
                Db::get()->query(sprintf("UPDATE %s SET name = ? WHERE idarchive = ? AND name = ?", $table), array('DevicesDetection_browserVersions', $blob['idarchive'], 'UserSettings_browser'));
            }
        }
    }

public static function updateOsArchives($table)
    {
        Db::exec(sprintf("UPDATE IGNORE %s SET name='DevicesDetection_osVersions' WHERE name = 'UserSettings_os'", $table));

/*
         * check dates of remaining (non-day) archives with calculated safe date
         * archives before or within that week/month/year of that date will be replaced
         */
        $oldOsBlobs = Db::get()->fetchAll(sprintf("SELECT * FROM %s WHERE name = 'UserSettings_os' AND `period` > 1", $table));
        foreach ($oldOsBlobs as $blob) {

// if start date of blob is before calculated date us old usersettings archive instead of already existing DevicesDetection archive
            if (strtotime($blob['date1']) < self::getFirstDayOfArchivedDeviceDetectorData()) {
                Db::get()->query(sprintf("DELETE FROM %s WHERE idarchive = ? AND name = ?", $table), array($blob['idarchive'], 'DevicesDetection_osVersions'));
                Db::get()->query(sprintf("UPDATE %s SET name = ? WHERE idarchive = ? AND name = ?", $table), array('DevicesDetection_osVersions', $blob['idarchive'], 'UserSettings_os'));
            }
        }
    }
}

${this.title}

Code Editor : 2.10.0-b5.php