Optimize Database after Deleting Revisions - Version 1.1.1

Version Description

No Upgrade Notice available.

Download this release

Release Info

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

Code changes from version 1.1 to 1.1.1

Files changed (3) hide show
  1. rvg-optimize-db.php +6 -5
  2. trunk/readme.txt +52 -0
  3. trunk/rvg-optimize-db.php +243 -0
rvg-optimize-db.php CHANGED
@@ -1,16 +1,16 @@
1
  <?php
2
- $version = '1.1';
3
  $release_date = '08/30/2012';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 1.1
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="plugins.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: Rolf van Gelder, Eindhoven, The Netherlands
13
- Version: 1.1
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
@@ -61,6 +61,7 @@ function rvg_odb_options_page() {
61
  // Give an updated message
62
  echo "<div class='updated'><p><strong>Optimize Database after Deleting Revisions options updated</strong> - Click <a href='options-general.php?page=rvg-optimize-db.php' style='font-weight:bold'>HERE</a> to run the optimization</p></div>";
63
  }
 
64
  if(!$rvg_odb_number) $rvg_odb_number = '0';
65
 
66
  // Output the options page
@@ -74,7 +75,7 @@ function rvg_odb_options_page() {
74
  <p>Below you can define the <u>maximum number</u> of - most recent - revisions you want to <u>keep</u> per post or page.</p>
75
  <p>If you set the maximum number to '<strong>0</strong>' it means <strong>ALL REVISIONS</strong> will be deleted for all posts and pages.</p>
76
  <p>To start the optimization:<br />
77
- In the WordPress Dashboard go to &lsquo;<strong>Settings</strong>&lsquo;.<br />
78
  Click on &lsquo;<strong>Optimize Database</strong>&lsquo;. Et voila! </p>
79
  <p>Plugin version:<br />
80
  <strong>v<?php echo $version ?> (<?php echo $release_date?>)</strong> </p>
@@ -95,7 +96,7 @@ In the WordPress Dashboard go to &lsquo;<strong>Settings</st
95
  <tr>
96
  <td><label for="<?php echo rvg_odb_number; ?>" style="font-weight:bold;">Maximum number of - most recent - revisions to keep per post / page<br />
97
  </label></td>
98
- <td><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo get_option('rvg_odb_number')?>" style="font-weight:bold;color:#00F;" /></td>
99
  </tr>
100
  </table>
101
  </fieldset>
1
  <?php
2
+ $version = '1.1.1';
3
  $release_date = '08/30/2012';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 1.1.1
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="plugins.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: Rolf van Gelder, Eindhoven, The Netherlands
13
+ Version: 1.1.1
14
  Author URI: http://cagewebdev.com
15
  */
16
  ?>
61
  // Give an updated message
62
  echo "<div class='updated'><p><strong>Optimize Database after Deleting Revisions options updated</strong> - Click <a href='options-general.php?page=rvg-optimize-db.php' style='font-weight:bold'>HERE</a> to run the optimization</p></div>";
63
  }
64
+ $rvg_odb_number = get_option('rvg_odb_number');
65
  if(!$rvg_odb_number) $rvg_odb_number = '0';
66
 
67
  // Output the options page
75
  <p>Below you can define the <u>maximum number</u> of - most recent - revisions you want to <u>keep</u> per post or page.</p>
76
  <p>If you set the maximum number to '<strong>0</strong>' it means <strong>ALL REVISIONS</strong> will be deleted for all posts and pages.</p>
77
  <p>To start the optimization:<br />
78
+ In the WordPress Dashboard go to &lsquo;<strong>Settings</strong>&lsquo;.<br />
79
  Click on &lsquo;<strong>Optimize Database</strong>&lsquo;. Et voila! </p>
80
  <p>Plugin version:<br />
81
  <strong>v<?php echo $version ?> (<?php echo $release_date?>)</strong> </p>
96
  <tr>
97
  <td><label for="<?php echo rvg_odb_number; ?>" style="font-weight:bold;">Maximum number of - most recent - revisions to keep per post / page<br />
98
  </label></td>
99
+ <td><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" style="font-weight:bold;color:#00F;" /></td>
100
  </tr>
101
  </table>
102
  </fieldset>
trunk/readme.txt ADDED
@@ -0,0 +1,52 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ === Plugin Name ===
2
+
3
+ Contributors: Rolf van Gelder
4
+ Donate link: http://cagewebdev.com
5
+ Plugin Name: Optimize Database after Deleting Revisions
6
+ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
7
+ Tags: wp, database, delete, revisions, optimize, posts, pages
8
+ Author URI: http://cagewebdev.com
9
+ Author: Rolf van Gelder
10
+ Requires at least: 2.0
11
+ Tested up to: 3.4.1
12
+ Stable tag: 1.1
13
+ Version: 1.1
14
+
15
+ == Description ==
16
+
17
+ <p>This plugin is a 'one click' database optimizer.</p>
18
+ <p>It deletes the redundant revisions of posts and pages and, after that, optimizes all database tables.</p>
19
+ <p>http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin</p>
20
+
21
+ == Installation ==
22
+
23
+ <ol>
24
+ <li>Upload `rvg-optimize-db.php` to the `/wp-content/plugins/` directory</li>
25
+ <li>Activate the plugin through the 'Plugins' menu in the WordPress Dashboard</li>
26
+ </ol>
27
+
28
+ == Upgrade Notice ==
29
+
30
+ No Upgrade Notice available.
31
+
32
+ == Screenshots ==
33
+
34
+ No Screenshots available.
35
+
36
+ == Changelog ==
37
+
38
+ <p><b>1.0</b> 11/22/2011 Initial release</p>
39
+ <p><b>1.0.1</b> 11/24/2011 A few updates for the readme.txt file</p>
40
+ <p><b>1.0.2</b> 12/02/2011 Some minor updates</p>
41
+ <p><b>1.0.3</b> 12/15/2011 Some minor layout updates</p>
42
+ <p><b>1.0.4</b> 06/06/2012 Now also works with non short_open_tag's</p>
43
+ <p><b>1.0.5</b> 08/21/2012 Depreciated item ('has_cap') replaced, abandoned line of code removed</p>
44
+ <p><b>1.1</b> 08/29/2012 Added: a new option page, in de plugins section, where you can define the maximum number of - most recent - revisions you want to keep per post or page</p>
45
+
46
+ == Frequently Asked Questions ==
47
+
48
+ <p><b>Q:</b> How can I change the settings of this plugin?</p>
49
+ <p><b>A:</b> In the WordPress Dashboard go to '<b>Plugins / Optimize DB Options</b>'. There you can define the maximum number of - most recent - revisions you want to keep per post or page.</p>
50
+ <br /><br />
51
+ <p><b>Q:</b> How do I run this plugin?</p>
52
+ <p><b>A:</b> In the WordPress Dashboard go to '<b>Settings</b>'. Click on '<b>Optimize Database</b>'. Et voila!</p>
trunk/rvg-optimize-db.php ADDED
@@ -0,0 +1,243 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ $version = '1.1.1';
3
+ $release_date = '08/30/2012';
4
+ /**
5
+ * @package Optimize Database after Deleting Revisions
6
+ * @version 1.1.1
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="plugins.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
+ Author: Rolf van Gelder, Eindhoven, The Netherlands
13
+ Version: 1.1.1
14
+ Author URI: http://cagewebdev.com
15
+ */
16
+ ?>
17
+ <?php
18
+ /********************************************************************************************
19
+
20
+ ADD THE 'OPTIMIZE DATABASE' ITEM TO THE SETTINGS MENU
21
+
22
+ *********************************************************************************************/
23
+ function optimize_db_main()
24
+ { if (function_exists('add_options_page'))
25
+ { add_options_page('Optimize Database', 'Optimize Database','administrator' ,'rvg-optimize-db.php', 'rvg_optimize_db');
26
+ }
27
+ }
28
+ add_action('admin_menu', 'optimize_db_main');
29
+
30
+
31
+ /********************************************************************************************
32
+
33
+ ADD THE 'OPTIMIZE DATABASE OPTION' ITEM TO THE PLUGINS MENU
34
+
35
+ *********************************************************************************************/
36
+ function rvg_odb_admin_menu()
37
+ { $hook = add_submenu_page('plugins.php', __('Optimize DB Options'), __('Optimize DB Options'), 'manage_options', 'rvg_odb_admin', 'rvg_odb_options_page');
38
+ }
39
+ add_action( 'admin_menu', 'rvg_odb_admin_menu' );
40
+ function rvg_odb_option_page()
41
+ { add_options_page('Optimize Database Options', 'rvg_odb', 'manage_options', basename(__FILE__), 'rvg_odb_options_page');
42
+ }
43
+
44
+
45
+ /********************************************************************************************
46
+
47
+ CREATE THE OPTIONS PAGE
48
+
49
+ *********************************************************************************************/
50
+ function rvg_odb_options_page() {
51
+ global $version, $release_date;
52
+
53
+ // If we are a postback, store the options
54
+ if ( isset( $_POST['info_update'] ) ) {
55
+ check_admin_referer();
56
+
57
+ // Update the Project ID
58
+ $rvg_odb_number = trim($_POST['rvg_odb_number']);
59
+ update_option('rvg_odb_number', $rvg_odb_number);
60
+
61
+ // Give an updated message
62
+ echo "<div class='updated'><p><strong>Optimize Database after Deleting Revisions options updated</strong> - Click <a href='options-general.php?page=rvg-optimize-db.php' style='font-weight:bold'>HERE</a> to run the optimization</p></div>";
63
+ }
64
+ $rvg_odb_number = get_option('rvg_odb_number');
65
+ if(!$rvg_odb_number) $rvg_odb_number = '0';
66
+
67
+ // Output the options page
68
+ ?>
69
+ <form method="post" action="">
70
+ <div class="wrap">
71
+ <h2>Using Optimize Database after Deleting Revisions</h2>
72
+ <blockquote>
73
+ <p><strong>'<em>Optimize Database after Deleting Revisions</em>' is an one-click plugin to optimize your WordPress database.<br />
74
+ It deletes redundant revisions of posts and pages and, after that, optimizes all database tables.</strong></p>
75
+ <p>Below you can define the <u>maximum number</u> of - most recent - revisions you want to <u>keep</u> per post or page.</p>
76
+ <p>If you set the maximum number to '<strong>0</strong>' it means <strong>ALL REVISIONS</strong> will be deleted for all posts and pages.</p>
77
+ <p>To start the optimization:<br />
78
+ In the WordPress Dashboard go to &lsquo;<strong>Settings</strong>&lsquo;.<br />
79
+ Click on &lsquo;<strong>Optimize Database</strong>&lsquo;. Et voila! </p>
80
+ <p>Plugin version:<br />
81
+ <strong>v<?php echo $version ?> (<?php echo $release_date?>)</strong> </p>
82
+ <p>Author:<br />
83
+ <strong><a href="http://cage.nl/" target="_blank">Rolf van Gelder</a>, <a href="http://cagewebdev.com/" target="_blank">CAGE Web Design</a></strong>, Eindhoven, The Netherlands<br />
84
+ <br />
85
+ Plugin URL:<br />
86
+ <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank"><strong>http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/</strong></a><strong><br />
87
+ </strong><br />
88
+ Download URL:<br />
89
+ <strong><a href="http://wordpress.org/extend/plugins/rvg-optimize-database/" target="_blank">http://wordpress.org/extend/plugins/rvg-optimize-database/</a></strong></p>
90
+ <p>&nbsp;</p>
91
+ </blockquote>
92
+ <h2>Optimize Database after Deleting Revisions - Options</h2>
93
+ <blockquote>
94
+ <fieldset class='options'>
95
+ <table class="editform" cellspacing="2" cellpadding="5">
96
+ <tr>
97
+ <td><label for="<?php echo rvg_odb_number; ?>" style="font-weight:bold;">Maximum number of - most recent - revisions to keep per post / page<br />
98
+ </label></td>
99
+ <td><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" style="font-weight:bold;color:#00F;" /></td>
100
+ </tr>
101
+ </table>
102
+ </fieldset>
103
+ </blockquote>
104
+ <p class="submit">
105
+ <input type='submit' name='info_update' value='Update Options' />
106
+ </p>
107
+ </div>
108
+ </form>
109
+ <?php
110
+ }
111
+
112
+
113
+ /********************************************************************************************
114
+
115
+ MAIN FUNCTION FOR DELETING REVISIONS AND OPTIMIZING DATABASE TABLES
116
+
117
+ *********************************************************************************************/
118
+ function rvg_optimize_db()
119
+ {
120
+ global $wpdb, $version;
121
+
122
+ /****************************************************************************************
123
+
124
+ DELETE REVISIONS
125
+
126
+ ******************************************************************************************/
127
+ $max_revisions = get_option('rvg_odb_number');
128
+ ?>
129
+
130
+ <h2 style="padding-left:8px;">Optimizing your WordPress Database</h2>
131
+ <p><span style="padding-left:8px;font-style:italic;"><a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank" style="font-weight:bold;">Optimize Database after Deleting Revisions v<?php echo $version?></a> - A WordPress Plugin by <a href="http://cagewebdev.com/" target="_blank" style="font-weight:bold;">Rolf van Gelder</a>, Eindhoven, The Netherlands</span></p>
132
+ <p><span style="padding-left:8px;font-style:normal;">Maximum number of - most recent - revisions to keep per post / page: <span style="font-weight:bold;color:#00F;"><?php echo $max_revisions?></span> - click <a href="plugins.php?page=rvg_odb_admin" style="font-weight:bold;">HERE</a> to change this value.</span></p>
133
+ <?php
134
+ $sql = "
135
+ SELECT `post_parent`, `post_title`, COUNT(*) cnt
136
+ FROM $wpdb->posts
137
+ WHERE `post_type` = 'revision'
138
+ GROUP BY `post_parent`
139
+ HAVING COUNT(*) > ".$max_revisions."
140
+ ORDER BY UCASE(`post_title`)
141
+ ";
142
+ $results = $wpdb -> get_results($sql);
143
+
144
+ if(count($results)>0)
145
+ { // WE HAVE REVISIONS TO DELETE!
146
+ ?>
147
+ <table border="0" cellspacing="8" cellpadding="2">
148
+ <tr>
149
+ <td colspan="4" style="font-weight:bold;color:#00F;">DELETING REVISIONS:</td>
150
+ </tr>
151
+ <tr>
152
+ <th align="right" style="border-bottom:solid 1px #999;">#</th>
153
+ <th align="left" style="border-bottom:solid 1px #999;">post / page</th>
154
+ <th align="left" style="border-bottom:solid 1px #999;">revision date</th>
155
+ <th align="right" style="border-bottom:solid 1px #999;">revisions deleted</th>
156
+ </tr>
157
+ <?php
158
+ $nr = 1;
159
+ $total_deleted = 0;
160
+ for($i=0; $i<count($results); $i++)
161
+ { $nr_to_delete = $results[$i]->cnt - $max_revisions;
162
+ $total_deleted += $nr_to_delete;
163
+ ?>
164
+ <tr>
165
+ <td align="right" valign="top"><?php echo $nr?>.</td>
166
+ <td valign="top" style="font-weight:bold;"><?php echo $results[$i]->post_title?></td>
167
+ <td valign="top"><?php
168
+ $sql_get_posts = "
169
+ SELECT `ID`, `post_modified`
170
+ FROM $wpdb->posts
171
+ WHERE `post_parent`=".$results[$i]->post_parent."
172
+ AND `post_type`='revision'
173
+ ORDER BY `post_modified` ASC
174
+ ";
175
+ $results_get_posts = $wpdb -> get_results($sql_get_posts);
176
+ for($j=0; $j<$nr_to_delete; $j++)
177
+ {
178
+ echo $results_get_posts[$j]->post_modified.'<br />';
179
+ $sql_delete = "
180
+ DELETE FROM $wpdb->posts
181
+ WHERE `ID` = ".$results_get_posts[$j]->ID."
182
+ ";
183
+ $results_delete = $wpdb -> get_results($sql_delete);
184
+ }
185
+ $nr++;
186
+ ?></td>
187
+ <td align="right" valign="top" style="font-weight:bold;"><?php echo $nr_to_delete?></td>
188
+ </tr>
189
+ <?php
190
+ }
191
+ ?>
192
+ <tr>
193
+ <td colspan="3" align="right" style="border-top:solid 1px #999;font-weight:bold;">total number of revisions deleted</td>
194
+ <td align="right" style="border-top:solid 1px #999;font-weight:bold;"><?php echo $total_deleted?></td>
195
+ </tr>
196
+ </table>
197
+ <br />
198
+ <?php
199
+ }
200
+ else
201
+ {
202
+ echo '<br /><span style="font-weight:bold;color:#00F;padding-left:8px;">NO REVISIONS FOUND TO DELETE...</span><br /><br />';
203
+ }
204
+ ?>
205
+ <?php
206
+ /****************************************************************************************
207
+
208
+ OPTIMIZE TABLES
209
+
210
+ ******************************************************************************************/
211
+ # GET TABLE NAMES
212
+ $Tables = $wpdb -> get_results('SHOW TABLES IN '.DB_NAME);
213
+ $Tables_in_DB_NAME = 'Tables_in_'.DB_NAME;
214
+ ?>
215
+ <table border="0" cellspacing="8" cellpadding="2">
216
+ <tr>
217
+ <td colspan="3" style="font-weight:bold;color:#00F;">OPTIMIZING DATABASE TABLES:</td>
218
+ </tr>
219
+ <tr>
220
+ <th style="border-bottom:solid 1px #999;" align="right">#</th>
221
+ <th style="border-bottom:solid 1px #999;" align="left">table name</th>
222
+ <th style="border-bottom:solid 1px #999;" align="left">optimization result</th>
223
+ </tr>
224
+ <?php
225
+ for ($i=0; $i<count($Tables); $i++)
226
+ {
227
+ $query = "OPTIMIZE TABLE ".$Tables[$i]->$Tables_in_DB_NAME;
228
+ $result = $wpdb -> get_results($query);
229
+ ?>
230
+ <tr>
231
+ <td align="right"><?php echo ($i+1)?>.</td>
232
+ <td style="font-weight:bold;"><?php echo $Tables[$i]->$Tables_in_DB_NAME ?></td>
233
+ <td><?php echo $result[0]->Msg_text ?></td>
234
+ </tr>
235
+ <?php
236
+ }
237
+ ?>
238
+ </table>
239
+ <br />
240
+ <span style="font-weight:bold;color:#00F;padding-left:5px;">DONE!</span>
241
+ <?php
242
+ }
243
+ ?>