Gecko [ dp-client.com ]

Name	Size	Permission
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--

Code Editor : 3.0.0-b1.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\Access;
use Piwik\Common;
use Piwik\Db;
use Piwik\Option;
use Piwik\Plugins\Installation\ServerFilesGenerator;
use Piwik\Updater;
use Piwik\Updater\Migration;
use Piwik\Updater\Migration\Factory as MigrationFactory;
use Piwik\Updates;
use Piwik\Plugins\Dashboard;

/**
 * Update for version 3.0.0-b1.
 */
class Updates_3_0_0_b1 extends Updates
{
    /**
     * @var MigrationFactory
     */
    private $migration;

private $pluginSettingsTable = 'plugin_setting';
    private $siteSettingsTable = 'site_setting';

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

/**
     * Here you can define one or multiple SQL statements that should be executed during the update.
     * @param Updater $updater
     * @return Migration[]
     */
    public function getMigrations(Updater $updater)
    {
        $db = Db::get();
        $allGoals = $db->fetchAll(sprintf("SELECT DISTINCT idgoal FROM %s", Common::prefixTable('goal')));
        $allDashboards = $db->fetchAll(sprintf("SELECT * FROM %s", Common::prefixTable('user_dashboard')));

$migrations = $this->getDashboardMigrations($allDashboards, $allGoals);
        $migrations = $this->getPluginSettingsMigrations($migrations);
        $migrations = $this->getSiteSettingsMigrations($migrations);
        $migrations = $this->getBigIntPreventOverflowMigrations($migrations);

return $migrations;
    }

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

// added .woff and woff2 allowlisted file for apache webserver
        ServerFilesGenerator::deleteHtAccessFiles();
        ServerFilesGenerator::createHtAccessFiles();

// Renamed plugin ExampleRssWidget -> RssWidget
        \Piwik\Plugin\Manager::getInstance()->activatePlugin('RssWidget');
        \Piwik\Plugin\Manager::getInstance()->deactivatePlugin('ExampleRssWidget');
    }

private function migratePluginEmailUpdateSetting()
    {
        $isEnabled = Option::get('enableUpdateCommunicationPlugins');

Access::doAsSuperUser(function () use ($isEnabled) {
            $table = Common::prefixTable('plugin_setting');
            $sql  = "INSERT INTO $table (`plugin_name`, `user_login`, `setting_name`, `setting_value`) VALUES (?, ?, ?, ?)";
            $bind = array('CoreUpdater', '', 'enable_plugin_update_communication', (int) !empty($isEnabled));
            Db::query($sql, $bind);
        });
    }

/**
     * @param Migration[] $queries
     * @return Migration[]
     */
    private function getBigIntPreventOverflowMigrations($queries)
    {
        $queries[] = $this->migration->db->changeColumnTypes('log_visit', array(
            'idvisit' => 'BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT'
        ));

$queries[] = $this->migration->db->changeColumnTypes('log_conversion_item', array(
            'idvisit' => 'BIGINT(10) UNSIGNED NOT NULL',
        ));

$queries[] = $this->migration->db->changeColumnTypes('log_conversion', array(
            'idvisit' => 'BIGINT(10) UNSIGNED NOT NULL',
            'idlink_va' => 'BIGINT(10) UNSIGNED default NULL',
        ));

$queries[] = $this->migration->db->changeColumnTypes('log_link_visit_action', array(
            'idlink_va' => 'BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT',
            'idvisit' => 'BIGINT(10) UNSIGNED NOT NULL',

// Note; this column is made NULLable for #9231
            'idaction_name_ref' => 'INTEGER(10) UNSIGNED NULL',
        ));

return $queries;
    }

/**
     * @param Migration[] $queries
     * @return Migration[]
     */
    private function getPluginSettingsMigrations($queries)
    {
        $queries[] = $this->migration->db->createTable($this->pluginSettingsTable, array(
            'plugin_name' => 'VARCHAR(60) NOT NULL',
            'setting_name' => 'VARCHAR(255) NOT NULL',
            'setting_value' => 'LONGTEXT NOT NULL',
            'user_login' => "VARCHAR(100) NOT NULL DEFAULT ''",
        ));
        $queries[] = $this->migration->db->addIndex($this->pluginSettingsTable, array('plugin_name', 'user_login'));

$optionTable = Common::prefixTable('option');
        $query = 'SELECT `option_name`, `option_value` FROM `' . $optionTable . '` WHERE `option_name` LIKE "Plugin_%_Settings"';
        $options = Db::get()->fetchAll($query);

foreach ($options as $option) {
            $name = $option['option_name'];
            $pluginName = str_replace(array('Plugin_', '_Settings'), '', $name);
            $values = Common::safe_unserialize($option['option_value']);

if (empty($values)) {
                continue;
            }

foreach ($values as $settingName => $settingValue) {
                if (!is_array($settingValue)) {
                    $settingValue = array($settingValue);
                }

foreach ($settingValue as $val) {
                    $queries[] = $this->createPluginSettingQuery($pluginName, $settingName, $val);
                }
            }
        }

$queries[] = $this->migration->db->sql(sprintf('DELETE FROM `%s` WHERE `option_name` like "Plugin_%%_Settings"', $optionTable));

return $queries;
    }

/**
     * @param Migration[] $queries
     * @return Migration[]
     */
    private function getSiteSettingsMigrations($queries)
    {
        $table = $this->siteSettingsTable;

// we cannot migrate existing settings as we do not know the related plugin name, but this feature
        // (measurablesettings) was not used anyway. also see https://github.com/piwik/piwik/issues/10703
        // we make sure to recreate the table as it might not have existed for some users instead of just 
        // deleting the content of it
        $queries[] = $this->migration->db->dropTable($table);
        $queries[] = $this->migration->db->createTable($table, array(
            'idsite' => 'INTEGER(10) UNSIGNED NOT NULL',
            'plugin_name' => 'VARCHAR(60) NOT NULL',
            'setting_name' => 'VARCHAR(255) NOT NULL',
            'setting_value' => 'LONGTEXT NOT NULL',
        ));

$table = Common::prefixTable($table);
        $queries[] = $this->migration->db->sql("ALTER TABLE `$table` ADD INDEX(idsite, plugin_name);",
                                               Migration\Db::ERROR_CODE_COLUMN_NOT_EXISTS);

return $queries;
    }

private function createPluginSettingQuery($pluginName, $settingName, $settingValue)
    {
        $login = '';
        if (preg_match('/^.+#(.+)#$/', $settingName, $matches)) {
            $login = $matches[1];
            $settingName = str_replace('#' . $login . '#', '', $settingName);
        }

return $this->migration->db->insert($this->pluginSettingsTable, array(
            'plugin_name' => $pluginName,
            'setting_name' => $settingName,
            'setting_value' => $settingValue,
            'user_login' => $login
        ));
    }

private function getDashboardMigrations($allDashboards, $allGoals)
    {
        $sqls = array();

// update dashboard to use new widgets
        $oldWidgets = array(
            array (
                'module' => 'VisitTime',
                'action' => 'getVisitInformationPerServerTime',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitTime',
                'action' => 'getVisitInformationPerLocalTime',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitTime',
                'action' => 'getByDayOfWeek',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitsSummary',
                'action' => 'getEvolutionGraph',
                'params' =>
                    array (
                        'columns' => array ('nb_visits'),
                    ),
            ),array (
                'module' => 'VisitsSummary',
                'action' => 'getSparklines',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitsSummary',
                'action' => 'index',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Live',
                'action' => 'getVisitorLog',
                'params' =>
                    array ('small' => 1),
            ),array (
                'module' => 'VisitorInterest',
                'action' => 'getNumberOfVisitsPerVisitDuration',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitorInterest',
                'action' => 'getNumberOfVisitsPerPage',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitFrequency',
                'action' => 'getSparklines',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitFrequency',
                'action' => 'getEvolutionGraph',
                'params' =>
                    array (
                        'columns' => array ('nb_visits_returning'),
                    ),
            ),array (
                'module' => 'DevicesDetection',
                'action' => 'getBrowserEngines',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getReferrerType',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getAll',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getSocials',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Goals',
                'action' => 'widgetGoalsOverview',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsSku',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsName',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsCategory',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Ecommerce',
                'action' => 'widgetGoalReport',
                'params' =>
                    array (
                        'idGoal' => 'ecommerceOrder',
                    ),
            ),
        );

foreach ($allGoals as $goal) {
            $oldWidgets[] = array (
                'module' => 'Goals',
                'action' => 'widgetGoalReport',
                'params' =>
                    array (
                        'idGoal' => (int) $goal['idgoal'],
                    ));
        }

$newWidgets = array(
            array (
                'module' => 'VisitTime',
                'action' => 'getVisitInformationPerServerTime',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitTime',
                'action' => 'getVisitInformationPerLocalTime',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitTime',
                'action' => 'getByDayOfWeek',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitsSummary',
                'action' => 'getEvolutionGraph',
                'params' =>
                    array (
                        'forceView' => '1',
                        'viewDataTable' => 'graphEvolution',
                    ),
            ),array (
                'module' => 'VisitsSummary',
                'action' => 'get',
                'params' =>
                    array (
                        'forceView' => '1',
                        'viewDataTable' => 'sparklines',
                    ),
            ),array (
                'module' => 'CoreHome',
                'action' => 'renderWidgetContainer',
                'uniqueId' => 'widgetVisitOverviewWithGraph',
                'params' =>
                    array (
                        'containerId' => 'VisitOverviewWithGraph',
                    ),
            ),array (
                'module' => 'Live',
                'action' => 'getLastVisitsDetails',
                'params' =>
                    array (
                        'forceView' => '1',
                        'viewDataTable' => 'VisitorLog',
                        'small' => '1',
                    ),
            ),array (
                'module' => 'VisitorInterest',
                'action' => 'getNumberOfVisitsPerVisitDuration',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitorInterest',
                'action' => 'getNumberOfVisitsPerPage',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'VisitFrequency',
                'action' => 'get',
                'params' =>
                    array (
                        'forceView' => '1',
                        'viewDataTable' => 'sparklines'
                    ),
            ),array (
                'module' => 'VisitFrequency',
                'action' => 'getEvolutionGraph',
                'params' =>
                    array (
                        'forceView' => 1,
                        'viewDataTable' => 'graphEvolution',
                    ),
            ),array (
                'module' => 'DevicesDetection',
                'action' => 'getBrowserEngines',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getReferrerType',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getAll',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'Referrers',
                'action' => 'getSocials',
                'params' =>
                    array (
                    ),
            ),array (
                'module' => 'CoreHome',
                'action' => 'renderWidgetContainer',
                'uniqueId' => 'widgetGoalsOverview',
                'params' =>
                    array (
                        'containerId' => 'GoalsOverview'
                    ),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsSku',
                'params' => array (),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsName',
                'params' => array (),
            ),array (
                'module' => 'Goals',
                'action' => 'getItemsCategory',
                'params' => array (),
            ),array (
                'module' => 'CoreHome',
                'action' => 'renderWidgetContainer',
                'uniqueId' => 'widgetEcommerceOverview',
                'params' =>
                    array (
                        'containerId' => 'EcommerceOverview',
                    ),
            ),
        );

foreach ($allGoals as $goal) {
            $newWidgets[] = array (
                'module' => 'CoreHome',
                'action' => 'renderWidgetContainer',
                'uniqueId' => 'widgetGoal_' . (int) $goal['idgoal'],
                'params' =>
                    array (
                        'containerId' => 'Goal_' . (int) $goal['idgoal'],
                    ));
        }

$table = Common::prefixTable('user_dashboard');
        $sql = sprintf('UPDATE %s SET layout = ? WHERE iddashboard = ?', $table);

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

$dashboardLayout = Dashboard\Model::replaceDashboardWidgets($dashboardLayout, $oldWidgets, $newWidgets);

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

return $sqls;
    }
}

${this.title}

Code Editor : 3.0.0-b1.php