Optimize Database after Deleting Revisions - Version 2.8

Version Description

[07/30/2014] = * CHANGE: 'administrator'-role changed to 'edit_themes'-capability * BUG FIX: no table names beside checkboxes

Download this release

Release Info

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

Code changes from version 2.7.9 to 2.8

Files changed (2) hide show
  1. readme.txt +16 -4
  2. rvg-optimize-db.php +11 -7
readme.txt CHANGED
@@ -3,13 +3,14 @@ Contributors: CAGE Web Design | Rolf van Gelder
3
  Donate link: http://cagewebdev.com
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
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.0
10
- Tested up to: 3.9
11
- Stable tag: 2.7.9
12
- Version: 2.7.9
 
13
 
14
  == Description ==
15
 
@@ -46,6 +47,13 @@ http://wordpress.org/extend/plugins/rvg-optimize-database/
46
  = Disclaimer =
47
  No warranty, use at own risk!
48
 
 
 
 
 
 
 
 
49
  == Installation ==
50
 
51
  * Upload the Plugin to the `/wp-content/plugins/` directory
@@ -54,6 +62,10 @@ No warranty, use at own risk!
54
 
55
  == Changelog ==
56
 
 
 
 
 
57
  = 2.7.9 [05/02/2014] =
58
  * BUG FIX: some minor bug fixes (thanks Mike!)
59
 
3
  Donate link: http://cagewebdev.com
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
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.0
10
+ Tested up to: 3.9.1
11
+ Stable tag: 2.8
12
+ Version: 2.8
13
+ License: GPLv2 or later
14
 
15
  == Description ==
16
 
47
  = Disclaimer =
48
  No warranty, use at own risk!
49
 
50
+ = Other plugins by Rolf van Gelder =
51
+ Rocket Reader (Speed reader)
52
+ http://wordpress.org/plugins/rocket-reader-speed-reader/
53
+
54
+ Order your Posts Manually
55
+ http://wordpress.org/plugins/order-your-posts-manually/
56
+
57
  == Installation ==
58
 
59
  * Upload the Plugin to the `/wp-content/plugins/` directory
62
 
63
  == Changelog ==
64
 
65
+ = 2.8 [07/30/2014] =
66
+ * CHANGE: 'administrator'-role changed to 'edit_themes'-capability
67
+ * BUG FIX: no table names beside checkboxes
68
+
69
  = 2.7.9 [05/02/2014] =
70
  * BUG FIX: some minor bug fixes (thanks Mike!)
71
 
rvg-optimize-db.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
- $odb_version = '2.7.9';
3
- $odb_release_date = '05/02/2014';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 2.7.9
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.7.9
14
  Author URI: http://cagewebdev.com
15
  */
16
 
@@ -21,7 +21,9 @@ Author URI: http://cagewebdev.com
21
  *********************************************************************************************/
22
  function optimize_db_main()
23
  { if (function_exists('add_management_page'))
24
- { add_management_page(__('Optimize Database'), __('Optimize Database'),'administrator' ,'rvg-optimize-db.php', 'rvg_optimize_db');
 
 
25
  }
26
  }
27
  add_action('admin_menu', 'optimize_db_main');
@@ -350,7 +352,8 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
350
  <?php
351
  # v2.7.8
352
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
353
- $dbname = 'Tables_in_'.DB_NAME;
 
354
  ?>
355
  <tr>
356
  <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
@@ -1346,7 +1349,8 @@ function rvg_optimize_tables($display)
1346
 
1347
  # v2.7.8
1348
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
1349
- $dbname = 'Tables_in_'.DB_NAME;
 
1350
  $cnt = 0;
1351
  for ($i=0; $i<count($names); $i++)
1352
  {
1
  <?php
2
+ $odb_version = '2.8';
3
+ $odb_release_date = '07/30/2014';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 2.8
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.8
14
  Author URI: http://cagewebdev.com
15
  */
16
 
21
  *********************************************************************************************/
22
  function optimize_db_main()
23
  { if (function_exists('add_management_page'))
24
+ { // add_management_page(__('Optimize Database'), __('Optimize Database'), 'administrator','rvg-optimize-db.php', 'rvg_optimize_db');
25
+ # v2.8: 'administrator' role changed to 'edit_themes' capability
26
+ add_management_page(__('Optimize Database'), __('Optimize Database'), 'edit_themes', 'rvg-optimize-db.php', 'rvg_optimize_db');
27
  }
28
  }
29
  add_action('admin_menu', 'optimize_db_main');
352
  <?php
353
  # v2.7.8
354
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
355
+ # v2.8
356
+ $dbname = 'Tables_in_'.strtolower(DB_NAME);
357
  ?>
358
  <tr>
359
  <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
1349
 
1350
  # v2.7.8
1351
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
1352
+ # v2.8
1353
+ $dbname = 'Tables_in_'.strtolower(DB_NAME);
1354
  $cnt = 0;
1355
  for ($i=0; $i<count($names); $i++)
1356
  {