Code in posts?

[Sexy Sarah]

Hi all,

when I read the forums, many posts don’t display the code for me – they look something like

That still didn't work for me  ;D

It makes the forums very hard to read for me, since it’s so many posts. Is there something I can do to view the forums in another way?

[admin]

Unfortunately there is nothing you can do to see them differently. The posts that show the html mark up are old posts that were migrated over when we changed the forum script. Since the html markup of the old posts is embedded in the database as text, the only thing that can be done to fix it is to edit each post. The problem is that there are about 19,000 posts that would need to be edited.

[Mr E]

Hi Admin. Regarding the markup in the old posts… would it be possible to do an SQL Update search changing all the old markup to the new? Either running it directly from phpMyAdmin or by writing a simple php script?

[admin]

Mr. E,

I did see you mention this before and forgot to reply. There are a couple of problems. The amount of text data in the 19,000 posts is huge. PhpMyAdmin borks or truncates the file even when I just attempt to export or modify the forum messages table. Running something inside there would probably crash the database server or make a mess of the data.

The other alternative is to export portions of it at a time and do a search and replace of certain text and then import the fixed data. Since it is text data the problem is having a search and replace script recognize which characters are html code to be removed, and which should be left intact. I could go for string searches but that would still likely grab some things I don’t want it to.

We could just delete posts over a certain age, but I think there is much in old posts that is still valuable. I’m always open to ideas. If you have something in mind I’m not seeing, please don’t hesitate to let me know. I’d love to find an easy or automated method to clean those old posts up.

– PK

[Mr E]

Admin… I’d be more than happy to help try and find a solution to this problem… I’ll PM you.

[jazzy]

I know that the old posts are sometimes difficult to read but as i know most of the writers past and present i still enjoy looking back at the old posts and seeing some of our past members names does bring back fond memories,also it may help new members with ideas for new posts.Just an old fool i suppose but we are all different in our own way.
Does anyone else look back? just wondered.!!!!!!!

🙂 Jazzy:)

[Anna]

Here you go people, we can all give Mr E some serious karma now.

Me first 🙂

[Desire]

done!!:cheer: :cheer: :cheer:

thanks mr E

love,
sam xx

[FetishKitten]

Thanks Anna 🙂
I’ll have to come back in 4 hours, you can only give Karma once every 6 hours and I did one earlier today!

[Author]

Posts