WP-Optimize - Version 1.9.1

Version Description

  • Ability to clean up Unused Post Meta, Comment Meta and Broken Relationship Data
  • Warning prompts for RED marked items and optimize button
  • Better transient options cleaning.
  • Language files update.
  • Various other fixes
Download this release

Release Info

Developer DavidAnderson
Plugin Icon 128x128 WP-Optimize
Version 1.9.1
Comparing to
See all releases

Code changes from version 1.9 to 1.9.1

Files changed (13) hide show
  1. elegantthemes_sm.png → images/elegantthemes_sm.png +0 -0
  2. embedplus.png → images/embedplus.png +0 -0
  3. images/mythemeshop.png +0 -0
  4. languages/wp-optimize.pot +226 -162
  5. readme.txt +9 -17
  6. screenshot-1.jpg +0 -0
  7. screenshot-2.jpg +0 -0
  8. translate.txt +0 -26
  9. wp-optimize-common.php +73 -63
  10. wp-optimize-credits.php +15 -9
  11. wp-optimize-main.php +83 -20
  12. wp-optimize-settings.php +1 -1
  13. wp-optimize.php +2 -2
elegantthemes_sm.png → images/elegantthemes_sm.png RENAMED
File without changes
embedplus.png → images/embedplus.png RENAMED
File without changes
images/mythemeshop.png ADDED
Binary file
languages/wp-optimize.pot CHANGED
@@ -1,16 +1,22 @@
1
  # Copyright (C) 2015 WP-Optimize
2
  # This file is distributed under the same license as the WP-Optimize package.
 
3
  msgid ""
4
  msgstr ""
5
  "Project-Id-Version: WP-Optimize 1.8.9.8\n"
6
  "Report-Msgid-Bugs-To: http://wordpress.org/tag/wp-optimize\n"
7
- "POT-Creation-Date: 2015-03-02 15:32:37+00:00\n"
8
  "MIME-Version: 1.0\n"
9
  "Content-Type: text/plain; charset=UTF-8\n"
10
  "Content-Transfer-Encoding: 8bit\n"
11
  "PO-Revision-Date: 2015-MO-DA HO:MI+ZONE\n"
12
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
13
  "Language-Team: LANGUAGE <LL@li.org>\n"
 
 
 
 
 
14
 
15
  #: wp-optimize-admin.php:25 wp-optimize-admin.php:43 wp-optimize.php:96
16
  msgid "Optimizer"
@@ -69,48 +75,81 @@ msgid "bytes"
69
  msgstr ""
70
 
71
  #: wp-optimize-common.php:635
72
- msgid "transient options deleted"
73
- msgstr ""
 
 
 
74
 
75
  #: wp-optimize-common.php:662
76
- msgid "post revisions deleted"
77
- msgstr ""
 
 
 
78
 
79
  #: wp-optimize-common.php:673
80
- msgid "auto drafts deleted"
81
- msgstr ""
 
 
 
82
 
83
  #: wp-optimize-common.php:683
84
- msgid "items removed from Trash"
85
- msgstr ""
 
 
 
86
 
87
  #: wp-optimize-common.php:695
88
- msgid "spam comments deleted"
89
- msgstr ""
 
 
 
90
 
91
  #: wp-optimize-common.php:704
92
- msgid "comments removed from Trash"
93
- msgstr ""
 
 
 
94
 
95
  #: wp-optimize-common.php:710
96
- msgid "unused comment metadata items removed"
97
- msgstr ""
 
 
 
98
 
99
  #: wp-optimize-common.php:716
100
- msgid "unused akismet comment metadata items removed"
101
- msgstr ""
 
 
 
102
 
103
  #: wp-optimize-common.php:726
104
- msgid "unapproved comments deleted"
105
- msgstr ""
 
 
 
106
 
107
  #: wp-optimize-common.php:732
108
- msgid "pingbacks deleted"
109
- msgstr ""
 
 
 
110
 
111
  #: wp-optimize-common.php:738
112
- msgid "trackbacks deleted"
113
- msgstr ""
 
 
 
114
 
115
  #: wp-optimize-common.php:745
116
  msgid "Enabled weekly processing"
@@ -125,48 +164,66 @@ msgid "NO Actions Taken"
125
  msgstr ""
126
 
127
  #: wp-optimize-common.php:787
128
- msgid "transient options in your database"
129
- msgstr ""
 
 
 
130
 
131
  #: wp-optimize-common.php:789
132
  msgid "No transient options found"
133
  msgstr ""
134
 
135
  #: wp-optimize-common.php:798
136
- msgid "orphaned postmeta in your database"
137
- msgstr ""
 
 
 
138
 
139
  #: wp-optimize-common.php:800
140
  msgid "No orphaned postmeta in your database"
141
  msgstr ""
142
 
143
  #: wp-optimize-common.php:809
144
- msgid "unused tags in your database"
145
- msgstr ""
 
 
 
146
 
147
  #: wp-optimize-common.php:811
148
  msgid "No unused tags found"
149
  msgstr ""
150
 
151
  #: wp-optimize-common.php:824
152
- msgid "post revisions in your database"
153
- msgstr ""
 
 
 
154
 
155
  #: wp-optimize-common.php:826
156
  msgid "No post revisions found"
157
  msgstr ""
158
 
159
  #: wp-optimize-common.php:839
160
- msgid "auto draft post(s) in your database"
161
- msgstr ""
 
 
 
162
 
163
  #: wp-optimize-common.php:841
164
  msgid "No auto draft posts found"
165
  msgstr ""
166
 
167
  #: wp-optimize-common.php:853
168
- msgid "spam comments found"
169
- msgstr ""
 
 
 
170
 
171
  #: wp-optimize-common.php:853 wp-optimize-common.php:884
172
  msgid "Review"
@@ -177,24 +234,33 @@ msgid "No spam comments found"
177
  msgstr ""
178
 
179
  #: wp-optimize-common.php:884
180
- msgid "unapproved comments found"
181
- msgstr ""
 
 
 
182
 
183
  #: wp-optimize-common.php:886
184
  msgid "No unapproved comments found"
185
  msgstr ""
186
 
187
  #: wp-optimize-common.php:894
188
- msgid "Pingbacks found"
189
- msgstr ""
 
 
 
190
 
191
  #: wp-optimize-common.php:896
192
  msgid "No pingbacks found"
193
  msgstr ""
194
 
195
  #: wp-optimize-common.php:904
196
- msgid "Trackbacks found"
197
- msgstr ""
 
 
 
198
 
199
  #: wp-optimize-common.php:906
200
  msgid "No trackbacks found"
@@ -289,7 +355,9 @@ msgid "No items"
289
  msgstr ""
290
 
291
  #: wp-optimize-main.php:76
292
- msgid "Database Optimized!"
 
 
293
  msgstr ""
294
 
295
  #: wp-optimize-main.php:154 wp-optimize-main.php:156
@@ -297,336 +365,329 @@ msgid "Clean-up options"
297
  msgstr ""
298
 
299
  #: wp-optimize-main.php:165
300
- msgid "Clean post revisions which are older than "
 
301
  msgstr ""
302
 
303
- #: wp-optimize-main.php:168 wp-optimize-main.php:186 wp-optimize-main.php:206
304
- #: wp-optimize-main.php:225
305
- msgid "weeks"
306
- msgstr ""
307
-
308
- #: wp-optimize-main.php:170
309
  msgid "Clean all post revisions"
310
  msgstr ""
311
 
312
- #: wp-optimize-main.php:183
313
- msgid "Clean auto draft posts which are older than "
 
314
  msgstr ""
315
 
316
- #: wp-optimize-main.php:188
317
  msgid "Clean all auto draft posts and posts in trash"
318
  msgstr ""
319
 
320
- #: wp-optimize-main.php:203
321
- msgid "Remove spam comments which are older than "
 
322
  msgstr ""
323
 
324
- #: wp-optimize-main.php:208
325
  msgid "Remove spam comments and comments in trash"
326
  msgstr ""
327
 
328
- #: wp-optimize-main.php:222
329
- msgid "Remove unapproved comments which are older than "
 
330
  msgstr ""
331
 
332
- #: wp-optimize-main.php:227 wp-optimize-settings.php:288
333
  msgid "Remove unapproved comments"
334
  msgstr ""
335
 
336
- #: wp-optimize-main.php:240 wp-optimize-settings.php:293
337
  msgid "Remove transient options"
338
  msgstr ""
339
 
340
- #: wp-optimize-main.php:251
341
  msgid "Remove pingbacks"
342
  msgstr ""
343
 
344
- #: wp-optimize-main.php:262
345
  msgid "Remove trackbacks"
346
  msgstr ""
347
 
348
- #: wp-optimize-main.php:272
349
  msgid "Do not select RED marked items unless you really need to use them"
350
  msgstr ""
351
 
352
- #: wp-optimize-main.php:278 wp-optimize-settings.php:207
353
- msgid "Optimize your YouTube embedding in WordPress with this plugin"
354
  msgstr ""
355
 
356
- #: wp-optimize-main.php:288
357
  msgid "Actions"
358
  msgstr ""
359
 
360
- #: wp-optimize-main.php:297
361
  msgid "Optimize database tables"
362
  msgstr ""
363
 
364
- #: wp-optimize-main.php:305
365
  msgid "Note:"
366
  msgstr ""
367
 
368
- #: wp-optimize-main.php:308
369
  msgid "InnoDB tables will not be optimized"
370
  msgstr ""
371
 
372
- #: wp-optimize-main.php:314
373
  msgid "Select safe options"
374
  msgstr ""
375
 
376
- #: wp-optimize-main.php:315
377
  msgid "Warning:"
378
  msgstr ""
379
 
380
- #: wp-optimize-main.php:316
381
  msgid "Always make a backup of your DB when you upgrade to major versions"
382
  msgstr ""
383
 
384
- #: wp-optimize-main.php:321
385
  msgid "PROCESS"
386
  msgstr ""
387
 
388
- #: wp-optimize-main.php:327
389
  msgid "Please donate! It really helps me keep improvising"
390
  msgstr ""
391
 
392
- #: wp-optimize-main.php:327
393
  msgid "Donate!"
394
  msgstr ""
395
 
396
- #: wp-optimize-main.php:328
397
- msgid "Please give a proper rating:)"
398
  msgstr ""
399
 
400
- #: wp-optimize-main.php:329
401
  msgid "Rating"
402
  msgstr ""
403
 
404
- #: wp-optimize-main.php:334
405
- msgid "Status log: "
406
  msgstr ""
407
 
408
- #: wp-optimize-main.php:349
409
  msgid "Last automatic optimization was at"
410
  msgstr ""
411
 
412
- #: wp-optimize-main.php:361
413
  msgid "There was no automatic optimization"
414
  msgstr ""
415
 
416
- #: wp-optimize-main.php:376
417
  msgid "Scheduled cleaning enabled"
418
  msgstr ""
419
 
420
- #: wp-optimize-main.php:388
421
- msgid "Next schedule"
422
  msgstr ""
423
 
424
- #: wp-optimize-main.php:399
425
  msgid "Refresh"
426
  msgstr ""
427
 
428
- #: wp-optimize-main.php:408
429
  msgid "Scheduled cleaning disabled"
430
  msgstr ""
431
 
432
- #: wp-optimize-main.php:411 wp-optimize-main.php:436
433
  msgid "Check settings"
434
  msgstr ""
435
 
436
- #: wp-optimize-main.php:422
437
- msgid "Keeping last "
 
438
  msgstr ""
439
 
440
- #: wp-optimize-main.php:425 wp-optimize-settings.php:148
441
- msgid "weeks data"
442
- msgstr ""
443
-
444
- #: wp-optimize-main.php:433
445
  msgid "Not keeping recent data"
446
  msgstr ""
447
 
448
- #: wp-optimize-main.php:450
449
- msgid "Current database size : "
450
- msgstr ""
451
-
452
- #: wp-optimize-main.php:455
453
- msgid "You have saved"
454
  msgstr ""
455
 
456
- #: wp-optimize-main.php:462
457
- msgid "Current database size"
458
  msgstr ""
459
 
460
- #: wp-optimize-main.php:470
461
- msgid "You can save almost"
462
  msgstr ""
463
 
464
- #: wp-optimize-main.php:487
465
- msgid "Total clean up overall"
466
  msgstr ""
467
 
468
- #: wp-optimize-main.php:508
469
  msgid "Sponsor"
470
  msgstr ""
471
 
472
- #: wp-optimize-settings.php:88
473
  msgid "Trackbacks disabled on all current and previously published posts"
474
  msgstr ""
475
 
476
- #: wp-optimize-settings.php:94
477
  msgid "Trackbacks enabled on all current and previously published posts"
478
  msgstr ""
479
 
480
- #: wp-optimize-settings.php:103
481
  msgid "Comments disabled on all current and previously published posts"
482
  msgstr ""
483
 
484
- #: wp-optimize-settings.php:109
485
  msgid "Comments enabled on all current and previously published posts"
486
  msgstr ""
487
 
488
- #: wp-optimize-settings.php:115
489
  msgid "Settings updated"
490
  msgstr ""
491
 
492
- #: wp-optimize-settings.php:132
493
  msgid "General Settings"
494
  msgstr ""
495
 
496
- #: wp-optimize-settings.php:137
497
- msgid "Keep last "
 
498
  msgstr ""
499
 
500
- #: wp-optimize-settings.php:153
501
  msgid "This option will retain the last selected weeks data and remove any garbage data before that period. This will also affect Auto Clean-up process"
502
  msgstr ""
503
 
504
- #: wp-optimize-settings.php:162
505
- msgid "Enable admin bar link "
506
  msgstr ""
507
 
508
- #: wp-optimize-settings.php:164
509
  msgid "(Click here to refresh)"
510
  msgstr ""
511
 
512
- #: wp-optimize-settings.php:170
513
  msgid "This option will put WP-Optimize link on the top admin bar (default is off). Requires page refresh."
514
  msgstr ""
515
 
516
- #: wp-optimize-settings.php:174
517
  msgid "Trackback/Comments Actions"
518
  msgstr ""
519
 
520
- #: wp-optimize-settings.php:176
521
  msgid "Disable/Enable Trackbacks"
522
  msgstr ""
523
 
524
- #: wp-optimize-settings.php:178 wp-optimize-settings.php:193
525
  msgid "SELECT"
526
  msgstr ""
527
 
528
- #: wp-optimize-settings.php:179 wp-optimize-settings.php:194
529
  msgid "Disable"
530
  msgstr ""
531
 
532
- #: wp-optimize-settings.php:180 wp-optimize-settings.php:195
533
  msgid "Enable"
534
  msgstr ""
535
 
536
- #: wp-optimize-settings.php:185
537
  msgid "This will disable/enable Trackbacks on all your current and previously published posts"
538
  msgstr ""
539
 
540
- #: wp-optimize-settings.php:191
541
  msgid "Disable/Enable Comments"
542
  msgstr ""
543
 
544
- #: wp-optimize-settings.php:200
545
  msgid "This will disable/enable Comments on all your current and previously published posts"
546
  msgstr ""
547
 
548
- #: wp-optimize-settings.php:211
549
  msgid "SAVE SETTINGS"
550
  msgstr ""
551
 
552
- #: wp-optimize-settings.php:221
553
  msgid "Auto Clean-up Settings"
554
  msgstr ""
555
 
556
- #: wp-optimize-settings.php:224
557
  msgid "Enable scheduled clean-up and optimization (Beta feature!)"
558
  msgstr ""
559
 
560
- #: wp-optimize-settings.php:226
561
  msgid "Select schedule type (default is Weekly)"
562
  msgstr ""
563
 
564
- #: wp-optimize-settings.php:233 wp-optimize-settings.php:255
565
  msgid "Everyday"
566
  msgstr ""
567
 
568
- #: wp-optimize-settings.php:237 wp-optimize-settings.php:249
569
- #: wp-optimize-settings.php:256
570
  msgid "Every week"
571
  msgstr ""
572
 
573
- #: wp-optimize-settings.php:241 wp-optimize-settings.php:257
574
  msgid "Every other week (every 14 days)"
575
  msgstr ""
576
 
577
- #: wp-optimize-settings.php:245 wp-optimize-settings.php:258
578
  msgid "Every month (every 31 days)"
579
  msgstr ""
580
 
581
- #: wp-optimize-settings.php:262
582
  msgid "Automatic cleanup will perform the following:"
583
  msgstr ""
584
 
585
- #: wp-optimize-settings.php:264
586
  msgid "Remove revisions, auto drafts, posts/comments in trash, transient options. After that it will optimize the db."
587
  msgstr ""
588
 
589
- #: wp-optimize-settings.php:271
590
  msgid "These options will only work if the automatic clean-up schedule has been enabled"
591
  msgstr ""
592
 
593
- #: wp-optimize-settings.php:276
594
  msgid "Remove auto revisions"
595
  msgstr ""
596
 
597
- #: wp-optimize-settings.php:280
598
  msgid "Remove auto drafts"
599
  msgstr ""
600
 
601
- #: wp-optimize-settings.php:284
602
  msgid "Remove spam comments"
603
  msgstr ""
604
 
605
- #: wp-optimize-settings.php:297
606
  msgid "Remove orphaned post meta"
607
  msgstr ""
608
 
609
- #: wp-optimize-settings.php:301
610
  msgid "Remove unused tags"
611
  msgstr ""
612
 
613
- #: wp-optimize-settings.php:307
614
  msgid "Optimize database"
615
  msgstr ""
616
 
617
- #: wp-optimize-settings.php:313
618
  msgid "If you have InnoDB tables. They will not be optimized!"
619
  msgstr ""
620
 
621
- #: wp-optimize-settings.php:322
622
  msgid "Enable email notification"
623
  msgstr ""
624
 
625
- #: wp-optimize-settings.php:329
626
  msgid "Send email to"
627
  msgstr ""
628
 
629
- #: wp-optimize-settings.php:335
630
  msgid "SAVE AUTO CLEAN-UP SETTINGS"
631
  msgstr ""
632
 
@@ -667,36 +728,39 @@ msgid "Total:"
667
  msgstr ""
668
 
669
  #: wp-optimize-tables.php:138
670
- msgid "%s Table"
671
- msgid_plural "%s Tables"
 
672
  msgstr[0] ""
673
  msgstr[1] ""
674
 
675
  #: wp-optimize-tables.php:139
676
- msgid "%s Record"
677
- msgid_plural "%s Records"
 
678
  msgstr[0] ""
679
  msgstr[1] ""
680
 
681
  #: wp-optimize-tables.php:179
682
- msgid "Total Size of Database"
683
  msgstr ""
684
 
685
  #: wp-optimize-tables.php:191
686
- msgid "Optimization Results"
687
  msgstr ""
688
 
689
  #: wp-optimize-tables.php:196
690
- msgid "Total Space Saved"
691
  msgstr ""
692
 
693
- #: wp-optimize-tables.php:208
694
- msgid "Optimization Possibility"
695
  msgstr ""
696
 
697
- #: wp-optimize-tables.php:215
698
- msgid "Total space can be saved"
699
  msgstr ""
 
700
  #. Plugin Name of the plugin/theme
701
  msgid "WP-Optimize"
702
  msgstr ""
@@ -715,4 +779,4 @@ msgstr ""
715
 
716
  #. Author URI of the plugin/theme
717
  msgid "https://github.com/ruhanirabin/WP-Optimize"
718
- msgstr ""
1
  # Copyright (C) 2015 WP-Optimize
2
  # This file is distributed under the same license as the WP-Optimize package.
3
+ #, fuzzy
4
  msgid ""
5
  msgstr ""
6
  "Project-Id-Version: WP-Optimize 1.8.9.8\n"
7
  "Report-Msgid-Bugs-To: http://wordpress.org/tag/wp-optimize\n"
8
+ "POT-Creation-Date: 2015-10-19 18:28+0100\n"
9
  "MIME-Version: 1.0\n"
10
  "Content-Type: text/plain; charset=UTF-8\n"
11
  "Content-Transfer-Encoding: 8bit\n"
12
  "PO-Revision-Date: 2015-MO-DA HO:MI+ZONE\n"
13
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
14
  "Language-Team: LANGUAGE <LL@li.org>\n"
15
+ "X-Poedit-KeywordsList: __;_e;__ngettext:1,2;_n:1,2;__ngettext_noop:1,2;_n_noop:1,2;_c,_nc:4c,1,2;_x:1,2c;_ex:1,2c;_nx:4c,1,2;_nx_noop:4c,1,2;esc_attr__;esc_attr_e;esc_attr_x:1,2c;esc_html__;esc_html_e;esc_html_x:1,2c\n"
16
+ "X-Poedit-Basepath: ..\n"
17
+ "X-Generator: Poedit 1.8.5\n"
18
+ "X-Poedit-SourceCharset: UTF-8\n"
19
+ "X-Poedit-SearchPath-0: .\n"
20
 
21
  #: wp-optimize-admin.php:25 wp-optimize-admin.php:43 wp-optimize.php:96
22
  msgid "Optimizer"
75
  msgstr ""
76
 
77
  #: wp-optimize-common.php:635
78
+ #, php-format
79
+ msgid "%d transient option deleted"
80
+ msgid_plural "%d transient options deleted"
81
+ msgstr[0] ""
82
+ msgstr[1] ""
83
 
84
  #: wp-optimize-common.php:662
85
+ #, php-format
86
+ msgid "%d post revision deleted"
87
+ msgid_plural "%d post revisions deleted"
88
+ msgstr[0] ""
89
+ msgstr[1] ""
90
 
91
  #: wp-optimize-common.php:673
92
+ #, php-format
93
+ msgid "%d auto draft deleted"
94
+ msgid_plural "%d auto drafts deleted"
95
+ msgstr[0] ""
96
+ msgstr[1] ""
97
 
98
  #: wp-optimize-common.php:683
99
+ #, php-format
100
+ msgid "%d item removed from Trash"
101
+ msgid_plural "%d items removed from Trash"
102
+ msgstr[0] ""
103
+ msgstr[1] ""
104
 
105
  #: wp-optimize-common.php:695
106
+ #, php-format
107
+ msgid "%d spam comment deleted"
108
+ msgid_plural "%d spam comments deleted"
109
+ msgstr[0] ""
110
+ msgstr[1] ""
111
 
112
  #: wp-optimize-common.php:704
113
+ #, php-format
114
+ msgid "%d comment removed from Trash"
115
+ msgid_plural "%d comments removed from Trash"
116
+ msgstr[0] ""
117
+ msgstr[1] ""
118
 
119
  #: wp-optimize-common.php:710
120
+ #, php-format
121
+ msgid "%d unused comment metadata item removed"
122
+ msgid_plural "%d unused comment metadata items removed"
123
+ msgstr[0] ""
124
+ msgstr[1] ""
125
 
126
  #: wp-optimize-common.php:716
127
+ #, php-format
128
+ msgid "%d unused akismet comment metadata item removed"
129
+ msgid_plural "%d unused akismet comment metadata items removed"
130
+ msgstr[0] ""
131
+ msgstr[1] ""
132
 
133
  #: wp-optimize-common.php:726
134
+ #, php-format
135
+ msgid "%d unapproved comment deleted"
136
+ msgid_plural "%d unapproved comments deleted"
137
+ msgstr[0] ""
138
+ msgstr[1] ""
139
 
140
  #: wp-optimize-common.php:732
141
+ #, php-format
142
+ msgid "%d pingback deleted"
143
+ msgid_plural "%d pingbacks deleted"
144
+ msgstr[0] ""
145
+ msgstr[1] ""
146
 
147
  #: wp-optimize-common.php:738
148
+ #, php-format
149
+ msgid "%d trackback deleted"
150
+ msgid_plural "%d trackbacks deleted"
151
+ msgstr[0] ""
152
+ msgstr[1] ""
153
 
154
  #: wp-optimize-common.php:745
155
  msgid "Enabled weekly processing"
164
  msgstr ""
165
 
166
  #: wp-optimize-common.php:787
167
+ #, php-format
168
+ msgid "%d transient option in your database"
169
+ msgid_plural "%d transient options in your database"
170
+ msgstr[0] ""
171
+ msgstr[1] ""
172
 
173
  #: wp-optimize-common.php:789
174
  msgid "No transient options found"
175
  msgstr ""
176
 
177
  #: wp-optimize-common.php:798
178
+ #, php-format
179
+ msgid "%d orphaned postmeta in your database"
180
+ msgid_plural "%d orphaned postmeta in your database"
181
+ msgstr[0] ""
182
+ msgstr[1] ""
183
 
184
  #: wp-optimize-common.php:800
185
  msgid "No orphaned postmeta in your database"
186
  msgstr ""
187
 
188
  #: wp-optimize-common.php:809
189
+ #, php-format
190
+ msgid "%d unused tag in your database"
191
+ msgid_plural "%d unused tags in your database"
192
+ msgstr[0] ""
193
+ msgstr[1] ""
194
 
195
  #: wp-optimize-common.php:811
196
  msgid "No unused tags found"
197
  msgstr ""
198
 
199
  #: wp-optimize-common.php:824
200
+ #, php-format
201
+ msgid "%d post revision in your database"
202
+ msgid_plural "%d post revisions in your database"
203
+ msgstr[0] ""
204
+ msgstr[1] ""
205
 
206
  #: wp-optimize-common.php:826
207
  msgid "No post revisions found"
208
  msgstr ""
209
 
210
  #: wp-optimize-common.php:839
211
+ #, php-format
212
+ msgid "%d auto draft post in your database"
213
+ msgid_plural "%d auto draft posts in your database"
214
+ msgstr[0] ""
215
+ msgstr[1] ""
216
 
217
  #: wp-optimize-common.php:841
218
  msgid "No auto draft posts found"
219
  msgstr ""
220
 
221
  #: wp-optimize-common.php:853
222
+ #, php-format
223
+ msgid "%d spam comment found"
224
+ msgid_plural "%d spam comments found"
225
+ msgstr[0] ""
226
+ msgstr[1] ""
227
 
228
  #: wp-optimize-common.php:853 wp-optimize-common.php:884
229
  msgid "Review"
234
  msgstr ""
235
 
236
  #: wp-optimize-common.php:884
237
+ #, php-format
238
+ msgid "%d unapproved comment found"
239
+ msgid_plural "%d unapproved comments found"
240
+ msgstr[0] ""
241
+ msgstr[1] ""
242
 
243
  #: wp-optimize-common.php:886
244
  msgid "No unapproved comments found"
245
  msgstr ""
246
 
247
  #: wp-optimize-common.php:894
248
+ #, php-format
249
+ msgid "%d Pingback found"
250
+ msgid_plural "%d Pingbacks found"
251
+ msgstr[0] ""
252
+ msgstr[1] ""
253
 
254
  #: wp-optimize-common.php:896
255
  msgid "No pingbacks found"
256
  msgstr ""
257
 
258
  #: wp-optimize-common.php:904
259
+ #, php-format
260
+ msgid "%d Trackback found"
261
+ msgid_plural "%d Trackbacks found"
262
+ msgstr[0] ""
263
+ msgstr[1] ""
264
 
265
  #: wp-optimize-common.php:906
266
  msgid "No trackbacks found"
355
  msgstr ""
356
 
357
  #: wp-optimize-main.php:76
358
+ #, php-format
359
+ msgctxt "%s is the Database Name"
360
+ msgid "%s Database Optimized!"
361
  msgstr ""
362
 
363
  #: wp-optimize-main.php:154 wp-optimize-main.php:156
365
  msgstr ""
366
 
367
  #: wp-optimize-main.php:165
368
+ #, php-format
369
+ msgid "Clean post revisions which are older than %d weeks"
370
  msgstr ""
371
 
372
+ #: wp-optimize-main.php:167
 
 
 
 
 
373
  msgid "Clean all post revisions"
374
  msgstr ""
375
 
376
+ #: wp-optimize-main.php:180
377
+ #, php-format
378
+ msgid "Clean auto draft posts which are older than %d weeks"
379
  msgstr ""
380
 
381
+ #: wp-optimize-main.php:182
382
  msgid "Clean all auto draft posts and posts in trash"
383
  msgstr ""
384
 
385
+ #: wp-optimize-main.php:197
386
+ #, php-format
387
+ msgid "Remove spam comments which are older than %d weeks"
388
  msgstr ""
389
 
390
+ #: wp-optimize-main.php:199
391
  msgid "Remove spam comments and comments in trash"
392
  msgstr ""
393
 
394
+ #: wp-optimize-main.php:213
395
+ #, php-format
396
+ msgid "Remove unapproved comments which are older than %d weeks"
397
  msgstr ""
398
 
399
+ #: wp-optimize-main.php:215 wp-optimize-settings.php:286
400
  msgid "Remove unapproved comments"
401
  msgstr ""
402
 
403
+ #: wp-optimize-main.php:228 wp-optimize-settings.php:291
404
  msgid "Remove transient options"
405
  msgstr ""
406
 
407
+ #: wp-optimize-main.php:239
408
  msgid "Remove pingbacks"
409
  msgstr ""
410
 
411
+ #: wp-optimize-main.php:250
412
  msgid "Remove trackbacks"
413
  msgstr ""
414
 
415
+ #: wp-optimize-main.php:260
416
  msgid "Do not select RED marked items unless you really need to use them"
417
  msgstr ""
418
 
419
+ #: wp-optimize-main.php:266 wp-optimize-settings.php:205
420
+ msgid "Optimize YouTube embedding with this free plugin on WordPress.org"
421
  msgstr ""
422
 
423
+ #: wp-optimize-main.php:276
424
  msgid "Actions"
425
  msgstr ""
426
 
427
+ #: wp-optimize-main.php:285
428
  msgid "Optimize database tables"
429
  msgstr ""
430
 
431
+ #: wp-optimize-main.php:293
432
  msgid "Note:"
433
  msgstr ""
434
 
435
+ #: wp-optimize-main.php:296
436
  msgid "InnoDB tables will not be optimized"
437
  msgstr ""
438
 
439
+ #: wp-optimize-main.php:302
440
  msgid "Select safe options"
441
  msgstr ""
442
 
443
+ #: wp-optimize-main.php:303
444
  msgid "Warning:"
445
  msgstr ""
446
 
447
+ #: wp-optimize-main.php:304
448
  msgid "Always make a backup of your DB when you upgrade to major versions"
449
  msgstr ""
450
 
451
+ #: wp-optimize-main.php:309
452
  msgid "PROCESS"
453
  msgstr ""
454
 
455
+ #: wp-optimize-main.php:315
456
  msgid "Please donate! It really helps me keep improvising"
457
  msgstr ""
458
 
459
+ #: wp-optimize-main.php:315
460
  msgid "Donate!"
461
  msgstr ""
462
 
463
+ #: wp-optimize-main.php:316
464
+ msgid "Please give a proper rating :)"
465
  msgstr ""
466
 
467
+ #: wp-optimize-main.php:317
468
  msgid "Rating"
469
  msgstr ""
470
 
471
+ #: wp-optimize-main.php:322
472
+ msgid "Status log"
473
  msgstr ""
474
 
475
+ #: wp-optimize-main.php:337
476
  msgid "Last automatic optimization was at"
477
  msgstr ""
478
 
479
+ #: wp-optimize-main.php:349
480
  msgid "There was no automatic optimization"
481
  msgstr ""
482
 
483
+ #: wp-optimize-main.php:364
484
  msgid "Scheduled cleaning enabled"
485
  msgstr ""
486
 
487
+ #: wp-optimize-main.php:376
488
+ msgid "Next schedule:"
489
  msgstr ""
490
 
491
+ #: wp-optimize-main.php:387
492
  msgid "Refresh"
493
  msgstr ""
494
 
495
+ #: wp-optimize-main.php:396
496
  msgid "Scheduled cleaning disabled"
497
  msgstr ""
498
 
499
+ #: wp-optimize-main.php:399 wp-optimize-main.php:421
500
  msgid "Check settings"
501
  msgstr ""
502
 
503
+ #: wp-optimize-main.php:410
504
+ #, php-format
505
+ msgid "Keeping last %s weeks data"
506
  msgstr ""
507
 
508
+ #: wp-optimize-main.php:418
 
 
 
 
509
  msgid "Not keeping recent data"
510
  msgstr ""
511
 
512
+ #: wp-optimize-main.php:435 wp-optimize-main.php:448
513
+ msgid "Current database size:"
 
 
 
 
514
  msgstr ""
515
 
516
+ #: wp-optimize-main.php:441
517
+ msgid "You have saved:"
518
  msgstr ""
519
 
520
+ #: wp-optimize-main.php:456
521
+ msgid "You can save almost:"
522
  msgstr ""
523
 
524
+ #: wp-optimize-main.php:473
525
+ msgid "Total clean up overall:"
526
  msgstr ""
527
 
528
+ #: wp-optimize-main.php:494
529
  msgid "Sponsor"
530
  msgstr ""
531
 
532
+ #: wp-optimize-settings.php:87
533
  msgid "Trackbacks disabled on all current and previously published posts"
534
  msgstr ""
535
 
536
+ #: wp-optimize-settings.php:93
537
  msgid "Trackbacks enabled on all current and previously published posts"
538
  msgstr ""
539
 
540
+ #: wp-optimize-settings.php:102
541
  msgid "Comments disabled on all current and previously published posts"
542
  msgstr ""
543
 
544
+ #: wp-optimize-settings.php:108
545
  msgid "Comments enabled on all current and previously published posts"
546
  msgstr ""
547
 
548
+ #: wp-optimize-settings.php:114
549
  msgid "Settings updated"
550
  msgstr ""
551
 
552
+ #: wp-optimize-settings.php:131
553
  msgid "General Settings"
554
  msgstr ""
555
 
556
+ #: wp-optimize-settings.php:136
557
+ #, php-format
558
+ msgid "Keep last %s weeks data"
559
  msgstr ""
560
 
561
+ #: wp-optimize-settings.php:150
562
  msgid "This option will retain the last selected weeks data and remove any garbage data before that period. This will also affect Auto Clean-up process"
563
  msgstr ""
564
 
565
+ #: wp-optimize-settings.php:159
566
+ msgid "Enable admin bar link"
567
  msgstr ""
568
 
569
+ #: wp-optimize-settings.php:162
570
  msgid "(Click here to refresh)"
571
  msgstr ""
572
 
573
+ #: wp-optimize-settings.php:168
574
  msgid "This option will put WP-Optimize link on the top admin bar (default is off). Requires page refresh."
575
  msgstr ""
576
 
577
+ #: wp-optimize-settings.php:172
578
  msgid "Trackback/Comments Actions"
579
  msgstr ""
580
 
581
+ #: wp-optimize-settings.php:174
582
  msgid "Disable/Enable Trackbacks"
583
  msgstr ""
584
 
585
+ #: wp-optimize-settings.php:176 wp-optimize-settings.php:191
586
  msgid "SELECT"
587
  msgstr ""
588
 
589
+ #: wp-optimize-settings.php:177 wp-optimize-settings.php:192
590
  msgid "Disable"
591
  msgstr ""
592
 
593
+ #: wp-optimize-settings.php:178 wp-optimize-settings.php:193
594
  msgid "Enable"
595
  msgstr ""
596
 
597
+ #: wp-optimize-settings.php:183
598
  msgid "This will disable/enable Trackbacks on all your current and previously published posts"
599
  msgstr ""
600
 
601
+ #: wp-optimize-settings.php:189
602
  msgid "Disable/Enable Comments"
603
  msgstr ""
604
 
605
+ #: wp-optimize-settings.php:198
606
  msgid "This will disable/enable Comments on all your current and previously published posts"
607
  msgstr ""
608
 
609
+ #: wp-optimize-settings.php:209
610
  msgid "SAVE SETTINGS"
611
  msgstr ""
612
 
613
+ #: wp-optimize-settings.php:219
614
  msgid "Auto Clean-up Settings"
615
  msgstr ""
616
 
617
+ #: wp-optimize-settings.php:222
618
  msgid "Enable scheduled clean-up and optimization (Beta feature!)"
619
  msgstr ""
620
 
621
+ #: wp-optimize-settings.php:224
622
  msgid "Select schedule type (default is Weekly)"
623
  msgstr ""
624
 
625
+ #: wp-optimize-settings.php:231 wp-optimize-settings.php:253
626
  msgid "Everyday"
627
  msgstr ""
628
 
629
+ #: wp-optimize-settings.php:235 wp-optimize-settings.php:247
630
+ #: wp-optimize-settings.php:254
631
  msgid "Every week"
632
  msgstr ""
633
 
634
+ #: wp-optimize-settings.php:239 wp-optimize-settings.php:255
635
  msgid "Every other week (every 14 days)"
636
  msgstr ""
637
 
638
+ #: wp-optimize-settings.php:243 wp-optimize-settings.php:256
639
  msgid "Every month (every 31 days)"
640
  msgstr ""
641
 
642
+ #: wp-optimize-settings.php:260
643
  msgid "Automatic cleanup will perform the following:"
644
  msgstr ""
645
 
646
+ #: wp-optimize-settings.php:262
647
  msgid "Remove revisions, auto drafts, posts/comments in trash, transient options. After that it will optimize the db."
648
  msgstr ""
649
 
650
+ #: wp-optimize-settings.php:269
651
  msgid "These options will only work if the automatic clean-up schedule has been enabled"
652
  msgstr ""
653
 
654
+ #: wp-optimize-settings.php:274
655
  msgid "Remove auto revisions"
656
  msgstr ""
657
 
658
+ #: wp-optimize-settings.php:278
659
  msgid "Remove auto drafts"
660
  msgstr ""
661
 
662
+ #: wp-optimize-settings.php:282
663
  msgid "Remove spam comments"
664
  msgstr ""
665
 
666
+ #: wp-optimize-settings.php:295
667
  msgid "Remove orphaned post meta"
668
  msgstr ""
669
 
670
+ #: wp-optimize-settings.php:299
671
  msgid "Remove unused tags"
672
  msgstr ""
673
 
674
+ #: wp-optimize-settings.php:305
675
  msgid "Optimize database"
676
  msgstr ""
677
 
678
+ #: wp-optimize-settings.php:311
679
  msgid "If you have InnoDB tables. They will not be optimized!"
680
  msgstr ""
681
 
682
+ #: wp-optimize-settings.php:320
683
  msgid "Enable email notification"
684
  msgstr ""
685
 
686
+ #: wp-optimize-settings.php:327
687
  msgid "Send email to"
688
  msgstr ""
689
 
690
+ #: wp-optimize-settings.php:333
691
  msgid "SAVE AUTO CLEAN-UP SETTINGS"
692
  msgstr ""
693
 
728
  msgstr ""
729
 
730
  #: wp-optimize-tables.php:138
731
+ #, php-format
732
+ msgid "%d Table"
733
+ msgid_plural "%d Tables"
734
  msgstr[0] ""
735
  msgstr[1] ""
736
 
737
  #: wp-optimize-tables.php:139
738
+ #, php-format
739
+ msgid "%d Record"
740
+ msgid_plural "%d Records"
741
  msgstr[0] ""
742
  msgstr[1] ""
743
 
744
  #: wp-optimize-tables.php:179
745
+ msgid "Total Size of Database:"
746
  msgstr ""
747
 
748
  #: wp-optimize-tables.php:191
749
+ msgid "Optimization Results:"
750
  msgstr ""
751
 
752
  #: wp-optimize-tables.php:196
753
+ msgid "Total Space Saved:"
754
  msgstr ""
755
 
756
+ #: wp-optimize-tables.php:207
757
+ msgid "Optimization Possibility:"
758
  msgstr ""
759
 
760
+ #: wp-optimize-tables.php:213
761
+ msgid "Total space can be saved:"
762
  msgstr ""
763
+
764
  #. Plugin Name of the plugin/theme
765
  msgid "WP-Optimize"
766
  msgstr ""
779
 
780
  #. Author URI of the plugin/theme
781
  msgid "https://github.com/ruhanirabin/WP-Optimize"
782
+ msgstr ""
readme.txt CHANGED
@@ -3,8 +3,8 @@ Contributors: ruhanirabin
3
  Donate link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=LTCMF6JDX94QS
4
  Tags: comments, spam, optimize, database, revisions, users, posts, trash, schedule, automatic, clean, phpmyadmin, meta, postmeta, responsive, mobile
5
  Requires at least: 4.4
6
- Tested up to: 4.5
7
- Stable tag: 1.9
8
  License: GPLv2+
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
@@ -43,7 +43,6 @@ Please join GitHub and collaborate.
43
  * Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.
44
  * Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
45
  * Enabled for Administrators only.
46
- * E-mail notifications on automatic cleanup
47
 
48
 
49
  **All the potentially dangerous clean up options are marked RED.**
@@ -73,20 +72,6 @@ Existing translators should join [Translation Utility](https://translate.wordpre
73
 
74
  You must have an account at WordPress.org in order to edit translation
75
 
76
- **WP-Optimize Translators:**
77
-
78
- * Language de_DE: Rene Wolf - http://www.fluchtsportler.de
79
- * Language fr_FR: Stéphane Benoit. - http://www.gnosticisme.com
80
- * Language sl_SI: Tomi Sambrailo - http://www.refuzed.it/
81
- * Language ka_GE: Givi Tabatadze - http://tagiweb.com
82
- * Language zh_CN: Maie - http://maie.name
83
- * Language es_ES: Navone Juan - http://navonej.com.ar/
84
- * Language sk_SK: Martin Šturcel- http://sturcel.sk/martin
85
- * Language nl_NL: Mathias Bosman - http://www.mathiasbosman.be
86
- * Language hu_HU: László Viktor - http://hunstart.hu/
87
- * Language lt_LT: Bronisav Ciuzelis - http://internetiniusvetainiukurimas.com/
88
-
89
- ** Some languages are removed from the above list, because translators did not update the languages for current version **
90
  [See a list of currently editable available languages at](https://translate.wordpress.org/projects/wp-plugins/wp-optimize)
91
 
92
  == Installation ==
@@ -151,6 +136,13 @@ Please check your database for corrupted tables. That can happen, usually your w
151
 
152
  == Changelog ==
153
 
 
 
 
 
 
 
 
154
  = 1.9 =
155
  * 27 Weeks retention option equivalent to 6 month
156
  * Compatibility update.
3
  Donate link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=LTCMF6JDX94QS
4
  Tags: comments, spam, optimize, database, revisions, users, posts, trash, schedule, automatic, clean, phpmyadmin, meta, postmeta, responsive, mobile
5
  Requires at least: 4.4
6
+ Tested up to: 4.7
7
+ Stable tag: 1.9.1
8
  License: GPLv2+
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
43
  * Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.
44
  * Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
45
  * Enabled for Administrators only.
 
46
 
47
 
48
  **All the potentially dangerous clean up options are marked RED.**
72
 
73
  You must have an account at WordPress.org in order to edit translation
74
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
75
  [See a list of currently editable available languages at](https://translate.wordpress.org/projects/wp-plugins/wp-optimize)
76
 
77
  == Installation ==
136
 
137
  == Changelog ==
138
 
139
+ = 1.9.1 =
140
+ * Ability to clean up Unused Post Meta, Comment Meta and Broken Relationship Data
141
+ * Warning prompts for RED marked items and optimize button
142
+ * Better transient options cleaning.
143
+ * Language files update.
144
+ * Various other fixes
145
+
146
  = 1.9 =
147
  * 27 Weeks retention option equivalent to 6 month
148
  * Compatibility update.
screenshot-1.jpg CHANGED
Binary file
screenshot-2.jpg CHANGED
Binary file
translate.txt DELETED
@@ -1,26 +0,0 @@
1
- I have implemented a translation update system using GlotPress. It will enable you to update WP-Optimize language to the latest version. Also will help you to find out how many translations are missing.
2
-
3
- Language which is not updated up-to 90% will not be included in plugin release
4
-
5
- To work with this system you will need to have an account attached to it. Here are the steps.
6
-
7
- 1. Get an account from http://wp-managed.com/wp-login.php?action=register
8
- 2. You should receive an email with your password. If any case you did not receive the password, please check your spam box and let me know
9
- 3. Do not login to WordPress admin with the password, use this link (http://wp-managed.com/login?redirect_to=http%3A%2F%2Fwp-managed.com%2Fprojects%2Fwp-optimize) to log in (bookmark that link)
10
- 4. You should be able to see all the language files available currently, you can choose the language to edit by clicking on the language name.
11
- 5. To see what strings are not completed or empty, Use the filter "Untranslated" - that would show you how many strings are not yet translated.
12
- 6. Double click an Entry to go to edit mode for that string.
13
- 7. Once you are done, you can use the "Suggest Translation" Button.
14
- 8. Yes that is it, at the main window http://wp-managed.com/projects/wp-optimize - you will be able to see the progress like 90% done or 70% done etc.
15
-
16
- When I prepare new release I will upload the new .POT file so the system will be updated with new strings (if there is any new strings).
17
-
18
- I will wait for the translations to finalize and pack it inside the plugin. So the new version will be available with new language update.
19
-
20
- I will not use any of your email for any other purpose other than WP-Optimize translations.
21
-
22
- I will eventually upgrade language editors to language validator level so they will be able to submit the translation without going through screening.
23
-
24
- Once, these are done, I can download the appropriate .PO file and .MO file from the system. So you do not need to send me email with attachment.
25
-
26
- I know it is a lot to ask to make an account on that site. But once that part is done, you will be able to do translation in a very systematic and simplified way.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
wp-optimize-common.php CHANGED
@@ -358,21 +358,15 @@ function wpo_cron_action() {
358
  // TODO: still need to test now cleaning up comments meta tables
359
  $clean = "DELETE FROM `$wpdb->commentmeta` WHERE comment_id NOT IN ( SELECT comment_id FROM `$wpdb->comments` )";
360
  $clean .= ';';
361
- $commentstrash1 = $wpdb->query( $clean );
362
-
363
- // TODO: still need to test now cleaning up comments meta tables - removing akismet related settings
364
- $clean = "DELETE FROM `$wpdb->commentmeta` WHERE meta_key LIKE '%akismet%'";
365
- $clean .= ';';
366
- $commentstrash2 = $wpdb->query( $clean );
367
-
368
 
369
  }
370
 
371
  // transient options
372
  if ($this_options['transient'] == 'true'){
373
- $clean = "DELETE FROM `$wpdb->options` WHERE option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%'";
374
  $clean .= ';';
375
- $transient_options = $wpdb->query( $clean );
376
  }
377
 
378
  // postmeta
@@ -626,21 +620,43 @@ function wpo_cleanUpSystem($cleanupType){
626
  list ($retention_enabled, $retention_period) = wpo_getRetainInfo();
627
 
628
  switch ($cleanupType) {
629
- case "transient_options":
630
  // backticks
631
- $clean = "DELETE FROM `$wpdb->options` WHERE option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%'";
632
- $clean .= ';';
633
 
634
- $transient_options = $wpdb->query( $clean );
635
- $message .= sprintf(_n('%d transient option deleted', '%d transient options deleted', $transient_options, 'wp-optimize'), number_format_i18n($transient_options)).'<br>';
636
  break;
637
  // TODO: need to use proper query
638
  case "postmeta":
639
- $clean = "DELETE pm FROM `$wpdb->postmeta` pm LEFT JOIN `$wpdb->posts` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL";
 
 
 
 
 
 
 
 
 
 
 
 
 
 
640
  $clean .= ';';
 
 
 
 
641
 
642
- //$postmeta = $wpdb->query( $clean );
643
- //$message .= sprintf(_n('%d orphaned postmeta deleted', '%d orphaned postmeta deleted', $postmeta, 'wp-optimize'), number_format_i18n($postmeta)).'<br>';
 
 
 
 
644
  break;
645
 
646
  case "tags":
@@ -702,18 +718,7 @@ function wpo_cleanUpSystem($cleanupType){
702
  $clean .= ';';
703
  $commentstrash = $wpdb->query( $clean );
704
  $message .= sprintf(_n('%d comment removed from Trash', '%d comments removed from Trash', $commentstrash, 'wp-optimize'), number_format_i18n($commentstrash)).'<br>';
705
-
706
- // TODO: still need to test now cleaning up comments meta tables
707
- $clean = "DELETE FROM `$wpdb->commentmeta` WHERE comment_id NOT IN ( SELECT comment_id FROM `$wpdb->comments` )";
708
- $clean .= ';';
709
- $commentstrash_meta = $wpdb->query( $clean );
710
- $message .= sprintf(_n('%d unused comment metadata item removed', '%d unused comment metadata items removed', $commentstrash_meta, 'wp-optimize'), number_format_i18n($commentstrash_meta)).'<br>';
711
-
712
- // TODO: still need to test now cleaning up comments meta tables - removing akismet related settings
713
- $clean = "DELETE FROM `$wpdb->commentmeta` WHERE meta_key LIKE '%akismet%'";
714
- $clean .= ';';
715
- $commentstrash_meta2 = $wpdb->query( $clean );
716
- $message .= sprintf(_n('%d unused akismet comment metadata item removed', '%d unused akismet comment metadata items removed', $commentstrash_meta2, 'wp-optimize'), number_format_i18n($commentstrash_meta2)).'<br>';
717
  break;
718
 
719
  case "unapproved":
@@ -738,7 +743,6 @@ function wpo_cleanUpSystem($cleanupType){
738
  $message .= sprintf(_n('%d trackback deleted', '%d trackbacks deleted', $comments, 'wp-optimize'), number_format_i18n($comments)).'<br>';
739
  break;
740
 
741
-
742
  case "enable-weekly":
743
  update_option( OPTION_NAME_SCHEDULE, 'true' );
744
  $comments = '';
@@ -778,39 +782,62 @@ function wpo_getInfo($cleanupType){
778
  list ($retention_enabled, $retention_period) = wpo_getRetainInfo();
779
 
780
  switch ($cleanupType) {
781
- case "transient_options":
782
- $sql = "SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%'";
783
- $sql .= ';';
784
- $transient_options = $wpdb->get_var( $sql );
785
 
786
- if(!$transient_options == 0 || !$transient_options == NULL){
787
- $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d transient option in your database', '%d transient options in your database', $transient_options, 'wp-optimize'), number_format_i18n($transient_options));
788
  }
789
  else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No transient options found', 'wp-optimize');
790
  break;
791
 
792
  case "postmeta":
793
- $sql = "SELECT COUNT(*) FROM `$wpdb->postmeta` pm LEFT JOIN `$wpdb->posts` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL";
794
  $sql .= ';';
795
  $postmeta = $wpdb->get_var( $sql );
796
 
797
- if(!$postmeta == 0 || !$postmeta == NULL){
798
- $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d orphaned postmeta in your database', '%d orphaned postmeta in your database', $postmeta, 'wp-optimize'), number_format_i18n($postmeta));
799
  }
800
- else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No orphaned postmeta in your database', 'wp-optimize');
801
  break;
802
 
803
- case "tags":
804
- $sql = "SELECT COUNT(*) FROM `$wpdb->terms` t INNER JOIN `$wpdb->term_taxonomy` tt ON t.term_id=tt.term_id WHERE tt.taxonomy='post_tag' AND tt.count=0";
 
 
 
 
 
 
 
 
 
 
 
805
  $sql .= ';';
806
- $tags = $wpdb->get_var( $sql );
807
 
808
- if(!$tags == 0 || !$tags == NULL){
809
- $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d unused tag in your database', '%d unused tags in your database', $tags, 'wp-optimize'), number_format_i18n($tags));
810
  }
811
- else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No unused tags found', 'wp-optimize');
812
  break;
813
 
 
 
 
 
 
 
 
 
 
 
 
 
814
  case "revisions":
815
  $sql = "SELECT COUNT(*) FROM `$wpdb->posts` WHERE post_type = 'revision'";
816
 
@@ -854,23 +881,6 @@ function wpo_getInfo($cleanupType){
854
  } else
855
  $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No spam comments found', 'wp-optimize');
856
 
857
- // TODO: still need to test 2 more sections for info - still need to test
858
- // $sql = "SELECT * FROM $wpdb->commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM $wpdb->comments )";
859
- // $sql .= ';';
860
- // $comments_meta = $wpdb->query( $sql );
861
- // if(!$comments_meta == NULL || !$comments_meta == 0){
862
- // $message .= '&nbsp;|&nbsp;'.$comments_meta.' '.__('Unused comment meta found', 'wp-optimize');
863
- // }
864
- //
865
- //
866
- // $sql = "SELECT * FROM $wpdb->commentmeta WHERE meta_key LIKE '%akismet%'";
867
- // $sql .= ';';
868
- // $comments_meta2 = $wpdb->query( $sql );
869
- // if(!$comments_meta2 == NULL || !$comments_meta2 == 0){
870
- // $message .= '&nbsp;|&nbsp;'.$comments_meta2.' '.__('additional Akismet junk data found', 'wp-optimize');
871
- // }
872
-
873
-
874
  break;
875
 
876
  case "unapproved":
358
  // TODO: still need to test now cleaning up comments meta tables
359
  $clean = "DELETE FROM `$wpdb->commentmeta` WHERE comment_id NOT IN ( SELECT comment_id FROM `$wpdb->comments` )";
360
  $clean .= ';';
361
+ //$commentstrash1 = $wpdb->query( $clean );
 
 
 
 
 
 
362
 
363
  }
364
 
365
  // transient options
366
  if ($this_options['transient'] == 'true'){
367
+ $clean = "DELETE FROM `$wpdb->options` WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'";
368
  $clean .= ';';
369
+ $transient = $wpdb->query( $clean );
370
  }
371
 
372
  // postmeta
620
  list ($retention_enabled, $retention_period) = wpo_getRetainInfo();
621
 
622
  switch ($cleanupType) {
623
+ case "transient":
624
  // backticks
625
+ $clean = "DELETE FROM `$wpdb->options` WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'";
626
+ //$clean .= ';';
627
 
628
+ $transient = $wpdb->query( $clean );
629
+ $message .= sprintf(_n('%d transient option deleted', '%d transient options deleted', $transient, 'wp-optimize'), number_format_i18n($transient)).'<br>';
630
  break;
631
  // TODO: need to use proper query
632
  case "postmeta":
633
+ $clean = "DELETE pm FROM `$wpdb->postmeta` pm LEFT JOIN `$wpdb->posts` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL";
634
+ $clean .= ';';
635
+
636
+ $postmeta = $wpdb->query( $clean );
637
+ $message .= sprintf(_n('%d orphaned postmeta deleted', '%d orphaned postmeta deleted', $postmeta, 'wp-optimize'), number_format_i18n($postmeta)).'<br>';
638
+ break;
639
+
640
+ case "commentmeta":
641
+ $clean = "DELETE FROM `$wpdb->commentmeta` WHERE comment_id NOT IN (SELECT comment_id FROM `$wpdb->comments`)";
642
+ $clean .= ';';
643
+ $commentstrash_meta = $wpdb->query( $clean );
644
+ $message .= sprintf(_n('%d unused comment metadata item removed', '%d unused comment metadata items removed', $commentstrash_meta, 'wp-optimize'), number_format_i18n($commentstrash_meta)).'<br>';
645
+
646
+ // TODO: still need to test now cleaning up comments meta tables - removing akismet related settings
647
+ $clean = "DELETE FROM `$wpdb->commentmeta` WHERE meta_key LIKE '%akismet%'";
648
  $clean .= ';';
649
+ $commentstrash_meta2 = $wpdb->query( $clean );
650
+ $message .= sprintf(_n('%d unused akismet comment metadata item removed', '%d unused akismet comment metadata items removed', $commentstrash_meta2, 'wp-optimize'), number_format_i18n($commentstrash_meta2)).'<br>';
651
+ break;
652
+
653
 
654
+ case "orphandata":
655
+ $clean = "DELETE FROM `$wpdb->term_relationships` WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM `$wpdb->posts`)";
656
+ $clean .= ';';
657
+
658
+ $orphandata = $wpdb->query( $clean );
659
+ $message .= sprintf(_n('%d orphaned meta data deleted', '%d orphaned meta data deleted', $orphandata, 'wp-optimize'), number_format_i18n($orphandata)).'<br>';
660
  break;
661
 
662
  case "tags":
718
  $clean .= ';';
719
  $commentstrash = $wpdb->query( $clean );
720
  $message .= sprintf(_n('%d comment removed from Trash', '%d comments removed from Trash', $commentstrash, 'wp-optimize'), number_format_i18n($commentstrash)).'<br>';
721
+
 
 
 
 
 
 
 
 
 
 
 
722
  break;
723
 
724
  case "unapproved":
743
  $message .= sprintf(_n('%d trackback deleted', '%d trackbacks deleted', $comments, 'wp-optimize'), number_format_i18n($comments)).'<br>';
744
  break;
745
 
 
746
  case "enable-weekly":
747
  update_option( OPTION_NAME_SCHEDULE, 'true' );
748
  $comments = '';
782
  list ($retention_enabled, $retention_period) = wpo_getRetainInfo();
783
 
784
  switch ($cleanupType) {
785
+ case "transient":
786
+ $sql = "SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'";
787
+ //$sql .= ';';
788
+ $transient = $wpdb->get_var( $sql );
789
 
790
+ if(!$transient == 0 || !$transient == NULL){
791
+ $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d transient option in your database', '%d transient options in your database', $transient, 'wp-optimize'), number_format_i18n($transient));
792
  }
793
  else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No transient options found', 'wp-optimize');
794
  break;
795
 
796
  case "postmeta":
797
+ $sql = "SELECT COUNT(*) FROM `$wpdb->postmeta` pm LEFT JOIN `$wpdb->posts` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL";
798
  $sql .= ';';
799
  $postmeta = $wpdb->get_var( $sql );
800
 
801
+ if(!$postmeta == 0 || !$postmeta == NULL){
802
+ $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d orphaned post meta data in your database', '%d orphaned postmeta in your database', $postmeta, 'wp-optimize'), number_format_i18n($postmeta));
803
  }
804
+ else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No orphaned post meta data in your database', 'wp-optimize');
805
  break;
806
 
807
+ case "commentmeta":
808
+ $sql = "SELECT COUNT(*) FROM `$wpdb->commentmeta` WHERE comment_id NOT IN (SELECT comment_id FROM `$wpdb->comments`)";
809
+ $sql .= ';';
810
+ $commentmeta = $wpdb->get_var( $sql );
811
+
812
+ if(!$commentmeta == 0 || !$commentmeta == NULL){
813
+ $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d orphaned comment meta data in your database', '%d orphaned comment meta data in your database', $commentmeta, 'wp-optimize'), number_format_i18n($commentmeta));
814
+ }
815
+ else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No orphaned comment meta data in your database', 'wp-optimize');
816
+ break;
817
+
818
+ case "orphandata":
819
+ $sql = "SELECT COUNT(*) FROM `$wpdb->term_relationships` WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM `$wpdb->posts`)";
820
  $sql .= ';';
821
+ $orphandata = $wpdb->get_var( $sql );
822
 
823
+ if(!$orphandata == 0 || !$orphandata == NULL){
824
+ $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d orphaned relationship data in your database', '%d orphaned relationship data in your database', $orphandata, 'wp-optimize'), number_format_i18n($orphandata));
825
  }
826
+ else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No orphaned relationship data in your database', 'wp-optimize');
827
  break;
828
 
829
+ // not used
830
+ /*case "transient":
831
+ $sql = "SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'";
832
+ $sql .= ';';
833
+ $transient = $wpdb->get_var( $sql );
834
+
835
+ if(!$transient == 0 || !$transient == NULL){
836
+ $message .= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.sprintf(_n('%d transient data in your database', '%d transient data in your database', $transient, 'wp-optimize'), number_format_i18n($transient));
837
+ }
838
+ else $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No transient data found', 'wp-optimize');
839
+ break;*/
840
+
841
  case "revisions":
842
  $sql = "SELECT COUNT(*) FROM `$wpdb->posts` WHERE post_type = 'revision'";
843
 
881
  } else
882
  $message .='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.__('No spam comments found', 'wp-optimize');
883
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
884
  break;
885
 
886
  case "unapproved":
wp-optimize-credits.php CHANGED
@@ -43,12 +43,6 @@ if ( ! defined( 'WPINC' ) ) {
43
  <div class="wpo_col wpo_span_1_of_3">
44
  <div class="postbox">
45
  <div class="inside">
46
- <h3><?php _e('Translators','wp-optimize'); ?></h3>
47
- <br />
48
- <h3><a href="<?php _e('http://(Translator Website)','wp-optimize'); ?>" target="_blank" title=""><?php _e('(Translator name)','wp-optimize') ?></a></h3>
49
-
50
- <br /><br />
51
-
52
  <h3><?php _e('Plugin Resources','wp-optimize'); ?></h3>
53
  <p>
54
  <b><a href="https://translate.wordpress.org/projects/wp-plugins/wp-optimize" target="_blank"><?php _e('Plugin Translation Portal (needs WordPress account)', 'wp-optimize'); ?></a></b>
@@ -75,17 +69,29 @@ if ( ! defined( 'WPINC' ) ) {
75
  <div class="wpo_col wpo_span_1_of_3">
76
  <div class="postbox">
77
  <div class="inside">
78
- <h3><?php _e('GitHub Development Log','wp-optimize'); ?></h3>
 
 
 
 
 
 
 
 
 
 
 
 
79
  <?php // Get RSS Feed(s)
80
  include_once( ABSPATH . WPINC . '/feed.php' );
81
 
82
  // Get a SimplePie feed object from the specified feed source.
83
- $rss = fetch_feed( 'https://github.com/ruhanirabin/wp-optimize/commits/master.atom' );
84
 
85
  if ( ! is_wp_error( $rss ) ) : // Checks that the object is created correctly
86
 
87
  // Figure out how many total items there are, but limit it to 5.
88
- $maxitems = $rss->get_item_quantity( 8 );
89
 
90
  // Build an array of all the items, starting with element 0 (first element).
91
  $rss_items = $rss->get_items( 0, $maxitems );
43
  <div class="wpo_col wpo_span_1_of_3">
44
  <div class="postbox">
45
  <div class="inside">
 
 
 
 
 
 
46
  <h3><?php _e('Plugin Resources','wp-optimize'); ?></h3>
47
  <p>
48
  <b><a href="https://translate.wordpress.org/projects/wp-plugins/wp-optimize" target="_blank"><?php _e('Plugin Translation Portal (needs WordPress account)', 'wp-optimize'); ?></a></b>
69
  <div class="wpo_col wpo_span_1_of_3">
70
  <div class="postbox">
71
  <div class="inside">
72
+ <h3>
73
+ <?php _e("What's New", 'wp-optimize'); ?></h3>
74
+
75
+ <?php
76
+ $news_items = wpo_readFeed('http://ruhanirabin.github.io/WP-Optimize/feed.xml', 3);
77
+
78
+ foreach ( $news_items as $item ) : ?>
79
+ <p>
80
+ <b> <a href="<?php echo $item->get_link(); ?>" title="<?php echo $item->get_title(); ?>" target="_blank"><?php echo $item->get_title(); ?></a> </b>
81
+ </p>
82
+ <?php endforeach; ?>
83
+
84
+ <h3><?php _e('GitHub - Develop Branch','wp-optimize'); ?></h3>
85
  <?php // Get RSS Feed(s)
86
  include_once( ABSPATH . WPINC . '/feed.php' );
87
 
88
  // Get a SimplePie feed object from the specified feed source.
89
+ $rss = fetch_feed( 'https://github.com/ruhanirabin/wp-optimize/commits/develop.atom' );
90
 
91
  if ( ! is_wp_error( $rss ) ) : // Checks that the object is created correctly
92
 
93
  // Figure out how many total items there are, but limit it to 5.
94
+ $maxitems = $rss->get_item_quantity( 5 );
95
 
96
  // Build an array of all the items, starting with element 0 (first element).
97
  $rss_items = $rss->get_items( 0, $maxitems );
wp-optimize-main.php CHANGED
@@ -61,13 +61,21 @@ if (isset($_POST["clean-trackbacks"])) {
61
  }
62
 
63
  if (isset($_POST["clean-transient"])) {
64
- $text .= wpo_cleanUpSystem('transient_options');
65
  }
66
 
67
  if (isset($_POST["clean-postmeta"])) {
68
  $text .= wpo_cleanUpSystem('postmeta');
69
  }
70
 
 
 
 
 
 
 
 
 
71
  if (isset($_POST["clean-tags"])) {
72
  $text .= wpo_cleanUpSystem('tags');
73
  }
@@ -145,10 +153,42 @@ Function optimizeTablesQuick($Optimize){
145
 
146
  ?>
147
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
148
 
 
 
 
 
 
 
 
 
149
 
150
  <div class="wpo_section wpo_group">
151
- <form action="#" method="post" enctype="multipart/form-data" name="optimize_form" id="optimize_form">
152
  <div class="wpo_col wpo_span_1_of_3">
153
  <div class="postbox">
154
  <div class="inside">
@@ -210,15 +250,15 @@ Function optimizeTablesQuick($Optimize){
210
  </p>
211
  <p>
212
  <label>
213
- <input name="clean-transient" id="clean-transient" type="checkbox" value="" />
214
  <span style="color: red;"><?php _e('Remove transient options', 'wp-optimize'); ?></span>
215
  </label>
216
  <br />
217
- <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('transient_options'), 'wp-optimize'); ?></small>
218
  </p>
219
  <p>
220
  <label>
221
- <input name="clean-pingbacks" id="clean-pingbacks" type="checkbox" value="" />
222
  <span style="color: red;"><?php _e('Remove pingbacks', 'wp-optimize'); ?></span>
223
  </label>
224
  <br />
@@ -226,18 +266,47 @@ Function optimizeTablesQuick($Optimize){
226
  </p>
227
  <p>
228
  <label>
229
- <input name="clean-trackbacks" id="clean-trackbacks" type="checkbox" value="" />
230
  <span style="color: red;"><?php _e('Remove trackbacks', 'wp-optimize'); ?></span>
231
  </label>
232
  <br />
233
  <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('trackbacks'), 'wp-optimize'); ?></small>
234
  </p>
 
235
  <p>
236
- <small><?php _e('Do not select RED marked items unless you really need to use them', 'wp-optimize'); ?></small>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
237
  </p>
238
  <p>
239
  <a href="https://wordpress.org/plugins/youtube-embed-plus/" target="_blank">
240
- <img src="<?php echo WPO_PLUGIN_URL ;?>embedplus.png" style="float: left;margin-right: 7px;"> <?php _e('Optimize YouTube embedding with this free plugin on WordPress.org', 'wp-optimize'); ?> &raquo;</a>
241
  </p>
242
  </div>
243
  </div>
@@ -283,15 +352,6 @@ Function optimizeTablesQuick($Optimize){
283
 
284
  <h3><?php _e('Status log', 'wp-optimize'); ?></h3>
285
 
286
- <?php
287
- $news_items = wpo_readFeed('http://ruhanirabin.github.io/WP-Optimize/feed.xml', 1);
288
-
289
- foreach ( $news_items as $item ) : ?>
290
- <p>
291
- <b> <a href="<?php echo $item->get_link(); ?>" title="<?php echo $item->get_title(); ?>" target="_blank"><?php echo $item->get_title(); ?></a> </b>
292
- </p>
293
- <?php endforeach; ?>
294
-
295
  <?php
296
  $lastopt = get_option(OPTION_NAME_LAST_OPT, 'Never');
297
  if ($lastopt !== 'Never'){
@@ -435,14 +495,17 @@ Function optimizeTablesQuick($Optimize){
435
  </div>
436
  <div class="wpo_col wpo_span_1_of_3">
437
 
438
- <p>
439
  <?php wpo_headerImage(); ?>
440
- </p>
441
  <p>
442
  <?php _e('Sponsor','wp-optimize')?>
443
  </p>
444
  <p>
445
- <a href="http://j.mp/1ePlbvc" target="_blank"><img style="border:0px" src="<?php echo WPO_PLUGIN_URL ;?>elegantthemes_sm.png" width="310" height="auto" alt=""></a>
 
 
 
446
  </p>
447
  </div>
448
  </form>
61
  }
62
 
63
  if (isset($_POST["clean-transient"])) {
64
+ $text .= wpo_cleanUpSystem('transient');
65
  }
66
 
67
  if (isset($_POST["clean-postmeta"])) {
68
  $text .= wpo_cleanUpSystem('postmeta');
69
  }
70
 
71
+ if (isset($_POST["clean-commentmeta"])) {
72
+ $text .= wpo_cleanUpSystem('commentmeta');
73
+ }
74
+
75
+ if (isset($_POST["clean-orphandata"])) {
76
+ $text .= wpo_cleanUpSystem('orphandata');
77
+ }
78
+
79
  if (isset($_POST["clean-tags"])) {
80
  $text .= wpo_cleanUpSystem('tags');
81
  }
153
 
154
  ?>
155
 
156
+ <script type="text/javascript">
157
+
158
+ function fCheck() {
159
+ var vCleanPingbacks = document.getElementById('clean-pingbacks');
160
+ var vCleanTrackbacks = document.getElementById('clean-trackbacks');
161
+ var vCleanPostmeta = document.getElementById('clean-postmeta');
162
+ var vCleanCommentmeta = document.getElementById('clean-commentmeta');
163
+ var vCleanOrphandata = document.getElementById('clean-orphandata');
164
+ var vCleanTransient = document.getElementById('clean-transient');
165
+
166
+ if ( vCleanTransient.checked )
167
+ return confirm('<?php _e('Transient options are automatically re-created by WordPress. Select this option, if you have a large number of Transient.', 'wp-optimize'); ?>');
168
+
169
+ if ( vCleanPingbacks.checked )
170
+ return confirm('<?php _e('This will delete all pingbacks in the database. Are you sure?', 'wp-optimize'); ?>');
171
+
172
+ if ( vCleanTrackbacks.checked )
173
+ return confirm('<?php _e('This will delete all trackbacks in the database. Are you sure?', 'wp-optimize'); ?>');
174
+
175
+ if ( vCleanPostmeta.checked )
176
+ return confirm('<?php _e('Cleaning up post meta can have unexpected results on some servers. Are you sure?', 'wp-optimize'); ?>');
177
+
178
+ if ( vCleanCommentmeta.checked )
179
+ return confirm('<?php _e('Cleaning up comments meta can have unexpected results on some servers. Are you sure?', 'wp-optimize'); ?>');
180
 
181
+ if ( vCleanOrphandata.checked )
182
+ return confirm('<?php _e('Cleaning up orphaned post relationship data can have unexpected result. Are you sure?', 'wp-optimize'); ?>');
183
+
184
+ }
185
+
186
+
187
+
188
+ </script>
189
 
190
  <div class="wpo_section wpo_group">
191
+ <form onSubmit="return confirm('<?php _e('WARNING: This operation is permanent. Continue?', 'wp-optimize'); ?>')" action="#" method="post" enctype="multipart/form-data" name="optimize_form" id="optimize_form">
192
  <div class="wpo_col wpo_span_1_of_3">
193
  <div class="postbox">
194
  <div class="inside">
250
  </p>
251
  <p>
252
  <label>
253
+ <input name="clean-transient" id="clean-transient" type="checkbox" value="" onclick="return fCheck()"/>
254
  <span style="color: red;"><?php _e('Remove transient options', 'wp-optimize'); ?></span>
255
  </label>
256
  <br />
257
+ <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('transient'), 'wp-optimize'); ?></small>
258
  </p>
259
  <p>
260
  <label>
261
+ <input name="clean-pingbacks" id="clean-pingbacks" type="checkbox" value="" onclick="return fCheck()"/>
262
  <span style="color: red;"><?php _e('Remove pingbacks', 'wp-optimize'); ?></span>
263
  </label>
264
  <br />
266
  </p>
267
  <p>
268
  <label>
269
+ <input name="clean-trackbacks" id="clean-trackbacks" type="checkbox" value="" onclick="return fCheck()"/>
270
  <span style="color: red;"><?php _e('Remove trackbacks', 'wp-optimize'); ?></span>
271
  </label>
272
  <br />
273
  <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('trackbacks'), 'wp-optimize'); ?></small>
274
  </p>
275
+
276
  <p>
277
+ <label>
278
+ <input name="clean-postmeta" id="clean-postmeta" type="checkbox" value=""
279
+ onclick="return fCheck()"/>
280
+ <span style="color: red;"><?php _e('Clean post meta data', 'wp-optimize'); ?></span>
281
+ </label>
282
+ <br />
283
+ <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('postmeta'), 'wp-optimize'); ?></small>
284
+ </p>
285
+
286
+ <p>
287
+ <label>
288
+ <input name="clean-commentmeta" id="clean-commentmeta" type="checkbox" value="" onclick="return fCheck()"/>
289
+ <span style="color: red;"><?php _e('Clean comment meta data', 'wp-optimize'); ?></span>
290
+ </label>
291
+ <br />
292
+ <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('commentmeta'), 'wp-optimize'); ?></small>
293
+ </p>
294
+
295
+ <p>
296
+ <label>
297
+ <input name="clean-orphandata" id="clean-orphandata" type="checkbox" value="" onclick="return fCheck()"/>
298
+ <span style="color: red;"><?php _e('Clean orphaned relationship data', 'wp-optimize'); ?></span>
299
+ </label>
300
+ <br />
301
+ <small>&nbsp;&nbsp;<?php _e(wpo_getInfo('orphandata'), 'wp-optimize'); ?></small>
302
+ </p>
303
+
304
+ <p>
305
+ <small><span style="color: red;"><?php _e('WARNING: Do not select RED marked items, they may have unexpected results', 'wp-optimize'); ?></span></small>
306
  </p>
307
  <p>
308
  <a href="https://wordpress.org/plugins/youtube-embed-plus/" target="_blank">
309
+ <img src="<?php echo WPO_PLUGIN_URL ;?>/images/embedplus.png" style="float: left;margin-right: 7px;"> <?php _e('Optimize YouTube embedding with this free plugin on WordPress.org', 'wp-optimize'); ?> &raquo;</a>
310
  </p>
311
  </div>
312
  </div>
352
 
353
  <h3><?php _e('Status log', 'wp-optimize'); ?></h3>
354
 
 
 
 
 
 
 
 
 
 
355
  <?php
356
  $lastopt = get_option(OPTION_NAME_LAST_OPT, 'Never');
357
  if ($lastopt !== 'Never'){
495
  </div>
496
  <div class="wpo_col wpo_span_1_of_3">
497
 
498
+ <!-- <p>
499
  <?php wpo_headerImage(); ?>
500
+ </p> -->
501
  <p>
502
  <?php _e('Sponsor','wp-optimize')?>
503
  </p>
504
  <p>
505
+ <a href="http://bit.ly/266KJBZ" target="_blank"><img style="border:0px" src="<?php echo WPO_PLUGIN_URL ;?>/images/mythemeshop.png" width="310" height="auto" alt=""></a>
506
+ </p>
507
+ <p>
508
+ <a href="http://j.mp/1ePlbvc" target="_blank"><img style="border:0px" src="<?php echo WPO_PLUGIN_URL ;?>/images/elegantthemes_sm.png" width="310" height="auto" alt=""></a>
509
  </p>
510
  </div>
511
  </form>
wp-optimize-settings.php CHANGED
@@ -177,7 +177,7 @@ if ($_SERVER['REQUEST_METHOD'] === 'POST') {
177
  </p>
178
  <p>
179
  <a href="https://wordpress.org/plugins/youtube-embed-plus/" target="_blank">
180
- <img src="<?php echo WPO_PLUGIN_URL ;?>embedplus.png" style="float: left;margin-right: 7px;"> <?php _e('Optimize YouTube embedding with this free plugin on WordPress.org', 'wp-optimize'); ?> &raquo;</a>
181
  </p>
182
  <p>
183
  <input class="button-primary" type="submit" name="wp-optimize-settings1" value="<?php _e('SAVE SETTINGS', 'wp-optimize'); ?>" />
177
  </p>
178
  <p>
179
  <a href="https://wordpress.org/plugins/youtube-embed-plus/" target="_blank">
180
+ <img src="<?php echo WPO_PLUGIN_URL ;?>images/embedplus.png" style="float: left;margin-right: 7px;"> <?php _e('Optimize YouTube embedding with this free plugin on WordPress.org', 'wp-optimize'); ?> &raquo;</a>
181
  </p>
182
  <p>
183
  <input class="button-primary" type="submit" name="wp-optimize-settings1" value="<?php _e('SAVE SETTINGS', 'wp-optimize'); ?>" />
wp-optimize.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: WP-Optimize
4
  Plugin URI: http://wp-optimize.ruhanirabin.com/
5
  Description: This plugin helps you to keep your database clean by removing post revisions and spam in a blaze. Additionally, it allows you to run the optimize command on your WordPress core tables (please use with caution).
6
- Version: 1.9
7
  Author: Ruhani Rabin
8
  Author URI: https://github.com/ruhanirabin/WP-Optimize
9
  Text Domain: wp-optimize
@@ -45,7 +45,7 @@ global $current_user;
45
  //error_reporting( error_reporting() & ~E_NOTICE );
46
 
47
  if (! defined('WPO_VERSION'))
48
- define('WPO_VERSION', '1.9');
49
 
50
  if (! defined('WPO_PLUGIN_MAIN_PATH'))
51
  define('WPO_PLUGIN_MAIN_PATH', plugin_dir_path( __FILE__ ));
3
  Plugin Name: WP-Optimize
4
  Plugin URI: http://wp-optimize.ruhanirabin.com/
5
  Description: This plugin helps you to keep your database clean by removing post revisions and spam in a blaze. Additionally, it allows you to run the optimize command on your WordPress core tables (please use with caution).
6
+ Version: 1.9.1
7
  Author: Ruhani Rabin
8
  Author URI: https://github.com/ruhanirabin/WP-Optimize
9
  Text Domain: wp-optimize
45
  //error_reporting( error_reporting() & ~E_NOTICE );
46
 
47
  if (! defined('WPO_VERSION'))
48
+ define('WPO_VERSION', '1.9.1');
49
 
50
  if (! defined('WPO_PLUGIN_MAIN_PATH'))
51
  define('WPO_PLUGIN_MAIN_PATH', plugin_dir_path( __FILE__ ));