case 'activate-indexes': wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats ADD INDEX {$GLOBALS['wpdb']->prefix}stats_resource_idx(resource(20))"); wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats ADD INDEX {$GLOBALS['wpdb']->prefix}stats_browser_idx(browser(10))"); wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats ADD INDEX {$GLOBALS['wpdb']->prefix}stats_searchterms_idx(searchterms(15))"); wp_slimstat_admin::show_alert_message(__('Congrats! Slimstat is now optimized for <a href="http://www.youtube.com/watch?v=ygE01sOhzz0" target="_blank">ludicrous speed</a>.', 'wp-slimstat'), 'wp-ui-highlight below-h2'); break; case 'deactivate-indexes': wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats DROP INDEX {$GLOBALS['wpdb']->prefix}stats_resource_idx"); wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats DROP INDEX {$GLOBALS['wpdb']->prefix}stats_browser_idx"); wp_slimstat::$wpdb->query("ALTER TABLE {$GLOBALS['wpdb']->prefix}slim_stats DROP INDEX {$GLOBALS['wpdb']->prefix}stats_searchterms_idx"); wp_slimstat_admin::show_alert_message(__('Indexing has been disabled. Enjoy the extra database space!', 'wp-slimstat'), 'wp-ui-highlight below-h2'); break; case 'delete-records': $rows_affected = 0; if (key_exists($_REQUEST['f'], wp_slimstat_db::$columns_names)) { $rows_affected = wp_slimstat::$wpdb->query("\n\t\t\t\t\tDELETE t1.* \n\t\t\t\t\tFROM {$GLOBALS['wpdb']->prefix}slim_stats t1\n\t\t\t\t\tWHERE " . wp_slimstat_db::get_combined_where('', '*', false)); } wp_slimstat_admin::show_alert_message(intval($rows_affected) . ' ' . __('records deleted from your database.', 'wp-slimstat'), 'wp-ui-highlight below-h2'); break; case 'delete-maxmind': @unlink(wp_slimstat::$maxmind_path); wp_slimstat_admin::show_alert_message(__('The geolocation database has been uninstalled from your server.', 'wp-slimstat'), 'wp-ui-highlight below-h2'); break; case 'download-maxmind': $error = wp_slimstat::download_maxmind_database(); if (!empty($error)) { wp_slimstat_admin::show_alert_message($error, 'wp-ui-notification below-h2'); } else { wp_slimstat_admin::show_alert_message(__('The geolocation database has been installed on your server.', 'wp-slimstat'), 'wp-ui-highlight below-h2'); } break;
public static function get_top_events() { if (empty(self::$filters_normalized['columns'])) { $from = "{$GLOBALS['wpdb']->prefix}slim_events te"; $where = wp_slimstat_db::get_combined_where('te.type > 1', 'notes'); } else { $from = "{$GLOBALS['wpdb']->prefix}slim_events te INNER JOIN {$GLOBALS['wpdb']->prefix}slim_stats t1 ON te.id = t1.id"; $where = wp_slimstat_db::get_combined_where('te.type > 1', 'notes', true, 't1'); } return self::get_results("\n\t\t\tSELECT te.notes, te.type, COUNT(*) counthits\n\t\t\tFROM {$from}\n\t\t\tWHERE {$where}\n\t\t\tGROUP BY te.notes, te.type\n\t\t\tORDER BY counthits DESC"); }