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 : 1.2-rc1.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\Updater;
use Piwik\Updates;
use Piwik\Updater\Migration\Factory as MigrationFactory;

/**
 */
class Updates_1_2_rc1 extends Updates
{
    /**
     * @var MigrationFactory
     */
    private $migration;

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

public function getMigrations(Updater $updater)
    {
        $customVarType = 'VARCHAR(100) DEFAULT NULL';
        $customVarColumns = array(
            'custom_var_k1' => $customVarType,
            'custom_var_v1' => $customVarType,
            'custom_var_k2' => $customVarType,
            'custom_var_v2' => $customVarType,
            'custom_var_k3' => $customVarType,
            'custom_var_v3' => $customVarType,
            'custom_var_k4' => $customVarType,
            'custom_var_v4' => $customVarType,
            'custom_var_k5' => $customVarType,
            'custom_var_v5' => $customVarType,
        );

return array(
            // Various performance improvements schema updates
            $this->migration->db->sql('ALTER TABLE `' . Common::prefixTable('log_visit') . '`
                DROP `visit_server_date`,
                DROP INDEX `index_idsite_date_config`,
                DROP INDEX `index_idsite_datetime_config`,
                ADD `idvisitor` BINARY(8) NOT NULL AFTER `idsite`,
                ADD `config_id` BINARY(8) NOT NULL AFTER `config_md5config`
               ', array(Updater\Migration\Db::ERROR_CODE_UNKNOWN_COLUMN, Updater\Migration\Db::ERROR_CODE_COLUMN_NOT_EXISTS)),
            $this->migration->db->sql('ALTER TABLE `' . Common::prefixTable('log_visit') . '`
                ADD `visit_entry_idaction_name` INT UNSIGNED NOT NULL AFTER `visit_entry_idaction_url`,
                ADD `visit_exit_idaction_name` INT UNSIGNED NOT NULL AFTER `visit_exit_idaction_url`,
                CHANGE `visit_exit_idaction_url` `visit_exit_idaction_url` INT UNSIGNED NOT NULL,
                CHANGE `visit_entry_idaction_url` `visit_entry_idaction_url` INT UNSIGNED NOT NULL,
                CHANGE `referer_type` `referer_type` TINYINT UNSIGNED NULL DEFAULT NULL,
                ADD visitor_count_visits SMALLINT(5) UNSIGNED NOT NULL AFTER `visitor_returning`,
                ADD visitor_days_since_last SMALLINT(5) UNSIGNED NOT NULL,
                ADD visitor_days_since_first SMALLINT(5) UNSIGNED NOT NULL
               ', Updater\Migration\Db::ERROR_CODE_DUPLICATE_COLUMN),

$this->migration->db->addColumns('log_visit', $customVarColumns),

$this->migration->db->addColumns('log_link_visit_action', array(
                'idsite' => 'INT( 10 ) UNSIGNED NOT NULL',
                'idvisitor' => 'BINARY(8) NOT NULL',
                'idaction_name_ref' => 'INT UNSIGNED NOT NULL'
            ), 'idlink_va'),

$this->migration->db->addColumn('log_link_visit_action', 'server_time', 'DATETIME', 'idsite'),
            $this->migration->db->addIndex('log_link_visit_action', array('idsite', 'server_time'), 'index_idsite_servertime'),
            
            $this->migration->db->sql('ALTER TABLE `' . Common::prefixTable('log_conversion') . '`
                DROP `referer_idvisit`,
                ADD `idvisitor` BINARY(8) NOT NULL AFTER `idsite`
               ', array(Updater\Migration\Db::ERROR_CODE_DUPLICATE_COLUMN, Updater\Migration\Db::ERROR_CODE_COLUMN_NOT_EXISTS)),
            $this->migration->db->addColumns('log_conversion', array(
                'visitor_count_visits' => 'SMALLINT(5) UNSIGNED NOT NULL',
                'visitor_days_since_first' => 'SMALLINT(5) UNSIGNED NOT NULL',
            )),
            $this->migration->db->addColumns('log_conversion', $customVarColumns),

// Migrate 128bits IDs inefficiently stored as 8bytes (256 bits) into 64bits
            $this->migration->db->sql('UPDATE ' . Common::prefixTable('log_visit') . '
                SET idvisitor = binary(unhex(substring(visitor_idcookie,1,16))),
                    config_id = binary(unhex(substring(config_md5config,1,16)))
                   ', Updater\Migration\Db::ERROR_CODE_UNKNOWN_COLUMN),
            $this->migration->db->sql('UPDATE ' . Common::prefixTable('log_conversion') . '
                SET idvisitor = binary(unhex(substring(visitor_idcookie,1,16)))
                   ', Updater\Migration\Db::ERROR_CODE_UNKNOWN_COLUMN),

// Drop migrated fields
            $this->migration->db->sql('ALTER TABLE `' . Common::prefixTable('log_visit') . '`
                DROP visitor_idcookie,
                DROP config_md5config
                ', Updater\Migration\Db::ERROR_CODE_COLUMN_NOT_EXISTS),
            $this->migration->db->sql('ALTER TABLE `' . Common::prefixTable('log_conversion') . '`
                DROP visitor_idcookie
                ', Updater\Migration\Db::ERROR_CODE_COLUMN_NOT_EXISTS),

// Recreate INDEX on new field
            $this->migration->db->addIndex('log_visit', array('idsite', 'visit_last_action_time', 'config_id'), 'index_idsite_datetime_config'),

// Backfill action logs as best as we can
            $this->migration->db->sql('UPDATE ' . Common::prefixTable('log_link_visit_action') . ' as action,
                      ' . Common::prefixTable('log_visit') . '  as visit
                SET action.idsite = visit.idsite,
                    action.server_time = visit.visit_last_action_time,
                    action.idvisitor = visit.idvisitor
                WHERE action.idvisit=visit.idvisit
                '),

$this->migration->db->changeColumnType('log_link_visit_action', 'server_time', 'DATETIME NOT NULL'),

// New index used max once per request, in case this table grows significantly in the future
            $this->migration->db->addIndex('option', 'autoload', 'autoload'),

// new field for websites
            $this->migration->db->addColumn('site', 'group', 'VARCHAR( 250 ) NOT NULL'),
        );
    }

public function doUpdate(Updater $updater)
    {
        // first we disable the plugins and keep an array of warnings messages
        $pluginsToDisableMessage = array(
            'GeoIP'     => "GeoIP plugin was disabled, because it is not compatible with the new Piwik 1.2. \nYou can download the latest version of the plugin, compatible with Piwik 1.2.\n<a target='_blank' rel='noopener' href='https://github.com/matomo-org/matomo/issues/45'>Click here.</a>",
            'EntryPage' => "EntryPage plugin is not compatible with this version of Matomo, it was disabled.",
        );
        $disabledPlugins = array();
        foreach ($pluginsToDisableMessage as $pluginToDisable => $warningMessage) {
            if (\Piwik\Plugin\Manager::getInstance()->isPluginActivated($pluginToDisable)) {
                \Piwik\Plugin\Manager::getInstance()->deactivatePlugin($pluginToDisable);
                $disabledPlugins[] = $warningMessage;
            }
        }

// Run the SQL
        $updater->executeMigrations(__FILE__, $this->getMigrations($updater));

// Outputs warning message, pointing users to the plugin download page
        if (!empty($disabledPlugins)) {
            throw new \Exception("The following plugins were disabled during the upgrade:"
                . "<ul><li>" .
                implode('</li><li>', $disabledPlugins) .
                "</li></ul>");
        }
    }
}

${this.title}

Code Editor : 1.2-rc1.php