Optimize Database after Deleting Revisions - Version 4.2.3

Version Description

[07/05/2017] = * CHANGE: Extra save button added to the settings page

Download this release

Release Info

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

Code changes from version 4.2.2 to 4.2.3

Files changed (4) hide show
  1. classes/odb-displayer.php +2 -2
  2. includes/settings-page.php +10 -0
  3. readme.txt +14 -6
  4. rvg-optimize-database.php +5 -5
classes/odb-displayer.php CHANGED
@@ -35,11 +35,11 @@ class ODB_Displayer
35
  </p>
36
  <span class="odb-bold">
37
  '.__('Plugin version', $odb_class->odb_txt_domain).': v'.$odb_class->odb_version.' ['.$odb_class->odb_release_date.'] -
38
- <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank">'.__('Plugin page', $odb_class->odb_txt_domain).'</a> -
39
  <a href="http://wordpress.org/plugins/rvg-optimize-database/" target="_blank">'.__('Download page', $odb_class->odb_txt_domain).'</a> -
40
  <a href="http://rvg.cage.nl/" target="_blank">'.__('Author', $odb_class->odb_txt_domain).'</a> -
41
  <a href="http://cagewebdev.com/" target="_blank">'.__('Company', $odb_class->odb_txt_domain).'</a> -
42
- <a href="http://cagewebdev.com/index.php/donations-odb/" target="_blank">'.__('Donation page', $odb_class->odb_txt_domain).'</a>
43
  </span>
44
  </div><!-- odb-options-opening -->
45
  </div><!-- /odb-header -->
35
  </p>
36
  <span class="odb-bold">
37
  '.__('Plugin version', $odb_class->odb_txt_domain).': v'.$odb_class->odb_version.' ['.$odb_class->odb_release_date.'] -
38
+ <a href="http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank">'.__('Plugin page', $odb_class->odb_txt_domain).'</a> -
39
  <a href="http://wordpress.org/plugins/rvg-optimize-database/" target="_blank">'.__('Download page', $odb_class->odb_txt_domain).'</a> -
40
  <a href="http://rvg.cage.nl/" target="_blank">'.__('Author', $odb_class->odb_txt_domain).'</a> -
41
  <a href="http://cagewebdev.com/" target="_blank">'.__('Company', $odb_class->odb_txt_domain).'</a> -
42
+ <a href="http://cagewebdev.com/donations-odb/" target="_blank">'.__('Donation page', $odb_class->odb_txt_domain).'</a>
43
  </span>
44
  </div><!-- odb-options-opening -->
45
  </div><!-- /odb-header -->
includes/settings-page.php CHANGED
@@ -365,6 +365,16 @@ echo '
365
  </tr>
366
  </table>
367
  <div align="center"><em>* '.__('change will be visible after loading the next page', $this->odb_txt_domain).'</em></div>
 
 
 
 
 
 
 
 
 
 
368
  <br>
369
  <div align="center">
370
  <span class="odb-bold">
365
  </tr>
366
  </table>
367
  <div align="center"><em>* '.__('change will be visible after loading the next page', $this->odb_txt_domain).'</em></div>
368
+ <br>
369
+
370
+ <div id="odb-options-buttons" align="center">
371
+ <p>
372
+ <input class="button-primary button-large odb-bold" type="submit" name="info_update" value="'.__('Save Settings',$this->odb_txt_domain).'">
373
+ &nbsp;
374
+ <input class="button odb-normal" type="button" name="optimizer" value="'.__('Go To Optimizer',$this->odb_txt_domain).'" onclick="self.location=\'tools.php?page=rvg-optimize-database\'">
375
+ </p>
376
+ </div>
377
+ <!-- odb-options-buttons -->
378
  <br>
379
  <div align="center">
380
  <span class="odb-bold">
readme.txt CHANGED
@@ -1,15 +1,15 @@
1
  === Optimize Database after Deleting Revisions ===
2
  Contributors: CAGE Web Design | Rolf van Gelder
3
- Donate link: http://cagewebdev.com/index.php/donations-odb/
4
  Plugin Name: Optimize Database after Deleting Revisions
5
- Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler, transients, unused tags, pingback, trackback, unix cron tab, crontab, multisite
7
  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.8
11
- Stable tag: 4.2.2
12
- Version: 4.2.2
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -76,7 +76,7 @@ Then, start the .php file from your crontab!<br>
76
  CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl
77
 
78
  = Plugin URL =
79
- http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
80
 
81
  = Download URL =
82
  http://wordpress.org/plugins/rvg-optimize-database/
@@ -86,7 +86,7 @@ NO WARRANTY, USE IT AT YOUR OWN RISK!
86
 
87
  = Plugins by CAGE Web Design | Rolf van Gelder =
88
  WordPress plugins created by CAGE Web Design | Rolf van Gelder<br>
89
- http://cagewebdev.com/index.php/wordpress-plugins/
90
 
91
  == Installation ==
92
 
@@ -102,6 +102,9 @@ http://cagewebdev.com/index.php/wordpress-plugins/
102
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
103
 
104
  == Changelog ==
 
 
 
105
  = 4.2.2 [04/06/2017] =
106
  * NEW: Indonesian (id_ID) translation added
107
 
@@ -426,5 +429,10 @@ http://cagewebdev.com/index.php/wordpress-plugins/
426
  * That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
427
  * Update: if you want to optimize your InnoDB tables too, just check the 'Optimize InnoDB tables too' option on the settings page
428
 
 
 
 
 
 
429
  = I scheduled the optimization for 8pm but it runs at 6pm (my local time) =
430
  * The scheduler uses the local time of the web server which can differ from your own local time
1
  === Optimize Database after Deleting Revisions ===
2
  Contributors: CAGE Web Design | Rolf van Gelder
3
+ Donate link: http://cagewebdev.com/donations-odb/
4
  Plugin Name: Optimize Database after Deleting Revisions
5
+ Plugin URI: http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler, transients, unused tags, pingback, trackback, unix cron tab, crontab, multisite
7
  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.8
11
+ Stable tag: 4.2.3
12
+ Version: 4.2.3
13
  License: GPLv2 or later
14
 
15
  == Description ==
76
  CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl
77
 
78
  = Plugin URL =
79
+ http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin
80
 
81
  = Download URL =
82
  http://wordpress.org/plugins/rvg-optimize-database/
86
 
87
  = Plugins by CAGE Web Design | Rolf van Gelder =
88
  WordPress plugins created by CAGE Web Design | Rolf van Gelder<br>
89
+ http://cagewebdev.com/wordpress-plugins/
90
 
91
  == Installation ==
92
 
102
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
103
 
104
  == Changelog ==
105
+ = 4.2.3 [07/05/2017] =
106
+ * CHANGE: Extra save button added to the settings page
107
+
108
  = 4.2.2 [04/06/2017] =
109
  * NEW: Indonesian (id_ID) translation added
110
 
429
  * That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
430
  * Update: if you want to optimize your InnoDB tables too, just check the 'Optimize InnoDB tables too' option on the settings page
431
 
432
+ = After I ran the plugin, I got "Total savings since the first run: -64 KB" =
433
+ * Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).
434
+ Optimizing InnoDB tables works differently than MyISAM.
435
+ InnoDB focuses on speed optimization and sometimes it means the database can grow a little.
436
+
437
  = I scheduled the optimization for 8pm but it runs at 6pm (my local time) =
438
  * The scheduler uses the local time of the web server which can differ from your own local time
rvg-optimize-database.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 4.2.2
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
8
- Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/
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
  Network: True
13
- Version: 4.2.2
14
  */
15
 
16
  /********************************************************************************************
@@ -25,8 +25,8 @@ $odb_class = new OptimizeDatabase();
25
  class OptimizeDatabase
26
  {
27
  // VERSION
28
- var $odb_version = '4.2.2';
29
- var $odb_release_date = '04/06/2017';
30
 
31
  // PLUGIN OPTIONS
32
  var $odb_rvg_options = array();
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 4.2.3
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
8
+ Plugin URI: http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin/
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
  Network: True
13
+ Version: 4.2.3
14
  */
15
 
16
  /********************************************************************************************
25
  class OptimizeDatabase
26
  {
27
  // VERSION
28
+ var $odb_version = '4.2.3';
29
+ var $odb_release_date = '07/05/2017';
30
 
31
  // PLUGIN OPTIONS
32
  var $odb_rvg_options = array();