function upgrade_News3()
{
global $my, $database;
$xf = new xonfig();
$newLists = array();
$idImportedList = array();
$i = 0;
$database->setQuery("SELECT * FROM #__newsletter_letters");
$newsletters = $database->loadObjectList();
$error = $database->getErrorMsg();
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->html = $newsletter->html;
$list->hidden = !$newsletter->hidden;
$list->unsubscribesend = 1;
$list->list_type = '1';
$list->auto_add = 0;
$list->user_choose = 0;
$list->cat_id = 0;
$list->delay_min = 0;
$list->delay_max = 0;
$list->follow_up = 0;
$list->owner = $my->id;
$list->auto_add = 0;
$list->acc_level = $newsletter->aid;
$list->acc_id = 29;
$list->published = 1;
$list->createdate = acajoom::getNow();
$list->footer = 1;
$list->notify_id = 0;
$list->notification = 0;
$query = 'INSERT INTO `#__acajoom_lists` (`list_name`) VALUES (\'' . $list->list_name . '\' )';
$database->setQuery($query);
$database->query();
$error = $database->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 `#__acajoom_lists` WHERE `list_name`= \'' . $list->list_name . '\'';
$database->setQuery($query);
$database->loadObject($mynewlist);
$error = $database->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->id;
$newLists[$i] = $mynewlist->id;
$i++;
$list->id = $mynewlist->id;
$error = 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[ACA . 'listnames1']) . ': </b>' . $list->list_name . ': ' . acajoom::printM('green', _ACA_IMPORT_SUCCESS);
$database->setQuery("SELECT * FROM #__newsletter_mailing WHERE `list_id`=" . $newsletter->id);
$mailingsImports = $database->loadObjectList();
$error = $database->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->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 = xmailing::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>' . _ACA_MENU_MAILING_TITLE . ': </b>' . $mailingsImport->subject . ': ' . acajoom::printM('green', _ACA_IMPORT_SUCCESS);
}
}
}
}
}
}
}
$database->setQuery("SELECT * FROM #__newsletter_subscribers");
$subscribers = $database->loadObjectList();
$error = $database->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;
$acajoomsubscribers = subscribers::getSubscribers(-1, -1, '', $total, 0, '', '', '', '');
foreach ($acajoomsubscribers as $acajoomsubscriber) {
if ($subscriber->subscriber_email == $acajoomsubscriber->email) {
$newSubs = false;
$subId[0] = $acajoomsubscriber->id;
}
}
if ($newSubs) {
$newSubscriber->user_id = $subscriber->userid;
$newSubscriber->name = $subscriber->subscriber_name;
$newSubscriber->email = $subscriber->subscriber_email;
$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 = '';
$error = subscribers::insertSubscriber($newSubscriber, $subscriberId);
if (!empty($error)) {
if ($subscriberId < 1) {
echo ' Error inserting subscriber:' . $newSubscriber->name;
}
$error = '';
$subId[0] = $subscriberId;
} else {
echo '<br /><b>' . _ACA_MENU_SUBSCRIBERS . ': </b>' . $newSubscriber->name . ': ' . acajoom::printM('green', _ACA_IMPORT_SUCCESS);
$d['email'] = $subscriber->email;
$erro->ck = subscribers::getSubscriberIdFromEmail($d);
$erro->Eck(__LINE__, '8304');
$subId[0] = $d['subscriberId'];
}
} else {
echo '<br /><b>' . _ACA_MENU_SUBSCRIBERS . ': </b>' . $subscriber->subscriber_name . ': ' . acajoom::printM('red', _ACA_IMPORT_EXIST);
}
$j = 0;
$queue = queue::suscriptionExist($subId[0], $idImportedList[$subscriber->list_id]);
if (empty($queue)) {
$error = 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;
}
function updateQueues($subId, $qids, $listId, $acc_level, $new)
{
if (ACA_CMSTYPE) {
$database =& JFactory::getDBO();
} else {
global $database;
}
//endif
$erro = new xerr(__FILE__, __FUNCTION__, __CLASS__);
$list = lists::getOneList($listId);
if ($list->list_type == 1) {
if ($new) {
if (!empty($subId)) {
$erro->ck = queue::insertQueuesForNews($subId, $listId, $acc_level);
$erro->Eck(__LINE__, '8504');
} else {
if (!empty($qids)) {
$qid = implode(',', $qids);
$query = 'SELECT `subscriber_id` FROM `#__acajoom_queue` WHERE `qid` IN ( ' . $qid . ' ) ';
$database->setQuery($query);
$subIds = $database->loadObjectList();
$erro->err = $database->getErrorMsg();
}
foreach ($subIds as $v) {
$subId[] = $v->subscriber_id;
}
$erro->ck = queue::insertQueuesForNews($subId, $listId, $acc_level);
$erro->E(__LINE__, '8505');
}
} else {
if (!empty($subId)) {
$erro->ck = queue::updateQueueData('', $subId, 0, $listId, 0, 0, 0, 0, $acc_level, 0);
$erro->Eck(__LINE__, '8506');
} elseif (!empty($qids)) {
$erro->ck = queue::updateQueueData($qids, '', 0, $listId, 0, 0, 0, 0, $acc_level, 0);
$erro->Eck(__LINE__, '8507');
}
}
} elseif ($list->list_type == 7) {
$newQueue->list_id = $list->id;
$newQueue->mailing_id = 0;
$newQueue->issue_nb = 0;
$newQueue->send_date = 0;
$newQueue->delay = 0;
$newQueue->acc_level = $acc_level;
$newQueue->published = $list->published;
$erro->ck = autonews::insertQueuesForAutoNews($subId, $newQueue);
$erro->Eck(__LINE__, '8508');
} else {
if ($new) {
if (!empty($subId)) {
$mailingId = 0;
$mailing = queue::getValidMailing($list, $mailingId);
if (!empty($mailing)) {
if (class_exists('auto')) {
if ($mailing->list_type == 2) {
$newQueue->list_id = $mailing->list_id;
$newQueue->mailing_id = $mailing->id;
$newQueue->issue_nb = $mailing->issue_nb;
$newQueue->send_date = acajoom::getNow($mailing->delay);
$newQueue->delay = $mailing->delay;
$newQueue->acc_level = $acc_level;
$newQueue->published = $list->published;
$erro->ck = auto::insertQueuesForAuto($subId, $newQueue);
$erro->Eck(__LINE__, '8508');
} else {
$erro->ck = queue::insertQueuesForNews($subId, $mailing->list_id, $acc_level);
$erro->Eck(__LINE__, '8509');
}
}
} else {
if (class_exists('auto')) {
$newQueue->list_id = $list->id;
$newQueue->mailing_id = 0;
$newQueue->issue_nb = 0;
$newQueue->send_date = 0;
$newQueue->delay = 0;
$newQueue->acc_level = $acc_level;
$newQueue->published = $list->published;
$erro->ck = auto::insertQueuesForAuto($subId, $newQueue);
$erro->Eck(__LINE__, '8510');
}
}
} elseif (!empty($qids)) {
//On r�cup�re le premier mail du follow up
$mailingId = xmailing::getFirstMailingId($listId);
if (!empty($mailingId)) {
$mailing = queue::getValidMailing($list, $mailingId);
if (!empty($mailing)) {
if ($mailing->list_type == 2) {
//$subscribers = subscribers::getSubscribers( -1 , -1 , '' , $total , $listId, '', 1, 1,'' );
//$subId = acajoom::convertObjectToIdList($subscribers , 'id');
if (!empty($subId)) {
$erro->ck = queue::updateQueueData('', $subId, $mailing->list_type, $listId, $mailing->id, $mailing->issue_nb, 0, $mailing->delay, 0, 1);
$erro->Eck(__LINE__, '8511');
} else {
$erro->ck = queue::updateQueueData($qids, '', $mailing->list_type, $listId, $mailing->id, $mailing->issue_nb, 0, $mailing->delay, 0, 1);
$erro->Eck(__LINE__, '8511');
}
} else {
$subscribers = subscribers::getSubscribers(-1, -1, '', $total, $listId, '', 1, 1, '');
$subId = acajoom::convertObjectToIdList($subscribers, 'id');
$erro->ck = queue::insertQueuesForNews($subId, $mailing->list_id, $acc_level);
$erro->Eck(__LINE__, '8512');
}
}
}
}
} else {
if (!empty($subId)) {
$mailing = queue::getValidMailing($list, 0);
if (!empty($mailing)) {
$erro->ck = queue::updateQueueData('', $subId, $list->list_type, $listId, '', '', 0, '', 0, $list->published);
} else {
$erro->ck = queue::updateQueueData('', $subId, $mailing->list_type, $mailing->list_id, $mailing->id, $mailing->issue_nb, acajoom::getNow(), $mailing->delay, $acc_level, $mailing->published);
}
$erro->E(__LINE__, '8513');
} elseif (!empty($qids)) {
$mailing = queue::getValidMailing($list, 0);
if (!empty($mailing)) {
if ($mailing->list_type == 2) {
$erro->ck = queue::updateQueueData($qids, '', $list->list_type, $listId, $mailing->id, $mailing->issue_nb, acajoom::getNow(), $mailing->delay, 0, 1);
$erro->E(__LINE__, '8514');
} else {
$subId = acajoom::convertObjectToIdList($qids, 'subscriber_id');
$erro->ck = queue::deleteQueues($qids);
$erro->Eck(__LINE__, '8515');
$erro->ck = queue::insertQueuesForNews($subId, $mailing->list_id, $acc_level);
$erro->Eck(__LINE__, '8516');
}
}
}
}
}
return $erro->R();
}
