Optimize Database after Deleting Revisions - Version 4.8.2

Version Description

[08/15/2019] = * CHANGE: Rewrote the deletion of (expired) transients

Download this release

Release Info

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

Code changes from version 4.8.1 to 4.8.2

Files changed (5) hide show
  1. classes/odb-cleaner.php +31 -33
  2. language/rvg-optimize-database-nl_NL.mo +0 -0
  3. language/rvg-optimize-database-nl_NL.po +60 -61
  4. readme.txt +5 -2
  5. rvg-optimize-database.php +5 -5
classes/odb-cleaner.php CHANGED
@@ -505,9 +505,14 @@ class ODB_Cleaner {
505
  } else {
506
  // NO TRANSIENTS FOUND
507
  if (!$scheduler) {
 
 
 
 
 
508
  ?>
509
  <div class="odb-not-found">
510
- <?php _e('No TRANSIENTS found to delete', $odb_class->odb_txt_domain);?>
511
  </div>
512
  <?php
513
  } // if (!$scheduler)
@@ -1495,16 +1500,16 @@ function odb_confirm_delete() {
1495
 
1496
  /********************************************************************************************
1497
  *
1498
- * GET TRANSIENTS
1499
  *
1500
  ********************************************************************************************/
1501
  function odb_get_transients($option = "Y") {
1502
- // $option == "A": delete all transients
1503
- // %option == "Y": only delete EXPIRED transients
1504
 
1505
- global $wpdb, $odb_class;
1506
 
1507
- $res_arr = array();
1508
 
1509
  // ONE MINUTE DELAY
1510
  $delay = time() - 60;
@@ -1513,6 +1518,8 @@ function odb_confirm_delete() {
1513
  for($i=0; $i<count($odb_class->odb_ms_prefixes); $i++) {
1514
  $prefix = $odb_class->odb_ms_prefixes[$i];
1515
 
 
 
1516
  if ($option == 'Y') {
1517
  // EXPIRED ONLY
1518
  $sql = sprintf ("
@@ -1525,7 +1532,8 @@ function odb_confirm_delete() {
1525
  )
1526
  AND option_value < '%d'
1527
  ORDER BY `option_name`
1528
- ", $prefix, $prefix, $delay);
 
1529
  } else {
1530
  // ALL
1531
  $sql = sprintf ("
@@ -1539,7 +1547,7 @@ function odb_confirm_delete() {
1539
  ORDER BY `option_name`
1540
  ", $prefix, $prefix);
1541
  }
1542
-
1543
  $res = $wpdb->get_results($sql, ARRAY_A);
1544
 
1545
  for($j = 0; $j < count($res); $j++) {
@@ -1552,14 +1560,14 @@ function odb_confirm_delete() {
1552
 
1553
  /********************************************************************************************
1554
  *
1555
- * DELETE TRANSIENTS (v4.7.3)
1556
  *
1557
  ********************************************************************************************/
1558
  function odb_delete_transients($results, $scheduler, $action = 'run', $option = 'Y') {
1559
  global $wpdb, $odb_class;
1560
 
1561
  // ONE MINUTE DELAY
1562
- $delay = time() - 60;
1563
 
1564
  $total_deleted = count($results);
1565
 
@@ -1578,32 +1586,22 @@ function odb_confirm_delete() {
1578
  <?php
1579
  } // if (!$scheduler && ($action == 'analyze_detail' || $action == 'run_detail'))
1580
 
 
1581
  if ($action == 'run_summary' || $action == 'run_detail') {
1582
- if ($option == 'Y') {
1583
- // EXPIRED
1584
- $sqldel = sprintf ("
1585
- DELETE
1586
- FROM `%soptions`
1587
- WHERE (
1588
- option_name LIKE '_transient_timeout_%%'
1589
- OR option_name LIKE '_site_transient_timeout_%%'
1590
- )
1591
- AND option_value < '%d'
1592
- ", $prefix, $delay);
1593
- } else {
1594
- // ALL
1595
- $sqldel = sprintf ("
1596
- DELETE
1597
- FROM `%soptions`
1598
- WHERE (
1599
- option_name LIKE '_transient_timeout_%%'
1600
- OR option_name LIKE '_site_transient_timeout_%%'
1601
- )
1602
- ", $prefix);
1603
- } // if ($option == 'Y')
1604
  $resdel = $wpdb->get_results($sqldel, ARRAY_A);
1605
  } // if ($action == 'run_summary' || $action == 'run_detail'))
1606
-
1607
  } // for($i = 0; $i < count($odb_class->odb_ms_prefixes); $i++)
1608
  } // for($i = 0; $i < count($odb_class->odb_ms_prefixes); $i++)
1609
 
505
  } else {
506
  // NO TRANSIENTS FOUND
507
  if (!$scheduler) {
508
+ if ($option == 'Y') {
509
+ $msg = 'No EXPIRED TRANSIENTS found to delete';
510
+ } else {
511
+ $msg = 'No TRANSIENTS found to delete';
512
+ } // if ($option == 'Y')
513
  ?>
514
  <div class="odb-not-found">
515
+ <?php _e($msg, $odb_class->odb_txt_domain);?>
516
  </div>
517
  <?php
518
  } // if (!$scheduler)
1500
 
1501
  /********************************************************************************************
1502
  *
1503
+ * GET TRANSIENTS v4.8.2
1504
  *
1505
  ********************************************************************************************/
1506
  function odb_get_transients($option = "Y") {
1507
+ // $option == "A": delete all transients
1508
+ // %option == "Y": only delete EXPIRED transients
1509
 
1510
+ global $wpdb, $odb_class;
1511
 
1512
+ $res_arr = array();
1513
 
1514
  // ONE MINUTE DELAY
1515
  $delay = time() - 60;
1518
  for($i=0; $i<count($odb_class->odb_ms_prefixes); $i++) {
1519
  $prefix = $odb_class->odb_ms_prefixes[$i];
1520
 
1521
+ $table = $prefix . 'options';
1522
+ // v4.8.2
1523
  if ($option == 'Y') {
1524
  // EXPIRED ONLY
1525
  $sql = sprintf ("
1532
  )
1533
  AND option_value < '%d'
1534
  ORDER BY `option_name`
1535
+ ", $prefix, $prefix, $delay);
1536
+ //echo $sql . '<br>';
1537
  } else {
1538
  // ALL
1539
  $sql = sprintf ("
1547
  ORDER BY `option_name`
1548
  ", $prefix, $prefix);
1549
  }
1550
+ //echo $sql . '<br>';
1551
  $res = $wpdb->get_results($sql, ARRAY_A);
1552
 
1553
  for($j = 0; $j < count($res); $j++) {
1560
 
1561
  /********************************************************************************************
1562
  *
1563
+ * DELETE TRANSIENTS (v4.8.2)
1564
  *
1565
  ********************************************************************************************/
1566
  function odb_delete_transients($results, $scheduler, $action = 'run', $option = 'Y') {
1567
  global $wpdb, $odb_class;
1568
 
1569
  // ONE MINUTE DELAY
1570
+ $delay = time() - MINUTE_IN_SECONDS;
1571
 
1572
  $total_deleted = count($results);
1573
 
1586
  <?php
1587
  } // if (!$scheduler && ($action == 'analyze_detail' || $action == 'run_detail'))
1588
 
1589
+ // v4.8.2
1590
  if ($action == 'run_summary' || $action == 'run_detail') {
1591
+ $timeout = $results[$j]['option_name'];
1592
+ $trans = str_replace('_timeout', '', $timeout);
1593
+ $sqldel = sprintf ("
1594
+ DELETE
1595
+ FROM `%soptions`
1596
+ WHERE (
1597
+ option_name = '%s'
1598
+ OR option_name = '%s'
1599
+ )
1600
+ ", $prefix, $timeout, $trans);
1601
+
1602
+ //echo $sqldel . '<br>';
 
 
 
 
 
 
 
 
 
 
1603
  $resdel = $wpdb->get_results($sqldel, ARRAY_A);
1604
  } // if ($action == 'run_summary' || $action == 'run_detail'))
 
1605
  } // for($i = 0; $i < count($odb_class->odb_ms_prefixes); $i++)
1606
  } // for($i = 0; $i < count($odb_class->odb_ms_prefixes); $i++)
1607
 
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: 2019-05-26 13:42+0200\n"
6
- "PO-Revision-Date: 2019-05-26 13:57+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"
@@ -49,8 +49,8 @@ msgstr "totaal aantal verwijderde revisies"
49
 
50
  #: classes/odb-cleaner.php:140 classes/odb-cleaner.php:226
51
  #: classes/odb-cleaner.php:308 classes/odb-cleaner.php:393
52
- #: classes/odb-cleaner.php:487 classes/odb-cleaner.php:569
53
- #: classes/odb-cleaner.php:659 classes/odb-cleaner.php:744
54
  msgid "prefix"
55
  msgstr "prefix"
56
 
@@ -90,8 +90,8 @@ msgstr "VERWIJDERDE TRASHED ITEMS"
90
  msgid "total number of trashed items deleted"
91
  msgstr "totaal aantal verwijderede trashed items"
92
 
93
- #: classes/odb-cleaner.php:227 classes/odb-cleaner.php:570
94
- #: classes/odb-cleaner.php:745
95
  msgid "type"
96
  msgstr "type"
97
 
@@ -99,7 +99,7 @@ msgstr "type"
99
  msgid "IP address / title"
100
  msgstr "IP adres / titel"
101
 
102
- #: classes/odb-cleaner.php:229 classes/odb-cleaner.php:572
103
  #: classes/odb-logger.php:114 classes/odb-logger.php:244
104
  msgid "date"
105
  msgstr "datum"
@@ -204,210 +204,206 @@ msgstr "VERWIJDERDE OEMBEDS"
204
  msgid "option name"
205
  msgstr "optienaam"
206
 
207
- #: classes/odb-cleaner.php:510
208
- msgid "No TRANSIENTS found to delete"
209
- msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
210
-
211
- #: classes/odb-cleaner.php:535
212
  msgid "PINGBACKS AND/OR TRACKBACKS found to delete: "
213
  msgstr "PINGBACKS en TRACKBACKS gevonden om te verwijderen:"
214
 
215
- #: classes/odb-cleaner.php:544
216
  msgid "PINGBACKS AND/OR TRACKBACKS deleted: "
217
  msgstr "Verwijderde PINGBACKS EN TRACKBACKS:"
218
 
219
- #: classes/odb-cleaner.php:553
220
  msgid "PINGBACKS AND TRACKBACKS"
221
  msgstr "PINGBACKS EN TRACKBACKS"
222
 
223
- #: classes/odb-cleaner.php:554
224
  msgid "total number of pingbacks and trackbacks"
225
  msgstr "total aantal pingbacks en trackbacks"
226
 
227
- #: classes/odb-cleaner.php:557
228
  msgid "DELETED PINGBACKS AND TRACKBACKS"
229
  msgstr "VERWIJDERDE PINGBACKS EN TRACKBACKS"
230
 
231
- #: classes/odb-cleaner.php:558
232
  msgid "total number of pingbacks and trackbacks deleted"
233
  msgstr "totaal aantal verwijderede trashed items"
234
 
235
- #: classes/odb-cleaner.php:571
236
  msgid "comment_author"
237
  msgstr "plaatser van de reactie"
238
 
239
- #: classes/odb-cleaner.php:599
240
  msgid "No PINGBACKS nor TRACKBACKS found to delete"
241
  msgstr "Geen PINGBACKS en TRACKBACKS gevonden om te verwijderen"
242
 
243
- #: classes/odb-cleaner.php:625
244
  msgid "OEMBED CACHE ITEMS found to delete: "
245
  msgstr "OEMBED CACHE ITEMS gevonden om te verwijderen:"
246
 
247
- #: classes/odb-cleaner.php:634
248
  msgid "OEMBED CACHE ITEMS deleted: "
249
  msgstr "Verwijderde OEMBED CACHE ITEMS:"
250
 
251
- #: classes/odb-cleaner.php:643
252
  msgid "OEMBED CACHE items"
253
  msgstr "OEMBED CACHE items"
254
 
255
- #: classes/odb-cleaner.php:644
256
  msgid "total number of oembed cache items"
257
  msgstr "totaal aantal oembed cache items"
258
 
259
- #: classes/odb-cleaner.php:647
260
  msgid "DELETED OEMBED CACHE ITEMS"
261
  msgstr "VERWIJDERDE OEMBED CACHE ITEMS"
262
 
263
- #: classes/odb-cleaner.php:648
264
  msgid "total number of oembed cache items deleted"
265
  msgstr "totaal aantal verwijderede oembed cache items"
266
 
267
- #: classes/odb-cleaner.php:660 classes/odb-cleaner.php:749
268
  msgid "meta key"
269
  msgstr "meta sleutel"
270
 
271
- #: classes/odb-cleaner.php:661 classes/odb-cleaner.php:750
272
  msgid "meta value"
273
  msgstr "meta waarde"
274
 
275
- #: classes/odb-cleaner.php:684
276
  msgid "No OEMBED CACHE ITEMS found to delete"
277
  msgstr "Geen OEMBED CACHE ITEMS gevonden om te verwijderen"
278
 
279
- #: classes/odb-cleaner.php:709
280
  msgid "ORPHANS found to delete: "
281
  msgstr "POSTMETA WEZEN gevonden om te verwijderen:"
282
 
283
- #: classes/odb-cleaner.php:718
284
  msgid "ORPHANS deleted: "
285
  msgstr "Verwijderde WEZEN:"
286
 
287
- #: classes/odb-cleaner.php:728
288
  msgid "ORPHANS"
289
  msgstr "POSTMETA WEZEN"
290
 
291
- #: classes/odb-cleaner.php:729
292
  msgid "total number of orphans"
293
  msgstr "totaal aantal wezen"
294
 
295
- #: classes/odb-cleaner.php:732
296
  msgid "DELETED ORPHANS"
297
  msgstr "VERWIJDERDE POSTMETA WEZEN"
298
 
299
- #: classes/odb-cleaner.php:733
300
  msgid "total number of orphans deleted"
301
  msgstr "totaal aantal verwijderde wezen"
302
 
303
- #: classes/odb-cleaner.php:746 classes/odb-logger.php:243
304
  msgid "id"
305
  msgstr "id"
306
 
307
- #: classes/odb-cleaner.php:747
308
  msgid "title"
309
  msgstr "titel"
310
 
311
- #: classes/odb-cleaner.php:748
312
  msgid "modified"
313
  msgstr "gewijzigd"
314
 
315
- #: classes/odb-cleaner.php:769
316
  msgid "No ORPHANS found to delete"
317
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
318
 
319
- #: classes/odb-cleaner.php:778
320
  msgid "TOTAL NUMBER OF ITEMS: "
321
  msgstr "TOTAAL ANTAL ITEMS:"
322
 
323
- #: classes/odb-cleaner.php:797
324
  msgid "Optimizing Database Tables"
325
  msgstr "Optimaliseren van Databasetabellen"
326
 
327
- #: classes/odb-cleaner.php:804
328
  msgid "table name"
329
  msgstr "tabelnaam"
330
 
331
- #: classes/odb-cleaner.php:805
332
  msgid "optimization result"
333
  msgstr "resultaat optimalisatie"
334
 
335
- #: classes/odb-cleaner.php:806
336
  msgid "engine"
337
  msgstr "engine"
338
 
339
- #: classes/odb-cleaner.php:807
340
  msgid "table rows"
341
  msgstr "tabelrijen"
342
 
343
- #: classes/odb-cleaner.php:808
344
  msgid "table size"
345
  msgstr "tabelgrootte"
346
 
347
- #: classes/odb-cleaner.php:859
348
  msgid "Savings"
349
  msgstr "Besparingen"
350
 
351
- #: classes/odb-cleaner.php:866
352
  msgid "size of the database"
353
  msgstr "grootte van de database"
354
 
355
- #: classes/odb-cleaner.php:869
356
  msgid "BEFORE optimization"
357
  msgstr "VOOR de optimalisatie"
358
 
359
- #: classes/odb-cleaner.php:873
360
  msgid "AFTER optimization"
361
  msgstr "NA de optimalisatie"
362
 
363
- #: classes/odb-cleaner.php:877
364
  msgid "SAVINGS THIS TIME"
365
  msgstr "DIT KEER BESPAARD"
366
 
367
- #: classes/odb-cleaner.php:881
368
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
369
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
370
 
371
- #: classes/odb-cleaner.php:909
372
  msgid "DONE!"
373
  msgstr "KLAAR!"
374
 
375
- #: classes/odb-cleaner.php:917
376
  msgid "Optimization took"
377
  msgstr "Optimalizatie duurde"
378
 
379
- #: classes/odb-cleaner.php:917 classes/odb-displayer.php:139
380
  #: classes/odb-displayer.php:174
381
  msgid "seconds"
382
  msgstr "seconden"
383
 
384
- #: classes/odb-cleaner.php:931 classes/odb-displayer.php:196
385
  #: classes/odb-logger.php:157
386
  msgid "Clear the log?"
387
  msgstr "Logs wissen?"
388
 
389
- #: classes/odb-cleaner.php:941 classes/odb-displayer.php:215
390
  msgid "View Log"
391
  msgstr "Bekijk Logs"
392
 
393
- #: classes/odb-cleaner.php:943 classes/odb-displayer.php:217
394
  #: classes/odb-logger.php:170
395
  msgid "Clear Log"
396
  msgstr "Wis Logs"
397
 
398
- #: classes/odb-cleaner.php:1191
399
  msgid "of"
400
  msgstr "van"
401
 
402
- #: classes/odb-cleaner.php:1892
403
  msgid "InnoDB table: skipped..."
404
  msgstr "InnoDB tabel overgeslagen..."
405
 
406
- #: classes/odb-cleaner.php:1899 classes/odb-cleaner.php:1909
407
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
408
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
409
 
410
- #: classes/odb-cleaner.php:1901 classes/odb-cleaner.php:1907
411
  msgid "Table is already up to date"
412
  msgstr "Tabel is al optimaal"
413
 
@@ -878,6 +874,9 @@ msgstr "Annuleer"
878
  msgid "Analysis Done!"
879
  msgstr "Analyze Gereed!"
880
 
 
 
 
881
  #~ msgid "Analyzing Database"
882
  #~ msgstr "Analiseer Database"
883
 
2
  msgstr ""
3
  "Project-Id-Version: Optimize Database after Deleting Revisions v4.3\n"
4
  "Report-Msgid-Bugs-To: \n"
5
+ "POT-Creation-Date: 2019-08-15 12:10+0200\n"
6
+ "PO-Revision-Date: 2019-08-15 12:11+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"
49
 
50
  #: classes/odb-cleaner.php:140 classes/odb-cleaner.php:226
51
  #: classes/odb-cleaner.php:308 classes/odb-cleaner.php:393
52
+ #: classes/odb-cleaner.php:487 classes/odb-cleaner.php:574
53
+ #: classes/odb-cleaner.php:664 classes/odb-cleaner.php:749
54
  msgid "prefix"
55
  msgstr "prefix"
56
 
90
  msgid "total number of trashed items deleted"
91
  msgstr "totaal aantal verwijderede trashed items"
92
 
93
+ #: classes/odb-cleaner.php:227 classes/odb-cleaner.php:575
94
+ #: classes/odb-cleaner.php:750
95
  msgid "type"
96
  msgstr "type"
97
 
99
  msgid "IP address / title"
100
  msgstr "IP adres / titel"
101
 
102
+ #: classes/odb-cleaner.php:229 classes/odb-cleaner.php:577
103
  #: classes/odb-logger.php:114 classes/odb-logger.php:244
104
  msgid "date"
105
  msgstr "datum"
204
  msgid "option name"
205
  msgstr "optienaam"
206
 
207
+ #: classes/odb-cleaner.php:540
 
 
 
 
208
  msgid "PINGBACKS AND/OR TRACKBACKS found to delete: "
209
  msgstr "PINGBACKS en TRACKBACKS gevonden om te verwijderen:"
210
 
211
+ #: classes/odb-cleaner.php:549
212
  msgid "PINGBACKS AND/OR TRACKBACKS deleted: "
213
  msgstr "Verwijderde PINGBACKS EN TRACKBACKS:"
214
 
215
+ #: classes/odb-cleaner.php:558
216
  msgid "PINGBACKS AND TRACKBACKS"
217
  msgstr "PINGBACKS EN TRACKBACKS"
218
 
219
+ #: classes/odb-cleaner.php:559
220
  msgid "total number of pingbacks and trackbacks"
221
  msgstr "total aantal pingbacks en trackbacks"
222
 
223
+ #: classes/odb-cleaner.php:562
224
  msgid "DELETED PINGBACKS AND TRACKBACKS"
225
  msgstr "VERWIJDERDE PINGBACKS EN TRACKBACKS"
226
 
227
+ #: classes/odb-cleaner.php:563
228
  msgid "total number of pingbacks and trackbacks deleted"
229
  msgstr "totaal aantal verwijderede trashed items"
230
 
231
+ #: classes/odb-cleaner.php:576
232
  msgid "comment_author"
233
  msgstr "plaatser van de reactie"
234
 
235
+ #: classes/odb-cleaner.php:604
236
  msgid "No PINGBACKS nor TRACKBACKS found to delete"
237
  msgstr "Geen PINGBACKS en TRACKBACKS gevonden om te verwijderen"
238
 
239
+ #: classes/odb-cleaner.php:630
240
  msgid "OEMBED CACHE ITEMS found to delete: "
241
  msgstr "OEMBED CACHE ITEMS gevonden om te verwijderen:"
242
 
243
+ #: classes/odb-cleaner.php:639
244
  msgid "OEMBED CACHE ITEMS deleted: "
245
  msgstr "Verwijderde OEMBED CACHE ITEMS:"
246
 
247
+ #: classes/odb-cleaner.php:648
248
  msgid "OEMBED CACHE items"
249
  msgstr "OEMBED CACHE items"
250
 
251
+ #: classes/odb-cleaner.php:649
252
  msgid "total number of oembed cache items"
253
  msgstr "totaal aantal oembed cache items"
254
 
255
+ #: classes/odb-cleaner.php:652
256
  msgid "DELETED OEMBED CACHE ITEMS"
257
  msgstr "VERWIJDERDE OEMBED CACHE ITEMS"
258
 
259
+ #: classes/odb-cleaner.php:653
260
  msgid "total number of oembed cache items deleted"
261
  msgstr "totaal aantal verwijderede oembed cache items"
262
 
263
+ #: classes/odb-cleaner.php:665 classes/odb-cleaner.php:754
264
  msgid "meta key"
265
  msgstr "meta sleutel"
266
 
267
+ #: classes/odb-cleaner.php:666 classes/odb-cleaner.php:755
268
  msgid "meta value"
269
  msgstr "meta waarde"
270
 
271
+ #: classes/odb-cleaner.php:689
272
  msgid "No OEMBED CACHE ITEMS found to delete"
273
  msgstr "Geen OEMBED CACHE ITEMS gevonden om te verwijderen"
274
 
275
+ #: classes/odb-cleaner.php:714
276
  msgid "ORPHANS found to delete: "
277
  msgstr "POSTMETA WEZEN gevonden om te verwijderen:"
278
 
279
+ #: classes/odb-cleaner.php:723
280
  msgid "ORPHANS deleted: "
281
  msgstr "Verwijderde WEZEN:"
282
 
283
+ #: classes/odb-cleaner.php:733
284
  msgid "ORPHANS"
285
  msgstr "POSTMETA WEZEN"
286
 
287
+ #: classes/odb-cleaner.php:734
288
  msgid "total number of orphans"
289
  msgstr "totaal aantal wezen"
290
 
291
+ #: classes/odb-cleaner.php:737
292
  msgid "DELETED ORPHANS"
293
  msgstr "VERWIJDERDE POSTMETA WEZEN"
294
 
295
+ #: classes/odb-cleaner.php:738
296
  msgid "total number of orphans deleted"
297
  msgstr "totaal aantal verwijderde wezen"
298
 
299
+ #: classes/odb-cleaner.php:751 classes/odb-logger.php:243
300
  msgid "id"
301
  msgstr "id"
302
 
303
+ #: classes/odb-cleaner.php:752
304
  msgid "title"
305
  msgstr "titel"
306
 
307
+ #: classes/odb-cleaner.php:753
308
  msgid "modified"
309
  msgstr "gewijzigd"
310
 
311
+ #: classes/odb-cleaner.php:774
312
  msgid "No ORPHANS found to delete"
313
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
314
 
315
+ #: classes/odb-cleaner.php:783
316
  msgid "TOTAL NUMBER OF ITEMS: "
317
  msgstr "TOTAAL ANTAL ITEMS:"
318
 
319
+ #: classes/odb-cleaner.php:802
320
  msgid "Optimizing Database Tables"
321
  msgstr "Optimaliseren van Databasetabellen"
322
 
323
+ #: classes/odb-cleaner.php:809
324
  msgid "table name"
325
  msgstr "tabelnaam"
326
 
327
+ #: classes/odb-cleaner.php:810
328
  msgid "optimization result"
329
  msgstr "resultaat optimalisatie"
330
 
331
+ #: classes/odb-cleaner.php:811
332
  msgid "engine"
333
  msgstr "engine"
334
 
335
+ #: classes/odb-cleaner.php:812
336
  msgid "table rows"
337
  msgstr "tabelrijen"
338
 
339
+ #: classes/odb-cleaner.php:813
340
  msgid "table size"
341
  msgstr "tabelgrootte"
342
 
343
+ #: classes/odb-cleaner.php:864
344
  msgid "Savings"
345
  msgstr "Besparingen"
346
 
347
+ #: classes/odb-cleaner.php:871
348
  msgid "size of the database"
349
  msgstr "grootte van de database"
350
 
351
+ #: classes/odb-cleaner.php:874
352
  msgid "BEFORE optimization"
353
  msgstr "VOOR de optimalisatie"
354
 
355
+ #: classes/odb-cleaner.php:878
356
  msgid "AFTER optimization"
357
  msgstr "NA de optimalisatie"
358
 
359
+ #: classes/odb-cleaner.php:882
360
  msgid "SAVINGS THIS TIME"
361
  msgstr "DIT KEER BESPAARD"
362
 
363
+ #: classes/odb-cleaner.php:886
364
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
365
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
366
 
367
+ #: classes/odb-cleaner.php:914
368
  msgid "DONE!"
369
  msgstr "KLAAR!"
370
 
371
+ #: classes/odb-cleaner.php:922
372
  msgid "Optimization took"
373
  msgstr "Optimalizatie duurde"
374
 
375
+ #: classes/odb-cleaner.php:922 classes/odb-displayer.php:139
376
  #: classes/odb-displayer.php:174
377
  msgid "seconds"
378
  msgstr "seconden"
379
 
380
+ #: classes/odb-cleaner.php:936 classes/odb-displayer.php:196
381
  #: classes/odb-logger.php:157
382
  msgid "Clear the log?"
383
  msgstr "Logs wissen?"
384
 
385
+ #: classes/odb-cleaner.php:946 classes/odb-displayer.php:215
386
  msgid "View Log"
387
  msgstr "Bekijk Logs"
388
 
389
+ #: classes/odb-cleaner.php:948 classes/odb-displayer.php:217
390
  #: classes/odb-logger.php:170
391
  msgid "Clear Log"
392
  msgstr "Wis Logs"
393
 
394
+ #: classes/odb-cleaner.php:1201
395
  msgid "of"
396
  msgstr "van"
397
 
398
+ #: classes/odb-cleaner.php:1895
399
  msgid "InnoDB table: skipped..."
400
  msgstr "InnoDB tabel overgeslagen..."
401
 
402
+ #: classes/odb-cleaner.php:1902 classes/odb-cleaner.php:1912
403
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
404
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
405
 
406
+ #: classes/odb-cleaner.php:1904 classes/odb-cleaner.php:1910
407
  msgid "Table is already up to date"
408
  msgstr "Tabel is al optimaal"
409
 
874
  msgid "Analysis Done!"
875
  msgstr "Analyze Gereed!"
876
 
877
+ #~ msgid "No TRANSIENTS found to delete"
878
+ #~ msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
879
+
880
  #~ msgid "Analyzing Database"
881
  #~ msgstr "Analiseer Database"
882
 
readme.txt CHANGED
@@ -10,8 +10,8 @@ Contributors: cageehv
10
  Requires at least: 2.8
11
  Requires PHP: 5.0
12
  Tested up to: 5.2.2
13
- Stable tag: 4.8.1
14
- Version: 4.8.1
15
  License: GPLv2 or later
16
 
17
  == Description ==
@@ -111,6 +111,9 @@ http://cagewebdev.com/category/news-tech-art/wordpress/
111
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
112
 
113
  == Changelog ==
 
 
 
114
  = 4.8.1 [07/15/2019] =
115
  * BUG FIX: Scheduler bug fixed
116
 
10
  Requires at least: 2.8
11
  Requires PHP: 5.0
12
  Tested up to: 5.2.2
13
+ Stable tag: 4.8.2
14
+ Version: 4.8.2
15
  License: GPLv2 or later
16
 
17
  == Description ==
111
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
112
 
113
  == Changelog ==
114
+ = 4.8.2 [08/15/2019] =
115
+ * CHANGE: Rewrote the deletion of (expired) transients
116
+
117
  = 4.8.1 [07/15/2019] =
118
  * BUG FIX: Scheduler bug fixed
119
 
rvg-optimize-database.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 4.8.1
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.8.1
14
  */
15
 
16
  /********************************************************************************************
@@ -28,13 +28,13 @@ $odb_class = new OptimizeDatabase();
28
 
29
  class OptimizeDatabase {
30
  // VERSION
31
- var $odb_version = '4.8.1';
32
- var $odb_release_date = '07/15/2019';
33
 
34
  // PLUGIN OPTIONS
35
  var $odb_rvg_options = array();
36
 
37
- // EXCLUDED TABELS
38
  var $odb_rvg_excluded_tabs = array();
39
 
40
  // MULTISITE STRUCTURE
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 4.8.2
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.8.2
14
  */
15
 
16
  /********************************************************************************************
28
 
29
  class OptimizeDatabase {
30
  // VERSION
31
+ var $odb_version = '4.8.2';
32
+ var $odb_release_date = '08/15/2019';
33
 
34
  // PLUGIN OPTIONS
35
  var $odb_rvg_options = array();
36
 
37
+ // EXCLUDED TABLES
38
  var $odb_rvg_excluded_tabs = array();
39
 
40
  // MULTISITE STRUCTURE