網站優化 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偽靜態

分享到：