Get current user, change users post status to published

The database holds several rows for each attribute of a post. All except on row should have status inherit. So I just hope the post_id is correct.

Anyway, yes you are correct to assume that it is similar:

$query = array(
  'ID' => $post_id,
  'post_status' => 'publish',
);
wp_update_post( $query, true );

Oh and 

add_action('publish_post'...

adds the check when the post is being published (so no need to check once a day).

Related Posts:

  1. Random sort within an already sorted query
  2. Displaying the category name of a custom post type
  3. Search by Hyphen
  4. Exclude drafts in all() view of edit.php
  5. Exclude posts that only have the ‘Uncategorized’ category [duplicate]
  6. How do I reorder (pop and push) items from WP_Query?
  7. How to exclude latest x posts from a paginated query?
  8. Reverse chronology of post listing
  9. WP_Query to work with custom view
  10. WordPress Number of Posts Not Changing With posts_per_page
  11. How to add posts to wp_query result?
  12. Posts for next month
  13. Exclude posts with specific meta_value while sorting by a separate meta_value
  14. WP_Query only ONE post, won’t work
  15. Unable to modify(update) posts – Page not found
  16. Display the latest posts, published in the last hour, with WP_Query
  17. Replace Main Query With Custom Query
  18. Fetch posts from current week (Sunday to Saturday)
  19. Hiding posts in a list from specified categories
  20. Converting multiple loops into one single loop with pagination
  21. Group posts by year in loop
  22. How would I get 1 latest post from a query for 5 posts?
  23. How to get posts by multiple post slugs? [duplicate]
  24. WP_Query do not load specifed number of post
  25. WP_Query: offset ignored when posts_per_page is -1?
  26. Exclude posts with empty post_content in wp_query
  27. Exclude posts from featuring
  28. Lazy Load using WP_Query pagination
  29. AJAX filter posts by year
  30. How can I remove posts of a certain category from homepage after a specified time period?
  31. Should $found_posts be returned as string in ‘found_posts’ filter hook?
  32. Get random posts between specific dates / of specific age
  33. Yearly archive page for future year
  34. Display post from current category and same tag?
  35. Ajax load more button in Recent posts widget
  36. WP_Query orderby not working with meta_value_num and menu_order
  37. Custom WP_Query with complex ‘post_status’ argument
  38. is there a way to show the the post title after the image?
  39. How do I correctly set up a WP-Query to only show upcoming event-posts?
  40. Blog post per page setting conflicting with custom WP_Query?
  41. How to filter my search in post if contains a word in title, content or excerpt?
  42. How to return another post than requested
  43. Select only post id and meta value with WP_Query
  44. Random ajax load only works with posts_per_page set to -1
  45. Query posts and return XML
  46. Query Posts With Over 1000 Views
  47. Adding a blog archive with pagination using WP_Query
  48. How to get Tags with specific post id
  49. How do I extract just the post ID of the first item in whatever WP_Query returns?
  50. Show post content and title in diferent divs using WP_Query using a loop
  51. Show posts by author of membership level (Paid Membership Pro)
  52. Why posts array is empty?
  53. Page and post loop same template
  54. How to check in functions.php if there is data in a WP_Query?
  55. Show metabox value last post excerpt, title and link
  56. How can I insert a new markup element after 4 posts automatically? [closed]
  57. If no posts exist for current day and month, show the next available day of posts
  58. Related Posts function not working
  59. how to handle the loop using filling bootstrap grid structure?
  60. Query function not executed between element [closed]
  61. Custom WP_Query not working correctly
  62. Echo the number of posts being displayed
  63. Creating a related posts section in wordpress inside a default post
  64. How to display WP Query filters?
  65. Finding a post’s slug
  66. Is there a function to get post info for any publish_status by post ID?
  67. How Can I Always Display A Particular Post First Using WP_Query?
  68. Optimal WP Web App Backend for mobile app development
  69. How do I display main query posts in random order using add_filter
  70. Why sorting posts doesn’t work properly?
  71. the wp_post_update isn’t working all the time
  72. Display specific posts based on an ID of another post
  73. query posts with selected post ids first
  74. Change URL of previous posts and next posts link in WordPress
  75. How to invoke a HTML custom button based on a HTML dropdownlist menu
  76. Order posts inside bootstrap card columns
  77. long-title posts do not want published
  78. Mix post date with post meta value using WP_Query
  79. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  80. Counting Posts by Category
  81. show image gallery in archives or category page
  82. Page with Category Returning 1
  83. The first post appears twice
  84. wp_query args with relation
  85. WP_Query sort by meta_value_num or date
  86. Get 5 most recent categories
  87. Displaying a specific sub-category’s posts from wp_query
  88. Get results from the main wp_query
  89. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  90. Pagination for custom query won’t let me back on page 1
  91. Can’t get pagination to work
  92. Order by ‘s’ using WP_Query()
  93. how to print loops for odd in 1st column and even in 2nd column in wordpress [closed]
  94. List posts related to category on a div [closed]
  95. Wp_query WooCommerce products
  96. posts_per_page – Repeats only first posts ‘post__in’ array
  97. Next and Previous buttons are not showing on home page for post
  98. query_posts different amount of posts per page [duplicate]
  99. How edit footer copyright info? [closed]
  100. Get related posts matching most of the provided tags using WP_Query