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

[sam at bristolwireless.net]

I believe Bristol IMC are considering a move to Wordpress.

If you fancied a challenge there is only about 11 years worth of content..

Best

Sam


Quoting Mike Harris <mike at mbharris.co.uk>:

> 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
>
>
> _______________________________________________
> HacktionLab mailing list
> HacktionLab at lists.aktivix.org
> https://lists.aktivix.org/mailman/listinfo/hacktionlab