<?php

include "../classes/class.loader.php";

$email = new email();
$functions = new functions();
$db = new db();

$res = $db->query("SELECT * FROM event_handler WHERE `sent` = 0 ORDER BY record_id ASC LIMIT 1");
if ($res->num_rows > 0) {
    while ($row = $res->fetch_assoc()) {
        $user_data = $functions->get_user_name_and_email($row['user_id']);
        $email->add_address($user_data['email'], $user_data['username']);
        $email->add_address("walruslector@gmail.com", "Jana");
        $email->add_address("unleashed.offleashed@gmail.com", "Rika");
        $email->subject("Unleashed - UnPaid Booking");
        $email->body($row['message']);
        if ($email->send()) {

            $date = date('Y-m-d H:i:s', strtotime("+2 Hours"));
            $db->query("UPDATE event_handler SET `sent` = 1,`sent_date_time` = '$date' WHERE record_id = {$row['record_id']}");
        }
    }
}