7
Quote:
panigrc wrote:
Thank you mikhail it was easier than I thought! 
Great that you understood the logic of this code!! You dont need more than it to convert a CMS like phpnuke to xoops, without php. Another sample, to convert the XOOPS news to weblog mod (should work):
replace INTO
xoops_weblog (blog_id, user_id, cat_id, created, title, contents, trackbacks)
SELECT storyid, uid, topicid, created, title, hometext, bodytext
FROM xoops_stories
And you can define a default value, like this 2 examples:
Quote:
xoops_weblog (blog_id, 1243, cat_id, created, "Xoops Rulez", contents, trackbacks)
so, the same value 1243 and XOOPS rulez for all lines.
