• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

HTML markup importing

#1
I am trying to import some HTML from another forum, however linebreaks and paragraphs are being rendered as code on the page - ie showing <p> and <br /> tags. Is there a way to convert these?

I took a look at the text inserted into the message field of the xf_post table but I cant figure out what character(s) are used to denote line breaks...

Also, the post_date field in xf_post - is this in ticks?

Thanks
 

Jake Bunce

XenForo moderator
Staff member
#2
I am trying to import some HTML from another forum, however linebreaks and paragraphs are being rendered as code on the page - ie showing <p> and <br /> tags. Is there a way to convert these?
You can install this addon to cleanup imported posts:

http://xenforo.com/community/threads/post-content-find-replace.6548/

This requires some regex ability though.

Also, the post_date field in xf_post - is this in ticks?
It's a unix timestamp:

http://en.wikipedia.org/wiki/Unix_time
 
#5
Thanks, but that looks a little scary allowing any html tags between [parsehtml] - I just needed to do this once on the import. A solution seems to be to render the html before running the sql insert - this scrubs tags like <em> but at least removes them and <p> and <br> tags work out fine.