public static function getEmails($list_id = 0)
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
//get Acymailing subscribers email
$query->select('s.email')->from('#__acymailing_subscriber AS s')->join('LEFT', '#__acymailing_listsub AS l ON s.subid = l.subid')->where('l.listid = ' . (int) $list_id)->where('l.status = 1')->where('s.enabled = 1')->where('s.accept = 1');
$db->setQuery($query);
try {
$emails = $db->loadColumn();
} catch (RuntimeException $e) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('Acymailing query error: ' . $e->getMessage());
}
return false;
}
if (version_compare(JVERSION, '3.0.0') == -1 and $error = $db->getErrorMsg()) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('Acymailing query error: ' . $error);
}
return false;
}
if (is_array($emails) and count($emails)) {
return $emails;
}
return false;
}
public static function getEmail($profile_id = 0)
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
//get JomSocial user email
$query->select('u.email')->from('#__users AS u')->where('u.id = ' . (int) $profile_id);
$db->setQuery($query);
try {
$email = $db->loadResult();
} catch (RuntimeException $e) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('JomSocial query error: ' . $e->getMessage());
}
return false;
}
if (version_compare(JVERSION, '3.0.0') == -1 and $error = $db->getErrorMsg()) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('JomSocial query error: ' . $error);
}
return false;
}
if (!empty($email)) {
return $email;
}
return false;
}
public static function getEmail($entry_id = 0)
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
//get SobiPro entry email
$query->select('d.baseData')->from('#__sobipro_field AS f')->join('LEFT', '#__sobipro_field_data AS d ON d.fid = f.fid')->where('d.sid = ' . (int) $entry_id)->where('f.enabled = 1')->where('(f.fieldType = ' . $db->quote('email') . ' OR f.filter = ' . $db->quote('email') . ')');
$db->setQuery($query);
try {
$email = $db->loadResult();
} catch (RuntimeException $e) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('SobiPro query error: ' . $e->getMessage());
}
return false;
}
if (version_compare(JVERSION, '3.0.0') == -1 and $error = $db->getErrorMsg()) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('SobiPro query error: ' . $error);
}
return false;
}
if (!empty($email)) {
if (JMailHelper::isEmailAddress($email)) {
return $email;
} else {
$result = self::unserialize($email);
if ($result !== false && is_array($result)) {
foreach ($result as $a) {
if (JMailHelper::isEmailAddress($a)) {
return $a;
}
}
}
}
}
//get SobiPro entry owner email
$query = $db->getQuery(true);
$query->select('u.email')->from('#__sobipro_object AS o')->join('LEFT', '#__users AS u ON u.id = o.owner')->where('o.id = ' . (int) $entry_id);
$db->setQuery($query);
try {
$email = $db->loadResult();
} catch (RuntimeException $e) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('SobiPro query error: ' . $e->getMessage());
}
return false;
}
if (version_compare(JVERSION, '3.0.0') == -1 and $error = $db->getErrorMsg()) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('SobiPro query error: ' . $error);
}
return false;
}
if (!empty($email)) {
return $email;
}
return false;
}
public static function getEmail($item_id = 0)
{
// load config
require_once JPATH_ADMINISTRATOR . '/components/com_zoo/config.php';
// get app
$zoo = App::getInstance('zoo');
// get current Zoo item
$item = $zoo->table->item->get($item_id);
if ($item) {
if (!in_array($item->type, array('author', 'employee'))) {
$elements = $item->getElements();
$email = $item = null;
foreach ($elements as $element) {
// Find email for current Zoo item
if ($element->getElementType() == 'email') {
$email = $element->get('value');
if ($item) {
break;
}
}
// Find author or employee ID for current Zoo item
if (in_array(strtolower($element->config->get('name')), array('author', 'employee'))) {
if ($element->getElementType() == 'relateditems') {
$relateditems = $element->get('item', array());
if (isset($relateditems[0])) {
// get author or employee Zoo item
$item = $zoo->table->item->get($relateditems[0]);
if ($email) {
break;
}
}
}
}
}
if ($email) {
return $email;
}
}
if ($item) {
// get email for Zoo author or employee
$elements = $item->getElements();
foreach ($elements as $element) {
if ($element->getElementType() == 'email') {
return $element->get('value');
}
}
}
}
$db = JFactory::getDBO();
$query = $db->getQuery(true);
//get Zoo created by user email
$query->select('u.email')->from('#__zoo_item AS i')->join('LEFT', '#__users AS u ON u.id = i.created_by')->where('i.id = ' . (int) $item_id);
$db->setQuery($query);
try {
$email = $db->loadResult();
} catch (RuntimeException $e) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('Zoo query error: ' . $e->getMessage());
}
return false;
}
if (version_compare(JVERSION, '3.0.0') == -1 and $error = $db->getErrorMsg()) {
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('Zoo query error: ' . $error);
}
return false;
}
if (!empty($email)) {
return $email;
}
return false;
}
public function delete($print_response = true)
{
if (PWEBCONTACT_DEBUG) {
modPwebcontactHelper::setLog('Deleting file');
}
return parent::delete($print_response);
}
