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

[Mike Harris]

On 21/05/2013 17:59, sam at bristolwireless.net wrote:
>
> I believe Bristol IMC are considering a move to Wordpress.
>
> If you fancied a challenge there is only about 11 years worth of
> content..
erm... that's probably a bit OTT for a workshop... but Charlie did do a
proptype IMC in WP when we were considering options in Oxford a couple
of years back.... anyway surely Oscailt rocks doesn't it?
>
> 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
>
>
>
>
>
>
> _______________________________________________
> 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