Optimize Database after Deleting Revisions - Version 3.4.7

Version Description

[08/30/2015] = * BUG FIX: Transients are now deleted using the delete_transient() / delete_site_transient() functions

Download this release

Release Info

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

Code changes from version 3.4.6 to 3.4.7

Files changed (4) hide show
  1. language/rvg-optimize-database-nl_NL.mo +0 -0
  2. language/rvg-optimize-database-nl_NL.po +146 -129
  3. readme.txt +5 -2
  4. rvg-optimize-db.php +58 -93
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 v2.8.3\n"
4
  "Report-Msgid-Bugs-To: \n"
5
- "POT-Creation-Date: 2015-04-19 20:36+0100\n"
6
- "PO-Revision-Date: 2015-04-19 20:36+0100\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: nl_NL\n"
@@ -15,8 +15,8 @@ msgstr ""
15
  "X-Poedit-SourceCharset: UTF-8\n"
16
  "X-Poedit-KeywordsList: __;_e;__ngettext:1,2;_n:1,2;__ngettext_noop:1,2;"
17
  "_n_noop:1,2;_c,_nc:4c,1,2;_x:1,2c;_ex:1,2c;_nx:4c,1,2;_nx_noop:4c,1,2\n"
18
- "X-Poedit-Basepath: C:\\Users\\rvgelder.KC15435\\Documents\\My Dropbox"
19
- "\\cagewebdev\\wp-content\\plugins\\rvg-optimize-database\\\n"
20
  "X-Textdomain-Support: yes\n"
21
  "X-Poedit-SearchPath-0: .\n"
22
 
@@ -37,11 +37,11 @@ msgstr "Optimaliseer DB (1 klik)"
37
  msgid "Once Weekly"
38
  msgstr "Eenmaal per week"
39
 
40
- #: rvg-optimize-db.php:425
41
  msgid "Optimize Database after Deleting Revisions SETTINGS UPDATED"
42
  msgstr "Optimize Database after Deleting Revisions INSTELLINGEN AANGEPAST"
43
 
44
- #: rvg-optimize-db.php:427
45
  msgid ""
46
  "Click <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
47
  "\">HERE</a> to run the optimization"
@@ -49,120 +49,124 @@ msgstr ""
49
  "Klik <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold\">HIER</"
50
  "a. om de optimalisatie te starten"
51
 
52
- #: rvg-optimize-db.php:494
53
  msgid "Optimize Database after Deleting Revisions"
54
  msgstr "Optimize Database after Deleting Revisions"
55
 
56
- #: rvg-optimize-db.php:498
57
  msgid "is an one-click plugin to clean and optimize your WordPress database"
58
  msgstr ""
59
  "is een één-klik plugin om de WordPress database op te schonen en te "
60
  "optimaliseren"
61
 
62
- #: rvg-optimize-db.php:501
63
- msgid "Plugin version:"
64
- msgstr "Plugin versie:"
65
 
66
- #: rvg-optimize-db.php:505
67
- msgid "Author:"
68
- msgstr "Auteur:"
69
 
70
- #: rvg-optimize-db.php:508 rvg-optimize-db.php:820 rvg-optimize-db.php:1994
71
- msgid "The Netherlands"
72
- msgstr "Nederland"
73
 
74
- #: rvg-optimize-db.php:511
75
- msgid "Plugin URL:"
76
- msgstr "Plugin URL:"
77
 
78
- #: rvg-optimize-db.php:515
79
- msgid "Download URL:"
80
- msgstr "Download URL:"
81
 
82
- #: rvg-optimize-db.php:523
 
 
 
 
83
  msgid "Settings"
84
  msgstr "Instellingen"
85
 
86
- #: rvg-optimize-db.php:531
87
  msgid ""
88
  "Maximum number of - most recent - revisions<br />to keep per post / page"
89
  msgstr ""
90
  "Maximale aantal - meest recente - revisies<br />om te bewaren per "
91
  "bericht / pagina"
92
 
93
- #: rvg-optimize-db.php:535
94
  msgid "('0' means: delete <u>ALL</u> revisions)"
95
  msgstr "('0' betekent: verwijder <u>ALLE</u> revisies)"
96
 
97
- #: rvg-optimize-db.php:539 rvg-optimize-db.php:829
98
  msgid "Delete trashed items"
99
  msgstr "Verwijder trashed items"
100
 
101
- #: rvg-optimize-db.php:545 rvg-optimize-db.php:832
102
  msgid "Delete spammed items"
103
  msgstr "Verwijder spammed items"
104
 
105
- #: rvg-optimize-db.php:551 rvg-optimize-db.php:835
106
  msgid "Delete unused tags"
107
  msgstr "Verwijder ongebruikte tags"
108
 
109
- #: rvg-optimize-db.php:557 rvg-optimize-db.php:838
110
  msgid "Delete expired transients"
111
  msgstr "Verwijder verlopen transiënts"
112
 
113
- #: rvg-optimize-db.php:563 rvg-optimize-db.php:841
114
  msgid "Delete pingbacks and trackbacks"
115
  msgstr "Verwijder pingback en trackbacks"
116
 
117
- #: rvg-optimize-db.php:569 rvg-optimize-db.php:844
118
  msgid "Keep a log"
119
  msgstr "Gebruik een logbestand"
120
 
121
- #: rvg-optimize-db.php:575 rvg-optimize-db.php:850
122
  msgid "Scheduler"
123
  msgstr "Planner"
124
 
125
- #: rvg-optimize-db.php:579 rvg-optimize-db.php:787
126
  msgid "NOT SCHEDULED"
127
  msgstr "NIET GEPLAND"
128
 
129
- #: rvg-optimize-db.php:582
130
  msgid "run optimization HOURLY"
131
  msgstr "voer de optimalisatie ELK UUR uit"
132
 
133
- #: rvg-optimize-db.php:585
134
  msgid "run optimization TWICE A DAY"
135
  msgstr "voer de optimalisatie TWEE KEER PER DAG uit"
136
 
137
- #: rvg-optimize-db.php:588
138
  msgid "run optimization DAILY"
139
  msgstr "voer de optimalisatie DAGELIJKS uit"
140
 
141
- #: rvg-optimize-db.php:591
142
  msgid "run optimization WEEKLY"
143
  msgstr "voer de optimalisatie WEKELIJKS uit"
144
 
145
- #: rvg-optimize-db.php:599
146
  msgid "Time"
147
  msgstr "Tijd"
148
 
149
- #: rvg-optimize-db.php:606
150
  msgid "hrs"
151
  msgstr "uur"
152
 
153
- #: rvg-optimize-db.php:619
154
  msgid "Show '1-click' link in Admin Bar"
155
  msgstr "Toon de '1-klik' link in de Admin Balk"
156
 
157
- #: rvg-optimize-db.php:622 rvg-optimize-db.php:629
158
  msgid "(change will be visible after loading the next page)"
159
  msgstr "(wijziging wordt zichtbaar na het laden van de volgende pagina)"
160
 
161
- #: rvg-optimize-db.php:626
162
  msgid "Show an icon in the Admin Menu"
163
  msgstr "Toon een icon in het Admin Menu"
164
 
165
- #: rvg-optimize-db.php:634
166
  msgid ""
167
  "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class=\"odb-underline-red"
168
  "\">CHECKED</span> TABLES <span class=\"odb-underline-red\">WON'T</span> BE "
@@ -172,332 +176,348 @@ msgstr ""
172
  "underline-red\">AANGEVINKTE</span> TABELLEN ZULLEN <span class=\"odb-"
173
  "underline-red\">NIET</span> GEOPTIMALISEERD WORDEN!</span>"
174
 
175
- #: rvg-optimize-db.php:637
176
  msgid "check all tables"
177
  msgstr "vink alle tabellen aan"
178
 
179
- #: rvg-optimize-db.php:639
180
  msgid "uncheck all tables"
181
  msgstr "vink alle tabellen uit"
182
 
183
- #: rvg-optimize-db.php:641
184
  msgid "check all NON-WordPress tables"
185
  msgstr "vink alle NIET-WordPress tabellen aan"
186
 
187
- #: rvg-optimize-db.php:666
188
  msgid "Save Settings"
189
  msgstr "Bewaar instellingen"
190
 
191
- #: rvg-optimize-db.php:668
192
  msgid "Go To Optimizer"
193
  msgstr "Ga naar Optimalisatie"
194
 
195
- #: rvg-optimize-db.php:730 rvg-optimize-db.php:737 rvg-optimize-db.php:744
196
- #: rvg-optimize-db.php:751 rvg-optimize-db.php:759 rvg-optimize-db.php:766
197
  msgid "NO"
198
  msgstr "NEE"
199
 
200
- #: rvg-optimize-db.php:730 rvg-optimize-db.php:737 rvg-optimize-db.php:744
201
- #: rvg-optimize-db.php:751 rvg-optimize-db.php:759 rvg-optimize-db.php:766
202
  msgid "YES"
203
  msgstr "JA"
204
 
205
- #: rvg-optimize-db.php:775
206
  msgid "ONCE HOURLY"
207
  msgstr "ELK UUR"
208
 
209
- #: rvg-optimize-db.php:777
210
  msgid "TWICE DAILY"
211
  msgstr "TWEEMAAL DAAGS"
212
 
213
- #: rvg-optimize-db.php:779
214
  msgid "ONCE DAILY"
215
  msgstr "DAGELIJKS"
216
 
217
- #: rvg-optimize-db.php:781
218
  msgid "ONCE WEEKLY"
219
  msgstr "WEKELIJKS"
220
 
221
  # @ rvg-optimize-database
222
- #: rvg-optimize-db.php:809
223
  msgid "Optimize your WordPress Database"
224
  msgstr "Optimaliseer uw WordPress Database"
225
 
226
- #: rvg-optimize-db.php:818 rvg-optimize-db.php:1994
227
  msgid "A WordPress Plugin by"
228
  msgstr "Een WordPress Plugin door"
229
 
230
- #: rvg-optimize-db.php:823
 
 
 
 
231
  msgid "Current settings"
232
  msgstr "Huidige instellingen"
233
 
234
- #: rvg-optimize-db.php:826
235
  msgid "Maximum number of - most recent - revisions to keep per post / page"
236
  msgstr ""
237
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
238
  "pagina"
239
 
240
- #: rvg-optimize-db.php:847
241
  msgid "Number of excluded tables"
242
  msgstr "Aantal uitgesloten tabellen"
243
 
244
- #: rvg-optimize-db.php:858
245
  msgid "Next scheduled run"
246
  msgstr "Volgende geplande uitvoering"
247
 
248
- #: rvg-optimize-db.php:867
249
  msgid "Total savings since the first run"
250
  msgstr "Totale besparing sinds de eerste uitvoering"
251
 
252
- #: rvg-optimize-db.php:874
253
  msgid "Change Settings"
254
  msgstr "Wijzig instellingen"
255
 
256
- #: rvg-optimize-db.php:880 rvg-optimize-db.php:1293
257
  msgid "View Log File"
258
  msgstr "Bekijk Logbestand"
259
 
260
- #: rvg-optimize-db.php:882 rvg-optimize-db.php:1295
261
  msgid "Delete Log File"
262
  msgstr "Verwijder Logbestand"
263
 
264
- #: rvg-optimize-db.php:891
265
  msgid "Start Optimization"
266
  msgstr "Start Optimalisatie"
267
 
268
- #: rvg-optimize-db.php:905
269
  msgid "Cleaning Database"
270
  msgstr "Opschonen Database"
271
 
272
- #: rvg-optimize-db.php:928
273
  msgid "DELETED REVISIONS"
274
  msgstr "VERWIJDERDE REVISIES"
275
 
276
- #: rvg-optimize-db.php:933 rvg-optimize-db.php:984 rvg-optimize-db.php:1036
277
  msgid "prefix"
278
  msgstr "prefix"
279
 
280
- #: rvg-optimize-db.php:934
281
  msgid "post / page"
282
  msgstr "bericht / pagina"
283
 
284
- #: rvg-optimize-db.php:935
285
  msgid "revision date"
286
  msgstr "revisiedatum"
287
 
288
- #: rvg-optimize-db.php:936
289
  msgid "revisions deleted"
290
  msgstr "revisies verwijderd"
291
 
292
- #: rvg-optimize-db.php:943
293
  msgid "total number of revisions deleted"
294
  msgstr "totaal aantal verwijderde revisies"
295
 
296
- #: rvg-optimize-db.php:953
297
  msgid "No REVISIONS found to delete"
298
  msgstr "Geen REVISIES gevonden om te verwijderen"
299
 
300
- #: rvg-optimize-db.php:979
301
  msgid "DELETED TRASHED ITEMS"
302
  msgstr "VERWIJDERDE TRASHED ITEMS"
303
 
304
- #: rvg-optimize-db.php:985
305
  msgid "type"
306
  msgstr "type"
307
 
308
- #: rvg-optimize-db.php:986
309
  msgid "IP address / title"
310
  msgstr "IP adres / titel"
311
 
312
- #: rvg-optimize-db.php:987
313
  msgid "date"
314
  msgstr "datum"
315
 
316
- #: rvg-optimize-db.php:994
317
  msgid "total number of trashed items deleted"
318
  msgstr "totaal aantal verwijderede trashed items"
319
 
320
- #: rvg-optimize-db.php:1004
321
  msgid "No TRASHED ITEMS found to delete"
322
  msgstr "Geen PRULLENBAK ITEMS gevonden om te verwijderen"
323
 
324
- #: rvg-optimize-db.php:1031
325
  msgid "DELETEED SPAMMED ITEMS"
326
  msgstr "VERWIJDERDE SPAMMEND ITEMS"
327
 
328
- #: rvg-optimize-db.php:1037
329
  msgid "comment author"
330
  msgstr "plaatser van de reactie"
331
 
332
- #: rvg-optimize-db.php:1038
333
  msgid "comment author email"
334
  msgstr "email van de plaatser van de reactie"
335
 
336
- #: rvg-optimize-db.php:1039
337
  msgid "comment date"
338
  msgstr "datum van de reactie"
339
 
340
- #: rvg-optimize-db.php:1046
341
  msgid "total number of spammed items deleted"
342
  msgstr "totaal aantal verwijderde spammed items"
343
 
344
- #: rvg-optimize-db.php:1056
345
  msgid "No SPAMMED ITEMS found to delete"
346
  msgstr "Geen SPAM gevonden om te verwijderen"
347
 
348
- #: rvg-optimize-db.php:1080
349
  msgid "NUMBER OF UNUSED TAGS DELETED"
350
  msgstr "AANTAL VERWIJDERDE ONGEBRUIKTE TAGS"
351
 
352
- #: rvg-optimize-db.php:1088
353
  msgid "No UNUSED TAGS found to delete"
354
  msgstr "Geen ONGEBRUIKTE TAGS gevonden om te verwijderen"
355
 
356
- #: rvg-optimize-db.php:1112
357
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
358
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
359
 
360
- #: rvg-optimize-db.php:1120
361
  msgid "No EXPIRED TRANSIENTS found to delete"
362
  msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
363
 
364
- #: rvg-optimize-db.php:1143
365
  msgid "NUMBER OF PINGBACKS AND TRACKBACKS DELETED"
366
  msgstr "AANTAL VERWIJDERDE PINGBACKS EN TRACKBACKS"
367
 
368
- #: rvg-optimize-db.php:1151
369
  msgid "No PINGBACKS nor TRACKBACKS found to delete"
370
  msgstr "Geen PINGBACKS en TRACKBACKS gevonden om te verwijderen"
371
 
372
- #: rvg-optimize-db.php:1172
373
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
374
  msgstr "AANTAL VERWIJDERDE POSTMETA WEZEN"
375
 
376
- #: rvg-optimize-db.php:1180
377
  msgid "No POSTMETA ORPHANS found to delete"
378
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
379
 
380
- #: rvg-optimize-db.php:1198
381
  msgid "Optimizing Database Tables"
382
  msgstr "Optimaliseren van Databasetabellen"
383
 
384
- #: rvg-optimize-db.php:1206
385
  msgid "table name"
386
  msgstr "tabelnaam"
387
 
388
- #: rvg-optimize-db.php:1207
389
  msgid "optimization result"
390
  msgstr "resultaat optimalisatie"
391
 
392
- #: rvg-optimize-db.php:1208
393
  msgid "engine"
394
  msgstr "engine"
395
 
396
- #: rvg-optimize-db.php:1209
397
  msgid "table rows"
398
  msgstr "tabelrijen"
399
 
400
- #: rvg-optimize-db.php:1210
401
  msgid "table size"
402
  msgstr "tabelgrootte"
403
 
404
- #: rvg-optimize-db.php:1237
405
  msgid "Savings"
406
  msgstr "Besparingen"
407
 
408
- #: rvg-optimize-db.php:1245
409
  msgid "size of the database"
410
  msgstr "grootte van de database"
411
 
412
- #: rvg-optimize-db.php:1248
413
  msgid "BEFORE optimization"
414
  msgstr "VOOR de optimalisatie"
415
 
416
- #: rvg-optimize-db.php:1252
417
  msgid "AFTER optimization"
418
  msgstr "NA de optimalisatie"
419
 
420
- #: rvg-optimize-db.php:1256
421
  msgid "SAVINGS THIS TIME"
422
  msgstr "DIT KEER BESPAARD"
423
 
424
- #: rvg-optimize-db.php:1260
425
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
426
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
427
 
428
- #: rvg-optimize-db.php:1276
429
  msgid "DONE!"
430
  msgstr "KLAAR!"
431
 
432
- #: rvg-optimize-db.php:1282
433
  msgid "Optimization took"
434
  msgstr "Optimalizatie duurde"
435
 
436
- #: rvg-optimize-db.php:1284
437
  msgid "seconds"
438
  msgstr "seconden"
439
 
440
- #: rvg-optimize-db.php:1912
441
  msgid "InnoDB table: skipped..."
442
  msgstr "InnoDB tabel overgeslagen..."
443
 
444
- #: rvg-optimize-db.php:1918
445
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
446
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
447
 
448
- #: rvg-optimize-db.php:1919
449
  msgid "Table is already up to date"
450
  msgstr "Tabel is al optimaal"
451
 
452
- #: rvg-optimize-db.php:1998
453
  msgid "time"
454
  msgstr "tijd"
455
 
456
- #: rvg-optimize-db.php:1999
457
  msgid "deleted<br />revisions"
458
  msgstr "verw.<br />revisies"
459
 
460
- #: rvg-optimize-db.php:2000
461
  msgid "deleted<br />trash"
462
  msgstr "verw.<br />prullenbak items"
463
 
464
- #: rvg-optimize-db.php:2001
465
  msgid "deleted<br />spam"
466
  msgstr "verw.<br />spamitems"
467
 
468
- #: rvg-optimize-db.php:2002
469
  msgid "deleted<br />tags"
470
  msgstr "verw.<br /> tags"
471
 
472
- #: rvg-optimize-db.php:2003
473
  msgid "deleted<br />transients"
474
  msgstr "verw.<br />transiënts"
475
 
476
- #: rvg-optimize-db.php:2004
477
  msgid "deleted<br />pingbacks<br />trackbacks"
478
  msgstr "verwijderde<br />pingbacks<br />trackbacks"
479
 
480
- #: rvg-optimize-db.php:2005
481
  msgid "deleted<br />orphans"
482
  msgstr "verw.<br />wezen"
483
 
484
  # @ rvg-optimize-database
485
- #: rvg-optimize-db.php:2006
486
  msgid "nr of optimized tables"
487
  msgstr "aantal geoptima-<br />liseerde tabellen"
488
 
489
- #: rvg-optimize-db.php:2007
490
  msgid "database size BEFORE"
491
  msgstr "database<br />grootte<br />VOOR"
492
 
493
- #: rvg-optimize-db.php:2008
494
  msgid "database size AFTER"
495
  msgstr "database<br />grootte<br />NA"
496
 
497
- #: rvg-optimize-db.php:2009
498
  msgid "SAVINGS"
499
  msgstr "BESPARINGEN"
500
 
 
 
 
 
 
 
 
 
 
 
 
 
501
  #~ msgid "Delete all trashed items"
502
  #~ msgstr "Maak de prullenbak leeg"
503
 
@@ -507,9 +527,6 @@ msgstr "BESPARINGEN"
507
  #~ msgid "Using Optimize Database after Deleting Revisions"
508
  #~ msgstr "Het gebruik van Optimize Database after Deleting Revisions"
509
 
510
- #~ msgid "Author"
511
- #~ msgstr "Auteur"
512
-
513
  #~ msgid "Optimize Database after Deleting Revisions - Settings"
514
  #~ msgstr "Optimize Database after Deleting Revisions - Instellingen"
515
 
2
  msgstr ""
3
  "Project-Id-Version: Optimize Database after Deleting Revisions v2.8.3\n"
4
  "Report-Msgid-Bugs-To: \n"
5
+ "POT-Creation-Date: 2015-08-30 14:32+0100\n"
6
+ "PO-Revision-Date: 2015-08-30 14:32+0100\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: nl_NL\n"
15
  "X-Poedit-SourceCharset: UTF-8\n"
16
  "X-Poedit-KeywordsList: __;_e;__ngettext:1,2;_n:1,2;__ngettext_noop:1,2;"
17
  "_n_noop:1,2;_c,_nc:4c,1,2;_x:1,2c;_ex:1,2c;_nx:4c,1,2;_nx_noop:4c,1,2\n"
18
+ "X-Poedit-Basepath: C:\\My Dropbox\\cagewebdev\\wp-content\\plugins\\rvg-"
19
+ "optimize-database\\\n"
20
  "X-Textdomain-Support: yes\n"
21
  "X-Poedit-SearchPath-0: .\n"
22
 
37
  msgid "Once Weekly"
38
  msgstr "Eenmaal per week"
39
 
40
+ #: rvg-optimize-db.php:449
41
  msgid "Optimize Database after Deleting Revisions SETTINGS UPDATED"
42
  msgstr "Optimize Database after Deleting Revisions INSTELLINGEN AANGEPAST"
43
 
44
+ #: rvg-optimize-db.php:451
45
  msgid ""
46
  "Click <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
47
  "\">HERE</a> to run the optimization"
49
  "Klik <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold\">HIER</"
50
  "a. om de optimalisatie te starten"
51
 
52
+ #: rvg-optimize-db.php:517
53
  msgid "Optimize Database after Deleting Revisions"
54
  msgstr "Optimize Database after Deleting Revisions"
55
 
56
+ #: rvg-optimize-db.php:521
57
  msgid "is an one-click plugin to clean and optimize your WordPress database"
58
  msgstr ""
59
  "is een één-klik plugin om de WordPress database op te schonen en te "
60
  "optimaliseren"
61
 
62
+ #: rvg-optimize-db.php:524
63
+ msgid "Plugin version"
64
+ msgstr "Plugin versie"
65
 
66
+ #: rvg-optimize-db.php:525
67
+ msgid "Plugin page"
68
+ msgstr "Pluginpagina"
69
 
70
+ #: rvg-optimize-db.php:526
71
+ msgid "Download page"
72
+ msgstr "Downloadpagina"
73
 
74
+ #: rvg-optimize-db.php:527
75
+ msgid "Author"
76
+ msgstr "Auteur"
77
 
78
+ #: rvg-optimize-db.php:528
79
+ msgid "Company"
80
+ msgstr "Bedrijf"
81
 
82
+ #: rvg-optimize-db.php:529
83
+ msgid "Donation page"
84
+ msgstr "Donatiepagina"
85
+
86
+ #: rvg-optimize-db.php:535
87
  msgid "Settings"
88
  msgstr "Instellingen"
89
 
90
+ #: rvg-optimize-db.php:543
91
  msgid ""
92
  "Maximum number of - most recent - revisions<br />to keep per post / page"
93
  msgstr ""
94
  "Maximale aantal - meest recente - revisies<br />om te bewaren per "
95
  "bericht / pagina"
96
 
97
+ #: rvg-optimize-db.php:547
98
  msgid "('0' means: delete <u>ALL</u> revisions)"
99
  msgstr "('0' betekent: verwijder <u>ALLE</u> revisies)"
100
 
101
+ #: rvg-optimize-db.php:551 rvg-optimize-db.php:840
102
  msgid "Delete trashed items"
103
  msgstr "Verwijder trashed items"
104
 
105
+ #: rvg-optimize-db.php:557 rvg-optimize-db.php:843
106
  msgid "Delete spammed items"
107
  msgstr "Verwijder spammed items"
108
 
109
+ #: rvg-optimize-db.php:563 rvg-optimize-db.php:846
110
  msgid "Delete unused tags"
111
  msgstr "Verwijder ongebruikte tags"
112
 
113
+ #: rvg-optimize-db.php:569 rvg-optimize-db.php:849
114
  msgid "Delete expired transients"
115
  msgstr "Verwijder verlopen transiënts"
116
 
117
+ #: rvg-optimize-db.php:575 rvg-optimize-db.php:852
118
  msgid "Delete pingbacks and trackbacks"
119
  msgstr "Verwijder pingback en trackbacks"
120
 
121
+ #: rvg-optimize-db.php:581 rvg-optimize-db.php:855
122
  msgid "Keep a log"
123
  msgstr "Gebruik een logbestand"
124
 
125
+ #: rvg-optimize-db.php:587 rvg-optimize-db.php:861
126
  msgid "Scheduler"
127
  msgstr "Planner"
128
 
129
+ #: rvg-optimize-db.php:591 rvg-optimize-db.php:798
130
  msgid "NOT SCHEDULED"
131
  msgstr "NIET GEPLAND"
132
 
133
+ #: rvg-optimize-db.php:594
134
  msgid "run optimization HOURLY"
135
  msgstr "voer de optimalisatie ELK UUR uit"
136
 
137
+ #: rvg-optimize-db.php:597
138
  msgid "run optimization TWICE A DAY"
139
  msgstr "voer de optimalisatie TWEE KEER PER DAG uit"
140
 
141
+ #: rvg-optimize-db.php:600
142
  msgid "run optimization DAILY"
143
  msgstr "voer de optimalisatie DAGELIJKS uit"
144
 
145
+ #: rvg-optimize-db.php:603
146
  msgid "run optimization WEEKLY"
147
  msgstr "voer de optimalisatie WEKELIJKS uit"
148
 
149
+ #: rvg-optimize-db.php:611
150
  msgid "Time"
151
  msgstr "Tijd"
152
 
153
+ #: rvg-optimize-db.php:618
154
  msgid "hrs"
155
  msgstr "uur"
156
 
157
+ #: rvg-optimize-db.php:631
158
  msgid "Show '1-click' link in Admin Bar"
159
  msgstr "Toon de '1-klik' link in de Admin Balk"
160
 
161
+ #: rvg-optimize-db.php:634 rvg-optimize-db.php:641
162
  msgid "(change will be visible after loading the next page)"
163
  msgstr "(wijziging wordt zichtbaar na het laden van de volgende pagina)"
164
 
165
+ #: rvg-optimize-db.php:638
166
  msgid "Show an icon in the Admin Menu"
167
  msgstr "Toon een icon in het Admin Menu"
168
 
169
+ #: rvg-optimize-db.php:646
170
  msgid ""
171
  "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class=\"odb-underline-red"
172
  "\">CHECKED</span> TABLES <span class=\"odb-underline-red\">WON'T</span> BE "
176
  "underline-red\">AANGEVINKTE</span> TABELLEN ZULLEN <span class=\"odb-"
177
  "underline-red\">NIET</span> GEOPTIMALISEERD WORDEN!</span>"
178
 
179
+ #: rvg-optimize-db.php:649
180
  msgid "check all tables"
181
  msgstr "vink alle tabellen aan"
182
 
183
+ #: rvg-optimize-db.php:651
184
  msgid "uncheck all tables"
185
  msgstr "vink alle tabellen uit"
186
 
187
+ #: rvg-optimize-db.php:653
188
  msgid "check all NON-WordPress tables"
189
  msgstr "vink alle NIET-WordPress tabellen aan"
190
 
191
+ #: rvg-optimize-db.php:677
192
  msgid "Save Settings"
193
  msgstr "Bewaar instellingen"
194
 
195
+ #: rvg-optimize-db.php:679
196
  msgid "Go To Optimizer"
197
  msgstr "Ga naar Optimalisatie"
198
 
199
+ #: rvg-optimize-db.php:741 rvg-optimize-db.php:748 rvg-optimize-db.php:755
200
+ #: rvg-optimize-db.php:762 rvg-optimize-db.php:770 rvg-optimize-db.php:777
201
  msgid "NO"
202
  msgstr "NEE"
203
 
204
+ #: rvg-optimize-db.php:741 rvg-optimize-db.php:748 rvg-optimize-db.php:755
205
+ #: rvg-optimize-db.php:762 rvg-optimize-db.php:770 rvg-optimize-db.php:777
206
  msgid "YES"
207
  msgstr "JA"
208
 
209
+ #: rvg-optimize-db.php:786
210
  msgid "ONCE HOURLY"
211
  msgstr "ELK UUR"
212
 
213
+ #: rvg-optimize-db.php:788
214
  msgid "TWICE DAILY"
215
  msgstr "TWEEMAAL DAAGS"
216
 
217
+ #: rvg-optimize-db.php:790
218
  msgid "ONCE DAILY"
219
  msgstr "DAGELIJKS"
220
 
221
+ #: rvg-optimize-db.php:792
222
  msgid "ONCE WEEKLY"
223
  msgstr "WEKELIJKS"
224
 
225
  # @ rvg-optimize-database
226
+ #: rvg-optimize-db.php:820
227
  msgid "Optimize your WordPress Database"
228
  msgstr "Optimaliseer uw WordPress Database"
229
 
230
+ #: rvg-optimize-db.php:829 rvg-optimize-db.php:1976
231
  msgid "A WordPress Plugin by"
232
  msgstr "Een WordPress Plugin door"
233
 
234
+ #: rvg-optimize-db.php:831 rvg-optimize-db.php:1976
235
+ msgid "The Netherlands"
236
+ msgstr "Nederland"
237
+
238
+ #: rvg-optimize-db.php:834
239
  msgid "Current settings"
240
  msgstr "Huidige instellingen"
241
 
242
+ #: rvg-optimize-db.php:837
243
  msgid "Maximum number of - most recent - revisions to keep per post / page"
244
  msgstr ""
245
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
246
  "pagina"
247
 
248
+ #: rvg-optimize-db.php:858
249
  msgid "Number of excluded tables"
250
  msgstr "Aantal uitgesloten tabellen"
251
 
252
+ #: rvg-optimize-db.php:869
253
  msgid "Next scheduled run"
254
  msgstr "Volgende geplande uitvoering"
255
 
256
+ #: rvg-optimize-db.php:878
257
  msgid "Total savings since the first run"
258
  msgstr "Totale besparing sinds de eerste uitvoering"
259
 
260
+ #: rvg-optimize-db.php:885
261
  msgid "Change Settings"
262
  msgstr "Wijzig instellingen"
263
 
264
+ #: rvg-optimize-db.php:891 rvg-optimize-db.php:1301
265
  msgid "View Log File"
266
  msgstr "Bekijk Logbestand"
267
 
268
+ #: rvg-optimize-db.php:893 rvg-optimize-db.php:1303
269
  msgid "Delete Log File"
270
  msgstr "Verwijder Logbestand"
271
 
272
+ #: rvg-optimize-db.php:902
273
  msgid "Start Optimization"
274
  msgstr "Start Optimalisatie"
275
 
276
+ #: rvg-optimize-db.php:915
277
  msgid "Cleaning Database"
278
  msgstr "Opschonen Database"
279
 
280
+ #: rvg-optimize-db.php:938
281
  msgid "DELETED REVISIONS"
282
  msgstr "VERWIJDERDE REVISIES"
283
 
284
+ #: rvg-optimize-db.php:943 rvg-optimize-db.php:994 rvg-optimize-db.php:1046
285
  msgid "prefix"
286
  msgstr "prefix"
287
 
288
+ #: rvg-optimize-db.php:944
289
  msgid "post / page"
290
  msgstr "bericht / pagina"
291
 
292
+ #: rvg-optimize-db.php:945
293
  msgid "revision date"
294
  msgstr "revisiedatum"
295
 
296
+ #: rvg-optimize-db.php:946
297
  msgid "revisions deleted"
298
  msgstr "revisies verwijderd"
299
 
300
+ #: rvg-optimize-db.php:953
301
  msgid "total number of revisions deleted"
302
  msgstr "totaal aantal verwijderde revisies"
303
 
304
+ #: rvg-optimize-db.php:963
305
  msgid "No REVISIONS found to delete"
306
  msgstr "Geen REVISIES gevonden om te verwijderen"
307
 
308
+ #: rvg-optimize-db.php:989
309
  msgid "DELETED TRASHED ITEMS"
310
  msgstr "VERWIJDERDE TRASHED ITEMS"
311
 
312
+ #: rvg-optimize-db.php:995
313
  msgid "type"
314
  msgstr "type"
315
 
316
+ #: rvg-optimize-db.php:996
317
  msgid "IP address / title"
318
  msgstr "IP adres / titel"
319
 
320
+ #: rvg-optimize-db.php:997
321
  msgid "date"
322
  msgstr "datum"
323
 
324
+ #: rvg-optimize-db.php:1004
325
  msgid "total number of trashed items deleted"
326
  msgstr "totaal aantal verwijderede trashed items"
327
 
328
+ #: rvg-optimize-db.php:1014
329
  msgid "No TRASHED ITEMS found to delete"
330
  msgstr "Geen PRULLENBAK ITEMS gevonden om te verwijderen"
331
 
332
+ #: rvg-optimize-db.php:1041
333
  msgid "DELETEED SPAMMED ITEMS"
334
  msgstr "VERWIJDERDE SPAMMEND ITEMS"
335
 
336
+ #: rvg-optimize-db.php:1047
337
  msgid "comment author"
338
  msgstr "plaatser van de reactie"
339
 
340
+ #: rvg-optimize-db.php:1048
341
  msgid "comment author email"
342
  msgstr "email van de plaatser van de reactie"
343
 
344
+ #: rvg-optimize-db.php:1049
345
  msgid "comment date"
346
  msgstr "datum van de reactie"
347
 
348
+ #: rvg-optimize-db.php:1056
349
  msgid "total number of spammed items deleted"
350
  msgstr "totaal aantal verwijderde spammed items"
351
 
352
+ #: rvg-optimize-db.php:1066
353
  msgid "No SPAMMED ITEMS found to delete"
354
  msgstr "Geen SPAM gevonden om te verwijderen"
355
 
356
+ #: rvg-optimize-db.php:1090
357
  msgid "NUMBER OF UNUSED TAGS DELETED"
358
  msgstr "AANTAL VERWIJDERDE ONGEBRUIKTE TAGS"
359
 
360
+ #: rvg-optimize-db.php:1098
361
  msgid "No UNUSED TAGS found to delete"
362
  msgstr "Geen ONGEBRUIKTE TAGS gevonden om te verwijderen"
363
 
364
+ #: rvg-optimize-db.php:1122
365
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
366
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
367
 
368
+ #: rvg-optimize-db.php:1130
369
  msgid "No EXPIRED TRANSIENTS found to delete"
370
  msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
371
 
372
+ #: rvg-optimize-db.php:1154
373
  msgid "NUMBER OF PINGBACKS AND TRACKBACKS DELETED"
374
  msgstr "AANTAL VERWIJDERDE PINGBACKS EN TRACKBACKS"
375
 
376
+ #: rvg-optimize-db.php:1162
377
  msgid "No PINGBACKS nor TRACKBACKS found to delete"
378
  msgstr "Geen PINGBACKS en TRACKBACKS gevonden om te verwijderen"
379
 
380
+ #: rvg-optimize-db.php:1183
381
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
382
  msgstr "AANTAL VERWIJDERDE POSTMETA WEZEN"
383
 
384
+ #: rvg-optimize-db.php:1191
385
  msgid "No POSTMETA ORPHANS found to delete"
386
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
387
 
388
+ #: rvg-optimize-db.php:1208
389
  msgid "Optimizing Database Tables"
390
  msgstr "Optimaliseren van Databasetabellen"
391
 
392
+ #: rvg-optimize-db.php:1216
393
  msgid "table name"
394
  msgstr "tabelnaam"
395
 
396
+ #: rvg-optimize-db.php:1217
397
  msgid "optimization result"
398
  msgstr "resultaat optimalisatie"
399
 
400
+ #: rvg-optimize-db.php:1218
401
  msgid "engine"
402
  msgstr "engine"
403
 
404
+ #: rvg-optimize-db.php:1219
405
  msgid "table rows"
406
  msgstr "tabelrijen"
407
 
408
+ #: rvg-optimize-db.php:1220
409
  msgid "table size"
410
  msgstr "tabelgrootte"
411
 
412
+ #: rvg-optimize-db.php:1246
413
  msgid "Savings"
414
  msgstr "Besparingen"
415
 
416
+ #: rvg-optimize-db.php:1254
417
  msgid "size of the database"
418
  msgstr "grootte van de database"
419
 
420
+ #: rvg-optimize-db.php:1257
421
  msgid "BEFORE optimization"
422
  msgstr "VOOR de optimalisatie"
423
 
424
+ #: rvg-optimize-db.php:1261
425
  msgid "AFTER optimization"
426
  msgstr "NA de optimalisatie"
427
 
428
+ #: rvg-optimize-db.php:1265
429
  msgid "SAVINGS THIS TIME"
430
  msgstr "DIT KEER BESPAARD"
431
 
432
+ #: rvg-optimize-db.php:1269
433
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
434
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
435
 
436
+ #: rvg-optimize-db.php:1284
437
  msgid "DONE!"
438
  msgstr "KLAAR!"
439
 
440
+ #: rvg-optimize-db.php:1290
441
  msgid "Optimization took"
442
  msgstr "Optimalizatie duurde"
443
 
444
+ #: rvg-optimize-db.php:1292
445
  msgid "seconds"
446
  msgstr "seconden"
447
 
448
+ #: rvg-optimize-db.php:1894
449
  msgid "InnoDB table: skipped..."
450
  msgstr "InnoDB tabel overgeslagen..."
451
 
452
+ #: rvg-optimize-db.php:1900
453
  msgid "<span class=\"odb-optimized\">TABLE OPTIMIZED</span>"
454
  msgstr "<span class=\"odb-optimized\">TABEL GEOPTIMALISEERD</span>"
455
 
456
+ #: rvg-optimize-db.php:1901
457
  msgid "Table is already up to date"
458
  msgstr "Tabel is al optimaal"
459
 
460
+ #: rvg-optimize-db.php:1980
461
  msgid "time"
462
  msgstr "tijd"
463
 
464
+ #: rvg-optimize-db.php:1981
465
  msgid "deleted<br />revisions"
466
  msgstr "verw.<br />revisies"
467
 
468
+ #: rvg-optimize-db.php:1982
469
  msgid "deleted<br />trash"
470
  msgstr "verw.<br />prullenbak items"
471
 
472
+ #: rvg-optimize-db.php:1983
473
  msgid "deleted<br />spam"
474
  msgstr "verw.<br />spamitems"
475
 
476
+ #: rvg-optimize-db.php:1984
477
  msgid "deleted<br />tags"
478
  msgstr "verw.<br /> tags"
479
 
480
+ #: rvg-optimize-db.php:1985
481
  msgid "deleted<br />transients"
482
  msgstr "verw.<br />transiënts"
483
 
484
+ #: rvg-optimize-db.php:1986
485
  msgid "deleted<br />pingbacks<br />trackbacks"
486
  msgstr "verwijderde<br />pingbacks<br />trackbacks"
487
 
488
+ #: rvg-optimize-db.php:1987
489
  msgid "deleted<br />orphans"
490
  msgstr "verw.<br />wezen"
491
 
492
  # @ rvg-optimize-database
493
+ #: rvg-optimize-db.php:1988
494
  msgid "nr of optimized tables"
495
  msgstr "aantal geoptima-<br />liseerde tabellen"
496
 
497
+ #: rvg-optimize-db.php:1989
498
  msgid "database size BEFORE"
499
  msgstr "database<br />grootte<br />VOOR"
500
 
501
+ #: rvg-optimize-db.php:1990
502
  msgid "database size AFTER"
503
  msgstr "database<br />grootte<br />NA"
504
 
505
+ #: rvg-optimize-db.php:1991
506
  msgid "SAVINGS"
507
  msgstr "BESPARINGEN"
508
 
509
+ #~ msgid "Plugin version:"
510
+ #~ msgstr "Plugin versie:"
511
+
512
+ #~ msgid "Author:"
513
+ #~ msgstr "Auteur:"
514
+
515
+ #~ msgid "Plugin URL:"
516
+ #~ msgstr "Plugin URL:"
517
+
518
+ #~ msgid "Download URL:"
519
+ #~ msgstr "Download URL:"
520
+
521
  #~ msgid "Delete all trashed items"
522
  #~ msgstr "Maak de prullenbak leeg"
523
 
527
  #~ msgid "Using Optimize Database after Deleting Revisions"
528
  #~ msgstr "Het gebruik van Optimize Database after Deleting Revisions"
529
 
 
 
 
530
  #~ msgid "Optimize Database after Deleting Revisions - Settings"
531
  #~ msgstr "Optimize Database after Deleting Revisions - Instellingen"
532
 
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.8
10
  Tested up to: 4.3
11
- Stable tag: 3.4.6
12
- Version: 3.4.6
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -86,6 +86,9 @@ http://cagewebdev.com/index.php/wordpress-plugins/
86
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
87
 
88
  == Changelog ==
 
 
 
89
  = 3.4.6 [06/21/2015] =
90
  * NEW: Danish translation (da_DK) added
91
 
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.8
10
  Tested up to: 4.3
11
+ Stable tag: 3.4.7
12
+ Version: 3.4.7
13
  License: GPLv2 or later
14
 
15
  == Description ==
86
  * If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!
87
 
88
  == Changelog ==
89
+ = 3.4.7 [08/30/2015] =
90
+ * BUG FIX: Transients are now deleted using the delete_transient() / delete_site_transient() functions
91
+
92
  = 3.4.6 [06/21/2015] =
93
  * NEW: Danish translation (da_DK) added
94
 
rvg-optimize-db.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
- * @version 3.4.6
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
@@ -9,11 +9,11 @@ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-rev
9
  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
- Version: 3.4.6
13
  */
14
 
15
- $odb_version = '3.4.6';
16
- $odb_release_date = '06/21/2015';
17
 
18
  // v3.3 - MULTISITE
19
  $odb_ms_prefixes = array();
@@ -520,24 +520,14 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
520
  <p class="odb-bold">'<span class="odb-italic">Optimize Database after Deleting Revisions</span> '
521
  <?php _e('is an one-click plugin to clean and optimize your WordPress database','rvg-optimize-database');?>
522
  </p>
523
- <p>
524
- <?php _e('Plugin version:','rvg-optimize-database');?>
525
- <br />
526
- <span class="odb-bold">v<?php echo $odb_version ?> (<?php echo $odb_release_date?>)</span></p>
527
- <p><span class="odb-bold">
528
- <?php _e('Author:','rvg-optimize-database');?>
529
- </span><br />
530
- <span class="odb-bold"><a href="http://cagewebdev.com/" target="_blank">CAGE Web Design</a> | <a href="http://rvg.cage.nl/" target="_blank">Rolf van Gelder</a></span>, Eindhoven,
531
- <?php _e('The Netherlands','rvg-optimize-database');?>
532
- <br />
533
- <span class="odb-bold">
534
- <?php _e('Plugin URL:','rvg-optimize-database');?>
535
- </span><br />
536
- <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank"><span class="odb-bold">http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/</span></a><br />
537
- <span class="odb-bold">
538
- <?php _e('Download URL:','rvg-optimize-database');?>
539
- </span><br />
540
- <span class="odb-bold"><a href="https://wordpress.org/plugins/rvg-optimize-database/" target="_blank">https://wordpress.org/plugins/rvg-optimize-database/</a></span></p>
541
  </div>
542
  <div id="odb-options-settings">
543
  <div class="odb-title-bar">
@@ -713,7 +703,7 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
713
  ********************************************************************************************/
714
  function rvg_optimize_db()
715
  {
716
- global $wpdb, $odb_version, $odb_ms_prefixes;
717
 
718
  // v3.3 - GET NETWORK INFORMATION (MULTISITE)
719
  rvg_odb_network_info();
@@ -835,49 +825,43 @@ function rvg_optimize_db()
835
  if($_REQUEST['action'] == "delete_log")
836
  echo '<div class="updated odb-updated"><p><span class="odb-bold">Optimize Database after Deleting Revisions - LOG FILE DELETED</span></p></div>';
837
  ?>
838
- <p><span class="odb-italic"><a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank" class="odb-bold">Optimize Database after Deleting Revisions v<?php echo $odb_version?></a> -
839
- <?php _e('A WordPress Plugin by','rvg-optimize-database');?>
840
- <a href="http://cagewebdev.com/" target="_blank" class="odb-bold">CAGE Web Design</a> | <a href="http://rvg.cage.nl/" target="_blank" class="odb-bold">Rolf van Gelder</a>, Eindhoven,
841
- <?php _e('The Netherlands','rvg-optimize-database');?>
842
- </span></p>
843
  <p>
844
- <?php _e('Current settings','rvg-optimize-database');?>
845
- :<br />
846
  <span class="odb-bold">
847
- <?php _e('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?>
848
- :</span> <span class="odb-bold odb-blue"><?php echo $max_revisions?></span><br />
 
 
 
 
 
 
 
 
 
 
849
  <span class="odb-bold">
850
- <?php _e('Delete trashed items','rvg-optimize-database');?>
851
- :</span> <span class="odb-bold odb-blue"><?php echo $clear_trash_yn?></span><br />
852
  <span class="odb-bold">
853
- <?php _e('Delete spammed items','rvg-optimize-database');?>
854
- :</span> <span class="odb-bold odb-blue"><?php echo $clear_spam_yn?></span><br />
855
  <span class="odb-bold">
856
- <?php _e('Delete unused tags','rvg-optimize-database');?>
857
- :</span> <span class="odb-bold odb-blue"><?php echo $clear_tags_yn?></span><br />
858
  <span class="odb-bold">
859
- <?php _e('Delete expired transients','rvg-optimize-database');?>
860
- :</span> <span class="odb-bold odb-blue"><?php echo $clear_transients_yn?></span><br />
861
  <span class="odb-bold">
862
- <?php _e('Delete pingbacks and trackbacks','rvg-optimize-database');?>
863
- :</span> <span class="odb-bold odb-blue"><?php echo $clear_pingbacks_yn?></span><br />
864
  <span class="odb-bold">
865
- <?php _e('Keep a log','rvg-optimize-database');?>
866
- :</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_logging_on_yn?></span><br />
867
  <span class="odb-bold">
868
- <?php _e('Number of excluded tables','rvg-optimize-database');?>
869
- :</span> <span class="odb-bold odb-blue"><?php echo $number_excluded?></span><br />
870
  <span class="odb-bold">
871
- <?php _e('Scheduler','rvg-optimize-database');?>
872
- :</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_schedule_txt?></span>
873
  <?php
874
  if($nextrun)
875
  {
876
  ?>
877
  <br />
878
  <span class="odb-bold">
879
- <?php _e('Next scheduled run','rvg-optimize-database');?>
880
- :</span> <span class="odb-bold odb-blue"><?php echo $nextrun?> hrs (current server time: <?php echo $current_hour?>)</span>
881
  <?php
882
  }
883
  if($total_savings)
@@ -885,8 +869,7 @@ function rvg_optimize_db()
885
  ?>
886
  <br />
887
  <span class="odb-bold">
888
- <?php _e('Total savings since the first run','rvg-optimize-database');?>
889
- :</span> <span class="odb-bold odb-blue"><?php echo rvg_format_size($total_savings); ?></span>
890
  <?php
891
  }
892
  ?>
@@ -1700,13 +1683,14 @@ function rvg_delete_tags_is_scheduled($term_id, $odb_prefix)
1700
  *
1701
  * DELETE EXPIRED TRANSIENTS
1702
  *
1703
- * v3.2: MULTISITE
 
1704
  *
1705
  ********************************************************************************************/
1706
  function rvg_delete_transients()
1707
  {
1708
  global $wpdb, $odb_ms_prefixes;
1709
-
1710
  $delay = time() - 60; // ONE MINUTE DELAY
1711
 
1712
  $total_deleted = 0;
@@ -1714,34 +1698,9 @@ function rvg_delete_transients()
1714
  // LOOP THROUGH THE NETWORK
1715
  for($i=0; $i<count($odb_ms_prefixes); $i++)
1716
  {
 
1717
  $sql = "
1718
- SELECT *
1719
- FROM ".$odb_ms_prefixes[$i]."options
1720
- WHERE (
1721
- option_name LIKE '_transient_timeout_%'
1722
- OR option_name LIKE '_site_transient_timeout_%'
1723
- OR option_name LIKE 'displayed_galleries_%'
1724
- )
1725
- AND option_value < '$delay'
1726
- ";
1727
-
1728
- $results = $wpdb->get_results($sql);
1729
- $total_deleted = count($results);
1730
-
1731
- $sql = "
1732
- DELETE FROM ".$odb_ms_prefixes[$i]."options
1733
- WHERE (
1734
- option_name LIKE '_transient_timeout_%'
1735
- OR option_name LIKE '_site_transient_timeout_%'
1736
- OR option_name LIKE 'displayed_galleries_%'
1737
- )
1738
- AND option_value < '$delay'
1739
- ";
1740
-
1741
- $wpdb->get_results($sql);
1742
-
1743
- $sql = "
1744
- SELECT *
1745
  FROM ".$odb_ms_prefixes[$i]."options
1746
  WHERE (
1747
  option_name LIKE '_transient_timeout_%'
@@ -1752,19 +1711,25 @@ function rvg_delete_transients()
1752
 
1753
  $results = $wpdb->get_results($sql);
1754
  $total_deleted += count($results);
1755
-
1756
- $sql = "
1757
- DELETE FROM ".$odb_ms_prefixes[$i]."options
1758
- WHERE (
1759
- option_name LIKE '_transient_timeout_%'
1760
- OR option_name LIKE '_site_transient_timeout_%'
1761
- )
1762
- AND option_value < '$delay'
1763
- ";
1764
 
1765
- $wpdb->get_results($sql);
1766
- }
1767
-
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1768
  return $total_deleted;
1769
  } // rvg_delete_transients()
1770
 
1
  <?php
2
  /**
3
  * @package Optimize Database after Deleting Revisions
4
+ * @version 3.4.7
5
  */
6
  /*
7
  Plugin Name: Optimize Database after Deleting Revisions
9
  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
+ Version: 3.4.7
13
  */
14
 
15
+ $odb_version = '3.4.7';
16
+ $odb_release_date = '08/30/2015';
17
 
18
  // v3.3 - MULTISITE
19
  $odb_ms_prefixes = array();
520
  <p class="odb-bold">'<span class="odb-italic">Optimize Database after Deleting Revisions</span> '
521
  <?php _e('is an one-click plugin to clean and optimize your WordPress database','rvg-optimize-database');?>
522
  </p>
523
+ <span class="odb-bold">
524
+ <?php _e( 'Plugin version', 'rvg-optimize-database' ); ?>: v<?php echo $odb_version?> [<?php echo $odb_release_date?>] - <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank">
525
+ <?php _e( 'Plugin page', 'rvg-optimize-database' ); ?></a> - <a href="http://wordpress.org/plugins/rvg-optimize-database/" target="_blank">
526
+ <?php _e( 'Download page', 'rvg-optimize-database' ); ?></a> - <a href="http://rvg.cage.nl/" target="_blank">
527
+ <?php _e( 'Author', 'rvg-optimize-database' ); ?></a> - <a href="http://cagewebdev.com/" target="_blank">
528
+ <?php _e( 'Company', 'rvg-optimize-database' ); ?></a> - <a href="http://cagewebdev.com/index.php/donations-odb/" target="_blank">
529
+ <?php _e( 'Donation page', 'rvg-optimize-database' ); ?></a><br />
530
+ </span>
 
 
 
 
 
 
 
 
 
 
531
  </div>
532
  <div id="odb-options-settings">
533
  <div class="odb-title-bar">
703
  ********************************************************************************************/
704
  function rvg_optimize_db()
705
  {
706
+ global $wpdb, $odb_version, $odb_release_date, $odb_ms_prefixes;
707
 
708
  // v3.3 - GET NETWORK INFORMATION (MULTISITE)
709
  rvg_odb_network_info();
825
  if($_REQUEST['action'] == "delete_log")
826
  echo '<div class="updated odb-updated"><p><span class="odb-bold">Optimize Database after Deleting Revisions - LOG FILE DELETED</span></p></div>';
827
  ?>
 
 
 
 
 
828
  <p>
 
 
829
  <span class="odb-bold">
830
+ <?php _e( 'Plugin version', 'rvg-optimize-database' ); ?>: v<?php echo $odb_version?> [<?php echo $odb_release_date?>] - <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank">
831
+ <?php _e( 'Plugin page', 'rvg-optimize-database' ); ?></a> - <a href="http://wordpress.org/plugins/rvg-optimize-database/" target="_blank">
832
+ <?php _e( 'Download page', 'rvg-optimize-database' ); ?></a> - <a href="http://rvg.cage.nl/" target="_blank">
833
+ <?php _e( 'Author', 'rvg-optimize-database' ); ?></a> - <a href="http://cagewebdev.com/" target="_blank">
834
+ <?php _e( 'Company', 'rvg-optimize-database' ); ?></a> - <a href="http://cagewebdev.com/index.php/donations-odb/" target="_blank">
835
+ <?php _e( 'Donation page', 'rvg-optimize-database' ); ?></a><br />
836
+ </span>
837
+ </p>
838
+ <p>
839
+ <?php _e('Current settings','rvg-optimize-database');?>:<br />
840
+ <span class="odb-bold">
841
+ <?php _e('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $max_revisions?></span><br />
842
  <span class="odb-bold">
843
+ <?php _e('Delete trashed items','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_trash_yn?></span><br />
 
844
  <span class="odb-bold">
845
+ <?php _e('Delete spammed items','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_spam_yn?></span><br />
 
846
  <span class="odb-bold">
847
+ <?php _e('Delete unused tags','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_tags_yn?></span><br />
 
848
  <span class="odb-bold">
849
+ <?php _e('Delete expired transients','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_transients_yn?></span><br />
 
850
  <span class="odb-bold">
851
+ <?php _e('Delete pingbacks and trackbacks','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_pingbacks_yn?></span><br />
 
852
  <span class="odb-bold">
853
+ <?php _e('Keep a log','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_logging_on_yn?></span><br />
 
854
  <span class="odb-bold">
855
+ <?php _e('Number of excluded tables','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $number_excluded?></span><br />
 
856
  <span class="odb-bold">
857
+ <?php _e('Scheduler','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_schedule_txt?></span>
 
858
  <?php
859
  if($nextrun)
860
  {
861
  ?>
862
  <br />
863
  <span class="odb-bold">
864
+ <?php _e('Next scheduled run','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $nextrun?> hrs (current server time: <?php echo $current_hour?>)</span>
 
865
  <?php
866
  }
867
  if($total_savings)
869
  ?>
870
  <br />
871
  <span class="odb-bold">
872
+ <?php _e('Total savings since the first run','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo rvg_format_size($total_savings); ?></span>
 
873
  <?php
874
  }
875
  ?>
1683
  *
1684
  * DELETE EXPIRED TRANSIENTS
1685
  *
1686
+ * v3.2: MULTISITE
1687
+ * v3.4.7: from now on it uses the delete_transient() and delete_site_transients() functions
1688
  *
1689
  ********************************************************************************************/
1690
  function rvg_delete_transients()
1691
  {
1692
  global $wpdb, $odb_ms_prefixes;
1693
+
1694
  $delay = time() - 60; // ONE MINUTE DELAY
1695
 
1696
  $total_deleted = 0;
1698
  // LOOP THROUGH THE NETWORK
1699
  for($i=0; $i<count($odb_ms_prefixes); $i++)
1700
  {
1701
+ // FIND EXPIRED TRANSIENTS
1702
  $sql = "
1703
+ SELECT `option_name`
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1704
  FROM ".$odb_ms_prefixes[$i]."options
1705
  WHERE (
1706
  option_name LIKE '_transient_timeout_%'
1711
 
1712
  $results = $wpdb->get_results($sql);
1713
  $total_deleted += count($results);
 
 
 
 
 
 
 
 
 
1714
 
1715
+ // LOOP THROUGH THE RESULTS
1716
+ for($i=0; $i<count($results); $i++)
1717
+ {
1718
+ if(substr($results[$i]->option_name, 0, 19) == '_transient_timeout_')
1719
+ { // _transient_timeout_%
1720
+ $transient = substr($results[$i]->option_name, 19);
1721
+ // DELETE THE TRANSIENT
1722
+ delete_transient($transient);
1723
+ }
1724
+ else
1725
+ { // _site_transient_timeout_%
1726
+ $transient = substr($results[$i]->option_name, 24);
1727
+ // DELETE THE TRANSIENT
1728
+ delete_site_transient($transient);
1729
+ }
1730
+ } // for($i=0; $i<count($results); $i++)
1731
+
1732
+ } // for($i=0; $i<count($odb_ms_prefixes); $i++)
1733
  return $total_deleted;
1734
  } // rvg_delete_transients()
1735