How to publish a post if condition is met?

Question

I’m trying to have my posts published when wp_posts.ID IN (list).
Is it advisable to do it with an event in MySQL/MariaDB?
Would it mess up the cache?
Is it enough to just do

SET
posts_status = 'publish'
WHERE
wp_posts.ID IN (list)

?
I found one answer that could be the solution here https://wordpress.stackexchange.com/a/313060/151436
but I’m not really sure how to implement it.

Also, it would be great if a solution had like a minute gap between publishing, so it doesn’t slow down the server.

Any help would be greatly apriciated!
Thank you

0
, inside83 2 years 2019-11-01T09:21:37-05:00 0 Answers 73 views 0

Leave an answer

Browse
Browse