[HacktionLab] N23/Wordpress session: Wordpress themes and porting your site to Wordpress

[Mike Harris]

On 21/05/2013 17:35, Charlie Harvey wrote:
> On 21/05/13 16:29, Mike Harris wrote:
>
> -----------------8<---------------
> > Is anyone out there interested in this and do any of you have a suitable
> > site?
>
> Interested, but haven't a site...
>
> > Just to be contentious, I am considering using my own Drupal 6 site as
> > my demo of how to get off Drupal and onto Wordpress! :P
>
> I think you're crazy. Why not:
>
> INSERT INTO wordpress_db.wp_posts (
>  post_author,
>  post_date,
>  post_date_gmt,
>  post_modified,
>  post_modified_gmt,
>  post_content,
>  post_title,
>  post_excerpt,
>  post_name,
>  post_type
> )
>        SELECT users.name,
> FROM_UNIXTIME(node.created),
> FROM_UNIXTIME(node.created),
> FROM_UNIXTIME(node.changed),
> FROM_UNIXTIME(node.changed),
>               node_revisions.body,
>               node.title,
>               node_revisions.teaser,
>       CONCAT('node/', node.nid),
>               'post'
>          FROM drupal_db.node,
>               drupal_db.node_revisions,
>               drupal_db.users
>         WHERE node.type = 'blog_post'
>           AND node.nid = node_revisions.nid
>           AND node.uid = users.uid
> ;
>
> Cheers,
Nice, it'd get the content but not the Skin.  Does that SQL work then?

>
> _______________________________________________
> HacktionLab mailing list
> HacktionLab at lists.aktivix.org
> https://lists.aktivix.org/mailman/listinfo/hacktionlab

-- 
Mike Harris
w: http://mbharris.co.uk
t: +44 7811 671 893
0: http://mbharris.co.uk/keys/pgp.html