Optimize Database after Deleting Revisions - Version 2.7.9

Version Description

[05/02/2014] = * BUG FIX: some minor bug fixes (thanks Mike!)

Download this release

Release Info

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

Code changes from version 2.7.8 to 2.7.9

Files changed (2) hide show
  1. readme.txt +5 -2
  2. rvg-optimize-db.php +7 -47
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.0
10
  Tested up to: 3.9
11
- Stable tag: 2.7.8
12
- Version: 2.7.8
13
 
14
  == Description ==
15
 
@@ -54,6 +54,9 @@ No warranty, use at own risk!
54
 
55
  == Changelog ==
56
 
 
 
 
57
  = 2.7.8 [05/01/2014] =
58
  * CHANGE: replaced depreciated MySQL queries (from WP 3.9 / PHP 5.5)
59
 
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
 
54
 
55
  == Changelog ==
56
 
57
+ = 2.7.9 [05/02/2014] =
58
+ * BUG FIX: some minor bug fixes (thanks Mike!)
59
+
60
  = 2.7.8 [05/01/2014] =
61
  * CHANGE: replaced depreciated MySQL queries (from WP 3.9 / PHP 5.5)
62
 
rvg-optimize-db.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
- $odb_version = '2.7.8';
3
- $odb_release_date = '05/01/2014';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 2.7.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.7.8
14
  Author URI: http://cagewebdev.com
15
  */
16
 
@@ -113,11 +113,9 @@ function rvg_odb_options_page()
113
  echo '<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>';
114
  }
115
  else
116
- { echo '<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>';
 
117
  }
118
-
119
- # RVG_WP_ONLY IS DEPRECIATED FROM v2.2
120
- rvg_fix_wp_only();
121
 
122
  if(isset($_REQUEST['delete_log']))
123
  if($_REQUEST['delete_log'] == "Y") @unlink(dirname(__FILE__).'/rvg-optimize-db-log.html');
@@ -1346,9 +1344,6 @@ function rvg_optimize_tables($display)
1346
  {
1347
  global $wpdb, $table_prefix;
1348
 
1349
- # WP_ONLY IS DEPRECIATED FROM v2.2
1350
- rvg_fix_wp_only();
1351
-
1352
  # v2.7.8
1353
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
1354
  $dbname = 'Tables_in_'.DB_NAME;
@@ -1388,48 +1383,13 @@ function rvg_optimize_tables($display)
1388
  </tr>
1389
  <?php
1390
  } // if($display)
1391
- } // if($wp_only == 'N' || ($wp_only == 'Y' && substr($row[0],0,strlen($table_prefix)) == $table_prefix))
1392
  } // for ($i=0; $i<count($names); $i++)
1393
  return $cnt;
1394
 
1395
  } // rvg_optimize_tables ()
1396
 
1397
 
1398
- /********************************************************************************************
1399
-
1400
- FIX WP_ONLY (DEPRECIATED FROM v2.2)
1401
-
1402
- *********************************************************************************************/
1403
- function rvg_fix_wp_only()
1404
- {
1405
- global $wpdb, $table_prefix;
1406
-
1407
- $wp_only = get_option('rvg_wp_only');
1408
- if($wp_only == 'Y')
1409
- {
1410
- # v2.7.8
1411
- $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
1412
- $dbname = 'Tables_in_'.DB_NAME;
1413
- for ($i=0; $i<count($names); $i++)
1414
- { if(substr($names[$i]->$dbname,0,strlen($table_prefix)) != $table_prefix)
1415
- { // NOT A WORDPRESS TABLE: EXLUDE IT
1416
- $sql = "
1417
- INSERT INTO $wpdb->options (option_name, option_value, autoload)
1418
- VALUES ('rvg_ex_".$row[0]."','excluded','yes')
1419
- ";
1420
- $wpdb -> get_results($sql);
1421
- }
1422
- }
1423
- }
1424
- $sql = "
1425
- DELETE FROM $wpdb->options
1426
- WHERE `option_name` = 'rvg_wp_only'
1427
- ";
1428
- $wpdb -> get_results($sql);
1429
-
1430
- } # function rvg_fix_wp_only ()
1431
-
1432
-
1433
  /********************************************************************************************
1434
 
1435
  WRITE LINE TO LOG FILE
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
 
113
  echo '<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>';
114
  }
115
  else
116
+ { # 2.7.9
117
+ echo '<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>';
118
  }
 
 
 
119
 
120
  if(isset($_REQUEST['delete_log']))
121
  if($_REQUEST['delete_log'] == "Y") @unlink(dirname(__FILE__).'/rvg-optimize-db-log.html');
1344
  {
1345
  global $wpdb, $table_prefix;
1346
 
 
 
 
1347
  # v2.7.8
1348
  $names = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`");
1349
  $dbname = 'Tables_in_'.DB_NAME;
1383
  </tr>
1384
  <?php
1385
  } // if($display)
1386
+ } // if(!$excluded)
1387
  } // for ($i=0; $i<count($names); $i++)
1388
  return $cnt;
1389
 
1390
  } // rvg_optimize_tables ()
1391
 
1392
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1393
  /********************************************************************************************
1394
 
1395
  WRITE LINE TO LOG FILE