WP SEO Redirection Free plugin trick

[nickmind]

Its a very useful tool for Seo and can prevent from hacking attacs your WP site. I have create a mysql query and assigned to table wp_WP_SEO_Redirection_LOG as an insert trigger to table wp_WP_SEO_Redirection. I have done this to do not manually assign a lot of logged urls to redirect and have them there.

Any way, the query as a trigger is

Code:

INSERT INTO wp_WP_SEO_Redirection ( enabled, redirect_from, redirect_from_type, redirect_from_folder_settings, redirect_from_subfolders, redirect_to, redirect_to_type, redirect_to_folder_settings, redirect_type )
SELECT DISTINCT 1 AS  enabled, rfrom, "Page" AS redirect_from_type, 0 AS redirect_from_folder_settings, 0 AS redirect_from_subfolders, rto, "Page" AS redirect_to_type, 0 AS redirect_to_folder_settings, "301" AS redirect_type
FROM wp_WP_SEO_Redirection_LOG
WHERE rfrom not in (Select redirect_from from wp_WP_SEO_Redirection)

Cheers

[nickmind]

A moderator can clean it up I can not edit. Thanks