Untitled

<?php
include_once("wp-config.php"); // skrt do confingu wp dla danych do bazy
$dbHost = DB_HOST;
$dbUser = DB_USER;
$dbPassword = DB_PASSWORD;
$recvMail = "adam.filipowicz92@gmail.com"; // nazwa maila wysyłającego

$database = mysql_connect($dbHost,$dbUser, $dbPassword);
mysql_set_charset('utf8',$database);
mysql_select_db($dbName);
if (!$database) {
    die('MySql Connection error: ' . mysql_error());
}


$sqlAfter = "Select * from wp_em_events Where DATEDIFF(event_start_date,CURDATE()) = 14";
$sqlNow = "Select * from wp_em_events Where DATEDIFF(event_start_date,CURDATE()) = 0";

$query = mysql_query($sqlAfter);
$rows = mysql_fetch_all($query);

if($rows != null && count($rows) > 0)
{
sendMails($rows,"Juz za dwa tygodnie rozpocznie się nabór na: ",$recvMail);
}
else {
echo "no results";
}

$query = mysql_query($sqlNow);
$rows = mysql_fetch_all($query);

if($rows != null && count($rows) > 0)
{
sendMails($rows,"Od dzisiaj trwa nabór na: ",$recvMail);
}
else {
echo "no results";

}
function mysql_fetch_all($result) {
   while($row=mysql_fetch_array($result)) {
       $return[] = $row;
   }

   return $return;
}

function sendMails($rows, $titlePart, $recvMail)
{
  foreach ($rows as $row) {
    $eventMessage = '<link rel="stylesheet" type="text/css"  href="http://dotacjenainnowacje.taxand.pl/wp-content/themes/brooklyn/style.css?ver=2.7" ></link>'.$row["post_content"];
    $startDate = $row["event_start_date"];
    $eventName = $titlePart. $row["event_name"];
    $startTime = $row["event_start_time"];
    $queryBooking = mysql_query("Select * From wp_em_bookings Where event_id = ".$row["event_id"]);

    $bookings = mysql_fetch_all($queryBooking);

    if($bookings == null || count($bookings) == 0)
    {

      continue;
    }
  foreach ($bookings as $booking) {

      $personId = $booking["person_id"];
      $query = mysql_query("Select * From wp_users Where ID =".$personId);


      $person = mysql_fetch_all($query);


        if($person == null || count($person) == 0 )
        {
          continue;
        }
        $email = $person[0]["user_email"];

        echo $recvMail;
        echo   $email;
        echo   $eventName;
        echo   $eventMessage;
        $to =  $email; //"adam.filipowicz92@gmail.com";

        $subject =    $eventName;

        $headers = "From: ".$recvMail ."\r\n";
        $headers .= "Reply-To: ".$recvMail ."\r\n";
        $headers .= "MIME-Version: 1.0\r\n";
        $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
        $message = '<html><body>';
        $message .= $eventMessage;
        $message .= '</body></html>';
        mail($to, $subject, $message, $headers);
    //    echo var_dump($person);
    }
 }
}
?>