Creates a Generic WXR XML file of comments from the Comments Module of CMS Made Simple for importing into the disqus.com service. Includes exporting of comments found in the News module and Pages by default. Structured so comments attached to other CMSMS modules can be added as needed.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001651s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.087918s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001424s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003341s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001691s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006199s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001423s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005996s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024540s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001931s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 302610 [ RunTime:0.002132s ]