Файловый менеджер - Редактировать - /home/wuectly/www/03cbe/data.zip
Назад
PK b "]�#o, , index.htmlnu &1i� <html><body bgcolor="#FFFFFF"></body></html>PK b "]hr�") ") view.html.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php class dataViewdata extends acymailingView{ function display($tpl = null){ $function = $this->getLayout(); if(method_exists($this, $function)) $this->$function(); parent::display($tpl); } function genericimport(){ $this->chosen = false; $isAdmin = false; if(acymailing_isAdmin()){ $isAdmin = true; $acyToolbar = acymailing_get('helper.toolbar'); $acyToolbar->custom('finalizeimport', acymailing_translation('IMPORT'), 'import', false, ''); $acyToolbar->link(acymailing_completeLink('subscriber'), acymailing_translation('ACY_CANCEL'), 'cancel'); $acyToolbar->divider(); $acyToolbar->help('data-import', 'secondpage'); $acyToolbar->setTitle(acymailing_translation('IMPORT'), 'data&task=import'); $acyToolbar->display(); } $config = acymailing_config(); $this->config = $config; $selectedParams = array(); $selectedParams = explode(',', $config->get('import_params', 'import_confirmed,generatename')); $this->selectedParams = $selectedParams; $lists = acymailing_getVar('array', 'importlists', array()); $listClass = acymailing_get('class.list'); $allLists = acymailing_isAdmin() ? $listClass->getLists() : $listClass->getFrontendLists(); $listsName = array(); $unsubListsName = array(); foreach($allLists as $oneList){ if($lists[$oneList->listid] == -1) $unsubListsName[] = $oneList->name; if($lists[$oneList->listid] == 1) $listsName[] = $oneList->name; if($lists[$oneList->listid] == 2) $listsName[] = $oneList->name.' + '.acymailing_translation('CAMPAIGN'); } $createList = acymailing_getVar('string', 'createlist'); if(!empty($createList)) $listsName[] = $createList; if(!empty($listsName)) $this->lists = implode(', ', $listsName); if(!empty($unsubListsName)) $this->unsublists = implode(', ', $unsubListsName); $importFrom = acymailing_getVar('cmd', 'importfrom'); $this->type = $importFrom; $this->isAdmin = $isAdmin; } function import(){ $listClass = acymailing_get('class.list'); $config = acymailing_config(); $isAdmin = false; if(acymailing_isAdmin()){ $isAdmin = true; $acyToolbar = acymailing_get('helper.toolbar'); $acyToolbar->custom('doimport', acymailing_translation('IMPORT'), 'import', false, ''); $acyToolbar->link(acymailing_completeLink('subscriber'), acymailing_translation('ACY_CANCEL'), 'cancel'); $acyToolbar->divider(); $acyToolbar->help('data-import'); $acyToolbar->setTitle(acymailing_translation('IMPORT'), 'data&task=import'); $acyToolbar->display(); } $importData = array(); $importData['textarea'] = acymailing_translation('IMPORT_TEXTAREA'); $importData['file'] = acymailing_translation('ACY_FILE'); if(acymailing_isAllowed($config->get('acl_subscriber_zohoimport', 'all'))) $importData['zohocrm'] = 'ZohoCRM'; $isAdmin = false; if(acymailing_isAdmin()){ $isAdmin = true; $importData['joomla'] = acymailing_translation('IMPORT_JOOMLA'); $importData['contact'] = 'com_contact'; $importData['database'] = acymailing_translation('DATABASE'); $importData['ldap'] = 'LDAP'; $importData['zohocrm'] = 'ZohoCRM'; if(acymailing_level(3)) $importData['fbleads'] = 'Facebook Leads'; $possibleImport = array(); $possibleImport[acymailing_getPrefix().'acajoom_subscribers'] = array('acajoom', 'Acajoom'); $possibleImport[acymailing_getPrefix().'ccnewsletter_subscribers'] = array('ccnewsletter', 'ccNewsletter'); $possibleImport[acymailing_getPrefix().'letterman_subscribers'] = array('letterman', 'Letterman'); $possibleImport[acymailing_getPrefix().'communicator_subscribers'] = array('communicator', 'Communicator'); $possibleImport[acymailing_getPrefix().'yanc_subscribers'] = array('yanc', 'Yanc'); $possibleImport[acymailing_getPrefix().'vemod_news_mailer_users'] = array('vemod', 'Vemod News Mailer'); $possibleImport[acymailing_getPrefix().'jnews_subscribers'] = array('jnews', 'jNews'); $possibleImport['civicrm_email'] = array('civi', 'CiviCRM'); $possibleImport[acymailing_getPrefix().'sobipro_field'] = array('sobipro', 'SobiPro'); $possibleImport[acymailing_getPrefix().'nspro_subs'] = array('nspro', 'NS Pro'); $tables = acymailing_getTableList(); foreach($tables as $mytable){ if(isset($possibleImport[$mytable])){ $importData[$possibleImport[$mytable][0]] = $possibleImport[$mytable][1]; } } $this->tables = $tables; $civifile = ACYMAILING_ROOT.'administrator'.DS.'components'.DS.'com_civicrm'.DS.'civicrm.settings.php'; if(empty($importData['civicrm_email']) && file_exists($civifile)){ $importData['civi'] = 'CiviCRM'; } } $importvalues = array(); foreach($importData as $div => $name){ $importvalues[] = acymailing_selectOption($div, $name); } $js = 'var currentoption = \'textarea\'; function updateImport(newoption){document.getElementById(currentoption).style.display = "none";document.getElementById(newoption).style.display = \'block\';currentoption = newoption;}'; $function = acymailing_getVar('cmd', 'importfrom'); if(!empty($function)){ $js .= 'window.addEventListener("load", function(){ updateImport(\''.$function.'\'); });'; } if($config->get('ldap_host') && acymailing_isAdmin()){ $js .= 'window.addEventListener("load", function(){ updateldap(); });'; } acymailing_addScript(true, $js); $this->importvalues = $importvalues; $this->importdata = $importData; $lists = acymailing_isAdmin() ? $listClass->getLists() : $listClass->getFrontendLists(); $subscribeOptions = array(); $subscribeOptions[] = acymailing_selectOption(0, acymailing_translation('JOOMEXT_NO')); $subscribeOptions[] = acymailing_selectOption(-1, acymailing_translation('UNSUBSCRIBE')); $subscribeOptions[] = acymailing_selectOption(1, acymailing_translation('SUBSCRIBE')); $campaignValues = $subscribeOptions; $campaignValues[] = acymailing_selectOption(2, acymailing_translation('JOOMEXT_YES_CAMPAIGN')); if(acymailing_level(3)){ $listsOfId = array(); foreach($lists as $oneList){ $listsOfId[] = $oneList->listid; } $listCampaign = $listClass->getCampaigns($listsOfId); foreach($lists as $key => $oneList){ if(!empty($listCampaign[$oneList->listid])){ $lists[$key]->campaign = implode(',', $listCampaign[$oneList->listid]); } } } $this->lists = $lists; $this->subscribeOptions = $subscribeOptions; $this->campaignValues = $campaignValues; $this->config = $config; $this->isAdmin = $isAdmin; } function export(){ $listClass = acymailing_get('class.list'); $fields = acymailing_getColumns('#__acymailing_subscriber'); $fieldsList = array(); $fieldsList['listid'] = 'smallint unsigned'; $fieldsList['listname'] = 'varchar'; $config = acymailing_config(); $selectedFields = explode(',', $config->get('export_fields', 'email,name')); $selectedLists = explode(',', $config->get('export_lists')); $selectedFilters = explode(',', $config->get('export_filters', 'subscribed')); $isAdmin = false; if(acymailing_isAdmin()){ $isAdmin = true; $acyToolbar = acymailing_get('helper.toolbar'); if(acymailing_isNoTemplate()){ $acyToolbar->custom('doexport', acymailing_translation('ACY_EXPORT'), 'export', false, ''); $acyToolbar->setTitle(acymailing_translation('ACY_EXPORT')); $acyToolbar->topfixed = false; }else{ $acyToolbar->custom('doexport', acymailing_translation('ACY_EXPORT'), 'export', false, ''); $acyToolbar->link(acymailing_completeLink('subscriber'), acymailing_translation('ACY_CANCEL'), 'cancel'); $acyToolbar->divider(); $acyToolbar->help('data-export'); $acyToolbar->setTitle(acymailing_translation('ACY_EXPORT'), 'data&task=export'); } $acyToolbar->display(); } $charsetType = acymailing_get('type.charset'); $this->charset = $charsetType; if(acymailing_isAdmin()){ $lists = $listClass->getLists(); }else $lists = $listClass->getFrontendLists(); $this->lists = $lists; $this->fields = $fields; $this->fieldsList = $fieldsList; $this->selectedfields = $selectedFields; $this->selectedlists = $selectedLists; $this->selectedFilters = $selectedFilters; $this->config = $config; $this->isAdmin = $isAdmin; if(acymailing_getVar('int', 'sessionvalues')){ if(!empty($_SESSION['acymailing']['exportusers'])){ $i = 1; $subids = array(); foreach($_SESSION['acymailing']['exportusers'] as $subid){ $subids[] = (int)$subid; $i++; if($i > 10) break; } if(!empty($subids)){ $users = acymailing_loadObjectList('SELECT DISTINCT `name`,`email` FROM `#__acymailing_subscriber` WHERE `subid` IN ('.implode(',', $subids).') LIMIT 10'); $this->users = $users; } }elseif(!empty($_SESSION['acymailing']['exportlist'])){ $filterList = $_SESSION['acymailing']['exportlist']; $this->exportlist = $filterList; $filterListStatus = $_SESSION['acymailing']['exportliststatus']; $this->exportliststatus = $filterListStatus; } } if(acymailing_getVar('int', 'fieldfilters')) $this->fieldfilters = true; if(acymailing_getVar('int', 'sessionquery')){ acymailing_session(); $exportQuery = $_SESSION['acymailing']['acyexportquery']; if(!empty($exportQuery)){ $users = acymailing_loadObjectList('SELECT DISTINCT s.`name`,s.`email` '.$exportQuery.' LIMIT 10'); $this->users = $users; if(strpos($exportQuery, 'userstats')){ $otherFields = array('userstats.mailid','userstats.senddate', 'userstats.open', 'userstats.opendate', 'userstats.bounce', 'userstats.bouncerule', 'userstats.ip', 'userstats.html', 'userstats.fail', 'userstats.sent', 'userstats.browser', 'userstats.browser_version', 'userstats.is_mobile', 'userstats.mobile_os', 'userstats.user_agent'); $this->otherfields = $otherFields; } if(strpos($exportQuery, 'urlclick')){ $otherFields = array('url.name', 'url.url', 'urlclick.date', 'urlclick.ip', 'urlclick.click'); $this->otherfields = $otherFields; } if(strpos($exportQuery, 'history')){ $otherFields = array('hist.data', 'hist.date'); $this->otherfields = $otherFields; } } } if(acymailing_level(3)){ $geolocFields = acymailing_getColumns('#__acymailing_geolocation'); $this->geolocfields = $geolocFields; } } } PK b "]^�� � tmpl/file.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><table class="acymailing_table"> <tr id="trfileupload"> <td class="acykey"> <?php echo acymailing_translation('UPLOAD_FILE'); ?> </td> <td> <input type="file" style="width:auto;" name="importfile"/> <?php echo '<br />'.(acymailing_translation_sprintf('MAX_UPLOAD', (acymailing_bytes(ini_get('upload_max_filesize')) > acymailing_bytes(ini_get('post_max_size'))) ? ini_get('post_max_size') : ini_get('upload_max_filesize'))); ?> </td> </tr> </table> PK b "]�[�& & tmpl/jnews.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('jnews_subscribers', false)); $resultLists = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('jnews_lists', false)); $resultNews = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('jnews_mailings', false)); echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'jNews'); if(!empty($resultLists)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'jNews').'</span>'; echo acymailing_translation_sprintf('IMPORT_X_LISTS', $resultLists).'<br />'; echo acymailing_translation_sprintf('IMPORT_LIST_TOO', 'jNews').acymailing_boolean("jnews_lists"); echo '</div>'; } if(!empty($resultNews)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'jNews').'</span>'; echo acymailing_translation_sprintf('IMPORT_NEWSLETTERS_TOO', 'jNews').acymailing_boolean("jnews_news"); } PK b "]�]HH tmpl/import.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $config = acymailing_config(); ?> <div id="acy_content"> <div id="iframedoc"></div> <form action="<?php echo acymailing_completeLink(acymailing_getVar('cmd', 'ctrl')); ?>" method="post" name="adminForm" enctype="multipart/form-data" id="adminForm"> <?php if(!empty($this->Itemid)) echo '<input type="hidden" name="Itemid" value="'.$this->Itemid.'" />'; acymailing_formOptions(); ?> <div style="width:100%;"> <div id="import_mode_container"> <div id="import_mode" class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>"> <span class="acyblocktitle"><?php echo acymailing_translation('IMPORT_FROM'); ?></span> <?php echo acymailing_radio($this->importvalues, 'importfrom', 'class="inputbox" size="1" onclick="updateImport(this.value);"', 'value', 'text', acymailing_getVar('cmd', 'importfrom', 'textarea')); ?> </div> </div> <div id="import_options" class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>"> <?php foreach($this->importdata as $div => $name){ echo '<div id="'.$div.'"'; if($div != acymailing_getVar('cmd', 'importfrom', 'textarea')) echo ' style="display:none"'; echo '>'; echo '<span class="acyblocktitle">'.$name.'</span>'; include(dirname(__FILE__).DS.$div.'.php'); echo '</div>'; } ?> </div> <div class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>" id="importlists"> <span class="acyblocktitle"><?php echo acymailing_translation('SUBSCRIPTION'); ?></span> <?php if(acymailing_isAllowed($this->config->get('acl_lists_manage', 'all'))){ ?> <table class="acymailing_table" cellpadding="1"> <tr class="<?php echo "row1"; ?>" id="importcreatelist"> <td colspan="2"> <?php echo acymailing_translation('IMPORT_SUBSCRIBE_CREATE').' : <input type="text" name="createlist" placeholder="'.acymailing_translation('LIST_NAME').'" />'; ?> </td> </tr> </table> <?php } $currentPage = 'import'; $currentValues = acymailing_getVar('none', 'importlists'); $listid = acymailing_getVar('int', 'listid'); include_once(ACYMAILING_BACK.'views'.DS.'list'.DS.'tmpl'.DS.'filter.lists.php'); ?> </div> </div> </form> <div style="clear: both;"></div> </div> PK b "],���� � tmpl/vemod.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(*) FROM `#__vemod_news_mailer_users`'); echo acymailing_translation_sprintf('USERS_IN_COMP',$resultUsers,'Vemod News Mailer'); PK b "]՝�'~ ~ tmpl/database.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $subfields = acymailing_getColumns('#__acymailing_subscriber'); $config = acymailing_config(); $postFields = (array)@unserialize($config->get('import_db_fields', '')); ?> <table <?php echo $this->isAdmin ? '' : 'class="admintable table" cellspacing="1"' ?>> <tr> <td class="acykey"><?php echo acymailing_translation('TABLENAME'); ?></td> <td><input type="text" name="tablename" style="width:200px" size="80" value="<?php echo $this->escape($config->get('import_db_table', '')); ?>"/></td> </tr> <?php if(!empty($subfields)){ foreach($subfields as $oneField => $type){ if(in_array($oneField, array('subid', 'confirmed', 'confirmed_date', 'confirmed_ip', 'lastopen_date', 'lastsent_date', 'lastclick_date', 'enabled', 'key', 'userid', 'accept', 'html', 'created'))) continue; echo '<tr><td class="acykey">'.$oneField.'</td><td><input style="width:200px" type="text" name="fields['.$oneField.']" value="'.@$postFields[$oneField].'" /></td></tr>'; } } if($this->config->get('require_confirmation')){ ?> <tr id="trdbconfirm"> <td class="acykey"> <?php echo acymailing_translation('IMPORT_CONFIRMED'); ?> </td> <td> <?php echo acymailing_boolean("import_confirmed_database", '', acymailing_getVar('int', 'import_confirmed_database', 1), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <?php } ?> </table> PK b "]�� �8 8 tmpl/contact.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php try{ $resultUsers = acymailing_loadResult("SELECT count(*) FROM `#__contact_details` WHERE `email_to` LIKE '%@%'"); }catch(Exception $e){ $resultUsers = 0; acymailing_display($e->getMessage(),'error'); } echo acymailing_translation_sprintf('USERS_IN_COMP',$resultUsers,'com_contact'); PK b "]7��$ $ tmpl/zohocrm.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $listClass = acymailing_get('class.list'); $this->data = $listClass->getLists('listid'); $this->values = array(); $this->values[] = acymailing_selectOption('0', '- - -'); foreach($this->data as $onelist){ $this->values[] = acymailing_selectOption($onelist->listid, $onelist->name); } $zohoFields = $this->config->get('zoho_fields'); $value['zoho_fields'] = empty($zohoFields) ? array() : unserialize($zohoFields); $zohoList = $this->config->get('zoho_list'); $value['zoho_list'] = empty($zohoList) ? 'Leads' : $zohoList; if(empty($value['zoho_fields'])) $value['zoho_fields'] = array('First Name' => 'name'); ?> <span class="acyblocktitle"><?php echo acymailing_translation('Options'); ?></span> <table <?php echo $this->isAdmin ? 'class="acymailing_table"' : 'class="admintable table" cellspacing="1"' ?>> <?php if($this->config->get('require_confirmation')){ ?> <tr id="trfileconfirm"> <td class="acykey"> <?php echo acymailing_translation('IMPORT_CONFIRMED'); ?> </td> <td> <?php echo acymailing_boolean("zoho_confirmed", '', $this->config->get('zoho_confirmed'), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <?php } ?> <tr id="trfileoverwrite"> <td class="acykey"> <?php echo acymailing_translation('OVERWRITE_EXISTING'); ?> </td> <td> <?php echo acymailing_boolean("zoho_overwrite", '', $this->config->get('zoho_overwrite'), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <tr id="trzohodelete"> <td class="acykey"> <?php echo acymailing_translation('DELETE_USERS'); ?> </td> <td> <?php echo acymailing_boolean("zoho_delete", '', $this->config->get('zoho_delete'), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <tr id="trzohoimportnew"> <td class="acykey"> <?php echo acymailing_translation('ACY_ZOHO_IMPORT_NEW'); ?> </td> <td> <?php echo acymailing_boolean("zoho_importnew", '', $this->config->get('zoho_importnew'), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO').' : '.acymailing_translation('ALL_USERS')); ?> </td> </tr> <tr id="trzohogeneratename"> <td class="acykey"> <?php echo acymailing_tooltip(acymailing_translation('ACY_ZOHO_GENERATE_NAME_DESC'), acymailing_translation('ACY_ZOHO_GENERATE_NAME'), '', acymailing_translation('ACY_ZOHO_GENERATE_NAME')); ?> </td> <td> <?php $generateFrom = array(); $generateFrom[] = acymailing_selectOption('fromemail', acymailing_translation('ACY_ZOHO_GENERATE_NAME_FROM_EMAIL')); $generateFrom[] = acymailing_selectOption('fromconcat', acymailing_translation('ACY_ZOHO_GENERATE_NAME_FROM_FIELDS')); echo acymailing_radio($generateFrom, "zoho_generate_name", 'class="inputbox" size="1"', 'value', 'text', $this->config->get('zoho_generate_name', 'fromemail')); ?> </td> </tr> <tr id="trzohoapikey"> <td class="acykey"> <?php echo 'Auth Token'; ?> </td> <td> <input class="inputbox" type="text" name="zoho_apikey" size="35" value="<?php echo $this->escape($this->config->get('zoho_apikey')); ?>"> </td> </tr> <tr id="trzoholist"> <td class="acykey"> <?php echo acymailing_translation('ACY_ZOHOLIST'); ?> </td> <td> <?php $lists = array(); $lists[] = acymailing_selectOption('Leads', 'Leads'); $lists[] = acymailing_selectOption('Contacts', 'Contacts'); $lists[] = acymailing_selectOption('Vendors', 'Vendors'); echo acymailing_select($lists, "zoho_list", 'class="inputbox" size="1"', 'value', 'text', $value['zoho_list']); ?> </td> </tr> <tr id="trzohocv"> <td class="acykey"> <?php echo acymailing_tooltip(acymailing_translation('CUSTOM_VIEW_DESC'), acymailing_translation('CUSTOM_VIEW'), '', acymailing_translation('CUSTOM_VIEW')); ?> </td> <td> <input class="inputbox" type="text" name="zoho_cv" size="35" value="<?php echo $this->escape($this->config->get('zoho_cv')); ?>"> </td> </tr> </table> <span class="acyblocktitle" style="margin-top: 20px;"><?php echo acymailing_translation('FIELD'); ?></span> <?php $subfields = acymailing_getColumns('#__acymailing_subscriber'); $acyfields = array(); $acyfields[] = acymailing_selectOption('', ' - - - '); if(!empty($subfields)){ foreach($subfields as $oneField => $typefield){ if(in_array($oneField, array('subid', 'confirmed', 'enabled', 'key', 'userid', 'accept', 'html', 'created', 'zohoid', 'zoholist', 'email'))) continue; $acyfields[] = acymailing_selectOption($oneField, $oneField); } } ?> <table <?php echo $this->isAdmin ? 'class="acymailing_table"' : 'class="admintable table" cellspacing="1"' ?>> <?php echo '<tr><td class="acykey">'.acymailing_translation('ACY_LOADZOHOFIELDS').'</td><td>'; echo '<input type="submit" class="btn" onclick="acymailing.submitbutton(\'loadZohoFields\')" value="'.acymailing_translation('ACY_LOADFIELDS').'"></td></tr>'; $fields = explode(',', $config->get('zoho_fieldsname', 'First Name,Last Name,Date of Birth')); foreach($fields as $oneField){ $fieldValue = ''; if(!empty($value['zoho_fields'][$oneField])) $fieldValue = $value['zoho_fields'][$oneField]; echo '<tr><td class="acykey">'.$oneField.'</td><td><div id="zoho_fields">'.acymailing_select($acyfields, "zoho_fields[".$oneField."]", 'class="inputbox" size="1"', 'value', 'text', $fieldValue).'</div></td></tr>'; } ?> </table> PK b "]�#o, , tmpl/index.htmlnu &1i� <html><body bgcolor="#FFFFFF"></body></html>PK b "]7� �� � tmpl/letterman.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(*) FROM '.acymailing_table('letterman_subscribers',false)); echo acymailing_translation_sprintf('USERS_IN_COMP',$resultUsers,'Letterman'); PK b "]\��'; ; tmpl/joomla.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count('.$this->cmsUserVars->id.') FROM '.acymailing_table($this->cmsUserVars->table, false)); $resultAcymailing = acymailing_loadResult('SELECT count(subid) FROM '.acymailing_table('subscriber').' WHERE userid > 0'); echo acymailing_translation_sprintf('ACY_IMPORT_NB_J_USERS', $resultUsers).'<br />'; echo acymailing_translation_sprintf('ACY_IMPORT_NB_ACY_USERS', $resultAcymailing).'<br />'; ?> <br/> <br/> <?php echo acymailing_translation('ACY_IMPORT_JOOMLA_1'); ?> <ol> <li><?php echo acymailing_translation('ACY_IMPORT_JOOMLA_2'); ?></li> <li><?php echo acymailing_translation('ACY_IMPORT_JOOMLA_3'); ?></li> <li><?php echo acymailing_translation('ACY_IMPORT_JOOMLA_4'); ?></li> <li><?php echo acymailing_translation('ACY_IMPORT_JOOMLA_5'); ?></li> </ol> PK b "]���C tmpl/textarea.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><textarea style="width:99%;height:180px;" rows="10" name="textareaentries"> <?php $text = acymailing_getVar('string', "textareaentries"); if(empty($text)){ ?> name,email Adrien,adrien@example.com John,john@example.com <?php }else{ echo $text; } ?> </textarea> PK b "]A�� � tmpl/acajoom.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('acajoom_subscribers', false)); $resultLists = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('acajoom_lists', false)); echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'Acajoom'); if(!empty($resultLists)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'Acajoom').'</span>'; echo acymailing_translation_sprintf('IMPORT_X_LISTS', $resultLists).'<br />'; echo acymailing_translation_sprintf('IMPORT_LIST_TOO', 'Acajoom').acymailing_boolean("acajoom_lists"); echo '</div>'; } PK b "]w�,� � tmpl/ccnewsletter.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(*) FROM '.acymailing_table('ccnewsletter_subscribers', false)); $resultLists = array(); $resultNews = array(); if(in_array(acymailing_getPrefix().'ccnewsletter_groups', $this->tables)){ $resultLists = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('ccnewsletter_groups', false)); $resultNews = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('ccnewsletter_newsletters', false)); } echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'ccNewsletter'); if(!empty($resultLists)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'ccNewsletter').'</span>'; echo acymailing_translation_sprintf('IMPORT_X_LISTS', $resultLists).'<br />'; echo acymailing_translation_sprintf('IMPORT_LIST_TOO', 'ccNewsletter').acymailing_boolean("ccNewsletter_lists"); echo '</div>'; } if(!empty($resultNews)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'ccNewsletter').'</span>'; echo acymailing_translation_sprintf('IMPORT_NEWSLETTERS_TOO', 'ccNewsletter').acymailing_boolean("ccNewsletter_news"); } PK b "]�W�}� � tmpl/civi.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $importHelper = acymailing_get('helper.import'); $importHelper->setciviprefix(); try{ $resultUsers = acymailing_loadResult('SELECT count(*) FROM '.$importHelper->civiprefix.'email WHERE is_primary = 1'); echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'CiviCRM'); }catch(Exception $e){ echo("Error counting users from CiviCRM. CiviCRM table probably doesn't exists"); } PK b "]��Uq q tmpl/yanc.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(*) FROM `#__yanc_subscribers`'); $resultLists = acymailing_loadResult('SELECT count(*) FROM `#__yanc_letters`'); echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'Yanc'); if(!empty($resultLists)){ echo '<div class="acyblockoptions"><span class="acyblocktitle">'.acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'Yanc').'</span>'; echo acymailing_translation_sprintf('IMPORT_X_LISTS', $resultLists).'<br />'; echo acymailing_translation_sprintf('IMPORT_LIST_TOO', 'Yanc').acymailing_boolean("yanc_lists"); echo '</div>'; } PK b "]U�K� � tmpl/communicator.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(*) FROM '.acymailing_table('communicator_subscribers',false)); echo acymailing_translation_sprintf('USERS_IN_COMP',$resultUsers,'Communicator'); PK b "]�}��# �# tmpl/export.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><div id="acy_content"> <div id="iframedoc"></div> <form action="<?php echo acymailing_completeLink((acymailing_isAdmin() ? '' : 'front').'data', true); ?>" method="post" name="adminForm" id="adminForm"> <style> #acy_content .oneBlock{ <?php if(acymailing_isAdmin()){ ?> float: left; width: 49%; padding: 5px; min-width: 500px; <?php }else{ ?> width: 100%; <?php } ?> } </style> <div style="width:100%;"> <div class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>"> <span class="acyblocktitle"><?php echo acymailing_translation('FIELD_EXPORT'); ?></span> <table class="acymailing_smalltable"> <?php $k = 0; if(!empty($this->fields)){ foreach($this->fields as $fieldName => $fieldType){ ?> <tr class="<?php echo "row$k"; ?>" id="userField_<?php echo $fieldName; ?>"> <td> <?php echo $fieldName ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportdata[".$fieldName."]", '', in_array($fieldName, $this->selectedfields) ? 1 : 0); ?> </td> </tr> <?php $k = 1 - $k; } } if(!empty($this->otherfields)){ foreach($this->otherfields as $fieldName){ ?> <tr class="<?php echo "row$k"; ?>" id="userField_<?php echo $fieldName; ?>"> <td> <?php echo $fieldName ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportdataother[".$fieldName."]", '', in_array($fieldName, $this->selectedfields) ? 1 : 0, acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO'), str_replace('.', '_', $fieldName)); ?> </td> </tr> <?php $k = 1 - $k; } } if(!empty($this->fieldsList)){ foreach($this->fieldsList as $fieldName => $fieldType){ ?> <tr class="<?php echo "row$k"; ?>" id="userField_<?php echo $fieldName; ?>"> <td> <?php echo $fieldName ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportdatalist[".$fieldName."]", '', in_array($fieldName, $this->selectedfields) ? 1 : 0); ?> </td> </tr> <?php $k = 1 - $k; } } if(!empty($this->geolocfields)){ ?> <tr class="<?php echo "row$k"; ?>" id="userField_<?php echo $fieldName; ?>"> <td> <?php echo acymailing_translation('ACYEXPORT_GEOLOC_VALUE'); ?> </td> <td align="center" style="text-align:center"> <?php $values = array(acymailing_selectOption('asc', acymailing_translation('SEPARATOR_FIRST_GEOL_SAVED')), acymailing_selectOption('desc', acymailing_translation('ACYEXPORT_LAST_GEOL_SAVED'))); echo acymailing_select($values, 'exportgeolocorder', '', 'value', 'text', $this->config->get('exportgeolocorder', 'asc')); ?> </td> </tr> <?php $k = 1 - $k; foreach($this->geolocfields as $fieldName => $fieldType){ if(in_array($fieldName, array('geolocation_id', 'geolocation_subid'))) continue; ?> <tr class="<?php echo "row$k"; ?>" id="userField_<?php echo $fieldName; ?>"> <td> <?php echo $fieldName ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportdatageoloc[".$fieldName."]", '', in_array($fieldName, $this->selectedfields) ? 1 : 0); ?> </td> </tr> <?php $k = 1 - $k; } } ?> <tr class="<?php echo "row$k"; $k = 1 - $k; ?>" id="userField_exportFormat"> <td> <?php echo acymailing_translation('EXPORT_FORMAT'); ?> </td> <td align="center" style="text-align:center"> <?php echo $this->charset->display('exportformat', $this->config->get('export_format', 'UTF-8')); ?> </td> </tr> <tr class="<?php echo "row$k"; $k = 1 - $k; ?>" id="userField_separator"> <td> <?php echo acymailing_translation('ACY_SEPARATOR'); ?> </td> <td align="center" nowrap="nowrap"> <?php $values = array(acymailing_selectOption('semicolon', acymailing_translation('SEPARATOR_SEMICOLON')), acymailing_selectOption('comma', acymailing_translation('SEPARATOR_COMMA'))); $data = str_replace(array(';', ','), array('semicolon', 'comma'), $this->config->get('export_separator', ';')); if($data == 'colon') $data = 'comma'; echo acymailing_radio($values, 'exportseparator', '', 'value', 'text', $data); ?> </td> </tr> <tr class="<?php echo "row$k"; ?>" id="userField_excel"> <td> <?php echo acymailing_tooltip(acymailing_translation('ACY_EXCEL_SECURITY_DESC'), acymailing_translation('ACY_EXCEL_SECURITY'), '', acymailing_translation('ACY_EXCEL_SECURITY')); ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("export_excelsecurity", '', $this->config->get('export_excelsecurity', 0) == 1 ? 1 : 0); ?> </td> </tr> </table> </div> <?php if (empty($this->users)){ ?> <div class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>"> <span class="acyblocktitle"><?php echo acymailing_translation('ACY_FILTERS'); ?></span> <table class="acymailing_smalltable"> <tr class="row0"> <td> <?php echo acymailing_translation('EXPORT_SUB_LIST'); ?> </td> <td align="center" nowrap="nowrap"> <?php echo acymailing_boolean("exportfilter[subscribed]", 'onchange="if(this.value == 1){document.getElementById(\'exportlists\').style.display = \'block\'; }else{document.getElementById(\'exportlists\').style.display = \'none\'; }"', (in_array('subscribed', $this->selectedFilters) || !empty($this->exportlist)) ? 1 : 0, acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO').' : '.acymailing_translation('ALL_USERS')); ?> </td> </tr> <tr class="row1"> <td> <?php echo acymailing_translation('EXPORT_REGISTERED'); ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportfilter[registered]", '', in_array('registered', $this->selectedFilters) ? 1 : 0, acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO').' : '.acymailing_translation('ALL_USERS')); ?> </td> </tr> <tr class="row0"> <td> <?php echo acymailing_translation('EXPORT_CONFIRMED'); ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportfilter[confirmed]", '', in_array('confirmed', $this->selectedFilters) ? 1 : 0, acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO').' : '.acymailing_translation('ALL_USERS')); ?> </td> </tr> <tr class="row1"> <td> <?php echo acymailing_translation('EXPORT_ENABLED'); ?> </td> <td align="center" style="text-align:center"> <?php echo acymailing_boolean("exportfilter[enabled]", '', in_array('enabled', $this->selectedFilters) ? 1 : 0, acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO').' : '.acymailing_translation('ALL_USERS')); ?> </td> </tr> </table> </id> <?php } ?> </div> <div class="<?php echo $this->isAdmin ? 'acyblockoptions' : 'onelineblockoptions'; ?>" id="exportlists" <?php echo (in_array('subscribed', $this->selectedFilters) || !empty($this->exportlist) || !empty($this->users)) ? '' : 'style="display:none"' ?> > <?php if(empty($this->users)){ ?> <span class="acyblocktitle"><?php echo acymailing_translation('LISTS'); ?></span> <?php $currentPage = 'export'; include_once(ACYMAILING_BACK.'views'.DS.'list'.DS.'tmpl'.DS.'filter.lists.php'); }else{ ?> <span class="acyblocktitle"><?php echo acymailing_translation('USERS'); ?></span> <table class="acymailing_table" cellpadding="1"> <?php $k = 0; foreach($this->users as $row){ ?> <tr class="<?php echo "row$k"; ?>"> <td><?php echo htmlspecialchars($row->name, ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlspecialchars($row->email, ENT_QUOTES, 'UTF-8'); ?></td> </tr> <?php $k = 1 - $k; } if(count($this->users) >= 10){ ?> <tr class="<?php echo "row$k"; ?>"> <td>...</td> <td>...</td> </tr> <?php } ?> </table> <?php } ?> </div> <input type="hidden" name="sessionvalues" value="<?php echo empty($this->users) ? 0 : acymailing_getVar('int', 'sessionvalues'); ?>"/> <input type="hidden" name="sessionquery" value="<?php echo empty($this->users) ? 0 : acymailing_getVar('int', 'sessionquery'); ?>"/> <?php acymailing_formOptions(); ?> </form> <div class="clr"></div> </div> PK b "]��P� tmpl/fbleads.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><table class="acymailing_table"> <tr> <td class="acykey"> <label for="fbleads_token"><?php echo acymailing_tooltip(acymailing_translation('ACY_FBLEADS_TOKEN_DESC'), acymailing_translation('ACY_FBLEADS_TOKEN'), '', acymailing_translation('ACY_FBLEADS_TOKEN')); ?></label> </td> <td> <input type="text" style="width:160px" name="fbleads_token" id="fbleads_token" value="<?php echo $this->escape($this->config->get('fbleads_token')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_adid"><?php echo acymailing_tooltip(acymailing_translation('ACY_FBLEADS_AD_FORM_ID_DESC'), 'Ad ID', '', 'Ad ID'); ?></label> </td> <td> <input type="text" style="width:160px" name="fbleads_adid" id="fbleads_adid" value="<?php echo $this->escape($this->config->get('fbleads_adid')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_formid"><?php echo acymailing_tooltip(acymailing_translation('ACY_FBLEADS_AD_FORM_ID_DESC'), 'Form ID', '', 'Form ID'); ?></label> </td> <td> <input type="text" style="width:160px" name="fbleads_formid" id="fbleads_formid" value="<?php echo $this->escape($this->config->get('fbleads_formid')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_mincreated"><?php echo acymailing_translation('ACY_FBLEADS_MINCREATED'); ?></label> </td> <td> <?php echo acymailing_calendar($this->config->get('fbleads_mincreated'), 'fbleads_mincreated', 'fbleads_mincreated', '%Y-%m-%d', array('style' => 'width:100px')); ?> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_maxcreated"><?php echo acymailing_translation('ACY_FBLEADS_MAXCREATED'); ?></label> </td> <td> <?php echo acymailing_calendar($this->config->get('fbleads_maxcreated'), 'fbleads_maxcreated', 'fbleads_maxcreated', '%Y-%m-%d', array('style' => 'width:100px')); ?> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_email"><?php echo acymailing_translation('EMAILCAPTION'); ?></label> </td> <td> <input type="text" style="width:160px" placeholder="email" name="fbleads_email" id="fbleads_email" value="<?php echo $this->escape($this->config->get('fbleads_email', 'email')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="fbleads_name"><?php echo acymailing_translation('NAMECAPTION'); ?></label> </td> <td> <input type="text" style="width:160px" placeholder="full_name" name="fbleads_name" id="fbleads_name" value="<?php echo $this->escape($this->config->get('fbleads_name', 'full_name')); ?>"/> </td> </tr> </table> PK b "]�a�`6 6 tmpl/ajaxencoding.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><span class="acyblocktitle"><?php echo acymailing_translation('ACY_MATCH_DATA'); ?></span> <?php $config = acymailing_config(); $encodingHelper = acymailing_get('helper.encoding'); $filename = strtolower(acymailing_getVar('cmd', 'filename')); $encoding = acymailing_getVar('cmd', 'encoding'); $extension = '.'.acymailing_fileGetExt($filename); $uploadPath = ACYMAILING_MEDIA.'import'.DS.str_replace(array('.', ' '), '_', substr($filename, 0, strpos($filename, $extension))).$extension; if(!file_exists($uploadPath)){ acymailing_display(acymailing_translation_sprintf('FAIL_OPEN', '<b><i>'.htmlspecialchars($uploadPath, ENT_COMPAT, 'UTF-8').'</i></b>'), 'error'); return; } $this->config = acymailing_config(); $this->content = file_get_contents($uploadPath); if(empty($encoding)){ $encoding = $encodingHelper->detectEncoding($this->content); } $content = $encodingHelper->change($this->content, $encoding, 'UTF-8'); $content = str_replace(array("\r\n", "\r"), "\n", $content); $this->lines = explode("\n", $content); $this->separator = ','; $listSeparators = array("\t", ';', ','); foreach($listSeparators as $sep){ if(strpos($this->lines[0], $sep) !== false){ $this->separator = $sep; break; } } $nbPreviewLines = 0; $i = 0; while(isset($this->lines[$i])){ if(empty($this->lines[$i])){ unset($this->lines[$i]); continue; }else $nbPreviewLines++; if(strpos($this->lines[$i], '"') !== false){ $j = $i + 1; $position = -1; while($j < ($i + 30)){ $quoteOpened = substr($this->lines[$i], $position + 1, 1) == '"'; if($quoteOpened){ $nextQuotePosition = strpos($this->lines[$i], '"', $position + 2); if($nextQuotePosition === false){ if(!isset($this->lines[$j])) break; $this->lines[$i] .= "\n".rtrim($this->lines[$j], $this->separator); unset($this->lines[$j]); $j++; continue; }else{ $quoteOpened = false; if(strlen($this->lines[$i]) - 1 == $nextQuotePosition){ break; } $position = $nextQuotePosition + 1; } }else{ $nextSeparatorPosition = strpos($this->lines[$i], $this->separator, $position + 1); if($nextSeparatorPosition === false){ break; }else{ // If found the next separator, add the value in $data and change the position $position = $nextSeparatorPosition; } } } $this->lines = array_merge($this->lines); } if($nbPreviewLines == 10) break; if($nbPreviewLines != 1){ $i++; continue; } if(strpos($this->lines[$i], '@')){ $noHeader = 1; }else $noHeader = 0; $columnNames = explode($this->separator, $this->lines[$i]); $nbColumns = count($columnNames); if(!empty($i)) unset($this->lines[$i]); ksort($this->lines); } $this->lines = array_values($this->lines); $nbLines = count($this->lines); ?> <table <?php echo acymailing_isAdmin() ? 'class="acymailing_table"' : 'class="adminlist"'; ?> cellspacing="10" cellpadding="10" align="center" id="importdata"> <?php if($noHeader || !isset($this->lines[1])){ $firstValueLine = $columnNames; }else{ $firstValueLine = explode($this->separator, $this->lines[1]); foreach($firstValueLine as &$oneValue){ $oneValue = trim($oneValue, '\'" '); } } $fieldAssignment = array(); $fieldAssignment[] = acymailing_selectOption("0", '- - -'); $fieldAssignment[] = acymailing_selectOption("1", acymailing_translation('ACY_IGNORE')); if(acymailing_isAllowed($this->config->get('acl_extra_fields_import', 'all'))){ $createField = acymailing_selectOption("2", acymailing_translation('ACY_CREATE_FIELD')); if(!acymailing_level(3)){ $createField->disable = true; $createField->text .= ' ('.acymailing_translation('ONLY_FROM_ENTERPRISE').')'; } $fieldAssignment[] = $createField; } $separator = acymailing_selectOption("3", '-------------------------------------'); $separator->disable = true; $fieldAssignment[] = $separator; $fields = array_keys(acymailing_getColumns('#__acymailing_subscriber')); $fields[] = 'listids'; $fields[] = 'listname'; foreach($fields as $oneField){ $fieldAssignment[] = acymailing_selectOption($oneField, $oneField); } $fields[] = '1'; echo '<tr class="row0"><td align="center" valign="top"><strong>'.acymailing_tooltip(acymailing_translation('ACY_ASSIGN_COLUMNS_DESC'), null, null, acymailing_translation('ACY_ASSIGN_COLUMNS')).'</strong>'.($nbColumns > 5 ? '<br/><a style="text-decoration:none;" href="#" onclick="ignoreAllOthers();">'.acymailing_translation('ACY_IGNORE_UNASSIGNED').'</a>' : '').'</td>'; $alreadyFound = array(); foreach($columnNames as $key => &$oneColumn){ $oneColumn = strtolower(trim($oneColumn, '\'" ')); $customValue = ''; $default = acymailing_getVar('cmd', 'fieldAssignment'.$key); if(empty($default) && $default !== 0){ $default = (in_array($oneColumn, $fields) ? $oneColumn : '0'); if(!$default && !empty($firstValueLine)){ if(isset($firstValueLine[$key]) && strpos($firstValueLine[$key], '@')){ $default = 'email'; }elseif($nbColumns == 2) $default = 'name'; } if(in_array($default, $alreadyFound)) $default = '0'; $alreadyFound[] = $default; }elseif($default == 2){ $customValue = acymailing_getVar('cmd', 'newcustom'.$key); } echo '<td align="center" valign="top">'.acymailing_select($fieldAssignment, 'fieldAssignment'.$key, 'size="1" onchange="checkNewCustom('.$key.')" style="width:180px;"', 'value', 'text', $default).'<br />'; echo '<input style="width:170px;'.(empty($customValue) ? 'display:none;"' : '" value="'.$customValue.'" required').' type="text" id="newcustom'.$key.'" name="newcustom" placeholder="'.acymailing_translation('FIELD_COLUMN').'..."/></td>'; } echo '</tr>'; if(!$noHeader){ foreach($columnNames as &$oneColumn){ $oneColumn = htmlspecialchars($oneColumn, ENT_COMPAT | ENT_IGNORE, 'UTF-8'); } echo '<tr class="row1"><td align="center"><strong>'.acymailing_translation('ACY_IGNORE_LINE').'</strong></td><td align="center">['.implode(']</td><td align="center">[', $columnNames).']</td></tr>'; } for($i = 1 - $noHeader; $i < 11 - $noHeader && $i < $nbLines; $i++){ $values = explode($this->separator, $this->lines[$i]); foreach($values as &$oneValue){ $oneValue = htmlspecialchars(trim($oneValue, '\'" '), ENT_COMPAT | ENT_IGNORE, 'UTF-8'); } echo '<tr class="row'.(1 - $i % 2).'"><td align="center"><strong>'.($i + $noHeader).'</strong></td><td align="center">'.implode('</td><td align="center">', $values).'</td></tr>'; } ?> </table> PK b "]*�4� tmpl/ldap.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php if(!function_exists('ldap_connect')){ acymailing_display('LDAP Extension not loaded on your server.<br />Please enable the LDAP php extension.', 'warning'); return; } $js = 'function updateldap(){ document.getElementById("ldap_fields").innerHTML = "<span class=\"onload\"></span>"; queryString = "'.acymailing_prepareAjaxURL('data').'&task=ajaxload&importfrom=ldap"; queryString += "&ldap_host="+document.getElementById("ldap_host").value; queryString += "&ldap_port="+document.getElementById("ldap_port").value; queryString += "&ldap_basedn="+document.getElementById("ldap_basedn").value; queryString += "&ldap_username="+document.getElementById("ldap_username").value; queryString += "&ldap_password="+document.getElementById("ldap_password").value; var xhr = new XMLHttpRequest(); xhr.open("GET", queryString); xhr.onload = function(){ document.getElementById("ldap_fields").innerHTML = xhr.responseText; } xhr.send(); }'; acymailing_addScript(true, $js); ?> <div class="onelineblockoptions"> <span class="acyblocktitle"><?php echo acymailing_translation('ACY_CONFIGURATION'); ?></span> <table <?php echo $this->isAdmin ? 'class="acymailing_table"' : 'class="admintable table" cellspacing="1"' ?>> <?php if($this->config->get('require_confirmation')){ ?> <tr> <td class="acykey"> <?php echo acymailing_translation('IMPORT_CONFIRMED'); ?> </td> <td> <?php echo acymailing_boolean("ldap_import_confirm", '', $this->config->get('ldap_import_confirm', 1), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <?php } ?> <tr> <td class="acykey"> <?php echo acymailing_translation('GENERATE_NAME'); ?> </td> <td> <?php echo acymailing_boolean("ldap_generatename", '', $this->config->get('ldap_generatename', 1), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <tr> <td class="acykey"> <?php echo acymailing_translation('OVERWRITE_EXISTING'); ?> </td> <td> <?php echo acymailing_boolean("ldap_overwriteexisting", '', $this->config->get('ldap_overwriteexisting', 0), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> <tr> <td class="acykey"> <?php echo 'Delete AcyMailing user if it does not exists in LDAP'; ?> </td> <td> <?php echo acymailing_boolean("ldap_deletenotexists", '', $this->config->get('ldap_deletenotexists', 0), acymailing_translation('JOOMEXT_YES'), acymailing_translation('JOOMEXT_NO')); ?> </td> </tr> </table> </div> <div class="onelineblockoptions"> <span class="acyblocktitle" style="margin-top: 20px;">Server</span> <table <?php echo $this->isAdmin ? 'class="acymailing_table"' : 'class="admintable table" cellspacing="1"' ?>> <tr> <td class="acykey"> <label for="ldap_host">Host</label> </td> <td> <input onchange="updateldap();" type="text" style="width:160px" name="ldap_host" id="ldap_host" value="<?php echo $this->escape($this->config->get('ldap_host')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="ldap_port">Port</label> </td> <td> <input onchange="updateldap();" type="text" style="width:50px" name="ldap_port" id="ldap_port" value="<?php echo $this->escape($this->config->get('ldap_port')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="ldap_username">RDN</label> </td> <td> <input onchange="updateldap();" type="text" style="width:160px" name="ldap_username" id="ldap_username" value="<?php echo $this->escape($this->config->get('ldap_username')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="ldap_password"><?php echo acymailing_translation('SMTP_PASSWORD'); ?></label> </td> <td> <input onchange="updateldap();" type="password" style="width:160px" name="ldap_password" id="ldap_password" value="<?php echo $this->escape($this->config->get('ldap_password')); ?>"/> </td> </tr> <tr> <td class="acykey"> <label for="ldap_basedn">Base DN</label> </td> <td> <input onchange="updateldap();" type="text" style="width:200px" name="ldap_basedn" id="ldap_basedn" value="<?php echo $this->escape($this->config->get('ldap_basedn')); ?>"/> </td> </tr> </table> </div> <div id="ldap_fields"></div> PK b "]� v � � tmpl/sobipro.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $config = acymailing_config(); $sobiproInfo = unserialize($config->get('sobipro_import')); $query='SELECT a.fid, a.nid, fieldType, section, b.name, filter FROM #__sobipro_field as a JOIN #__sobipro_object as b ON a.section = b.id WHERE (fieldType = "inbox" AND ( filter = "title" OR filter = "0" OR filter = "")) OR (fieldType = "inbox" AND filter = "email") ORDER BY `section`'; $nidResult = acymailing_loadObjectList($query); $section = array(); foreach($nidResult as $oneResult){ if(!isset($section[$oneResult->section])) { $section[$oneResult->section] = array(); $section[$oneResult->section]['sectionName'] = $oneResult->name; $section[$oneResult->section]['sectionID'] = $oneResult->section; $section[$oneResult->section]['email'] = array(acymailing_selectOption('', '- - -')); $section[$oneResult->section]['name'] = array(acymailing_selectOption('', '- - -')); } if(($oneResult->fieldType=='inbox' && $oneResult->filter=='email')){ $section[$oneResult->section]['email'][] = acymailing_selectOption($oneResult->fid, $oneResult->nid); } if(($oneResult->fieldType == 'inbox' && (($oneResult->filter == "title") || ($oneResult->filter == "0") || ($oneResult->filter == "")))){ $section[$oneResult->section]['name'][] = acymailing_selectOption($oneResult->fid, $oneResult->nid); } } ?> <table> <thead> <tr> <th><?php echo acymailing_translation('TAG_CATEGORIES');?></th><th><?php echo acymailing_translation('JOOMEXT_EMAIL'); ?></th><th><?php echo acymailing_translation('JOOMEXT_NAME'); ?></th> </tr> </thead> <tbody> <?php foreach($section as $oneSection){ ?> <tr> <td><?php echo $oneSection['sectionName']; ?></td> <td><?php echo acymailing_select($oneSection['email'], 'config['.$oneSection['sectionID'].'][sobiEmail]' , 'size="1"', 'value', 'text', isset($sobiproInfo[$oneSection['sectionID']]['sobiEmail']) ? $sobiproInfo[$oneSection['sectionID']]['sobiEmail'] : ''); ?></td> <td><?php echo acymailing_select($oneSection['name'], 'config['.$oneSection['sectionID'].'][sobiName]' , 'size="1"', 'value', 'text', isset($sobiproInfo[$oneSection['sectionID']]['sobiName']) ? $sobiproInfo[$oneSection['sectionID']]['sobiName'] : '' ); ?></td> </tr> <?php } ?> </tbody> </table> PK b "]�V؇S S tmpl/nspro.phpnu &1i� <?php /** * @package AcyMailing for Joomla! * @version 5.9.6 * @author acyba.com * @copyright (C) 2009-2018 ACYBA S.A.R.L. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php $resultUsers = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('nspro_subs', false)); $resultLists = acymailing_loadResult('SELECT count(id) FROM '.acymailing_table('nspro_lists', false)); ?> <table <?php echo $this->isAdmin ? 'class="acymailing_table"' : 'class="admintable table" cellspacing="1"' ?>> <tr> <td colspan="2"> <?php echo acymailing_translation_sprintf('USERS_IN_COMP', $resultUsers, 'NS Pro'); ?> <br/> <?php echo acymailing_translation_sprintf('LISTS_IN_COMP', $resultLists, 'NS Pro'); ?> <br/> <?php echo acymailing_translation_sprintf('IMPORT_X_LISTS', $resultLists); ?> </td> </tr> <tr> <td class="acykey"> <?php echo acymailing_translation_sprintf('IMPORT_LIST_TOO', 'NS Pro'); ?> </td> <td> <?php echo acymailing_boolean("nspro_lists"); ?> </td> </tr> </table> PK b "]qu�f�"