Home

Drupal to Textpattern · Saturday September 30, 2006 by jauzsi

insert into txp_textpattern (Posted, AuthorID, LastMod, Title, 
Annotate, Status, textile_body, textile_excerpt, Section, url_title, 
Body_html) select FROM_UNIXTIME(node.created) as 'Posted', 
users.name, FROM_UNIXTIME(node.changed) as 'LastMod', node.title
 as 'Title', '0' as Annotate, '4' as Status, '0' as textile_body, '0' as 
textile_excerpt, 'article' as Section, REPLACE(node.title,' ','-') as 
urltitle, node.body as Body_html FROM node,users  WHERE 
node.uid=users.uid and node.type='story';