Optimize Database after Deleting Revisions - Version 4.9.1

Version Description

[05/17/2020] = * BUG FIX: Fixed a bug for deleting orphans

Download this release

Release Info

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

Code changes from version 4.9 to 4.9.1

Files changed (3) hide show
  1. classes/odb-cleaner.php +4 -2
  2. readme.txt +6 -3
  3. rvg-optimize-database.php +4 -4
classes/odb-cleaner.php CHANGED
@@ -1820,7 +1820,7 @@ function odb_confirm_delete() {
1820
  $sql = sprintf ("
1821
  SELECT '%s' AS site,
1822
  `post_id` AS ID,
1823
- 'meta' AS type,
1824
  '' AS post_title,
1825
  '' AS post_modified,
1826
  '' AS term_taxonomy_id,
@@ -1829,7 +1829,8 @@ function odb_confirm_delete() {
1829
  FROM %spostmeta
1830
  WHERE post_id NOT IN (SELECT ID FROM %sposts)
1831
  ORDER BY `meta_key`
1832
- ", $prefix, $prefix, $prefix);
 
1833
 
1834
  $results = $wpdb->get_results($sql, ARRAY_A);
1835
  for ($j = 0; $j < count($results); $j++) {
@@ -1894,6 +1895,7 @@ function odb_confirm_delete() {
1894
  } // if (!$scheduler && ($action == 'analyze_detail' || $action == 'run_detail'))
1895
 
1896
  if ($scheduler || $action == 'run_summary' || $action == 'run_detail') {
 
1897
  for($j = 0; $j < count($results); $j++) {
1898
  // DELETE METADATA FOR THIS COMMENT (IF ANY)
1899
  if ($results[$j]['type'] == 'post meta') {
1820
  $sql = sprintf ("
1821
  SELECT '%s' AS site,
1822
  `post_id` AS ID,
1823
+ 'post meta' AS type,
1824
  '' AS post_title,
1825
  '' AS post_modified,
1826
  '' AS term_taxonomy_id,
1829
  FROM %spostmeta
1830
  WHERE post_id NOT IN (SELECT ID FROM %sposts)
1831
  ORDER BY `meta_key`
1832
+ ", $prefix, $prefix, $prefix);
1833
+ //echo $sql . '<br>';
1834
 
1835
  $results = $wpdb->get_results($sql, ARRAY_A);
1836
  for ($j = 0; $j < count($results); $j++) {
1895
  } // if (!$scheduler && ($action == 'analyze_detail' || $action == 'run_detail'))
1896
 
1897
  if ($scheduler || $action == 'run_summary' || $action == 'run_detail') {
1898
+ $sql = "";
1899
  for($j = 0; $j < count($results); $j++) {
1900
  // DELETE METADATA FOR THIS COMMENT (IF ANY)
1901
  if ($results[$j]['type'] == 'post meta') {
readme.txt CHANGED
@@ -9,9 +9,9 @@ Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Contributors: cageehv
10
  Requires at least: 2.8
11
  Requires PHP: 5.0
12
- Tested up to: 5.4
13
- Stable tag: 4.9
14
- Version: 4.9
15
  License: GPLv2 or later
16
 
17
  == Description ==
@@ -111,6 +111,9 @@ http://cagewebdev.com/category/news-tech-art/wordpress/
111
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
112
 
113
  == Changelog ==
 
 
 
114
  = 4.9 [04/10/2020] =
115
  * NEW: Deletion of orphaned term relationships
116
 
9
  Contributors: cageehv
10
  Requires at least: 2.8
11
  Requires PHP: 5.0
12
+ Tested up to: 5.4.1
13
+ Stable tag: 4.9.1
14
+ Version: 4.9.1
15
  License: GPLv2 or later
16
 
17
  == Description ==
111
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
112
 
113
  == Changelog ==
114
+ = 4.9.1 [05/17/2020] =
115
+ * BUG FIX: Fixed a bug for deleting orphans
116
+
117
  = 4.9 [04/10/2020] =
118
  * NEW: Deletion of orphaned term relationships
119
 
rvg-optimize-database.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 4.9
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
@@ -10,7 +10,7 @@ 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
  Network: True
13
- Version: 4.9
14
  */
15
 
16
  /********************************************************************************************
@@ -28,8 +28,8 @@ $odb_class = new OptimizeDatabase();
28
 
29
  class OptimizeDatabase {
30
  // VERSION
31
- var $odb_version = '4.9';
32
- var $odb_release_date = '04/10/2020';
33
 
34
  // PLUGIN OPTIONS
35
  var $odb_rvg_options = array();
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 4.9.1
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
10
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
11
  Author URI: http://cagewebdev.com
12
  Network: True
13
+ Version: 4.9.1
14
  */
15
 
16
  /********************************************************************************************
28
 
29
  class OptimizeDatabase {
30
  // VERSION
31
+ var $odb_version = '4.9.1';
32
+ var $odb_release_date = '05/17/2020';
33
 
34
  // PLUGIN OPTIONS
35
  var $odb_rvg_options = array();