Optimize Database after Deleting Revisions - Version 4.6.3

Version Description

[08/23/2018] = * CHANGE: Removed the MyISAM engine for the log table (now it uses the default-storage-engine of the database)

Download this release

Release Info

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

Code changes from version 4.6.2 to 4.6.3

Files changed (5) hide show
  1. classes/odb-cleaner.php +59 -8
  2. language/rvg-optimize-database-nl_NL.mo +0 -0
  3. language/rvg-optimize-database-nl_NL.po +62 -63
  4. readme.txt +7 -3
  5. rvg-optimize-database.php +7 -5
classes/odb-cleaner.php CHANGED
@@ -1262,13 +1262,25 @@ function odb_confirm_delete() {
1262
  // SKIP InnoDB tables
1263
  $msg = __('InnoDB table: skipped...', 'rvg-optimize-database');
1264
  } else {
1265
- $query = "OPTIMIZE TABLE ".$odb_class->odb_tables[$i][0];
1266
- $result = $wpdb->get_results($query);
1267
- $msg = $result[0]->Msg_text;
1268
- $msg = str_replace('OK', __('<span class="odb-optimized">TABLE OPTIMIZED</span>', 'rvg-optimize-database'), $msg);
1269
- $msg = str_replace('Table is already up to date', __('Table is already up to date', 'rvg-optimize-database'), $msg);
1270
- $msg = str_replace('Table does not support optimize, doing recreate + analyze instead', __('<span class="odb-optimized">TABLE OPTIMIZED</span>', 'rvg-optimize-database'), $msg);
1271
- }
 
 
 
 
 
 
 
 
 
 
 
 
1272
 
1273
  if (!$scheduler)
1274
  { // NOT FROM THE SCEDULER
@@ -1287,7 +1299,46 @@ function odb_confirm_delete() {
1287
  } // for ($i=0; $i<count($tables); $i++)
1288
  return $cnt;
1289
 
1290
- } // odb_optimize_tables()
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1291
 
1292
  } // ODB_Cleaner
1293
  ?>
1262
  // SKIP InnoDB tables
1263
  $msg = __('InnoDB table: skipped...', 'rvg-optimize-database');
1264
  } else {
1265
+ // v4.6.3
1266
+ if (strtolower($table_info[0]->engine) == 'myisam') {
1267
+ $result = $this->odb_optimize_myisam($odb_class->odb_tables[$i][0]);
1268
+ $msg = $result[0]->Msg_text;
1269
+ if ($msg == 'OK') {
1270
+ $msg = __('<span class="odb-optimized">TABLE OPTIMIZED</span>', 'rvg-optimize-database');
1271
+ } else if ($msg == 'Table is already up to date') {
1272
+ $msg = __('Table is already up to date', 'rvg-optimize-database');
1273
+ }
1274
+ } else {
1275
+ $result = $this->odb_optimize_innodb($odb_class->odb_tables[$i][0]);
1276
+ $msg = $result[0]->Msg_text;
1277
+ if ($msg == 'Table is already up to date') {
1278
+ $msg = __('Table is already up to date', 'rvg-optimize-database');
1279
+ } else {
1280
+ $msg = __('<span class="odb-optimized">TABLE OPTIMIZED</span>', 'rvg-optimize-database');
1281
+ }
1282
+ } // if (strtolower($table_info[0]->engine) == 'myisam')
1283
+ } // if($odb_class->odb_rvg_options["optimize_innodb"] == 'N' && strtolower($table_info[0]->engine) == 'innodb')
1284
 
1285
  if (!$scheduler)
1286
  { // NOT FROM THE SCEDULER
1299
  } // for ($i=0; $i<count($tables); $i++)
1300
  return $cnt;
1301
 
1302
+ } // odb_optimize_tables()
1303
+
1304
+
1305
+ /********************************************************************************************
1306
+ * OPTIMIZE A MyISAM TABLE
1307
+ ********************************************************************************************/
1308
+ function odb_optimize_myisam($table_name) {
1309
+ global $wpdb;
1310
+ $query = "OPTIMIZE TABLE " . $table_name;
1311
+ return $wpdb->get_results($query);
1312
+ } // odb_optimize_myisam()
1313
+
1314
+
1315
+ /********************************************************************************************
1316
+ * OPTIMIZE AN InnoDB TABLE
1317
+ ********************************************************************************************/
1318
+ function odb_optimize_innodb($table_name) {
1319
+ global $wpdb;
1320
+
1321
+ $query = "OPTIMIZE TABLE " . $table_name;
1322
+ return $wpdb->get_results($query);
1323
+
1324
+ /* // https://www.percona.com/blog/2010/12/09/mysql-optimize-tables-innodb-stop/
1325
+ $query = "SHOW KEYS FROM " . $table_name . " WHERE Key_name <> 'PRIMARY'";
1326
+ $result = $wpdb->get_results($query);
1327
+ if (count($result) > 0) {
1328
+ for ($i = 0; $i < count($result); $i++) {
1329
+ $key_name = $result[$i]->Key_name;
1330
+
1331
+ $query = "ALTER TABLE " . $table_name . " DROP KEY " . $key_name;
1332
+ $result = $wpdb->get_results($query);
1333
+
1334
+ $query = "ALTER TABLE " . $table_name . " add key(" . $key_name . ")";
1335
+ $result = $wpdb->get_results($query);
1336
+ } // for ($i = 0; $i < count($result); $i++)
1337
+ return __('<span class="odb-optimized">TABLE OPTIMIZED</span>', 'rvg-optimize-database');
1338
+ } else {
1339
+ return __('Table is already up to date', 'rvg-optimize-database');
1340
+ } // if (count($result) > 0*/
1341
+ } // odb_optimize_innodb()
1342
 
1343
  } // ODB_Cleaner
1344
  ?>
language/rvg-optimize-database-nl_NL.mo CHANGED
Binary file
language/rvg-optimize-database-nl_NL.po CHANGED
@@ -2,8 +2,8 @@ msgid ""
2
  msgstr ""
3
  "Project-Id-Version: Optimize Database after Deleting Revisions v4.3\n"
4
  "Report-Msgid-Bugs-To: \n"
5
- "POT-Creation-Date: 2018-06-05 13:33+0200\n"
6
- "PO-Revision-Date: 2018-06-05 13:34+0200\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: nl_NL\n"
@@ -205,21 +205,21 @@ msgstr "KLAAR!"
205
  msgid "Optimization took"
206
  msgstr "Optimalizatie duurde"
207
 
208
- #: classes/odb-cleaner.php:509 classes/odb-displayer.php:130
209
- #: classes/odb-displayer.php:165
210
  msgid "seconds"
211
  msgstr "seconden"
212
 
213
- #: classes/odb-cleaner.php:520 classes/odb-displayer.php:187
214
  #: classes/odb-logger.php:157
215
  msgid "Clear the log?"
216
  msgstr "Logs wissen?"
217
 
218
- #: classes/odb-cleaner.php:530 classes/odb-displayer.php:206
219
  msgid "View Log"
220
  msgstr "Bekijk Logs"
221
 
222
- #: classes/odb-cleaner.php:532 classes/odb-displayer.php:208
223
  #: classes/odb-logger.php:170
224
  msgid "Clear Log"
225
  msgstr "Wis Logs"
@@ -232,11 +232,11 @@ msgstr "van"
232
  msgid "InnoDB table: skipped..."
233
  msgstr "InnoDB tabel overgeslagen..."
234
 
235
- #: classes/odb-cleaner.php:1268 classes/odb-cleaner.php:1270
236
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
237
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
238
 
239
- #: classes/odb-cleaner.php:1269
240
  msgid "Table is already up to date"
241
  msgstr "Tabel is al optimaal"
242
 
@@ -244,185 +244,181 @@ msgstr "Tabel is al optimaal"
244
  msgid "Optimize Database after Deleting Revisions"
245
  msgstr "Optimize Database after Deleting Revisions"
246
 
247
- #: classes/odb-displayer.php:32
248
  msgid ""
249
  "A popular 'one-click' plugin to clean and optimize your WordPress database."
250
  msgstr ""
251
  "Een populaire 'one-click' plugin om de WordPress database op te schonen en "
252
  "te optimaliseren."
253
 
254
- #: classes/odb-displayer.php:35
255
  msgid "Plugin version"
256
  msgstr "Plugin versie"
257
 
258
- #: classes/odb-displayer.php:36
259
  msgid "Plugin page"
260
  msgstr "Pluginpagina"
261
 
262
- #: classes/odb-displayer.php:37
263
  msgid "Download page"
264
  msgstr "Downloadpagina"
265
 
266
- #: classes/odb-displayer.php:38
267
  msgid "Author"
268
  msgstr "Auteur"
269
 
270
- #: classes/odb-displayer.php:39
271
  msgid "Company"
272
  msgstr "Bedrijf"
273
 
274
- #: classes/odb-displayer.php:40
275
- msgid "PLEASE DONATE!"
276
- msgstr "DONEER!"
277
-
278
- #: classes/odb-displayer.php:54
279
  msgid "YES"
280
  msgstr "JA"
281
 
282
- #: classes/odb-displayer.php:55
283
  msgid "NO"
284
  msgstr "NEE"
285
 
286
- #: classes/odb-displayer.php:63 includes/settings-page.php:321
287
  msgid "DELETE EXPIRED TRANSIENTS"
288
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
289
 
290
- #: classes/odb-displayer.php:65 includes/settings-page.php:324
291
  msgid "DELETE ALL TRANSIENTS"
292
  msgstr "VERWIJDER ALLE TRANSIENTS"
293
 
294
- #: classes/odb-displayer.php:77
295
  msgid "EVERY FIVE MINUTES"
296
  msgstr "IEDERE VIJF MINUTEN"
297
 
298
- #: classes/odb-displayer.php:79
299
  msgid "ONCE HOURLY"
300
  msgstr "ELK UUR"
301
 
302
- #: classes/odb-displayer.php:81
303
  msgid "TWICE DAILY"
304
  msgstr "TWEEMAAL DAAGS"
305
 
306
- #: classes/odb-displayer.php:83
307
  msgid "ONCE DAILY"
308
  msgstr "DAGELIJKS"
309
 
310
- #: classes/odb-displayer.php:85
311
  msgid "ONCE WEEKLY"
312
  msgstr "WEKELIJKS"
313
 
314
- #: classes/odb-displayer.php:87
315
  msgid "ONCE MONTHLY"
316
  msgstr "MAANDELIJKS"
317
 
318
- #: classes/odb-displayer.php:88 includes/settings-page.php:361
319
  msgid "NOT SCHEDULED"
320
  msgstr "NIET GEPLAND"
321
 
322
- #: classes/odb-displayer.php:93
323
  msgid "Current settings"
324
  msgstr "Huidige instellingen"
325
 
326
- #: classes/odb-displayer.php:108
327
  msgid "NONE"
328
  msgstr "GEEN"
329
 
330
- #: classes/odb-displayer.php:110
331
  msgid "Delete revisions of"
332
  msgstr "Verwijder revisies van"
333
 
334
- #: classes/odb-displayer.php:113 includes/settings-page.php:152
335
  #: includes/settings-page.php:263
336
  msgid "Delete revisions older than"
337
  msgstr "Verwijder revisies ouder dan"
338
 
339
- #: classes/odb-displayer.php:113 classes/odb-displayer.php:161
340
  msgid "days"
341
  msgstr "dagen"
342
 
343
- #: classes/odb-displayer.php:117
344
  msgid "Maximum number of - most recent - revisions to keep per post / page"
345
  msgstr ""
346
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
347
  "pagina"
348
 
349
- #: classes/odb-displayer.php:121 includes/settings-page.php:296
350
  msgid "Delete trashed items"
351
  msgstr "Verwijder trashed items"
352
 
353
- #: classes/odb-displayer.php:122 includes/settings-page.php:302
354
  msgid "Delete spammed items"
355
  msgstr "Verwijder spammed items"
356
 
357
- #: classes/odb-displayer.php:123 includes/settings-page.php:308
358
  msgid "Delete unused tags"
359
  msgstr "Verwijder ongebruikte tags"
360
 
361
- #: classes/odb-displayer.php:124 includes/settings-page.php:314
362
  msgid "Delete transients"
363
  msgstr "Verwijder transiënts"
364
 
365
- #: classes/odb-displayer.php:125 includes/settings-page.php:333
366
  msgid "Delete pingbacks and trackbacks"
367
  msgstr "Verwijder pingback en trackbacks"
368
 
369
- #: classes/odb-displayer.php:126 includes/settings-page.php:339
370
  msgid "Clear oEmbed cache"
371
  msgstr "Leeg de oEmbed cache"
372
 
373
- #: classes/odb-displayer.php:127 includes/settings-page.php:351
374
  msgid "Keep a log"
375
  msgstr "Gebruik een logbestand"
376
 
377
- #: classes/odb-displayer.php:128
378
  msgid "Optimize InnoDB tables"
379
  msgstr "Optimaliseer InnoDB tabellen"
380
 
381
- #: classes/odb-displayer.php:129
382
  msgid "Number of excluded tables"
383
  msgstr "Aantal uitgesloten tabellen"
384
 
385
- #: classes/odb-displayer.php:130
386
  msgid "Last run"
387
  msgstr "Laatste uitvoering"
388
 
389
- #: classes/odb-displayer.php:130 includes/settings-page.php:395
390
  msgid "hrs"
391
  msgstr "uur"
392
 
393
- #: classes/odb-displayer.php:130
394
  msgid "in"
395
  msgstr "in"
396
 
397
- #: classes/odb-displayer.php:131 includes/settings-page.php:357
398
  msgid "Scheduler"
399
  msgstr "Planner"
400
 
401
- #: classes/odb-displayer.php:141
402
  msgid "Next scheduled run"
403
  msgstr "Volgende geplande uitvoering"
404
 
405
- #: classes/odb-displayer.php:146
406
  msgid "Total savings since the first run"
407
  msgstr "Totale besparing sinds de eerste uitvoering"
408
 
409
- #: classes/odb-displayer.php:162
410
  msgid "hours"
411
  msgstr "uur"
412
 
413
- #: classes/odb-displayer.php:163
414
  msgid "minutes"
415
  msgstr "minuten"
416
 
417
- #: classes/odb-displayer.php:164
418
  msgid "and"
419
  msgstr "en"
420
 
421
- #: classes/odb-displayer.php:180 classes/odb-logger.php:168
422
  msgid "Change Settings"
423
  msgstr "Wijzig instellingen"
424
 
425
- #: classes/odb-displayer.php:214 classes/odb-logger.php:174
426
  msgid "Start Optimization"
427
  msgstr "Start Optimalisatie"
428
 
@@ -570,7 +566,7 @@ msgstr "Je moet het <Maximaal aantal revisies> invullen"
570
  msgid "<Maximum number of revisions> should be a number"
571
  msgstr "<Maximaal aantal revisies> moet een getal zijn"
572
 
573
- #: includes/settings-page.php:227 rvg-optimize-database.php:454
574
  msgid "Settings"
575
  msgstr "Instellingen"
576
 
@@ -666,22 +662,25 @@ msgid "check all NON-WordPress tables"
666
  msgstr "vink alle NIET-WordPress tabellen aan"
667
 
668
  # @ rvg-optimize-database
669
- #: rvg-optimize-database.php:426 rvg-optimize-database.php:427
670
- #: rvg-optimize-database.php:441 rvg-optimize-database.php:442
671
- #: rvg-optimize-database.php:482 rvg-optimize-database.php:483
672
- #: rvg-optimize-database.php:500 rvg-optimize-database.php:501
673
  msgid "Optimize Database"
674
  msgstr "Optimaliseer Database"
675
 
676
  # @ optimize_db
677
- #: rvg-optimize-database.php:471
678
  msgid "Optimize DB (1 click)"
679
  msgstr "Optimaliseer DB (1 klik)"
680
 
681
- #: rvg-optimize-database.php:619
682
  msgid "Optimize Database after Deleting Revisions LOGS HAVE BEEN CLEARED"
683
  msgstr "Optimize Database after Deleting Revisions LOGS ZIJN VERWIJDERD"
684
 
 
 
 
685
  #~ msgid "Donation page"
686
  #~ msgstr "Donatiepagina"
687
 
2
  msgstr ""
3
  "Project-Id-Version: Optimize Database after Deleting Revisions v4.3\n"
4
  "Report-Msgid-Bugs-To: \n"
5
+ "POT-Creation-Date: 2018-06-26 15:19+0200\n"
6
+ "PO-Revision-Date: 2018-06-26 15:20+0200\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: nl_NL\n"
205
  msgid "Optimization took"
206
  msgstr "Optimalizatie duurde"
207
 
208
+ #: classes/odb-cleaner.php:509 classes/odb-displayer.php:139
209
+ #: classes/odb-displayer.php:174
210
  msgid "seconds"
211
  msgstr "seconden"
212
 
213
+ #: classes/odb-cleaner.php:520 classes/odb-displayer.php:196
214
  #: classes/odb-logger.php:157
215
  msgid "Clear the log?"
216
  msgstr "Logs wissen?"
217
 
218
+ #: classes/odb-cleaner.php:530 classes/odb-displayer.php:215
219
  msgid "View Log"
220
  msgstr "Bekijk Logs"
221
 
222
+ #: classes/odb-cleaner.php:532 classes/odb-displayer.php:217
223
  #: classes/odb-logger.php:170
224
  msgid "Clear Log"
225
  msgstr "Wis Logs"
232
  msgid "InnoDB table: skipped..."
233
  msgstr "InnoDB tabel overgeslagen..."
234
 
235
+ #: classes/odb-cleaner.php:1270 classes/odb-cleaner.php:1318
236
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
237
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
238
 
239
+ #: classes/odb-cleaner.php:1271 classes/odb-cleaner.php:1320
240
  msgid "Table is already up to date"
241
  msgstr "Tabel is al optimaal"
242
 
244
  msgid "Optimize Database after Deleting Revisions"
245
  msgstr "Optimize Database after Deleting Revisions"
246
 
247
+ #: classes/odb-displayer.php:33
248
  msgid ""
249
  "A popular 'one-click' plugin to clean and optimize your WordPress database."
250
  msgstr ""
251
  "Een populaire 'one-click' plugin om de WordPress database op te schonen en "
252
  "te optimaliseren."
253
 
254
+ #: classes/odb-displayer.php:34
255
  msgid "Plugin version"
256
  msgstr "Plugin versie"
257
 
258
+ #: classes/odb-displayer.php:34
259
  msgid "Plugin page"
260
  msgstr "Pluginpagina"
261
 
262
+ #: classes/odb-displayer.php:34
263
  msgid "Download page"
264
  msgstr "Downloadpagina"
265
 
266
+ #: classes/odb-displayer.php:34
267
  msgid "Author"
268
  msgstr "Auteur"
269
 
270
+ #: classes/odb-displayer.php:34
271
  msgid "Company"
272
  msgstr "Bedrijf"
273
 
274
+ #: classes/odb-displayer.php:63
 
 
 
 
275
  msgid "YES"
276
  msgstr "JA"
277
 
278
+ #: classes/odb-displayer.php:64
279
  msgid "NO"
280
  msgstr "NEE"
281
 
282
+ #: classes/odb-displayer.php:72 includes/settings-page.php:321
283
  msgid "DELETE EXPIRED TRANSIENTS"
284
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
285
 
286
+ #: classes/odb-displayer.php:74 includes/settings-page.php:324
287
  msgid "DELETE ALL TRANSIENTS"
288
  msgstr "VERWIJDER ALLE TRANSIENTS"
289
 
290
+ #: classes/odb-displayer.php:86
291
  msgid "EVERY FIVE MINUTES"
292
  msgstr "IEDERE VIJF MINUTEN"
293
 
294
+ #: classes/odb-displayer.php:88
295
  msgid "ONCE HOURLY"
296
  msgstr "ELK UUR"
297
 
298
+ #: classes/odb-displayer.php:90
299
  msgid "TWICE DAILY"
300
  msgstr "TWEEMAAL DAAGS"
301
 
302
+ #: classes/odb-displayer.php:92
303
  msgid "ONCE DAILY"
304
  msgstr "DAGELIJKS"
305
 
306
+ #: classes/odb-displayer.php:94
307
  msgid "ONCE WEEKLY"
308
  msgstr "WEKELIJKS"
309
 
310
+ #: classes/odb-displayer.php:96
311
  msgid "ONCE MONTHLY"
312
  msgstr "MAANDELIJKS"
313
 
314
+ #: classes/odb-displayer.php:97 includes/settings-page.php:361
315
  msgid "NOT SCHEDULED"
316
  msgstr "NIET GEPLAND"
317
 
318
+ #: classes/odb-displayer.php:102
319
  msgid "Current settings"
320
  msgstr "Huidige instellingen"
321
 
322
+ #: classes/odb-displayer.php:117
323
  msgid "NONE"
324
  msgstr "GEEN"
325
 
326
+ #: classes/odb-displayer.php:119
327
  msgid "Delete revisions of"
328
  msgstr "Verwijder revisies van"
329
 
330
+ #: classes/odb-displayer.php:122 includes/settings-page.php:152
331
  #: includes/settings-page.php:263
332
  msgid "Delete revisions older than"
333
  msgstr "Verwijder revisies ouder dan"
334
 
335
+ #: classes/odb-displayer.php:122 classes/odb-displayer.php:170
336
  msgid "days"
337
  msgstr "dagen"
338
 
339
+ #: classes/odb-displayer.php:126
340
  msgid "Maximum number of - most recent - revisions to keep per post / page"
341
  msgstr ""
342
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
343
  "pagina"
344
 
345
+ #: classes/odb-displayer.php:130 includes/settings-page.php:296
346
  msgid "Delete trashed items"
347
  msgstr "Verwijder trashed items"
348
 
349
+ #: classes/odb-displayer.php:131 includes/settings-page.php:302
350
  msgid "Delete spammed items"
351
  msgstr "Verwijder spammed items"
352
 
353
+ #: classes/odb-displayer.php:132 includes/settings-page.php:308
354
  msgid "Delete unused tags"
355
  msgstr "Verwijder ongebruikte tags"
356
 
357
+ #: classes/odb-displayer.php:133 includes/settings-page.php:314
358
  msgid "Delete transients"
359
  msgstr "Verwijder transiënts"
360
 
361
+ #: classes/odb-displayer.php:134 includes/settings-page.php:333
362
  msgid "Delete pingbacks and trackbacks"
363
  msgstr "Verwijder pingback en trackbacks"
364
 
365
+ #: classes/odb-displayer.php:135 includes/settings-page.php:339
366
  msgid "Clear oEmbed cache"
367
  msgstr "Leeg de oEmbed cache"
368
 
369
+ #: classes/odb-displayer.php:136 includes/settings-page.php:351
370
  msgid "Keep a log"
371
  msgstr "Gebruik een logbestand"
372
 
373
+ #: classes/odb-displayer.php:137
374
  msgid "Optimize InnoDB tables"
375
  msgstr "Optimaliseer InnoDB tabellen"
376
 
377
+ #: classes/odb-displayer.php:138
378
  msgid "Number of excluded tables"
379
  msgstr "Aantal uitgesloten tabellen"
380
 
381
+ #: classes/odb-displayer.php:139
382
  msgid "Last run"
383
  msgstr "Laatste uitvoering"
384
 
385
+ #: classes/odb-displayer.php:139 includes/settings-page.php:395
386
  msgid "hrs"
387
  msgstr "uur"
388
 
389
+ #: classes/odb-displayer.php:139
390
  msgid "in"
391
  msgstr "in"
392
 
393
+ #: classes/odb-displayer.php:140 includes/settings-page.php:357
394
  msgid "Scheduler"
395
  msgstr "Planner"
396
 
397
+ #: classes/odb-displayer.php:150
398
  msgid "Next scheduled run"
399
  msgstr "Volgende geplande uitvoering"
400
 
401
+ #: classes/odb-displayer.php:155
402
  msgid "Total savings since the first run"
403
  msgstr "Totale besparing sinds de eerste uitvoering"
404
 
405
+ #: classes/odb-displayer.php:171
406
  msgid "hours"
407
  msgstr "uur"
408
 
409
+ #: classes/odb-displayer.php:172
410
  msgid "minutes"
411
  msgstr "minuten"
412
 
413
+ #: classes/odb-displayer.php:173
414
  msgid "and"
415
  msgstr "en"
416
 
417
+ #: classes/odb-displayer.php:189 classes/odb-logger.php:168
418
  msgid "Change Settings"
419
  msgstr "Wijzig instellingen"
420
 
421
+ #: classes/odb-displayer.php:223 classes/odb-logger.php:174
422
  msgid "Start Optimization"
423
  msgstr "Start Optimalisatie"
424
 
566
  msgid "<Maximum number of revisions> should be a number"
567
  msgstr "<Maximaal aantal revisies> moet een getal zijn"
568
 
569
+ #: includes/settings-page.php:227 rvg-optimize-database.php:456
570
  msgid "Settings"
571
  msgstr "Instellingen"
572
 
662
  msgstr "vink alle NIET-WordPress tabellen aan"
663
 
664
  # @ rvg-optimize-database
665
+ #: rvg-optimize-database.php:428 rvg-optimize-database.php:429
666
+ #: rvg-optimize-database.php:443 rvg-optimize-database.php:444
667
+ #: rvg-optimize-database.php:484 rvg-optimize-database.php:485
668
+ #: rvg-optimize-database.php:502 rvg-optimize-database.php:503
669
  msgid "Optimize Database"
670
  msgstr "Optimaliseer Database"
671
 
672
  # @ optimize_db
673
+ #: rvg-optimize-database.php:473
674
  msgid "Optimize DB (1 click)"
675
  msgstr "Optimaliseer DB (1 klik)"
676
 
677
+ #: rvg-optimize-database.php:621
678
  msgid "Optimize Database after Deleting Revisions LOGS HAVE BEEN CLEARED"
679
  msgstr "Optimize Database after Deleting Revisions LOGS ZIJN VERWIJDERD"
680
 
681
+ #~ msgid "PLEASE DONATE!"
682
+ #~ msgstr "DONEER!"
683
+
684
  #~ msgid "Donation page"
685
  #~ msgstr "Donatiepagina"
686
 
readme.txt CHANGED
@@ -7,9 +7,9 @@ Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, cl
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.9.6
11
- Stable tag: 4.6.2
12
- Version: 4.6.2
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -104,6 +104,9 @@ http://cagewebdev.com/wordpress-plugins/
104
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
105
 
106
  == Changelog ==
 
 
 
107
  = 4.6.2 [06/05/2018] =
108
  * BUG FIX: Fixed a javascript bug for the 'Clear Log' confirmation
109
  * NEW: PayPal donation button
@@ -476,6 +479,7 @@ http://cagewebdev.com/wordpress-plugins/
476
  = Why do I see 'InnoDB table: skipped...'? =
477
  * That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
478
  * Update: if you want to optimize your InnoDB tables too, just check the 'Optimize InnoDB tables too' option on the settings page
 
479
 
480
  = After I ran the plugin, I got "Total savings since the first run: -64 KB" =
481
  * Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).
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.9.8
11
+ Stable tag: 4.6.3
12
+ Version: 4.6.3
13
  License: GPLv2 or later
14
 
15
  == Description ==
104
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
105
 
106
  == Changelog ==
107
+ = 4.6.3 [08/23/2018] =
108
+ * CHANGE: Removed the MyISAM engine for the log table (now it uses the default-storage-engine of the database)
109
+
110
  = 4.6.2 [06/05/2018] =
111
  * BUG FIX: Fixed a javascript bug for the 'Clear Log' confirmation
112
  * NEW: PayPal donation button
479
  = Why do I see 'InnoDB table: skipped...'? =
480
  * That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
481
  * Update: if you want to optimize your InnoDB tables too, just check the 'Optimize InnoDB tables too' option on the settings page
482
+ * IMPORTANT: optimizing InnoDB tables, might increase the size of the database! However, it will speed up the performance of the database
483
 
484
  = After I ran the plugin, I got "Total savings since the first run: -64 KB" =
485
  * Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).
rvg-optimize-database.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 4.6.2
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
@@ -10,7 +10,7 @@ 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.6.2
14
  */
15
 
16
  /********************************************************************************************
@@ -24,8 +24,8 @@ $odb_class = new OptimizeDatabase();
24
 
25
  class OptimizeDatabase {
26
  // VERSION
27
- var $odb_version = '4.6.2';
28
- var $odb_release_date = '06/05/2018';
29
 
30
  // PLUGIN OPTIONS
31
  var $odb_rvg_options = array();
@@ -98,6 +98,7 @@ class OptimizeDatabase {
98
  // CREATE LOG TABLE (IF NOT EXISTS) - v4.6
99
  $this->odb_logtable_name = $wpdb->base_prefix . 'odb_logs';
100
 
 
101
  $sql = '
102
  CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` (
103
  `odb_id` int(11) NOT NULL AUTO_INCREMENT,
@@ -115,8 +116,9 @@ class OptimizeDatabase {
115
  `odb_after` varchar(20) NOT NULL,
116
  `odb_savings` varchar(20) NOT NULL,
117
  PRIMARY KEY (`odb_id`)
118
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
119
  ';
 
120
  // CREATE TABLE
121
  $wpdb->get_results($sql);
122
 
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 4.6.3
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
10
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
11
  Author URI: http://cagewebdev.com
12
  Network: True
13
+ Version: 4.6.3
14
  */
15
 
16
  /********************************************************************************************
24
 
25
  class OptimizeDatabase {
26
  // VERSION
27
+ var $odb_version = '4.6.3';
28
+ var $odb_release_date = '08/23/2018';
29
 
30
  // PLUGIN OPTIONS
31
  var $odb_rvg_options = array();
98
  // CREATE LOG TABLE (IF NOT EXISTS) - v4.6
99
  $this->odb_logtable_name = $wpdb->base_prefix . 'odb_logs';
100
 
101
+ // v4.6.3: MyISAM engine deleted
102
  $sql = '
103
  CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` (
104
  `odb_id` int(11) NOT NULL AUTO_INCREMENT,
116
  `odb_after` varchar(20) NOT NULL,
117
  `odb_savings` varchar(20) NOT NULL,
118
  PRIMARY KEY (`odb_id`)
119
+ ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
120
  ';
121
+
122
  // CREATE TABLE
123
  $wpdb->get_results($sql);
124