{"id":904054,"date":"2008-11-17T17:15:39","date_gmt":"2008-11-17T17:15:39","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/plugin-yet-another-related-posts-plugin-post_body_keywords-and-strip_tags\/"},"modified":"2016-08-19T02:45:09","modified_gmt":"2016-08-19T02:45:09","slug":"plugin-yet-another-related-posts-plugin-post_body_keywords-and-strip_tags","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/plugin-yet-another-related-posts-plugin-post_body_keywords-and-strip_tags\/","title":{"rendered":"[Plugin: Yet Another Related Posts Plugin] post_body_keywords and strip_tags"},"content":{"rendered":"

A client of ours is using this plugin on a WP site that has a good deal of embeds (youtube). The post_body_keywords function in keywords.php doesn’t strip_tags and was causing queries like this…<\/p>\n

SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('param hl 0xcfcfcf 0xb1b1b1 color1 color2 en embed true center fs v allowfullscreen height 0 1 width object com value'))<\/code><\/p>\n

Changing<\/p>\n

return yarpp_extract_keywords($post->post_content);<\/code><\/p>\n

to<\/p>\n

return yarpp_extract_keywords(strip_tags($post->post_content));<\/code><\/p>\n

helped reduce mysql usage quite a bit.<\/p>\n

thanks!<\/p>\n","protected":false},"template":"","class_list":["post-904054","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/904054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/904054\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=904054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}