I have had wordpress and gallery on my blog for a long time now, and it has just been becoming more and more complex. I discovered ZenPhoto by accident and it's simplicity itself, I love it! Especially with the ZenPage plugin.
I wanted to bring my wordpress posts and comments over but I couldn't find anything to do that, so I wrote a couple of crude SQL export commands that allowed me to export the wp_comments and wp_posts in the format of ZenPhoto database, and directly import them. I thought I'd share them in case others where trying to do the same. Sorry if they are a bit basic but they worked for me
Keep up the great work guys!
== Posts ==
SELECT
ID,
post_title as title,
post_content as content,
"" as extracontent,
1 as show,
post_date as date,
post_name as titlelink,
1 as commentson,
"a:3:{i:1;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";}" as codeblock,
"minch" as author,
NULL as lastchange,
"" as lastchangeauthor,
0 as hitcounter,
1 as permalink,
0 as locked,
NULL as expiredate,
0 as total_votes,
0 as total_value,
0 as rating,
NULL as used_ips,
3 as rating_status
FROM wp_posts
WHERE post_status = "publish"
ORDER BY wp_posts.ID ASC
== Comments ==
SELECT
comment_ID as id,
comment_post_ID as ownerid,
comment_author as name,
comment_author_email as email,
comment_author_url as website,
comment_date as date,
comment_content as comment,
0 as inmoderation,
'news' as type,
comment_author_IP as IP,
0 as private,
0 as anon,
NULL as custom_data
FROM wp_comments
ORDER BY wp_comments.comment_ID ASC
