乱舞春秋

七 14th, 2010删空内容的插件for DedeCMS

<?php
//COPYRIGHT hotmold.com BY sojoy
//清除内容为空的文章 2006-4-16
include “include/config_base.php”;
$db = mysql_connect($cfg_dbhost,$cfg_dbuser,$cfg_dbpwd);
mysql_select_db($cfg_dbname);

$sql = “select aid from ” .$cfg_dbprefix. “addonarticle where body = ””;
$result=mysql_query($sql,$db) or die(mysql_error());

$num=mysql_num_rows($result);

for ($i=1; $i<=$num;$i++){
    $row=mysql_fetch_array($result);
    echo “贴子ID：”.$row[aid];
    $sql2 = “delete from “.$cfg_dbprefix.”archives where id =’$row[aid]‘”;
    $result2=mysql_query($sql2,$db);
    $sql1 = “delete from “.$cfg_dbprefix.”addonarticle where aid =’$row[aid]‘”;
    $result1 = mysql_query($sql1,$db);
    echo “已被删除<font color=’#00CC00′>OK! </font> <br>”;
    }
?>

把以上代码存为一个文件名，比如：PURGE。PHP，或直接下载附件解包，然后放在DEDE根目录下运行即可!

20% off Hosting at GoDaddy.com - World's largest Web host!
Domain Sale! $7.49 .com at GoDaddy
声明：本文发表于乱舞春秋(www.20blog.cn),转载请注明出处：http://www.20blog.cn/2010/07/2254.html，谢谢！有任何问题请联系QQ37750965
标签: DedeCms,