WP Clean Up - Version 1.1.1

Version Description

  • Some optimization
Download this release

Release Info

Developer acalbert
Plugin Icon wp plugin WP Clean Up
Version 1.1.1
Comparing to
See all releases

Code changes from version 1.1.0 to 1.1.1

Files changed (5) hide show
  1. lang/wp-clean-up-zh_CN.mo +0 -0
  2. lang/wp-clean-up-zh_CN.po +26 -26
  3. readme.txt +5 -1
  4. wp-clean-up.php +1 -62
  5. wp_clean_up_admin.php +64 -1
lang/wp-clean-up-zh_CN.mo CHANGED
Binary file
lang/wp-clean-up-zh_CN.po CHANGED
@@ -2,8 +2,8 @@ msgid ""
2
  msgstr ""
3
  "Project-Id-Version: WP-Clean-Up Languages\n"
4
  "Report-Msgid-Bugs-To: \n"
5
- "POT-Creation-Date: 2012-12-06 14:58+0800\n"
6
- "PO-Revision-Date: 2012-12-06 15:03+0800\n"
7
  "Last-Translator: 夜光 <berttung(#)gmail.com>\n"
8
  "Language-Team: 玻璃泉BoLiQuan.COM <berttung(#)gmail.com>\n"
9
  "MIME-Version: 1.0\n"
@@ -16,84 +16,84 @@ msgstr ""
16
  "X-Poedit-SourceCharset: utf-8\n"
17
  "X-Poedit-SearchPath-0: F:\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-clean-up\n"
18
 
19
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp-clean-up.php:85
20
  msgid "Settings"
21
  msgstr "设置"
22
 
23
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:17
24
  msgid "All revisions deleted!"
25
  msgstr "所有修订版本已删除！"
26
 
27
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:22
28
  msgid "All drafts deleted!"
29
  msgstr "所有草稿已删除！"
30
 
31
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:27
32
  msgid "All autodrafts deleted!"
33
  msgstr "所有自动草稿已删除！"
34
 
35
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:32
36
  msgid "All moderated comments deleted!"
37
  msgstr "所有待审评论已删除！"
38
 
39
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:37
40
  msgid "All spam comments deleted!"
41
  msgstr "所有垃圾评论已删除！"
42
 
43
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:42
44
  msgid "All trash comments deleted!"
45
  msgstr "所有回收站评论已删除！"
46
 
47
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:52
48
  msgid "All redundant data deleted!"
49
  msgstr "所有冗余数据已删除！"
50
 
51
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:64
52
  msgid "Type"
53
  msgstr "类型"
54
 
55
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:65
56
  msgid "Count"
57
  msgstr "数量"
58
 
59
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:66
60
  msgid "Operate"
61
  msgstr "操作"
62
 
63
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:72
64
  msgid "Revision"
65
  msgstr "修订版本"
66
 
67
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:80
68
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:94
69
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:108
70
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:122
71
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:136
72
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:150
73
  msgid "Delete"
74
  msgstr "删除"
75
 
76
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:86
77
  msgid "Draft"
78
  msgstr "草稿"
79
 
80
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:100
81
  msgid "Auto Draft"
82
  msgstr "自动草稿"
83
 
84
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:114
85
  msgid "Moderated Comments"
86
  msgstr "待审评论"
87
 
88
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:128
89
  msgid "Spam Comments"
90
  msgstr "垃圾评论"
91
 
92
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:142
93
  msgid "Trash Comments"
94
  msgstr "回收站评论"
95
 
96
- #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:161
97
  msgid "Delete All"
98
  msgstr "删除所有"
99
 
2
  msgstr ""
3
  "Project-Id-Version: WP-Clean-Up Languages\n"
4
  "Report-Msgid-Bugs-To: \n"
5
+ "POT-Creation-Date: 2012-12-07 10:24+0800\n"
6
+ "PO-Revision-Date: 2012-12-07 10:25+0800\n"
7
  "Last-Translator: 夜光 <berttung(#)gmail.com>\n"
8
  "Language-Team: 玻璃泉BoLiQuan.COM <berttung(#)gmail.com>\n"
9
  "MIME-Version: 1.0\n"
16
  "X-Poedit-SourceCharset: utf-8\n"
17
  "X-Poedit-SearchPath-0: F:\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-clean-up\n"
18
 
19
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp-clean-up.php:24
20
  msgid "Settings"
21
  msgstr "设置"
22
 
23
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:80
24
  msgid "All revisions deleted!"
25
  msgstr "所有修订版本已删除！"
26
 
27
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:85
28
  msgid "All drafts deleted!"
29
  msgstr "所有草稿已删除！"
30
 
31
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:90
32
  msgid "All autodrafts deleted!"
33
  msgstr "所有自动草稿已删除！"
34
 
35
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:95
36
  msgid "All moderated comments deleted!"
37
  msgstr "所有待审评论已删除！"
38
 
39
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:100
40
  msgid "All spam comments deleted!"
41
  msgstr "所有垃圾评论已删除！"
42
 
43
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:105
44
  msgid "All trash comments deleted!"
45
  msgstr "所有回收站评论已删除！"
46
 
47
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:115
48
  msgid "All redundant data deleted!"
49
  msgstr "所有冗余数据已删除！"
50
 
51
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:127
52
  msgid "Type"
53
  msgstr "类型"
54
 
55
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:128
56
  msgid "Count"
57
  msgstr "数量"
58
 
59
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:129
60
  msgid "Operate"
61
  msgstr "操作"
62
 
63
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:135
64
  msgid "Revision"
65
  msgstr "修订版本"
66
 
67
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:143
68
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:157
69
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:171
70
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:185
71
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:199
72
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:213
73
  msgid "Delete"
74
  msgstr "删除"
75
 
76
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:149
77
  msgid "Draft"
78
  msgstr "草稿"
79
 
80
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:163
81
  msgid "Auto Draft"
82
  msgstr "自动草稿"
83
 
84
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:177
85
  msgid "Moderated Comments"
86
  msgstr "待审评论"
87
 
88
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:191
89
  msgid "Spam Comments"
90
  msgstr "垃圾评论"
91
 
92
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:205
93
  msgid "Trash Comments"
94
  msgstr "回收站评论"
95
 
96
+ #: F:\xampp\htdocs\wordpress\wp-content\plugins\wp-clean-up/wp_clean_up_admin.php:224
97
  msgid "Delete All"
98
  msgstr "删除所有"
99
 
readme.txt CHANGED
@@ -5,7 +5,7 @@ Tags: wp clean up,clean,cleaner,cleanup,database,mysql,comments,posts,post revis
5
  License: GPLv2
6
  Requires at least: 2.7
7
  Tested up to: 3.4.2
8
- Stable tag: 1.1.0
9
 
10
  WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" and so on.
11
 
@@ -48,6 +48,10 @@ Related Links:
48
 
49
  == Changelog ==
50
 
 
 
 
 
51
  = 1.1.0 =
52
 
53
  * First release.
5
  License: GPLv2
6
  Requires at least: 2.7
7
  Tested up to: 3.4.2
8
+ Stable tag: 1.1.1
9
 
10
  WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" and so on.
11
 
48
 
49
  == Changelog ==
50
 
51
+ = 1.1.1 =
52
+
53
+ * Some optimization
54
+
55
  = 1.1.0 =
56
 
57
  * First release.
wp-clean-up.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: WP Clean Up
4
  Plugin URI: http://boliquan.com/wp-clean-up/
5
  Description: WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" "moderated comments" "spam comments" "trash comments".
6
- Version: 1.1.0
7
  Author: BoLiQuan
8
  Author URI: http://boliquan.com/
9
  Text Domain: WP-Clean-Up
@@ -19,67 +19,6 @@ function load_wp_clean_up_lang(){
19
  }
20
  add_filter('init','load_wp_clean_up_lang');
21
 
22
- function wp_clean_up($type){
23
- global $wpdb;
24
- switch($type){
25
- case "revision":
26
- $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_type = 'revision'";
27
- $wpdb->query($wcu_sql);
28
- break;
29
- case "draft":
30
- $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_status = 'draft'";
31
- $wpdb->query($wcu_sql);
32
- break;
33
- case "autodraft":
34
- $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_status = 'auto-draft'";
35
- $wpdb->query($wcu_sql);
36
- break;
37
- case "moderated":
38
- $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = '0'";
39
- $wpdb->query($wcu_sql);
40
- break;
41
- case "spam":
42
- $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = 'spam'";
43
- $wpdb->query($wcu_sql);
44
- break;
45
- case "trash":
46
- $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = 'trash'";
47
- $wpdb->query($wcu_sql);
48
- break;
49
- }
50
- }
51
-
52
- function wp_clean_up_count($type){
53
- global $wpdb;
54
- switch($type){
55
- case "revision":
56
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'revision'";
57
- $count = $wpdb->get_var($wcu_sql);
58
- break;
59
- case "draft":
60
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'draft'";
61
- $count = $wpdb->get_var($wcu_sql);
62
- break;
63
- case "autodraft":
64
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'auto-draft'";
65
- $count = $wpdb->get_var($wcu_sql);
66
- break;
67
- case "moderated":
68
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'";
69
- $count = $wpdb->get_var($wcu_sql);
70
- break;
71
- case "spam":
72
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = 'spam'";
73
- $count = $wpdb->get_var($wcu_sql);
74
- break;
75
- case "trash":
76
- $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = 'trash'";
77
- $count = $wpdb->get_var($wcu_sql);
78
- break;
79
- }
80
- return $count;
81
- }
82
-
83
  function wp_clean_up_settings_link($action_links,$plugin_file){
84
  if($plugin_file==plugin_basename(__FILE__)){
85
  $wcu_settings_link = '<a href="options-general.php?page=' . dirname(plugin_basename(__FILE__)) . '/wp_clean_up_admin.php">' . __("Settings") . '</a>';
3
  Plugin Name: WP Clean Up
4
  Plugin URI: http://boliquan.com/wp-clean-up/
5
  Description: WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" "moderated comments" "spam comments" "trash comments".
6
+ Version: 1.1.1
7
  Author: BoLiQuan
8
  Author URI: http://boliquan.com/
9
  Text Domain: WP-Clean-Up
19
  }
20
  add_filter('init','load_wp_clean_up_lang');
21
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
22
  function wp_clean_up_settings_link($action_links,$plugin_file){
23
  if($plugin_file==plugin_basename(__FILE__)){
24
  $wcu_settings_link = '<a href="options-general.php?page=' . dirname(plugin_basename(__FILE__)) . '/wp_clean_up_admin.php">' . __("Settings") . '</a>';
wp_clean_up_admin.php CHANGED
@@ -10,6 +10,69 @@ function wp_clean_up_page(){
10
  <h2>WP Clean Up</h2>
11
 
12
  <?php
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
13
  $wcu_message = '';
14
 
15
  if(isset($_POST['wp_clean_up_revision'])){
@@ -58,7 +121,7 @@ function wp_clean_up_page(){
58
  ?>
59
 
60
  <p>
61
- <table class="widefat" style="width:36%;">
62
  <thead>
63
  <tr>
64
  <th scope="col"><?php _e('Type','WP-Clean-Up'); ?></th>
10
  <h2>WP Clean Up</h2>
11
 
12
  <?php
13
+
14
+ function wp_clean_up($type){
15
+ global $wpdb;
16
+ switch($type){
17
+ case "revision":
18
+ $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_type = 'revision'";
19
+ $wpdb->query($wcu_sql);
20
+ break;
21
+ case "draft":
22
+ $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_status = 'draft'";
23
+ $wpdb->query($wcu_sql);
24
+ break;
25
+ case "autodraft":
26
+ $wcu_sql = "DELETE FROM $wpdb->posts WHERE post_status = 'auto-draft'";
27
+ $wpdb->query($wcu_sql);
28
+ break;
29
+ case "moderated":
30
+ $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = '0'";
31
+ $wpdb->query($wcu_sql);
32
+ break;
33
+ case "spam":
34
+ $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = 'spam'";
35
+ $wpdb->query($wcu_sql);
36
+ break;
37
+ case "trash":
38
+ $wcu_sql = "DELETE FROM $wpdb->comments WHERE comment_approved = 'trash'";
39
+ $wpdb->query($wcu_sql);
40
+ break;
41
+ }
42
+ }
43
+
44
+ function wp_clean_up_count($type){
45
+ global $wpdb;
46
+ switch($type){
47
+ case "revision":
48
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'revision'";
49
+ $count = $wpdb->get_var($wcu_sql);
50
+ break;
51
+ case "draft":
52
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'draft'";
53
+ $count = $wpdb->get_var($wcu_sql);
54
+ break;
55
+ case "autodraft":
56
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'auto-draft'";
57
+ $count = $wpdb->get_var($wcu_sql);
58
+ break;
59
+ case "moderated":
60
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'";
61
+ $count = $wpdb->get_var($wcu_sql);
62
+ break;
63
+ case "spam":
64
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = 'spam'";
65
+ $count = $wpdb->get_var($wcu_sql);
66
+ break;
67
+ case "trash":
68
+ $wcu_sql = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = 'trash'";
69
+ $count = $wpdb->get_var($wcu_sql);
70
+ break;
71
+ }
72
+ return $count;
73
+ }
74
+
75
+
76
  $wcu_message = '';
77
 
78
  if(isset($_POST['wp_clean_up_revision'])){
121
  ?>
122
 
123
  <p>
124
+ <table class="widefat" style="width:419px;">
125
  <thead>
126
  <tr>
127
  <th scope="col"><?php _e('Type','WP-Clean-Up'); ?></th>