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

[Charlie Harvey]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

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,
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBCgAGBQJRm6JDAAoJEPytMqUZaqlzEhAP/jyEELuPIlo4zIj6SP+dMXmJ
fToOnigdmHS3Aqv9tbaV9cNJKXKFk2u+rjUj8ZnqJipOEMby75S0t+S/Xkcf5wEr
NUcJLEyXRhq1Q9mHWMzuPzJEn1fka0fGuC6KPSV3ubcyupkkoxK1eey/Iy5SisHe
k8uZT0cj7qTtQIQEf84AApZOIXl8mn2YkOAH1UEO2PTs+J70lnK9Y18mGWnJDA66
BiL/vyOAPK6iAaVeCEs8nYJftEdqSLMm9eNDED/afFBSVARPfCv0BH8DdutEOgsG
s5bCwbDowfbXpXp7kIMtSSpScTiUKDwQsqIxozsOhJsAMGhvL8my9S0KBajFtHhP
SKlfvBIDkU0x17I/xBzRmnahQ3g8JoDDu+vBYYfXRDvSh+mV7HTEozpAyZpLQUvU
NUAALjjyg+GRJkNuSOu2GjHKyhMWyVd2hEJ2fUw17TySDRRbHqKh+vk7O5o0sVZN
QLMviXZltK+v/4pMGZWyroHQswJ/BYuyZRa5bte83hAEnRJ2soD+U1rSLXbsDsof
Enxij5DWFJ/2qTq+q7IwwPEe8rxVSwSB6Ef+R6y/Zypq4D/YSF+W+oVHjpnDYWJK
SrTzLDMIjB/PMPnzKVtrl+hzzh9OwAJdBLaAnTiufvZje9vJUvt9fBArRMYAm3iT
pT/cEZt0Q5Oaa+fQtLS3
=d28f
-----END PGP SIGNATURE-----