wordpress计划数据库条目

2 回答

• 0

  TL;DR 值在wp_options表中，其中option_name = 'cron' .

  ---

  使用WordPress cron将帖子从未来移到发布，你是对的 . 当您安排发布以供将来发布时，WordPress会更新选项表中的"cron"条目（默认情况下为 wp_options ，但如果您更改了表前缀，则会有所不同） .

  它adds a publish_future_post entry到存储的数组（使用wp_schedule_single_event()函数） .

  实际发布是通过check_and_publish_future_post()函数完成的 .

  该值是PHP序列化的，因此使用数据库查询进行更新可能会非常棘手 .

  Edit

  继我的评论之后，这些是我在该表中看到的之前（没有未来的帖子）和之后（一个未来的帖子）值 .

  之前：

  'a:4:{i:1467810391;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1467853602;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1467855934;a:1:{s:30:\"wp_scheduled_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}','yes');'
  

  后：

  'a:5:{i:1467802230;a:1:{s:19:\"publish_future_post\";a:1:{s:32:\"c235acd81e1457babc4e93303796723c\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:20;}}}}i:1467810391;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1467853602;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1467855934;a:1:{s:30:\"wp_scheduled_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}'
  

  区别在于 publish_future_post 条目：

  i:1467802230;a:1:{s:19:\"publish_future_post\";a:1:{s:32:\"c235acd81e1457babc4e93303796723c\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{i:0;i:20;}}}}
  

  回复于 2024-05-15T02:29:27+08:00
• 0

  只需将此代码添加到主题的functions.php文件中即可

  function wpb_upcoming_posts() { 
          // The query to fetch future posts
          $the_query = new WP_Query(array( 
              'post_status' => 'future',
              'posts_per_page' => 3,
              'orderby' => 'date',
              'order' => 'ASC'
          ));
  
      // The loop to display posts
      if ( $the_query->have_posts() ) {
          echo '<ul>';
          while ( $the_query->have_posts() ) {
              $the_query->the_post();
              $output .= '<li>' . get_the_title() .' ('.  get_the_time('d-M-Y') . ')</li>';
          }
          echo '</ul>';
  
      } else {
          // Show this when no future posts are found
          $output .= '<p>No posts planned yet.</p>';
      }
  
      // Reset post data
      wp_reset_postdata();
  
      // Return output
  
      return $output; 
      } 
      // Add shortcode
      add_shortcode('upcoming_posts', 'wpb_upcoming_posts'); 
      // Enable shortcode execution inside text widgets
      add_filter('widget_text', 'do_shortcode');
  

  短代码：

  <?php echo do_shortcode('[upcoming_posts]');?>
  
  [upcoming_posts]
  

  希望如此工作

  回复于 2024-05-15T02:29:27+08:00