prefix . 'eistat_'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended $days = isset($_GET['days']) && (int) $_GET['days'] === 28 ? 28 : 7; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $eistat_page_urls = []; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $eistat_rows = $wpdb->get_results($wpdb->prepare( "SELECT DISTINCT page_type, page_id, page_url FROM {$eistat_p}pageviews WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY)", $days )); foreach ($eistat_rows as $r) { $eistat_page_urls[$r->page_type . '|' . $r->page_id] = $r->page_url; } // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $eistat_transitions = $wpdb->get_results($wpdb->prepare( "SELECT from_page_type, from_page_id, to_page_type, to_page_id, SUM(count) AS c FROM {$eistat_p}transitions WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY) GROUP BY from_page_type, from_page_id, to_page_type, to_page_id ORDER BY c DESC LIMIT 50", $days )); ?>

from_page_type . '|' . $t->from_page_id; $eistat_to_key = $t->to_page_type . '|' . $t->to_page_id; $eistat_from_url = $eistat_page_urls[$eistat_from_key] ?? ''; $eistat_to_url = $eistat_page_urls[$eistat_to_key] ?? ''; ?>


from_page_id)); ?>	to_page_id)); ?>	c)); ?>