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

XF 1.3 Database Query Needed

wickedstangs

Well-known member
#1
Did the SMF to Xenforo move and need a database query for Images..

All the images moved with [img width=449 height=480] and need it to be
Code:
[img]
 

wickedstangs

Well-known member
#2
Would it be something like this????
Code:
UPDATE my_db_name.xf_post
SET my_db_name.xf_post.message
= REPLACE (my_db_name.xf_post.message ,'[imgXXXXX]',' ')
WHERE my_db_name.xf_post.message like '[img]';
 

borbole

Well-known member
#4
Would it be something like this????
Code:
UPDATE my_db_name.xf_post
SET my_db_name.xf_post.message
= REPLACE (my_db_name.xf_post.message ,'[imgXXXXX]',' ')
WHERE my_db_name.xf_post.message like '[img]';
It would be best to use the mod linked by Andy above. But if you would rather run the query, try this:

Code:
UPDATE xf_post
SET message = REPLACE(message,'[img width=449 height=480]','[img]');