论坛风格切换
发帖 回复
返回列表
  • 5978阅读
  • 1回复

[常用修复工具]替换主题内容和回复的特定字符 [复制链接]

 上一主题 下一主题
离线太史慈
荣誉会员
 

发帖
766
金币
626
威望
556
只看楼主 倒序阅读 使用道具 楼主  发表于: 2011-05-04
保存下面的文件为replace_content.php放在根目录下执行，记得修改下$old和$new，务必提前备分好文件哦！

复制代码
  1. <?php
  2. error_reporting(0);
  3. define('P_W',1);
  4. define('PW_UPLOAD',1);
  5. define('R_P',getdirname(__FILE__));
  6. define('D_P',R_P);
  8. require_once(R_P.'require/common.php');
  9. include_once(D_P.'data/bbscache/config.php');
  10. //require_once(R_P.'admin/cache.php');
  12. $basename = 'http://'.$_SERVER['HTTP_HOST'].(isset($_SERVER['PHP_SELF']) ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME']);
  14. @header("Content-Type:text/html; charset=$db_charset");
  16. include_once(D_P.'data/sql_config.php');
  17. if ($database=='mysqli' && Pwloaddl('mysqli')===false) {
  18. $database = 'mysql';
  19. }
  20. require_once Pcv(R_P."require/db_$database.php");
  21. $db = new DB($dbhost,$dbuser,$dbpw,$dbname,$PW,$charset,$pconnect);
  23. $action = $_GET['action'];
  24. $start = $_GET['start'];
  25. $s_c = $_GET['s_c'];
  26. if(!$action){
  27.     $action = 'tmsgs';
  28. }
  29. if(!$start){
  30.     $start = 0;
  31. }
  32. if(!$s_c){
  33.     $s_c = 0;
  34. }
  35. $percount = 1000;
  37. $old = "liudatxt.com";
  38. $new = "zhongtianwen.com";
  40. if ($action == 'tmsgs')//先替换主题内容
  41. {
  42.     $query = $db->query("SELECT tid,content FROM pw_tmsgs WHERE tid>$start ORDER BY tid LIMIT $percount");
  43.     while ($rt = $db->fetch_array($query))
  44.     {
  45. $lastid = $rt['tid'];
  46.         //$pw_tmsgs = GetTtable($rt['tid']);//分表尚未处理，一般用不到吧？
  47.         if(strpos($rt['content'],$old)!==false){
  48.             $rt['content'] = str_replace($old,$new,$rt['content']);
  49.             $db->update("UPDATE pw_tmsgs set content = '".addslashes($rt['content'])."' WHERE tid=".$rt['tid']);
  50.     $s_c++;
  51.         }
  52.     }
  53.     $maxid = $db->get_value("SELECT max(tid) FROM pw_tmsgs");
  54.     echo '当前'.$lastid.'<br />最大 '.$maxid;
  55.     if($maxid > $lastid){
  56. echo "<meta http-equiv='refresh' content='1;url=$basename?action=$action&start=$lastid&s_c=$s_c'>";
  57. }else{
  58. echo "<meta http-equiv='refresh' content='1;url=$basename?action=posts'>";
  59. }
  60. }
  61. elseif ($action == 'posts')//先替换回复内容
  62. {
  63.     $query = $db->query("SELECT tid,content FROM pw_posts WHERE pid>$start ORDER BY pid LIMIT $percount");
  64.     while ($rt = $db->fetch_array($query))
  65.     {
  66. $lastid = $rt['pid'];
  67.         if(strpos($rt['content'],$old)!==false){
  68.             $rt['content'] = str_replace($old,$new,$rt['content']);
  69.             $db->update("UPDATE pw_posts set content = '".addslashes($rt['content'])."' WHERE pid=".$rt['pid']);
  70.     $s_c++;
  71.         }
  72.     }
  73.     $maxid = $db->get_value("SELECT max(pid) FROM pw_posts");
  74.     echo '当前'.$lastid.'<br />最大 '.$maxid;
  75.     if($maxid > $lastid){
  76. echo "<meta http-equiv='refresh' content='1;url=$basename?action=$action&start=$lastid&s_c=$s_c'>";
  77. }else{
  78. echo '替换结束';exit;
  79. echo "<meta http-equiv='refresh' content='1;url=$basename?action=member'>";
  80. }
  81. }
  82. elseif ($action == 'member')//再替换用户内容
  83. {
  84.     $query = $db->query("SELECT uid,icon,signature FROM pw_members WHERE uid>$start LIMIT $percount");
  85.     while ($rt = $db->fetch_array($query))
  86.     {
  87. $lastid = $rt['pid'];
  88.         if(strpos($rt['icon'],$old)!==false){
  89.             $rt['icon'] = str_replace($old,$new,$rt['icon']);
  90.             $db->update("UPDATE pw_members set icon = '".addslashes($rt['icon'])."' WHERE uid=".$rt['uid']);
  91.     $s_c++;
  92.         }
  93.         if(strpos($rt['signature'],$old)!==false){
  94.             $rt['signature'] = str_replace($old,$new,$rt['signature']);
  95.             $db->update("UPDATE pw_members set signature = '".addslashes($rt['signature'])."' WHERE uid=".$rt['uid']);
  96.     $s_c++;
  97.         }
  98.     }
  99.     $maxid = $db->get_value("SELECT max(uid) FROM pw_members");
  100.     echo '当前'.$lastid.'<br />最大 '.$maxid;
  101.     if($maxid > $lastid){
  102. echo "<meta http-equiv='refresh' content='1;url=$basename?action=$action&start=$lastid&s_c=$s_c'>";
  103. }else{
  104.         echo '批量替换字符[结束]';exit;
  105. }
  106. }
  108. function getdirname($path=null){
  109. if (!empty($path)) {
  110. if (strpos($path,'\\')!==false) {
  111. return substr($path,0,strrpos($path,'\\')).'/';
  112. } elseif (strpos($path,'/')!==false) {
  113. return substr($path,0,strrpos($path,'/')).'/';
  114. }
  115. }
  116. return './';
  117. }
  118. ?>
[url=http://www.phpwind.com]phpwind[/url]
回复
举报
离线太史慈
荣誉会员

发帖
766
金币
626
威望
556
只看该作者 沙发  发表于: 2011-11-15
如果嫌麻烦，也可以直接在require/bbscode.php
加一句
复制代码
  1.     $message = str_replace("data/attachment/album","attachment/photo",$message);
  2.     $message = str_replace("data/attachment/forum","attachment",$message);
[url=http://www.phpwind.com]phpwind[/url]
回复
举报
发帖 回复
返回列表
快速回复
限100 字节
如果您在写长篇帖子又不马上发表，建议存为草稿
 
提到某人：
选择好友
上一个 下一个