XF 2.2 Add a paragraph line, via phpmyadmin using bbcode

Miri

Active member
Hi.
With the search and replace function in phpmyadmin, I want to add a paragraph after a specific keyword.

This is a content that is repeated in some posts:

Code:
[url="http://wwww.domain.tld"]etiam sollicitudin...[/url] Praesent porttitor, nulla vitae posuere
now I want to immediately after
Code:
[/url]
and before
Code:
Praesent
insert a tag to wrap, in a new line.
It would be like the equivalent of <p> in html. I don't want a line break [br] but a new paragraph. How can I do?

immsql (2).png
immsql (1).png

Thanks
Miri
 

Miri

Active member
I read this post (I invite you to vote) by @adamgreenough, and I realized that XenForo doesn't use paragraphs but line breaks.
I currently have solved, with twice enter, from the keyboard, inside the SQL formula
SQL:
UPDATE `xf_post`
  SET `message` = replace (` message`, 'text test', 'text 

test')

Warning, this worked for me, but I don't know if it's the correct procedure.
 
Top