Old HTML Posts

[yaashul]

I have many post in HTML like

Code: Select all

<img src="image url here" alt="alt text here">

How can I convert them into bbcode?

like

Code: Select all

[img]image code here[/img]

I know I need to run this command in my database

Code: Select all

update table_name set table_field = replace(table_field,'search_for_this','replace_with_this');

and then reparse bbocde.

But can you suggest my what exactly I should write to replace. I'm really confused on this.

[dcz]

Since the post test field is using BLOB type, I doubt that the query you proposed would work. Beside, it's kind of tricky to run such a query with many posts.

If you code a bit you could inspire from our phpbb_seo/sync_url.php script to loop through all posts and edit them, it's a very simple example on how to perform batch operation on a db using meta refresh to loop.

++