Hugo博客公告弹窗

苹果cms10后台更换图片地址和播放链接sql

   
文章摘要
摘要小助理今天溜号啦……😜

图片地址替换

https://xxx.com 为远程图片地址

UPDATE {pre}vod SET vod_pic=REPLACE(vod_pic, 'upload/vod', 'https://xxx.com')

播放地址替换

s1.bfengbf.com 是旧地址,c1.rrcdnbf1.com 是新地址

UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's1.bfengbf.com', 'c1.rrcdnbf1.com')
UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's2.bfengbf.com', 'c1.rrcdnbf2.com')
UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's3.bfengbf.com', 'c1.rrcdnbf3.com')
UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's4.bfengbf.com', 'c1.rrcdnbf4.com')
UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's5.bfengbf.com', 'c1.rrcdnbf5.com')
UPDATE {pre}vod SET vod_play_url=REPLACE(vod_play_url, 's6.bfengbf.com', 'c1.rrcdnbf6.com')
CC BY-NC-SA 4.0 转载请注明
最后更新于 2024-11-23 15:12
clarity统计