Removing HTML Code From Posts

[ConqSoft]

I converted my site from IkonBoard a while back, and all the old posts are full of HTML formatting code that was imported. I have HTML turned off on VB, so of course, the messages show up with all this ugly HTML code in them. Is there an easy way I can strip all that out?

Thanks.

Example Thread: http://www.fireblades.org/forums/showthread.php?t=6708

[NTLDR]

There are a few options to this I guess. Assuming the HTML is pretty much the same in alot of posts, for example HTML for a quote box, you could use vB replacements to just hide it.

Alternativly you'd need a script to run through and grab each post, either strip all HTML or try and convert it to vBcode and then update the database. Going on your 97k posts this would take a while todo as you'd have to have around the same number of queries to perform the operation.

[Xenon]

or you can try this way:
open includes/functions_bbcodeparse.php

find

PHP Code:

// ###################### Start bbcodeparse2 #######################
function parse_bbcode2($bbcode, $dohtml, $dobbimagecode, $dosmilies, $dobbcode, $iswysiwyg = 0, $donl2br = 1)
{
// parses text for vB code, smilies and censoring

    global $DB_site, $vboptions, $bbuserinfo, $templatecache, $smiliecache;
    global $html_allowed; 


and below add:

PHP Code:

$bbcode = strip_tags($bbcode); 


[ConqSoft]

Thanks.

Just tried that, but nothing changed.

[Xenon]

hmm, that should work normally...

well i don't beleive it, but maybe try this:

PHP Code:

$bbcode = strip_tags(unhtmlspecialchars($bbcode)); 


[ConqSoft]

Nope. Same.

[Xenon]

are you sure you have not enabled post caching?
if you have it enabled, you won't see fresh parsed posts

[ConqSoft]

Ooops.

Yep, post caching is enabled.

[Andreas]

I'd close the board and run an update-script to strip all HTML.
Seems to be the better solution to do this one-time and not "on the fly" all the time.

[ConqSoft]

Originally Posted by KirbyDE

I'd close the board and run an update-script to strip all HTML.
Seems to be the better solution to do this one-time and not "on the fly" all the time.

Sounds good to me? So where's that update script buddy?