Optimize Database after Deleting Revisions - Version 2.9

Version Description

[10/22/2014] = * NEW: plugin has been fully localized * NEW: dutch language support [nl_NL] added * NEW: serbian language support [sr_RS] added

Download this release

Release Info

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

Code changes from version 2.8.3 to 2.9

Files changed (6) hide show
  1. readme.txt +25 -11
  2. rvg-optimize-database-nl_NL.mo +0 -0
  3. rvg-optimize-database-nl_NL.po +482 -0
  4. rvg-optimize-database-sr_RS.mo +0 -0
  5. rvg-optimize-database-sr_RS.po +475 -0
  6. rvg-optimize-db.php +136 -123
readme.txt CHANGED
@@ -6,10 +6,10 @@ Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-rev
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler, transients, unused tags
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
- Requires at least: 2.0
10
- Tested up to: 4.0
11
- Stable tag: 2.8.3
12
- Version: 2.8.3
13
  License: GPLv2 or later
14
 
15
  == Description ==
@@ -35,23 +35,32 @@ You can find the settings page in the WP Admin Panel » Settings » Op
35
  You can start the Optimization in the WP Admin Panel » Tools » Optimize Database.
36
  Note: if you use the Scheduler the Optimization will run automatically!
37
 
 
 
 
 
 
38
  = Author =
39
- CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://cage.nl
40
 
41
  = Plugin URL =
42
  http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
43
 
44
  = Download URL =
45
- http://wordpress.org/extend/plugins/rvg-optimize-database/
46
 
47
  = Disclaimer =
48
  NO WARRANTY, USE IT AT YOUR OWN RISK!
49
 
50
- = Other plugins by Rolf van Gelder =
51
- Rocket Reader (Speed reader)
52
- http://wordpress.org/plugins/rocket-reader-speed-reader/
53
- Order your Posts Manually
54
- http://wordpress.org/plugins/order-your-posts-manually/
 
 
 
 
55
 
56
  == Installation ==
57
 
@@ -61,6 +70,11 @@ http://wordpress.org/plugins/order-your-posts-manually/
61
 
62
  == Changelog ==
63
 
 
 
 
 
 
64
  = 2.8.3 [09/10/2014] =
65
  * CHANGE: using the WP jQuery libs now (not from googleapis anymore)
66
  * BUG FIX: check_admin_referer() fixed (gave a debug warning)
6
  Tags: database, delete, revisions, optimize, post, posts, page, pages, clean, clean up, trash, spam, trashed, spammed, database size, scheduler, transients, unused tags
7
  Author URI: http://cagewebdev.com
8
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
9
+ Requires at least: 2.8
10
+ Tested up to: 4.1
11
+ Stable tag: 2.9
12
+ Version: 2.9
13
  License: GPLv2 or later
14
 
15
  == Description ==
35
  You can start the Optimization in the WP Admin Panel » Tools » Optimize Database.
36
  Note: if you use the Scheduler the Optimization will run automatically!
37
 
38
+ = Supported languages =
39
+ * English [en_US] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
40
+ * Dutch [nl_NL] - translated by Rolf van Gelder, CAGE Web Design - http://cagewebdev.com
41
+ * Serbian [sr_RS] - translated by Ogi Djuraskovic, FirstSiteGuide - http://firstsiteguide.com
42
+
43
  = Author =
44
+ CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl
45
 
46
  = Plugin URL =
47
  http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
48
 
49
  = Download URL =
50
+ http://wordpress.org/plugins/rvg-optimize-database/
51
 
52
  = Disclaimer =
53
  NO WARRANTY, USE IT AT YOUR OWN RISK!
54
 
55
+ = Plugins by Rolf van Gelder =
56
+ Optimize Database after Deleting Revisions<br />
57
+ http://wordpress.org/plugins/rvg-optimize-database/<br />
58
+ Rocket Reader (Speed reader)<br />
59
+ http://wordpress.org/plugins/rocket-reader-speed-reader/<br />
60
+ Order your Posts Manually<br />
61
+ http://wordpress.org/plugins/order-your-posts-manually/<br />
62
+ Float to Top Button<br />
63
+ http://wordpress.org/plugins/float-to-top-button/
64
 
65
  == Installation ==
66
 
70
 
71
  == Changelog ==
72
 
73
+ = 2.9 [10/22/2014] =
74
+ * NEW: plugin has been fully localized
75
+ * NEW: dutch language support [nl_NL] added
76
+ * NEW: serbian language support [sr_RS] added
77
+
78
  = 2.8.3 [09/10/2014] =
79
  * CHANGE: using the WP jQuery libs now (not from googleapis anymore)
80
  * BUG FIX: check_admin_referer() fixed (gave a debug warning)
rvg-optimize-database-nl_NL.mo ADDED
Binary file
rvg-optimize-database-nl_NL.po ADDED
@@ -0,0 +1,482 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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: 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"
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.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"
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: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!"
rvg-optimize-database-sr_RS.mo ADDED
Binary file
rvg-optimize-database-sr_RS.po ADDED
@@ -0,0 +1,475 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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: 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"
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.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"
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: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"
rvg-optimize-db.php CHANGED
@@ -1,19 +1,34 @@
1
  <?php
2
- $odb_version = '2.8.3';
3
- $odb_release_date = '09/10/2014';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
- * @version 2.8.3
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
10
  Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/
11
  Description: Optimizes the Wordpress Database after Cleaning it out - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
- Version: 2.8.3
14
  Author URI: http://cagewebdev.com
15
  */
16
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
17
  /********************************************************************************************
18
 
19
  ADD THE 'OPTIMIZE DATABASE' ITEM TO THE TOOLS MENU
@@ -24,7 +39,7 @@ function optimize_db_main()
24
  { # v2.8: 'administrator' role changed to 'edit_themes' capability
25
  // add_management_page(__('Optimize Database'), __('Optimize Database'), 'edit_themes', 'rvg-optimize-db.php', 'rvg_optimize_db');
26
  # v2.8.1: changed capability back to 'administrator'
27
- add_management_page(__('Optimize Database'), __('Optimize Database'), 'administrator','rvg-optimize-db.php', 'rvg_optimize_db');
28
  }
29
  }
30
  add_action('admin_menu', 'optimize_db_main');
@@ -38,7 +53,7 @@ add_action('admin_menu', 'optimize_db_main');
38
  function rvg_odb_admin_menu()
39
  {
40
  if (function_exists('add_options_page'))
41
- { add_options_page(__('Optimize DB Options'), __('Optimize DB Options'), 'manage_options', 'rvg_odb_admin', 'rvg_odb_options_page');
42
  }
43
  }
44
  add_action( 'admin_menu', 'rvg_odb_admin_menu' );
@@ -53,7 +68,7 @@ function rvg_odb_admin_bar()
53
  { global $wp_admin_bar;
54
  if ( !is_super_admin() || !is_admin_bar_showing() ) return;
55
  $siteurl = site_url('/');
56
- $wp_admin_bar->add_menu( array('id' => 'optimize','title' => __('Optimize DB (1 click)'),'href' => __($siteurl.'wp-admin/tools.php?page=rvg-optimize-db.php&action=run') ) );
57
  }
58
  $rvg_odb_adminbar = get_option('rvg_odb_adminbar');
59
  if($rvg_odb_adminbar == "Y") add_action( 'wp_before_admin_bar_render', 'rvg_odb_admin_bar' );
@@ -210,7 +225,11 @@ function rvg_odb_options_page()
210
  }
211
 
212
  // UPDATED MESSAGE
213
- echo "<div class='updated'><p><strong>Optimize Database after Deleting Revisions OPTIONS UPDATED</strong> - Click <a href='tools.php?page=rvg-optimize-db.php' style='font-weight:bold'>HERE</a> to run the optimization</p></div>";
 
 
 
 
214
  }
215
 
216
  $rvg_odb_number = get_option('rvg_odb_number');
@@ -253,23 +272,23 @@ function schedule_changed()
253
  <?php // v2.8.3 ?>
254
  <?php wp_nonce_field( 'odb_action','odb_nonce' ); ?>
255
  <div class="wrap">
256
- <h2>Using Optimize Database after Deleting Revisions</h2>
257
  <blockquote>
258
- <p><strong>'<em>Optimize Database after Deleting Revisions</em>' is an one-click plugin to clean and optimize your WordPress database.</strong></p>
259
- <p>To start the optimization:<br />
260
- <strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; <strong>Optimize Database</strong>. Then click the '<strong>Start Optimization</strong>'-button. Et voila!<br />
261
- Note: if you use the Scheduler the Optimization will run automatically!
262
- <p>Plugin version:<br />
263
  <strong>v<?php echo $odb_version ?> (<?php echo $odb_release_date?>)</strong> </p>
264
- <p><strong>Author:</strong><br />
265
- <strong><a href="http://cagewebdev.com/" target="_blank">CAGE Web Design</a> | <a href="http://cage.nl/" target="_blank">Rolf van Gelder</a></strong>, Eindhoven, The Netherlands<br />
266
- <strong>Plugin URL:</strong><br />
267
  <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank"><strong>http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/</strong></a><br />
268
- <strong>Download URL:</strong><br />
269
  <strong><a href="http://wordpress.org/extend/plugins/rvg-optimize-database/" target="_blank">http://wordpress.org/extend/plugins/rvg-optimize-database/</a></strong></p>
270
  <p>&nbsp;</p>
271
  </blockquote>
272
- <h2>Optimize Database after Deleting Revisions - Options</h2>
273
  <?php
274
  if($rvg_odb_adminbar == 'Y') $rvg_odb_adminbar_checked = ' checked="checked"'; else $rvg_odb_adminbar_checked = '';
275
  if($rvg_clear_trash == 'Y') $rvg_clear_trash_checked = ' checked="checked"'; else $rvg_clear_trash_checked = '';
@@ -284,50 +303,50 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
284
  <tr>
285
  <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="4">
286
  <tr>
287
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Maximum number of - most recent - revisions to keep per post / page<br />
288
- ('0' means: delete <u>ALL</u> revisions)</span></td>
289
  <td width="50%" valign="top"><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" style="font-weight:bold;color:#00F;" /></td>
290
  </tr>
291
  <tr>
292
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Delete all trashed items</span></td>
293
  <td width="50%" valign="top"><input name="rvg_clear_trash" type="checkbox" value="Y" <?php echo $rvg_clear_trash_checked?> /></td>
294
  </tr>
295
  <tr>
296
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Delete all spammed items</span></td>
297
  <td width="50%" valign="top"><input name="rvg_clear_spam" type="checkbox" value="Y" <?php echo $rvg_clear_spam_checked?> /></td>
298
  </tr>
299
  <tr>
300
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Delete unused tags</span></td>
301
  <td width="50%" valign="top"><input name="rvg_clear_tags" type="checkbox" value="Y" <?php echo $rvg_clear_tags_checked?> /></td>
302
  </tr>
303
  <tr>
304
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Delete expired transients</span></td>
305
  <td width="50%" valign="top"><input name="rvg_clear_transients" type="checkbox" value="Y" <?php echo $rvg_clear_transients_checked?> /></td>
306
  </tr>
307
  <tr>
308
- <td width="50%" align="right" valign="top"><span style="font-weight:bold;">Keep a log</span></td>
309
  <td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" <?php echo $rvg_odb_logging_on_checked?> /></td>
310
  </tr>
311
  <tr>
312
- <td width="50%" align="right"><span style="font-weight:bold;">Scheduler</span></td>
313
  <td width="50%"><select name="rvg_odb_schedule" id="rvg_odb_schedule" onchange="schedule_changed();">
314
- <option selected="selected" value="">NOT SCHEDULED</option>
315
- <option value="hourly">run optimization HOURLY</option>
316
- <option value="twicedaily">run optimization TWICE A DAY</option>
317
- <option value="daily">run optimization DAILY</option>
318
- <option value="weekly">run optimization WEEKLY</option>
319
  <?php /*?><option value="test">run optimization TEST</option><?php */?>
320
  </select>
321
  <script type="text/javascript">
322
  document.options.rvg_odb_schedule.value = '<?php echo $rvg_odb_schedule; ?>';
323
  </script>
324
- <span id="schedulehour" style="display:none;"> <span style="font-weight:bold;">Time</span>
325
  <select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour">
326
  <?php
327
  for($i=0; $i<=23; $i++)
328
  { if($i<10) $i = '0'.$i;
329
  ?>
330
- <option value="<?php echo $i?>"><?php echo $i.':00'.' hrs'?></option>
331
  <?php
332
  }
333
  ?>
@@ -339,9 +358,9 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
339
  <script type="text/javascript">schedule_changed();</script></td>
340
  </tr>
341
  <tr>
342
- <td align="right" valign="top"><span style="font-weight:bold;">Show '1-click' link in Admin Bar</span></td>
343
  <td valign="top"><input name="rvg_odb_adminbar" type="checkbox" value="Y" <?php echo $rvg_odb_adminbar_checked?> />
344
- (change will be visible after loading the next page)</td>
345
  </tr>
346
  </table></td>
347
  </tr>
@@ -353,8 +372,8 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
353
  <tr>
354
  <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
355
  <tr>
356
- <td colspan="4" align="center"><span style="font-weight:bold;">EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style="text-decoration:underline;color:#F00;">CHECKED</span> TABLES <span style="text-decoration:underline;color:#F00;">WON'T</span> BE OPTIMIZED!</span><br />
357
- <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',true);">check all tables</a> | <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',false);">uncheck all tables</a> | <a href="javascript:;" onclick="jQuery(':not([id^=cb_<?php echo $table_prefix; ?>])').filter('[id^=cb_]').attr('checked',true);">check all NON-WordPress tables</a></td>
358
  </tr>
359
  <tr>
360
  <?php
@@ -392,9 +411,9 @@ if($rvg_odb_logging_on == 'Y') $rvg_odb_logging_on_checked = ' checked="checke
392
  </fieldset>
393
  </blockquote>
394
  <p class="submit">
395
- <input class="button-primary button-large" type='submit' name='info_update' value='Save Options' style="font-weight:bold;" />
396
  &nbsp;
397
- <input class="button" type="button" name="delete_log" value="Go To Optimizer" onclick="self.location='tools.php?page=rvg-optimize-db.php'" style="font-weight:normal;" />
398
  </p>
399
  </div>
400
  </form>
@@ -437,35 +456,35 @@ function rvg_optimize_db()
437
  { $clear_trash = 'N';
438
  update_option('rvg_clear_trash', $clear_trash);
439
  }
440
- $clear_trash_yn = ($clear_trash == 'N') ? 'NO' : 'YES';
441
 
442
  $clear_spam = get_option('rvg_clear_spam');
443
  if(!$clear_spam)
444
  { $clear_spam = 'N';
445
  update_option('rvg_clear_spam', $clear_spam);
446
  }
447
- $clear_spam_yn = ($clear_spam == 'N') ? 'NO' : 'YES';
448
 
449
  $clear_tags = get_option('rvg_clear_tags');
450
  if(!$clear_tags)
451
  { $clear_tags = 'N';
452
  update_option('rvg_clear_tags', $clear_tags);
453
  }
454
- $clear_tags_yn = ($clear_tags == 'N') ? 'NO' : 'YES';
455
 
456
  $clear_transients = get_option('rvg_clear_transients');
457
  if(!$clear_transients)
458
  { $clear_transients = 'N';
459
  update_option('rvg_clear_transients', $clear_transients);
460
  }
461
- $clear_transients_yn = ($clear_transients == 'N') ? 'NO' : 'YES';
462
 
463
  $rvg_odb_logging_on = get_option('rvg_odb_logging_on');
464
  if(!$rvg_odb_logging_on)
465
  { $rvg_odb_logging_on = 'N';
466
  update_option('rvg_odb_logging_on', $rvg_odb_logging_on);
467
  }
468
- $rvg_odb_logging_on_yn = ($rvg_odb_logging_on == 'N') ? 'NO' : 'YES';
469
 
470
  $rvg_odb_schedule = get_option('rvg_odb_schedule');
471
  if(!$rvg_odb_schedule)
@@ -474,19 +493,19 @@ function rvg_optimize_db()
474
  }
475
 
476
  if($rvg_odb_schedule == 'hourly')
477
- $rvg_odb_schedule_txt = 'ONCE HOURLY';
478
  else if($rvg_odb_schedule == 'twicedaily')
479
- $rvg_odb_schedule_txt = 'TWICE DAILY';
480
  else if($rvg_odb_schedule == 'daily')
481
- $rvg_odb_schedule_txt = 'ONCE DAILY';
482
  else if($rvg_odb_schedule == 'weekly')
483
- $rvg_odb_schedule_txt = 'ONCE WEEKLY';
484
  else if($rvg_odb_schedule == 'test')
485
  $rvg_odb_schedule_txt = 'TEST';
486
 
487
  $nextrun = '';
488
  if(!isset($rvg_odb_schedule_txt))
489
- { $rvg_odb_schedule_txt = 'NOT SCHEDULED';
490
  }
491
  else
492
  { $timestamp = wp_next_scheduled('rvg_optimize_database');
@@ -506,48 +525,48 @@ function rvg_optimize_db()
506
  $number_excluded = $results[0] -> cnt;
507
  ?>
508
  <div style="padding-left:8px;">
509
- <h2>Optimize your WordPress Database</h2>
510
  <?php
511
  if(isset($_REQUEST['action']))
512
  if($_REQUEST['action'] == "delete_log")
513
  echo '<div class="updated" style="position:relative;left:-15px;"><p><strong>Optimize Database after Deleting Revisions - LOG FILE DELETED</strong></p></div>';
514
  ?>
515
- <p><span style="font-style:italic;"><a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank" style="font-weight:bold;">Optimize Database after Deleting Revisions v<?php echo $odb_version?></a> - A WordPress Plugin by <a href="http://cagewebdev.com/" target="_blank" style="font-weight:bold;">CAGE Web Design</a> | <a href="http://cage.nl/" target="_blank" style="font-weight:bold;">Rolf van Gelder</a>, Eindhoven, The Netherlands</span></p>
516
- <p>Current options:<br />
517
- <strong>Maximum number of - most recent - revisions to keep per post / page:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $max_revisions?></span><br />
518
- <strong>Delete trashed items:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_trash_yn?></span><br />
519
- <strong>Delete spammed items:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_spam_yn?></span><br />
520
- <strong>Delete unused tags:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_tags_yn?></span><br />
521
- <strong>Delete expired transients:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_transients_yn?></span><br />
522
- <strong>Keep a log:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $rvg_odb_logging_on_yn?></span><br />
523
- <strong>Number of excluded tables:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $number_excluded?></span><br />
524
- <strong>Scheduler:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $rvg_odb_schedule_txt?></span>
525
  <?php
526
  if($nextrun)
527
  {
528
  ?>
529
  <br />
530
- <strong>Next scheduled run:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $nextrun?> hrs (current server time: <?php echo $current_hour?>)</span>
531
  <?php
532
  }
533
  if($total_savings)
534
  {
535
  ?>
536
  <br />
537
- <strong>Total savings since the first run:</strong> <span style="font-weight:bold;color:#00F;"><?php echo rvg_format_size($total_savings); ?></span>
538
  <?php
539
  }
540
  ?>
541
  <p class="submit">
542
- <input class="button" type="button" name="change_options" value="Change Options" onclick="self.location='options-general.php?page=rvg_odb_admin'" style="font-weight:normal;" />
543
  <?php
544
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
545
  {
546
  ?>
547
  &nbsp;
548
- <input class="button" type="button" name="view_log" value="View Log File" onclick="window.open('<?php echo $log_url?>','log','width=800,height=800,scrollbars=1')" style="font-weight:normal;" />
549
  &nbsp;
550
- <input class="button" type="button" name="delete_log" value="Delete Log File" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=delete_log'" style="font-weight:normal;" />
551
  <?php
552
  }
553
  $action = '';
@@ -556,7 +575,7 @@ function rvg_optimize_db()
556
  {
557
  ?>
558
  &nbsp;
559
- <input class="button-primary button-large" type="button" name="start_optimization" value="Start Optimization" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=run'" style="font-weight:bold;" />
560
  <?php
561
  }
562
  ?>
@@ -567,7 +586,7 @@ function rvg_optimize_db()
567
  if(isset($_REQUEST['action'])) $action = $_REQUEST['action'];
568
  if($action != 'run') return;
569
  ?>
570
- <h2 style="padding-left:8px;">Starting Optimization...</h2>
571
  <?php
572
  // GET THE SIZE OF THE DATABASE BEFORE OPTIMIZATION
573
  $start_size = rvg_get_db_size();
@@ -586,20 +605,20 @@ function rvg_optimize_db()
586
  ?>
587
  <table border="0" cellspacing="8" cellpadding="2">
588
  <tr>
589
- <td colspan="4" style="font-weight:bold;color:#00F;">DELETING REVISIONS:</td>
590
  </tr>
591
  <tr>
592
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
593
- <th align="left" style="border-bottom:solid 1px #999;">post / page</th>
594
- <th align="left" style="border-bottom:solid 1px #999;">revision date</th>
595
- <th align="right" style="border-bottom:solid 1px #999;">revisions deleted</th>
596
  </tr>
597
  <?php
598
  // LOOP THROUGH THE REVISIONS AND DELETE THEM
599
  $total_deleted = rvg_delete_revisions($results, true, $max_revisions);
600
  ?>
601
  <tr>
602
- <td colspan="3" align="right" style="border-top:solid 1px #999;font-weight:bold;">total number of revisions deleted</td>
603
  <td align="right" style="border-top:solid 1px #999;font-weight:bold;"><?php echo $total_deleted?></td>
604
  </tr>
605
  </table>
@@ -610,7 +629,7 @@ function rvg_optimize_db()
610
  ?>
611
  <table border="0" cellspacing="8" cellpadding="2">
612
  <tr>
613
- <td style="font-weight:bold;color:#21759b;">No REVISIONS found to delete...</td>
614
  </tr>
615
  </table>
616
  <?php
@@ -636,13 +655,13 @@ function rvg_optimize_db()
636
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
637
  <table border="0" cellspacing="8" cellpadding="2">
638
  <tr>
639
- <td colspan="4" style="font-weight:bold;color:#00F;">DELETING TRASHED ITEMS:</td>
640
  </tr>
641
  <tr>
642
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
643
- <th align="left" style="border-bottom:solid 1px #999;">type</th>
644
- <th align="left" style="border-bottom:solid 1px #999;">IP address / title</th>
645
- <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;">date</th>
646
  </tr>
647
  <?php
648
  // LOOP THROUGH THE TRASHED ITEMS AND DELETE THEM
@@ -657,7 +676,7 @@ function rvg_optimize_db()
657
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
658
  <table border="0" cellspacing="8" cellpadding="2">
659
  <tr>
660
- <td style="font-weight:bold;color:#21759b;">No TRASHED ITEMS found to delete...</td>
661
  </tr>
662
  </table>
663
  <?php
@@ -685,13 +704,13 @@ function rvg_optimize_db()
685
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
686
  <table border="0" cellspacing="8" cellpadding="2">
687
  <tr>
688
- <td colspan="4" style="font-weight:bold;color:#00F;">DELETING SPAMMED ITEMS:</td>
689
  </tr>
690
  <tr>
691
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
692
- <th align="left" style="border-bottom:solid 1px #999;">comment author</th>
693
- <th align="left" style="border-bottom:solid 1px #999;">comment author email</th>
694
- <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;">comment date</th>
695
  </tr>
696
  <?php
697
  // LOOP THROUGH SPAMMED ITEMS AND DELETE THEM
@@ -706,7 +725,7 @@ function rvg_optimize_db()
706
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
707
  <table border="0" cellspacing="8" cellpadding="2">
708
  <tr>
709
- <td style="font-weight:bold;color:#21759b;">No SPAMMED ITEMS found to delete...</td>
710
  </tr>
711
  </table>
712
  <?php
@@ -733,7 +752,7 @@ function rvg_optimize_db()
733
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
734
  <table border="0" cellspacing="8" cellpadding="2">
735
  <tr>
736
- <td><span style="font-weight:bold;color:#00F;">NUMBER OF UNUSED TAGS DELETED:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
737
  </tr>
738
  </table>
739
  <?php
@@ -744,7 +763,7 @@ function rvg_optimize_db()
744
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
745
  <table border="0" cellspacing="8" cellpadding="2">
746
  <tr>
747
- <td style="font-weight:bold;color:#21759b;">No UNUSED TAGS found to delete...</td>
748
  </tr>
749
  </table>
750
  <?php
@@ -771,7 +790,7 @@ function rvg_optimize_db()
771
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
772
  <table border="0" cellspacing="8" cellpadding="2">
773
  <tr>
774
- <td><span style="font-weight:bold;color:#00F;">NUMBER OF EXPIRED TRANSIENTS DELETED:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
775
  </tr>
776
  </table>
777
  <?php
@@ -782,7 +801,7 @@ function rvg_optimize_db()
782
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
783
  <table border="0" cellspacing="8" cellpadding="2">
784
  <tr>
785
- <td style="font-weight:bold;color:#21759b;">No EXPIRED TRANSIENTS found to delete...</td>
786
  </tr>
787
  </table>
788
  <?php
@@ -805,7 +824,7 @@ function rvg_optimize_db()
805
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
806
  <table border="0" cellspacing="8" cellpadding="2">
807
  <tr>
808
- <td colspan="4"><span style="font-weight:bold;color:#00F;">NUMBER OF POSTMETA ORPHANS DELETED:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
809
  </tr>
810
  </table>
811
  <?php
@@ -816,7 +835,7 @@ function rvg_optimize_db()
816
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
817
  <table border="0" cellspacing="8" cellpadding="2">
818
  <tr>
819
- <td style="font-weight:bold;color:#21759b;">No POSTMETA ORPHANS found to delete...</td>
820
  </tr>
821
  </table>
822
  <?php
@@ -833,15 +852,15 @@ function rvg_optimize_db()
833
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
834
  <table border="0" cellspacing="8" cellpadding="2">
835
  <tr>
836
- <td colspan="4" style="font-weight:bold;color:#00F;">OPTIMIZING DATABASE TABLES:</td>
837
  </tr>
838
  <tr>
839
  <th style="border-bottom:solid 1px #999;" align="right">#</th>
840
- <th style="border-bottom:solid 1px #999;" align="left">table name</th>
841
- <th style="border-bottom:solid 1px #999;" align="left">optimization result</th>
842
- <th style="border-bottom:solid 1px #999;" align="left">engine</th>
843
- <th style="border-bottom:solid 1px #999;" align="right">table rows</th>
844
- <th style="border-bottom:solid 1px #999;" align="right">table size</th>
845
  </tr>
846
  <?php
847
  # OPTIMIZE THE DATABASE TABLES
@@ -868,41 +887,41 @@ function rvg_optimize_db()
868
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
869
  <table border="0" cellspacing="8" cellpadding="2">
870
  <tr>
871
- <td colspan="2" style="font-weight:bold;color:#00F;">SAVINGS:</td>
872
  </tr>
873
  <tr>
874
  <th>&nbsp;</th>
875
- <th style="border-bottom:solid 1px #999;">size of the database</th>
876
  </tr>
877
  <tr>
878
- <td align="right">BEFORE optimization</td>
879
  <td align="right" style="font-weight:bold;"><?php echo rvg_format_size($start_size,3); ?></td>
880
  </tr>
881
  <tr>
882
- <td align="right">AFTER optimization</td>
883
  <td align="right" style="font-weight:bold;"><?php echo rvg_format_size($end_size,3); ?></td>
884
  </tr>
885
  <tr>
886
- <td align="right" style="font-weight:bold;">SAVINGS THIS TIME</td>
887
  <td align="right" style="font-weight:bold;border-top:solid 1px #999;"><?php echo rvg_format_size(($start_size - $end_size),3); ?></td>
888
  </tr>
889
  <tr>
890
- <td align="right" style="font-weight:bold;">TOTAL SAVINGS SINCE THE FIRST RUN</td>
891
  <td align="right" style="font-weight:bold;border-top:solid 1px #999;"><?php echo rvg_format_size($total_savings,3); ?></td>
892
  </tr>
893
  </table>
894
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span><br />
895
  <br />
896
- <span style="font-weight:bold;color:#00F;padding-left:8px;">DONE!</span><br />
897
  <br />
898
  <?php
899
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
900
  {
901
  ?>
902
  &nbsp;
903
- <input class="button" type="button" name="view_log" value="View Log File" onclick="window.open('<?php echo $log_url?>','log','width=800,height=800,scrollbars=1')" style="font-weight:normal;" />
904
  &nbsp;
905
- <input class="button" type="button" name="delete_log" value="Delete Log File" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=delete_log'" style="font-weight:normal;" />
906
  <?php
907
  }
908
  } // rvg_optimize_db ()
@@ -1441,27 +1460,21 @@ td {
1441
  <body>
1442
  <div id="header">
1443
  <h2><a href="http://wordpress.org/extend/plugins/rvg-optimize-database/" target="_blank">Optimize Database after Deleting Revisions v'.$odb_version.'</a></h2>
1444
- A WordPress Plugin by <a href="http://cagewebdev.com" target="_blank"><strong>CAGE Web Design</strong></a> | <a href="http://cage.nl/rg_biography.php" target="_blank"><strong>Rolf van Gelder</strong></a>, Eindhoven, The Netherlands</strong>
1445
  </div>
1446
  <table width="100%" border="0" cellspacing="6" cellpadding="1">
1447
  <tr>
1448
- <th width="9%" align="left" valign="top">time</th>
1449
- <th width="9%" align="right" valign="top">deleted<br />
1450
- revisions</th>
1451
- <th width="9%" align="right" valign="top">deleted<br />
1452
- trash</th>
1453
- <th width="9%" align="right" valign="top">deleted<br />
1454
- spam</th>
1455
- <th width="9%" align="right" valign="top">deleted<br />
1456
- tags</th>
1457
- <th width="9%" align="right" valign="top">deleted<br />
1458
- transients</th>
1459
- <th width="9%" align="right" valign="top">deleted<br />
1460
- orphans</th>
1461
- <th width="9%" align="right" valign="top">nr of optimized tables</th>
1462
- <th width="9%" align="right" valign="top">database size BEFORE</th>
1463
- <th width="9%" align="right" valign="top">database size AFTER</th>
1464
- <th width="9%" align="right" valign="top">SAVINGS</th>
1465
  </tr>
1466
  </table>
1467
  ';
1
  <?php
2
+ $odb_version = '2.9';
3
+ $odb_release_date = '10/22/2014';
4
  /**
5
  * @package Optimize Database after Deleting Revisions
6
+ * @version 2.9
7
  */
8
  /*
9
  Plugin Name: Optimize Database after Deleting Revisions
10
  Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/
11
  Description: Optimizes the Wordpress Database after Cleaning it out - <a href="options-general.php?page=rvg_odb_admin"><strong>plug in options</strong></a>
12
  Author: CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands
13
+ Version: 2.9
14
  Author URI: http://cagewebdev.com
15
  */
16
 
17
+ /********************************************************************************************
18
+
19
+ ADD THE LANGUAGE SUPPORT (LOCALIZATION)
20
+
21
+ *********************************************************************************************/
22
+ function odb_action_init()
23
+ {
24
+ // TEXT DOMAIN
25
+ load_plugin_textdomain('rvg-optimize-database', false, dirname(plugin_basename(__FILE__)));
26
+ }
27
+
28
+ // INIT HOOK
29
+ add_action('init', 'odb_action_init');
30
+
31
+
32
  /********************************************************************************************
33
 
34
  ADD THE 'OPTIMIZE DATABASE' ITEM TO THE TOOLS MENU
39
  { # v2.8: 'administrator' role changed to 'edit_themes' capability
40
  // add_management_page(__('Optimize Database'), __('Optimize Database'), 'edit_themes', 'rvg-optimize-db.php', 'rvg_optimize_db');
41
  # v2.8.1: changed capability back to 'administrator'
42
+ add_management_page(__('Optimize Database','rvg-optimize-database'), __('Optimize Database','rvg-optimize-database'), 'administrator','rvg-optimize-db.php', 'rvg_optimize_db');
43
  }
44
  }
45
  add_action('admin_menu', 'optimize_db_main');
53
  function rvg_odb_admin_menu()
54
  {
55
  if (function_exists('add_options_page'))
56
+ { add_options_page(__('Optimize DB Options'), __('Optimize DB Options','rvg-optimize-database'), 'manage_options', 'rvg_odb_admin', 'rvg_odb_options_page');
57
  }
58
  }
59
  add_action( 'admin_menu', 'rvg_odb_admin_menu' );
68
  { global $wp_admin_bar;
69
  if ( !is_super_admin() || !is_admin_bar_showing() ) return;
70
  $siteurl = site_url('/');
71
+ $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' ) );
72
  }
73
  $rvg_odb_adminbar = get_option('rvg_odb_adminbar');
74
  if($rvg_odb_adminbar == "Y") add_action( 'wp_before_admin_bar_render', 'rvg_odb_admin_bar' );
225
  }
226
 
227
  // UPDATED MESSAGE
228
+ echo "<div class='updated'><p><strong>".
229
+ __('Optimize Database after Deleting Revisions OPTIONS UPDATED','rvg-optimize-database').
230
+ "</strong> - ";
231
+ echo __('Click <a href="tools.php?page=rvg-optimize-db.php" style="font-weight:bold">HERE</a> to run the optimization','rvg-optimize-database');
232
+ echo "</p></div>";
233
  }
234
 
235
  $rvg_odb_number = get_option('rvg_odb_number');
272
  <?php // v2.8.3 ?>
273
  <?php wp_nonce_field( 'odb_action','odb_nonce' ); ?>
274
  <div class="wrap">
275
+ <h2><?php echo __('Using Optimize Database after Deleting Revisions', 'rvg-optimize-database'); ?></h2>
276
  <blockquote>
277
+ <p><strong>'<em>Optimize Database after Deleting Revisions</em> ' <?php echo __('is an one-click plugin to clean and optimize your WordPress database','rvg-optimize-database');?></strong></p>
278
+ <p><?php echo __('To start the optimization:','rvg-optimize-database');?><br />
279
+ <?php echo __('<strong>WP Admin Panel</strong> &raquo; <strong>Tools</strong> &raquo; <strong>Optimize Database</strong>. Then click the \'<strong>Start Optimization</strong>\'-button. Et voila!','rvg-optimize-database');?><br />
280
+ <?php echo __('Note: if you use the Scheduler the Optimization will run automatically!','rvg-optimize-database');?>
281
+ <p><?php echo __('Plugin version:','rvg-optimize-database');?><br />
282
  <strong>v<?php echo $odb_version ?> (<?php echo $odb_release_date?>)</strong> </p>
283
+ <p><strong><?php echo __('Author','rvg-optimize-database');?>:</strong><br />
284
+ <strong><a href="http://cagewebdev.com/" target="_blank">CAGE Web Design</a> | <a href="http://cage.nl/" target="_blank">Rolf van Gelder</a></strong>, Eindhoven, <?php echo __('The Netherlands','rvg-optimize-database');?><br />
285
+ <strong><?php echo __('Plugin URL:','rvg-optimize-database');?></strong><br />
286
  <a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank"><strong>http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/</strong></a><br />
287
+ <strong><?php echo __('Download URL:','rvg-optimize-database');?></strong><br />
288
  <strong><a href="http://wordpress.org/extend/plugins/rvg-optimize-database/" target="_blank">http://wordpress.org/extend/plugins/rvg-optimize-database/</a></strong></p>
289
  <p>&nbsp;</p>
290
  </blockquote>
291
+ <h2><?php echo __('Optimize Database after Deleting Revisions - Options','rvg-optimize-database');?></h2>
292
  <?php
293
  if($rvg_odb_adminbar == 'Y') $rvg_odb_adminbar_checked = ' checked="checked"'; else $rvg_odb_adminbar_checked = '';
294
  if($rvg_clear_trash == 'Y') $rvg_clear_trash_checked = ' checked="checked"'; else $rvg_clear_trash_checked = '';
303
  <tr>
304
  <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="4">
305
  <tr>
306
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?><br />
307
+ <?php echo __('(\'0\' means: delete <u>ALL</u> revisions)','rvg-optimize-database');?></span></td>
308
  <td width="50%" valign="top"><input type="text" size="5" name="rvg_odb_number" id="rvg_odb_number" value="<?php echo $rvg_odb_number?>" style="font-weight:bold;color:#00F;" /></td>
309
  </tr>
310
  <tr>
311
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Delete all trashed items','rvg-optimize-database');?></span></td>
312
  <td width="50%" valign="top"><input name="rvg_clear_trash" type="checkbox" value="Y" <?php echo $rvg_clear_trash_checked?> /></td>
313
  </tr>
314
  <tr>
315
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Delete all spammed items','rvg-optimize-database');?></span></td>
316
  <td width="50%" valign="top"><input name="rvg_clear_spam" type="checkbox" value="Y" <?php echo $rvg_clear_spam_checked?> /></td>
317
  </tr>
318
  <tr>
319
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Delete unused tags','rvg-optimize-database');?></span></td>
320
  <td width="50%" valign="top"><input name="rvg_clear_tags" type="checkbox" value="Y" <?php echo $rvg_clear_tags_checked?> /></td>
321
  </tr>
322
  <tr>
323
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Delete expired transients','rvg-optimize-database');?></span></td>
324
  <td width="50%" valign="top"><input name="rvg_clear_transients" type="checkbox" value="Y" <?php echo $rvg_clear_transients_checked?> /></td>
325
  </tr>
326
  <tr>
327
+ <td width="50%" align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Keep a log','rvg-optimize-database');?></span></td>
328
  <td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" <?php echo $rvg_odb_logging_on_checked?> /></td>
329
  </tr>
330
  <tr>
331
+ <td width="50%" align="right"><span style="font-weight:bold;"><?php echo __('Scheduler','rvg-optimize-database');?></span></td>
332
  <td width="50%"><select name="rvg_odb_schedule" id="rvg_odb_schedule" onchange="schedule_changed();">
333
+ <option selected="selected" value=""><?php echo __('NOT SCHEDULED','rvg-optimize-database');?></option>
334
+ <option value="hourly"><?php echo __('run optimization HOURLY','rvg-optimize-database');?></option>
335
+ <option value="twicedaily"><?php echo __('run optimization TWICE A DAY','rvg-optimize-database');?></option>
336
+ <option value="daily"><?php echo __('run optimization DAILY','rvg-optimize-database');?></option>
337
+ <option value="weekly"><?php echo __('run optimization WEEKLY','rvg-optimize-database');?></option>
338
  <?php /*?><option value="test">run optimization TEST</option><?php */?>
339
  </select>
340
  <script type="text/javascript">
341
  document.options.rvg_odb_schedule.value = '<?php echo $rvg_odb_schedule; ?>';
342
  </script>
343
+ <span id="schedulehour" style="display:none;"> <span style="font-weight:bold;"><?php echo __('Time','rvg-optimize-database');?></span>
344
  <select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour">
345
  <?php
346
  for($i=0; $i<=23; $i++)
347
  { if($i<10) $i = '0'.$i;
348
  ?>
349
+ <option value="<?php echo $i?>"><?php echo $i.':00 '.__('hrs','rvg-optimize-database')?></option>
350
  <?php
351
  }
352
  ?>
358
  <script type="text/javascript">schedule_changed();</script></td>
359
  </tr>
360
  <tr>
361
+ <td align="right" valign="top"><span style="font-weight:bold;"><?php echo __('Show \'1-click\' link in Admin Bar','rvg-optimize-database');?></span></td>
362
  <td valign="top"><input name="rvg_odb_adminbar" type="checkbox" value="Y" <?php echo $rvg_odb_adminbar_checked?> />
363
+ <?php echo __('(change will be visible after loading the next page)','rvg-optimize-database');?></td>
364
  </tr>
365
  </table></td>
366
  </tr>
372
  <tr>
373
  <td colspan="4" valign="top"><table id="table_list" width="100%" border="0" cellspacing="0" cellpadding="4" style="display:block;">
374
  <tr>
375
+ <td colspan="4" align="center"><span style="font-weight:bold;"><?php echo __('EXCLUDE DATABASE TABLES FROM OPTIMIZATION: <span style="text-decoration:underline;color:#F00;">CHECKED</span> TABLES <span style="text-decoration:underline;color:#F00;">WON\'T</span> BE OPTIMIZED!</span>','rvg-optimize-database');?><br />
376
+ <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>
377
  </tr>
378
  <tr>
379
  <?php
411
  </fieldset>
412
  </blockquote>
413
  <p class="submit">
414
+ <input class="button-primary button-large" type='submit' name='info_update' value='<?php echo __('Save Options','rvg-optimize-database');?>' style="font-weight:bold;" />
415
  &nbsp;
416
+ <input class="button" type="button" name="optimizer" value="<?php echo __('Go To Optimizer','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php'" style="font-weight:normal;" />
417
  </p>
418
  </div>
419
  </form>
456
  { $clear_trash = 'N';
457
  update_option('rvg_clear_trash', $clear_trash);
458
  }
459
+ $clear_trash_yn = ($clear_trash == 'N') ? __('NO','rvg-optimize-database') : __('YES','rvg-optimize-database');
460
 
461
  $clear_spam = get_option('rvg_clear_spam');
462
  if(!$clear_spam)
463
  { $clear_spam = 'N';
464
  update_option('rvg_clear_spam', $clear_spam);
465
  }
466
+ $clear_spam_yn = ($clear_spam == 'N') ? __('NO','rvg-optimize-database') : __('YES','rvg-optimize-database');
467
 
468
  $clear_tags = get_option('rvg_clear_tags');
469
  if(!$clear_tags)
470
  { $clear_tags = 'N';
471
  update_option('rvg_clear_tags', $clear_tags);
472
  }
473
+ $clear_tags_yn = ($clear_tags == 'N') ? __('NO','rvg-optimize-database') : __('YES','rvg-optimize-database');
474
 
475
  $clear_transients = get_option('rvg_clear_transients');
476
  if(!$clear_transients)
477
  { $clear_transients = 'N';
478
  update_option('rvg_clear_transients', $clear_transients);
479
  }
480
+ $clear_transients_yn = ($clear_transients == 'N') ? __('NO','rvg-optimize-database') : __('YES','rvg-optimize-database');
481
 
482
  $rvg_odb_logging_on = get_option('rvg_odb_logging_on');
483
  if(!$rvg_odb_logging_on)
484
  { $rvg_odb_logging_on = 'N';
485
  update_option('rvg_odb_logging_on', $rvg_odb_logging_on);
486
  }
487
+ $rvg_odb_logging_on_yn = ($rvg_odb_logging_on == 'N') ? __('NO','rvg-optimize-database') : __('YES','rvg-optimize-database');
488
 
489
  $rvg_odb_schedule = get_option('rvg_odb_schedule');
490
  if(!$rvg_odb_schedule)
493
  }
494
 
495
  if($rvg_odb_schedule == 'hourly')
496
+ $rvg_odb_schedule_txt = __('ONCE HOURLY','rvg-optimize-database');
497
  else if($rvg_odb_schedule == 'twicedaily')
498
+ $rvg_odb_schedule_txt = __('TWICE DAILY','rvg-optimize-database');
499
  else if($rvg_odb_schedule == 'daily')
500
+ $rvg_odb_schedule_txt = __('ONCE DAILY','rvg-optimize-database');
501
  else if($rvg_odb_schedule == 'weekly')
502
+ $rvg_odb_schedule_txt = __('ONCE WEEKLY','rvg-optimize-database');
503
  else if($rvg_odb_schedule == 'test')
504
  $rvg_odb_schedule_txt = 'TEST';
505
 
506
  $nextrun = '';
507
  if(!isset($rvg_odb_schedule_txt))
508
+ { $rvg_odb_schedule_txt = __('NOT SCHEDULED','rvg-optimize-database');
509
  }
510
  else
511
  { $timestamp = wp_next_scheduled('rvg_optimize_database');
525
  $number_excluded = $results[0] -> cnt;
526
  ?>
527
  <div style="padding-left:8px;">
528
+ <h2><?php echo __('Optimize your WordPress Database','rvg-optimize-database');?></h2>
529
  <?php
530
  if(isset($_REQUEST['action']))
531
  if($_REQUEST['action'] == "delete_log")
532
  echo '<div class="updated" style="position:relative;left:-15px;"><p><strong>Optimize Database after Deleting Revisions - LOG FILE DELETED</strong></p></div>';
533
  ?>
534
+ <p><span style="font-style:italic;"><a href="http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank" style="font-weight:bold;">Optimize Database after Deleting Revisions v<?php echo $odb_version?></a> - <?php echo __('A WordPress Plugin by','rvg-optimize-database');?> <a href="http://cagewebdev.com/" target="_blank" style="font-weight:bold;">CAGE Web Design</a> | <a href="http://cage.nl/" target="_blank" style="font-weight:bold;">Rolf van Gelder</a>, Eindhoven, <?php echo __('The Netherlands','rvg-optimize-database');?></span></p>
535
+ <p><?php echo __('Current options','rvg-optimize-database');?>:<br />
536
+ <strong><?php echo __('Maximum number of - most recent - revisions to keep per post / page','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $max_revisions?></span><br />
537
+ <strong><?php echo __('Delete all trashed items','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_trash_yn?></span><br />
538
+ <strong><?php echo __('Delete all spammed items','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_spam_yn?></span><br />
539
+ <strong><?php echo __('Delete unused tags','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_tags_yn?></span><br />
540
+ <strong><?php echo __('Delete expired transients','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $clear_transients_yn?></span><br />
541
+ <strong><?php echo __('Keep a log','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $rvg_odb_logging_on_yn?></span><br />
542
+ <strong><?php echo __('Number of excluded tables','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $number_excluded?></span><br />
543
+ <strong><?php echo __('Scheduler','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $rvg_odb_schedule_txt?></span>
544
  <?php
545
  if($nextrun)
546
  {
547
  ?>
548
  <br />
549
+ <strong><?php echo __('Next scheduled run','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo $nextrun?> hrs (current server time: <?php echo $current_hour?>)</span>
550
  <?php
551
  }
552
  if($total_savings)
553
  {
554
  ?>
555
  <br />
556
+ <strong><?php echo __('Total savings since the first run','rvg-optimize-database');?>:</strong> <span style="font-weight:bold;color:#00F;"><?php echo rvg_format_size($total_savings); ?></span>
557
  <?php
558
  }
559
  ?>
560
  <p class="submit">
561
+ <input class="button" type="button" name="change_options" value="<?php echo __('Change Options','rvg-optimize-database');?>" onclick="self.location='options-general.php?page=rvg_odb_admin'" style="font-weight:normal;" />
562
  <?php
563
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
564
  {
565
  ?>
566
  &nbsp;
567
+ <input class="button" type="button" name="view_log" value="<?php echo __('View Log File','rvg-optimize-database');?>" onclick="window.open('<?php echo $log_url?>','log','width=800,height=800,scrollbars=1')" style="font-weight:normal;" />
568
  &nbsp;
569
+ <input class="button" type="button" name="delete_log" value="<?php echo __('Delete Log File','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=delete_log'" style="font-weight:normal;" />
570
  <?php
571
  }
572
  $action = '';
575
  {
576
  ?>
577
  &nbsp;
578
+ <input class="button-primary button-large" type="button" name="start_optimization" value="<?php echo __('Start Optimization','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=run'" style="font-weight:bold;" />
579
  <?php
580
  }
581
  ?>
586
  if(isset($_REQUEST['action'])) $action = $_REQUEST['action'];
587
  if($action != 'run') return;
588
  ?>
589
+ <h2 style="padding-left:8px;"><?php echo __('Starting Optimization','rvg-optimize-database');?>...</h2>
590
  <?php
591
  // GET THE SIZE OF THE DATABASE BEFORE OPTIMIZATION
592
  $start_size = rvg_get_db_size();
605
  ?>
606
  <table border="0" cellspacing="8" cellpadding="2">
607
  <tr>
608
+ <td colspan="4" style="font-weight:bold;color:#00F;"><?php echo __('DELETING REVISIONS','rvg-optimize-database');?>:</td>
609
  </tr>
610
  <tr>
611
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
612
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('post / page','rvg-optimize-database');?></th>
613
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('revision date','rvg-optimize-database');?></th>
614
+ <th align="right" style="border-bottom:solid 1px #999;"><?php echo __('revisions deleted','rvg-optimize-database');?></th>
615
  </tr>
616
  <?php
617
  // LOOP THROUGH THE REVISIONS AND DELETE THEM
618
  $total_deleted = rvg_delete_revisions($results, true, $max_revisions);
619
  ?>
620
  <tr>
621
+ <td colspan="3" align="right" style="border-top:solid 1px #999;font-weight:bold;"><?php echo __('total number of revisions deleted','rvg-optimize-database');?></td>
622
  <td align="right" style="border-top:solid 1px #999;font-weight:bold;"><?php echo $total_deleted?></td>
623
  </tr>
624
  </table>
629
  ?>
630
  <table border="0" cellspacing="8" cellpadding="2">
631
  <tr>
632
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No REVISIONS found to delete','rvg-optimize-database');?>...</td>
633
  </tr>
634
  </table>
635
  <?php
655
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
656
  <table border="0" cellspacing="8" cellpadding="2">
657
  <tr>
658
+ <td colspan="4" style="font-weight:bold;color:#00F;"><?php echo __('DELETING TRASHED ITEMS','rvg-optimize-database');?>:</td>
659
  </tr>
660
  <tr>
661
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
662
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('type','rvg-optimize-database');?></th>
663
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('IP address / title','rvg-optimize-database');?></th>
664
+ <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;"><?php echo __('date','rvg-optimize-database');?></th>
665
  </tr>
666
  <?php
667
  // LOOP THROUGH THE TRASHED ITEMS AND DELETE THEM
676
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
677
  <table border="0" cellspacing="8" cellpadding="2">
678
  <tr>
679
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No TRASHED ITEMS found to delete','rvg-optimize-database');?>...</td>
680
  </tr>
681
  </table>
682
  <?php
704
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
705
  <table border="0" cellspacing="8" cellpadding="2">
706
  <tr>
707
+ <td colspan="4" style="font-weight:bold;color:#00F;"><?php echo __('DELETING SPAMMED ITEMS','rvg-optimize-database');?>:</td>
708
  </tr>
709
  <tr>
710
  <th align="right" style="border-bottom:solid 1px #999;">#</th>
711
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('comment author','rvg-optimize-database');?></th>
712
+ <th align="left" style="border-bottom:solid 1px #999;"><?php echo __('comment author email','rvg-optimize-database');?></th>
713
+ <th align="left" nowrap="nowrap" style="border-bottom:solid 1px #999;"><?php echo __('comment date','rvg-optimize-database');?></th>
714
  </tr>
715
  <?php
716
  // LOOP THROUGH SPAMMED ITEMS AND DELETE THEM
725
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
726
  <table border="0" cellspacing="8" cellpadding="2">
727
  <tr>
728
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No SPAMMED ITEMS found to delete','rvg-optimize-database');?>...</td>
729
  </tr>
730
  </table>
731
  <?php
752
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
753
  <table border="0" cellspacing="8" cellpadding="2">
754
  <tr>
755
+ <td><span style="font-weight:bold;color:#00F;"><?php echo __('NUMBER OF UNUSED TAGS DELETED','rvg-optimize-database');?>:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
756
  </tr>
757
  </table>
758
  <?php
763
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
764
  <table border="0" cellspacing="8" cellpadding="2">
765
  <tr>
766
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No UNUSED TAGS found to delete','rvg-optimize-database');?>...</td>
767
  </tr>
768
  </table>
769
  <?php
790
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
791
  <table border="0" cellspacing="8" cellpadding="2">
792
  <tr>
793
+ <td><span style="font-weight:bold;color:#00F;"><?php echo __('NUMBER OF EXPIRED TRANSIENTS DELETED','rvg-optimize-database');?>:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
794
  </tr>
795
  </table>
796
  <?php
801
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
802
  <table border="0" cellspacing="8" cellpadding="2">
803
  <tr>
804
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No EXPIRED TRANSIENTS found to delete','rvg-optimize-database');?>...</td>
805
  </tr>
806
  </table>
807
  <?php
824
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
825
  <table border="0" cellspacing="8" cellpadding="2">
826
  <tr>
827
+ <td colspan="4"><span style="font-weight:bold;color:#00F;"><?php echo __('NUMBER OF POSTMETA ORPHANS DELETED','rvg-optimize-database');?>:</span> <span style="font-weight:bold;"><?php echo $total_deleted;?></span></td>
828
  </tr>
829
  </table>
830
  <?php
835
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
836
  <table border="0" cellspacing="8" cellpadding="2">
837
  <tr>
838
+ <td style="font-weight:bold;color:#21759b;"><?php echo __('No POSTMETA ORPHANS found to delete','rvg-optimize-database');?>...</td>
839
  </tr>
840
  </table>
841
  <?php
852
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
853
  <table border="0" cellspacing="8" cellpadding="2">
854
  <tr>
855
+ <td colspan="4" style="font-weight:bold;color:#00F;"><?php echo __('OPTIMIZING DATABASE TABLES','rvg-optimize-database');?>:</td>
856
  </tr>
857
  <tr>
858
  <th style="border-bottom:solid 1px #999;" align="right">#</th>
859
+ <th style="border-bottom:solid 1px #999;" align="left"><?php echo __('table name','rvg-optimize-database');?></th>
860
+ <th style="border-bottom:solid 1px #999;" align="left"><?php echo __('optimization result','rvg-optimize-database');?></th>
861
+ <th style="border-bottom:solid 1px #999;" align="left"><?php echo __('engine','rvg-optimize-database');?></th>
862
+ <th style="border-bottom:solid 1px #999;" align="right"><?php echo __('table rows','rvg-optimize-database');?></th>
863
+ <th style="border-bottom:solid 1px #999;" align="right"><?php echo __('table size','rvg-optimize-database');?></th>
864
  </tr>
865
  <?php
866
  # OPTIMIZE THE DATABASE TABLES
887
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span>
888
  <table border="0" cellspacing="8" cellpadding="2">
889
  <tr>
890
+ <td colspan="2" style="font-weight:bold;color:#00F;"><?php echo __('SAVINGS','rvg-optimize-database');?>:</td>
891
  </tr>
892
  <tr>
893
  <th>&nbsp;</th>
894
+ <th style="border-bottom:solid 1px #999;"><?php echo __('size of the database','rvg-optimize-database');?></th>
895
  </tr>
896
  <tr>
897
+ <td align="right"><?php echo __('BEFORE optimization','rvg-optimize-database');?></td>
898
  <td align="right" style="font-weight:bold;"><?php echo rvg_format_size($start_size,3); ?></td>
899
  </tr>
900
  <tr>
901
+ <td align="right"><?php echo __('AFTER optimization','rvg-optimize-database');?></td>
902
  <td align="right" style="font-weight:bold;"><?php echo rvg_format_size($end_size,3); ?></td>
903
  </tr>
904
  <tr>
905
+ <td align="right" style="font-weight:bold;"><?php echo __('SAVINGS THIS TIME','rvg-optimize-database');?></td>
906
  <td align="right" style="font-weight:bold;border-top:solid 1px #999;"><?php echo rvg_format_size(($start_size - $end_size),3); ?></td>
907
  </tr>
908
  <tr>
909
+ <td align="right" style="font-weight:bold;"><?php echo __('TOTAL SAVINGS SINCE THE FIRST RUN','rvg-optimize-database');?></td>
910
  <td align="right" style="font-weight:bold;border-top:solid 1px #999;"><?php echo rvg_format_size($total_savings,3); ?></td>
911
  </tr>
912
  </table>
913
  <span style="font-weight:bold;color:#000;padding-left:8px;">~~~~~</span><br />
914
  <br />
915
+ <span style="font-weight:bold;color:#00F;padding-left:8px;"><?php echo __('DONE','rvg-optimize-database');?>!</span><br />
916
  <br />
917
  <?php
918
  if(file_exists(dirname(__FILE__).'/rvg-optimize-db-log.html'))
919
  {
920
  ?>
921
  &nbsp;
922
+ <input class="button" type="button" name="view_log" value="<?php echo __('View Log File','rvg-optimize-database');?>" onclick="window.open('<?php echo $log_url?>','log','width=800,height=800,scrollbars=1')" style="font-weight:normal;" />
923
  &nbsp;
924
+ <input class="button" type="button" name="delete_log" value="<?php echo __('Delete Log File','rvg-optimize-database');?>" onclick="self.location='tools.php?page=rvg-optimize-db.php&action=delete_log'" style="font-weight:normal;" />
925
  <?php
926
  }
927
  } // rvg_optimize_db ()
1460
  <body>
1461
  <div id="header">
1462
  <h2><a href="http://wordpress.org/extend/plugins/rvg-optimize-database/" target="_blank">Optimize Database after Deleting Revisions v'.$odb_version.'</a></h2>
1463
+ '.__('A WordPress Plugin by','rvg-optimize-database').' <a href="http://cagewebdev.com" target="_blank"><strong>CAGE Web Design</strong></a> | <a href="http://cage.nl/rg_biography.php" target="_blank"><strong>Rolf van Gelder</strong></a>, Eindhoven, '.__('The Netherlands','rvg-optimize-database').'</strong>
1464
  </div>
1465
  <table width="100%" border="0" cellspacing="6" cellpadding="1">
1466
  <tr>
1467
+ <th width="9%" align="left" valign="top">'.__('time','rvg-optimize-database').'</th>
1468
+ <th width="9%" align="right" valign="top">'.__('deleted<br />revisions','rvg-optimize-database').'</th>
1469
+ <th width="9%" align="right" valign="top">'.__('deleted<br />trash','rvg-optimize-database').'</th>
1470
+ <th width="9%" align="right" valign="top">'.__('deleted<br />spam','rvg-optimize-database').'</th>
1471
+ <th width="9%" align="right" valign="top">'.__('deleted<br />tags','rvg-optimize-database').'</th>
1472
+ <th width="9%" align="right" valign="top">'.__('deleted<br />transients','rvg-optimize-database').'</th>
1473
+ <th width="9%" align="right" valign="top">'.__('deleted<br />orphans','rvg-optimize-database').'</th>
1474
+ <th width="9%" align="right" valign="top">'.__('nr of optimized tables','rvg-optimize-database').'</th>
1475
+ <th width="9%" align="right" valign="top">'.__('database size BEFORE','rvg-optimize-database').'</th>
1476
+ <th width="9%" align="right" valign="top">'.__('database size AFTER','rvg-optimize-database').'</th>
1477
+ <th width="9%" align="right" valign="top">'.__('SAVINGS','rvg-optimize-database').'</th>
 
 
 
 
 
 
1478
  </tr>
1479
  </table>
1480
  ';