Optimize Database after Deleting Revisions - Version 1.3.3

Version Description

No Upgrade Notice available.

Download this release

Release Info

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

Code changes from version 1.3.2 to 1.3.3

Files changed (2) hide show
  1. readme.txt +3 -2
  2. rvg-optimize-db.php +21 -21
readme.txt CHANGED
@@ -9,8 +9,8 @@ Author URI: http://cagewebdev.com
9
  Author: Rolf van Gelder, Eindhoven, The Netherlands
10
  Requires at least: 2.0
11
  Tested up to: 3.4.2
12
- Stable tag: 1.3.2
13
- Version: 1.3.2
14
 
15
  == Description ==
16
 
@@ -56,6 +56,7 @@ No Screenshots available.
56
  <p><b>1.3</b> 10/06/2012 Extra button for starting optimization, shows savings (in bytes) now</p>
57
  <p><b>1.3.1</b> 10/07/2012 Minor changes</p>
58
  <p><b>1.3.2</b> 11/14/2012 Shows more information about the optimized tables + other minor changes</p>
 
59
 
60
  == Frequently Asked Questions ==
61
 
9
  Author: Rolf van Gelder, Eindhoven, The Netherlands
10
  Requires at least: 2.0
11
  Tested up to: 3.4.2
12
+ Stable tag: 1.3.3
13
+ Version: 1.3.3
14
 
15
  == Description ==
16
 
56
  <p><b>1.3</b> 10/06/2012 Extra button for starting optimization, shows savings (in bytes) now</p>
57
  <p><b>1.3.1</b> 10/07/2012 Minor changes</p>
58
  <p><b>1.3.2</b> 11/14/2012 Shows more information about the optimized tables + other minor changes</p>
59
+ <p><b>1.3.3</b> 12/01/2012 Some layout changes</p>
60
 
61
  == Frequently Asked Questions ==
62
 
rvg-optimize-db.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
- $odb_version = '1.3.2';
3
- $odb_release_date = '11/14/2012';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 1.3.2
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 Deleting Revisions - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: Rolf van Gelder, Eindhoven, The Netherlands
13
- Version: 1.3.2
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
@@ -342,7 +342,7 @@ if($_REQUEST['action'] != 'run')
342
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
343
  <th align="left" style="border-bottom:solid 1px #999;">type</th>
344
  <th align="left" style="border-bottom:solid 1px #999;">IP address / title</th>
345
- <th align="left" style="border-bottom:solid 1px #999;">date</th>
346
  </tr>
347
  <?php
348
  $nr = 1;
@@ -351,10 +351,10 @@ if($_REQUEST['action'] != 'run')
351
  {
352
  ?>
353
  <tr>
354
- <td align="right"><?php echo $nr; ?></td>
355
- <td><?php echo $results[$i]->post_type; ?></td>
356
- <td><?php echo $results[$i]->title; ?></td>
357
- <td><?php echo $results[$i]->modified; ?></td>
358
  </tr>
359
  <?php
360
  if($results[$i]->post_type == 'comment')
@@ -427,7 +427,7 @@ if($_REQUEST['action'] != 'run')
427
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
428
  <th align="left" style="border-bottom:solid 1px #999;">comment author</th>
429
  <th align="left" style="border-bottom:solid 1px #999;">comment author email</th>
430
- <th align="left" style="border-bottom:solid 1px #999;">comment date</th>
431
  </tr>
432
  <?php
433
  $nr = 1;
@@ -436,10 +436,10 @@ if($_REQUEST['action'] != 'run')
436
  {
437
  ?>
438
  <tr>
439
- <td align="right"><?php echo $nr; ?></td>
440
- <td><?php echo $results[$i]->comment_author; ?></td>
441
- <td><?php echo $results[$i]->comment_author_email; ?></td>
442
- <td><?php echo $results[$i]->comment_date; ?></td>
443
  </tr>
444
  <?php
445
  $sql_delete = "
@@ -513,12 +513,12 @@ if($_REQUEST['action'] != 'run')
513
  $table_info = $wpdb -> get_results($sql);
514
  ?>
515
  <tr>
516
- <td align="right"><?php echo $cnt?>.</td>
517
- <td style="font-weight:bold;"><?php echo $row[0] ?></td>
518
- <td><?php echo $result[0]->Msg_text ?></td>
519
- <td><?php echo $table_info[0]->engine ?></td>
520
- <td align="right"><?php echo $table_info[0]->table_rows ?></td>
521
- <td align="right"><?php echo rvg_format_size($table_info[0]->size) ?></td>
522
  </tr>
523
  <?php
524
  } // if($wp_only == 'N' || ($wp_only == 'Y' && substr($row[0],0,strlen($table_prefix)) == $table_prefix))
@@ -534,7 +534,7 @@ $end_size = rvg_get_db_size();
534
  <td colspan="2" style="font-weight:bold;color:#00F;">SAVINGS:</td>
535
  </tr>
536
  <tr>
537
- <th xstyle="border-bottom:solid 1px #999;"></th>
538
  <th style="border-bottom:solid 1px #999;">size of the database</th>
539
  </tr>
540
  <tr>
1
  <?php
2
+ $odb_version = '1.3.3';
3
+ $odb_release_date = '12/01/2012';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 1.3.3
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 Deleting Revisions - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: Rolf van Gelder, Eindhoven, The Netherlands
13
+ Version: 1.3.3
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
342
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
343
  <th align="left" style="border-bottom:solid 1px #999;">type</th>
344
  <th align="left" style="border-bottom:solid 1px #999;">IP address / title</th>
345
+ <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;">date</th>
346
  </tr>
347
  <?php
348
  $nr = 1;
351
  {
352
  ?>
353
  <tr>
354
+ <td align="right" valign="top"><?php echo $nr; ?></td>
355
+ <td valign="top"><?php echo $results[$i]->post_type; ?></td>
356
+ <td valign="top"><?php echo $results[$i]->title; ?></td>
357
+ <td valign="top" nowrap="nowrap"><?php echo $results[$i]->modified; ?></td>
358
  </tr>
359
  <?php
360
  if($results[$i]->post_type == 'comment')
427
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
428
  <th align="left" style="border-bottom:solid 1px #999;">comment author</th>
429
  <th align="left" style="border-bottom:solid 1px #999;">comment author email</th>
430
+ <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;">comment date</th>
431
  </tr>
432
  <?php
433
  $nr = 1;
436
  {
437
  ?>
438
  <tr>
439
+ <td align="right" valign="top"><?php echo $nr; ?></td>
440
+ <td valign="top"><?php echo $results[$i]->comment_author; ?></td>
441
+ <td valign="top"><?php echo $results[$i]->comment_author_email; ?></td>
442
+ <td valign="top" nowrap="nowrap"><?php echo $results[$i]->comment_date; ?></td>
443
  </tr>
444
  <?php
445
  $sql_delete = "
513
  $table_info = $wpdb -> get_results($sql);
514
  ?>
515
  <tr>
516
+ <td align="right" valign="top"><?php echo $cnt?>.</td>
517
+ <td valign="top" style="font-weight:bold;"><?php echo $row[0] ?></td>
518
+ <td valign="top"><?php echo $result[0]->Msg_text ?></td>
519
+ <td valign="top"><?php echo $table_info[0]->engine ?></td>
520
+ <td align="right" valign="top"><?php echo $table_info[0]->table_rows ?></td>
521
+ <td align="right" valign="top"><?php echo rvg_format_size($table_info[0]->size) ?></td>
522
  </tr>
523
  <?php
524
  } // if($wp_only == 'N' || ($wp_only == 'Y' && substr($row[0],0,strlen($table_prefix)) == $table_prefix))
534
  <td colspan="2" style="font-weight:bold;color:#00F;">SAVINGS:</td>
535
  </tr>
536
  <tr>
537
+ <th>&nbsp;</th>
538
  <th style="border-bottom:solid 1px #999;">size of the database</th>
539
  </tr>
540
  <tr>