数码荔枝 正版Mac软件 618大促销 送5元优惠券

Xenforo批量替换文件方法

本帖由 Bill2012-02-13 发布。版面名称:谈天说地

  1. Bill

    Bill 老牛 管理成员

    注册:
    2010-11-01
    帖子:
    6,620
    进入phpMyAdmin

    运行

    请修改"原内容"和"替换为"为合适的内容
     
  2. Bill

    Bill 老牛 管理成员

    注册:
    2010-11-01
    帖子:
    6,620
    代码:
    UPDATE xf_post SET message = REPLACE(message, 'http://img.applex.net/images/','https://s1.ax1x.com/data/applex/')
    UPDATE xf_post SET message = REPLACE(message, 'http://www.applex.net/','https://www.applex.net/')
    
    UPDATE xf_resource_update SET message = REPLACE(message, 'http://img.applex.net/images/','https://s1.ax1x.com/data/applex/')
    
    UPDATE xf_resource_update SET message = REPLACE(message, 'http://www.applex.net/','https://www.applex.net/')
    UPDATE xf_edit_history SET old_text = REPLACE(old_text, 'http://www.applex.net/','https://www.applex.net/')
    UPDATE xf_template_compiled SET template_compiled = REPLACE(template_compiled, 'http://www.applex.net/','https://www.applex.net/')
    
    UPDATE xf_resource SET external_url = REPLACE(external_url, 'http://img.applex.net/images/','https://s1.ax1x.com/data/applex/')
    
     
  3. Bill

    Bill 老牛 管理成员

    注册:
    2010-11-01
    帖子:
    6,620
    代码:
    UPDATE xf_post SET message = REPLACE(message, 'https://www.nas2x.com/img/images/','https://www.nas2x.com/data/images/')
    UPDATE xf_resource_update SET message = REPLACE(message, 'http://www.nas2x.com/','https://www.nas2x.com/')
    UPDATE xf_resource SET external_url = REPLACE(external_url, 'https://www.nas2x.com/img/images/','https://www.nas2x.com/data/images/')
    UPDATE xf_edit_history SET old_text = REPLACE(old_text, 'https://www.nas2x.com/img/images/','https://www.nas2x.com/data/images/')
    UPDATE xf_search_index SET message = REPLACE(message, 'http://www.nas2x.com/','https://www.nas2x.com/')



    代码:
    UPDATE xf_post SET message = REPLACE(message, 'http://down.applex.net','http://s1.applex.net')
    UPDATE xf_resource_update SET message = REPLACE(message, 'http://down.applex.net','http://s1.applex.net')
    UPDATE xf_resource_version SET download_url= REPLACE(download_url, 'http://down.applex.net','http://s1.applex.net')
     
    最后编辑: 2017-12-16
  4. Bill

    Bill 老牛 管理成员

    注册:
    2010-11-01
    帖子:
    6,620
    代码:
    UPDATE xf_post SET message = REPLACE(message, 'http://d11.applex.net','http://s1.applex.net')
    
    UPDATE xf_resource_update SET message = REPLACE(message, 'http://d11.applex.net','http://s1.applex.net')
    
    UPDATE xf_resource_version SET download_url= REPLACE(download_url, 'http://d11.applex.net','http://s1.applex.net')