Optimize Database after Deleting Revisions - Version 3.5.1

Version Description

[11/01/2015] = * BUG FIX: Views are skipped from the optimization

Download this release

Release Info

Developer cageehv
Plugin Icon 128x128 Optimize Database after Deleting Revisions
Version 3.5.1
Comparing to
See all releases

Code changes from version 3.5 to 3.5.1

Files changed (2) hide show
  1. readme.txt +5 -2
  2. rvg-optimize-db.php +10 -9
readme.txt CHANGED
@@ -8,8 +8,8 @@ Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.8
10
  Tested up to: 4.3.1
11
- Stable tag: 3.5
12
- Version: 3.5
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -86,6 +86,9 @@ http://cagewebdev.com/index.php/wordpress-plugins/
86
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
87
 
88
  == Changelog ==
 
 
 
89
  = 3.5 [10/24/2015] =
90
  * CHANGE: Stylesheet is only loaded on required admin pages
91
 
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.8
10
  Tested up to: 4.3.1
11
+ Stable tag: 3.5.1
12
+ Version: 3.5.1
13
  License: GPLv2 or later
14
 
15
  == Description ==
86
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
87
 
88
  == Changelog ==
89
+ = 3.5.1 [11/01/2015] =
90
+ * BUG FIX: Views are skipped from the optimization
91
+
92
  = 3.5 [10/24/2015] =
93
  * CHANGE: Stylesheet is only loaded on required admin pages
94
 
rvg-optimize-db.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 3.5
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
@@ -9,11 +9,11 @@ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-rev
9
  Description: Optimizes the Wordpress Database after Cleaning it out
10
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
11
  Author URI: http://cagewebdev.com
12
- Version: 3.5
13
  */
14
 
15
- $odb_version = '3.5';
16
- $odb_release_date = '10/24/2015';
17
 
18
  // v3.3 - MULTISITE
19
  $odb_ms_prefixes = array();
@@ -196,9 +196,9 @@ function rvg_odb_uninstall()
196
  {
197
  global $wpdb, $odb_ms_prefixes;
198
 
199
- $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`", ARRAY_N);
200
 
201
- // DELETE ALL POSSIBLY EXCLUDED TABLES
202
  for ($i=0; $i<count($tables); $i++) rvg_odb_delete_option('rvg_ex_'.$tables[$i][0].'');
203
 
204
  // DELETE THE OTHER OPTIONS
@@ -313,7 +313,8 @@ function rvg_odb_settings_page()
313
  {
314
  global $odb_version, $odb_release_date, $wpdb, $table_prefix, $odb_ms_prefixes;
315
 
316
- $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`", ARRAY_N);
 
317
 
318
  // v3.3 - GET NETWORK INFORMATION (MULTISITE)
319
  rvg_odb_network_info();
@@ -1856,8 +1857,8 @@ function rvg_optimize_tables($display)
1856
  {
1857
  global $wpdb;
1858
 
1859
- # v2.8.2
1860
- $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`", ARRAY_N);
1861
  // print_r($tables);
1862
 
1863
  $cnt = 0;
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 3.5.1
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
9
  Description: Optimizes the Wordpress Database after Cleaning it out
10
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
11
  Author URI: http://cagewebdev.com
12
+ Version: 3.5.1
13
  */
14
 
15
+ $odb_version = '3.5.1';
16
+ $odb_release_date = '11/01/2015';
17
 
18
  // v3.3 - MULTISITE
19
  $odb_ms_prefixes = array();
196
  {
197
  global $wpdb, $odb_ms_prefixes;
198
 
199
+ $tables = $wpdb->get_results("SHOW FULL TABLES FROM `".DB_NAME."` WHERE table_type = 'BASE TABLE'", ARRAY_N);
200
 
201
+ // DELETE ALL POSSIBLY EXCLUDED TABLES FROM THE OPTIONS
202
  for ($i=0; $i<count($tables); $i++) rvg_odb_delete_option('rvg_ex_'.$tables[$i][0].'');
203
 
204
  // DELETE THE OTHER OPTIONS
313
  {
314
  global $odb_version, $odb_release_date, $wpdb, $table_prefix, $odb_ms_prefixes;
315
 
316
+ // v3.5.1 - SKIP VIEWS
317
+ $tables = $wpdb->get_results("SHOW FULL TABLES FROM `".DB_NAME."` WHERE table_type = 'BASE TABLE'", ARRAY_N);
318
 
319
  // v3.3 - GET NETWORK INFORMATION (MULTISITE)
320
  rvg_odb_network_info();
1857
  {
1858
  global $wpdb;
1859
 
1860
+ # v3.5.1 - SKIP VIEWS
1861
+ $tables = $wpdb->get_results("SHOW FULL TABLES FROM `".DB_NAME."` WHERE table_type = 'BASE TABLE'", ARRAY_N);
1862
  // print_r($tables);
1863
 
1864
  $cnt = 0;