Create browsers.php

[clinton/MarylandElectronicPetitionSignature.git] / admin / follow_up_emails.php

<?PHP
include_once('../email.php');

$base_message = "I just wanted to take a second and follow up with your visit to md-petition.com and see if you needed anything, or had any questions.";

// USAGE meps_mail('Patrick <baltimorehacker@gmail.com>','','Petition Follow-Up');

$q="SELECT * FROM follow_up where status = 'NEW'";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
  $name = $d['name'];
  $email = $d['email'];
  
  $q2 = "SELECT * FROM presign where php_session_id = '$d[php_session]'";
  $r2 = $petition->query($q2);
  $presign = mysqli_fetch_array($r2);
  
  $visit = $presign['action_on'];
  
  $q2 = "SELECT * FROM petitions where petition_id = '$d[petition_id]'";
  $r2 = $petition->query($q2);
  $petitions = mysqli_fetch_array($r2);
  
  $petition_name = $petitions['petition_name'];
  $landing_page = $petitions['landing_page'];
  $web_short_name   = $petitions['web_short_name'];
  
  $link = 'https://www.md-petition.com/?invite='.$web_short_name;
  if ($landing_page != ''){
    $link = 'https://www.md-petition.com/'.$landing_page;
  }
  
  $invite = "<br><br>Petition: $petition_name at <a href='$link'>$link</a>";
  $last = "<br><br>Follow up was requested at $visit";
  $body = $base_message.$invite.$last;
  $subject = "$petition_name Petition Follow-Up";
  $to = "$name <$email>";
  $feedback_message = "TO: $to SUB: $subject MSG: $body sent on ".date('r')." by ".$_COOKIE['name'];
  meps_mail($to,$body,$subject);
  $feedback_message = $petition->real_escape_string($feedback_message);
  $petition->query("update follow_up set status = 'sent', feedback_message = '$feedback_message' where id = '$d[id]'  ");
}

?>