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_entry_pages = $wpdb->get_results($wpdb->prepare(
"SELECT entry_page_url, COUNT(*) AS c
FROM {$eistat_p}sessions
WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY) AND is_bot = 0
GROUP BY entry_page_url
ORDER BY c DESC
LIMIT 30",
$days
));
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
$eistat_exit_pages = $wpdb->get_results($wpdb->prepare(
"SELECT exit_page_url, COUNT(*) AS c
FROM {$eistat_p}sessions
WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY) AND is_bot = 0
GROUP BY exit_page_url
ORDER BY c DESC
LIMIT 30",
$days
));
$eistat_entry_total = 0;
foreach ($eistat_entry_pages as $r) { $eistat_entry_total += (int) $r->c; }
$eistat_exit_total = 0;
foreach ($eistat_exit_pages as $r) { $eistat_exit_total += (int) $r->c; }
?>
|
|
|
0 ? round((int) $pg->c / $eistat_exit_total * 100, 1) : 0;
?>
|
exit_page_url); ?>
|
c)); ?>
(%)
|