Changeset 130677

Timestamp:

06/30/2009 04:49:39 AM (17 years ago)

Author:

gohsy

Message:

 

Location:

delete-revision

Files:

• tags/1.3 (added)
• tags/1.3/changelog.txt (added)
• tags/1.3/delete-revision-zh_CN.mo (added)
• tags/1.3/delete-revision-zh_CN.po (added)
• tags/1.3/delete-revision.php (added)
• tags/1.3/readme.txt (added)
• tags/1.3/screenshot-1.png (added)
• tags/1.3/screenshot-2.png (added)
• tags/1.3/screenshot-3.png (added)
• trunk/changelog.txt (modified) (1 diff)
• trunk/delete-revision-zh_CN.mo (modified) (previous)
• trunk/delete-revision-zh_CN.po (modified) (4 diffs)
• trunk/delete-revision.php (modified) (10 diffs)
• trunk/readme.txt (modified) (2 diffs)
• trunk/screenshot1.png (deleted)
• trunk/screenshot2.png (deleted)
• trunk/screenshot3.png (deleted)

delete-revision/trunk/changelog.txt

@@ +1 @@
+2009-06-30  v1.3
+            Increased the database maintenance and the optimization
+            增加数据库状态检测和修复优化
+
 2008-11-24  v1.2
             An increase of the international language support
-            Ôö¼Ó¹ú¼Ê»¯ÓïÑÔÖ§³Ö
+            增加国际化语言支持
 
 2008-11-24  v1.1
             Fix bugs cann't runat where the datebase name is not the default "wp-*" and some description. 
-            ÐÞ¸´ÁËÒòÊý¾Ý¿âÃû³Æǰ׺·ÇĬÈϵÄ"wp-*"ʱµÄÔËÐдíÎóºÍ×ÊÁÏÖÐ˵Ã÷ÖÐÊý×ÖÎÊÌâ¡£
+            修复了因数据库名称前缀非默认的"wp-*"时的运行错误和资料中说明中数字问题。
 2008-10-21  v1.0
             First public ver1.0
-            Ê״η¢²¼1.0
+            首次发布1.0

delete-revision/trunk/delete-revision-zh_CN.po

@@ -4 +4 @@
 "Report-Msgid-Bugs-To: \n"
 "POT-Creation-Date: 2008-11-24 17:51+0800\n"
-"PO-Revision-Date: 2008-11-24 18:27+0800\n"
-"Last-Translator: gohsy <igohsy@gmail.com>\n"
+"PO-Revision-Date: 2009-06-30 12:44+0800\n"
+"Last-Translator: gohsy.com <me@gohsy.com>\n"
 "Language-Team: gohsy <[email protected]>\n"
 "MIME-Version: 1.0\n"
@@ -17 +17 @@
 #: delete-revision.php:32
 #, php-format
-msgid "Now You have <span style='color:red;font-weight:bolder;'> %s </span> posts ,Up to now Delete-Revision has deteted <span style='color:red;font-weight:bolder;'> %s </span> post revision of dedundancy,it's easy . Wish happy ending !"
-msgstr "您已经发布了 <span style='color:red;font-weight:bolder;'> %s </span> 篇日志，截止目前，Delete-Revision 已轻松删除了 <span style='color:red;font-weight:bolder;'> %s </span>  篇冗余日志，祝您愉快！"
+msgid "Now You have <span style='color:red;font-weight:bolder;'> %s </span> posts ,Up to now Delete-Revision has deteted <span id='revs_no' style='color:red;font-weight:bolder;'> %s </span> post revision of dedundancy,it's easy . Wish happy ending !"
+msgstr "您已经发布了 <span style='color:red;font-weight:bolder;'> %s </span> 篇日志，截止目前，Delete-Revision 已轻松删除了 <span id='revs_no' style='color:red;font-weight:bolder;'> %s </span>  篇冗余日志，祝您愉快！"
 
 #: delete-revision.php:41
@@ -27 +27 @@
 #: delete-revision.php:51
 msgid "Check Redundant Revision"
-msgstr "检查冗余 Revision 数量"
+msgstr "检查冗余 日志 数量"
 
 #: delete-revision.php:57
@@ -62 +62 @@
 msgstr "太棒了，您的wordpress还没有发现冗余的 revision 日志 ! <br />今天又是您美好的一天 ！"
 
+msgid "Optimize DataBase"
+msgstr "执行数据库优化"
+
+msgid "If the Status is green <font color=green>OK</font>, then indicated that is normal, does not need any operation, please go back; If is red, then click on the following button to optimize."
+msgstr "如果Status是绿色的<font color=green>OK</font>，则表明是正常的，不需要任何操作，请返回。如果是红色的，请点击下来的按钮执行优化。"
+
+msgid "Optimization of database completed."
+msgstr "优化数据库操作完成！"
+
+msgid "Database Optimization"
+msgstr "检测数据库和优化"
+

delete-revision/trunk/delete-revision.php

@@ -5 +5 @@
 Description: Delete revision post from Database,let us now to drop Redundancy, lose weight !
 Author: gohsy
-Version: 1.2
+Version: 1.3
 Author URI: http://gohsy.com
 */
@@ -11 +11 @@
 /*
 Changelog
+
+2009-06-30  v1.3
+            Increased the database maintenance and the optimization
+            Ôö¼ÓÊý¾Ý¿â״̬¼ì²âºÍÐÞ¸´ÓÅ»¯
 
 2008-11-24  v1.2
@@ -41 +45 @@
 
 function my_options_delete_revision() {
-    $dr_ver = 1.1;
+    $dr_ver = 1.3;
     $get_my_posts = get_my_posts();
     $del_revision_no = get_option('del_revision_no');
@@ -47 +51 @@
     <div class="wrap">
         <h2>Delete-revision Manager  <font size=1>ver $dr_ver</font></h2>
-        <div style="padding:5px 0;border:1px dashed #80B5D0;padding:10px;background:#E4F2FD;margin:15px 0;">
+        <div class="widget"><p style="margin:10px;">
 EOT;
-        printf(__("Now You have <span style='color:red;font-weight:bolder;'> %s </span> posts ,Up to now Delete-Revision has deteted <span style='color:red;font-weight:bolder;'> %s </span> post revision of dedundancy,it's easy . Wish happy ending !",'delete-revision'), $get_my_posts,$del_revision_no);
-        echo '</div>';
-
-        
+        printf(__("Now You have <span style='color:red;font-weight:bolder;'> %s </span> posts ,Up to now Delete-Revision has deteted <span id='revs_no' style='color:red;font-weight:bolder;'> %s </span> post revision of dedundancy,it's easy . Wish happy ending !",'delete-revision'), $get_my_posts,$del_revision_no);
+        echo '</p></div>';
+
     if (isset($_POST['del_act'])) {
         delete_revision_act();
@@ -59 +62 @@
         echo '<div class="updated" style="margin-top:50px;"><p><strong>';
         printf(__("Deleted <span style='color:red;font-weight:bolder;'> %s </span> redundancy posts !",'delete-revision'),$del_no); 
-        echo '</strong></p></div></div>';
+        echo "</strong></p></div></div><script>
+        var del_no = document.getElementById('revs_no').innerHTML;
+        document.getElementById('revs_no').innerHTML = Number(del_no)+ $del_no;
+        </script>";
     }
     elseif (isset($_POST['get_rev'])) {
@@ -65 +71 @@
         
     }
+    elseif (isset($_POST['maintain_mysql'])) {
+        if ($_POST['operation'] == 'OPTIMIZE' ) {echo maintain_mysql('OPTIMIZE');}
+        else echo maintain_mysql('ANALYZE');
+    }
     else {
         echo '<form method="post" action="">';
-        echo '<input type="submit" name="get_rev" value="';
+        echo '<input class="button" type="submit" name="get_rev" value="';
         _e('Check Redundant Revision','delete-revision');
+        echo '" />  <input class="button" type="submit" name="maintain_mysql" value="';
+        _e('Database Optimization','delete-revision');
         echo '" /></form></div>';
 
     }
     
-    echo '<div style="line-height:22px;padding:5px 0;border:1px dashed #80B5D0;padding:10px;background:#E4F2FD;margin:15px;">';
+    echo '<br /><div class="widget"><div style="margin:12px;line-height: 1.5em;">';
     _e('Revision Post is in the 2.6 version of WordPress after the automatic accession to the revised edition of the journal preservation cause, you modify a log of each, will add a revision, if you modify many times, log on the few speeches, it will be a very frightening number!','delete-revision');
-    //echo '<br />';
     _e('If you have 100 on the log, your revisiong redundancy may be as many as 1,000 articles!','delete-revision');
     echo '<br />';
@@ -82 +93 @@
     _e('Thank you for your useing. I hope this will give you convenient plug-ins!','delete-revision');
     _e('Author','delete-revision');
-    echo ':<a href="http://www.gohsy.com" target="_blank">http://www.gohsy.com</a></div>';
+    echo ':<a href="http://www.gohsy.com" target="_blank">http://www.gohsy.com</a></div></div>';
     
 }
@@ -110 +121 @@
     if($results) {
     $res_no = count($results);
-    echo "<table>";
-    echo "<tr style=\"background:#C6D9E9\"><td width=30> Id </td><td width=450> Title </td><td width=180> Post date </td><td width=180> Last modified </td></tr>";
+    echo "<table class='widefat'><thead>";
+    echo "<tr><th width=30> Id </th><th width=450> Title </th><th width=180> Post date </th><th width=180> Last modified </th></tr></thead>";
     for($i = 0 ; $i < $res_no ; $i++) {
         echo "<tr><td>".$results[$i] -> ID."</td>";
@@ -123 +134 @@
         <input type="hidden" name="rev_no" value=" $res_no " />
 EOT;
-        echo '<input type="submit" name="del_act" value="';
-        printf(__('Yes,I would like to delete them!(A Total Of %s)','delete-revision'),$res_no);
-        echo '" /><input type="submit" name="goback" value="';
-        _e('No,I would not mind deleted!','delete-revision');
+        echo '<input class="button" type="submit" name="del_act" value="';
+        printf(__('Yes , I would like to delete them!(A Total Of %s)','delete-revision'),$res_no);
+        echo '" /><input class="button" type="submit" name="goback" value="';
+        _e('No , I would not mind deleted!','delete-revision');
         echo '" /></form></div>';
 
@@ -144 +155 @@
 }
 
+function maintain_mysql($operation = "ANALYZE"){
+        global $wpdb;
+       
+        $Tables = $wpdb -> get_results('SHOW TABLES IN '.DB_NAME);
+        $query = "$operation TABLE ";
+
+        $Tables_in_DB_NAME = 'Tables_in_'.DB_NAME;
+        foreach($Tables as $k=>$v){
+            $_tabName = $v -> $Tables_in_DB_NAME ;
+           $query .= " `$_tabName`,";
+        }
+
+        $query = substr($query,0,strlen($query)-1);
+        $result = $wpdb -> get_results($query);
+        if ($operation == "OPTIMIZE") {
+            return '<h3>'.__('Optimization of database completed.','delete-revision').'</h3>';
+        }
+
+        $res = "<table border=\"0\" class=\"widefat\">";
+        $res .= "<thead><tr>
+            <th>Table</th>
+            <th>OP</th>
+            <th>Status</th>
+            </tr><thead>";
+        $bgcolor = $color3;
+        foreach($result as $j=>$o) {
+            $res .= "<tr>";
+            foreach ($o as $k=>$v) {
+                $tdClass = $j%2 == 1 ? 'active alt' : 'inactive';
+                if($k == 'Msg_type') continue;
+                if($k == 'Msg_text' ) {
+                    if ($v == 'OK') {
+                    $res .= "<td class='$tdClass' ><font color='green'><b>$v</b></font></td>";
+                    }
+                    else {
+                    $res .= "<td class='$tdClass' ><font color='red'><b>$v</b></font></td>";
+                    }
+                }
+                else $res .= "<td class='$tdClass' >$v</td>";
+            }
+            $res .= "</tr>";
+        }
+        $res .= "<tfoot><tr><th colspan=3>".__('If the Status is green <font color=green>OK</font>, then indicated that is normal, does not need any operation, please go back; If is red, then click on the following button to optimize.','delete-revision')."</th></tr></tfoot></table>";
+        $res .= "<br /><form method='post' action=''>
+            <input name='operation' type='hidden' value='OPTIMIZE' />
+            <input name='maintain_mysql' type='hidden' value='OPTIMIZE' />
+            <input name='submit' type='submit' class='button' value='".__('Optimize DataBase','delete-revision')."' /></form>";
+        return $res;
+    }
+
 ?>

delete-revision/trunk/readme.txt

@@ -5 +5 @@
 Tags:revision,posts,datebase,Redundancy
 Requires at least:2.6.X
-Tested up to:1.2
-Stable tag:1.2
+Tested up to:1.3
+Stable tag:1.3
 
 Delete revision post from Database,let us now to drop Redundancy, lose weight !
@@ -30 +30 @@
 == Contributors/Changelog ==
 
+2009-06-30  v1.3
+            Increased the database maintenance and the optimization
+            增加数据库状态检测和修复优化
+
+
 2008-11-24  v1.2
             An increase of the international language support
-            Ôö¼Ó¹ú¼Ê»¯ÓïÑÔÖ§³Ö
+            增加国际化语言支持
 
 2008-11-24  v1.1
             Fix bugs cann't runat where the datebase name is not the default "wp-*" and some description. 
-            ÐÞ¸´ÁËÒòÊý¾Ý¿âÃû³Æǰ׺·ÇĬÈϵÄ"wp-*"ʱµÄÔËÐдíÎóºÍ×ÊÁÏÖÐ˵Ã÷ÖÐÊý×ÖÎÊÌâ¡£
+            修复了因数据库名称前缀非默认的"wp-*"时的运行错误和资料中说明中数字问题。
 2008-10-21  v1.0
             First public ver1.0
-            Ê״η¢²¼1.0
+            首次发布1.0
             
 == Frequently Asked Questions ==