网站优化 2023-10-12

图片跳转头条真实地址伪静态规则，wordpress+wellcms伪静态

站长笔记：

图片跳转头条真实地址伪静态规则，
location /upload9/pgc-image/ {
rewrite ^/upload9/pgc-image/(.*)$ https://p3.toutiaoimg.com/pgc-image/$1~noop.image redirect;
}
2020年之后的新图
location /upload9/ {
rewrite ^/upload9/tos-cn-i-(.*)/(.*)$ https://p3.toutiaoimg.com/tos-cn-i-$1/$2~noop.image redirect;
}
不要用mysql命令去批量修改已经发过的，因为不止有p3，还有p26...，还有https://p3.toutiaoimg.com/[参数]~noop.image这种结构的

如要加上.jpg的后缀，规则如下
location ~ ^/upload/pgc-image/(.+).jpg$ {
return 301 https://p3.toutiaoimg.com/pgc-image/$1~noop.image;
}
示例：
http://www.ggplus.cn/wp-content/uploads/2023/10/1697094808-a23cf3369021b29.jpg
跳转到
https://p3.toutiaoimg.com/pgc-image/cc0b3df88f5249428940543ad4532104~noop.image

wordpress+wellcms伪静态

location /

{

try_files $uri $uri/ /index.php?$args;

}

rewrite /wp-admin$ $scheme://$host$uri/ permanent;

location /we/ {

if (!-e $request_filename) {

rewrite ^((.*)/) /we/index.php last;

}

大河插件自带配图，带的是 360buying的图片，使用以下跳转规则
location ~ ^/upload/14/(.+.jpg)$ {
return 301 https://img14.360buyimg.com/$1;
}
location ~ ^/upload/13/(.+.jpg)$ {
return 301 https://img13.360buyimg.com/$1;
}
location ~ ^/upload/12/(.+.jpg)$ {
return 301 https://img12.360buyimg.com/$1;
}
location ~ ^/upload/11/(.+.jpg)$ {
return 301 https://img11.360buyimg.com/$1;
}
location ~ ^/upload/10/(.+.jpg)$ {
return 301 https://img10.360buyimg.com/$1;
}

火车头替换：
2020之后
src="https://p3.toutiaoimg.com/tos-cn-i-[参数]/[参数]~noop.image">
src="/upload9/tos-cn-i-[参数1]/[参数2]">

src="https://p3.toutiaoimg.com/dfic-imagehandler/[参数]~noop.image">
src="/upload9/dfic-imagehandler/[参数1]">

老的图2020之前
src="https://p3.toutiaoimg.com/pgc-image/[参数]~noop.image">
src="/upload9/pgc-image/[参数1]">

火车头mysql
UPDATE Content SET [内容]=replace([内容],'https://p3.toutiaoimg.com/tos-cn-i-','/upload9/tos-cn-i-')
UPDATE Content SET [内容]=replace([内容],'~noop.image','')

WP数据库中替换：[参数]不变
update wpyst_posts SET post_content=REPLACE(REPLACE(post_content,'https://p3.toutiaoimg.com/tos-cn-i-', '/upload9/tos-cn-i-'), '~noop.image', '') WHERE post_content LIKE '%https://p3.toutiaoimg.com/tos-cn-i-%~noop.image%';

update wpyst_posts SET post_content=REPLACE(REPLACE(post_content,'https://p3.toutiaoimg.com/pgc-image/', '/upload9/pgc-image/'), '~noop.image', '') WHERE post_content LIKE '%https://p3.toutiaoimg.com/pgc-image/%~noop.image%';

update wpyst_posts SET post_content=REPLACE(REPLACE(post_content,'https://p3.toutiaoimg.com/dfic-imagehandler', '/upload9/dfic-imagehandler'), '~noop.image', '') WHERE post_content LIKE '%https://p3.toutiaoimg.com/dfic-imagehandler%~noop.image%';

update wpyst_posts SET post_content=REPLACE(post_content,'https://p3.toutiaoimg.com/dfic-imagehandler','/upload9/dfic-imagehandler')

zb
UPDATE zbp_post SET log_Content = REPLACE(REPLACE(log_Content, 'https://p3.toutiaoimg.com/tos-cn-i-', '/upload9/tos-cn-i-'), '~noop.image', '') WHERE log_Content LIKE '%https://p3.toutiaoimg.com/tos-cn-i-%~noop.image%';

UPDATE zbp_post SET log_Content = REPLACE(REPLACE(log_Content, 'https://p3.toutiaoimg.com/pgc-image/', '/upload9/pgc-image/'), '~noop.image', '') WHERE log_Content LIKE '%https://p3.toutiaoimg.com/pgc-image/%~noop.image%';

搜狗图跳转
location /upload01/ {
rewrite ^/upload01/(.*)$ https://i01piccdn.sogoucdn.com/$1 redirect;
}
location /upload02/ {
rewrite ^/upload02/(.*)$ https://i02piccdn.sogoucdn.com/$1 redirect;
}
location /upload03/ {
rewrite ^/upload03/(.*)$ https://i03piccdn.sogoucdn.com/$1 redirect;
}
location /upload04/ {
rewrite ^/upload04/(.*)$ https://i04piccdn.sogoucdn.com/$1 redirect;
}
火车头替换：
src="https://i02piccdn.sogoucdn.com/[参数]"
src="/upload02/[参数1]"

UPDATE Content SET [内容]=replace([内容],'https://i01piccdn.sogoucdn.com','/upload01');
UPDATE Content SET [内容]=replace([内容],'https://i02piccdn.sogoucdn.com','/upload02');
UPDATE Content SET [内容]=replace([内容],'https://i03piccdn.sogoucdn.com','/upload03');
UPDATE Content SET [内容]=replace([内容],'https://i04piccdn.sogoucdn.com','/upload04');
UPDATE Content SET [内容]=replace([内容],'：和总体上说：','');

update zbp_post SET log_Content=REPLACE(log_Content,'https://i01piccdn.sogoucdn.com','/upload01');
update zbp_post SET log_Content=REPLACE(log_Content,'https://i02piccdn.sogoucdn.com','/upload02');
update zbp_post SET log_Content=REPLACE(log_Content,'https://i03piccdn.sogoucdn.com','/upload03');
update zbp_post SET log_Content=REPLACE(log_Content,'https://i04piccdn.sogoucdn.com','/upload04');

wordpress主目录搬到子目录：多站点支持

新建子目录，将所有文件复制到子目录，数据库导出，然后导入新建的数据库，删除子目录wp-config文件，重新安装一下，myphpadmin中修改options，user等字段的网址加上子目录名称：比如everyteas.com/item

然后宝塔中修改网站配置文件中的伪静态，子目录的伪静态放到后面。

删除子目录中的user.ini文件,然后就可以正常登录后台，登录后修改固定链接。

修改图片文件路径：/wp-content/uploads/改为 /items/wp-content/uploads/

update wpteas_posts SET post_content=REPLACE(post_content,'/wp-content/uploads/','/items/wp-content/uploads/')

如果是做站点，安装后记得对比wp-config.php文件，开启多站点。

wp-config中的域名不要改。

wordpress主目录搬到子目录之后，主站安装在zblog，伪静态：

location / {

if (-f $request_filename/index.html){

rewrite (.*) $1/index.html break;

}

if (-f $request_filename/index.php){

rewrite (.*) $1/index.php;

}

if (!-f $request_filename){

rewrite (.*) /index.php;

}

location /items/ {

index index.html index.php;

if (-f $request_filename/index.html){

rewrite (.*) $1/index.html break;

}

if (-f $request_filename/index.php){

rewrite (.*) $1/index.php;

}

if (!-f $request_filename){

rewrite (.*) /items/index.php;

}

新的主站规则仅仅是两头多了一个 location / { } 包含语句

数据库触发器：阻止网站首页修改

IF (NEW.option_id IN (1,2,3,4,6)) THEN

SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Cannot update locked record';

END IF

update zbp_post SET log_Content=REPLACE(log_Content,'总之，','');
update zbp_post SET log_Content=REPLACE(log_Content,'总结，','');
update zbp_post SET log_Content=REPLACE(log_Content,'综上所述，','');
update zbp_post SET log_Content=REPLACE(log_Content,'结尾，','');
update zbp_post SET log_Content=REPLACE(log_Content,'小结，','');
update zbp_post SET log_Content=REPLACE(log_Content,'结论，','');
update zbp_post SET log_Content=REPLACE(log_Content,'结语，','');
update zbp_post SET log_Content=REPLACE(log_Content,'您，','你');
update zbp_post SET log_Content=REPLACE(log_Content,'首先，','');
update zbp_post SET log_Content=REPLACE(log_Content,'其次，','');
update zbp_post SET log_Content=REPLACE(log_Content,'再次，','');
update zbp_post SET log_Content=REPLACE(log_Content,'此外，','');
update zbp_post SET log_Content=REPLACE(log_Content,'最后，','');

update zbp_post SET log_Content=REPLACE(log_Content,'长句提取：','');
update zbp_post SET log_Content=REPLACE(log_Content,'复合句提取：','');
update zbp_post SET log_Content=REPLACE(log_Content,'长句示例：','');
update zbp_post SET log_Content=REPLACE(log_Content,'复合句示例：','');
update zbp_post SET log_Content=REPLACE(log_Content,'长句：','');
update zbp_post SET log_Content=REPLACE(log_Content,'长句或复合句：','');
update zbp_post SET log_Content=REPLACE(log_Content,'（h2标签）','');

ZBlog文章批量修改分类目录
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%狗%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%拉布拉多%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%金毛%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%比特%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%犬%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%牧羊%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%寻回%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%哈士奇%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%二哈%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%波士顿梗%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%贵宾%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%柯基%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%西施%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%斗牛%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%博美%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%藏獒%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%阿拉%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%吉娃娃%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%牛头梗%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%金毛%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%泰迪%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%茶杯%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%可卡%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%大麦%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%雪纳瑞%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%西高地%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%萨摩耶%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%杜宾%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%贝吉格里芬梗%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%罗威纳%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%约克夏%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '2') WHERE log_Content LIKE '%边牧%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%猫%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%暹罗%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%短毛%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%缅因%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%挪威森林%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%俄罗斯蓝%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%布偶%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%孟加拉豹%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%埃及%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%阿比西尼亚%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%斯芬克斯%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%土耳其安哥拉%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%短尾%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%奥西%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%短脚%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%卷毛%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%科尼希%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%喜马拉雅%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '3') WHERE log_Content LIKE '%狸花%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '5') WHERE log_Content LIKE '%鸟%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '4') WHERE log_Title LIKE '%鸟%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '5') WHERE log_Content LIKE '%养鱼%'AND log_CateID = '1';
UPDATE zbp_post SET log_CateID = REPLACE(log_CateID, '1', '5') WHERE log_Title LIKE '%鱼%'AND log_CateID = '1';

zblog

由于网站搬家，部分链接失效，如无法下载，请联系站长！谢谢支持！
1. 带 [亲测] 说明源码已经被站长亲测过!
2. 下载后的源码请在24小时内删除,仅供学习用途！
3. 分享目的仅供大家学习和交流，请不要用于商业用途！
4. 本站资源售价只是赞助，收取费用仅维持本站的日常运营所需！
5. 本站所有资源来源于站长上传和网络，如有侵权请邮件联系站长！
6. 没带 [亲测] 代表站长时间紧促,站长会保持每天更新 [亲测] 源码 !
7. 盗版ripro用户购买ripro美化无担保,若设置不成功/不生效我们不支持退款!
8. 本站提供的源码、模板、插件等等其他资源，都不包含技术服务请大家谅解！
9. 如果你也有好源码或者教程，可以到审核区发布，分享有金币奖励和额外收入!
10.如果您购买了某个产品，而我们还没来得及更新，请联系站长或留言催更，谢谢理解 !
GG资源网 » 图片跳转头条真实地址伪静态规则，wordpress+wellcms伪静态

分享到：