upgrade-posts.php

<?php
/*
Copyright (c) 2008, Alex Tingle.

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

/** Only include this file if a database upgrade is called for.
 *  Otherwise it can be safely ignored. */
function ec3_upgrade_posts()
{
  global $ec3,$post,$wpdb;
  $ec3->advanced=false;
  $changed = ec3_upgrade_posts_apply();

  $query =& new WP_Query();
  $query->query( 'nopaging=1&cat=' . $ec3->event_category );

  $format = 'Y-m-d H:i:s';
  $now = time();
  $rownum = 0;
  ?>

  <?php if($changed): ?>

   <div id="message" class="updated fade"><p><strong>
   <?php if($changed==1) _e('Post upgraded.','ec3') ?>
   <?php if($changed>1) echo sprintf(__('%d posts upgraded.','ec3'),$changed) ?>
   </strong></p></div>

  <?php endif ?>

  <div class="wrap">
  <form method="post">
  <h2><?php _e('Upgrade Event Posts (from version 3.0)','ec3'); ?></h2>

  <?php if($query->have_posts()): ?>

  <input type="hidden" name="ec3_action" value="upgrade_posts" />
  <table class="widefat">

        <thead>
        <tr>
           <th scope="col">OK</th>
           <th scope="col">Title</th>
           <th scope="col">Post date</th>
           <th scope="col">Event date</th>
        </tr>
        </thead>

   <?php while($query->have_posts()): $query->the_post(); ?>

     <?php if(empty($post->ec3_schedule)):
       $post_date = get_post_time();
       $post_modified_date = get_post_modified_time();
       $rownum++;
       if($rownum % 2)
       {
         $rowclass='alternate ';
       }
       else
       {
         $rowclass='';
       }

       if($post_modified_date >= $now)
       {
         $errstyle='background-color:#fcc';
       }
       else
       {
         $errstyle='';
       }
     ?>

       <tr class="<?php echo $rowclass ?>">
          <td>
           <input type="checkbox" name="ec3_upgrade_<?php the_ID() ?>"
            value="1" checked="checked" />
          </td>
          <td title="Post ID: <?php the_ID() ?>">
           <a target="_blank" href="<?php the_permalink() ?>">
            <?php the_title() ?>
           </a>
          </td>
          <td>
           <input type="text" name="ec3_postdate_<?php the_ID() ?>"
            style="<?php echo $errstyle ?>"
            value="<?php echo date($format,$post_modified_date) ?>" />
          </td>
          <td>
           <input type="text" name="ec3_eventdate_<?php the_ID() ?>"
            value="<?php echo date($format,$post_date) ?>" />
          </td>
       </tr>

     <?php endif ?>
   <?php endwhile ?>
   <?php if($rownum==0): ?>

       <tr><td>No posts to upgrade.</td></tr>

   <?php endif ?>

  </table>

  <p class="submit">

    <?php if($rownum>0): ?>

       <input type="submit" name="ec3_upgrade_posts"
        value="<?php _e('Upgrade Event Posts','ec3') ?>" />
       <input type="submit" name="ec3_cancel_upgrade"
        value="<?php _e("Don't Upgrade Posts") ?>" />

    <?php else: update_option('ec3_upgrade_posts',0) ?>

       <input type="submit" name="ec3_cancel_upgrade"
        value="<?php _e('OK') ?> &raquo;" />

    <?php endif ?>

  </p>

  <?php endif ?>

  </form>
  </div>

<?php

}


/** Process results from the 'ec3_upgrade_posts' form. */
function ec3_upgrade_posts_apply()
{
  if(!isset($_POST) ||
     !isset($_POST['ec3_action']) ||
     $_POST['ec3_action']!='upgrade_posts')
  {
    return;
  }

  global $ec3,$wpdb;

  $changed_count=0;

  // Find all of our parameters
  $sched_entries=array();
  $fields =array('postdate','eventdate');
  foreach($_POST as $k => $v)
  {
    if(preg_match('/^ec3_(upgrade|'.implode('|',$fields).')_(_?)([0-9]+)$/',$k,$match))
    {
      $pid=intval($match[3]);
      if(!isset( $sched_entries[$pid] ))
          $sched_entries[ $pid ]=array();
      $sched_entries[ $pid ][ $match[1] ] = $v;
    }
  }

  foreach($sched_entries as $pid => $vals)
  {
    if(empty($vals['upgrade']) ||
       empty($vals['postdate']) ||
       empty($vals['eventdate']) )
    {
      continue;
    }
    $postdate = "'".$wpdb->escape($vals['postdate'])."'";
    $eventdate = "'".$wpdb->escape($vals['eventdate'])."'";
    $cnt=$wpdb->get_var(
      "SELECT COUNT(0) FROM $ec3->schedule
       WHERE post_id=$pid");
    if(!empty($cnt))
      continue;
    // Create a schedule record.
    $wpdb->query(
      "INSERT INTO $ec3->schedule (post_id,start,end,allday,rpt)
       VALUES ($pid,$eventdate,$eventdate,0,'')"
    );
    // Modify the post date.
    $wpdb->query(
      "UPDATE $wpdb->posts
       SET post_date=$postdate, post_date_gmt=$postdate
       WHERE ID=$pid"
    );
    $changed_count++;
  }
  return $changed_count;
}

?>