帝国一键快速刷新文章时间。与定义表的ID号帝国cms

帝国论坛 → 帝国网站管理系统交流区 → 帝国CMS使用交流 → 帝国一键快速刷新文章时间。与定义表的ID号

【本版专题贴子】

jzjit
用户头衔：举人

精华贴   ：0
发贴数   ：157
经验值   ：1204
注册时间：2009-07-09

信息

搜索

好友

发送悄悄话

【精益求精－帝国网站管理系统7.5正式版开源发布】 [第 1 楼]

帝国一键快速刷新文章时间。与定义表的ID号

帝国一键快速刷新文章时间。与定义表的ID号
帝国一键快速刷新文章时间。

update phome_ecms_news set newstime='1412787730';
update phome_ecms_info set newstime='1412787730';
update phome_ecms_shop set newstime='1412787730';
update phome_ecms_movie set newstime='1412787730';
update phome_ecms_flash set newstime='1412787730';
update phome_ecms_photo set newstime='1412787730';
update phome_ecms_download set newstime='1412787730';
update phome_ecms_article set newstime='1412787730';

update phome_ecms_news set truetime='1412787730';
update phome_ecms_info set truetime='1412787730';
update phome_ecms_shop set truetime='1412787730';
update phome_ecms_movie set truetime='1412787730';
update phome_ecms_flash set truetime='1412787730';
update phome_ecms_photo set truetime='1412787730';
update phome_ecms_download set truetime='1412787730';
update phome_ecms_article set truetime='1412787730';

update phome_ecms_news set lastdotime='1412787730';
update phome_ecms_info set lastdotime='1412787730';
update phome_ecms_shop set lastdotime='1412787730';
update phome_ecms_movie set lastdotime='1412787730';
update phome_ecms_flash set lastdotime='1412787730';
update phome_ecms_photo set lastdotime='1412787730';
update phome_ecms_download set lastdotime='1412787730';
update phome_ecms_article set lastdotime='1412787730';

所有发布时间就变为了：2014-10-09 23:13:19

定义表的ID号：

ALTER TABLE phome_enewsdolog AUTO_INCREMENT=1

（将表phome_enewsdolog 中的AUTO_INCREMENT 值设为1）