public static function getSubscriberId() { $app = \Cobalt\Container::fetch('app'); $person_id = $app->input->get('person_id') ? $app->input->get('person_id') : $app->input->get('id'); $personModel = new PeopleModel(); $email = $personModel->getEmail($person_id); $db = \Cobalt\Container::fetch('db'); $query = $db->getQuery(true); $query->select("subid")->from("#__acymailing_subscriber")->where("email='" . $email . "'"); $db->setQuery($query); $id = $db->loadResult(); return $id; }