/home/edulekha/crm.edulekha.com/application/controllers/Check_emails.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Check_emails extends CI_Controller
{
public function track($uid)
{
// The SPAM protection appears to call "HEAD" calls instead of "GET" as they aren't interested in the result,
// just that things seem to redirect somewhere good.
if (strtolower($_SERVER['REQUEST_METHOD']) === 'get') {
$this->db->where('opened', 0);
$this->db->where('uid', $uid);
$tracking = $this->db->get(db_prefix() . 'tracked_mails')->row();
// Perhaps already tracked?
if ($tracking) {
$this->db->where('id', $tracking->id);
$this->db->update(db_prefix() . 'tracked_mails', [
'date_opened' => date('Y-m-d H:i:s'),
'opened' => 1,
]);
}
}
}
}