IPB to SMF (HTML Post Conversion)

[TwinsX2Dad]

I have searched for awhile but have found no answers to this. If there is one, please tell me where it is.

I have an IPB 1.3 Final board and am trying to convert it to SMF (1.0.6 or the RC). I had to first go to SMF 1.0, then to the RC. All went well. My forums were converted, as well as posts and members. My problem is that I've had this board for years and have personally posted many articles in HTML. I know SMF will handle an admin doing HTML with the tags - I even tested a couple of threads with flash - but is there anyway to either drop the tag requirement or to automatically insert the tags in past posts?

I have probably 600-700 posts with HTML in them, above and beyond the basic HTML tags. Tables, some flash, etc. are all included. After the conversion, all of these posts show the HTML code and not the intended result.

Thanks in advance for any assistance.

[Oldiesmann]

Your first step should be to make sure you've got basic HTML enabled (admin -> Posts and Topics). That will take care of links, images, and basic text formatting tags (bold, underlined and italicized text). Replacing any additional HTML tags with bbcode shouldn't be too difficult, although it depends on whether or not MySQL lets you use wildcards in the replace statement (which I'm pretty sure it does).

[TwinsX2Dad]

It does, but I am uncertain as to whether or not all of the tags have BBCode equivalents. We're talking some pretty hard run HTML here.

[budzik]

I've got the same problem as Purple. I was converting from IPB 2.1.4 and everything is ok but this html in many posts. One thing more is that this html is not always good formated. I mean there are unclosed or inproperly opened tags... In original IPB board instead of html I had bbcode for images with thumbs (like hxxp:imageshack.us [nonactive] etc.)

[Oldiesmann]

Purple - if you can give me a list of the tags being used (along with any attributes, as needed), I should be able to tell you whether or not SMF has a bbcode tag that offers the same functionality, and also come up with some code to replace those tags as needed.

budzik - bad HTML makes things more difficult, especially when they don't close the HTML tags.

[budzik]

OK, I would like to try and change this kind of htmls:

Code Select Expand

<a href='http://img94.imageshack.us/my.php?image=foremniak1025sm.jpg' target='_blank'><img src='http://img94.imageshack.us/img94/6003/foremniak1025sm.th.jpg' border='0' alt='user posted image'></a>

to these bbcodes in my posts:

Code Select Expand

[URL=http://img94.imageshack.us/my.php?image=foremniak1025sm.jpg][IMG]http://img94.imageshack.us/img94/6003/foremniak1025sm.th.jpg[/IMG][/URL]

What kind of query sholud I use on my database?

[TwinsX2Dad]

Purple - if you can give me a list of the tags being used (along with any attributes, as needed), I should be able to tell you whether or not SMF has a bbcode tag that offers the same functionality, and also come up with some code to replace those tags as needed.

When I look at it all, there are tables, div tags, nearly everything - since IPB allows admins & others with permissions to use any HTML tags they want. You can literally create HTML pages with a WYSIWYG editor (like Dreamweaver or Frontpage) and transfer the HTML over - the result is the same as a regular Web page, but within the forum.

Over the years, I've allowed several people to post articles and such with HTML - and I am the worst offender. 

[TwinsX2Dad]

I have 477 posts in HTML. 65 with tables. Nearly all utilize closing tags.

[Oldiesmann]

OK, I would like to try and change this kind of htmls:

Code Select Expand

<a href='http://img94.imageshack.us/my.php?image=foremniak1025sm.jpg' target='_blank'><img src='http://img94.imageshack.us/img94/6003/foremniak1025sm.th.jpg' border='0' alt='user posted image'></a>

to these bbcodes in my posts:

Code Select Expand

[URL=http://img94.imageshack.us/my.php?image=foremniak1025sm.jpg][IMG]http://img94.imageshack.us/img94/6003/foremniak1025sm.th.jpg[/IMG][/URL]

What kind of query sholud I use on my database?

The IPB converter should handle those automatically (at least the IPB2 converter does). You need PHP to do that.

Purple - it's relatively easy to replace tables, but the problem comes with attributes. If it's just <table><tr><td> or they're all using the same attributes and same values for these attributes (and the attributes are listed in the same order), it's easy to convert those as well.