FROM kispests_db.`reservation` LEFT JOIN kispests_db.user ON (kispests_db.reservation.user_id=kispests_db.user.id) WHERE kispests_db.reservation.`date` > UNIX_TIMESTAMP( "2015-01-01 00:00:00" ) AND kispests_db.user.login!="uszoda" '; $sth = $DB->prepare($sql); $sth->execute(); $reservations = array(); foreach ($sth->fetchAll() as $res) { $date = date("Y-m-d", $res['date']); $username = $res['login']; $court_id = $res['palya']; // 3-as pály az igazából 6-os pálya, 4-es az 7-es, 5-ös az 8-as if ($court_id >= 3) { $court_id += 3; } $price = $res['price']; $from = date("H:i", $res['date'] - 2 * 60 * 60); $add_date = date("Y-m-d H:i:s", $res['created']); $timeunit = TimeUnit::get_by_date_and_from($date, $from, $court_id); reservation_migrate($timeunit->id, $username, $price, $add_date); echo '"' . $username . '";"' . $date . '";"' . $from . '";"' . $price . '";"' . $court_id . '";"' . $timeunit->id . '"' . "\n"; $two_hour_timeunits = array('08:00' => '09:00', '10:00' => '11:00', '12:00' => '13:00'); if (in_array($from, array_keys($two_hour_timeunits))) { $next_hour = $two_hour_timeunits[$from]; $timeunit = TimeUnit::get_by_date_and_from($date, $next_hour, $court_id); echo '"' . $username . '";"' . $date . '";"' . $next_hour . '";"' . $price . '";"' . $court_id . '";"' . $timeunit->id . '";"2ND HOUR"' . "\n"; reservation_migrate($timeunit->id, $username, $price, $add_date); } }