converting from mamboboard

[sibling chris]

am trying to convert from mamboboard 1.x and struggling a little bit

first off I can't find an exact converter as mamboboard is based on simpleboard I tried that converter and in the main it seems to have worked

however I have trouble with esacped characters

inpparticular in the mamboboard database if I have some quoted text it is stored in the db like this...

Code Select Expand

\"Whatever Text\"

after conversion it remins exactly the same but rather than SMF displaying "Whatever Text" it instead displays \"Whatever Text\"

can anyone advise on the best way to sort this out?

thanks
sc

[sibling chris]

applied this in phpmyadmin after conversion

Code Select Expand


UPDATE smf_messages SET body = REPLACE(body,"\\"",""");
UPDATE smf_messages SET subject = REPLACE(subject,"\\"",""");
UPDATE smf_messages SET body = REPLACE(body,"\\'","'");
UPDATE smf_messages SET subject = REPLACE(subject,"\\'","'");
UPDATE smf_messages SET body = REPLACE(body,"\\\"",""");
UPDATE smf_messages SET subject = REPLACE(subject,"\\\"",""");




not sure if this catches all the esacped characters and HTML characters in the messages after conversion but certainly it has sorted the ones I noticed