XF 2.1 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:

[MENTION=123]Scandal[/MENTION]

This is very close to the xF2 one:

[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 idea? Can someone improve the queries?

UPDATE `xf_post` SET `message` = replace(message, '[MENTION=', '[USER=')
UPDATE `xf_post` SET `message` = replace(message, '[/MENTION]', '[/USER]')

Thanks

 

[Paul B]

You will need to use this add-on and regex: https://xenforo.com/community/resources/post-content-find-replace.5748/

 

[Scandal]

I'm not familiar with regular expressions
Maybe any idea to make it via an sql query like the pre-noticed queries?

 

[djbaxter]

Could this be done using this? Any downsides?

AdminCP >> Setup >> Options >> Censoring

Word or phrase: [MENTION=
Replacement: [USER=

and

Word or phrase: [/MENTION]
Replacement: [/USER]

 

[Scandal]

My issue is the missing "@". I have already achieve via my queries to replace the main bbcode tag

 

[djbaxter]

I'd still like to have my question above answered but whether or not the @ is displayed is a setting in XF2:

AdminCP >> Setup >> Options >> User alerts and notifications

At the bottom of that page, check or uncheck this option:

Keep @ character with user mentions
The @ character is used to initiate user mentions. If this option is disabled, successful user mentions will remove this character.

 

[Scandal]

wow thanks, I didn't know that this option was exists on the control panel
But I like the @ on every mention, for this reason I still asking for a solution. Is there any kind of query that can make the replaces like:

replace(message, '[MENTION={variable_part}]', '[USER={variable_part}]@')

We're talking about an importer xF2 board from vBulletin. Currently I'm working on localhost / testing boards. Any suggestion is welcomed.

 

[djbaxter]

That setting should do it once you've converted to the Xenforo bbcode.

 

[Scandal]

I have as default checked the "Keep @ character with user mentions" which is what I need.
But as I can see on older posts of the imported board, the mentions still not have an "@". I think that this setting you noticed is for the "from now and then" posts.

I tried to uncheck the above setting but still not achieve what I need. I need the "@" in all user mentions, even if that was on an old post (imported from vBulletin database).

 

[djbaxter]

You could try my suggested method above if you've already converted to the XF bbcode:

Word or phrase: [USER=
Replacement: @[USER=

 

[Scandal]

hmm, no, as I can see, the normalized way xF2 is applying the mentions is this:

[USER=8002]@Scandal[/USER]

The @ should be inside the bbcode. Sorry, I need it very clearly and normal.

 

[djbaxter]

OK. I'm out of ideas then.

 

[jdeg]

You will need to use this add-on and regex: https://xenforo.com/community/resources/post-content-find-replace.5748/

For anyone getting to this page in the future, here is the regex you can use:

^(\[MENTION=)([\d]+)(\])([\w]+)(\[\/MENTION\])/

Replacement:

[USER=$2]@$4[/USER]

 

[MentaL]

For anyone getting to this page in the future, here is the regex you can use:

^(\[MENTION=)([\d]+)(\])([\w]+)(\[\/MENTION\])/

Replacement:

[USER=$2]@$4[/USER]

You'll get a delimiter error... correct regex for those like me;

Quick find:

[MENTION

Regular expression:

/^(\[MENTION=)([\d]+)(\])([\w]+)(\[\/MENTION\])/

Replacement string:

[USER=$2]@$4[/USER]

Enjoy.

 

[MentaL]

You'll get a delimiter error... correct regex for those like me;

Quick find:

[MENTION

Regular expression:

/^(\[MENTION=)([\d]+)(\])([\w]+)(\[\/MENTION\])/

Replacement string:

[USER=$2]@$4[/USER]

Enjoy.

For those with weird ascii character name tags, use this for the Regular expression:

/^(\[MENTION=)([\d]+)(\])([\W]+)(\[\/MENTION\])/