public function getInput() { jimport('joomla.filesystem.file'); if (!JFile::exists(JPATH_ADMINISTRATOR . '/components/com_joomailermailchimpintegration/libraries/MCAPI.class.php')) { $app = JFactory::getApplication(); $app->enqueueMessage(JText::_('PLG_USER_JOOMLAMAILER_INSTALL_JOOMLAMAILER'), 'error'); $app->redirect('index.php?option=com_plugins'); } else { $listid = $this->form->getValue('listid', 'params'); require_once JPATH_ADMINISTRATOR . '/components/com_joomailermailchimpintegration/libraries/MCAPI.class.php'; $params = JComponentHelper::getParams('com_joomailermailchimpintegration'); $MCapi = $params->get('params.MCapi'); $api = new joomlamailerMCAPI($MCapi); $fields = $api->listMergeVars($listid); if ($fields) { $options = array(); foreach ($fields as $field) { if (!in_array($field['tag'], array('EMAIL', 'FNAME', 'LNAME', 'SIGNUPAPI'))) { $options[] = array('tag' => $field['tag'], 'name' => $field['name']); } } if (count($options)) { return JHtml::_('select.genericlist', $options, 'jform[params][fields][]', 'multiple="multiple"', 'tag', 'name', $this->value, $this->id); } } return JText::_('PLG_USER_JOOMLAMAILER_NO_MERGE_VARS'); } }
public function getInput() { jimport('joomla.filesystem.file'); $mainframe = JFactory::getApplication(); if (!JFile::exists(JPATH_ADMINISTRATOR . '/components/com_joomailermailchimpintegration/libraries/MCAPI.class.php')) { $mainframe->enqueueMessage(JText::_('JM_PLEASE_INSTALL_JOOMLAMAILER'), 'error'); $mainframe->redirect('index.php'); } $listId = $this->form->getValue('listid', 'params'); require_once JPATH_ADMINISTRATOR . '/components/com_joomailermailchimpintegration/libraries/MCAPI.class.php'; $params = JComponentHelper::getParams('com_joomailermailchimpintegration'); $MCapi = $params->get('params.MCapi'); $api = new joomlamailerMCAPI($MCapi); $fields = $api->listMergeVars($listId); $options = array(); if ($fields) { foreach ($fields as $field) { $choices = ''; if (isset($field['choices'])) { $choices = implode('##', $field['choices']); } $req = $field['req'] ? 1 : 0; $tag = $field['tag'] . ';' . $field['field_type'] . ';' . $field['name'] . ';' . $req . ';' . $choices; // force email field to be pre-selected if ($field['tag'] == 'EMAIL') { $this->value[] = $tag; } $options[] = array('tag' => $tag, 'name' => $field['name']); } } return JHtml::_('select.genericlist', $options, 'jform[params][fields][]', 'multiple="multiple"', 'tag', 'name', $this->value, $this->id); }
function fetchElement($name, $value, &$node, $control_name) { jimport( 'joomla.filesystem.file' ); $mainframe = & JFactory::getApplication(); if(!JFile::exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_joomailermailchimpintegration'.DS.'libraries'.DS.'MCAPI.class.php')) { $mainframe->redirect('index.php',JText::_('JM_PLEASE_INSTALL_JOOMLAMAILER'),'error'); } else { jimport('joomla.plugin.plugin'); $pluginParams = new JParameter( $this->_parent->_raw ); $listid = $pluginParams->get('listid'); require_once( JPATH_ADMINISTRATOR.DS.'components'.DS.'com_joomailermailchimpintegration'.DS.'libraries'.DS.'MCAPI.class.php'); $params = & JComponentHelper::getParams('com_joomailermailchimpintegration'); $apikey = $params->get('MCapi'); $api = new joomlamailerMCAPI($apikey); $fields = $api->listMergeVars( $listid ); $value = $pluginParams->get('fields'); $key = 'tag'; $val = 'name'; $options = false; if($fields) { foreach ($fields as $field){ //if ($field['form_field']!='hidden') { if ($field['field_type'] != 'email') { $options[]=array($key=>$field[$key],$val=>$field[$val]); } //} } } $ctrl = $control_name .'['. $name .']'; $attribs = 'multiple="multiple"'; $control_name = 'params'; $ctrl .= '[]'; if($options){ $content = JHTML::_('select.genericlist',$options, $ctrl, $attribs, $key, $val, $value, $control_name.$name); } else { $content = JText::_('JM_NO_MERGE_VARS'); } return $content; } }
function fetchElement($name, $value, &$node, $control_name) { jimport( 'joomla.filesystem.file' ); $mainframe = & JFactory::getApplication(); $option = JRequest::getCmd('option'); if(!JFile::exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_joomailermailchimpintegration'.DS.'libraries'.DS.'MCAPI.class.php')) { $mainframe->redirect('index.php',JText::_('JM_PLEASE_INSTALL_JOOMLAMAILER'),'error'); } else { $moduleParams = new JParameter( $this->_parent->_raw ); $listid = $moduleParams->get('listid'); require_once( JPATH_ADMINISTRATOR.DS.'components'.DS.'com_joomailermailchimpintegration'.DS.'libraries'.DS.'MCAPI.class.php'); $params = & JComponentHelper::getParams('com_joomailermailchimpintegration'); $apikey = $params->get('MCapi'); $api = new joomlamailerMCAPI($apikey); $fields = $api->listMergeVars( $listid ); $value = $moduleParams->get('fields'); $key = 'tag'; $val = 'name'; $options = false; if($fields) { foreach ($fields as $field){ $choices = ''; if(isset($field['choices'])){ foreach($field['choices'] as $c){ $choices .= $c.'##'; } $choices = substr($choices,0,-2); } $req = ($field['req'])?1:0; if($field[$key]=='EMAIL') { if( !is_array($value)){ $oldValue = $value; $value = array(); $value[] = $oldValue; } $value[] = $field[$key].';'.$field['field_type'].';'.$field['name'].';'.$req.';'.$choices; } $options[]=array($key=>$field[$key].';'.$field['field_type'].';'.$field['name'].';'.$req.';'.$choices,$val=>$field[$val]); } } $ctrl = $control_name .'['. $name .']'; $attribs = 'multiple="multiple"'; $ctrl .= '[]'; if($options){ $content = JHTML::_('select.genericlist',$options, $ctrl, $attribs, $key, $val, $value, $control_name.$name); $content .= '<script type="text/javascript"> window.addEvent(\'domready\',function() { $("'.$control_name.$name.'").addEvent( \'change\', function(){ $("'.$control_name.$name.'").options[0].setProperty(\'selected\', \'selected\'); }); }); </script>'; } else { $content = JText::_('JM_NO_FIELDS'); } return $content; } }
public function ajaxSyncAll() { $done = JRequest::getVar('done', '', 'POST', 'int'); if ($done == 0) { $_SESSION['abortAJAX'] = 0; unset($_SESSION['addedUsers']); } if ($_SESSION['abortAJAX'] != 1) { $db = JFactory::getDBO(); $params = JComponentHelper::getParams('com_joomailermailchimpintegration'); $MCapi = $params->get('params.MCapi'); $MC = new joomlamailerMCAPI($MCapi); $MCerrorHandler = new MCerrorHandler(); $listId = JRequest::getVar('listId', '', 'POST', 'string'); $total = JRequest::getVar('total', 0, 'POST', 'int'); $errors = JRequest::getVar('errors', 0, 'POST', 'int'); $step = JRequest::getVar('step', 100, 'POST', 'int'); $failed = JRequest::getVar('failed', array(), 'POST'); $addedUsers = JRequest::getVar('addedUsers', array(), 'POST'); $errorMsg = JRequest::getVar('errorMsg', '', 'POST', 'string'); if (!$addedUsers) { $addedUsers = array(); } // create hidden signup date merge var if it doesn't exist $createSignupdateMerge = true; $mergeVars = $MC->listMergeVars($listId); foreach ($mergeVars as $mv) { if ($mv['tag'] == 'SIGNUPAPI') { $createSignupdateMerge = false; break; } } if ($createSignupdateMerge) { $MC->listMergeVarAdd($listId, 'SIGNUPAPI', 'date added (API)', array('date', false, false, true)); } if (isset($_SESSION['addedUsers'])) { $exclude = $_SESSION['addedUsers']; } else { $exclude = array(); } if (!$failed) { $failed = array(); } if (count($failed)) { $exclude = array_merge($exclude, $failed); } $query = $db->getQuery(true)->select($db->qn(array('id', 'email')))->from($db->qn('#__users'))->where($db->qn('block') . ' = ' . $db->q(0))->where($db->qn('id') . ' NOT IN ("' . implode('","', $exclude) . '")'); $db->setQuery($query, 0, $step); $users = $db->loadObjectList(); $userIds = array(); foreach ($users as $user) { $userIds[$user->email] = $user->id; } // gather custom fields data $query = $db->getQuery(true)->select('*')->from($db->qn('#__joomailermailchimpintegration_custom_fields'))->where($db->qn('listid') . ' = ' . $db->q($listId)); $db->setQuery($query); $customFields = $db->loadObjectList(); $m = $successCount = $errorcount = $msgErrorsCount = $counter = 0; $msg = $msgErrors = false; $ids = ''; for ($x = 0; $x < count($users); $x += $step) { if ($_SESSION['abortAJAX'] == 1) { unset($_SESSION['addedUsers']); break; } $k = $errorcount = $msgErrorsCount = 0; $batch = array(); for ($y = $x; $y < $x + $step; $y++) { if ($_SESSION['abortAJAX'] == 1) { unset($_SESSION['addedUsers']); break; } $dat = isset($users[$y]) ? $users[$y] : false; if ($dat) { $user = $this->getModel('sync')->getUser($dat->id); $addedUsers[] = $user[0]->id; $batch[$k]['EMAIL'] = $user[0]->email; // name $names = explode(' ', $user[0]->name); if (isset($names[0]) && isset($names[1])) { $batch[$k]['FNAME'] = $names[0]; $batch[$k]['LNAME'] = ''; for ($i = 1; $i < count($names); $i++) { $batch[$k]['LNAME'] .= $names[$i] . ' '; } } else { $batch[$k]['FNAME'] = $user[0]->name; } if (count($customFields)) { foreach ($customFields as $field) { $query = $db->getQuery(true); if ($field->framework == 'CB') { $query->select($db->qn($field->dbfield))->from($db->qn('#__comprofiler'))->where($db->qn('user_id') . ' = ' . $db->q($user[0]->id)); } else { $query->select($db->qn('value'))->from($db->qn('#__community_fields_values'))->where($db->qn('field_id') . ' = ' . $db->q($field->dbfield))->where($db->qn('user_id') . ' = ' . $db->q($user[0]->id)); } $db->setQuery($query); $fieldValue = $db->loadResult(); if ($field->framework == 'CB') { $fieldValue = str_replace('|*|', ',', $fieldValue); } if ($field->framework == 'JS') { if ($fieldValue == NULL) { $fieldValue = ''; } else { $fieldValue = substr($fieldValue, strlen($fieldValue) - 1) == ',' ? $fieldValue = substr($fieldValue, 0, -1) : $fieldValue; } } if ($field->type == 'group') { $batch[$k]['GROUPINGS'][] = array('id' => $field->grouping_id, 'groups' => $fieldValue); } else { $batch[$k][$field->grouping_id] = $fieldValue; } } } // add signup date $batch[$k]['SIGNUPAPI'] = date('Y-m-d'); $query = $db->getQuery(true); try { $query->insert($db->qn('#__joomailermailchimpintegration'))->set($db->qn('userid') . ' = ' . $db->q($user[0]->id))->set($db->qn('email') . ' = ' . $db->q($user[0]->email))->set($db->qn('listid') . ' = ' . $db->q($listId)); $db->setQuery($query); $db->execute(); } catch (Exception $e) { } $k++; } else { break; } } if ($batch) { $optin = false; // do not send optin emails $updateExisting = true; // yes, update currently subscribed users $replaceInterests = true; // false = add interest, don't replace $result = $MC->listBatchSubscribe($listId, $batch, $optin, $updateExisting, $replaceInterests); $successCount = $successCount + $result['success_count']; if ($result['error_count']) { foreach ($result['errors'] as $e) { $tmp = new stdClass(); $tmp->errorCode = $e['code']; $tmp->errorMessage = $e['message']; $errorMsg .= '"' . $MCerrorHandler->getErrorMsg($tmp) . ' => ' . $e['row']['EMAIL'] . '", '; $query->getQuery(true); $query->delete($db->qn('#__joomailermailchimpintegration'))->where($db->qn('listid') . ' = ' . $db->q($listId))->where($db->qn('email') . ' = ' . $db->q($e['row']['EMAIL'])); $db->setQuery($query, 0, 1); $db->execute(); $addedUsers = array_diff($addedUsers, array($userIds[$e['row']['EMAIL']])); $failed[] = $userIds[$e['row']['EMAIL']]; $errorcount++; } $msgErrorsCount += $result['error_count']; } } } if (!count($users)) { $done = $total; unset($_SESSION['addedUsers']); $percent = 100; } else { $done = count($addedUsers); $_SESSION['addedUsers'] = $addedUsers; $percent = $done / $total * 100; } $response['msg'] = '<div id="bg"></div>' . '<div id="progressBarContainer">' . '<div id="progressBarTitle">' . JText::_('JM_ADDING_USERS') . ' (' . $done . '/' . $total . ' ' . JText::_('JM_DONE') . ')</div>' . '<div id="progressBarBg">' . '<div id="progressBarCompleted" style="width: ' . round($percent) . '%;"></div>' . '<div id="progressBarNumber">' . round($percent) . ' %</div>' . '</div>' . '<a id="sbox-btn-close" href="javascript:joomlamailerJS.sync.abortAJAX();">abort</a>' . '</div>'; $response['done'] = $done; // $msg = $successCount.' '.JText::_('JM_RECIPIENTS_SAVED').$msgErrors; $response['errors'] = count($failed); $response['errorMsg'] = $errorMsg; $response['addedUsers'] = array_values($addedUsers); $response['failed'] = $failed; if ($done + count($failed) + $errors >= $total) { $response['finished'] = 1; if ($errorMsg) { $errorMsg = substr($errorMsg, 0, -2); $msgErrors = ' (' . count($failed) . ' ' . JText::_('JM_ERRORS') . ': ' . $errorMsg . ')'; } if (!$msg) { $msg = $done . ' ' . JText::_('JM_RECIPIENTS_SAVED'); } if ($msgErrors) { $msg .= $msgErrors; } $response['finalMessage'] = $msg; } else { $response['finished'] = 0; $response['finalMessage'] = ''; } $response['abortAJAX'] = $_SESSION['abortAJAX']; echo json_encode($response); } else { unset($_SESSION['addedUsers']); $response['finished'] = 1; $response['addedUsers'] = ''; $response['abortAJAX'] = $_SESSION['abortAJAX']; echo json_encode($response); } }
function register_save() { $option = JRequest::getCmd('option'); $extension = JRequest::getVar('component'); $extension = version_compare(JVERSION, '1.6.0', 'ge') && $extension == 'com_user' ? 'com_users' : $extension; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $lang =& JFactory::getLanguage(); $task = JRequest::getVar('oldtask'); //com_user if ($extension == 'com_user' || $extension == 'com_users') { if (version_compare(JVERSION, '1.6.0', 'ge')) { $jform = JRequest::getVar('jform'); $name = $jform['name']; $email_address = $jform['email1']; } else { $name = JRequest::getVar('name'); $email_address = JRequest::getVar('email'); } $name = explode(' ', $name); $email_address = $email_address; $controller = '/controller.php'; $cname = version_compare(JVERSION, '1.6.0', 'ge') ? 'UsersController' : 'UserController'; $lang->load($extension, JPATH_BASE); //Jomsocial } elseif ($extension == 'com_community') { if ($user->email) { $email_address = $user->email; $name = explode(' ', $user->name); $_POST['view'] = 'profile'; } else { $query = 'SELECT token FROM #__community_register_auth_token WHERE auth_key="' . $_POST['authkey'] . '"'; $db->setQuery($query); $token = $db->loadResult(); $query = 'SELECT name, email FROM #__community_register WHERE token="' . $token . '"'; $db->setQuery($query); $details = $db->loadAssocList(); $name = explode(' ', $details[0]['name']); $email_address = $details[0]['email']; } $cntrllr = JRequest::getVar('cntrllr'); $controller = '/controllers/' . $cntrllr . '.php'; $cname = 'Community' . strtoupper($cntrllr[0]) . substr($cntrllr, 1) . 'Controller'; $this->_name = str_replace('com_', '', $extension); require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'controllers' . DS . 'controller.php'; require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'libraries' . DS . 'core.php'; require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'libraries' . DS . 'template.php'; require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'views' . DS . 'views.php'; require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'views' . DS . 'register' . DS . 'view.html.php'; require_once JPATH_SITE . DS . 'components' . DS . $extension . DS . 'views' . DS . 'profile' . DS . 'view.html.php'; $lang->load($extension, JPATH_BASE); $_POST['option'] = $extension; $_POST['task'] = $task; $view = JRequest::getCmd('view'); //Community Builder } elseif ($extension == 'com_comprofiler') { $name[0] = JRequest::getVar('firstname'); $name[1] = JRequest::getVar('lastname'); $name = explode(' ', JRequest::getVar('name')); $email_address = JRequest::getVar('email'); $controller = '/comprofiler.php'; $cname = 'Comprofiler'; $_POST['option'] = $extension; $GLOBALS['_JREQUEST']['option'] = array('DEFAULTCMD0' => 'com_comprofiler'); $cbtask = JRequest::getVar('oldtask'); } elseif ($extension == 'com_virtuemart') { $name[0] = JRequest::getVar('first_name'); $name[1] = JRequest::getVar('middle_name'); $name[2] = JRequest::getVar('last_name'); $email_address = JRequest::getVar('email'); } $email_address_old = JRequest::getVar('oldEmail', $email_address); $fname = $name[0]; $lname = ''; if (isset($name[1])) { for ($i = 1; $i < count($name); $i++) { $lname .= $name[$i] . ' '; } $lname = trim($lname); } //Create the api object $params =& JComponentHelper::getParams('com_joomailermailchimpintegration'); $paramsPrefix = version_compare(JVERSION, '1.6.0', 'ge') ? 'params.' : ''; $MCapi = $params->get($paramsPrefix . 'MCapi'); $api = new joomlamailerMCAPI($MCapi); //Get the ID of the mailing list jimport('joomla.html.parameter'); $plugin =& JPluginHelper::getPlugin('system', 'joomailermailchimpsignup'); $pluginParams = new JParameter($plugin->params); $listId = $pluginParams->get('listid'); //Check if the user is already logged in and subscribed if ($user->email) { $userlists = $api->listsForEmail($email_address_old); if ($userlists && in_array($listId, $userlists)) { $sub = 1; } } //User wishes to subscribe/update interests if (isset($_POST['newsletter'])) { $double_optin = false; $update_existing = false; $replace_interests = false; $send_welcome = false; //Get merge vars from API $fields = $api->listMergeVars($listId); $fieldids = $pluginParams->get('fields'); $key = 'tag'; $val = 'name'; //Get interests from API $interests = $api->listInterestGroupings($listId); $interestids = $pluginParams->get('interests'); $groupings = array(); $merges = array(); if ($extension == 'com_user' || $extension == 'com_users') { //Default registration if ($fields) { foreach ($fields as $f) { if (isset($_POST['mf_' . $f['tag']])) { $val = $_POST['mf_' . $f['tag']]; $merges[$f['tag']] = $val; } } } if ($interests) { foreach ($interests as $i) { if ($_POST['interest_' . $i['id']]) { $groups = ''; if (is_array($_POST['interest_' . $i['id']])) { foreach ($_POST['interest_' . $i['id']] as $g) { //var_dump($i['groups']);die; foreach ($i['groups'] as $gg) { if ($g == $gg['bit']) { $groups .= $gg['name'] . ','; } } } $groups = substr($groups, 0, -1); $groupings[$i['name']] = array('name' => $i['name'], 'id' => $i['id'], 'groups' => $groups); } else { foreach ($i['groups'] as $gg) { if ($_POST['interest_' . $i['id']] == $gg['bit']) { $groups .= $gg['name']; } } $groupings[$i['name']] = array('name' => $i['name'], 'id' => $i['id'], 'groups' => $groups); } } } } } elseif ($extension == 'com_comprofiler' || $extension == 'com_community' || $extension == 'com_virtuemart') { //Get custom fields $query = 'SELECT dbfield, grouping_id as gid, type, framework FROM #__joomailermailchimpintegration_custom_fields WHERE listID="' . $listId . '"'; $db->setQuery($query); $customfields = $db->loadAssocList(); if ($customfields) { //loop over groupings if ($interests) { foreach ($interests as $i) { foreach ($customfields as $cf) { if ($cf['type'] == 'group') { if ($i['id'] == $cf['gid']) { $groups = ''; if ($extension == 'com_comprofiler' && $cf['framework'] == 'CB' || $extension == 'com_virtuemart' && $cf['framework'] == 'VM') { $field = $_POST[$cf['dbfield']]; } else { if (isset($_POST['field' . $cf['dbfield']])) { $field = $_POST['field' . $cf['dbfield']]; } } if (isset($field) && is_array($field)) { foreach ($field as $g) { foreach ($i['groups'] as $gg) { if ($g == $gg['name']) { $groups .= $gg['name'] . ','; } } } $groups = substr($groups, 0, -1); } else { foreach ($i['groups'] as $gg) { if (isset($field) && $field == $gg['name']) { $groups .= $gg['name']; } } } $groupings[$i['name']] = array('name' => $i['name'], 'id' => $i['id'], 'groups' => $groups); } } } } } } //loop over merge vars if ($fields) { foreach ($fields as $f) { foreach ($customfields as $cf) { if ($cf['type'] == 'field') { if ($f['tag'] == strtoupper($cf['gid'])) { if ($extension == 'com_comprofiler' && $cf['framework'] == 'CB' || $extension == 'com_virtuemart' && $cf['framework'] == 'VM') { if ($f['field_type'] == 'date') { if ($extension == 'com_virtuemart') { $valDay = $_POST['birthday_selector_day']; $valMonth = $_POST['birthday_selector_month']; $valYear = $_POST['birthday_selector_year']; $val = $valMonth . '/' . $valDay . '/' . $valYear; } else { $val = $_POST[$cf['dbfield']]; } $merges[$f['tag']] = substr($val, 3, 2) . '-' . substr($val, 0, 2) . '-' . substr($val, 6, 4); } else { $val = $_POST[$cf['dbfield']]; $merges[$f['tag']] = $val; } } else { if (isset($_POST['field' . $cf['dbfield']])) { $val = $_POST['field' . $cf['dbfield']]; if ($f['field_type'] == 'date') { $merges[$f['tag']] = $val[2] . '-' . $val[1] . '-' . $val[0]; } else { $merges[$f['tag']] = $val; } } } } } } } } } //If this is a new user then subscribe the user at activation if (!$user->id) { $merges_string = ''; if ($merges) { foreach ($merges as $k => $v) { $merges_string .= "name=" . $k . "\n"; if (is_array($v)) { $merges_string .= "value="; foreach ($v as $vv) { $merges_string .= $vv . "||"; } } else { $merges_string .= "value=" . $v; } $merges_string .= "\n\n"; } } $groupings_string = ''; foreach ($groupings as $g) { $groupings_string .= 'name=' . $g['name'] . "\n"; $groupings_string .= 'id=' . $g['id'] . "\n"; $groupings_string .= 'groups=' . $g['groups'] . "\n" . '||' . "\n"; } $groupings_string = substr($groupings_string, 0, -3); $merges_string = substr($merges_string, 0, -2); $query = "INSERT INTO #__joomailermailchimpsignup (fname,lname,email,groupings,merges)\r\n\t\t\t VALUES ('" . $fname . "','" . $lname . "','" . $email_address . "','" . $groupings_string . "','" . $merges_string . "')"; $db->setQuery($query); $db->query(); //Otherwise workout whether to update or subscribe the user } else { //Get the users ip address $ip = $this->get_ip_address(); $merge_vars = array('FNAME' => $fname, 'LNAME' => $lname, 'INTERESTS' => '', 'GROUPINGS' => $groupings, 'OPTINIP' => $ip); $merge_vars = array_merge($merge_vars, $merges); $email_type = ''; if (!isset($sub)) { //Subscribe the user $retval = $api->listSubscribe($listId, $email_address, $merge_vars, $email_type, $double_optin, $update_existing, $replace_interests, $send_welcome); $query = 'INSERT INTO #__joomailermailchimpintegration VALUES ("", ' . $user->id . ', "' . $email_address . '", "' . $listId . '")'; $db->setQuery($query); $db->Query(); } else { //Update the users subscription // email address changed in CB? if (($extension == 'com_comprofiler' || $extension == 'com_user' || $extension == 'com_users') && $email_address != $email_address_old) { // update local database entry $query = 'UPDATE #__joomailermailchimpintegration SET email = "' . $email_address . '" WHERE email="' . $email_address_old . '" AND listid = "' . $listId . '"'; $db->setQuery($query); $db->query(); // add new email address to merge vars array $merge_vars['EMAIL'] = $email_address; $email_address = $email_address_old; } $retval = $api->listUpdateMember($listId, $email_address, $merge_vars, $email_type, true); } } //User wishes to unsubscribe } elseif (!isset($_POST['newsletter']) && isset($sub)) { $api->listUnsubscribe($listId, $email_address, false, false, false); $query = 'DELETE FROM #__joomailermailchimpintegration WHERE email="' . $email_address . '" AND listid = "' . $listId . '"'; $db->setQuery($query); $db->query(); } if ($api->errorCode && $api->errorCode != 215 && $api->errorCode != 211) { echo "Unable to load listSubscribe()!\n"; echo "\tCode=" . $api->errorCode . "\n"; echo "\tMsg=" . $api->errorMessage . "\n"; } else { if ($option == 'com_user' || $option == 'com_users' || $extension == 'com_virtuemart' || $extension == 'com_community' && $task != 'edit' || $extension == 'com_comprofiler') { // we're done at this point return; } else { if ($extension != 'com_comprofiler') { if ($extension != 'com_community') { if (version_compare(JVERSION, '1.6.0', 'ge')) { JRequest::setVar('task', $task); JRequest::setVar('option', 'com_users'); $task = explode('.', $task); $controllerpath = JPATH_SITE . DS . 'components/com_users/controller.php'; require_once $controllerpath; $controllerpath = JPATH_SITE . DS . 'components/com_users/controllers/' . $task[0] . '.php'; require_once $controllerpath; $userController = JController::getInstance('Users', array('base_path' => JPATH_ROOT . DS . 'components' . DS . $extension, 'name' => str_replace('com_', '', $extension))); $task = $task[1]; } else { $controllerpath = JPATH_SITE . DS . 'components/' . $extension . $controller; require_once $controllerpath; $userController = new $cname(array('base_path' => JPATH_ROOT . DS . 'components' . DS . $extension, 'name' => $view)); $this->_name = str_replace('com_', '', $extension); } } else { $controllerpath = JPATH_SITE . DS . 'components/' . $extension . $controller; require_once $controllerpath; $userController = new $cname(array('base_path' => JPATH_ROOT . DS . 'components' . DS . $extension, 'name' => $view)); $this->_name = str_replace('com_', '', $extension); } $userController->execute($task); $userController->redirect(); } else { $controllerpath = JPATH_SITE . DS . 'components/' . $extension . $controller; require_once $controllerpath; if ($cbtask == 'saveUserEdit') { userSave($_POST['option'], $_POST['id']); } else { saveRegistration($_POST['option']); } } } } }