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

Chromaniac

Well-known member
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!
 
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.
 
Back
Top Bottom