How to fix reference links!

[Goosemoose]

I am sure many of you have the same problem as me. Now that I only use the mambo bridge for smf, all the old references to posts link to the non-mambo site. Here is how you can fix all that!! You need to run this in phpmyadmin. This makes a change to many database entries, so please please make sure to do it carefully and BACKUP your db first! It changed around 1000 links for my board. Please note that you need to change.

****NOTE: If you don't know what you are doing, post what you think your sql statement would look like and give us a link to your mambo site, and your standalone forum and someone can double check it for you before you run it!!
smf_messages to reflect the prefix of your smf tables
www.yoursite.com to your website address
also check the /index.php?option=com_smf&Itemid=70&?topic= to see how mambo links to all of your posts. Mine is Itemid=70 but everyone's is probably different.
/mambo/ is the directory you have mambo in.

The format is:
UPDATE smf_messages SET `body` = replace(`body`,
"http://www.yoursite.com/forum/index.php?topic=",
"http://www.goosemoose.com/mambo/index.php?option=com_smf&Itemid=70&?topic=")

Here is how mine looks when all done. Note that I don't have a /mambo because I have mambo running in the root directory of my site, and I have rfc because that is the old name of my smf directory installation, and I have rfc_messages because that is the prefix for my smf tables.

UPDATE rfc_messages SET `body` = replace(`body`, "http://www.goosemoose.com/rfc/index.php?topic=", "http://www.goosemoose.com/index.php?option=com_smf&Itemid=70&?topic=")

[torkil]

Excellent and very useful post!

[Goosemoose]

Thanks! Glad you were able to understand it.

[Kindred]

thanks goosemoose...    I have added this information into the (sticky) combined readme post.