leftJoin('url_alias', 'ua', "CONCAT('node/', n.nid) = ua.source"); $query->addField('n', 'nid'); $query->isNull('ua.source'); $query->condition('n.nid', $context['sandbox']['current'], '>'); $query->orderBy('n.nid'); $query->addTag('pathauto_bulk_update'); $query->addMetaData('entity', 'node'); // Get the total amount of items to process. if (!isset($context['sandbox']['total'])) { $context['sandbox']['total'] = $query->countQuery()->execute()->fetchField(); // If there are no nodes to update, the stop immediately. if (!$context['sandbox']['total']) { $context['finished'] = 1; return; } } $query->range(0, 25); $nids = $query->execute()->fetchCol(); pathauto_node_update_alias_multiple($nids, 'bulkupdate'); $context['sandbox']['count'] += count($nids); $context['sandbox']['current'] = max($nids); $context['message'] = t('Updated alias for node @nid.', array('@nid' => end($nids))); if ($context['sandbox']['count'] != $context['sandbox']['total']) { $context['finished'] = $context['sandbox']['count'] / $context['sandbox']['total']; } } /** * Batch processing callback; Generate aliases for taxonomy terms. */ function taxonomy_pathauto_bulk_update_batch_process(&$context) { if (!isset($context['sandbox']['current'])) { $context['sandbox']['count'] = 0; $context['sandbox']['current'] = 0; } $query = db_select('taxonomy_term_data', 'td'); $query->leftJoin('url_alias', 'ua', "CONCAT('taxonomy/term/', td.tid) = ua.source"); $query->addField('td', 'tid'); $query->isNull('ua.source'); $query->condition('td.tid', $context['sandbox']['current'], '>'); // Exclude the forums terms. if ($forum_vid = variable_get('forum_nav_vocabulary', '')) { $query->condition('td.vid', $forum_vid, '<>'); } $query->orderBy('td.tid'); $query->addTag('pathauto_bulk_update'); $query->addMetaData('entity', 'taxonomy_term'); // Get the total amount of items to process. if (!isset($context['sandbox']['total'])) { $context['sandbox']['total'] = $query->countQuery()->execute()->fetchField(); // If there are no nodes to update, the stop immediately. if (!$context['sandbox']['total']) { $context['finished'] = 1; return; } } $query->range(0, 25); $tids = $query->execute()->fetchCol(); pathauto_taxonomy_term_update_alias_multiple($tids, 'bulkupdate'); $context['sandbox']['count'] += count($tids); $context['sandbox']['current'] = max($tids); $context['message'] = t('Updated alias for term @tid.', array('@tid' => end($tids))); if ($context['sandbox']['count'] != $context['sandbox']['total']) { $context['finished'] = $context['sandbox']['count'] / $context['sandbox']['total']; } } /** * Batch processing callback; Generate aliases for forums. */ function forum_pathauto_bulk_update_batch_process(&$context) { if (!isset($context['sandbox']['current'])) { $context['sandbox']['count'] = 0; $context['sandbox']['current'] = 0; } $query = db_select('taxonomy_term_data', 'td'); $query->leftJoin('url_alias', 'ua', "CONCAT('forum/', td.tid) = ua.source"); $query->addField('td', 'tid'); $query->isNull('ua.source'); $query->condition('td.tid', $context['sandbox']['current'], '>'); $query->condition('td.vid', variable_get('forum_nav_vocabulary', '')); $query->orderBy('td.tid'); $query->addTag('pathauto_bulk_update'); $query->addMetaData('entity', 'taxonomy_term'); // Get the total amount of items to process. if (!isset($context['sandbox']['total'])) { $context['sandbox']['total'] = $query->countQuery()->execute()->fetchField(); // If there are no nodes to update, the stop immediately. if (!$context['sandbox']['total']) { $context['finished'] = 1; return; } } $query->range(0, 25); $tids = $query->execute()->fetchCol(); pathauto_taxonomy_term_update_alias_multiple($tids, 'bulkupdate'); $context['sandbox']['count'] += count($tids); $context['sandbox']['current'] = max($tids); $context['message'] = t('Updated alias for forum @tid.', array('@tid' => end($tids))); if ($context['sandbox']['count'] != $context['sandbox']['total']) { $context['finished'] = $context['sandbox']['count'] / $context['sandbox']['total']; } } /** * Batch processing callback; Generate aliases for users. */ function user_pathauto_bulk_update_batch_process(&$context) { if (!isset($context['sandbox']['current'])) { $context['sandbox']['count'] = 0; $context['sandbox']['current'] = 0; } $query = db_select('users', 'u'); $query->leftJoin('url_alias', 'ua', "CONCAT('user/', u.uid) = ua.source"); $query->addField('u', 'uid'); $query->isNull('ua.source'); $query->condition('u.uid', $context['sandbox']['current'], '>'); $query->orderBy('u.uid'); $query->addTag('pathauto_bulk_update'); $query->addMetaData('entity', 'user'); // Get the total amount of items to process. if (!isset($context['sandbox']['total'])) { $context['sandbox']['total'] = $query->countQuery()->execute()->fetchField(); // If there are no nodes to update, the stop immediately. if (!$context['sandbox']['total']) { $context['finished'] = 1; return; } } $query->range(0, 25); $uids = $query->execute()->fetchCol(); pathauto_user_update_alias_multiple($uids, 'bulkupdate', array('alias blog' => FALSE)); $context['sandbox']['count'] += count($uids); $context['sandbox']['current'] = max($uids); $context['message'] = t('Updated alias for user @uid.', array('@uid' => end($uids))); if ($context['sandbox']['count'] != $context['sandbox']['total']) { $context['finished'] = $context['sandbox']['count'] / $context['sandbox']['total']; } } /** * Batch processing callback; Generate aliases for blogs. */ function blog_pathauto_bulk_update_batch_process(&$context) { if (!isset($context['sandbox']['current'])) { $context['sandbox']['count'] = 0; $context['sandbox']['current'] = 0; } $query = db_select('users', 'u'); $query->leftJoin('url_alias', 'ua', "CONCAT('blog/', u.uid) = ua.source"); $query->addField('u', 'uid'); $query->isNull('ua.source'); $query->condition('u.uid', $context['sandbox']['current'], '>'); $query->orderBy('u.uid'); $query->addTag('pathauto_bulk_update'); $query->addMetaData('entity', 'user'); // Get the total amount of items to process. if (!isset($context['sandbox']['total'])) { $context['sandbox']['total'] = $query->countQuery()->execute()->fetchField(); // If there are no nodes to update, the stop immediately. if (!$context['sandbox']['total']) { $context['finished'] = 1; return; } } $query->range(0, 25); $uids = $query->execute()->fetchCol(); $accounts = user_load_multiple($uids); foreach ($accounts as $account) { pathauto_blog_update_alias($account, 'bulkupdate'); } $context['sandbox']['count'] += count($uids); $context['sandbox']['current'] = max($uids); $context['message'] = t('Updated alias for blog user @uid.', array('@uid' => end($uids))); if ($context['sandbox']['count'] != $context['sandbox']['total']) { $context['finished'] = $context['sandbox']['count'] / $context['sandbox']['total']; } }