XF 1.3 Database Query Needed

wickedstangs

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

All the images moved with
CODE]
 
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]';
 
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]');
 
Top Bottom