In finally(!) migrating from IPB 1.3.1 to 2.1.7, there's quite a few things I have to manually change around. One of them is the emoticons; I used to implement two different emoticon sets manually, whereas now that IPB allows this per-skin, I can do it based on skin choice.

So, I would like to get rid of the user profile field for the emoticon set, but I also need to make a few database changes.

So first of all:

I have a lot of posts with contents like this (in the posts table's post column):


Which should now look like this:


A select query will return results:


will give me 25.

But an update query like this:


will just give me "Query OK, 0 rows affected", leading me to believe that it failed to retrieve any matching rows and thus didn't even try to do any replacements. I'm assuming I need to escape some of the first argument's value, but how/what?

Any help greatly appreciated.

Why not just do this:

update ibf_posts set post=replace(post, 'emoteURL/', 'style_emoticons/<#EMO_DIR#>/')

OR, even better, just run the rebuild post content tool in the ACP, which will unparse and then reparse emoticons

I guess I'm afraid it'll affect some unrelated posts.



But won't that also unparse and reparse tags? (Many of which were custom and implemented differently, so it probably won't recognize them and will balk.)

I'll backup and try. Thanks

It's unlikely it'll effect anything other than emoticons; I'd try the query Brandon posted after backing up.