function views_url_alias_node_rebuild in Views URL alias 6

Same name and namespace in other branches

1. 8 views_url_alias_node.module \views_url_alias_node_rebuild()
2. 7 views_url_alias_node.module \views_url_alias_node_rebuild()

Rebuild view_url_alias_node table.

This function typically only needs to be called when this module is installed.

2 calls to views_url_alias_node_rebuild()

views_url_alias_node_admin_submit in ./views_url_alias_node.admin.inc

Submit callback for Views URL Alias admin form.

views_url_alias_node_enable in ./views_url_alias_node.install

Implementation of hook_enable().

File

./views_url_alias_node.module, line 128

Allows node related Views to be filtered by path aliases.

Code

function views_url_alias_node_rebuild() {

  // Purge view_url_alias_node table.
  db_query("TRUNCATE TABLE {views_url_alias_node}");

  // Populate view_url_alias_node table.
  db_query("INSERT INTO {views_url_alias_node} (nid, dst)\n    SELECT n.nid, ua.dst FROM {url_alias} ua INNER JOIN node AS n ON CONCAT('node/', n.nid) = ua.src WHERE ua.language=''");

  // Display message
  drupal_set_message(t('The %table table has been successfully rebuilt.', array(
    '%table' => 'views_url_alias_node',
  )));
}