Optimize Database after Deleting Revisions - Version 3.1.4

Version Description

[03/01/2015] = * NEW: italian language support [it_IT] added (thanks Fabio Marzocca!) * NEW: optimization timer * CHANGE: from now on InnoDB tables are skipped from optimization * CHANGE: various minor improvements * BUG FIX: removed strtolower while fetching database properties

Download this release

Release Info

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

Code changes from version 3.1.3 to 3.1.4

Files changed (9) hide show
  1. css/style.css +5 -2
  2. language/rvg-optimize-database-it_IT.mo +0 -0
  3. language/rvg-optimize-database-it_IT.po +552 -0
  4. language/rvg-optimize-database-nl_NL.mo +0 -0
  5. language/rvg-optimize-database-nl_NL.po +224 -151
  6. language/rvg-optimize-database-sr_RS.mo +0 -0
  7. language/rvg-optimize-database-sr_RS.po +203 -149
  8. readme.txt +12 -4
  9. rvg-optimize-db.php +318 -280
css/style.css CHANGED
@@ -30,10 +30,13 @@
30
  width: 100px;
31
  height: 1px;
32
  border-bottom: solid 1px #999;
33
- margin-top: 16px;
34
- margin-bottom: 14px;
35
  margin-left: 10px;
36
  }
 
 
 
37
  .odb-underline-red {
38
  text-decoration: underline;
39
  color: #F00;
30
  width: 100px;
31
  height: 1px;
32
  border-bottom: solid 1px #999;
33
+ margin-top: 7px;
34
+ margin-bottom: 7px;
35
  margin-left: 10px;
36
  }
37
+ .odb-optimizing-table {
38
+ margin-top: 16px;
39
+ }
40
  .odb-underline-red {
41
  text-decoration: underline;
42
  color: #F00;
language/rvg-optimize-database-it_IT.mo ADDED
Binary file
language/rvg-optimize-database-it_IT.po ADDED
@@ -0,0 +1,552 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ 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-03-01 15:05+0100\n"
6
+ "PO-Revision-Date: 2015-03-01 16:22+0100\n"
7
+ "Last-Translator: Fabio Marzocca <marzoccafabio@gmail.com>\n"
8
+ "Language-Team: CAGE <info@cagewebdev.com>\n"
9
+ "Language: it_IT\n"
10
+ "MIME-Version: 1.0\n"
11
+ "Content-Type: text/plain; charset=UTF-8\n"
12
+ "Content-Transfer-Encoding: 8bit\n"
13
+ "Plural-Forms: nplurals=2; plural=(n != 1);\n"
14
+ "X-Generator: Poedit 1.7.4\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:/Users/rvgelder.KC15435/Documents/My Dropbox/cagewebdev/"
19
+ "wp-content/plugins/rvg-optimize-database\n"
20
+ "X-Textdomain-Support: yes\n"
21
+ "X-Poedit-SearchPath-0: .\n"
22
+
23
+ # @ rvg-optimize-database
24
+ #: rvg-optimize-db.php:39 rvg-optimize-db.php:40 rvg-optimize-db.php:59
25
+ #: rvg-optimize-db.php:60 rvg-optimize-db.php:80 rvg-optimize-db.php:81
26
+ #: rvg-optimize-db.php:100 rvg-optimize-db.php:101
27
+ msgid "Optimize Database"
28
+ msgstr "Ottimizza il Database"
29
+
30
+ # @ optimize_db
31
+ #: rvg-optimize-db.php:136
32
+ msgid "Optimize DB (1 click)"
33
+ msgstr "Ottimizza il DB (con 1 click)"
34
+
35
+ # @ default
36
+ #: rvg-optimize-db.php:165
37
+ msgid "Once Weekly"
38
+ msgstr "Una volta a settimana"
39
+
40
+ # @ default
41
+ #: rvg-optimize-db.php:201
42
+ msgctxt "timezone date format"
43
+ msgid "YmdGis"
44
+ msgstr "YmdGis"
45
+
46
+ #: rvg-optimize-db.php:318
47
+ msgid "Optimize Database after Deleting Revisions SETTINGS UPDATED"
48
+ msgstr "Optimize Database after Deleting Revisions IMPOSTAZIONI AGGIORNATE"
49
+
50
+ #: rvg-optimize-db.php:320
51
+ msgid ""
52
+ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
53
+ "\">HERE</a> to run the optimization"
54
+ msgstr ""
55
+ "Clicca <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
56
+ "\">QUI</a> per eseguire l'ottimizzazione"
57
+
58
+ #: rvg-optimize-db.php:372
59
+ msgid "Using Optimize Database after Deleting Revisions"
60
+ msgstr "Utilizzando Ottimizza il database dopo l'eliminazione Revisioni"
61
+
62
+ #: rvg-optimize-db.php:374
63
+ msgid "is an one-click plugin to clean and optimize your WordPress database"
64
+ msgstr ""
65
+ "è un plugin per pulire e ottimizzare il vostro database Wordpress con un "
66
+ "click"
67
+
68
+ #: rvg-optimize-db.php:375
69
+ msgid "Plugin version:"
70
+ msgstr "Versione Plugin:"
71
+
72
+ #: rvg-optimize-db.php:377
73
+ msgid "Author"
74
+ msgstr "Autore"
75
+
76
+ #: rvg-optimize-db.php:378 rvg-optimize-db.php:656 rvg-optimize-db.php:1736
77
+ msgid "The Netherlands"
78
+ msgstr "Paesi Bassi"
79
+
80
+ #: rvg-optimize-db.php:379
81
+ msgid "Plugin URL:"
82
+ msgstr "URL del plugin:"
83
+
84
+ #: rvg-optimize-db.php:381
85
+ msgid "Download URL:"
86
+ msgstr "URL per scaricare:"
87
+
88
+ #: rvg-optimize-db.php:385
89
+ msgid "Optimize Database after Deleting Revisions - Settings"
90
+ msgstr "Optimize Database after Deleting Revisions - Impostazioni"
91
+
92
+ #: rvg-optimize-db.php:403 rvg-optimize-db.php:658
93
+ msgid "Maximum number of - most recent - revisions to keep per post / page"
94
+ msgstr ""
95
+ "Massimo numero di revisioni recenti da mantenere per ogni articolo / pagina"
96
+
97
+ #: rvg-optimize-db.php:404
98
+ msgid "('0' means: delete <u>ALL</u> revisions)"
99
+ msgstr "('0' significa: cancella <u>TUTTE</u> le revisioni)"
100
+
101
+ #: rvg-optimize-db.php:408 rvg-optimize-db.php:659
102
+ msgid "Delete all trashed items"
103
+ msgstr "Cancella il cestino"
104
+
105
+ #: rvg-optimize-db.php:412 rvg-optimize-db.php:660
106
+ msgid "Delete all spammed items"
107
+ msgstr "Cancella tutti gli elementi di spam"
108
+
109
+ #: rvg-optimize-db.php:416 rvg-optimize-db.php:661
110
+ msgid "Delete unused tags"
111
+ msgstr "Cancella tags non usati"
112
+
113
+ #: rvg-optimize-db.php:420 rvg-optimize-db.php:662
114
+ msgid "Delete expired transients"
115
+ msgstr "Cancella transienti scaduti"
116
+
117
+ #: rvg-optimize-db.php:424 rvg-optimize-db.php:663
118
+ msgid "Delete pingbacks and trackbacks"
119
+ msgstr "Cancella pingbacks e trackbacks"
120
+
121
+ #: rvg-optimize-db.php:428 rvg-optimize-db.php:664
122
+ msgid "Keep a log"
123
+ msgstr "Mantieni un log"
124
+
125
+ #: rvg-optimize-db.php:432 rvg-optimize-db.php:666
126
+ msgid "Scheduler"
127
+ msgstr "Pianificatore"
128
+
129
+ #: rvg-optimize-db.php:434 rvg-optimize-db.php:630
130
+ msgid "NOT SCHEDULED"
131
+ msgstr "NON PIANIFICATO"
132
+
133
+ #: rvg-optimize-db.php:435
134
+ msgid "run optimization HOURLY"
135
+ msgstr "esegui l'ottimizzazione OGNI ORA"
136
+
137
+ #: rvg-optimize-db.php:436
138
+ msgid "run optimization TWICE A DAY"
139
+ msgstr "esegui l'ottimizzazione DUE VOLTE AL GIORNO"
140
+
141
+ #: rvg-optimize-db.php:437
142
+ msgid "run optimization DAILY"
143
+ msgstr "esegui l'ottimizzazione UNA VOLTA AL GIORNO"
144
+
145
+ #: rvg-optimize-db.php:438
146
+ msgid "run optimization WEEKLY"
147
+ msgstr "esegui l'ottimizzazione UNA VOLTA A SETTIMANA"
148
+
149
+ #: rvg-optimize-db.php:444
150
+ msgid "Time"
151
+ msgstr "Ora"
152
+
153
+ #: rvg-optimize-db.php:450
154
+ msgid "hrs"
155
+ msgstr "ore"
156
+
157
+ #: rvg-optimize-db.php:462
158
+ msgid "Show '1-click' link in Admin Bar"
159
+ msgstr "Mostra il link '1-click' nella Barra di amministrazione"
160
+
161
+ #: rvg-optimize-db.php:464 rvg-optimize-db.php:469
162
+ msgid "(change will be visible after loading the next page)"
163
+ msgstr "(la modifica sarà visibile dopo il caricamento della prossima pagina)"
164
+
165
+ #: rvg-optimize-db.php:467
166
+ msgid "Show an icon in the Admin Menu"
167
+ msgstr "Mostra un'icona nel Menu Amministratore"
168
+
169
+ #: rvg-optimize-db.php:481
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 "
173
+ "OPTIMIZED!</span>"
174
+ msgstr ""
175
+ "ESCLUDI TABELLE DALL'OTTIMIZZAZIONE: <span class=\"odb-underline-red\">LE "
176
+ "TABELLE SELEZIONATE</span><span class=\"odb-underline-red\">NON</span> "
177
+ "SARANNO OTTIMIZZATE!</span>"
178
+
179
+ #: rvg-optimize-db.php:482
180
+ msgid "check all tables"
181
+ msgstr "seleziona tutte le tabelle"
182
+
183
+ #: rvg-optimize-db.php:482
184
+ msgid "uncheck all tables"
185
+ msgstr "deseleziona tutte le tabelle"
186
+
187
+ #: rvg-optimize-db.php:482
188
+ msgid "check all NON-WordPress tables"
189
+ msgstr "seleziona tutte le tabelle NON-WordPress"
190
+
191
+ #: rvg-optimize-db.php:520
192
+ msgid "Save Settings"
193
+ msgstr "Salva le impostazioni"
194
+
195
+ #: rvg-optimize-db.php:522
196
+ msgid "Go To Optimizer"
197
+ msgstr "Vai all'ottimizzatore"
198
+
199
+ # @ default
200
+ #: rvg-optimize-db.php:548
201
+ msgctxt "timezone date format"
202
+ msgid "G:i"
203
+ msgstr "G:i"
204
+
205
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
206
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
207
+ msgid "NO"
208
+ msgstr "NO"
209
+
210
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
211
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
212
+ msgid "YES"
213
+ msgstr "SI"
214
+
215
+ #: rvg-optimize-db.php:618
216
+ msgid "ONCE HOURLY"
217
+ msgstr "UNA VOLTA L'ORA"
218
+
219
+ #: rvg-optimize-db.php:620
220
+ msgid "TWICE DAILY"
221
+ msgstr "DUE VOLTE AL GIORNO"
222
+
223
+ #: rvg-optimize-db.php:622
224
+ msgid "ONCE DAILY"
225
+ msgstr "UNA VOLTA AL GIORNO"
226
+
227
+ #: rvg-optimize-db.php:624
228
+ msgid "ONCE WEEKLY"
229
+ msgstr "UNA VOLTA A SETTIMANA"
230
+
231
+ # @ rvg-optimize-database
232
+ #: rvg-optimize-db.php:650
233
+ msgid "Optimize your WordPress Database"
234
+ msgstr "Ottimizza il tuo Database WordPress"
235
+
236
+ #: rvg-optimize-db.php:656 rvg-optimize-db.php:1736
237
+ msgid "A WordPress Plugin by"
238
+ msgstr "Un Plugin Wordpress di"
239
+
240
+ #: rvg-optimize-db.php:657
241
+ msgid "Current settings"
242
+ msgstr "Impostazioni correnti"
243
+
244
+ #: rvg-optimize-db.php:665
245
+ msgid "Number of excluded tables"
246
+ msgstr "Numero di tabelle escluse"
247
+
248
+ #: rvg-optimize-db.php:672
249
+ msgid "Next scheduled run"
250
+ msgstr "Prossima esecuzione pianficata"
251
+
252
+ #: rvg-optimize-db.php:679
253
+ msgid "Total savings since the first run"
254
+ msgstr "Risparmio totale dalla prima esecuzione"
255
+
256
+ #: rvg-optimize-db.php:684
257
+ msgid "Change Settings"
258
+ msgstr "Modifica le impostazioni"
259
+
260
+ #: rvg-optimize-db.php:690 rvg-optimize-db.php:1093
261
+ msgid "View Log File"
262
+ msgstr "Vedi il file di blog"
263
+
264
+ #: rvg-optimize-db.php:692 rvg-optimize-db.php:1095
265
+ msgid "Delete Log File"
266
+ msgstr "Cancella il log"
267
+
268
+ #: rvg-optimize-db.php:701
269
+ msgid "Start Optimization"
270
+ msgstr "Inizia l'ottimizzazione"
271
+
272
+ #: rvg-optimize-db.php:712
273
+ msgid "Starting Optimization"
274
+ msgstr "Inizio ottimizzazione"
275
+
276
+ # @ default
277
+ #: rvg-optimize-db.php:718
278
+ msgctxt "timezone date format"
279
+ msgid "m/d/YH:i:s"
280
+ msgstr "d/m/YH:i:s"
281
+
282
+ #: rvg-optimize-db.php:731
283
+ msgid "DELETING REVISIONS"
284
+ msgstr "CANCELLO LE REVISIONI"
285
+
286
+ #: rvg-optimize-db.php:735
287
+ msgid "post / page"
288
+ msgstr "articolo / pagina"
289
+
290
+ #: rvg-optimize-db.php:736
291
+ msgid "revision date"
292
+ msgstr "data di revisione"
293
+
294
+ #: rvg-optimize-db.php:737
295
+ msgid "revisions deleted"
296
+ msgstr "revisioni cancellate"
297
+
298
+ #: rvg-optimize-db.php:744
299
+ msgid "total number of revisions deleted"
300
+ msgstr "numero totale di revisioni cancellate"
301
+
302
+ #: rvg-optimize-db.php:755
303
+ msgid "No REVISIONS found to delete"
304
+ msgstr "Nessuna REVISIONE trovata da cancellare"
305
+
306
+ #: rvg-optimize-db.php:781
307
+ msgid "DELETING TRASHED ITEMS"
308
+ msgstr "CANCELLAZIONE DEL CESTINO"
309
+
310
+ #: rvg-optimize-db.php:785
311
+ msgid "type"
312
+ msgstr "tipo"
313
+
314
+ #: rvg-optimize-db.php:786
315
+ msgid "IP address / title"
316
+ msgstr "indirizzo IP / titolo"
317
+
318
+ #: rvg-optimize-db.php:787
319
+ msgid "date"
320
+ msgstr "data"
321
+
322
+ #: rvg-optimize-db.php:802
323
+ msgid "No TRASHED ITEMS found to delete"
324
+ msgstr "Nessun elemento trovato nel CESTINO"
325
+
326
+ #: rvg-optimize-db.php:830
327
+ msgid "DELETING SPAMMED ITEMS"
328
+ msgstr "CANCELLO ELEMENTI DI SPAM"
329
+
330
+ #: rvg-optimize-db.php:834
331
+ msgid "comment author"
332
+ msgstr "autore del commenti"
333
+
334
+ #: rvg-optimize-db.php:835
335
+ msgid "comment author email"
336
+ msgstr "email dell'autore del commento"
337
+
338
+ #: rvg-optimize-db.php:836
339
+ msgid "comment date"
340
+ msgstr "data del commento"
341
+
342
+ #: rvg-optimize-db.php:851
343
+ msgid "No SPAMMED ITEMS found to delete"
344
+ msgstr "Nessun elemento trovato nello SPAM"
345
+
346
+ #: rvg-optimize-db.php:878
347
+ msgid "NUMBER OF UNUSED TAGS DELETED"
348
+ msgstr "NUMERO DI TAG NON USATI CANCELLATI"
349
+
350
+ #: rvg-optimize-db.php:889
351
+ msgid "No UNUSED TAGS found to delete"
352
+ msgstr "Nessun TAG NON USATO trovato da cancellare"
353
+
354
+ #: rvg-optimize-db.php:916
355
+ msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
356
+ msgstr "NUMERO DI TRANSIENTI SCADUTI CANCELLATI"
357
+
358
+ #: rvg-optimize-db.php:927
359
+ msgid "No EXPIRED TRANSIENTS found to delete"
360
+ msgstr "Nessun TRANSIENTE SCADUTO trovato da cancellare"
361
+
362
+ #: rvg-optimize-db.php:954
363
+ msgid "NUMBER OF PINGBACKS AND TRACKBACKS DELETED"
364
+ msgstr "NUMERO DI PINGBACKS e TRACKBACKS CANCELLATI"
365
+
366
+ #: rvg-optimize-db.php:965
367
+ msgid "No PINGBACKS nor TRACKBACKS found to delete"
368
+ msgstr "Nessun PINGBACK o TRACKBACK da cancellare"
369
+
370
+ #: rvg-optimize-db.php:989
371
+ msgid "NUMBER OF POSTMETA ORPHANS DELETED"
372
+ msgstr "NUMERO DI POSTMETA ORFANI CANCELLATI"
373
+
374
+ #: rvg-optimize-db.php:1000
375
+ msgid "No POSTMETA ORPHANS found to delete"
376
+ msgstr "Nessun POSTMETA ORFANO trovato da cancellare"
377
+
378
+ #: rvg-optimize-db.php:1018
379
+ msgid "OPTIMIZING DATABASE TABLES"
380
+ msgstr "OTTIMIZZAZIONE TABELLE DATABASE"
381
+
382
+ #: rvg-optimize-db.php:1022
383
+ msgid "table name"
384
+ msgstr "nome tabella"
385
+
386
+ #: rvg-optimize-db.php:1023
387
+ msgid "optimization result"
388
+ msgstr "risultato ottimizzazione"
389
+
390
+ #: rvg-optimize-db.php:1024
391
+ msgid "engine"
392
+ msgstr "motore"
393
+
394
+ #: rvg-optimize-db.php:1025
395
+ msgid "table rows"
396
+ msgstr "righe tabella"
397
+
398
+ #: rvg-optimize-db.php:1026
399
+ msgid "table size"
400
+ msgstr "dimensione tabella"
401
+
402
+ #: rvg-optimize-db.php:1051 rvg-optimize-db.php:1751
403
+ msgid "SAVINGS"
404
+ msgstr "RISPARMI"
405
+
406
+ #: rvg-optimize-db.php:1055
407
+ msgid "size of the database"
408
+ msgstr "dimensione del database"
409
+
410
+ #: rvg-optimize-db.php:1058
411
+ msgid "BEFORE optimization"
412
+ msgstr "PRIMA dell'ottimizzazione"
413
+
414
+ #: rvg-optimize-db.php:1062
415
+ msgid "AFTER optimization"
416
+ msgstr "DOPO l'ottimizzazione"
417
+
418
+ #: rvg-optimize-db.php:1066
419
+ msgid "SAVINGS THIS TIME"
420
+ msgstr "RISPARMI DI QUESTA ESECUZIONE"
421
+
422
+ #: rvg-optimize-db.php:1070
423
+ msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
424
+ msgstr "RISPARMI TOTALI DALLA PRIMA ESECUZIONE"
425
+
426
+ #: rvg-optimize-db.php:1083
427
+ msgid "DONE"
428
+ msgstr "ESEGUITO"
429
+
430
+ # Optimization took xxx seconds
431
+ #: rvg-optimize-db.php:1085
432
+ msgid "Optimization took"
433
+ msgstr "L'ottimizzazione ha impiegato"
434
+
435
+ # Optimization took xxx seconds
436
+ #: rvg-optimize-db.php:1085
437
+ msgid "seconds"
438
+ msgstr "secondi"
439
+
440
+ #: rvg-optimize-db.php:1654
441
+ msgid "InnoDB table: skipped..."
442
+ msgstr "Tabella InnoDB: saltata"
443
+
444
+ #: rvg-optimize-db.php:1660
445
+ msgid "TABLE OPTIMIZED"
446
+ msgstr "TABELLA OTTIMIZZATA"
447
+
448
+ #: rvg-optimize-db.php:1661
449
+ msgid "Table is already up to date"
450
+ msgstr "La tabella è già aggiornata"
451
+
452
+ #: rvg-optimize-db.php:1740
453
+ msgid "time"
454
+ msgstr "tempo"
455
+
456
+ #: rvg-optimize-db.php:1741
457
+ msgid "deleted<br />revisions"
458
+ msgstr "revisioni<br />cancellate"
459
+
460
+ #: rvg-optimize-db.php:1742
461
+ msgid "deleted<br />trash"
462
+ msgstr "cestino<br/>cancellato"
463
+
464
+ #: rvg-optimize-db.php:1743
465
+ msgid "deleted<br />spam"
466
+ msgstr "spam<br />cancellato"
467
+
468
+ #: rvg-optimize-db.php:1744
469
+ msgid "deleted<br />tags"
470
+ msgstr "tags<br />cancellati"
471
+
472
+ #: rvg-optimize-db.php:1745
473
+ msgid "deleted<br />transients"
474
+ msgstr "transienti<br />cancellati"
475
+
476
+ #: rvg-optimize-db.php:1746
477
+ msgid "deleted<br />pingbacks<br />trackbacks"
478
+ msgstr "pingback<br />trackbacks<br />cancellati"
479
+
480
+ #: rvg-optimize-db.php:1747
481
+ msgid "deleted<br />orphans"
482
+ msgstr "orfani<br />cancellati"
483
+
484
+ # @ rvg-optimize-database
485
+ #: rvg-optimize-db.php:1748
486
+ msgid "nr of optimized tables"
487
+ msgstr "numero di tabelle ottimizzate"
488
+
489
+ #: rvg-optimize-db.php:1749
490
+ msgid "database size BEFORE"
491
+ msgstr "dimensione del database PRIMA"
492
+
493
+ #: rvg-optimize-db.php:1750
494
+ msgid "database size AFTER"
495
+ msgstr "dimensione del database DOPO"
496
+
497
+ # @ default
498
+ #~ msgid "Optimize DB Options"
499
+ #~ msgstr "Opzioni di ottimizzazione del DB"
500
+
501
+ #~ msgid "Optimize Database after Deleting Revisions OPTIONS UPDATED"
502
+ #~ msgstr "Optimize Database after Deleting Revisions OPZIONI AGGIORNATE"
503
+
504
+ #~ msgid ""
505
+ #~ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
506
+ #~ "bold\">HERE</a> to run the optimization"
507
+ #~ msgstr ""
508
+ #~ "Clicca <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
509
+ #~ "bold\">QUI</a> per iniziare l'ottimizzazione"
510
+
511
+ #~ msgid "To start the optimization:"
512
+ #~ msgstr "Per iniziare l'ottimizzazione:"
513
+
514
+ #~ msgid ""
515
+ #~ "<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; "
516
+ #~ "<strong>Optimize Database</strong>. Then click the '<strong>Start "
517
+ #~ "Optimization</strong>'-button. Et voila!"
518
+ #~ msgstr ""
519
+ #~ "<strong>Pannello amministrazione WP</strong> &raquo; <strong>Strumenti</"
520
+ #~ "strong> &raquo; <strong>Ottimizza il database</strong>. Poi clicca il "
521
+ #~ "bottone '<strong>Inizia ottimizzazione</strong>'. Et voila!"
522
+
523
+ #~ msgid ""
524
+ #~ "Note: if you use the Scheduler the Optimization will run automatically!"
525
+ #~ msgstr ""
526
+ #~ "Nota: se usi la Pianificazione, l'ottimizzazione verrà eseguita "
527
+ #~ "automaticamente!"
528
+
529
+ #~ msgid "Optimize Database after Deleting Revisions - Options"
530
+ #~ msgstr "Ottimizza il database dopo l'eliminazione delle revisioni - Opzioni"
531
+
532
+ #~ msgid ""
533
+ #~ "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style=\"text-decoration:"
534
+ #~ "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-"
535
+ #~ "decoration:underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
536
+ #~ msgstr ""
537
+ #~ "ESCLUDI TABELLE DALL'OTTIMIZZAZIONE: <span style=\"text-decoration:"
538
+ #~ "underline;color:#F00;\">LE TABELLE SELEZIONATE</span><span style=\"text-"
539
+ #~ "decoration:underline;color:#F00;\">NON</span> SARANNO OTTIMIZZATE!</span>"
540
+
541
+ #~ msgid "Save Options"
542
+ #~ msgstr "Salva le opzioni"
543
+
544
+ #~ msgid "Current options"
545
+ #~ msgstr "Attuali opzioni"
546
+
547
+ #~ msgid "Change Options"
548
+ #~ msgstr "Modifica le opzioni"
549
+
550
+ # @ rvg-optimize-database
551
+ #~ msgid "Hello world!"
552
+ #~ msgstr "CIAO!"
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: 2014-09-22 23:49+0100\n"
6
- "PO-Revision-Date: 2014-09-23 00:00+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"
@@ -11,7 +11,7 @@ msgstr ""
11
  "Content-Type: text/plain; charset=UTF-8\n"
12
  "Content-Transfer-Encoding: 8bit\n"
13
  "Plural-Forms: nplurals=2; plural=n != 1;\n"
14
- "X-Generator: Poedit 1.6.9\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"
@@ -21,462 +21,535 @@ msgstr ""
21
  "X-Poedit-SearchPath-0: .\n"
22
 
23
  # @ rvg-optimize-database
24
- #: rvg-optimize-db.php:37
 
 
25
  msgid "Optimize Database"
26
  msgstr "Optimaliseer Database"
27
 
28
- # @ default
29
- #: rvg-optimize-db.php:51
30
- msgid "Optimize DB Options"
31
- msgstr "Optimaliseer DB Opties"
32
-
33
  # @ optimize_db
34
- #: rvg-optimize-db.php:66
35
  msgid "Optimize DB (1 click)"
36
  msgstr "Optimaliseer DB (1 klik)"
37
 
38
  # @ default
39
- #: rvg-optimize-db.php:83
40
  msgid "Once Weekly"
41
  msgstr "Eenmaal per week"
42
 
43
  # @ default
44
- #: rvg-optimize-db.php:119
45
  msgctxt "timezone date format"
46
  msgid "YmdGis"
47
  msgstr ""
48
 
49
- #: rvg-optimize-db.php:224
50
- msgid "Optimize Database after Deleting Revisions OPTIONS UPDATED"
51
- msgstr "Optimize Database after Deleting Revisions OPTIES OPGESLAGEN"
52
 
53
- #: rvg-optimize-db.php:226
54
  msgid ""
55
- "Click <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:bold"
56
  "\">HERE</a> to run the optimization"
57
  msgstr ""
58
- "Klik <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:bold"
59
- "\">HIER</a> om de optimalisatie te starten"
60
 
61
- #: rvg-optimize-db.php:270
62
  msgid "Using Optimize Database after Deleting Revisions"
63
  msgstr "Het gebruik van Optimize Database after Deleting Revisions"
64
 
65
- #: rvg-optimize-db.php:272
66
  msgid "is an one-click plugin to clean and optimize your WordPress database"
67
  msgstr ""
68
  "is een één-klik plugin om de WordPress database op te schonen en te "
69
  "optimaliseren"
70
 
71
- #: rvg-optimize-db.php:273
72
- msgid "To start the optimization:"
73
- msgstr "Om de optimalisatie te starten:"
74
-
75
- #: rvg-optimize-db.php:274
76
- msgid ""
77
- "<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; "
78
- "<strong>Optimize Database</strong>. Then click the '<strong>Start "
79
- "Optimization</strong>'-button. Et voila!"
80
- msgstr ""
81
- "<strong>WP Admin Panel</strong> &raquo; <strong>Extra</strong> &raquo; "
82
- "<strong>Optimaliseren Database</strong>. Klik dan de '<strong>Start "
83
- "Optimalisatie</strong>'-knop. Et voila!"
84
-
85
- #: rvg-optimize-db.php:275
86
- msgid "Note: if you use the Scheduler the Optimization will run automatically!"
87
- msgstr ""
88
- "Opmerking: als u gebruik maakt van de Planner zal de optimalisatie "
89
- "automatisch worden uitgevoerd"
90
-
91
- #: rvg-optimize-db.php:276
92
  msgid "Plugin version:"
93
  msgstr "Plugin versie:"
94
 
95
- #: rvg-optimize-db.php:278
96
  msgid "Author"
97
  msgstr "Auteur"
98
 
99
- #: rvg-optimize-db.php:279 rvg-optimize-db.php:529 rvg-optimize-db.php:1458
100
  msgid "The Netherlands"
101
  msgstr "Nederland"
102
 
103
- #: rvg-optimize-db.php:280
104
  msgid "Plugin URL:"
105
  msgstr "Plugin URL:"
106
 
107
- #: rvg-optimize-db.php:282
108
  msgid "Download URL:"
109
  msgstr "Download URL:"
110
 
111
- #: rvg-optimize-db.php:286
112
- msgid "Optimize Database after Deleting Revisions - Options"
113
- msgstr "Optimize Database after Deleting Revisions - Opties"
114
 
115
- #: rvg-optimize-db.php:301 rvg-optimize-db.php:531
116
  msgid "Maximum number of - most recent - revisions to keep per post / page"
117
  msgstr ""
118
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
119
  "pagina"
120
 
121
- #: rvg-optimize-db.php:302
122
  msgid "('0' means: delete <u>ALL</u> revisions)"
123
  msgstr "('0' betekent: verwijder <u>ALLE</u> revisies)"
124
 
125
- #: rvg-optimize-db.php:306 rvg-optimize-db.php:532
126
  msgid "Delete all trashed items"
127
  msgstr "Maak de prullenbak leeg"
128
 
129
- #: rvg-optimize-db.php:310 rvg-optimize-db.php:533
130
  msgid "Delete all spammed items"
131
  msgstr "Verwijder alle spam reacties"
132
 
133
- #: rvg-optimize-db.php:314 rvg-optimize-db.php:534
134
  msgid "Delete unused tags"
135
  msgstr "Verwijder ongebruikte tags"
136
 
137
- #: rvg-optimize-db.php:318 rvg-optimize-db.php:535
138
  msgid "Delete expired transients"
139
  msgstr "Verwijder verlopen transiënts"
140
 
141
- #: rvg-optimize-db.php:322 rvg-optimize-db.php:536
 
 
 
 
142
  msgid "Keep a log"
143
  msgstr "Gebruik een logbestand"
144
 
145
- #: rvg-optimize-db.php:326 rvg-optimize-db.php:538
146
  msgid "Scheduler"
147
  msgstr "Planner"
148
 
149
- #: rvg-optimize-db.php:328 rvg-optimize-db.php:503
150
  msgid "NOT SCHEDULED"
151
  msgstr "NIET GEPLAND"
152
 
153
- #: rvg-optimize-db.php:329
154
  msgid "run optimization HOURLY"
155
  msgstr "voer de optimalisatie ELK UUR uit"
156
 
157
- #: rvg-optimize-db.php:330
158
  msgid "run optimization TWICE A DAY"
159
  msgstr "voer de optimalisatie TWEE KEER PER DAG uit"
160
 
161
- #: rvg-optimize-db.php:331
162
  msgid "run optimization DAILY"
163
  msgstr "voer de optimalisatie DAGELIJKS uit"
164
 
165
- #: rvg-optimize-db.php:332
166
  msgid "run optimization WEEKLY"
167
  msgstr "voer de optimalisatie WEKELIJKS uit"
168
 
169
- #: rvg-optimize-db.php:338
170
  msgid "Time"
171
  msgstr "Tijd"
172
 
173
- #: rvg-optimize-db.php:344
174
  msgid "hrs"
175
  msgstr "uur"
176
 
177
- #: rvg-optimize-db.php:356
178
  msgid "Show '1-click' link in Admin Bar"
179
  msgstr "Toon de '1-klik' link in de Admin Balk"
180
 
181
- #: rvg-optimize-db.php:358
182
  msgid "(change will be visible after loading the next page)"
183
  msgstr "(wijziging wordt zichtbaar na het laden van de volgende pagina)"
184
 
185
- #: rvg-optimize-db.php:370
 
 
 
 
186
  msgid ""
187
- "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style=\"text-decoration:"
188
- "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-decoration:"
189
- "underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
190
  msgstr ""
191
- "SLUIT DE VOLGENDE TABELLEN UIT VAN OPTIMALISATIE: <span style=\"text-"
192
- "decoration:underline;color:#F00;\">AANGEVINKTE</span> TABELLEN WORDEN <span "
193
- "style=\"text-decoration:underline;color:#F00;\">NIET</span> GEOPTIMALISEERD!"
194
- "</span>"
195
 
196
- #: rvg-optimize-db.php:371
197
  msgid "check all tables"
198
  msgstr "vink alle tabellen aan"
199
 
200
- #: rvg-optimize-db.php:371
201
  msgid "uncheck all tables"
202
  msgstr "vink alle tabellen uit"
203
 
204
- #: rvg-optimize-db.php:371
205
  msgid "check all NON-WordPress tables"
206
  msgstr "vink alle NIET-WordPress tabellen aan"
207
 
208
- #: rvg-optimize-db.php:409
209
- msgid "Save Options"
210
- msgstr "Bewaar Opties"
211
 
212
- #: rvg-optimize-db.php:411
213
  msgid "Go To Optimizer"
214
  msgstr "Ga naar Optimalisatie"
215
 
216
  # @ default
217
- #: rvg-optimize-db.php:429
218
  msgctxt "timezone date format"
219
  msgid "G:i"
220
  msgstr ""
221
 
222
- #: rvg-optimize-db.php:454 rvg-optimize-db.php:461 rvg-optimize-db.php:468
223
- #: rvg-optimize-db.php:475 rvg-optimize-db.php:482
224
  msgid "NO"
225
  msgstr "NEE"
226
 
227
- #: rvg-optimize-db.php:454 rvg-optimize-db.php:461 rvg-optimize-db.php:468
228
- #: rvg-optimize-db.php:475 rvg-optimize-db.php:482
229
  msgid "YES"
230
  msgstr "JA"
231
 
232
- #: rvg-optimize-db.php:491
233
  msgid "ONCE HOURLY"
234
  msgstr "ELK UUR"
235
 
236
- #: rvg-optimize-db.php:493
237
  msgid "TWICE DAILY"
238
  msgstr "TWEEMAAL DAAGS"
239
 
240
- #: rvg-optimize-db.php:495
241
  msgid "ONCE DAILY"
242
  msgstr "DAGELIJKS"
243
 
244
- #: rvg-optimize-db.php:497
245
  msgid "ONCE WEEKLY"
246
  msgstr "WEKELIJKS"
247
 
248
  # @ rvg-optimize-database
249
- #: rvg-optimize-db.php:523
250
  msgid "Optimize your WordPress Database"
251
  msgstr "Optimaliseer uw WordPress Database"
252
 
253
- #: rvg-optimize-db.php:529 rvg-optimize-db.php:1458
254
  msgid "A WordPress Plugin by"
255
  msgstr "Een WordPress Plugin door"
256
 
257
- #: rvg-optimize-db.php:530
258
- msgid "Current options"
259
- msgstr "Huidige opties"
260
 
261
- #: rvg-optimize-db.php:537
262
  msgid "Number of excluded tables"
263
  msgstr "Aantal uitgesloten tabellen"
264
 
265
- #: rvg-optimize-db.php:544
266
  msgid "Next scheduled run"
267
  msgstr "Volgende geplande uitvoering"
268
 
269
- #: rvg-optimize-db.php:551
270
  msgid "Total savings since the first run"
271
  msgstr "Totale besparing sinds de eerste uitvoering"
272
 
273
- #: rvg-optimize-db.php:556
274
- msgid "Change Options"
275
- msgstr "Wijzig Opties"
276
 
277
- #: rvg-optimize-db.php:562 rvg-optimize-db.php:917
278
  msgid "View Log File"
279
  msgstr "Bekijk Logbestand"
280
 
281
- #: rvg-optimize-db.php:564 rvg-optimize-db.php:919
282
  msgid "Delete Log File"
283
  msgstr "Verwijder Logbestand"
284
 
285
- #: rvg-optimize-db.php:573
286
  msgid "Start Optimization"
287
  msgstr "Start Optimalisatie"
288
 
289
- #: rvg-optimize-db.php:584
290
  msgid "Starting Optimization"
291
  msgstr "Aan het optimaliseren"
292
 
293
  # @ default
294
- #: rvg-optimize-db.php:590
295
  msgctxt "timezone date format"
296
  msgid "m/d/YH:i:s"
297
  msgstr ""
298
 
299
- #: rvg-optimize-db.php:603
300
  msgid "DELETING REVISIONS"
301
  msgstr "REVISIES AAN HET VERWIJDEREN"
302
 
303
- #: rvg-optimize-db.php:607
304
  msgid "post / page"
305
  msgstr "bericht / pagina"
306
 
307
- #: rvg-optimize-db.php:608
308
  msgid "revision date"
309
  msgstr "revisiedatum"
310
 
311
- #: rvg-optimize-db.php:609
312
  msgid "revisions deleted"
313
  msgstr "revisies verwijderd"
314
 
315
- #: rvg-optimize-db.php:616
316
  msgid "total number of revisions deleted"
317
  msgstr "totaal aantal verwijderde revisies"
318
 
319
- #: rvg-optimize-db.php:627
320
  msgid "No REVISIONS found to delete"
321
  msgstr "Geen REVISIES gevonden om te verwijderen"
322
 
323
- #: rvg-optimize-db.php:653
324
  msgid "DELETING TRASHED ITEMS"
325
  msgstr "PRULLENBAK AAN HET LEEGMAKEN"
326
 
327
- #: rvg-optimize-db.php:657
328
  msgid "type"
329
  msgstr "type"
330
 
331
- #: rvg-optimize-db.php:658
332
  msgid "IP address / title"
333
  msgstr "IP adres / titel"
334
 
335
- #: rvg-optimize-db.php:659
336
  msgid "date"
337
  msgstr "datum"
338
 
339
- #: rvg-optimize-db.php:674
340
  msgid "No TRASHED ITEMS found to delete"
341
  msgstr "Geen PRULLENBAK ITEMS gevonden om te verwijderen"
342
 
343
- #: rvg-optimize-db.php:702
344
  msgid "DELETING SPAMMED ITEMS"
345
  msgstr "SPAM ITEMS AAN HET VERWIJDEREN"
346
 
347
- #: rvg-optimize-db.php:706
348
  msgid "comment author"
349
  msgstr "plaatser van de reactie"
350
 
351
- #: rvg-optimize-db.php:707
352
  msgid "comment author email"
353
  msgstr "email van de plaatser van de reactie"
354
 
355
- #: rvg-optimize-db.php:708
356
  msgid "comment date"
357
  msgstr "datum van de reactie"
358
 
359
- #: rvg-optimize-db.php:723
360
  msgid "No SPAMMED ITEMS found to delete"
361
  msgstr "Geen SPAM gevonden om te verwijderen"
362
 
363
- #: rvg-optimize-db.php:750
364
  msgid "NUMBER OF UNUSED TAGS DELETED"
365
  msgstr "AANTAL VERWIJDERDE ONGEBRUIKTE TAGS"
366
 
367
- #: rvg-optimize-db.php:761
368
  msgid "No UNUSED TAGS found to delete"
369
  msgstr "Geen ONGEBRUIKTE TAGS gevonden om te verwijderen"
370
 
371
- #: rvg-optimize-db.php:788
372
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
373
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
374
 
375
- #: rvg-optimize-db.php:799
376
  msgid "No EXPIRED TRANSIENTS found to delete"
377
  msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
378
 
379
- #: rvg-optimize-db.php:822
 
 
 
 
 
 
 
 
380
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
381
  msgstr "AANTAL VERWIJDERDE POSTMETA WEZEN"
382
 
383
- #: rvg-optimize-db.php:833
384
  msgid "No POSTMETA ORPHANS found to delete"
385
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
386
 
387
- #: rvg-optimize-db.php:850
388
  msgid "OPTIMIZING DATABASE TABLES"
389
  msgstr "DATABASETABELLEN AAN HET OPTIMALISEREN"
390
 
391
- #: rvg-optimize-db.php:854
392
  msgid "table name"
393
  msgstr "tabelnaam"
394
 
395
- #: rvg-optimize-db.php:855
396
  msgid "optimization result"
397
  msgstr "resultaat optimalisatie"
398
 
399
- #: rvg-optimize-db.php:856
400
  msgid "engine"
401
  msgstr "engine"
402
 
403
- #: rvg-optimize-db.php:857
404
  msgid "table rows"
405
  msgstr "tabelrijen"
406
 
407
- #: rvg-optimize-db.php:858
408
  msgid "table size"
409
  msgstr "tabelgrootte"
410
 
411
- #: rvg-optimize-db.php:885 rvg-optimize-db.php:1472
412
  msgid "SAVINGS"
413
  msgstr "BESPARINGEN"
414
 
415
- #: rvg-optimize-db.php:889
416
  msgid "size of the database"
417
  msgstr "grootte van de database"
418
 
419
- #: rvg-optimize-db.php:892
420
  msgid "BEFORE optimization"
421
  msgstr "VOOR de optimalisatie"
422
 
423
- #: rvg-optimize-db.php:896
424
  msgid "AFTER optimization"
425
  msgstr "NA de optimalisatie"
426
 
427
- #: rvg-optimize-db.php:900
428
  msgid "SAVINGS THIS TIME"
429
  msgstr "DIT KEER BESPAARD"
430
 
431
- #: rvg-optimize-db.php:904
432
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
433
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
434
 
435
- #: rvg-optimize-db.php:910
436
  msgid "DONE"
437
  msgstr "KLAAR"
438
 
439
- #: rvg-optimize-db.php:1462
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
440
  msgid "time"
441
  msgstr "tijd"
442
 
443
- #: rvg-optimize-db.php:1463
444
  msgid "deleted<br />revisions"
445
  msgstr "verw.<br />revisies"
446
 
447
- #: rvg-optimize-db.php:1464
448
  msgid "deleted<br />trash"
449
  msgstr "verw.<br />prullenbak items"
450
 
451
- #: rvg-optimize-db.php:1465
452
  msgid "deleted<br />spam"
453
  msgstr "verw.<br />spamitems"
454
 
455
- #: rvg-optimize-db.php:1466
456
  msgid "deleted<br />tags"
457
  msgstr "verw.<br /> tags"
458
 
459
- #: rvg-optimize-db.php:1467
460
  msgid "deleted<br />transients"
461
  msgstr "verw.<br />transiënts"
462
 
463
- #: rvg-optimize-db.php:1468
 
 
 
 
464
  msgid "deleted<br />orphans"
465
  msgstr "verw.<br />wezen"
466
 
467
  # @ rvg-optimize-database
468
- #: rvg-optimize-db.php:1469
469
  msgid "nr of optimized tables"
470
  msgstr "aantal geoptima-<br />liseerde tabellen"
471
 
472
- #: rvg-optimize-db.php:1470
473
  msgid "database size BEFORE"
474
  msgstr "database<br />grootte<br />VOOR"
475
 
476
- #: rvg-optimize-db.php:1471
477
  msgid "database size AFTER"
478
  msgstr "database<br />grootte<br />NA"
479
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
480
  # @ rvg-optimize-database
481
  #~ msgid "Hello world!"
482
  #~ msgstr "HALLO WERELD!"
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-03-01 14:55+0100\n"
6
+ "PO-Revision-Date: 2015-03-01 14:56+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"
11
  "Content-Type: text/plain; charset=UTF-8\n"
12
  "Content-Transfer-Encoding: 8bit\n"
13
  "Plural-Forms: nplurals=2; plural=n != 1;\n"
14
+ "X-Generator: Poedit 1.7.4\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"
21
  "X-Poedit-SearchPath-0: .\n"
22
 
23
  # @ rvg-optimize-database
24
+ #: rvg-optimize-db.php:39 rvg-optimize-db.php:40 rvg-optimize-db.php:59
25
+ #: rvg-optimize-db.php:60 rvg-optimize-db.php:80 rvg-optimize-db.php:81
26
+ #: rvg-optimize-db.php:100 rvg-optimize-db.php:101
27
  msgid "Optimize Database"
28
  msgstr "Optimaliseer Database"
29
 
 
 
 
 
 
30
  # @ optimize_db
31
+ #: rvg-optimize-db.php:136
32
  msgid "Optimize DB (1 click)"
33
  msgstr "Optimaliseer DB (1 klik)"
34
 
35
  # @ default
36
+ #: rvg-optimize-db.php:165
37
  msgid "Once Weekly"
38
  msgstr "Eenmaal per week"
39
 
40
  # @ default
41
+ #: rvg-optimize-db.php:201
42
  msgctxt "timezone date format"
43
  msgid "YmdGis"
44
  msgstr ""
45
 
46
+ #: rvg-optimize-db.php:318
47
+ msgid "Optimize Database after Deleting Revisions SETTINGS UPDATED"
48
+ msgstr "Optimize Database after Deleting Revisions INSTELLINGEN AANGEPAST"
49
 
50
+ #: rvg-optimize-db.php:320
51
  msgid ""
52
+ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
53
  "\">HERE</a> to run the optimization"
54
  msgstr ""
55
+ "Klik <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold\">HIER</"
56
+ "a. om de optimalisatie te starten"
57
 
58
+ #: rvg-optimize-db.php:372
59
  msgid "Using Optimize Database after Deleting Revisions"
60
  msgstr "Het gebruik van Optimize Database after Deleting Revisions"
61
 
62
+ #: rvg-optimize-db.php:374
63
  msgid "is an one-click plugin to clean and optimize your WordPress database"
64
  msgstr ""
65
  "is een één-klik plugin om de WordPress database op te schonen en te "
66
  "optimaliseren"
67
 
68
+ #: rvg-optimize-db.php:375
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
69
  msgid "Plugin version:"
70
  msgstr "Plugin versie:"
71
 
72
+ #: rvg-optimize-db.php:377
73
  msgid "Author"
74
  msgstr "Auteur"
75
 
76
+ #: rvg-optimize-db.php:378 rvg-optimize-db.php:656 rvg-optimize-db.php:1736
77
  msgid "The Netherlands"
78
  msgstr "Nederland"
79
 
80
+ #: rvg-optimize-db.php:379
81
  msgid "Plugin URL:"
82
  msgstr "Plugin URL:"
83
 
84
+ #: rvg-optimize-db.php:381
85
  msgid "Download URL:"
86
  msgstr "Download URL:"
87
 
88
+ #: rvg-optimize-db.php:385
89
+ msgid "Optimize Database after Deleting Revisions - Settings"
90
+ msgstr "Optimize Database after Deleting Revisions - Instellingen"
91
 
92
+ #: rvg-optimize-db.php:403 rvg-optimize-db.php:658
93
  msgid "Maximum number of - most recent - revisions to keep per post / page"
94
  msgstr ""
95
  "Maximaal aantal (meest recente) revisies die bewaard worden per bericht / "
96
  "pagina"
97
 
98
+ #: rvg-optimize-db.php:404
99
  msgid "('0' means: delete <u>ALL</u> revisions)"
100
  msgstr "('0' betekent: verwijder <u>ALLE</u> revisies)"
101
 
102
+ #: rvg-optimize-db.php:408 rvg-optimize-db.php:659
103
  msgid "Delete all trashed items"
104
  msgstr "Maak de prullenbak leeg"
105
 
106
+ #: rvg-optimize-db.php:412 rvg-optimize-db.php:660
107
  msgid "Delete all spammed items"
108
  msgstr "Verwijder alle spam reacties"
109
 
110
+ #: rvg-optimize-db.php:416 rvg-optimize-db.php:661
111
  msgid "Delete unused tags"
112
  msgstr "Verwijder ongebruikte tags"
113
 
114
+ #: rvg-optimize-db.php:420 rvg-optimize-db.php:662
115
  msgid "Delete expired transients"
116
  msgstr "Verwijder verlopen transiënts"
117
 
118
+ #: rvg-optimize-db.php:424 rvg-optimize-db.php:663
119
+ msgid "Delete pingbacks and trackbacks"
120
+ msgstr "Verwijder pingback en trackbacks"
121
+
122
+ #: rvg-optimize-db.php:428 rvg-optimize-db.php:664
123
  msgid "Keep a log"
124
  msgstr "Gebruik een logbestand"
125
 
126
+ #: rvg-optimize-db.php:432 rvg-optimize-db.php:666
127
  msgid "Scheduler"
128
  msgstr "Planner"
129
 
130
+ #: rvg-optimize-db.php:434 rvg-optimize-db.php:630
131
  msgid "NOT SCHEDULED"
132
  msgstr "NIET GEPLAND"
133
 
134
+ #: rvg-optimize-db.php:435
135
  msgid "run optimization HOURLY"
136
  msgstr "voer de optimalisatie ELK UUR uit"
137
 
138
+ #: rvg-optimize-db.php:436
139
  msgid "run optimization TWICE A DAY"
140
  msgstr "voer de optimalisatie TWEE KEER PER DAG uit"
141
 
142
+ #: rvg-optimize-db.php:437
143
  msgid "run optimization DAILY"
144
  msgstr "voer de optimalisatie DAGELIJKS uit"
145
 
146
+ #: rvg-optimize-db.php:438
147
  msgid "run optimization WEEKLY"
148
  msgstr "voer de optimalisatie WEKELIJKS uit"
149
 
150
+ #: rvg-optimize-db.php:444
151
  msgid "Time"
152
  msgstr "Tijd"
153
 
154
+ #: rvg-optimize-db.php:450
155
  msgid "hrs"
156
  msgstr "uur"
157
 
158
+ #: rvg-optimize-db.php:462
159
  msgid "Show '1-click' link in Admin Bar"
160
  msgstr "Toon de '1-klik' link in de Admin Balk"
161
 
162
+ #: rvg-optimize-db.php:464 rvg-optimize-db.php:469
163
  msgid "(change will be visible after loading the next page)"
164
  msgstr "(wijziging wordt zichtbaar na het laden van de volgende pagina)"
165
 
166
+ #: rvg-optimize-db.php:467
167
+ msgid "Show an icon in the Admin Menu"
168
+ msgstr "Toon een icon in het Admin Menu"
169
+
170
+ #: rvg-optimize-db.php:481
171
  msgid ""
172
+ "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class=\"odb-underline-red"
173
+ "\">CHECKED</span> TABLES <span class=\"odb-underline-red\">WON'T</span> BE "
174
+ "OPTIMIZED!</span>"
175
  msgstr ""
176
+ "SLUIT DE VOLGENDE TABELLEN UIT VAN OPTIMILIZATIE: <span class=\"odb-"
177
+ "underline-red\">AANGEVINKTE</span> TABELLEN ZULLEN <span class=\"odb-"
178
+ "underline-red\">NIET</span> GEOPTIMALISEERD WORDEN!</span>"
 
179
 
180
+ #: rvg-optimize-db.php:482
181
  msgid "check all tables"
182
  msgstr "vink alle tabellen aan"
183
 
184
+ #: rvg-optimize-db.php:482
185
  msgid "uncheck all tables"
186
  msgstr "vink alle tabellen uit"
187
 
188
+ #: rvg-optimize-db.php:482
189
  msgid "check all NON-WordPress tables"
190
  msgstr "vink alle NIET-WordPress tabellen aan"
191
 
192
+ #: rvg-optimize-db.php:520
193
+ msgid "Save Settings"
194
+ msgstr "Bewaar instellingen"
195
 
196
+ #: rvg-optimize-db.php:522
197
  msgid "Go To Optimizer"
198
  msgstr "Ga naar Optimalisatie"
199
 
200
  # @ default
201
+ #: rvg-optimize-db.php:548
202
  msgctxt "timezone date format"
203
  msgid "G:i"
204
  msgstr ""
205
 
206
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
207
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
208
  msgid "NO"
209
  msgstr "NEE"
210
 
211
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
212
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
213
  msgid "YES"
214
  msgstr "JA"
215
 
216
+ #: rvg-optimize-db.php:618
217
  msgid "ONCE HOURLY"
218
  msgstr "ELK UUR"
219
 
220
+ #: rvg-optimize-db.php:620
221
  msgid "TWICE DAILY"
222
  msgstr "TWEEMAAL DAAGS"
223
 
224
+ #: rvg-optimize-db.php:622
225
  msgid "ONCE DAILY"
226
  msgstr "DAGELIJKS"
227
 
228
+ #: rvg-optimize-db.php:624
229
  msgid "ONCE WEEKLY"
230
  msgstr "WEKELIJKS"
231
 
232
  # @ rvg-optimize-database
233
+ #: rvg-optimize-db.php:650
234
  msgid "Optimize your WordPress Database"
235
  msgstr "Optimaliseer uw WordPress Database"
236
 
237
+ #: rvg-optimize-db.php:656 rvg-optimize-db.php:1736
238
  msgid "A WordPress Plugin by"
239
  msgstr "Een WordPress Plugin door"
240
 
241
+ #: rvg-optimize-db.php:657
242
+ msgid "Current settings"
243
+ msgstr "Huidige instellingen"
244
 
245
+ #: rvg-optimize-db.php:665
246
  msgid "Number of excluded tables"
247
  msgstr "Aantal uitgesloten tabellen"
248
 
249
+ #: rvg-optimize-db.php:672
250
  msgid "Next scheduled run"
251
  msgstr "Volgende geplande uitvoering"
252
 
253
+ #: rvg-optimize-db.php:679
254
  msgid "Total savings since the first run"
255
  msgstr "Totale besparing sinds de eerste uitvoering"
256
 
257
+ #: rvg-optimize-db.php:684
258
+ msgid "Change Settings"
259
+ msgstr "Wijzig instellingen"
260
 
261
+ #: rvg-optimize-db.php:690 rvg-optimize-db.php:1093
262
  msgid "View Log File"
263
  msgstr "Bekijk Logbestand"
264
 
265
+ #: rvg-optimize-db.php:692 rvg-optimize-db.php:1095
266
  msgid "Delete Log File"
267
  msgstr "Verwijder Logbestand"
268
 
269
+ #: rvg-optimize-db.php:701
270
  msgid "Start Optimization"
271
  msgstr "Start Optimalisatie"
272
 
273
+ #: rvg-optimize-db.php:712
274
  msgid "Starting Optimization"
275
  msgstr "Aan het optimaliseren"
276
 
277
  # @ default
278
+ #: rvg-optimize-db.php:718
279
  msgctxt "timezone date format"
280
  msgid "m/d/YH:i:s"
281
  msgstr ""
282
 
283
+ #: rvg-optimize-db.php:731
284
  msgid "DELETING REVISIONS"
285
  msgstr "REVISIES AAN HET VERWIJDEREN"
286
 
287
+ #: rvg-optimize-db.php:735
288
  msgid "post / page"
289
  msgstr "bericht / pagina"
290
 
291
+ #: rvg-optimize-db.php:736
292
  msgid "revision date"
293
  msgstr "revisiedatum"
294
 
295
+ #: rvg-optimize-db.php:737
296
  msgid "revisions deleted"
297
  msgstr "revisies verwijderd"
298
 
299
+ #: rvg-optimize-db.php:744
300
  msgid "total number of revisions deleted"
301
  msgstr "totaal aantal verwijderde revisies"
302
 
303
+ #: rvg-optimize-db.php:755
304
  msgid "No REVISIONS found to delete"
305
  msgstr "Geen REVISIES gevonden om te verwijderen"
306
 
307
+ #: rvg-optimize-db.php:781
308
  msgid "DELETING TRASHED ITEMS"
309
  msgstr "PRULLENBAK AAN HET LEEGMAKEN"
310
 
311
+ #: rvg-optimize-db.php:785
312
  msgid "type"
313
  msgstr "type"
314
 
315
+ #: rvg-optimize-db.php:786
316
  msgid "IP address / title"
317
  msgstr "IP adres / titel"
318
 
319
+ #: rvg-optimize-db.php:787
320
  msgid "date"
321
  msgstr "datum"
322
 
323
+ #: rvg-optimize-db.php:802
324
  msgid "No TRASHED ITEMS found to delete"
325
  msgstr "Geen PRULLENBAK ITEMS gevonden om te verwijderen"
326
 
327
+ #: rvg-optimize-db.php:830
328
  msgid "DELETING SPAMMED ITEMS"
329
  msgstr "SPAM ITEMS AAN HET VERWIJDEREN"
330
 
331
+ #: rvg-optimize-db.php:834
332
  msgid "comment author"
333
  msgstr "plaatser van de reactie"
334
 
335
+ #: rvg-optimize-db.php:835
336
  msgid "comment author email"
337
  msgstr "email van de plaatser van de reactie"
338
 
339
+ #: rvg-optimize-db.php:836
340
  msgid "comment date"
341
  msgstr "datum van de reactie"
342
 
343
+ #: rvg-optimize-db.php:851
344
  msgid "No SPAMMED ITEMS found to delete"
345
  msgstr "Geen SPAM gevonden om te verwijderen"
346
 
347
+ #: rvg-optimize-db.php:878
348
  msgid "NUMBER OF UNUSED TAGS DELETED"
349
  msgstr "AANTAL VERWIJDERDE ONGEBRUIKTE TAGS"
350
 
351
+ #: rvg-optimize-db.php:889
352
  msgid "No UNUSED TAGS found to delete"
353
  msgstr "Geen ONGEBRUIKTE TAGS gevonden om te verwijderen"
354
 
355
+ #: rvg-optimize-db.php:916
356
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
357
  msgstr "AANTAL VERWIJDERDE VERLOPEN TRANSIËNTS"
358
 
359
+ #: rvg-optimize-db.php:927
360
  msgid "No EXPIRED TRANSIENTS found to delete"
361
  msgstr "Geen VERLOPEN TRANSIËNTS gevonden om te verwijderen"
362
 
363
+ #: rvg-optimize-db.php:954
364
+ msgid "NUMBER OF PINGBACKS AND TRACKBACKS DELETED"
365
+ msgstr "AANTAL VERWIJDERDE PINGBACKS EN TRACKBACKS"
366
+
367
+ #: rvg-optimize-db.php:965
368
+ msgid "No PINGBACKS nor TRACKBACKS found to delete"
369
+ msgstr "Geen PINGBACKS en TRACKBACKS gevonden om te verwijderen"
370
+
371
+ #: rvg-optimize-db.php:989
372
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
373
  msgstr "AANTAL VERWIJDERDE POSTMETA WEZEN"
374
 
375
+ #: rvg-optimize-db.php:1000
376
  msgid "No POSTMETA ORPHANS found to delete"
377
  msgstr "Geen POSTMETA WEZEN gevonden om te verwijderen"
378
 
379
+ #: rvg-optimize-db.php:1018
380
  msgid "OPTIMIZING DATABASE TABLES"
381
  msgstr "DATABASETABELLEN AAN HET OPTIMALISEREN"
382
 
383
+ #: rvg-optimize-db.php:1022
384
  msgid "table name"
385
  msgstr "tabelnaam"
386
 
387
+ #: rvg-optimize-db.php:1023
388
  msgid "optimization result"
389
  msgstr "resultaat optimalisatie"
390
 
391
+ #: rvg-optimize-db.php:1024
392
  msgid "engine"
393
  msgstr "engine"
394
 
395
+ #: rvg-optimize-db.php:1025
396
  msgid "table rows"
397
  msgstr "tabelrijen"
398
 
399
+ #: rvg-optimize-db.php:1026
400
  msgid "table size"
401
  msgstr "tabelgrootte"
402
 
403
+ #: rvg-optimize-db.php:1051 rvg-optimize-db.php:1751
404
  msgid "SAVINGS"
405
  msgstr "BESPARINGEN"
406
 
407
+ #: rvg-optimize-db.php:1055
408
  msgid "size of the database"
409
  msgstr "grootte van de database"
410
 
411
+ #: rvg-optimize-db.php:1058
412
  msgid "BEFORE optimization"
413
  msgstr "VOOR de optimalisatie"
414
 
415
+ #: rvg-optimize-db.php:1062
416
  msgid "AFTER optimization"
417
  msgstr "NA de optimalisatie"
418
 
419
+ #: rvg-optimize-db.php:1066
420
  msgid "SAVINGS THIS TIME"
421
  msgstr "DIT KEER BESPAARD"
422
 
423
+ #: rvg-optimize-db.php:1070
424
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
425
  msgstr "TOTALE BESPARING SINDS DE EERSTE UITVOERING"
426
 
427
+ #: rvg-optimize-db.php:1083
428
  msgid "DONE"
429
  msgstr "KLAAR"
430
 
431
+ #: rvg-optimize-db.php:1085
432
+ msgid "Optimization took"
433
+ msgstr "Optimalizatie duurde"
434
+
435
+ #: rvg-optimize-db.php:1085
436
+ msgid "seconds"
437
+ msgstr "seconden"
438
+
439
+ #: rvg-optimize-db.php:1654
440
+ msgid "InnoDB table: skipped..."
441
+ msgstr "InnoDB tabel overgeslagen..."
442
+
443
+ #: rvg-optimize-db.php:1660
444
+ msgid "TABLE OPTIMIZED"
445
+ msgstr "TABEL GEOPTIMALISEERD"
446
+
447
+ #: rvg-optimize-db.php:1661
448
+ msgid "Table is already up to date"
449
+ msgstr "Tabel is al optimaal"
450
+
451
+ #: rvg-optimize-db.php:1740
452
  msgid "time"
453
  msgstr "tijd"
454
 
455
+ #: rvg-optimize-db.php:1741
456
  msgid "deleted<br />revisions"
457
  msgstr "verw.<br />revisies"
458
 
459
+ #: rvg-optimize-db.php:1742
460
  msgid "deleted<br />trash"
461
  msgstr "verw.<br />prullenbak items"
462
 
463
+ #: rvg-optimize-db.php:1743
464
  msgid "deleted<br />spam"
465
  msgstr "verw.<br />spamitems"
466
 
467
+ #: rvg-optimize-db.php:1744
468
  msgid "deleted<br />tags"
469
  msgstr "verw.<br /> tags"
470
 
471
+ #: rvg-optimize-db.php:1745
472
  msgid "deleted<br />transients"
473
  msgstr "verw.<br />transiënts"
474
 
475
+ #: rvg-optimize-db.php:1746
476
+ msgid "deleted<br />pingbacks<br />trackbacks"
477
+ msgstr "verwijderde<br />pingbacks<br />trackbacks"
478
+
479
+ #: rvg-optimize-db.php:1747
480
  msgid "deleted<br />orphans"
481
  msgstr "verw.<br />wezen"
482
 
483
  # @ rvg-optimize-database
484
+ #: rvg-optimize-db.php:1748
485
  msgid "nr of optimized tables"
486
  msgstr "aantal geoptima-<br />liseerde tabellen"
487
 
488
+ #: rvg-optimize-db.php:1749
489
  msgid "database size BEFORE"
490
  msgstr "database<br />grootte<br />VOOR"
491
 
492
+ #: rvg-optimize-db.php:1750
493
  msgid "database size AFTER"
494
  msgstr "database<br />grootte<br />NA"
495
 
496
+ #~ msgid "TABLE OPTIMIZED!"
497
+ #~ msgstr "TABEL GEOPTIMALISEERD!"
498
+
499
+ # @ default
500
+ #~ msgid "Optimize DB Options"
501
+ #~ msgstr "Optimaliseer DB Opties"
502
+
503
+ #~ msgid "Optimize Database after Deleting Revisions OPTIONS UPDATED"
504
+ #~ msgstr "Optimize Database after Deleting Revisions OPTIES OPGESLAGEN"
505
+
506
+ #~ msgid ""
507
+ #~ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
508
+ #~ "bold\">HERE</a> to run the optimization"
509
+ #~ msgstr ""
510
+ #~ "Klik <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
511
+ #~ "bold\">HIER</a> om de optimalisatie te starten"
512
+
513
+ #~ msgid "To start the optimization:"
514
+ #~ msgstr "Om de optimalisatie te starten:"
515
+
516
+ #~ msgid ""
517
+ #~ "<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; "
518
+ #~ "<strong>Optimize Database</strong>. Then click the '<strong>Start "
519
+ #~ "Optimization</strong>'-button. Et voila!"
520
+ #~ msgstr ""
521
+ #~ "<strong>WP Admin Panel</strong> &raquo; <strong>Extra</strong> &raquo; "
522
+ #~ "<strong>Optimaliseren Database</strong>. Klik dan de '<strong>Start "
523
+ #~ "Optimalisatie</strong>'-knop. Et voila!"
524
+
525
+ #~ msgid ""
526
+ #~ "Note: if you use the Scheduler the Optimization will run automatically!"
527
+ #~ msgstr ""
528
+ #~ "Opmerking: als u gebruik maakt van de Planner zal de optimalisatie "
529
+ #~ "automatisch worden uitgevoerd"
530
+
531
+ #~ msgid "Optimize Database after Deleting Revisions - Options"
532
+ #~ msgstr "Optimize Database after Deleting Revisions - Opties"
533
+
534
+ #~ msgid ""
535
+ #~ "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style=\"text-decoration:"
536
+ #~ "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-"
537
+ #~ "decoration:underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
538
+ #~ msgstr ""
539
+ #~ "SLUIT DE VOLGENDE TABELLEN UIT VAN OPTIMALISATIE: <span style=\"text-"
540
+ #~ "decoration:underline;color:#F00;\">AANGEVINKTE</span> TABELLEN WORDEN "
541
+ #~ "<span style=\"text-decoration:underline;color:#F00;\">NIET</span> "
542
+ #~ "GEOPTIMALISEERD!</span>"
543
+
544
+ #~ msgid "Save Options"
545
+ #~ msgstr "Bewaar Opties"
546
+
547
+ #~ msgid "Current options"
548
+ #~ msgstr "Huidige opties"
549
+
550
+ #~ msgid "Change Options"
551
+ #~ msgstr "Wijzig Opties"
552
+
553
  # @ rvg-optimize-database
554
  #~ msgid "Hello world!"
555
  #~ msgstr "HALLO WERELD!"
language/rvg-optimize-database-sr_RS.mo CHANGED
Binary file
language/rvg-optimize-database-sr_RS.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: 2014-10-06 14:01+0100\n"
6
- "PO-Revision-Date: 2014-10-06 14:01+0100\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: sr_RS\n"
@@ -11,7 +11,7 @@ msgstr ""
11
  "Content-Type: text/plain; charset=UTF-8\n"
12
  "Content-Transfer-Encoding: 8bit\n"
13
  "Plural-Forms: nplurals=2; plural=n != 1;\n"
14
- "X-Generator: Poedit 1.6.9\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"
@@ -21,455 +21,509 @@ msgstr ""
21
  "X-Poedit-SearchPath-0: .\n"
22
 
23
  # @ rvg-optimize-database
24
- #: rvg-optimize-db.php:37
 
 
25
  msgid "Optimize Database"
26
  msgstr "Optimize Database"
27
 
28
- # @ default
29
- #: rvg-optimize-db.php:51
30
- msgid "Optimize DB Options"
31
- msgstr "Optimize DB opcije"
32
-
33
  # @ optimize_db
34
- #: rvg-optimize-db.php:66
35
  msgid "Optimize DB (1 click)"
36
  msgstr "Optimizuj bazu podataka (1 klik)"
37
 
38
  # @ default
39
- #: rvg-optimize-db.php:83
40
  msgid "Once Weekly"
41
  msgstr "Jednom nedeljno"
42
 
43
  # @ default
44
- #: rvg-optimize-db.php:119
45
  msgctxt "timezone date format"
46
  msgid "YmdGis"
47
  msgstr "YmdGis"
48
 
49
- #: rvg-optimize-db.php:224
50
- msgid "Optimize Database after Deleting Revisions OPTIONS UPDATED"
51
- msgstr "Optimize Database after Deleting Revisions OPCIJE AŽURIRANE"
52
 
53
- #: rvg-optimize-db.php:226
54
  msgid ""
55
- "Click <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:bold"
56
  "\">HERE</a> to run the optimization"
57
  msgstr ""
58
- "Kliknite <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
59
- "bold\">OVDE</a> da biste pokrenuli optimizaciju "
60
 
61
- #: rvg-optimize-db.php:270
62
  msgid "Using Optimize Database after Deleting Revisions"
63
  msgstr "Upotreba Optimize Database after Deleting Revisions"
64
 
65
- #: rvg-optimize-db.php:272
66
  msgid "is an one-click plugin to clean and optimize your WordPress database"
67
  msgstr ""
68
  "je plugin na 1 klik koji čisti i unapređuje vašu WordPress bazu podataka"
69
 
70
- #: rvg-optimize-db.php:273
71
- msgid "To start the optimization:"
72
- msgstr "Da biste započeli optimizaciju:"
73
-
74
- #: rvg-optimize-db.php:274
75
- msgid ""
76
- "<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; "
77
- "<strong>Optimize Database</strong>. Then click the '<strong>Start "
78
- "Optimization</strong>'-button. Et voila!"
79
- msgstr ""
80
- "<strong>WP Admin Panel</strong> &raquo; <strong>Alati</strong> &raquo; "
81
- "<strong>Optimizuj bazu podataka</strong>. Zatim kliknite na<strong>Počni "
82
- "optimizaciju</strong>'-taster. To je to!"
83
-
84
- #: rvg-optimize-db.php:275
85
- msgid "Note: if you use the Scheduler the Optimization will run automatically!"
86
- msgstr ""
87
- "Napomena: ako koristite planer, optimizacija će se pokrenuti automatski"
88
-
89
- #: rvg-optimize-db.php:276
90
  msgid "Plugin version:"
91
  msgstr "Plugin verzija:"
92
 
93
- #: rvg-optimize-db.php:278
94
  msgid "Author"
95
  msgstr "Autor"
96
 
97
- #: rvg-optimize-db.php:279 rvg-optimize-db.php:529 rvg-optimize-db.php:1458
98
  msgid "The Netherlands"
99
  msgstr "Holandija"
100
 
101
- #: rvg-optimize-db.php:280
102
  msgid "Plugin URL:"
103
  msgstr "URL Plugin-a:"
104
 
105
- #: rvg-optimize-db.php:282
106
  msgid "Download URL:"
107
  msgstr "Download URL:"
108
 
109
- #: rvg-optimize-db.php:286
110
- msgid "Optimize Database after Deleting Revisions - Options"
111
- msgstr "Optimize Database after Deleting Revisions - Opcije"
112
 
113
- #: rvg-optimize-db.php:301 rvg-optimize-db.php:531
114
  msgid "Maximum number of - most recent - revisions to keep per post / page"
115
  msgstr ""
116
  "Najveći broj - najskorijih - revizija koje treba održavati za svaki post/"
117
  "stranicu"
118
 
119
- #: rvg-optimize-db.php:302
120
  msgid "('0' means: delete <u>ALL</u> revisions)"
121
  msgstr "('0' znači: obriši <u>SVE</u> revizije)"
122
 
123
- #: rvg-optimize-db.php:306 rvg-optimize-db.php:532
124
  msgid "Delete all trashed items"
125
  msgstr "Obriši sve stavke u korpi za otpatke"
126
 
127
- #: rvg-optimize-db.php:310 rvg-optimize-db.php:533
128
  msgid "Delete all spammed items"
129
  msgstr "Obriši sve spam stavke"
130
 
131
- #: rvg-optimize-db.php:314 rvg-optimize-db.php:534
132
  msgid "Delete unused tags"
133
  msgstr "Obriši neiskorišćene oznake"
134
 
135
- #: rvg-optimize-db.php:318 rvg-optimize-db.php:535
136
  msgid "Delete expired transients"
137
  msgstr "Obriši sve prolazne stavke koje su istekle"
138
 
139
- #: rvg-optimize-db.php:322 rvg-optimize-db.php:536
 
 
 
 
140
  msgid "Keep a log"
141
  msgstr "Vodi dnevnik"
142
 
143
- #: rvg-optimize-db.php:326 rvg-optimize-db.php:538
144
  msgid "Scheduler"
145
  msgstr "Planer"
146
 
147
- #: rvg-optimize-db.php:328 rvg-optimize-db.php:503
148
  msgid "NOT SCHEDULED"
149
  msgstr "NIJE PLANIRANO"
150
 
151
- #: rvg-optimize-db.php:329
152
  msgid "run optimization HOURLY"
153
  msgstr "pokreni optimizaciju NA SVAKI SAT"
154
 
155
- #: rvg-optimize-db.php:330
156
  msgid "run optimization TWICE A DAY"
157
  msgstr "pokreni optimizaciju DVA PUTA DNEVNO"
158
 
159
- #: rvg-optimize-db.php:331
160
  msgid "run optimization DAILY"
161
  msgstr "pokreni optimizaciju JEDNOM DNEVNO"
162
 
163
- #: rvg-optimize-db.php:332
164
  msgid "run optimization WEEKLY"
165
  msgstr "pokreni optimizaciju JEDNOM NEDELJNO"
166
 
167
- #: rvg-optimize-db.php:338
168
  msgid "Time"
169
  msgstr "Vreme"
170
 
171
- #: rvg-optimize-db.php:344
172
  msgid "hrs"
173
  msgstr "Sat"
174
 
175
- #: rvg-optimize-db.php:356
176
  msgid "Show '1-click' link in Admin Bar"
177
  msgstr "Prikaži ‘1-klik’ link u traci za meni administratora"
178
 
179
- #: rvg-optimize-db.php:358
180
  msgid "(change will be visible after loading the next page)"
181
  msgstr "(promena će biti vidljiva nakon učitavanja sledeće stranice)"
182
 
183
- #: rvg-optimize-db.php:370
 
 
 
 
184
  msgid ""
185
- "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style=\"text-decoration:"
186
- "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-decoration:"
187
- "underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
188
  msgstr ""
189
- "ISKLJUČI TABELE BAZE PODATAKA IZ OPTIMIZACIJE: <span style=\"text-decoration:"
190
- "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-decoration:"
191
- "underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
192
 
193
- #: rvg-optimize-db.php:371
194
  msgid "check all tables"
195
  msgstr "štikliraj sve tabele"
196
 
197
- #: rvg-optimize-db.php:371
198
  msgid "uncheck all tables"
199
  msgstr "poništi štikliranje svih tabela"
200
 
201
- #: rvg-optimize-db.php:371
202
  msgid "check all NON-WordPress tables"
203
  msgstr "štikliraj sve tabele koje NISU WordPress "
204
 
205
- #: rvg-optimize-db.php:409
206
- msgid "Save Options"
207
- msgstr "Sačuvaj opcije"
208
 
209
- #: rvg-optimize-db.php:411
210
  msgid "Go To Optimizer"
211
  msgstr "Pokreni optimizator"
212
 
213
  # @ default
214
- #: rvg-optimize-db.php:429
215
  msgctxt "timezone date format"
216
  msgid "G:i"
217
  msgstr "G:i"
218
 
219
- #: rvg-optimize-db.php:454 rvg-optimize-db.php:461 rvg-optimize-db.php:468
220
- #: rvg-optimize-db.php:475 rvg-optimize-db.php:482
221
  msgid "NO"
222
  msgstr "NE"
223
 
224
- #: rvg-optimize-db.php:454 rvg-optimize-db.php:461 rvg-optimize-db.php:468
225
- #: rvg-optimize-db.php:475 rvg-optimize-db.php:482
226
  msgid "YES"
227
  msgstr "DA"
228
 
229
- #: rvg-optimize-db.php:491
230
  msgid "ONCE HOURLY"
231
  msgstr "SVAKOG SATA"
232
 
233
- #: rvg-optimize-db.php:493
234
  msgid "TWICE DAILY"
235
  msgstr "DVA PUTA DNEVNO"
236
 
237
- #: rvg-optimize-db.php:495
238
  msgid "ONCE DAILY"
239
  msgstr "JEDNOM DNEVNO"
240
 
241
- #: rvg-optimize-db.php:497
242
  msgid "ONCE WEEKLY"
243
  msgstr "JEDNOM NEDELJNO"
244
 
245
  # @ rvg-optimize-database
246
- #: rvg-optimize-db.php:523
247
  msgid "Optimize your WordPress Database"
248
  msgstr "Optimizujte svoju WordPress bazu podataka"
249
 
250
- #: rvg-optimize-db.php:529 rvg-optimize-db.php:1458
251
  msgid "A WordPress Plugin by"
252
  msgstr "WordPress Plugin kreirao:"
253
 
254
- #: rvg-optimize-db.php:530
255
- msgid "Current options"
256
- msgstr "Trenutne opcije"
257
 
258
- #: rvg-optimize-db.php:537
259
  msgid "Number of excluded tables"
260
  msgstr "Broj isključenih tabela"
261
 
262
- #: rvg-optimize-db.php:544
263
  msgid "Next scheduled run"
264
  msgstr "Sledeća planirana optimizacija"
265
 
266
- #: rvg-optimize-db.php:551
267
  msgid "Total savings since the first run"
268
  msgstr "Ukupno sačuvanih od prvog pokretanja "
269
 
270
- #: rvg-optimize-db.php:556
271
- msgid "Change Options"
272
- msgstr "Promeni opcije"
273
 
274
- #: rvg-optimize-db.php:562 rvg-optimize-db.php:917
275
  msgid "View Log File"
276
  msgstr "Pregledaj datoteku dnevnika"
277
 
278
- #: rvg-optimize-db.php:564 rvg-optimize-db.php:919
279
  msgid "Delete Log File"
280
  msgstr "Obriši datoteku dnevnika"
281
 
282
- #: rvg-optimize-db.php:573
283
  msgid "Start Optimization"
284
  msgstr "Pokreni optimizaciju"
285
 
286
- #: rvg-optimize-db.php:584
287
  msgid "Starting Optimization"
288
  msgstr "Optimizacija počinje"
289
 
290
  # @ default
291
- #: rvg-optimize-db.php:590
292
  msgctxt "timezone date format"
293
  msgid "m/d/YH:i:s"
294
  msgstr "m/d/YH:i:s"
295
 
296
- #: rvg-optimize-db.php:603
297
  msgid "DELETING REVISIONS"
298
  msgstr "BRISANJE REVIZIJA"
299
 
300
- #: rvg-optimize-db.php:607
301
  msgid "post / page"
302
  msgstr "post/stranica"
303
 
304
- #: rvg-optimize-db.php:608
305
  msgid "revision date"
306
  msgstr "datum revizije"
307
 
308
- #: rvg-optimize-db.php:609
309
  msgid "revisions deleted"
310
  msgstr "revizija obrisana"
311
 
312
- #: rvg-optimize-db.php:616
313
  msgid "total number of revisions deleted"
314
  msgstr "ukupan broj obrisanih revizija"
315
 
316
- #: rvg-optimize-db.php:627
317
  msgid "No REVISIONS found to delete"
318
  msgstr "NISU PRONAĐENE REVIZIJE za brisanje"
319
 
320
- #: rvg-optimize-db.php:653
321
  msgid "DELETING TRASHED ITEMS"
322
  msgstr "BRISANJE STAVKI U KORPI ZA OTPATKE"
323
 
324
- #: rvg-optimize-db.php:657
325
  msgid "type"
326
  msgstr "tip"
327
 
328
- #: rvg-optimize-db.php:658
329
  msgid "IP address / title"
330
  msgstr "IP adresa/naslov"
331
 
332
- #: rvg-optimize-db.php:659
333
  msgid "date"
334
  msgstr "datum"
335
 
336
- #: rvg-optimize-db.php:674
337
  msgid "No TRASHED ITEMS found to delete"
338
  msgstr "NISU PRONAĐENE STAVKE za brisanje u korpi za otpatke "
339
 
340
- #: rvg-optimize-db.php:702
341
  msgid "DELETING SPAMMED ITEMS"
342
  msgstr "BRISANJE SPAM STAVKI"
343
 
344
- #: rvg-optimize-db.php:706
345
  msgid "comment author"
346
  msgstr "komentarišite autora"
347
 
348
- #: rvg-optimize-db.php:707
349
  msgid "comment author email"
350
  msgstr "komentarišite email autora"
351
 
352
- #: rvg-optimize-db.php:708
353
  msgid "comment date"
354
  msgstr "komentarišite datum"
355
 
356
- #: rvg-optimize-db.php:723
357
  msgid "No SPAMMED ITEMS found to delete"
358
  msgstr "NISU PRONAĐENE SPAM STAVKE za brisanje"
359
 
360
- #: rvg-optimize-db.php:750
361
  msgid "NUMBER OF UNUSED TAGS DELETED"
362
  msgstr "BROJ NEUPOTREBLJENIH OBRISANIH OZNAKA"
363
 
364
- #: rvg-optimize-db.php:761
365
  msgid "No UNUSED TAGS found to delete"
366
  msgstr "NISU PRONAĐENE NEUPOTREBLJENE OZNAKE za brisanje"
367
 
368
- #: rvg-optimize-db.php:788
369
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
370
  msgstr "BROJ OBRISANIH, ISTEKLIH PROLAZNIH STAVKI "
371
 
372
- #: rvg-optimize-db.php:799
373
  msgid "No EXPIRED TRANSIENTS found to delete"
374
  msgstr "Nisu pronađene istekle, prolazne stavke za brisanje "
375
 
376
- #: rvg-optimize-db.php:822
 
 
 
 
 
 
 
 
377
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
378
  msgstr "BROJ OBRISANIH POSTMETA SIROČIĆA "
379
 
380
- #: rvg-optimize-db.php:833
381
  msgid "No POSTMETA ORPHANS found to delete"
382
  msgstr "Nisu pronađeni postmeta siročići za brisanje"
383
 
384
- #: rvg-optimize-db.php:850
385
  msgid "OPTIMIZING DATABASE TABLES"
386
  msgstr "Optimizovanje tabela baze podataka"
387
 
388
- #: rvg-optimize-db.php:854
389
  msgid "table name"
390
  msgstr "naziv tabele"
391
 
392
- #: rvg-optimize-db.php:855
393
  msgid "optimization result"
394
  msgstr "rezultat optimizacije"
395
 
396
- #: rvg-optimize-db.php:856
397
  msgid "engine"
398
  msgstr "sredstvo"
399
 
400
- #: rvg-optimize-db.php:857
401
  msgid "table rows"
402
  msgstr "redovi tabele"
403
 
404
- #: rvg-optimize-db.php:858
405
  msgid "table size"
406
  msgstr "veličina tabele"
407
 
408
- #: rvg-optimize-db.php:885 rvg-optimize-db.php:1472
409
  msgid "SAVINGS"
410
  msgstr "SAČUVANO"
411
 
412
- #: rvg-optimize-db.php:889
413
  msgid "size of the database"
414
  msgstr "veličina baze podataka"
415
 
416
- #: rvg-optimize-db.php:892
417
  msgid "BEFORE optimization"
418
  msgstr "PRE optimizacije"
419
 
420
- #: rvg-optimize-db.php:896
421
  msgid "AFTER optimization"
422
  msgstr "POSLE optimizacije"
423
 
424
- #: rvg-optimize-db.php:900
425
  msgid "SAVINGS THIS TIME"
426
  msgstr "KOLIKO JE SAČUVANO STAVKI OVOG PUTA"
427
 
428
- #: rvg-optimize-db.php:904
429
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
430
  msgstr "UKUPNO SAČUVANIH STAVKI OD PRVOG POKRETANJA"
431
 
432
- #: rvg-optimize-db.php:910
433
  msgid "DONE"
434
  msgstr "URAĐENO"
435
 
436
- #: rvg-optimize-db.php:1462
 
 
 
 
 
 
 
 
437
  msgid "time"
438
  msgstr "vreme"
439
 
440
- #: rvg-optimize-db.php:1463
441
  msgid "deleted<br />revisions"
442
  msgstr "obrisane <br />revizije"
443
 
444
- #: rvg-optimize-db.php:1464
445
  msgid "deleted<br />trash"
446
  msgstr "obrisano <br /> iz korpe za otpatke "
447
 
448
- #: rvg-optimize-db.php:1465
449
  msgid "deleted<br />spam"
450
  msgstr "obrisani <br />spam"
451
 
452
- #: rvg-optimize-db.php:1466
453
  msgid "deleted<br />tags"
454
  msgstr "obrisane <br /> oznake"
455
 
456
- #: rvg-optimize-db.php:1467
457
  msgid "deleted<br />transients"
458
  msgstr "obrisane <br /> prolazne stavke"
459
 
460
- #: rvg-optimize-db.php:1468
 
 
 
 
461
  msgid "deleted<br />orphans"
462
  msgstr "obrisani <br /> siročići"
463
 
464
  # @ rvg-optimize-database
465
- #: rvg-optimize-db.php:1469
466
  msgid "nr of optimized tables"
467
  msgstr "broj optimizovanih tabela"
468
 
469
- #: rvg-optimize-db.php:1470
470
  msgid "database size BEFORE"
471
  msgstr "baza podataka PRE"
472
 
473
- #: rvg-optimize-db.php:1471
474
  msgid "database size AFTER"
475
  msgstr "baza podataka POSLE"
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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-03-01 14:42+0100\n"
6
+ "PO-Revision-Date: 2015-03-01 14:42+0100\n"
7
  "Last-Translator: Rolf van Gelder <info@cagewebdev.com>\n"
8
  "Language-Team: CAGE <info@cagewebdev.com>\n"
9
  "Language: sr_RS\n"
11
  "Content-Type: text/plain; charset=UTF-8\n"
12
  "Content-Transfer-Encoding: 8bit\n"
13
  "Plural-Forms: nplurals=2; plural=n != 1;\n"
14
+ "X-Generator: Poedit 1.7.4\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"
21
  "X-Poedit-SearchPath-0: .\n"
22
 
23
  # @ rvg-optimize-database
24
+ #: rvg-optimize-db.php:39 rvg-optimize-db.php:40 rvg-optimize-db.php:59
25
+ #: rvg-optimize-db.php:60 rvg-optimize-db.php:80 rvg-optimize-db.php:81
26
+ #: rvg-optimize-db.php:100 rvg-optimize-db.php:101
27
  msgid "Optimize Database"
28
  msgstr "Optimize Database"
29
 
 
 
 
 
 
30
  # @ optimize_db
31
+ #: rvg-optimize-db.php:136
32
  msgid "Optimize DB (1 click)"
33
  msgstr "Optimizuj bazu podataka (1 klik)"
34
 
35
  # @ default
36
+ #: rvg-optimize-db.php:165
37
  msgid "Once Weekly"
38
  msgstr "Jednom nedeljno"
39
 
40
  # @ default
41
+ #: rvg-optimize-db.php:201
42
  msgctxt "timezone date format"
43
  msgid "YmdGis"
44
  msgstr "YmdGis"
45
 
46
+ #: rvg-optimize-db.php:318
47
+ msgid "Optimize Database after Deleting Revisions SETTINGS UPDATED"
48
+ msgstr ""
49
 
50
+ #: rvg-optimize-db.php:320
51
  msgid ""
52
+ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" class=\"odb-bold"
53
  "\">HERE</a> to run the optimization"
54
  msgstr ""
 
 
55
 
56
+ #: rvg-optimize-db.php:372
57
  msgid "Using Optimize Database after Deleting Revisions"
58
  msgstr "Upotreba Optimize Database after Deleting Revisions"
59
 
60
+ #: rvg-optimize-db.php:374
61
  msgid "is an one-click plugin to clean and optimize your WordPress database"
62
  msgstr ""
63
  "je plugin na 1 klik koji čisti i unapređuje vašu WordPress bazu podataka"
64
 
65
+ #: rvg-optimize-db.php:375
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
66
  msgid "Plugin version:"
67
  msgstr "Plugin verzija:"
68
 
69
+ #: rvg-optimize-db.php:377
70
  msgid "Author"
71
  msgstr "Autor"
72
 
73
+ #: rvg-optimize-db.php:378 rvg-optimize-db.php:656 rvg-optimize-db.php:1735
74
  msgid "The Netherlands"
75
  msgstr "Holandija"
76
 
77
+ #: rvg-optimize-db.php:379
78
  msgid "Plugin URL:"
79
  msgstr "URL Plugin-a:"
80
 
81
+ #: rvg-optimize-db.php:381
82
  msgid "Download URL:"
83
  msgstr "Download URL:"
84
 
85
+ #: rvg-optimize-db.php:385
86
+ msgid "Optimize Database after Deleting Revisions - Settings"
87
+ msgstr ""
88
 
89
+ #: rvg-optimize-db.php:403 rvg-optimize-db.php:658
90
  msgid "Maximum number of - most recent - revisions to keep per post / page"
91
  msgstr ""
92
  "Najveći broj - najskorijih - revizija koje treba održavati za svaki post/"
93
  "stranicu"
94
 
95
+ #: rvg-optimize-db.php:404
96
  msgid "('0' means: delete <u>ALL</u> revisions)"
97
  msgstr "('0' znači: obriši <u>SVE</u> revizije)"
98
 
99
+ #: rvg-optimize-db.php:408 rvg-optimize-db.php:659
100
  msgid "Delete all trashed items"
101
  msgstr "Obriši sve stavke u korpi za otpatke"
102
 
103
+ #: rvg-optimize-db.php:412 rvg-optimize-db.php:660
104
  msgid "Delete all spammed items"
105
  msgstr "Obriši sve spam stavke"
106
 
107
+ #: rvg-optimize-db.php:416 rvg-optimize-db.php:661
108
  msgid "Delete unused tags"
109
  msgstr "Obriši neiskorišćene oznake"
110
 
111
+ #: rvg-optimize-db.php:420 rvg-optimize-db.php:662
112
  msgid "Delete expired transients"
113
  msgstr "Obriši sve prolazne stavke koje su istekle"
114
 
115
+ #: rvg-optimize-db.php:424 rvg-optimize-db.php:663
116
+ msgid "Delete pingbacks and trackbacks"
117
+ msgstr ""
118
+
119
+ #: rvg-optimize-db.php:428 rvg-optimize-db.php:664
120
  msgid "Keep a log"
121
  msgstr "Vodi dnevnik"
122
 
123
+ #: rvg-optimize-db.php:432 rvg-optimize-db.php:666
124
  msgid "Scheduler"
125
  msgstr "Planer"
126
 
127
+ #: rvg-optimize-db.php:434 rvg-optimize-db.php:630
128
  msgid "NOT SCHEDULED"
129
  msgstr "NIJE PLANIRANO"
130
 
131
+ #: rvg-optimize-db.php:435
132
  msgid "run optimization HOURLY"
133
  msgstr "pokreni optimizaciju NA SVAKI SAT"
134
 
135
+ #: rvg-optimize-db.php:436
136
  msgid "run optimization TWICE A DAY"
137
  msgstr "pokreni optimizaciju DVA PUTA DNEVNO"
138
 
139
+ #: rvg-optimize-db.php:437
140
  msgid "run optimization DAILY"
141
  msgstr "pokreni optimizaciju JEDNOM DNEVNO"
142
 
143
+ #: rvg-optimize-db.php:438
144
  msgid "run optimization WEEKLY"
145
  msgstr "pokreni optimizaciju JEDNOM NEDELJNO"
146
 
147
+ #: rvg-optimize-db.php:444
148
  msgid "Time"
149
  msgstr "Vreme"
150
 
151
+ #: rvg-optimize-db.php:450
152
  msgid "hrs"
153
  msgstr "Sat"
154
 
155
+ #: rvg-optimize-db.php:462
156
  msgid "Show '1-click' link in Admin Bar"
157
  msgstr "Prikaži ‘1-klik’ link u traci za meni administratora"
158
 
159
+ #: rvg-optimize-db.php:464 rvg-optimize-db.php:469
160
  msgid "(change will be visible after loading the next page)"
161
  msgstr "(promena će biti vidljiva nakon učitavanja sledeće stranice)"
162
 
163
+ #: rvg-optimize-db.php:467
164
+ msgid "Show an icon in the Admin Menu"
165
+ msgstr ""
166
+
167
+ #: rvg-optimize-db.php:481
168
  msgid ""
169
+ "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class=\"odb-underline-red"
170
+ "\">CHECKED</span> TABLES <span class=\"odb-underline-red\">WON'T</span> BE "
171
+ "OPTIMIZED!</span>"
172
  msgstr ""
 
 
 
173
 
174
+ #: rvg-optimize-db.php:482
175
  msgid "check all tables"
176
  msgstr "štikliraj sve tabele"
177
 
178
+ #: rvg-optimize-db.php:482
179
  msgid "uncheck all tables"
180
  msgstr "poništi štikliranje svih tabela"
181
 
182
+ #: rvg-optimize-db.php:482
183
  msgid "check all NON-WordPress tables"
184
  msgstr "štikliraj sve tabele koje NISU WordPress "
185
 
186
+ #: rvg-optimize-db.php:520
187
+ msgid "Save Settings"
188
+ msgstr ""
189
 
190
+ #: rvg-optimize-db.php:522
191
  msgid "Go To Optimizer"
192
  msgstr "Pokreni optimizator"
193
 
194
  # @ default
195
+ #: rvg-optimize-db.php:548
196
  msgctxt "timezone date format"
197
  msgid "G:i"
198
  msgstr "G:i"
199
 
200
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
201
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
202
  msgid "NO"
203
  msgstr "NE"
204
 
205
+ #: rvg-optimize-db.php:573 rvg-optimize-db.php:580 rvg-optimize-db.php:587
206
+ #: rvg-optimize-db.php:594 rvg-optimize-db.php:602 rvg-optimize-db.php:609
207
  msgid "YES"
208
  msgstr "DA"
209
 
210
+ #: rvg-optimize-db.php:618
211
  msgid "ONCE HOURLY"
212
  msgstr "SVAKOG SATA"
213
 
214
+ #: rvg-optimize-db.php:620
215
  msgid "TWICE DAILY"
216
  msgstr "DVA PUTA DNEVNO"
217
 
218
+ #: rvg-optimize-db.php:622
219
  msgid "ONCE DAILY"
220
  msgstr "JEDNOM DNEVNO"
221
 
222
+ #: rvg-optimize-db.php:624
223
  msgid "ONCE WEEKLY"
224
  msgstr "JEDNOM NEDELJNO"
225
 
226
  # @ rvg-optimize-database
227
+ #: rvg-optimize-db.php:650
228
  msgid "Optimize your WordPress Database"
229
  msgstr "Optimizujte svoju WordPress bazu podataka"
230
 
231
+ #: rvg-optimize-db.php:656 rvg-optimize-db.php:1735
232
  msgid "A WordPress Plugin by"
233
  msgstr "WordPress Plugin kreirao:"
234
 
235
+ #: rvg-optimize-db.php:657
236
+ msgid "Current settings"
237
+ msgstr ""
238
 
239
+ #: rvg-optimize-db.php:665
240
  msgid "Number of excluded tables"
241
  msgstr "Broj isključenih tabela"
242
 
243
+ #: rvg-optimize-db.php:672
244
  msgid "Next scheduled run"
245
  msgstr "Sledeća planirana optimizacija"
246
 
247
+ #: rvg-optimize-db.php:679
248
  msgid "Total savings since the first run"
249
  msgstr "Ukupno sačuvanih od prvog pokretanja "
250
 
251
+ #: rvg-optimize-db.php:684
252
+ msgid "Change Settings"
253
+ msgstr ""
254
 
255
+ #: rvg-optimize-db.php:690 rvg-optimize-db.php:1093
256
  msgid "View Log File"
257
  msgstr "Pregledaj datoteku dnevnika"
258
 
259
+ #: rvg-optimize-db.php:692 rvg-optimize-db.php:1095
260
  msgid "Delete Log File"
261
  msgstr "Obriši datoteku dnevnika"
262
 
263
+ #: rvg-optimize-db.php:701
264
  msgid "Start Optimization"
265
  msgstr "Pokreni optimizaciju"
266
 
267
+ #: rvg-optimize-db.php:712
268
  msgid "Starting Optimization"
269
  msgstr "Optimizacija počinje"
270
 
271
  # @ default
272
+ #: rvg-optimize-db.php:718
273
  msgctxt "timezone date format"
274
  msgid "m/d/YH:i:s"
275
  msgstr "m/d/YH:i:s"
276
 
277
+ #: rvg-optimize-db.php:731
278
  msgid "DELETING REVISIONS"
279
  msgstr "BRISANJE REVIZIJA"
280
 
281
+ #: rvg-optimize-db.php:735
282
  msgid "post / page"
283
  msgstr "post/stranica"
284
 
285
+ #: rvg-optimize-db.php:736
286
  msgid "revision date"
287
  msgstr "datum revizije"
288
 
289
+ #: rvg-optimize-db.php:737
290
  msgid "revisions deleted"
291
  msgstr "revizija obrisana"
292
 
293
+ #: rvg-optimize-db.php:744
294
  msgid "total number of revisions deleted"
295
  msgstr "ukupan broj obrisanih revizija"
296
 
297
+ #: rvg-optimize-db.php:755
298
  msgid "No REVISIONS found to delete"
299
  msgstr "NISU PRONAĐENE REVIZIJE za brisanje"
300
 
301
+ #: rvg-optimize-db.php:781
302
  msgid "DELETING TRASHED ITEMS"
303
  msgstr "BRISANJE STAVKI U KORPI ZA OTPATKE"
304
 
305
+ #: rvg-optimize-db.php:785
306
  msgid "type"
307
  msgstr "tip"
308
 
309
+ #: rvg-optimize-db.php:786
310
  msgid "IP address / title"
311
  msgstr "IP adresa/naslov"
312
 
313
+ #: rvg-optimize-db.php:787
314
  msgid "date"
315
  msgstr "datum"
316
 
317
+ #: rvg-optimize-db.php:802
318
  msgid "No TRASHED ITEMS found to delete"
319
  msgstr "NISU PRONAĐENE STAVKE za brisanje u korpi za otpatke "
320
 
321
+ #: rvg-optimize-db.php:830
322
  msgid "DELETING SPAMMED ITEMS"
323
  msgstr "BRISANJE SPAM STAVKI"
324
 
325
+ #: rvg-optimize-db.php:834
326
  msgid "comment author"
327
  msgstr "komentarišite autora"
328
 
329
+ #: rvg-optimize-db.php:835
330
  msgid "comment author email"
331
  msgstr "komentarišite email autora"
332
 
333
+ #: rvg-optimize-db.php:836
334
  msgid "comment date"
335
  msgstr "komentarišite datum"
336
 
337
+ #: rvg-optimize-db.php:851
338
  msgid "No SPAMMED ITEMS found to delete"
339
  msgstr "NISU PRONAĐENE SPAM STAVKE za brisanje"
340
 
341
+ #: rvg-optimize-db.php:878
342
  msgid "NUMBER OF UNUSED TAGS DELETED"
343
  msgstr "BROJ NEUPOTREBLJENIH OBRISANIH OZNAKA"
344
 
345
+ #: rvg-optimize-db.php:889
346
  msgid "No UNUSED TAGS found to delete"
347
  msgstr "NISU PRONAĐENE NEUPOTREBLJENE OZNAKE za brisanje"
348
 
349
+ #: rvg-optimize-db.php:916
350
  msgid "NUMBER OF EXPIRED TRANSIENTS DELETED"
351
  msgstr "BROJ OBRISANIH, ISTEKLIH PROLAZNIH STAVKI "
352
 
353
+ #: rvg-optimize-db.php:927
354
  msgid "No EXPIRED TRANSIENTS found to delete"
355
  msgstr "Nisu pronađene istekle, prolazne stavke za brisanje "
356
 
357
+ #: rvg-optimize-db.php:954
358
+ msgid "NUMBER OF PINGBACKS AND TRACKBACKS DELETED"
359
+ msgstr ""
360
+
361
+ #: rvg-optimize-db.php:965
362
+ msgid "No PINGBACKS nor TRACKBACKS found to delete"
363
+ msgstr ""
364
+
365
+ #: rvg-optimize-db.php:989
366
  msgid "NUMBER OF POSTMETA ORPHANS DELETED"
367
  msgstr "BROJ OBRISANIH POSTMETA SIROČIĆA "
368
 
369
+ #: rvg-optimize-db.php:1000
370
  msgid "No POSTMETA ORPHANS found to delete"
371
  msgstr "Nisu pronađeni postmeta siročići za brisanje"
372
 
373
+ #: rvg-optimize-db.php:1018
374
  msgid "OPTIMIZING DATABASE TABLES"
375
  msgstr "Optimizovanje tabela baze podataka"
376
 
377
+ #: rvg-optimize-db.php:1022
378
  msgid "table name"
379
  msgstr "naziv tabele"
380
 
381
+ #: rvg-optimize-db.php:1023
382
  msgid "optimization result"
383
  msgstr "rezultat optimizacije"
384
 
385
+ #: rvg-optimize-db.php:1024
386
  msgid "engine"
387
  msgstr "sredstvo"
388
 
389
+ #: rvg-optimize-db.php:1025
390
  msgid "table rows"
391
  msgstr "redovi tabele"
392
 
393
+ #: rvg-optimize-db.php:1026
394
  msgid "table size"
395
  msgstr "veličina tabele"
396
 
397
+ #: rvg-optimize-db.php:1051 rvg-optimize-db.php:1750
398
  msgid "SAVINGS"
399
  msgstr "SAČUVANO"
400
 
401
+ #: rvg-optimize-db.php:1055
402
  msgid "size of the database"
403
  msgstr "veličina baze podataka"
404
 
405
+ #: rvg-optimize-db.php:1058
406
  msgid "BEFORE optimization"
407
  msgstr "PRE optimizacije"
408
 
409
+ #: rvg-optimize-db.php:1062
410
  msgid "AFTER optimization"
411
  msgstr "POSLE optimizacije"
412
 
413
+ #: rvg-optimize-db.php:1066
414
  msgid "SAVINGS THIS TIME"
415
  msgstr "KOLIKO JE SAČUVANO STAVKI OVOG PUTA"
416
 
417
+ #: rvg-optimize-db.php:1070
418
  msgid "TOTAL SAVINGS SINCE THE FIRST RUN"
419
  msgstr "UKUPNO SAČUVANIH STAVKI OD PRVOG POKRETANJA"
420
 
421
+ #: rvg-optimize-db.php:1083
422
  msgid "DONE"
423
  msgstr "URAĐENO"
424
 
425
+ #: rvg-optimize-db.php:1654
426
+ msgid "InnoDB table: skipped..."
427
+ msgstr ""
428
+
429
+ #: rvg-optimize-db.php:1660
430
+ msgid "TABLE OPTIMIZED!"
431
+ msgstr ""
432
+
433
+ #: rvg-optimize-db.php:1739
434
  msgid "time"
435
  msgstr "vreme"
436
 
437
+ #: rvg-optimize-db.php:1740
438
  msgid "deleted<br />revisions"
439
  msgstr "obrisane <br />revizije"
440
 
441
+ #: rvg-optimize-db.php:1741
442
  msgid "deleted<br />trash"
443
  msgstr "obrisano <br /> iz korpe za otpatke "
444
 
445
+ #: rvg-optimize-db.php:1742
446
  msgid "deleted<br />spam"
447
  msgstr "obrisani <br />spam"
448
 
449
+ #: rvg-optimize-db.php:1743
450
  msgid "deleted<br />tags"
451
  msgstr "obrisane <br /> oznake"
452
 
453
+ #: rvg-optimize-db.php:1744
454
  msgid "deleted<br />transients"
455
  msgstr "obrisane <br /> prolazne stavke"
456
 
457
+ #: rvg-optimize-db.php:1745
458
+ msgid "deleted<br />pingbacks<br />trackbacks"
459
+ msgstr ""
460
+
461
+ #: rvg-optimize-db.php:1746
462
  msgid "deleted<br />orphans"
463
  msgstr "obrisani <br /> siročići"
464
 
465
  # @ rvg-optimize-database
466
+ #: rvg-optimize-db.php:1747
467
  msgid "nr of optimized tables"
468
  msgstr "broj optimizovanih tabela"
469
 
470
+ #: rvg-optimize-db.php:1748
471
  msgid "database size BEFORE"
472
  msgstr "baza podataka PRE"
473
 
474
+ #: rvg-optimize-db.php:1749
475
  msgid "database size AFTER"
476
  msgstr "baza podataka POSLE"
477
+
478
+ # @ default
479
+ #~ msgid "Optimize DB Options"
480
+ #~ msgstr "Optimize DB opcije"
481
+
482
+ #~ msgid "Optimize Database after Deleting Revisions OPTIONS UPDATED"
483
+ #~ msgstr "Optimize Database after Deleting Revisions OPCIJE AŽURIRANE"
484
+
485
+ #~ msgid ""
486
+ #~ "Click <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-weight:"
487
+ #~ "bold\">HERE</a> to run the optimization"
488
+ #~ msgstr ""
489
+ #~ "Kliknite <a href=\"tools.php?page=rvg-optimize-db.php\" style=\"font-"
490
+ #~ "weight:bold\">OVDE</a> da biste pokrenuli optimizaciju "
491
+
492
+ #~ msgid "To start the optimization:"
493
+ #~ msgstr "Da biste započeli optimizaciju:"
494
+
495
+ #~ msgid ""
496
+ #~ "<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; "
497
+ #~ "<strong>Optimize Database</strong>. Then click the '<strong>Start "
498
+ #~ "Optimization</strong>'-button. Et voila!"
499
+ #~ msgstr ""
500
+ #~ "<strong>WP Admin Panel</strong> &raquo; <strong>Alati</strong> &raquo; "
501
+ #~ "<strong>Optimizuj bazu podataka</strong>. Zatim kliknite na<strong>Počni "
502
+ #~ "optimizaciju</strong>'-taster. To je to!"
503
+
504
+ #~ msgid ""
505
+ #~ "Note: if you use the Scheduler the Optimization will run automatically!"
506
+ #~ msgstr ""
507
+ #~ "Napomena: ako koristite planer, optimizacija će se pokrenuti automatski"
508
+
509
+ #~ msgid "Optimize Database after Deleting Revisions - Options"
510
+ #~ msgstr "Optimize Database after Deleting Revisions - Opcije"
511
+
512
+ #~ msgid ""
513
+ #~ "EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style=\"text-decoration:"
514
+ #~ "underline;color:#F00;\">CHECKED</span> TABLES <span style=\"text-"
515
+ #~ "decoration:underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</span>"
516
+ #~ msgstr ""
517
+ #~ "ISKLJUČI TABELE BAZE PODATAKA IZ OPTIMIZACIJE: <span style=\"text-"
518
+ #~ "decoration:underline;color:#F00;\">CHECKED</span> TABLES <span style="
519
+ #~ "\"text-decoration:underline;color:#F00;\">WON'T</span> BE OPTIMIZED!</"
520
+ #~ "span>"
521
+
522
+ #~ msgid "Save Options"
523
+ #~ msgstr "Sačuvaj opcije"
524
+
525
+ #~ msgid "Current options"
526
+ #~ msgstr "Trenutne opcije"
527
+
528
+ #~ msgid "Change Options"
529
+ #~ msgstr "Promeni opcije"
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.1.1
11
- Stable tag: 3.1.3
12
- Version: 3.1.3
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -42,6 +42,7 @@ Note: you also can click the 'Optimize DB (1 click)' link in the admin bar (if e
42
  * English [en_US] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
43
  * Dutch [nl_NL] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
44
  * Serbian [sr_RS] - translated by Ogi Djuraskovic, FirstSiteGuide - http://firstsiteguide.com
 
45
 
46
  = Author =
47
  CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl
@@ -66,6 +67,13 @@ http://cagewebdev.com/index.php/wordpress-plugins/
66
  * Change the settings (if needed) in the WP Admin Panel &raquo; Settings &raquo; Optimize Database -or- via the WP Admin Panel &raquo; Optimize Database icon (depends on settings)
67
 
68
  == Changelog ==
 
 
 
 
 
 
 
69
  = 3.1.3 [02/21/2015] =
70
  * NEW: showing the icon in the admin menu is now configurable via the settings page
71
 
@@ -261,8 +269,8 @@ http://cagewebdev.com/index.php/wordpress-plugins/
261
  * WP Admin Panel &raquo; Optimize Database. Then click the 'Start Optimization'-button -or- via the WP Admin Panel &raquo; Optimize Database icon (depends on settings)
262
  * Click the 'Optimize DB (1 click)' link in the Admin Bar (if enabled)
263
 
264
- = Why do I see 'Table does not support optimize, doing recreate + analyze instead' while optimizing my database? =
265
- * That is because the table type of that table is not 'MyISAM'
266
 
267
  = I scheduled the optimization for 8pm but it runs at 6pm (my local time) =
268
  * The scheduler uses the local time of the web server which can differ from your own local time
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
  Requires at least: 2.8
10
  Tested up to: 4.1.1
11
+ Stable tag: 3.1.4
12
+ Version: 3.1.4
13
  License: GPLv2 or later
14
 
15
  == Description ==
42
  * English [en_US] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
43
  * Dutch [nl_NL] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
44
  * Serbian [sr_RS] - translated by Ogi Djuraskovic, FirstSiteGuide - http://firstsiteguide.com
45
+ * Italian [it_IT] - translated by Fabio Marzocca
46
 
47
  = Author =
48
  CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl
67
  * Change the settings (if needed) in the WP Admin Panel &raquo; Settings &raquo; Optimize Database -or- via the WP Admin Panel &raquo; Optimize Database icon (depends on settings)
68
 
69
  == Changelog ==
70
+ = 3.1.4 [03/01/2015] =
71
+ * NEW: italian language support [it_IT] added (thanks Fabio Marzocca!)
72
+ * NEW: optimization timer
73
+ * CHANGE: from now on InnoDB tables are skipped from optimization
74
+ * CHANGE: various minor improvements
75
+ * BUG FIX: removed strtolower while fetching database properties
76
+
77
  = 3.1.3 [02/21/2015] =
78
  * NEW: showing the icon in the admin menu is now configurable via the settings page
79
 
269
  * WP Admin Panel &raquo; Optimize Database. Then click the 'Start Optimization'-button -or- via the WP Admin Panel &raquo; Optimize Database icon (depends on settings)
270
  * Click the 'Optimize DB (1 click)' link in the Admin Bar (if enabled)
271
 
272
+ = Why do I see 'InnoDB table: skipped...'? =
273
+ * That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
274
 
275
  = I scheduled the optimization for 8pm but it runs at 6pm (my local time) =
276
  * The scheduler uses the local time of the web server which can differ from your own local time
rvg-optimize-db.php CHANGED
@@ -1,9 +1,9 @@
1
  <?php
2
- $odb_version = '3.1.3';
3
- $odb_release_date = '02/21/2015';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 3.1.3
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
@@ -11,7 +11,7 @@ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-rev
11
  Description: Optimizes the Wordpress Database after Cleaning it out
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
  Author URI: http://cagewebdev.com
14
- Version: 3.1.3
15
  */
16
 
17
  /********************************************************************************************
@@ -128,12 +128,16 @@ add_filter('plugin_action_links_'.plugin_basename(__FILE__), 'odb_settings_link'
128
  *********************************************************************************************/
129
  function rvg_odb_admin_bar()
130
  { global $wp_admin_bar;
131
- if ( !is_super_admin() || !is_admin_bar_showing() ) return;
132
  $siteurl = site_url('/');
133
- $wp_admin_bar->add_menu( array('id' => 'optimize','title' => __('Optimize DB (1 click)','rvg-optimize-database'),'href' => $siteurl.'wp-admin/tools.php?page=rvg-optimize-db.php&action=run' ) );
 
 
 
 
134
  }
135
  $rvg_odb_adminbar = get_option('rvg_odb_adminbar');
136
- if($rvg_odb_adminbar == "Y") add_action( 'wp_before_admin_bar_render', 'rvg_odb_admin_bar' );
137
 
138
 
139
  /********************************************************************************************
@@ -158,7 +162,7 @@ function rvg_extra_schedules( $schedules ) {
158
  // ADD A WEEKLY SCHEDULE
159
  $schedules['weekly'] = array(
160
  'interval' => 604800,
161
- 'display' => __('Once Weekly')
162
  );
163
  return $schedules;
164
  }
@@ -210,19 +214,19 @@ function rvg_odb_settings_page()
210
 
211
  # DELETE ALL EXCLUDED TABLES
212
  $sql = "
213
- DELETE FROM $wpdb->options
214
- WHERE `option_name` LIKE 'rvg_ex_%'
215
  ";
216
- $wpdb -> get_results($sql);
217
 
218
  # ADD EXCLUDED TABLES
219
  foreach ($_POST as $key => $value)
220
  { if(substr($key,0,3) == 'cb_')
221
  { $sql = "
222
  INSERT INTO $wpdb->options (option_name, option_value, autoload)
223
- VALUES ('rvg_ex_".substr($key,3)."','excluded','yes')
224
  ";
225
- $wpdb -> get_results($sql);
226
  }
227
  }
228
 
@@ -352,33 +356,34 @@ function rvg_odb_settings_page()
352
  ?>
353
  <script type="text/javascript">
354
  function schedule_changed()
355
- { // v2.8.3
356
- if(document.options.rvg_odb_schedule.value == 'daily' || document.options.rvg_odb_schedule.value == 'weekly')
357
  jQuery("#schedulehour").show();
358
  else
359
  jQuery("#schedulehour").hide();
360
  }
361
  </script>
362
 
363
- <form name="options" method="post" action="">
364
- <?php // v2.8.3 ?>
365
- <?php wp_nonce_field( 'odb_action','odb_nonce' ); ?>
366
- <div class="wrap">
367
- <h2><?php echo __('Using Optimize Database after Deleting Revisions', 'rvg-optimize-database'); ?></h2>
368
- <blockquote>
369
- <p class="odb-bold">'<span class="odb-italic">Optimize Database after Deleting Revisions</span> ' <?php echo __('is an one-click plugin to clean and optimize your WordPress database','rvg-optimize-database');?></p>
370
- <p><?php echo __('Plugin version:','rvg-optimize-database');?><br />
371
- <span class="odb-bold">v<?php echo $odb_version ?> (<?php echo $odb_release_date?>)</span></p>
372
- <p><span class="odb-bold"><?php echo __('Author','rvg-optimize-database');?>:</span><br />
373
- <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, <?php echo __('The Netherlands','rvg-optimize-database');?><br />
374
- <span class="odb-bold"><?php echo __('Plugin URL:','rvg-optimize-database');?></class><br />
375
- <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/</class></a><br />
376
- <span class="odb-bold"><?php echo __('Download URL:','rvg-optimize-database');?></class><br />
377
- <span class="odb-bold"><a href="https://wordpress.org/plugins/rvg-optimize-database/" target="_blank">https://wordpress.org/plugins/rvg-optimize-database/</a></class></p>
378
- <p>&nbsp;</p>
379
- </blockquote>
380
- <h2><?php echo __('Optimize Database after Deleting Revisions - Settings','rvg-optimize-database');?></h2>
381
- <?php
 
382
  if($rvg_odb_adminbar == 'Y') $rvg_odb_adminbar_checked = ' checked="checked"'; else $rvg_odb_adminbar_checked = '';
383
  if($rvg_odb_adminmenu == 'Y') $rvg_odb_adminmenu_checked = ' checked="checked"'; else $rvg_odb_adminmenu_checked = '';
384
  if($rvg_clear_trash == 'Y') $rvg_clear_trash_checked = ' checked="checked"'; else $rvg_clear_trash_checked = '';
@@ -389,95 +394,95 @@ if($rvg_clear_transients == 'Y') $rvg_clear_transients_checked = ' checked="ch
389
  if($rvg_clear_pingbacks == 'Y') $rvg_clear_pingbacks_checked = ' checked="checked"'; else $rvg_clear_pingbacks_checked = '';
390
  if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checked"'; else $rvg_odb_logging_on_checked = '';
391
  ?>
392
- <blockquote>
393
- <fieldset class='options'>
394
- <table class="editform" cellspacing="2" cellpadding="5" width="100%">
395
- <tr>
396
- <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="4">
397
- <tr>
398
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?><br />
399
- <?php echo __('(\'0\' means: delete <u>ALL</u> revisions)','rvg-optimize-database');?></span></td>
400
- <td width="50%" valign="top"><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" class="odb-bold odb-blue" /></td>
401
- </tr>
402
- <tr>
403
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete all trashed items','rvg-optimize-database');?></span></td>
404
- <td width="50%" valign="top"><input name="rvg_clear_trash" type="checkbox" value="Y" <?php echo $rvg_clear_trash_checked?> /></td>
405
- </tr>
406
- <tr>
407
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete all spammed items','rvg-optimize-database');?></span></td>
408
- <td width="50%" valign="top"><input name="rvg_clear_spam" type="checkbox" value="Y" <?php echo $rvg_clear_spam_checked?> /></td>
409
- </tr>
410
- <tr>
411
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete unused tags','rvg-optimize-database');?></span></td>
412
- <td width="50%" valign="top"><input name="rvg_clear_tags" type="checkbox" value="Y" <?php echo $rvg_clear_tags_checked?> /></td>
413
- </tr>
414
- <tr>
415
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete expired transients','rvg-optimize-database');?></span></td>
416
- <td width="50%" valign="top"><input name="rvg_clear_transients" type="checkbox" value="Y" <?php echo $rvg_clear_transients_checked?> /></td>
417
- </tr>
418
- <tr>
419
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete pingbacks and trackbacks','rvg-optimize-database');?></span></td>
420
- <td width="50%" valign="top"><input name="rvg_clear_pingbacks" type="checkbox" value="Y" <?php echo $rvg_clear_pingbacks_checked?> /></td>
421
- </tr>
422
- <tr>
423
- <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Keep a log','rvg-optimize-database');?></span></td>
424
- <td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" <?php echo $rvg_odb_logging_on_checked?> /></td>
425
- </tr>
426
- <tr>
427
- <td width="50%" align="right"><span class="odb-bold"><?php echo __('Scheduler','rvg-optimize-database');?></span></td>
428
- <td width="50%"><select name="rvg_odb_schedule" id="rvg_odb_schedule" onchange="schedule_changed();">
429
- <option selected="selected" value=""><?php echo __('NOT SCHEDULED','rvg-optimize-database');?></option>
430
- <option value="hourly"><?php echo __('run optimization HOURLY','rvg-optimize-database');?></option>
431
- <option value="twicedaily"><?php echo __('run optimization TWICE A DAY','rvg-optimize-database');?></option>
432
- <option value="daily"><?php echo __('run optimization DAILY','rvg-optimize-database');?></option>
433
- <option value="weekly"><?php echo __('run optimization WEEKLY','rvg-optimize-database');?></option>
434
- <?php /*?><option value="test">run optimization TEST</option><?php */?>
435
- </select>
436
- <script type="text/javascript">
437
- document.options.rvg_odb_schedule.value = '<?php echo $rvg_odb_schedule; ?>';
438
  </script>
439
- <span id="schedulehour" style="display:none;"> <span class="odb-bold"><?php echo __('Time','rvg-optimize-database');?></span>
440
- <select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour">
441
- <?php
442
  for($i=0; $i<=23; $i++)
443
  { if($i<10) $i = '0'.$i;
444
  ?>
445
- <option value="<?php echo $i?>"><?php echo $i.':00 '.__('hrs','rvg-optimize-database')?></option>
446
- <?php
447
  }
448
  ?>
449
- </select>
450
- <script type="text/javascript">
451
- document.options.rvg_odb_schedulehour.value = '<?php echo $rvg_odb_schedulehour; ?>';
452
  </script>
453
- </span>
454
- <script type="text/javascript">schedule_changed();</script></td>
455
- </tr>
456
- <tr>
457
- <td align="right" valign="top"><span class="odb-bold"><?php echo __('Show \'1-click\' link in Admin Bar','rvg-optimize-database');?></span></td>
458
- <td valign="top"><input name="rvg_odb_adminbar" type="checkbox" value="Y" <?php echo $rvg_odb_adminbar_checked?> />
459
- <?php echo __('(change will be visible after loading the next page)','rvg-optimize-database');?></td>
460
- </tr>
461
- <tr>
462
- <td align="right" valign="top"><span class="odb-bold"><?php echo __('Show an icon in the Admin Menu','rvg-optimize-database');?></span></td>
463
- <td valign="top"><input name="rvg_odb_adminmenu" type="checkbox" value="Y" <?php echo $rvg_odb_adminmenu_checked?> />
464
- <?php echo __('(change will be visible after loading the next page)','rvg-optimize-database');?></td>
465
- </tr>
466
- </table></td>
467
- </tr>
468
- <?php
469
  # v2.8.2
470
- $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`",ARRAY_N);
471
  # v2.8.3 $ replaced by jQuery
472
  ?>
473
- <tr>
474
- <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
475
- <tr>
476
- <td colspan="4" align="center"><span class="odb-bold"><?php echo __('EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class="odb-underline-red">CHECKED</span> TABLES <span class="odb-underline-red">WON\'T</span> BE OPTIMIZED!</span>','rvg-optimize-database');?><br />
477
- <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',true);"><?php echo __('check all tables','rvg-optimize-database');?></a> | <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',false);"><?php echo __('uncheck all tables','rvg-optimize-database');?></a> | <a href="javascript:;" onclick="jQuery(':not([id^=cb_<?php echo $table_prefix; ?>])').filter('[id^=cb_]').attr('checked',true);"><?php echo __('check all NON-WordPress tables','rvg-optimize-database');?></a></td>
478
- </tr>
479
- <tr>
480
- <?php
481
  $c = 0;
482
  $t = 0;
483
  # v2.8.2
@@ -495,29 +500,31 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
495
 
496
  $cb_checked = '';
497
  $sql = "
498
- SELECT `option_value`
499
- FROM $wpdb->options
500
- WHERE `option_name` = 'rvg_ex_".$tables[$i][0]."'
501
  ";
502
- $results = $wpdb -> get_results($sql);
503
  if(isset($results[0]->option_value))
504
  if($results[0]->option_value == 'excluded') $cb_checked = ' checked';
505
  echo '<td width="25%" '.$class.'><input id="cb_'.$tables[$i][0].'" name="cb_'.$tables[$i][0].'" type="checkbox" value="1" '.$cb_checked.' /> '.$tables[$i][0].'</td>'."\n";
506
  } # for ($i=0; $i<count($tables); $i++)
507
  ?>
508
- </tr>
509
- </table></td>
510
- </tr>
511
- </table>
512
- </fieldset>
513
- </blockquote>
514
- <p class="submit">
515
- <input class="button-primary button-large" type='submit' name='info_update' value='<?php echo __('Save Settings','rvg-optimize-database');?>' class="odb-bold" />
516
- &nbsp;
517
- <input class="button odb-normal" type="button" name="optimizer" value="<?php echo __('Go To Optimizer','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php'" />
518
- </p>
519
- </div>
520
- </form>
 
 
521
  <?php
522
  } // rvg_odb_settings_page ()
523
 
@@ -530,7 +537,13 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
530
  *********************************************************************************************/
531
  function rvg_optimize_db()
532
  {
533
- global $wpdb, $odb_version, $table_prefix;
 
 
 
 
 
 
534
 
535
  $timezone_format = _x('G:i', 'timezone date format');
536
  $current_hour = date_i18n($timezone_format);
@@ -630,41 +643,41 @@ function rvg_optimize_db()
630
  FROM $wpdb->options
631
  WHERE option_name LIKE 'rvg_ex_%'
632
  ";
633
- $results = $wpdb -> get_results($sql);
634
- $number_excluded = $results[0] -> cnt;
635
  ?>
636
  <div class="odb-padding-left">
637
  <h2><?php echo __('Optimize your WordPress Database','rvg-optimize-database');?></h2>
638
  <?php
639
  if(isset($_REQUEST['action']))
640
  if($_REQUEST['action'] == "delete_log")
641
- echo '<div class="updated odb-updated"><p><span class="odb-bold">Optimize Database after Deleting Revisions - LOG FILE DELETED</class></p></div>';
642
  ?>
643
  <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> - <?php echo __('A WordPress Plugin by','rvg-optimize-database');?> <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, <?php echo __('The Netherlands','rvg-optimize-database');?></span></p>
644
  <p><?php echo __('Current settings','rvg-optimize-database');?>:<br />
645
- <span class="odb-bold"><?php echo __('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $max_revisions?></span><br />
646
- <span class="odb-bold"><?php echo __('Delete all trashed items','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $clear_trash_yn?></span><br />
647
- <span class="odb-bold"><?php echo __('Delete all spammed items','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $clear_spam_yn?></span><br />
648
- <span class="odb-bold"><?php echo __('Delete unused tags','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $clear_tags_yn?></span><br />
649
- <span class="odb-bold"><?php echo __('Delete expired transients','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $clear_transients_yn?></span><br />
650
- <span class="odb-bold"><?php echo __('Delete pingbacks and trackbacks','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $clear_pingbacks_yn?></span><br />
651
- <span class="odb-bold"><?php echo __('Keep a log','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $rvg_odb_logging_on_yn?></span><br />
652
- <span class="odb-bold"><?php echo __('Number of excluded tables','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $number_excluded?></span><br />
653
- <span class="odb-bold"><?php echo __('Scheduler','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $rvg_odb_schedule_txt?></span>
654
- <?php
655
  if($nextrun)
656
  {
657
  ?>
658
- <br />
659
- <span class="odb-bold"><?php echo __('Next scheduled run','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo $nextrun?> hrs (current server time: <?php echo $current_hour?>)</span>
660
- <?php
661
  }
662
  if($total_savings)
663
  {
664
  ?>
665
- <br />
666
- <span class="odb-bold"><?php echo __('Total savings since the first run','rvg-optimize-database');?>:</class> <span class="odb-bold odb-blue"><?php echo rvg_format_size($total_savings); ?></span>
667
- <?php
668
  }
669
  ?>
670
  <p class="submit">
@@ -999,24 +1012,25 @@ function rvg_optimize_db()
999
  ******************************************************************************************/
1000
  ?>
1001
  <div class="odb-separator"></div>
1002
- <table border="0" cellspacing="8" cellpadding="2">
1003
- <tr>
1004
- <td colspan="4" class="odb-bold odb-blue"><?php echo __('OPTIMIZING DATABASE TABLES','rvg-optimize-database');?>:</td>
1005
- </tr>
1006
- <tr>
1007
- <th class="odb-border-bottom" align="right">#</th>
1008
- <th class="odb-border-bottom" align="left"><?php echo __('table name','rvg-optimize-database');?></th>
1009
- <th class="odb-border-bottom" align="left"><?php echo __('optimization result','rvg-optimize-database');?></th>
1010
- <th class="odb-border-bottom" align="left"><?php echo __('engine','rvg-optimize-database');?></th>
1011
- <th class="odb-border-bottom" align="right"><?php echo __('table rows','rvg-optimize-database');?></th>
1012
- <th class="odb-border-bottom" align="right"><?php echo __('table size','rvg-optimize-database');?></th>
1013
- </tr>
1014
- <?php
 
1015
  # OPTIMIZE THE DATABASE TABLES
1016
  $cnt = rvg_optimize_tables(true);
1017
  ?>
1018
- </table>
1019
- <?php
1020
  // NUMBER OF TABLES
1021
  $log_arr["tables"] = $cnt;
1022
  // DATABASE SIZE BEFORE OPTIMIZATION
@@ -1033,37 +1047,48 @@ function rvg_optimize_db()
1033
  $total_savings += ($start_size - $end_size);
1034
  update_option('rvg_odb_total_savings',$total_savings);
1035
  ?>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1036
  <div class="odb-separator"></div>
1037
- <span class="odb-bold odb-blue odb-padding-left"><?php echo __('SAVINGS','rvg-optimize-database');?>!</span><br />
1038
- <table border="0" cellspacing="8" cellpadding="2">
1039
- <tr>
1040
- <th>&nbsp;</th>
1041
- <th class="odb-border-bottom"><?php echo __('size of the database','rvg-optimize-database');?></th>
1042
- </tr>
1043
- <tr>
1044
- <td align="right"><?php echo __('BEFORE optimization','rvg-optimize-database');?></td>
1045
- <td align="right" class="odb-bold"><?php echo rvg_format_size($start_size,3); ?></td>
1046
- </tr>
1047
- <tr>
1048
- <td align="right"><?php echo __('AFTER optimization','rvg-optimize-database');?></td>
1049
- <td align="right" class="odb-bold"><?php echo rvg_format_size($end_size,3); ?></td>
1050
- </tr>
1051
- <tr>
1052
- <td align="right" class="odb-bold"><?php echo __('SAVINGS THIS TIME','rvg-optimize-database');?></td>
1053
- <td align="right" class="odb-border-top odb-bold"><?php echo rvg_format_size(($start_size - $end_size),3); ?></td>
1054
- </tr>
1055
- <tr>
1056
- <td align="right" class="odb-bold"><?php echo __('TOTAL SAVINGS SINCE THE FIRST RUN','rvg-optimize-database');?></td>
1057
- <td align="right" class="odb-border-top odb-bold"><?php echo rvg_format_size($total_savings,3); ?></td>
1058
- </tr>
1059
- </table>
1060
- <div class="odb-separator"></div>
1061
  <span class="odb-bold odb-blue odb-padding-left"><?php echo __('DONE','rvg-optimize-database');?>!</span><br />
1062
  <br />
 
1063
  <?php
1064
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
1065
  {
1066
  ?>
 
 
1067
  &nbsp;
1068
  <input class="button odb-normal" type="button" name="view_log" value="<?php echo __('View Log File','rvg-optimize-database');?>" onclick="window.open('<?php echo $log_url?>')" />
1069
  &nbsp;
@@ -1080,7 +1105,7 @@ function rvg_optimize_db()
1080
  *********************************************************************************************/
1081
  function rvg_optimize_db_cron()
1082
  {
1083
- global $wpdb, $odb_version, $table_prefix;
1084
 
1085
  // GET SETTINGS AND SET DEFAULT VALUES
1086
  $max_revisions = get_option('rvg_odb_number');
@@ -1243,13 +1268,13 @@ function rvg_delete_revisions($results, $display, $max_revisions)
1243
  } // if($display)
1244
 
1245
  $sql_get_posts = "
1246
- SELECT `ID`, `post_modified`
1247
- FROM $wpdb->posts
1248
- WHERE `post_parent`=".$results[$i]->post_parent."
1249
- AND `post_type`='revision'
1250
- ORDER BY `post_modified` ASC
1251
  ";
1252
- $results_get_posts = $wpdb -> get_results($sql_get_posts);
1253
 
1254
  for($j=0; $j<$nr_to_delete; $j++)
1255
  {
@@ -1257,9 +1282,9 @@ function rvg_delete_revisions($results, $display, $max_revisions)
1257
 
1258
  $sql_delete = "
1259
  DELETE FROM $wpdb->posts
1260
- WHERE `ID` = ".$results_get_posts[$j]->ID."
1261
  ";
1262
- $wpdb -> get_results($sql_delete);
1263
 
1264
  } // for($j=0; $j<$nr_to_delete; $j++)
1265
 
@@ -1302,9 +1327,10 @@ function rvg_delete_trash($results, $display)
1302
  if($results[$i]->post_type == 'comment')
1303
  { // DELETE META DATA (IF ANY...)
1304
  $sql_delete = "
1305
- DELETE FROM $wpdb->commentmeta WHERE `comment_id` = ".$results[$i]->id."
 
1306
  ";
1307
- $wpdb -> get_results($sql_delete);
1308
  }
1309
 
1310
  $nr++;
@@ -1312,15 +1338,17 @@ function rvg_delete_trash($results, $display)
1312
 
1313
  // DELETE TRASHED POSTS / PAGES
1314
  $sql_delete = "
1315
- DELETE FROM $wpdb->posts WHERE `post_status` = 'trash'
 
1316
  ";
1317
- $wpdb -> get_results($sql_delete);
1318
 
1319
  // DELETE TRASHED COMMENTS
1320
  $sql_delete = "
1321
- DELETE FROM $wpdb->comments WHERE `comment_approved` = 'trash'
 
1322
  ";
1323
- $wpdb -> get_results($sql_delete);
1324
 
1325
  return $total_deleted;
1326
 
@@ -1351,16 +1379,18 @@ function rvg_delete_spam($results, $display)
1351
  <?php
1352
  } // if($display)
1353
  $sql_delete = "
1354
- DELETE FROM $wpdb->commentmeta WHERE `comment_id` = ".$results[$i]->comment_ID."
 
1355
  ";
1356
- $wpdb -> get_results($sql_delete);
1357
  $nr++;
1358
  } // for($i=0; $i<count($results); $i++)
1359
 
1360
  $sql_delete = "
1361
- DELETE FROM $wpdb->comments WHERE `comment_approved` = 'spam'
 
1362
  ";
1363
- $wpdb -> get_results($sql_delete);
1364
 
1365
  return $total_deleted;
1366
 
@@ -1402,13 +1432,13 @@ function rvg_delete_tags_is_scheduled($term_id)
1402
  global $wpdb;
1403
 
1404
  $sql_get_posts = "
1405
- SELECT p.post_status
1406
- FROM $wpdb->term_relationships t, $wpdb->posts p
1407
- WHERE t.term_taxonomy_id = '".$term_id."'
1408
- AND t.object_id = p.ID
1409
  ";
1410
 
1411
- $results_get_posts = $wpdb -> get_results($sql_get_posts);
1412
  for($i=0; $i<count($results_get_posts); $i++)
1413
  if($results_get_posts[$i]->post_status == 'future') return true;
1414
 
@@ -1441,7 +1471,7 @@ function rvg_delete_transients()
1441
  AND option_value < '$delay'
1442
  ";
1443
 
1444
- $results = $wpdb -> get_results($sql);
1445
  $total_deleted = count($results);
1446
 
1447
  $sql = "
@@ -1454,7 +1484,7 @@ function rvg_delete_transients()
1454
  AND option_value < '$delay'
1455
  ";
1456
 
1457
- $wpdb -> get_results($sql);
1458
 
1459
  $sql = "
1460
  SELECT *
@@ -1466,7 +1496,7 @@ function rvg_delete_transients()
1466
  AND option_value < '$delay'
1467
  ";
1468
 
1469
- $results = $wpdb -> get_results($sql);
1470
  $total_deleted += count($results);
1471
 
1472
  $sql = "
@@ -1478,7 +1508,7 @@ function rvg_delete_transients()
1478
  AND option_value < '$delay'
1479
  ";
1480
 
1481
- $wpdb -> get_results($sql);
1482
 
1483
  return $total_deleted;
1484
  } // rvg_delete_transients ()
@@ -1504,16 +1534,16 @@ function rvg_delete_pingbacks()
1504
  )
1505
  ";
1506
 
1507
- $results = $wpdb -> get_results($sql);
1508
  $total_deleted = count($results);
1509
 
1510
  for($i=0; $i<count($results); $i++)
1511
  { // DELETE METADATA FOR THIS COMMENT (IF ANY)
1512
  $sql_delete_meta = "
1513
  DELETE FROM $wpdb->commentmeta
1514
- WHERE `comment_id` = ".$results[$i] -> comment_ID."
1515
  ";
1516
- $wpdb -> get_results($sql_delete_meta);
1517
  }
1518
 
1519
  $sql_delete_comments = "
@@ -1523,7 +1553,7 @@ function rvg_delete_pingbacks()
1523
  OR `comment_type` = 'trackback'
1524
  )
1525
  ";
1526
- $wpdb -> get_results($sql_delete_comments);
1527
 
1528
  return $total_deleted;
1529
  } // rvg_delete_pingbacks ()
@@ -1545,41 +1575,41 @@ function rvg_delete_orphans($display)
1545
  // DELETE POST ORPHANS (AUTO DRAFTS)
1546
  $sql_delete = "
1547
  SELECT COUNT(*) cnt
1548
- FROM $wpdb->posts
1549
- WHERE ID NOT IN (SELECT post_id FROM $wpdb->postmeta)
1550
- AND post_status = 'auto-draft'
1551
  ";
1552
 
1553
- $results = $wpdb -> get_results($sql_delete);
1554
 
1555
- $post_orphans = $results[0] -> cnt;
1556
 
1557
  if($post_orphans > 0)
1558
  { $sql_delete = "
1559
  DELETE FROM $wpdb->posts
1560
- WHERE ID NOT IN (SELECT post_id FROM $wpdb->postmeta)
1561
- AND post_status = 'auto-draft'
1562
  ";
1563
- $wpdb -> get_results($sql_delete);
1564
  }
1565
 
1566
  // DELETE POSTMETA ORPHANS
1567
  $sql_delete = "
1568
  SELECT COUNT(*) cnt
1569
- FROM $wpdb->postmeta
1570
- WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)
1571
  ";
1572
 
1573
- $results = $wpdb -> get_results($sql_delete);
1574
 
1575
- $meta_orphans = $results[0] -> cnt;
1576
 
1577
  if($meta_orphans > 0)
1578
  { $sql_delete = "
1579
  DELETE FROM $wpdb->postmeta
1580
- WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)
1581
  ";
1582
- $wpdb -> get_results($sql_delete);
1583
  }
1584
 
1585
  return ($meta_orphans + $post_orphans);
@@ -1594,13 +1624,13 @@ function rvg_delete_orphans($display)
1594
  *********************************************************************************************/
1595
  function rvg_optimize_tables($display)
1596
  {
1597
- global $wpdb, $table_prefix;
1598
 
1599
  # v2.8.2
1600
- $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`",ARRAY_N);
1601
  // print_r($tables);
1602
 
1603
- $cnt = 0;
1604
  for ($i=0; $i<count($tables); $i++)
1605
  {
1606
  $excluded = get_option('rvg_ex_'.$tables[$i][0]);
@@ -1608,28 +1638,36 @@ function rvg_optimize_tables($display)
1608
  if(!$excluded)
1609
  { # TABLE NOT EXCLUDED
1610
  $cnt++;
1611
- $query = "OPTIMIZE TABLE ".$tables[$i][0];
1612
- $result = $wpdb -> get_results($query);
1613
-
1614
- // v2.7.5
1615
  $sql = "
1616
- SELECT engine, (
1617
- data_length + index_length
1618
- ) AS size, table_rows
1619
- FROM information_schema.TABLES
1620
- WHERE table_schema = '".strtolower(DB_NAME)."'
1621
- AND table_name = '".$tables[$i][0]."'
1622
  ";
 
1623
 
1624
- $table_info = $wpdb -> get_results($sql);
 
 
 
 
 
 
 
 
 
 
 
1625
 
1626
  if($display)
1627
- {
1628
  ?>
1629
  <tr>
1630
  <td align="right" valign="top"><?php echo $cnt?>.</td>
1631
  <td valign="top" class="odb-bold"><?php echo $tables[$i][0] ?></td>
1632
- <td valign="top"><?php echo $result[0]->Msg_text ?></td>
1633
  <td valign="top"><?php echo $table_info[0]->engine ?></td>
1634
  <td align="right" valign="top"><?php echo $table_info[0]->table_rows ?></td>
1635
  <td align="right" valign="top"><?php echo rvg_format_size($table_info[0]->size) ?></td>
@@ -1695,7 +1733,7 @@ td {
1695
  <body>
1696
  <div id="header">
1697
  <h2><a href="https://wordpress.org/plugins/rvg-optimize-database/" target="_blank">Optimize Database after Deleting Revisions v'.$odb_version.'</a></h2>
1698
- '.__('A WordPress Plugin by','rvg-optimize-database').' <a href="http://cagewebdev.com" target="_blank"><span class="odb-bold">CAGE Web Design</class></a> | <a href="http://rvg.cage.nl" target="_blank"><span class="odb-bold">Rolf van Gelder</class></a>, Eindhoven, '.__('The Netherlands','rvg-optimize-database').'</class>
1699
  </div>
1700
  <table width="100%" border="0" cellspacing="6" cellpadding="1">
1701
  <tr>
@@ -1721,7 +1759,7 @@ td {
1721
  $html = '
1722
  <table width="100%" border="0" cellspacing="6" cellpadding="0">
1723
  <tr>
1724
- <td width="8%" valign="top"><span class="odb-bold">'.$log_arr["time"].'</class></td>
1725
  <td width="8%" align="right" valign="top">'.$log_arr["revisions"].'</td>
1726
  <td width="8%" align="right" valign="top">'.$log_arr["trash"].'</td>
1727
  <td width="8%" align="right" valign="top">'.$log_arr["spam"].'</td>
@@ -1754,15 +1792,15 @@ function rvg_get_revisions($max_revisions)
1754
  global $wpdb;
1755
 
1756
  $sql = "
1757
- SELECT `post_parent`, `post_title`, COUNT(*) cnt
1758
- FROM $wpdb->posts
1759
- WHERE `post_type` = 'revision'
1760
- GROUP BY `post_parent`
1761
- HAVING COUNT(*) > ".$max_revisions."
1762
- ORDER BY UCASE(`post_title`)
1763
  ";
1764
 
1765
- return $wpdb -> get_results($sql);
1766
 
1767
  } // rvg_get_revisions ()
1768
 
@@ -1777,17 +1815,17 @@ function rvg_get_trash()
1777
  global $wpdb;
1778
 
1779
  $sql = "
1780
- SELECT `ID` AS id, 'post' AS post_type, `post_title` AS title, `post_modified` AS modified
1781
- FROM $wpdb->posts
1782
- WHERE `post_status` = 'trash'
1783
  UNION ALL
1784
- SELECT `comment_ID` AS id, 'comment' AS post_type, `comment_author_IP` AS title, `comment_date` AS modified
1785
- FROM $wpdb->comments
1786
- WHERE `comment_approved` = 'trash'
1787
- ORDER BY post_type, UCASE(title)
1788
  ";
1789
 
1790
- return $wpdb -> get_results($sql);
1791
 
1792
  } // rvg_get_trash ()
1793
 
@@ -1802,13 +1840,13 @@ function rvg_get_spam()
1802
  global $wpdb;
1803
 
1804
  $sql = "
1805
- SELECT `comment_ID`, `comment_author`, `comment_author_email`, `comment_date`
1806
- FROM $wpdb->comments
1807
- WHERE `comment_approved` = 'spam'
1808
- ORDER BY UCASE(`comment_author`)
1809
  ";
1810
 
1811
- return $wpdb -> get_results($sql);
1812
 
1813
  } // rvg_get_trash ()
1814
 
@@ -1821,16 +1859,16 @@ function rvg_get_spam()
1821
  function rvg_get_db_size()
1822
  {
1823
  global $wpdb;
1824
-
1825
- // v2.7.5
1826
  $sql = "
1827
- SELECT SUM( data_length + index_length ) size
1828
- FROM information_schema.TABLES
1829
- WHERE table_schema = '".strtolower(DB_NAME)."'
1830
  GROUP BY table_schema
1831
- ";
1832
 
1833
- $res = $wpdb -> get_results($sql);
1834
 
1835
  return $res[0]->size;
1836
 
1
  <?php
2
+ $odb_version = '3.1.4';
3
+ $odb_release_date = '03/01/2015';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 3.1.4
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
11
  Description: Optimizes the Wordpress Database after Cleaning it out
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
  Author URI: http://cagewebdev.com
14
+ Version: 3.1.4
15
  */
16
 
17
  /********************************************************************************************
128
  *********************************************************************************************/
129
  function rvg_odb_admin_bar()
130
  { global $wp_admin_bar;
131
+ if (!is_super_admin() || !is_admin_bar_showing()) return;
132
  $siteurl = site_url('/');
133
+ $wp_admin_bar->add_menu(
134
+ array(
135
+ 'id' => 'optimize',
136
+ 'title' => __('Optimize DB (1 click)','rvg-optimize-database'),
137
+ 'href' => $siteurl.'wp-admin/tools.php?page=rvg-optimize-db.php&action=run' ));
138
  }
139
  $rvg_odb_adminbar = get_option('rvg_odb_adminbar');
140
+ if($rvg_odb_adminbar == "Y") add_action('wp_before_admin_bar_render', 'rvg_odb_admin_bar');
141
 
142
 
143
  /********************************************************************************************
162
  // ADD A WEEKLY SCHEDULE
163
  $schedules['weekly'] = array(
164
  'interval' => 604800,
165
+ 'display' => __('Once Weekly')
166
  );
167
  return $schedules;
168
  }
214
 
215
  # DELETE ALL EXCLUDED TABLES
216
  $sql = "
217
+ DELETE FROM $wpdb->options
218
+ WHERE `option_name` LIKE 'rvg_ex_%'
219
  ";
220
+ $wpdb->get_results($sql);
221
 
222
  # ADD EXCLUDED TABLES
223
  foreach ($_POST as $key => $value)
224
  { if(substr($key,0,3) == 'cb_')
225
  { $sql = "
226
  INSERT INTO $wpdb->options (option_name, option_value, autoload)
227
+ VALUES ('rvg_ex_".substr($key,3)."','excluded','yes')
228
  ";
229
+ $wpdb->get_results($sql);
230
  }
231
  }
232
 
356
  ?>
357
  <script type="text/javascript">
358
  function schedule_changed()
359
+ { // v3.1.4
360
+ if(jQuery("#rvg_odb_schedule").val() == 'daily' || jQuery("#rvg_odb_schedule").val() == 'weekly')
361
  jQuery("#schedulehour").show();
362
  else
363
  jQuery("#schedulehour").hide();
364
  }
365
  </script>
366
 
367
+ <div id="odb-options-form">
368
+ <form name="options" method="post" action="">
369
+ <?php // v2.8.3 ?>
370
+ <?php wp_nonce_field( 'odb_action','odb_nonce' ); ?>
371
+ <div class="wrap">
372
+ <h2><?php echo __('Using Optimize Database after Deleting Revisions', 'rvg-optimize-database'); ?></h2>
373
+ <blockquote>
374
+ <p class="odb-bold">'<span class="odb-italic">Optimize Database after Deleting Revisions</span> ' <?php echo __('is an one-click plugin to clean and optimize your WordPress database','rvg-optimize-database');?></p>
375
+ <p><?php echo __('Plugin version:','rvg-optimize-database');?><br />
376
+ <span class="odb-bold">v<?php echo $odb_version ?> (<?php echo $odb_release_date?>)</span></p>
377
+ <p><span class="odb-bold"><?php echo __('Author','rvg-optimize-database');?>:</span><br />
378
+ <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, <?php echo __('The Netherlands','rvg-optimize-database');?><br />
379
+ <span class="odb-bold"><?php echo __('Plugin URL:','rvg-optimize-database');?></span><br />
380
+ <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 />
381
+ <span class="odb-bold"><?php echo __('Download URL:','rvg-optimize-database');?></span><br />
382
+ <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>
383
+ <p>&nbsp;</p>
384
+ </blockquote>
385
+ <h2><?php echo __('Optimize Database after Deleting Revisions - Settings','rvg-optimize-database');?></h2>
386
+ <?php
387
  if($rvg_odb_adminbar == 'Y') $rvg_odb_adminbar_checked = ' checked="checked"'; else $rvg_odb_adminbar_checked = '';
388
  if($rvg_odb_adminmenu == 'Y') $rvg_odb_adminmenu_checked = ' checked="checked"'; else $rvg_odb_adminmenu_checked = '';
389
  if($rvg_clear_trash == 'Y') $rvg_clear_trash_checked = ' checked="checked"'; else $rvg_clear_trash_checked = '';
394
  if($rvg_clear_pingbacks == 'Y') $rvg_clear_pingbacks_checked = ' checked="checked"'; else $rvg_clear_pingbacks_checked = '';
395
  if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checked"'; else $rvg_odb_logging_on_checked = '';
396
  ?>
397
+ <blockquote>
398
+ <fieldset class='options'>
399
+ <table class="editform" cellspacing="2" cellpadding="5" width="100%">
400
+ <tr>
401
+ <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="4">
402
+ <tr>
403
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?><br />
404
+ <?php echo __('(\'0\' means: delete <u>ALL</u> revisions)','rvg-optimize-database');?></span></td>
405
+ <td width="50%" valign="top"><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" class="odb-bold odb-blue" /></td>
406
+ </tr>
407
+ <tr>
408
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete all trashed items','rvg-optimize-database');?></span></td>
409
+ <td width="50%" valign="top"><input name="rvg_clear_trash" type="checkbox" value="Y" <?php echo $rvg_clear_trash_checked?> /></td>
410
+ </tr>
411
+ <tr>
412
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete all spammed items','rvg-optimize-database');?></span></td>
413
+ <td width="50%" valign="top"><input name="rvg_clear_spam" type="checkbox" value="Y" <?php echo $rvg_clear_spam_checked?> /></td>
414
+ </tr>
415
+ <tr>
416
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete unused tags','rvg-optimize-database');?></span></td>
417
+ <td width="50%" valign="top"><input name="rvg_clear_tags" type="checkbox" value="Y" <?php echo $rvg_clear_tags_checked?> /></td>
418
+ </tr>
419
+ <tr>
420
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete expired transients','rvg-optimize-database');?></span></td>
421
+ <td width="50%" valign="top"><input name="rvg_clear_transients" type="checkbox" value="Y" <?php echo $rvg_clear_transients_checked?> /></td>
422
+ </tr>
423
+ <tr>
424
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Delete pingbacks and trackbacks','rvg-optimize-database');?></span></td>
425
+ <td width="50%" valign="top"><input name="rvg_clear_pingbacks" type="checkbox" value="Y" <?php echo $rvg_clear_pingbacks_checked?> /></td>
426
+ </tr>
427
+ <tr>
428
+ <td width="50%" align="right" valign="top"><span class="odb-bold"><?php echo __('Keep a log','rvg-optimize-database');?></span></td>
429
+ <td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" <?php echo $rvg_odb_logging_on_checked?> /></td>
430
+ </tr>
431
+ <tr>
432
+ <td width="50%" align="right"><span class="odb-bold"><?php echo __('Scheduler','rvg-optimize-database');?></span></td>
433
+ <td width="50%"><select name="rvg_odb_schedule" id="rvg_odb_schedule" onchange="schedule_changed();">
434
+ <option selected="selected" value=""><?php echo __('NOT SCHEDULED','rvg-optimize-database');?></option>
435
+ <option value="hourly"><?php echo __('run optimization HOURLY','rvg-optimize-database');?></option>
436
+ <option value="twicedaily"><?php echo __('run optimization TWICE A DAY','rvg-optimize-database');?></option>
437
+ <option value="daily"><?php echo __('run optimization DAILY','rvg-optimize-database');?></option>
438
+ <option value="weekly"><?php echo __('run optimization WEEKLY','rvg-optimize-database');?></option>
439
+ <?php /*?><option value="test">run optimization TEST</option><?php */?>
440
+ </select>
441
+ <script type="text/javascript">
442
+ jQuery("#rvg_odb_schedule").val('<?php echo $rvg_odb_schedule; ?>');
443
  </script>
444
+ <span id="schedulehour" style="display:none;"> <span class="odb-bold"><?php echo __('Time','rvg-optimize-database');?></span>
445
+ <select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour">
446
+ <?php
447
  for($i=0; $i<=23; $i++)
448
  { if($i<10) $i = '0'.$i;
449
  ?>
450
+ <option value="<?php echo $i?>"><?php echo $i.':00 '.__('hrs','rvg-optimize-database')?></option>
451
+ <?php
452
  }
453
  ?>
454
+ </select>
455
+ <script type="text/javascript">
456
+ jQuery("#rvg_odb_schedulehour").val('<?php echo $rvg_odb_schedulehour; ?>');
457
  </script>
458
+ </span>
459
+ <script type="text/javascript">schedule_changed();</script></td>
460
+ </tr>
461
+ <tr>
462
+ <td align="right" valign="top"><span class="odb-bold"><?php echo __('Show \'1-click\' link in Admin Bar','rvg-optimize-database');?></span></td>
463
+ <td valign="top"><input name="rvg_odb_adminbar" type="checkbox" value="Y" <?php echo $rvg_odb_adminbar_checked?> />
464
+ <?php echo __('(change will be visible after loading the next page)','rvg-optimize-database');?></td>
465
+ </tr>
466
+ <tr>
467
+ <td align="right" valign="top"><span class="odb-bold"><?php echo __('Show an icon in the Admin Menu','rvg-optimize-database');?></span></td>
468
+ <td valign="top"><input name="rvg_odb_adminmenu" type="checkbox" value="Y" <?php echo $rvg_odb_adminmenu_checked?> />
469
+ <?php echo __('(change will be visible after loading the next page)','rvg-optimize-database');?></td>
470
+ </tr>
471
+ </table></td>
472
+ </tr>
473
+ <?php
474
  # v2.8.2
475
+ $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`", ARRAY_N);
476
  # v2.8.3 $ replaced by jQuery
477
  ?>
478
+ <tr>
479
+ <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
480
+ <tr>
481
+ <td colspan="4" align="center"><span class="odb-bold"><?php echo __('EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span class="odb-underline-red">CHECKED</span> TABLES <span class="odb-underline-red">WON\'T</span> BE OPTIMIZED!</span>','rvg-optimize-database');?><br />
482
+ <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',true);"><?php echo __('check all tables','rvg-optimize-database');?></a> | <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',false);"><?php echo __('uncheck all tables','rvg-optimize-database');?></a> | <a href="javascript:;" onclick="jQuery(':not([id^=cb_<?php echo $table_prefix; ?>])').filter('[id^=cb_]').attr('checked',true);"><?php echo __('check all NON-WordPress tables','rvg-optimize-database');?></a></td>
483
+ </tr>
484
+ <tr>
485
+ <?php
486
  $c = 0;
487
  $t = 0;
488
  # v2.8.2
500
 
501
  $cb_checked = '';
502
  $sql = "
503
+ SELECT `option_value`
504
+ FROM $wpdb->options
505
+ WHERE `option_name` = 'rvg_ex_".$tables[$i][0]."'
506
  ";
507
+ $results = $wpdb->get_results($sql);
508
  if(isset($results[0]->option_value))
509
  if($results[0]->option_value == 'excluded') $cb_checked = ' checked';
510
  echo '<td width="25%" '.$class.'><input id="cb_'.$tables[$i][0].'" name="cb_'.$tables[$i][0].'" type="checkbox" value="1" '.$cb_checked.' /> '.$tables[$i][0].'</td>'."\n";
511
  } # for ($i=0; $i<count($tables); $i++)
512
  ?>
513
+ </tr>
514
+ </table></td>
515
+ </tr>
516
+ </table>
517
+ </fieldset>
518
+ </blockquote>
519
+ <p class="submit">
520
+ <input class="button-primary button-large" type='submit' name='info_update' value='<?php echo __('Save Settings','rvg-optimize-database');?>' class="odb-bold" />
521
+ &nbsp;
522
+ <input class="button odb-normal" type="button" name="optimizer" value="<?php echo __('Go To Optimizer','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php'" />
523
+ </p>
524
+ </div>
525
+ </form>
526
+ </div>
527
+ <!-- ocb-options-form -->
528
  <?php
529
  } // rvg_odb_settings_page ()
530
 
537
  *********************************************************************************************/
538
  function rvg_optimize_db()
539
  {
540
+ global $wpdb, $odb_version;
541
+
542
+ // PAGE LOAD COUNTER
543
+ $time = microtime();
544
+ $time = explode(' ', $time);
545
+ $time = $time[1] + $time[0];
546
+ $odb_start_time = $time;
547
 
548
  $timezone_format = _x('G:i', 'timezone date format');
549
  $current_hour = date_i18n($timezone_format);
643
  FROM $wpdb->options
644
  WHERE option_name LIKE 'rvg_ex_%'
645
  ";
646
+ $results = $wpdb->get_results($sql);
647
+ $number_excluded = $results[0]->cnt;
648
  ?>
649
  <div class="odb-padding-left">
650
  <h2><?php echo __('Optimize your WordPress Database','rvg-optimize-database');?></h2>
651
  <?php
652
  if(isset($_REQUEST['action']))
653
  if($_REQUEST['action'] == "delete_log")
654
+ echo '<div class="updated odb-updated"><p><span class="odb-bold">Optimize Database after Deleting Revisions - LOG FILE DELETED</span></p></div>';
655
  ?>
656
  <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> - <?php echo __('A WordPress Plugin by','rvg-optimize-database');?> <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, <?php echo __('The Netherlands','rvg-optimize-database');?></span></p>
657
  <p><?php echo __('Current settings','rvg-optimize-database');?>:<br />
658
+ <span class="odb-bold"><?php echo __('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 />
659
+ <span class="odb-bold"><?php echo __('Delete all trashed items','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_trash_yn?></span><br />
660
+ <span class="odb-bold"><?php echo __('Delete all spammed items','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_spam_yn?></span><br />
661
+ <span class="odb-bold"><?php echo __('Delete unused tags','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_tags_yn?></span><br />
662
+ <span class="odb-bold"><?php echo __('Delete expired transients','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_transients_yn?></span><br />
663
+ <span class="odb-bold"><?php echo __('Delete pingbacks and trackbacks','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $clear_pingbacks_yn?></span><br />
664
+ <span class="odb-bold"><?php echo __('Keep a log','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_logging_on_yn?></span><br />
665
+ <span class="odb-bold"><?php echo __('Number of excluded tables','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $number_excluded?></span><br />
666
+ <span class="odb-bold"><?php echo __('Scheduler','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo $rvg_odb_schedule_txt?></span>
667
+ <?php
668
  if($nextrun)
669
  {
670
  ?>
671
+ <br />
672
+ <span class="odb-bold"><?php echo __('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>
673
+ <?php
674
  }
675
  if($total_savings)
676
  {
677
  ?>
678
+ <br />
679
+ <span class="odb-bold"><?php echo __('Total savings since the first run','rvg-optimize-database');?>:</span> <span class="odb-bold odb-blue"><?php echo rvg_format_size($total_savings); ?></span>
680
+ <?php
681
  }
682
  ?>
683
  <p class="submit">
1012
  ******************************************************************************************/
1013
  ?>
1014
  <div class="odb-separator"></div>
1015
+ <div class="odb-optimizing-table">
1016
+ <table border="0" cellspacing="8" cellpadding="2">
1017
+ <tr>
1018
+ <td colspan="4" class="odb-bold odb-blue"><?php echo __('OPTIMIZING DATABASE TABLES','rvg-optimize-database');?>:</td>
1019
+ </tr>
1020
+ <tr>
1021
+ <th class="odb-border-bottom" align="right">#</th>
1022
+ <th class="odb-border-bottom" align="left"><?php echo __('table name','rvg-optimize-database');?></th>
1023
+ <th class="odb-border-bottom" align="left"><?php echo __('optimization result','rvg-optimize-database');?></th>
1024
+ <th class="odb-border-bottom" align="left"><?php echo __('engine','rvg-optimize-database');?></th>
1025
+ <th class="odb-border-bottom" align="right"><?php echo __('table rows','rvg-optimize-database');?></th>
1026
+ <th class="odb-border-bottom" align="right"><?php echo __('table size','rvg-optimize-database');?></th>
1027
+ </tr>
1028
+ <?php
1029
  # OPTIMIZE THE DATABASE TABLES
1030
  $cnt = rvg_optimize_tables(true);
1031
  ?>
1032
+ </table>
1033
+ <?php
1034
  // NUMBER OF TABLES
1035
  $log_arr["tables"] = $cnt;
1036
  // DATABASE SIZE BEFORE OPTIMIZATION
1047
  $total_savings += ($start_size - $end_size);
1048
  update_option('rvg_odb_total_savings',$total_savings);
1049
  ?>
1050
+ <div class="odb-separator"></div>
1051
+ <span class="odb-bold odb-blue odb-padding-left"><?php echo __('SAVINGS','rvg-optimize-database');?></span><br />
1052
+ <table border="0" cellspacing="8" cellpadding="2">
1053
+ <tr>
1054
+ <th>&nbsp;</th>
1055
+ <th class="odb-border-bottom"><?php echo __('size of the database','rvg-optimize-database');?></th>
1056
+ </tr>
1057
+ <tr>
1058
+ <td align="right"><?php echo __('BEFORE optimization','rvg-optimize-database');?></td>
1059
+ <td align="right" class="odb-bold"><?php echo rvg_format_size($start_size,3); ?></td>
1060
+ </tr>
1061
+ <tr>
1062
+ <td align="right"><?php echo __('AFTER optimization','rvg-optimize-database');?></td>
1063
+ <td align="right" class="odb-bold"><?php echo rvg_format_size($end_size,3); ?></td>
1064
+ </tr>
1065
+ <tr>
1066
+ <td align="right" class="odb-bold"><?php echo __('SAVINGS THIS TIME','rvg-optimize-database');?></td>
1067
+ <td align="right" class="odb-border-top odb-bold"><?php echo rvg_format_size(($start_size - $end_size),3); ?></td>
1068
+ </tr>
1069
+ <tr>
1070
+ <td align="right" class="odb-bold"><?php echo __('TOTAL SAVINGS SINCE THE FIRST RUN','rvg-optimize-database');?></td>
1071
+ <td align="right" class="odb-border-top odb-bold"><?php echo rvg_format_size($total_savings,3); ?></td>
1072
+ </tr>
1073
+ </table>
1074
+ </div>
1075
  <div class="odb-separator"></div>
1076
+ <?php
1077
+ $time = microtime();
1078
+ $time = explode(' ', $time);
1079
+ $time = $time[1] + $time[0];
1080
+ $finish = $time;
1081
+ $total_time = round(($finish - $odb_start_time), 4);
1082
+ ?>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1083
  <span class="odb-bold odb-blue odb-padding-left"><?php echo __('DONE','rvg-optimize-database');?>!</span><br />
1084
  <br />
1085
+ <span class="odb-padding-left"><?php echo __('Optimization took', 'rvg-optimize-database').' <strong>'.$total_time.'</strong> '.__('seconds', 'rvg-optimize-database').'.'?></span>
1086
  <?php
1087
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
1088
  {
1089
  ?>
1090
+ <br />
1091
+ <br />
1092
  &nbsp;
1093
  <input class="button odb-normal" type="button" name="view_log" value="<?php echo __('View Log File','rvg-optimize-database');?>" onclick="window.open('<?php echo $log_url?>')" />
1094
  &nbsp;
1105
  *********************************************************************************************/
1106
  function rvg_optimize_db_cron()
1107
  {
1108
+ global $wpdb, $odb_version;
1109
 
1110
  // GET SETTINGS AND SET DEFAULT VALUES
1111
  $max_revisions = get_option('rvg_odb_number');
1268
  } // if($display)
1269
 
1270
  $sql_get_posts = "
1271
+ SELECT `ID`, `post_modified`
1272
+ FROM $wpdb->posts
1273
+ WHERE `post_parent`=".$results[$i]->post_parent."
1274
+ AND `post_type`='revision'
1275
+ ORDER BY `post_modified` ASC
1276
  ";
1277
+ $results_get_posts = $wpdb->get_results($sql_get_posts);
1278
 
1279
  for($j=0; $j<$nr_to_delete; $j++)
1280
  {
1282
 
1283
  $sql_delete = "
1284
  DELETE FROM $wpdb->posts
1285
+ WHERE `ID` = ".$results_get_posts[$j]->ID."
1286
  ";
1287
+ $wpdb->get_results($sql_delete);
1288
 
1289
  } // for($j=0; $j<$nr_to_delete; $j++)
1290
 
1327
  if($results[$i]->post_type == 'comment')
1328
  { // DELETE META DATA (IF ANY...)
1329
  $sql_delete = "
1330
+ DELETE FROM $wpdb->commentmeta
1331
+ WHERE `comment_id` = ".$results[$i]->id."
1332
  ";
1333
+ $wpdb->get_results($sql_delete);
1334
  }
1335
 
1336
  $nr++;
1338
 
1339
  // DELETE TRASHED POSTS / PAGES
1340
  $sql_delete = "
1341
+ DELETE FROM $wpdb->posts
1342
+ WHERE `post_status` = 'trash'
1343
  ";
1344
+ $wpdb->get_results($sql_delete);
1345
 
1346
  // DELETE TRASHED COMMENTS
1347
  $sql_delete = "
1348
+ DELETE FROM $wpdb->comments
1349
+ WHERE `comment_approved` = 'trash'
1350
  ";
1351
+ $wpdb->get_results($sql_delete);
1352
 
1353
  return $total_deleted;
1354
 
1379
  <?php
1380
  } // if($display)
1381
  $sql_delete = "
1382
+ DELETE FROM $wpdb->commentmeta
1383
+ WHERE `comment_id` = ".$results[$i]->comment_ID."
1384
  ";
1385
+ $wpdb->get_results($sql_delete);
1386
  $nr++;
1387
  } // for($i=0; $i<count($results); $i++)
1388
 
1389
  $sql_delete = "
1390
+ DELETE FROM $wpdb->comments
1391
+ WHERE `comment_approved` = 'spam'
1392
  ";
1393
+ $wpdb->get_results($sql_delete);
1394
 
1395
  return $total_deleted;
1396
 
1432
  global $wpdb;
1433
 
1434
  $sql_get_posts = "
1435
+ SELECT p.post_status
1436
+ FROM $wpdb->term_relationships t, $wpdb->posts p
1437
+ WHERE t.term_taxonomy_id = '".$term_id."'
1438
+ AND t.object_id = p.ID
1439
  ";
1440
 
1441
+ $results_get_posts = $wpdb->get_results($sql_get_posts);
1442
  for($i=0; $i<count($results_get_posts); $i++)
1443
  if($results_get_posts[$i]->post_status == 'future') return true;
1444
 
1471
  AND option_value < '$delay'
1472
  ";
1473
 
1474
+ $results = $wpdb->get_results($sql);
1475
  $total_deleted = count($results);
1476
 
1477
  $sql = "
1484
  AND option_value < '$delay'
1485
  ";
1486
 
1487
+ $wpdb->get_results($sql);
1488
 
1489
  $sql = "
1490
  SELECT *
1496
  AND option_value < '$delay'
1497
  ";
1498
 
1499
+ $results = $wpdb->get_results($sql);
1500
  $total_deleted += count($results);
1501
 
1502
  $sql = "
1508
  AND option_value < '$delay'
1509
  ";
1510
 
1511
+ $wpdb->get_results($sql);
1512
 
1513
  return $total_deleted;
1514
  } // rvg_delete_transients ()
1534
  )
1535
  ";
1536
 
1537
+ $results = $wpdb->get_results($sql);
1538
  $total_deleted = count($results);
1539
 
1540
  for($i=0; $i<count($results); $i++)
1541
  { // DELETE METADATA FOR THIS COMMENT (IF ANY)
1542
  $sql_delete_meta = "
1543
  DELETE FROM $wpdb->commentmeta
1544
+ WHERE `comment_id` = ".$results[$i]->comment_ID."
1545
  ";
1546
+ $wpdb->get_results($sql_delete_meta);
1547
  }
1548
 
1549
  $sql_delete_comments = "
1553
  OR `comment_type` = 'trackback'
1554
  )
1555
  ";
1556
+ $wpdb->get_results($sql_delete_comments);
1557
 
1558
  return $total_deleted;
1559
  } // rvg_delete_pingbacks ()
1575
  // DELETE POST ORPHANS (AUTO DRAFTS)
1576
  $sql_delete = "
1577
  SELECT COUNT(*) cnt
1578
+ FROM $wpdb->posts
1579
+ WHERE ID NOT IN (SELECT post_id FROM $wpdb->postmeta)
1580
+ AND post_status = 'auto-draft'
1581
  ";
1582
 
1583
+ $results = $wpdb->get_results($sql_delete);
1584
 
1585
+ $post_orphans = $results[0]->cnt;
1586
 
1587
  if($post_orphans > 0)
1588
  { $sql_delete = "
1589
  DELETE FROM $wpdb->posts
1590
+ WHERE ID NOT IN (SELECT post_id FROM $wpdb->postmeta)
1591
+ AND post_status = 'auto-draft'
1592
  ";
1593
+ $wpdb->get_results($sql_delete);
1594
  }
1595
 
1596
  // DELETE POSTMETA ORPHANS
1597
  $sql_delete = "
1598
  SELECT COUNT(*) cnt
1599
+ FROM $wpdb->postmeta
1600
+ WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)
1601
  ";
1602
 
1603
+ $results = $wpdb->get_results($sql_delete);
1604
 
1605
+ $meta_orphans = $results[0]->cnt;
1606
 
1607
  if($meta_orphans > 0)
1608
  { $sql_delete = "
1609
  DELETE FROM $wpdb->postmeta
1610
+ WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)
1611
  ";
1612
+ $wpdb->get_results($sql_delete);
1613
  }
1614
 
1615
  return ($meta_orphans + $post_orphans);
1624
  *********************************************************************************************/
1625
  function rvg_optimize_tables($display)
1626
  {
1627
+ global $wpdb;
1628
 
1629
  # v2.8.2
1630
+ $tables = $wpdb->get_results("SHOW TABLES FROM `".DB_NAME."`", ARRAY_N);
1631
  // print_r($tables);
1632
 
1633
+ $cnt = 0;
1634
  for ($i=0; $i<count($tables); $i++)
1635
  {
1636
  $excluded = get_option('rvg_ex_'.$tables[$i][0]);
1638
  if(!$excluded)
1639
  { # TABLE NOT EXCLUDED
1640
  $cnt++;
1641
+
1642
+ // v3.1.4
 
 
1643
  $sql = "
1644
+ SELECT engine, (data_length + index_length) AS size, table_rows
1645
+ FROM information_schema.TABLES
1646
+ WHERE table_schema = '".DB_NAME."'
1647
+ AND table_name = '".$tables[$i][0]."'
 
 
1648
  ";
1649
+ $table_info = $wpdb->get_results($sql);
1650
 
1651
+ // v3.1.4
1652
+ if(strtolower($table_info[0]->engine) == 'innodb')
1653
+ { // SKIP InnoDB tables
1654
+ $msg = __('InnoDB table: skipped...', 'rvg-optimize-database');
1655
+ }
1656
+ else
1657
+ { $query = "OPTIMIZE TABLE ".$tables[$i][0];
1658
+ $result = $wpdb->get_results($query);
1659
+ $msg = $result[0]->Msg_text;
1660
+ $msg = str_replace('OK', __('TABLE OPTIMIZED', 'rvg-optimize-database'), $msg);
1661
+ $msg = str_replace('Table is already up to date', __('Table is already up to date', 'rvg-optimize-database'), $msg);
1662
+ }
1663
 
1664
  if($display)
1665
+ { // NOT FROM THE SCEDULER
1666
  ?>
1667
  <tr>
1668
  <td align="right" valign="top"><?php echo $cnt?>.</td>
1669
  <td valign="top" class="odb-bold"><?php echo $tables[$i][0] ?></td>
1670
+ <td valign="top"><?php echo $msg ?></td>
1671
  <td valign="top"><?php echo $table_info[0]->engine ?></td>
1672
  <td align="right" valign="top"><?php echo $table_info[0]->table_rows ?></td>
1673
  <td align="right" valign="top"><?php echo rvg_format_size($table_info[0]->size) ?></td>
1733
  <body>
1734
  <div id="header">
1735
  <h2><a href="https://wordpress.org/plugins/rvg-optimize-database/" target="_blank">Optimize Database after Deleting Revisions v'.$odb_version.'</a></h2>
1736
+ '.__('A WordPress Plugin by','rvg-optimize-database').' <a href="http://cagewebdev.com" target="_blank"><span class="odb-bold">CAGE Web Design</span></a> | <a href="http://rvg.cage.nl" target="_blank"><span class="odb-bold">Rolf van Gelder</span></a>, Eindhoven, '.__('The Netherlands','rvg-optimize-database').'</span>
1737
  </div>
1738
  <table width="100%" border="0" cellspacing="6" cellpadding="1">
1739
  <tr>
1759
  $html = '
1760
  <table width="100%" border="0" cellspacing="6" cellpadding="0">
1761
  <tr>
1762
+ <td width="8%" valign="top"><span class="odb-bold">'.$log_arr["time"].'</span></td>
1763
  <td width="8%" align="right" valign="top">'.$log_arr["revisions"].'</td>
1764
  <td width="8%" align="right" valign="top">'.$log_arr["trash"].'</td>
1765
  <td width="8%" align="right" valign="top">'.$log_arr["spam"].'</td>
1792
  global $wpdb;
1793
 
1794
  $sql = "
1795
+ SELECT `post_parent`, `post_title`, COUNT(*) cnt
1796
+ FROM $wpdb->posts
1797
+ WHERE `post_type` = 'revision'
1798
+ GROUP BY `post_parent`
1799
+ HAVING COUNT(*) > ".$max_revisions."
1800
+ ORDER BY UCASE(`post_title`)
1801
  ";
1802
 
1803
+ return $wpdb->get_results($sql);
1804
 
1805
  } // rvg_get_revisions ()
1806
 
1815
  global $wpdb;
1816
 
1817
  $sql = "
1818
+ SELECT `ID` AS id, 'post' AS post_type, `post_title` AS title, `post_modified` AS modified
1819
+ FROM $wpdb->posts
1820
+ WHERE `post_status` = 'trash'
1821
  UNION ALL
1822
+ SELECT `comment_ID` AS id, 'comment' AS post_type, `comment_author_IP` AS title, `comment_date` AS modified
1823
+ FROM $wpdb->comments
1824
+ WHERE `comment_approved` = 'trash'
1825
+ ORDER BY post_type, UCASE(title)
1826
  ";
1827
 
1828
+ return $wpdb->get_results($sql);
1829
 
1830
  } // rvg_get_trash ()
1831
 
1840
  global $wpdb;
1841
 
1842
  $sql = "
1843
+ SELECT `comment_ID`, `comment_author`, `comment_author_email`, `comment_date`
1844
+ FROM $wpdb->comments
1845
+ WHERE `comment_approved` = 'spam'
1846
+ ORDER BY UCASE(`comment_author`)
1847
  ";
1848
 
1849
+ return $wpdb->get_results($sql);
1850
 
1851
  } // rvg_get_trash ()
1852
 
1859
  function rvg_get_db_size()
1860
  {
1861
  global $wpdb;
1862
+
1863
+ // v3.1.4
1864
  $sql = "
1865
+ SELECT SUM(data_length + index_length) AS size
1866
+ FROM information_schema.TABLES
1867
+ WHERE table_schema = '".DB_NAME."'
1868
  GROUP BY table_schema
1869
+ ";
1870
 
1871
+ $res = $wpdb->get_results($sql);
1872
 
1873
  return $res[0]->size;
1874