function suscriptionExist($subscriber_id, $listId)
{
if (ACA_CMSTYPE) {
$database =& JFactory::getDBO();
} else {
global $database;
}
//endif
$erro = new xerr(__FILE__, __FUNCTION__, __CLASS__);
if ($subscriber_id > 0 and $listId > 0) {
if (is_array($subscriber_id)) {
$subscriber_id = implode(',', $subscriber_id);
}
$query = 'SELECT * FROM `#__acajoom_queue` WHERE `subscriber_id` IN ( ' . $subscriber_id . ') AND `list_id` =' . $listId;
$database->setQuery($query);
if (ACA_CMSTYPE) {
// joomla 15
$queue = $database->loadObject();
} else {
//joomla 1x
$database->loadObject($queue);
}
//endif
$erro->err = $database->getErrorMsg();
return $erro->Ertrn(__LINE__, '8541', $database, $queue);
}
return '';
}
function getAdmins()
{
global $database;
$erro = new xerr(__FILE__, __FUNCTION__, __CLASS__);
$query = "SELECT S.* FROM `#__acajoom_subscribers` as S ";
$query .= " LEFT JOIN `#__users` as U ON S.user_id = U.id ";
$query .= " WHERE ( U.usertype = 'superadministrator' ";
$query .= " OR U.usertype = 'Super Administrator' ";
$query .= " OR U.usertype = 'super administrator' ) ";
$database->setQuery($query);
$admins = $database->loadObjectList();
$erro->err = $database->getErrorMsg();
return $erro->Ertrn(__LINE__, '8666', $database, $admins);
}