Optimize Database after Deleting Revisions - Version 2.2.5

Version Description

[02/20/2013] = * Bug fix: fixed an (innocent) PHP warning (in error.log)

Download this release

Release Info

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

Code changes from version 2.2.4 to 2.2.5

Files changed (2) hide show
  1. readme.txt +7 -4
  2. rvg-optimize-db.php +9 -9
readme.txt CHANGED
@@ -6,10 +6,10 @@ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-rev
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
- Requires at least: 2.2.4
10
- Tested up to: 3.5
11
- Stable tag: 2.2.4
12
- Version: 2.2.4
13
 
14
  == Description ==
15
 
@@ -48,6 +48,9 @@ http://wordpress.org/extend/plugins/rvg-optimize-database/
48
 
49
  == Changelog ==
50
 
 
 
 
51
  = 2.2.4 [02/12/2013] =
52
  * Bug fix: error corrected in readme.txt file
53
 
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
+ Requires at least: 2.2.5
10
+ Tested up to: 3.5.1
11
+ Stable tag: 2.2.5
12
+ Version: 2.2.5
13
 
14
  == Description ==
15
 
48
 
49
  == Changelog ==
50
 
51
+ = 2.2.5 [02/20/2013] =
52
+ * Bug fix: fixed an (innocent) PHP warning (in error.log)
53
+
54
  = 2.2.4 [02/12/2013] =
55
  * Bug fix: error corrected in readme.txt file
56
 
rvg-optimize-db.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
- $odb_version = '2.2.4';
3
- $odb_release_date = '02/12/2013';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 2.2.4
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
10
  Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/
11
  Description: Optimizes the Wordpress Database after Cleaning it out - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
- Version: 2.2.4
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
@@ -999,7 +999,7 @@ function rvg_optimize_tables($display)
999
  $result = $wpdb -> get_results($query);
1000
 
1001
  $sql = "
1002
- SELECT engine, SUM(data_length + index_length) AS size, table_rows
1003
  FROM information_schema.TABLES
1004
  WHERE table_schema = '".strtolower(DB_NAME)."'
1005
  AND table_name = '".$row[0]."'
@@ -1022,7 +1022,6 @@ function rvg_optimize_tables($display)
1022
  } // if($display)
1023
  } // if($wp_only == 'N' || ($wp_only == 'Y' && substr($row[0],0,strlen($table_prefix)) == $table_prefix))
1024
  } // while($row = mysql_fetch_row($names))
1025
-
1026
  return $cnt;
1027
 
1028
  } // rvg_optimize_tables()
@@ -1235,9 +1234,10 @@ function rvg_get_db_size()
1235
  global $wpdb;
1236
 
1237
  $sql = "
1238
- SELECT SUM(data_length + index_length) AS size
1239
- FROM information_schema.TABLES
1240
- WHERE table_schema = '".strtolower(DB_NAME)."'
 
1241
  ";
1242
 
1243
  $res = $wpdb -> get_results($sql);
1
  <?php
2
+ $odb_version = '2.2.5';
3
+ $odb_release_date = '02/20/2013';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 2.2.5
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
10
  Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/
11
  Description: Optimizes the Wordpress Database after Cleaning it out - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
+ Version: 2.2.5
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
999
  $result = $wpdb -> get_results($query);
1000
 
1001
  $sql = "
1002
+ SELECT engine, (data_length + index_length) as size, table_rows
1003
  FROM information_schema.TABLES
1004
  WHERE table_schema = '".strtolower(DB_NAME)."'
1005
  AND table_name = '".$row[0]."'
1022
  } // if($display)
1023
  } // if($wp_only == 'N' || ($wp_only == 'Y' && substr($row[0],0,strlen($table_prefix)) == $table_prefix))
1024
  } // while($row = mysql_fetch_row($names))
 
1025
  return $cnt;
1026
 
1027
  } // rvg_optimize_tables()
1234
  global $wpdb;
1235
 
1236
  $sql = "
1237
+ SELECT SUM(data_length + index_length) size
1238
+ FROM information_schema.TABLES
1239
+ WHERE table_schema = '".strtolower(DB_NAME)."'
1240
+ GROUP BY table_schema
1241
  ";
1242
 
1243
  $res = $wpdb -> get_results($sql);