Hello, I succesfully converted a phpBB Forum into SMF 1.0.5, and because of the different URL scheme this makes all links embedded into posts linking between different topics broken. I have partially fixed it now, needing help on a last issue.
I changed to a new domain, too, so I first ran the following SQL query to convert all links to the new domain:
UPDATE smf_messages SET body = REPLACE(body, 'www.olddomain.com/forum', 'forum.newdomain.com');
phpBB uses a URL scheme like viewtopic.php?=topicid while SMFs is like index.php?topic=topicid, so I used:
UPDATE smf_messages SET body = REPLACE(body, 'forum.newdomain.com/viewtopic.php?t=', 'forum.newdomain.com/index.php?topic=');
Additionally I left a php script at the original location which redirects the browser to the new domain and correct topic in case someone follows an external, outdated link.
The remaining problem is that in phpBB you can have links pointing to specific posts only, (viewtopic.php?p=2345), but SMF requires the link to contain topicid + postid (index.php?topic=123.msg2345#msg2345), so I cannot convert them with a (simple) query/script. A conversion script would need to do a DB lookup to check to which topicid a certain postid belongs to and add the missing ?topic=topicid to the URL string.
Any suggestions?
Thanx in advance.