) question. I have solved most of the problems directly updating the database. My major concern is 301 redirects. The background is that we have implemented Pretty URLs which rewrites the URL in SMF. They way it does it is that it do not add any topic number. Also, looking on the Swedish Xenforo sites I got referenced it seems like the URL uses the Swedish characters åäö. 
So , my "final" ( I hope
As an example a topic, number 2243 would have the following URLs
SMF with Pretty URL: www.mysite.com/amne/rott-for-500-kr/
phpbb: www.mysite.com/viewtopic.php?f=8&t=2243
Xenforo: www.mysite.com/threads/rött-för-500-kr.2243/
The key is to use the topic number as the usage of local character for Xenforo URLs makes it virtually impossible to know how it will be constructed. What I do have is a table in mysql which links the topic number to the Pretty URL which basically would list (for the above example
Topic ID Pretty URL
2243 rott-for-500-kr
Would it be possible to use this table and build any logic in php or similar. We are talking about 3000 topics. I'm not in any way a programmer, hence my question.
Thx in advance for any help
PS. I'm planning to test all steps and will document exactly how I did a potential migration. Will post that here if we move and if there are interest for this type of experiences.
UPDATE mydbname.com.phpbb_posts
SET mydbname_com.phpbb_posts.post_text
= REPLACE (mydbname_com.phpbb_posts.post_text ,' ',' ')
WHERE mydbname_com.phpbb_posts.post_text like ' ;%';I have problems with the passwords moving from SMF via PHPbb to Xenforo and ideally I do not want people to have to change them. It seems like if I sign on to phpBB after migration from SMF but before importing the users to Xenforo password will work, otherwise not.
UPDATE xf_user_authenticate AS ua, smf_members AS m
SET ua.data = BINARY
CONCAT(
CONCAT(
CONCAT('a:3:{s:4:"hash";s:40:"', m.passwd),
CONCAT('";s:4:"name";s:', LENGTH(LOWER(m.member_name)), ':"', LOWER(m.member_name))
),
'";s:8:"hashFunc";s:4:"sha1";}'
),
ua.scheme_class = 'XenForo_Authentication_SMF'
WHERE ua.user_id = m.id_member
AND LENGTH(m.passwd) = 40;
UPDATE mydbname.com.phpbb_posts
SET mydbname_com.phpbb_posts.post_text
= REPLACE (mydbname_com.phpbb_posts.post_text ,' ',' ')
WHERE mydbname_com.phpbb_posts.post_text like ' ;%';UPDATE my_db_name.xf_post
SET my_db_name.xf_post.message
= REPLACE (my_db_name.xf_post.message ,' ',' ')
WHERE my_db_name.xf_post.message like '% %';UPDATE my_db_name.xf_conversation_message
SET my_db_name.xf_conversation_message.message
= REPLACE (my_db_name.xf_conversation_message.message ,' ',' ')
WHERE my_db_name.xf_conversation_message.message like '% %';
