[@sbroways Participant 13 years, 10 months ago]

I’m really hoping someone can help me figure out some sql queries I would like to run (especially spwestwood). I have been working on migrating a forum for a number of days now and would love if I could get some help on this last piece. I started out with a Phorum > migrated to SMF > migrated to phpBB3 > migrated to bbPress. The first 3 conversions were all successful. I would stay with phpBB3 but even after I loaded WordPress I could not get all my PHP to work properly on the forum page and I really like the bbPress integration into WordPress. But, I have the same anonymous error on the majority of my posts (55k) because, I believe, these are actually anonymous users who were not required to sign-up in order to post. The problem seems to be that bbPress uses only an ‘id’ to attach the name of the poster to the post and phpBB3 uses a ‘username’ field that actually contains the name within the table. All of these unregistered users simply default to user id = anonymous (1998 in my case). Here’s my solution… only, I don’t really know how to implement it as I have limited mySQL experience.. so please bare with me as this is all theoretical and I have no idea if it will work… and how to write it out in sql commands.

Step 1: I want to take phpbb_posts.post_username and assign new users in wp_users for each unique user name (I want to avoid duplicates obviously!). I would like that user_name assigned to both wp_users.user_login and wp_users.display_name. Now I have user accounts for all these anonymous posters.

Step 2: Convert the date format in phpbb_posts.post_time from an integer to the ‘datetime’ php format using the from_unixtime sql command… or something. That way I can accurately match the date/time field in both databases since they currently use different encoding.

Step 3. When wp_posts.post_date = phpbb_posts.post_time match phpbb_posts.post_username to wp_users.user_login GET id and assign to wp_posts.post_author

Does this make any sense? Or am I completely off the ball here? THANK YOU SO MUCH for any help!!