XF 1.3 SQL Query to convert permanent redirects to temporary redirects?

OperaManiac

Well-known member
#1
Just wanted to declutter the forum views by changing permanent redirects to 60 day redirects which should be enough time for search engines to update their databases. Thanks!
 

Chris D

XenForo developer
Staff member
#2
Code:
UPDATE xf_thread_redirect SET expiry_date = '1410862757' WHERE expiry_date = '0'
1410862757 is a timestamp that represents 16th September 2014, so roughly 60 days from now.

That will only change redirects that are currently permanent.
 

OperaManiac

Well-known member
#4
How do I edit the SQL command to run it for all redirections (temporary and permanent). I just need to remove the WHERE part?
 
Top