Ques/Help Switch from dbtech [MENTION] bbcode (vBulletin) to [USER] xF2 - A simple query modify

[Scandal]

I'm working the migration of my sites from vBulletin 3 to XenForo 2.1

I have stuck on this issue. On my vBulletin board we ran dbtech user tagging.
That system has the following own bbcode format:
Code:

[MENTION=123]Scandal[/MENTION]

This is very close to the xF2 one:
Code:

[USER=123]@Scandal[/USER]

... with the difference an "@" symbol.

So I want to update all my forum's posts to be normalized with the xF2 one.

The following queries are working, but I don't know how to apply the "@" inside the username. Any...

Read more

Continue reading...