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

Help with SQL query after SMF > XF import

#1
I recently converted my forum from SMF to XF.
Could someone please help me wit an SQL command that can do this in the xf_posts table?

replace
"domain.com/forum1/index.php?action=dlattach;topic=*;attach=#" with "domain.com/forum2/attachments/#/

for example:
domain.com/forum1/index.php?action=dlattach;topic=56382.0;attach=17975"