function updateUserstoAcajoom($force = false)
{
global $database;
$time = isset($GLOBALS[ACA . 'last_sub_update']) && $GLOBALS[ACA . 'last_sub_update'] > 0 ? $GLOBALS[ACA . 'last_sub_update'] : 10000;
$newTask = mktime(date("H") - 1, date("i"), date("s"), date("m"), date("d") - 1, date("Y"));
if ($force or $newTask > $GLOBALS[ACA . 'last_sub_update']) {
$erro = new xerr(__FILE__, __FUNCTION__, __CLASS__);
$xf = new xonfig();
$newtime = mktime(date("H", $time) - 1, date("i", $time), date("s", $time), date("m", $time), date("d", $time), date("Y", $time));
$oneDay = date('Y-m-d H:i:s', $newtime);
$query = 'SELECT M.* FROM `#__users` AS M ' . ' LEFT JOIN `#__acajoom_subscribers` AS N ON M.id = N.user_id OR M.email = N.email ';
$query .= ' WHERE M.registerDate > \'' . $oneDay . '\'';
$query .= ' AND N.id IS NULL AND M.block=0 ';
$database->setQuery($query);
$rows = $database->loadObjectList();
$erro->err = $database->getErrorMsg();
$erro->E(__LINE__, '8638', $database);
if ($erro->result and !empty($rows)) {
foreach ($rows as $row) {
$query = "INSERT INTO `#__acajoom_subscribers` (`user_id`,`subscribe_date`, `name`,`email`,`confirmed`)";
$query .= " VALUES ( {$row->id} , '{$row->registerDate}', '{$row->name}', '{$row->email}' , 1 ) ";
$database->setQuery($query);
$database->query();
$erro->err = $database->getErrorMsg();
$xf->plus('totalsubcribers0', 1);
$xf->plus('act_totalsubcribers0', 1);
$lists = lists::getLists(0, 0, null, '', true, false, false);
if (!empty($lists)) {
foreach ($lists as $list) {
$qid[0] = subscribers::getSubscriberId($row->registerDate);
$subscriber = subscribers::getSubscribersFromId($qid, false);
$subId = array();
$subId[0] = $subscriber->id;
$erro->ck = queue::updateQueues($subId, '', $list->id, @$list->acc_id, true);
$erro->Eck(__LINE__, '8640');
}
}
}
}
}
}
