trackable.php

<?php
// File size is limited by Nginx site to 10M
// To speed things up, we do not include prerequisites
header('Content-Type: text/plain');
require_once "vars.inc.php";
// Do not show errors, we log to using error_log
ini_set('error_reporting', 0);
// Init database
//$dsn = $database_type . ':host=' . $database_host . ';dbname=' . $database_name;
$dsn = $database_type . ":unix_socket=" . $database_sock . ";dbname=" . $database_name;
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
try {
  $pdo = new PDO($dsn, $database_user, $database_pass, $opt);
}
catch (PDOException $e) {
  error_log("TRACKABLE: " . $e . PHP_EOL);
  http_response_code(501);
  exit;
}

if (!function_exists('getallheaders'))  {
  function getallheaders() {
    if (!is_array($_SERVER)) {
      return array();
    }
    $headers = array();
    foreach ($_SERVER as $name => $value) {
      if (substr($name, 0, 5) == 'HTTP_') {
        $headers[str_replace(' ', '-', ucwords(strtolower(str_replace('_', ' ', substr($name, 5)))))] = $value;
      }
    }
    return $headers;
  }
}

// Read headers
$headers = getallheaders();
// Get Domain
$domain = $headers['Domain'];
// Get Username
$username = $headers['Username'];
// Get From
$from = $headers['From'];

error_log("TRACKABLE: checking for domain " . $domain . ", user " . $username . " and address " . $from . PHP_EOL);

try {
  // try get $target_domain if $domain is an alias_domain
  $stmt = $pdo->prepare("SELECT `target_domain` FROM `alias_domain` 
    WHERE `alias_domain` = :alias_domain");
  $stmt->execute(array(
    ':alias_domain' => $domain
  ));
  $alias_domain = $stmt->fetch(PDO::FETCH_ASSOC);
  if (!$alias_domain) {
    $target_domain = $domain;
  } else {
    $target_domain = $alias_domain['target_domain'];
  }

  // get custom mailbox attributes and search for TRACK = YES
  $stmt = $pdo->prepare("SELECT `custom_attributes` FROM `mailbox` WHERE `username` = :username");
  $stmt->execute(array(
    ':username' => $username
  ));
  $custom_attributes = $stmt->fetch(PDO::FETCH_ASSOC)['custom_attributes'];
  $result = false;
  $custom_attributes = json_decode($custom_attributes, true);
  foreach($custom_attributes as $key => $value) {
    if($key === 'OPEN_TRACKING' && $value === 'YES') {
      $result = true;
      break;
    }
  }

  error_log("TRACKABLE: " . json_encode($result) . PHP_EOL);

  echo json_encode(array(
    'result' => $result
  ));

}
catch (Exception $e) {
  error_log("TRACKABLE: " . $e->getMessage() . PHP_EOL);
  http_response_code(502);
  exit;
}