帝国CMS批量设置正文第一张图片为缩略图方法

执行以下脚本的时候请 先备份数据库！文本存放的新闻正文字段不可用！

新闻正文字段作为主表的情况用以下语句：

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),'"',''),'.gif') 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='';

新闻正文字段作为副表的情况用以下语句：

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;