帝国CMS批量正文提取第一张图片为标题图片

wdzsjl 2周前 (01-01) 阅读数 58 #ASP

文章标签图片帝国的黎明图片帝国主义奴役这片东方图片帝王帝国图片帝国cms多图上传插件

新闻正文字段作为主表的情况

使用以下SQL语句：

update phome_ecms_news set titlepic = concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, 'src=', -1),'.gif',1),'"',''),'.gif') where newstext like '%.gif%' and titlepic=''; update phome_ecms_news set titlepic = concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, 'src=', -1),'.jpg',1),'"',''),'.jpg') where newstext like '%.jpg%' and titlepic=''; update phome_ecms_news set titlepic = concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, 'src=', -1),'.png',1),'"',''),'.png') where newstext like '%.png%' and titlepic='';

新闻正文字段作为副表的情况

使用以下SQL语句：

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, 'src=', -1),'.gif',1),'"',''),'.gif') where a.newstext like '%.gif%' and b.titlepic='' and a.id=b.id; update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, 'src=', -1),'.jpg',1),'"',''),'.jpg') where a.newstext like '%.jpg%' and b.titlepic='' and a.id=b.id; update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, 'src=', -1),'.png',1),'"',''),'.png') where a.newstext like '%.png%' and b.titlepic='' and a.id=b.id;

阅读全文

上一篇：帝国CMS批量提取新闻内容的第一张图片为标题图片的SQL语句下一篇：帝国CMS报错connect.php eval()'d code on line 1的解决办法