<?php

include "/m/data1/app.hotlunches.net/db.php";

$query = "SELECT DISTINCT school_num,ordered_by_num,schedule_num FROM hotlunch_order_items WHERE order_num = 0 AND school_num > 0";
$results = db_query($query);

$time = time() - 60 * 60;

while ($row = db_fetch_assoc($results)) {
   extract($row);

   $query = "SELECT * FROM hotlunch_order_header " .
            "WHERE school_num = $school_num " .
            "AND ordered_by_num = $ordered_by_num " .
            "AND schedule_num = $schedule_num " .
            "AND added_time < $time";
   $oh = db_getVal($query);
   if ($oh) {
      extract($oh);

      $query = "UPDATE hotlunch_order_items SET order_num = $record_num " .
               "WHERE school_num = $school_num " .
               "AND ordered_by_num = $ordered_by_num " .
               "AND schedule_num = $schedule_num";
      db_query($query);
   }
}

?>