G'day people! :)
I'm running Co Authors Plus 2.6.1 and it works like a charm!
My site has many authors and I want to create a script that reminds them to update their old posts so that the site is not full of outdated info. Now, I have done this by digging into the MySQL database..
First I do a select authors:
SELECT * FROM wp_fraga_users ORDER BY display_name
Then within that loop I do a select posts and display how many months ago they were last edited:
SELECT post_category,post_title, ID, TIMESTAMPDIFF(MONTH, post_modified_gmt,NOW()) as 'last_edited', TIMESTAMPDIFF(MONTH, post_date_gmt,NOW()) as 'first_published' from wp_fraga_posts WHEREpost_status
= 'publish' ANDpost_type
= 'post' AND post_author='$id'
($id is the author's ID)
NOW... this only pulls up the posts that have no co-authors.. Any ideas of how to pull up also the posts that the people have co-authored? I can't actually figure out where/how the Co-Author plugin stores this info in the database.
Anyone knows how to do this? :)