<?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;

}

?>