public function Process()
{
// Newsletter component disabled or not found. Aborting.
if (!$this->enabled) {
return true;
}
$config = new jNews_Config();
// Build subscriber object
$subscriber = new stdClass();
// Lists
$cumulative = $this->JInput->post->get("jnews_subscribe_cumulative", NULL, "int");
$checkboxes = $this->JInput->post->get("jnews_subscribe", array(), "array");
$subscriber->list_id = $cumulative ? $checkboxes : array();
// No lists selected. Skip here to avoid annoying the user with email confirmation. It is useless to confirm a subscription to no lists.
if (empty($subscriber->list_id)) {
return true;
}
// Name field may be absent. JNews will assign an empty name to the user.
$subscriber->name = isset($this->FieldsBuilder->Fields['sender0']) ? $this->FieldsBuilder->Fields['sender0']['Value'] : "";
$subscriber->email = empty($this->FieldsBuilder->Fields['sender1']['Value']) ? NULL : JMailHelper::cleanAddress($this->FieldsBuilder->Fields['sender1']['Value']);
// JNews saves users with empty email address, so we have to check it
if (empty($subscriber->email)) {
$this->logger->Write(get_class($this) . " Process(): Email address empty. User save aborted.");
return true;
}
// It seems that $subscriber->confirmed defaults to unconfirmed if unset, so we need to read and pass the actual value from the configuration
$subscriber->confirmed = !(bool) $config->get('require_confirmation');
$subscriber->receive_html = 1;
// Avoid Notice: Undefined property while JNews libraries access undefined properties
$subscriber->ip = jNews_Subscribers::getIP();
$subscriber->subscribe_date = jnews::getNow();
$subscriber->language_iso = "eng";
$subscriber->timezone = "00:00:00";
$subscriber->blacklist = 0;
$subscriber->user_id = JFactory::getUser()->id;
// Subscription
$sub_id = null;
jNews_Subscribers::saveSubscriber($subscriber, $sub_id, true);
if (empty($sub_id)) {
// User save failed. Probably email address is empty or invalid
$this->logger->Write(get_class($this) . " Process(): User save failed");
return true;
}
// Subscribe $subscriber to $subscriber->list_id
//$subscriber->id = $sub_id;
// jNews_ListsSubs::saveToListSubscribers() doesn't work well. When only one list is passed to, it reads the value $listids[0],
// but the element 0 is not always the first element of the array. In our case is $listids[1]
//jNews_ListsSubs::saveToListSubscribers($subscriber);
$this->SaveSubscription($subscriber);
// Log
$this->logger->Write(get_class($this) . " Process(): subscribed " . $this->FieldsBuilder->Fields['sender0']['Value'] . " (" . $this->FieldsBuilder->Fields['sender1']['Value'] . ") to lists " . implode(",", $subscriber->list_id));
return true;
}
function subscribers($action, $task, $userid, $listId, $cid, $front = false)
{
$Itemid = JRequest::getInt('Itemid');
$mainframe = JFactory::getApplication();
$newSubscriber = null;
$subscriberId = JRequest::getInt('subscriber_id');
$message = JRequest::getVar('message', '');
$css = '.icon-48-subscribers { background-image:url(' . JNEWS_PATH_ADMIN_IMAGES2 . 'header/subscribers.png)}';
$doc = JFactory::getDocument();
$doc->addStyleDeclaration($css, $type = 'text/css');
$img = 'subscribers.png';
$emailField = JRequest::getVar('email', '');
$new = true;
//new subscriber
$my = JFactory::getUser();
//START OF DATA FROM REQUEST
$subscriber = new stdClass();
$subscriber->user_id = JRequest::getInt('user_id');
$subscriber->name = JRequest::getVar('name', '');
$subscriber->email = JRequest::getVar('email', '', '', 'STRING');
if (!jNews_Subscribers::validEmail($subscriber->email)) {
$subscriber->email = '';
}
$subscriber->receive_html = JRequest::getInt('receive_html', 0);
if (empty($subscriberId)) {
//if it is a new user the confirmed depends if the require confirmation is turned on
if ($GLOBALS[JNEWS . 'require_confirmation'] == '1') {
$subscriber->confirmed = 0;
} else {
$subscriber->confirmed = JRequest::getInt('confirmed');
}
} else {
$subscriber->confirmed = JRequest::getInt('confirmed');
}
$subscriber->blacklist = JRequest::getVar('blacklist', 0);
$subscriber->timezone = JRequest::getVar('timezone', '');
$subscriber->language_iso = JRequest::getVar('language_iso', '');
if (empty($subscriber->ip)) {
$subscriber->ip = jNews_Subscribers::getIP();
}
if ($subscriber->ip == '0.0.0.0') {
$subscriber->ip = '0';
}
$subscriber->subscribe_date = time();
$subscriber->params = JRequest::getVar('params', '');
//column
if ($GLOBALS[JNEWS . 'level'] > 2) {
$subscriber->column1 = JRequest::getVar('column1', '');
$subscriber->column2 = JRequest::getVar('column2', '');
$subscriber->column3 = JRequest::getVar('column3', '');
$subscriber->column4 = JRequest::getVar('column4', '');
$subscriber->column5 = JRequest::getVar('column5', '');
}
//end check of version pro
//END OF DATA FROM REQUEST
$doShowSubscribers = true;
switch ($task) {
case 'updateOneSub':
JRequest::checkToken() or die('Invalid Token');
$doShowSubscribers = true;
$new = false;
//we addslashes the name incase an ' is entered in the name
$subscriber->name = addslashes($subscriber->name);
$message = jnews::printYN(jNews_Subscribers::saveSubscriber($subscriber, $subscriberId, $new), _JNEWS_UPDATED_SUCCESSFULLY, _JNEWS_ERROR);
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
case 'deleteOneSub':
JRequest::checkToken() or die('Invalid Token');
$doShowSubscribers = true;
$message = jnews::printYN(jNews_Subscribers::deleteSubscriber($subscriberId), _JNEWS_SUBSCRIBER_DELETED, _JNEWS_ERROR);
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
case 'cancelSub':
$doShowSubscribers = true;
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
case 'edit':
foreach ($cid as $id) {
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION . '&act=subscribers&task=show&userid=' . $id);
}
break;
case 'show':
$doShowSubscribers = false;
$qid[0] = $userid;
$subscriber = jNews_Subscribers::getSubscribersFromId($qid, false);
$lists = jNews_Lists::getLists(0, 0, 1, '', false, false);
$queues = jNews_ListsSubs::getSubscriberLists($userid);
$forms['main'] = " <form action='index.php' method='post' name='adminForm' id=\"adminForm\">";
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
backHTML::formStart('', 0, '');
echo jNews_SubscribersHTML::editSubscriber($subscriber, $lists, $queues, $forms, jnews::checkPermissions('admin'), false, false);
$go[] = jnews::makeObj('act', $action);
$go[] = jnews::makeObj('subscriber_id', $subscriber->id);
$go[] = jnews::makeObj('user_id', $subscriber->user_id);
backHTML::formEnd($go);
break;
case 'new':
case 'add':
$doShowSubscribers = false;
$newSubscriber = new stdClass();
$newSubscriber->id = '';
$newSubscriber->user_id = 0;
$newSubscriber->name = '';
$newSubscriber->email = '';
$newSubscriber->ip = jNews_Subscribers::getIP();
$newSubscriber->receive_html = 1;
$newSubscriber->confirmed = 1;
$newSubscriber->blacklist = 0;
$newSubscriber->timezone = '00:00:00';
$newSubscriber->language_iso = 'eng';
$newSubscriber->params = '';
$newSubscriber->subscribe_date = time();
//column
if ($GLOBALS[JNEWS . 'level'] > 2) {
//check if the version of jnews is pro
$newSubscriber->column1 = '';
$newSubscriber->column2 = '';
$newSubscriber->column3 = '';
$newSubscriber->column4 = '';
$newSubscriber->column5 = '';
}
$lists = jNews_Lists::getLists(0, 0, 1, '', false, false);
$queues = '';
$forms['main'] = " <form action='index.php' method='post' name=\"adminForm\" id=\"adminForm\">";
if ($mainframe->isAdmin() || $GLOBALS[JNEWS . 'use_backendview']) {
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
backHTML::formStart('addsubsback', 0, '');
echo jNews_SubscribersHTML::editSubscriber($newSubscriber, $lists, $queues, $forms, jnews::checkPermissions('admin'), false, false);
} else {
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
backHTML::formStart('addsubsfront', 0, '');
echo jNews_SubscribersHTML::editSubscriberFE($newSubscriber, $lists, $queues, $forms, jnews::checkPermissions('admin'), false, false);
}
$go[] = jnews::makeObj('act', $action);
$go[] = jnews::makeObj('subscriber_id', $newSubscriber->id);
$go[] = jnews::makeObj('user_id', $newSubscriber->user_id);
backHTML::formEnd($go);
break;
case 'doNew':
JRequest::checkToken() or die('Invalid Token');
$doShowSubscribers = true;
if ($mainframe->isAdmin() || $GLOBALS[JNEWS . 'use_backendview']) {
$message = jnews::printYN(jNews_Subscribers::saveSubscriber($subscriber, $subscriberId, $new), _JNEWS_NEW_SUBSCRIBER, _JNEWS_ERROR);
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
} else {
$status = jNews_Subscribers::importBis();
if ($mainframe->isAdmin()) {
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION . '&act=subscribers&mid=2');
} else {
$mainLink = JRoute::_('index.php?option=' . JNEWS_OPTION . '&act=subscribers&mid=2');
jNews_Tools::redirect($mainLink);
}
}
break;
case 'delete':
JRequest::checkToken() or die('Invalid Token');
if (!is_array($cid) || count($cid) < 1) {
echo "<script> alert('Select an item to delete'); window.history.go(-1);</script>\n";
return false;
} else {
$status = true;
foreach ($cid as $id) {
if (!jNews_Subscribers::deleteSubscriber($id)) {
$status = false;
}
}
$message = jnews::printYN($status, _JNEWS_SUBSCRIBER_DELETED, _JNEWS_ERROR);
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
}
break;
case 'update':
JRequest::checkToken() or die('Invalid Token');
if (!is_array($cid) || count($cid) < 1) {
echo "<script> alert('Select an item to update'); window.history.go(-1);</script>\n";
return false;
} else {
foreach ($cid as $id) {
$changes = JRequest::getVar($id, array(0));
if (!isset($changes['receive_html'])) {
$changes['receive_html'] = 0;
}
if (!isset($changes['confirmed'])) {
$changes['confirmed'] = 0;
}
}
}
$message = jnews::print_message(_JNEWS_UPDATED_SUCCESSFULLY, 1);
break;
case 'export':
$doShowSubscribers = false;
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
jNews_SubscribersHTML::export($action, $listId);
break;
case 'doExport':
$message = jnews::printYN(jNews_Subscribers::export($listId), _EXPORT, _JNEWS_ERROR);
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
case 'import':
$doShowSubscribers = false;
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
$lists = jNews_Lists::getLists('', 0, '', '', false, true, true, false, false);
jNews_SubscribersHTML::import($action, $lists, $listId);
break;
case 'doImport':
JRequest::checkToken() or die('Invalid Token');
$message = jNews_Subscribers::importBis();
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
$message = !empty($message) && $message !== true ? $message : ($message === false ? 'Import failed' : _JNEWS_IMPORT_FINISHED);
if ($mainframe->isAdmin()) {
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION . '&act=subscribers', $message);
} else {
$mainLink = JRoute::_('index.php?option=' . JNEWS_OPTION . '&act=subscribers&mid=2');
jNews_Tools::redirect($mainLink);
}
break;
case 'subscribeAll':
case 'unsubscribeAll':
JRequest::checkToken() or die('Invalid Token');
break;
case 'cancel':
if ($listId != 0) {
$listId = 0;
} else {
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION);
}
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
case 'cpanel':
$mainframe = JFactory::getApplication();
if ($mainframe->isAdmin()) {
backHTML::controlPanel();
} else {
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION);
}
$doShowSubscribers = 0;
break;
case 'toggle':
$subid = JRequest::getVar('subid');
$column = JRequest::getVar('col');
if (!empty($subid) && !empty($column)) {
$passObj = new stdClass();
$passObj->tableName = '#__jnews_subscribers';
$passObj->columnName = $column;
$passObj->whereColumn = 'id';
$passObj->whereColumnValue = $subid;
jnews::toggle($passObj);
// change suspend status if column toggled is confirmed
if ($column == 'confirmed') {
$passObj = new stdClass();
$passObj->tableName = '#__jnews_queue';
$passObj->columnName = 'suspend';
$passObj->whereColumn = 'subscriber_id';
$passObj->whereColumnValue = $subid;
jnews::toggle($passObj);
}
}
jNews_Tools::redirect('index.php?option=' . JNEWS_OPTION . '&act=subscribers&listid=' . $listId);
break;
default:
backHTML::_header(_JNEWS_MENU_SUBSCRIBERS, $img, $message, $task, $action);
break;
}
if ($doShowSubscribers) {
$limit = -1;
$emailsearch = JRequest::getVar('emailsearch', '', '', 'STRING');
$emailsearch = htmlentities($emailsearch, ENT_COMPAT, "UTF-8");
$paginationStart = JRequest::getVar('pg');
$lll = JRequest::getVar('limitstart');
if (empty($lll)) {
JRequest::setVar('limitstart', 0, 'int');
}
$app = JFactory::getApplication();
$limitstart = $app->getUserStateFromRequest('limitstart', 'limitstart', 0, 'int');
$limitend = $app->getUserStateFromRequest('limit', 'limit', 0, 'int');
$subscirberTypeID = JRequest::getVar('subtype', 1);
if (empty($listId) && in_array($subscirberTypeID, array(1, 2))) {
$subscirberTypeID = 0;
}
if (!empty($listId) && in_array($subscirberTypeID, array(3, 4))) {
$subscirberTypeID = 0;
}
if (!empty($my->id)) {
$ownedlists = jNews_Lists::getOwnedlists($my->id);
}
$ztozto = null;
$limittotal = jNews_Subscribers::getSubscribers(0, 0, $emailsearch, $ztozto, $listId, '', '', '', 'sub_dateD', '', $ownedlists, '', $subscirberTypeID, true);
//added one parameter for mailid
$setLimit = new stdClass();
$setLimit->total = !empty($limittotal) ? $limittotal : 0;
$setLimit->start = !empty($limitstart) ? $limitstart : 0;
$setLimit->end = !empty($limitend) ? $limitend : 20;
$setSort = new stdClass();
$setSort->orderValue = $app->getUserStateFromRequest(JNEWS_OPTION . '.subscribers.filter_order', 'filter_order', 'subscribe_date', 'cmd');
$setSort->orderDir = $app->getUserStateFromRequest(JNEWS_OPTION . '.subscribers.filter_order_Dir', 'filter_order_Dir', 'desc', 'word');
if (empty($limitstart)) {
$limitstart = 0;
}
if ($setLimit->end > 200) {
$setLimit->end = 200;
}
if ($setLimit->total == $setLimit->end) {
$setLimit->start = 0;
}
$subscribers = jNews_Subscribers::getSubscribers($setLimit->start, $setLimit->end, $emailsearch, $setLimit->total, $listId, '', '', '', 'sub_dateD', '', $ownedlists, $setSort, $subscirberTypeID);
//added one parameter for mailid
if ($listId != 0) {
$showAdmin = true;
} else {
$showAdmin = false;
}
$dropDownList = jNews_ListType::getListsDropList(0, '', '');
$subTypeA = array();
$subTypeA[0] = new stdClass();
$subTypeA[0]->id = 0;
$subTypeA[0]->subtype = _JNEWS_SUB_LISTTYPE_ALL;
if ($listId != 0) {
$subTypeA[1] = new stdClass();
$subTypeA[1]->id = 1;
$subTypeA[1]->subtype = _JNEWS_SUB_LISTTYPE_ONLY_SUBCRIBED;
$subTypeA[2] = new stdClass();
$subTypeA[2]->id = 2;
$subTypeA[2]->subtype = _JNEWS_SUB_LISTTYPE_ONLY_UNSUBCRIBED;
} else {
$subTypeA[3] = new stdClass();
$subTypeA[3]->id = 3;
$subTypeA[3]->subtype = _JNEWS_SUB_LISTTYPE_ONLY_WAITINGCONF;
$subTypeA[4] = new stdClass();
$subTypeA[4]->id = 4;
$subTypeA[4]->subtype = _JNEWS_SUB_LISTTYPE_ONLY_BLOCKED;
}
$lists['listid'] = jnews::HTML_GenericList($dropDownList, 'listid', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'id', 'list_name', $listId);
$lists['subscirberType'] = jnews::HTML_GenericList($subTypeA, 'subtype', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'id', 'subtype', $subscirberTypeID);
if ($mainframe->isAdmin()) {
$forms['main'] = " <form action='index.php' method='post' name=\"adminForm\" id=\"adminForm\">";
} else {
if (empty($setLimit->start)) {
$setLimit->start = 0;
}
$mainLink = JRoute::_('index.php?option=' . JNEWS_OPTION);
$forms['main'] = "<form action='" . $mainLink . "' method='post' name=\"adminForm\" id=\"adminForm\">";
}
$forms['select'] = " <form method='post' name='jNewsFilterForm'> \n";
backHTML::formStart('show_mailing', 0, '');
jNews_SubscribersHTML::showSubscribers($subscribers, $action, $listId, $lists, $setLimit->start, $setLimit->end, $setLimit->total, $showAdmin, $listId, $emailsearch, $forms, $setLimit, $front, $setSort);
}
return true;
}
/**
* This public static function is used for CB Integration and FE Subscription
*/
public static function updateCBFESubscriber($userId = 0, $user = null, $confirmed = '0')
{
$oneSubscriber = new stdClass();
$oneSubscriber->name = JRequest::getVar('name', '');
$oneSubscriber->receive_html = JRequest::getInt('receive_html');
$oneSubscriber->confirmed = JRequest::getInt('confirmed');
$oneSubscriber->blacklist = JRequest::getVar('blacklist', 0);
$oneSubscriber->timezone = JRequest::getVar('timezone', '');
$oneSubscriber->language_iso = JRequest::getVar('language_iso', '');
$oneSubscriber->params = JRequest::getVar('params', '');
$oneSubscriber->email = JRequest::getVar('email', '');
$oneSubscriber->subscribe_date = time();
//update column 1
if ($GLOBALS[JNEWS . 'level'] > 2) {
$oneSubscriber->column1 = JRequest::getVar('column1', '');
$oneSubscriber->column2 = JRequest::getVar('column2', '');
$oneSubscriber->column3 = JRequest::getVar('column3', '');
$oneSubscriber->column4 = JRequest::getVar('column4', '');
$oneSubscriber->column5 = JRequest::getVar('column5', '');
}
if (isset($user)) {
$oneSubscriber->email = $user->email;
if (empty($oneSubscriber->email) || !jNews_Subscribers::validEmail($oneSubscriber->email)) {
echo '<br />' . jnews::printM('red', _JNEWS_EMAIL_INVALID);
echo "<script> alert('" . addslashes(_JNEWS_EMAIL_INVALID) . "'); window.history.go(-1);</script>\n";
return false;
}
$oneSubscriber->user_id = $user->id;
$oneSubscriber->id = jNews_Subscribers::getSubscriberIdFromUserId($user->id);
$subscriberId = $oneSubscriber->id;
if (!empty($user->name)) {
$oneSubscriber->name = $user->name;
}
if ($oneSubscriber->confirmed || $confirmed) {
$oneSubscriber->confirmed = 1;
}
if (isset($user->receive_html)) {
$oneSubscriber->receive_html = $user->receive_html;
}
} elseif ($userId != 0) {
$oneSubscriber->user_id = $userId;
$subscriberId = jNews_Subscribers::getSubscriberIdFromUserId($userId);
$oneSubscriber->id = $subscriberId;
} else {
$oneSubscriber->user_id = JRequest::getInt('id');
$subscriberId = JRequest::getInt('subscriber_id');
if (empty($oneSubscriber->id)) {
$oneSubscriber->id = $subscriberId;
}
//newly added
}
jnews::objectHTMLSafe($oneSubscriber);
if ($subscriberId) {
//i need to update
return jNews_Subscribers::saveSubscriber($oneSubscriber, $subscriberId, false);
} else {
return jNews_Subscribers::saveSubscriber($oneSubscriber, $subscriberId, true);
}
}
function onAfterRoute()
{
$redirectlink = trim(JRequest::getString('redirectlink'));
$fromSubscribe = JRequest::getVar('fromSubscribe', '');
// this is either we have a redirect setup or we come from the module
if (empty($fromSubscribe) || empty($redirectlink)) {
return '';
}
if (strtolower(substr(JPATH_ROOT, strlen(JPATH_ROOT) - 13)) == 'administrator') {
$adminPath = strtolower(substr(JPATH_ROOT, strlen(JPATH_ROOT) - 13));
} else {
$adminPath = JPATH_ROOT;
}
if (!@(include_once $adminPath . DS . 'components' . DS . 'com_jnews' . DS . 'defines.php')) {
return;
}
include_once JNEWSPATH_CLASS . 'class.jnews.php';
require_once JNEWS_JPATH_ROOT_NO_ADMIN . DS . 'administrator' . DS . 'components' . DS . JNEWS_OPTION . DS . 'classes' . DS . 'class.subscribers.php';
require_once JNEWS_JPATH_ROOT_NO_ADMIN . DS . 'administrator' . DS . 'components' . DS . JNEWS_OPTION . DS . 'classes' . DS . 'class.listssubscribers.php';
jimport('joomla.html.parameter');
$db = JFactory::getDBO();
$plugin = JPluginHelper::getPlugin('system', 'vmjnewssubs');
$registry = new JRegistry();
if (!method_exists($registry, 'loadString')) {
$data = trim($plugin->params);
$options = array('processSections' => false);
if (substr($data, 0, 1) != '{' && substr($data, -1, 1) != '}') {
$ini = JRegistryFormat::getInstance('INI');
$obj = $ini->stringToObject($data, $options);
} else {
$obj = json_decode($data);
}
$registry->loadObject($obj);
} else {
$registry->loadString($plugin->params);
}
$params = $registry;
$reqfield = $params->get('reqfield', 'user_email');
$email = JRequest::getString('email');
$reqvalue = $reqfield == 'user_email' ? $email : JRequest::get($reqfield);
if (is_array($reqvalue)) {
//if we find any no we do no
if (empty($reqvalue)) {
return '';
}
foreach ($reqvalue as $resultArVal) {
if (empty($resultArVal)) {
return '';
}
}
} else {
if (empty($reqvalue) || empty($email) || in_array(strtolower($reqvalue), array('', '0', 'n', 'no', 'none', 'nein', 'non'))) {
return;
}
}
$user_id = JRequest::getInt('user_id');
$email = trim(strip_tags($email));
$fname = JRequest::getString('first_name', '');
$mname = JRequest::getString('middle_name', '');
$lname = JRequest::getString('last_name', '');
$name = '';
if (!empty($fname)) {
$name .= $fname . ' ';
}
if (!empty($mname)) {
$name .= $mname . ' ';
}
if (!empty($lname)) {
$name .= $lname;
}
$name = trim($name);
if (empty($name)) {
$name = JRequest::getVar('username');
}
$subscriber = new stdClass();
$subscriber->user_id = $user_id;
$subscriber->name = $name;
$subscriber->email = $email;
$subscriber->ip = jNews_Subscribers::getIP();
$subscriber->receive_html = 1;
$subscriber->confirmed = $GLOBALS[JNEWS . 'require_confirmation'] == '1' ? 0 : 1;
$subscriber->subscribe_date = time();
$subscriber->language_iso = 'eng';
$subscriber->timezone = '00:00:00';
$subscriber->blacklist = 0;
$subscriber->params = '';
$subscriber->admin_id = 62;
$status = jNews_Subscribers::saveSubscriber($subscriber, $user_id, true);
if (!$status) {
return;
}
$listsToSubscribe = $params->get('lists', '');
$listsToSubscribe = str_replace(' ', '', $listsToSubscribe);
if (!empty($listsToSubscribe)) {
$condition = ' WHERE `id` IN (' . $listsToSubscribe . ')';
} else {
$condition = '';
}
$query = 'SELECT `id`, `list_type`,`params` from `#__jnews_lists`' . $condition;
$db->setQuery($query);
$lsidstoinsert = $db->loadObjectList();
$error = $db->getErrorMsg();
if (!empty($error)) {
echo $error;
return false;
} else {
//use for masterlists
$listsA = array();
foreach ($lsidstoinsert as $lsid) {
$d['email'] = $subscriber->email;
//get the subscriber id which is newly inserted
jNews_Subscribers::getSubscriberIdFromEmail($d);
//subscriber_id from the inserted subscriber
if ($d['subscriberId'] > 0) {
$subscriber->id = $d['subscriberId'];
} else {
$subscriber->id = $subscriber->user_id;
}
if (!empty($lsid->params)) {
//use for masterlists
$listsA[] = $lsid->id;
} else {
//for non-masterlists
$subscriber->list_id = $lsid->id;
jNews_ListsSubs::saveToListSubscribers($subscriber);
}
if ($lsid->list_type == 2) {
$subscribe = array();
$subscribe[] = $lsid->id;
if (!empty($subscribe)) {
jNews_ListsSubs::subscribeARtoQueue($subscriber->id, $subscribe);
}
}
}
//end of foreach
if (!empty($listsA)) {
//we check if the social class file exists for the implementation of master lists
if (@(include_once JNEWSPATH_ADMIN . 'social' . DS . 'class.social.php')) {
if (class_exists('jNews_Social')) {
$listidSubsA = array();
$masterListSubscriber = new stdClass();
//we check if configuration for master lists is enabled
if ($GLOBALS[JNEWS . 'use_masterlists']) {
if ($GLOBALS[JNEWS . 'level'] > 1) {
//we validate if the user can be subscribed to the list then we return the masterlistid
//1 - MasterLists for all Potential Users
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 1, $listsA);
//2 - MasterLists for all Registered Subscribers
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 2, $listsA);
}
if ($GLOBALS[JNEWS . 'level'] > 2) {
//we validate if the user can be subscribed to the list then we return the masterlistid
//3 - MasterLists for all Front-end Subscribers
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 3, $listsA);
}
}
//we check first if $listidSubsA and if not empty we do the subscription to the lists
if (!empty($listidSubsA)) {
$masterListSubscriber->id = $subscriber->id;
$masterListSubscriber->list_id = $listidSubsA;
jNews_ListsSubs::saveToListSubscribers($masterListSubscriber);
}
}
}
}
}
}
public static function confirmRegistration($d)
{
if (!empty($d['subscriberId']) and !empty($d['cle'])) {
$qid[0] = $d['subscriberId'];
$subscriber = jNews_Subscribers::getSubscribersFromId($qid, false);
if (md5($subscriber->email) == $d['cle']) {
$subscriber->confirmed = 1;
$subscriber->name = addslashes($subscriber->name);
jNews_Subscribers::saveSubscriber($subscriber, $subscriber->id, false);
//&$subscriberId
}
if (!(require_once JNEWSPATH_CLASS . 'class.queue.php')) {
return false;
}
jNews_Queue::updateSuspendedQueue($subscriber->id);
}
return true;
}
$subscriber->timezone = '00:00:00';
$subscriber->blacklist = 0;
$subscriber->params = '';
$subscriber->admin_id = 62;
//notice columns
if ($GLOBALS[JNEWS . 'level'] > 2) {
//check if the version of jnews is pro
$subscriber->column1 = '';
$subscriber->column2 = '';
$subscriber->column3 = '';
$subscriber->column4 = '';
$subscriber->column5 = '';
}
//end if check if the version is pro
//jNews_Subscribers::insertSubscriber($subscriber, $subscriberId);
jNews_Subscribers::saveSubscriber($subscriber, $subscriberId, true, $listid);
//get subscriber info by passing the user id
$userInfo = jNews_Subscribers::getSubscriberInfoFromUserId($user->id);
} else {
}
//end if
//save the subscriber id and list to listssubscribers table
$subscriber->id = $userInfo->id;
$subscriber->list_id = $listid;
$subscriber->flexicontentFlag = true;
//a flag that the subscription is from a tenders subscription from the flexicontent module
$subscriber->params = $params;
jNews_ListsSubs::saveToListSubscribers($subscriber);
}
//clear jnews session
$mySess->clear('flexi_countries', 'JNEWLSETTER');
function onAfterStoreUser($user, $isnew, $success, $msg)
{
if ($success === false) {
return false;
}
if (strtolower(substr(JPATH_ROOT, strlen(JPATH_ROOT) - 13)) == 'administrator') {
$adminPath = strtolower(substr(JPATH_ROOT, strlen(JPATH_ROOT) - 13));
} else {
$adminPath = JPATH_ROOT;
}
if (!@(include_once $adminPath . DS . 'components' . DS . 'com_jnews' . DS . 'defines.php')) {
return;
}
include_once JNEWSPATH_CLASSN . 'class.jnews.php';
require_once JNEWS_JPATH_ROOT_NO_ADMIN . DS . 'administrator' . DS . 'components' . DS . JNEWS_OPTION . DS . 'classes' . DS . 'class.subscribers.php';
require_once JNEWS_JPATH_ROOT_NO_ADMIN . DS . 'administrator' . DS . 'components' . DS . JNEWS_OPTION . DS . 'classes' . DS . 'class.listssubscribers.php';
jimport('joomla.html.parameter');
$plugin =& JPluginHelper::getPlugin('user', 'jnewssyncuser');
$params = new JParameter($plugin->params);
$db =& JFactory::getDBO();
$subscriber = null;
$confirmed = 1;
if ($user['block']) {
$confirmed = 0;
}
$subscriber->email = trim(strip_tags($user['email']));
if (!empty($user['name'])) {
$subscriber->name = trim(strip_tags($user['name']));
}
if (empty($user['block'])) {
$subscriber->confirmed = 1;
}
$subscriber->user_id = $user['id'];
$subscriber->ip = jNews_Subscribers::getIP();
$subscriber->receive_html = 1;
$subscriber->confirmed = $confirmed;
$subscriber->subscribe_date = jnews::getNow();
$subscriber->language_iso = 'eng';
$subscriber->timezone = '00:00:00';
$subscriber->blacklist = 0;
//check if the version of jnews is pro
if ($GLOBALS[JNEWS . 'type'] == 'PRO') {
$subscriber->column1 = '';
$subscriber->column2 = '';
$subscriber->column3 = '';
$subscriber->column4 = '';
$subscriber->column5 = '';
}
//end if check if the version is pro
if (!$isnew and !empty($this->oldUser['email']) and $user['email'] != $this->oldUser['email']) {
$d['email'] = $this->oldUser['email'];
$infos = jNews_Subscribers::getSubscriberIdFromEmail($this->oldUser);
$subscriber->id = $infos['subscriberId'];
}
if ($isnew) {
//new registered user
$status = jNews_Subscribers::saveSubscriber($subscriber, $subscriber->user_id, true);
if (empty($subscriber->id)) {
$subscriber->id = jNews_Subscribers::getSubscriberIdFromUserId($subscriber->user_id);
}
if (!$status) {
return;
}
$listsToSubscribe = $params->get('lists', '');
if (!empty($listsToSubscribe)) {
$condition = ' WHERE `id` IN (' . $listsToSubscribe . ')';
} else {
$condition = ' WHERE `auto_add` > 0';
}
//get list ids of auto_add lists
$query = 'SELECT `id`, `list_type`, `params` from `#__jnews_lists`' . $condition;
$db->setQuery($query);
$autoListId = $db->loadObjectList();
$error = $db->getErrorMsg();
if (!empty($error)) {
echo $error;
return false;
} else {
//use for masterlists
$listsA = array();
foreach ($autoListId as $autoId) {
if (!empty($autoId->params)) {
//use for masterlists
$listsA[] = $autoId->id;
} else {
//for non-masterlists
$subscriber->list_id = $autoId->id;
jNews_ListsSubs::saveToListSubscribers($subscriber);
}
if ($autoId->list_type == 2) {
$subscribe = array();
$subscribe[] = $autoId->id;
if (!empty($subscribe)) {
jNews_ListsSubs::subscribeARtoQueue($subscriber->id, $subscribe);
}
}
}
//end of foreach
}
if (!empty($listsA)) {
//we check if the social class file exists for the implementation of master lists
if (@(include_once JNEWSPATH_ADMIN . 'social' . DS . 'class.social.php')) {
if (class_exists('social')) {
$listidSubsA = array();
$masterListSubscriber = null;
//we check if configuration for master lists is enabled
if ($GLOBALS[JNEWS . 'use_masterlists']) {
if ($GLOBALS[JNEWS . 'type'] == 'PLUS' || $GLOBALS[JNEWS . 'type'] == 'PRO') {
//we validate if the user can be subscribed to the list then we return the masterlistid
//1 - MasterLists for all Potential Users
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 1, $listsA);
//2 - MasterLists for all Registered Subscribers
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 2, $listsA);
}
if ($GLOBALS[JNEWS . 'type'] == 'PRO') {
//we validate if the user can be subscribed to the list then we return the masterlistid
//3 - MasterLists for all Front-end Subscribers
$listidSubsA[] = jNews_Social::includeMasterListIds($subscriber->id, 3, $listsA);
}
}
$masterListSubscriber->id = $subscriber->id;
$masterListSubscriber->list_id = $listidSubsA;
jNews_ListsSubs::saveToListSubscribers($masterListSubscriber);
}
}
}
} else {
//confirmed registered user
// if(!empty($this->oldUser['block']) AND !empty($subscriber->confirmed)){
if (empty($subscriber->id)) {
$subscriber->id = jNews_Subscribers::getSubscriberIdFromUserId($subscriber->user_id);
}
plgUserjNewssyncuser::_confirmUserSubscription($subscriber->id);
// }
}
//endelse
return true;
}
public static function upgrade_News3()
{
$my = JFactory::getUser();
$db = JFactory::getDBO();
$xf = new jNews_Config();
$newLists = array();
$idImportedList = array();
$i = 0;
$db->setQuery("SELECT * FROM #__yanc_letters");
$newsletters = $db->loadObjectList();
$error = $db->getErrorMsg();
$newSubscriber = null;
$list = null;
$mailings = null;
$subscriberId = 0;
$total = 0;
if (!empty($error)) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3 () line ' . __LINE__ . '):</b> Error getting newsletters. Database error: <br />' . $error . '</p>';
return false;
} else {
foreach ($newsletters as $newsletter) {
$list->list_name = $newsletter->list_name;
$list->list_desc = $newsletter->list_desc;
$list->sendername = $newsletter->sendername;
$list->senderemail = $newsletter->senderemail;
$list->bounceadres = $newsletter->bounceadres;
$list->layout = $newsletter->layout;
$list->template = 0;
$list->subscribemessage = $newsletter->subscribemessage;
$list->unsubscribemessage = $newsletter->unsubscribemessage;
$list->notifyadminmsg = $newsletter->notifyadminmsg;
$list->html = $newsletter->html;
$list->hidden = !$newsletter->hidden;
$list->unsubscribesend = 1;
$list->unsubscribenotifyadmin = 1;
$list->list_type = '1';
$list->auto_add = 0;
$list->user_choose = 0;
$list->cat_id = '0:0';
$list->delay_min = 0;
$list->delay_max = 0;
$list->follow_up = 0;
$list->owner = $my->id;
$list->acc_level = $newsletter->aid;
$list->acc_id = 29;
$list->published = 1;
$list->createdate = time();
$list->footer = 1;
$list->notify_id = 0;
$list->notification = 0;
$query = 'INSERT INTO `#__jnews_lists` (`list_name`) VALUES (\'' . $list->list_name . '\' )';
$db->setQuery($query);
$db->query();
$error = $db->getErrorMsg();
if (!empty($error)) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3() line ' . __LINE__ . '):</b> Error adding list to database. Database error: <br />' . $error . '</p><br /><br />Are you trying to insert a list name which is already in use? The list name has to be different for each list! <br /><br />';
} else {
$query = 'SELECT * FROM `#__jnews_lists` WHERE `list_name`= \'' . $list->list_name . '\'';
$db->setQuery($query);
$mynewlist = $db->loadObject();
$error = $db->getErrorMsg();
$xf->plus('totallist0', 1);
$xf->plus('act_totallist0', 1);
$xf->plus('totallist1', 1);
$xf->plus('act_totallist1', 1);
if (!empty($error)) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3() line ' . __LINE__ . '):</b> Error getting listname. Database error: <br />' . $error . '</p>';
return false;
} else {
$idImportedList[$newsletter->id] = $mynewlist->list_id;
$newLists[$i] = $mynewlist->list_id;
$i++;
$list->id = $mynewlist->list_id;
$error = jNews_Lists::updateListData($list);
if (!$error) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3 () line ' . __LINE__ . '):</b> Error inserting list. Database error: <br />' . $error . '</p>';
} else {
echo '<br /><b>' . @constant($GLOBALS[JNEWS . 'listnames1']) . ': </b>' . $list->list_name . ': ' . jnews::printM('green', _JNEWS_IMPORT_SUCCESS);
$db->setQuery("SELECT * FROM #__yanc_letters WHERE `list_id`=" . $newsletter->id);
$mailingsImports = $db->loadObjectList();
$error = $db->getErrorMsg();
if (!empty($error)) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3() line ' . __LINE__ . '):</b> Error getting mailings. Database error: <br />' . $error . '</p>';
return false;
} else {
$issue_nb = 1;
foreach ($mailingsImports as $mailingsImport) {
$mailings->list_id = $mynewlist->list_id;
$mailings->list_type = '1';
$mailings->send_date = $mailingsImport->send_date;
$mailings->subject = $mailingsImport->subject;
$mailings->htmlcontent = $mailingsImport->htmlcontent;
$mailings->textonly = $mailingsImport->textonly;
$mailings->attachments = $mailingsImport->attachments;
$mailings->images = $mailingsImport->images;
$mailings->published = $mailingsImport->published;
$mailings->visible = $mailingsImport->visible;
$mailings->html = $mynewlist->html;
$mailings->fromname = $list->sendername;
$mailings->fromemail = $list->senderemail;
$mailings->frombounce = $list->bounceadres;
$mailings->author_id = $my->id;
$mailings->delay = 0;
$mailings->issue_nb = $issue_nb;
$mailings->acc_level = 25;
$mailings->createdate = $list->createdate;
$issue_nb++;
$error = jNews_Mailing::insertMailingData($mailings);
if (!$error) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3() line ' . __LINE__ . '):</b> Error inserting mailing. Database error: <br />' . $error . '</p>';
} else {
echo '<br /><b>' . _JNEWS_MENU_MAILING_TITLE . ': </b>' . $mailingsImport->subject . ': ' . jnews::printM('green', _JNEWS_IMPORT_SUCCESS);
}
}
}
}
}
}
}
$db->setQuery("SELECT * FROM #__yanc_subscribers");
$subscribers = $db->loadObjectList();
$error = $db->getErrorMsg();
if (!empty($error)) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3() line ' . __LINE__ . '):</b> Error getting subscribers. Database error: <br />' . $error . '</p>';
return false;
} else {
foreach ($subscribers as $subscriber) {
$newSubs = true;
$jnewssubscribers = jNews_Subscribers::getSubscribers(-1, -1, '', $total, 0, '', '', '', '', '');
//added one parameter for mailid
foreach ($jnewssubscribers as $jnewssubscriber) {
if ($subscriber->subscriber_email == $jnewssubscriber->email) {
$newSubs = false;
$subId[0] = $jnewssubscriber->id;
}
}
if ($newSubs) {
$newSubscriber->user_id = $subscriber->userid;
$newSubscriber->name = $subscriber->subscriber_name;
$newSubscriber->email = $subscriber->subscriber_email;
$newSubscriber->ip = $subscriber->ip;
$newSubscriber->receive_html = $subscriber->receive_html;
$newSubscriber->confirmed = $subscriber->confirmed;
$newSubscriber->subscribe_date = $subscriber->subscribe_date;
$newSubscriber->blacklist = 0;
$newSubscriber->timezone = '00:00:00';
$newSubscriber->language_iso = 'eng';
$newSubscriber->params = '';
if ($GLOBALS[JNEWS . 'level'] > 2) {
//check if the version of jnews is pro
$newSubscriber->column1 = $newSubscriber->column1;
$newSubscriber->column2 = $newSubscriber->column2;
$newSubscriber->column3 = $newSubscriber->column3;
$newSubscriber->column4 = $newSubscriber->column4;
$newSubscriber->column5 = $newSubscriber->column5;
}
//end if for check version pro
$error = jNews_Subscribers::saveSubscriber($newSubscriber, $subscriberId, true);
if (!empty($error)) {
if ($subscriberId < 1) {
echo ' Error inserting subscriber:' . $newSubscriber->name;
}
$error = '';
$subId[0] = $subscriberId;
} else {
echo '<br /><b>' . _JNEWS_MENU_SUBSCRIBERS . ': </b>' . $newSubscriber->name . ': ' . jnews::printM('green', _JNEWS_IMPORT_SUCCESS);
$d['email'] = $subscriber->email;
jNews_Subscribers::getSubscriberIdFromEmail($d);
$subId[0] = $d['subscriberId'];
}
} else {
echo '<br /><b>' . _JNEWS_MENU_SUBSCRIBERS . ': </b>' . $subscriber->subscriber_name . ': ' . jnews::printM('red', _JNEWS_IMPORT_EXIST);
}
$j = 0;
$queue = jNews_ListsSubs::getListSubscriberInfo($subId[0], $idImportedList[$subscriber->list_id]);
if (empty($queue)) {
$error = jNews_Queue::insertQueuesForNews($subId, $idImportedList[$subscriber->list_id], 29);
if (!$error) {
echo '<p><b>Error (class.upgrade.php->upgrade_News3 () line ' . __LINE__ . '):</b> Error inserting queue. Database error: <br />' . $error . '</p>';
}
}
}
}
}
return true;
}
