taxonomy.module 49.2 KB
Newer Older
Dries's avatar
 
Dries committed
1
<?php
Kjartan's avatar
Kjartan committed
2
// $Id$
Dries's avatar
 
Dries committed
3

Dries's avatar
 
Dries committed
4 5 6 7 8
/**
 * @file
 * Enables the organization of content into categories.
 */

Dries's avatar
 
Dries committed
9 10 11
/**
 * Implementation of hook_perm().
 */
Kjartan's avatar
Kjartan committed
12
function taxonomy_perm() {
Dries's avatar
 
Dries committed
13
  return array('administer taxonomy');
Kjartan's avatar
Kjartan committed
14
}
Dries's avatar
 
Dries committed
15

Dries's avatar
 
Dries committed
16 17 18 19 20 21 22 23 24 25 26
/**
 * Implementation of hook_link().
 *
 * This hook is extended with $type = 'taxonomy terms' to allow themes to
 * print lists of terms associated with a node. Themes can print taxonomy
 * links with:
 *
 * if (module_exist('taxonomy')) {
 *   $this->links(taxonomy_link('taxonomy terms', $node));
 * }
 */
Dries's avatar
 
Dries committed
27
function taxonomy_link($type, $node = NULL) {
Dries's avatar
 
Dries committed
28
  if ($type == 'taxonomy terms' && $node != NULL) {
Kjartan's avatar
 
Kjartan committed
29
    $links = array();
Dries's avatar
 
Dries committed
30
    if (array_key_exists('taxonomy', $node)) {
Dries's avatar
 
Dries committed
31 32
      foreach ($node->taxonomy as $tid) {
        $term = taxonomy_get_term($tid);
Dries's avatar
 
Dries committed
33
        $links[] = l($term->name, 'taxonomy/term/'. $term->tid);
Dries's avatar
 
Dries committed
34 35 36 37 38
      }
    }
    else {
      $links = array();
      foreach (taxonomy_node_get_terms($node->nid) as $term) {
Dries's avatar
 
Dries committed
39
        $links[] = l($term->name, 'taxonomy/term/'. $term->tid);
Dries's avatar
 
Dries committed
40
      }
Dries's avatar
 
Dries committed
41 42 43 44

    }
    return $links;
  }
Kjartan's avatar
Kjartan committed
45 46
}

Dries's avatar
 
Dries committed
47 48 49
/**
 * Implementation of hook_menu().
 */
Dries's avatar
 
Dries committed
50
function taxonomy_menu($may_cache) {
Dries's avatar
 
Dries committed
51
  $items = array();
Dries's avatar
 
Dries committed
52

Dries's avatar
 
Dries committed
53 54 55 56
  if ($may_cache) {
    $items[] = array('path' => 'admin/taxonomy', 'title' => t('categories'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'));
57

Dries's avatar
 
Dries committed
58 59
    $items[] = array('path' => 'admin/taxonomy/list', 'title' => t('list'),
      'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -10);
60

Dries's avatar
 
Dries committed
61 62 63 64 65
    $items[] = array('path' => 'admin/taxonomy/add/vocabulary', 'title' => t('add vocabulary'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_LOCAL_TASK);

66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
    $items[] = array('path' => 'admin/taxonomy/edit/vocabulary', 'title' => t('edit vocabulary'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

    $items[] = array('path' => 'admin/taxonomy/add/term', 'title' => t('add term'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

    $items[] = array('path' => 'admin/taxonomy/edit/term', 'title' => t('edit term'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

Dries's avatar
 
Dries committed
81 82 83 84 85
    $items[] = array('path' => 'taxonomy/term', 'title' => t('taxonomy term'),
      'callback' => 'taxonomy_term_page',
      'access' => user_access('access content'),
      'type' => MENU_CALLBACK);
  }
Dries's avatar
Dries committed
86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101
  else {
    if (is_numeric(arg(2))) {
      $items[] = array('path' => 'admin/taxonomy/' . arg(2), 'title' => t('add term'),
        'callback' => 'taxonomy_admin',
        'access' => user_access('administer taxonomy'),
        'type' => MENU_CALLBACK);

      $items[] = array('path' => 'admin/taxonomy/' . arg(2) . '/list', 'title' => t('list'),
        'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -10);

      $items[] = array('path' => 'admin/taxonomy/' . arg(2) . '/add/term', 'title' => t('add term'),
        'callback' => 'taxonomy_admin',
        'access' => user_access('administer taxonomy'),
        'type' => MENU_LOCAL_TASK);
    }
  }
Dries's avatar
 
Dries committed
102

Dries's avatar
 
Dries committed
103 104
  return $items;
}
Dries's avatar
 
Dries committed
105

Kjartan's avatar
Kjartan committed
106
function taxonomy_form_vocabulary($edit = array()) {
Dries's avatar
Dries committed
107
  foreach (node_list() as $type) {
Dries's avatar
 
Dries committed
108 109
    $node_type = node_invoke($type, 'node_name');
    $nodes[$type] = $node_type ? $node_type : $type;
Kjartan's avatar
Kjartan committed
110
  }
Dries's avatar
 
Dries committed
111

Dries's avatar
 
Dries committed
112 113 114
  $form .= form_textfield(t('Vocabulary name'), 'name', $edit['name'], 50, 64, t('The name for this vocabulary.  Example: "Topic".'), NULL, TRUE);
  $form .= form_textarea(t('Description'), 'description', $edit['description'], 60, 5, t('Description of the vocabulary; can be used by modules.'));
  $form .= form_textfield(t('Help text'), 'help', $edit['help'], 50, 255, t('Instructions to present to the user when choosing a term.'));
Dries's avatar
 
Dries committed
115
  $form .= form_checkboxes(t('Types'), 'nodes', $edit['nodes'], $nodes, t('A list of node types you want to associate with this vocabulary.'), NULL, TRUE);
116
  $form .= form_radios(t('Hierarchy'), 'hierarchy', $edit['hierarchy'], array(t('Disabled'), t('Single'), t('Multiple')), t('Allows <a href="%help-url">a tree-like hierarchy</a> between terms of this vocabulary.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'hierarchy'))));
Dries's avatar
Dries committed
117 118 119
  $form .= form_checkbox(t('Related terms'), 'relations', 1, $edit['relations'], t('Allows <a href="%help-url">related terms</a> in this vocabulary.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'related-terms'))));
  $form .= form_checkbox(t('Free tagging'), 'tags', 1, $edit['tags'], t('Content is categorized by typing terms instead of choosing from a list.'));
  $form .= form_checkbox(t('Multiple select'), 'multiple', 1, $edit['multiple'], t('Allows nodes to have more than one term from this vocabulary (always true for free tagging).'));
Dries's avatar
 
Dries committed
120
  $form .= form_checkbox(t('Required'), 'required', 1, $edit['required'], t('If enabled, every node <strong>must</strong> have at least one term in this vocabulary.'));
Dries's avatar
 
Dries committed
121
  $form .= form_weight(t('Weight'), 'weight', $edit['weight'], 10, t('In listings, the heavier vocabularies will sink and the lighter vocabularies will be positioned nearer the top.'));
Dries's avatar
 
Dries committed
122
  $form .= form_submit(t('Submit'));
Dries's avatar
 
Dries committed
123

Dries's avatar
 
Dries committed
124 125 126
  if ($edit['vid']) {
    $form .= form_submit(t('Delete'));
    $form .= form_hidden('vid', $edit['vid']);
Dries's avatar
 
Dries committed
127 128
  }

Kjartan's avatar
Kjartan committed
129 130
  return form($form);
}
Kjartan's avatar
Kjartan committed
131

Kjartan's avatar
Kjartan committed
132
function taxonomy_save_vocabulary($edit) {
Dries's avatar
 
Dries committed
133 134
  if (!$edit['nodes']) {
    $edit['nodes'] = array();
Dries's avatar
 
Dries committed
135 136
  }

Dries's avatar
Dries committed
137
  $data = array('name' => $edit['name'], 'description' => $edit['description'], 'help' => $edit['help'], 'multiple' => $edit['multiple'], 'required' => $edit['required'], 'hierarchy' => $edit['hierarchy'], 'relations' => $edit['relations'], 'tags' => $edit['tags'], 'weight' => $edit['weight'],  'module' => isset($edit['module']) ? $edit['module'] : 'taxonomy');
Dries's avatar
 
Dries committed
138
  if ($edit['vid'] && $edit['name']) {
Dries's avatar
 
Dries committed
139
    db_query('UPDATE {vocabulary} SET '. _taxonomy_prepare_update($data) .' WHERE vid = %d', $edit['vid']);
Dries's avatar
 
Dries committed
140 141 142 143
    db_query("DELETE FROM {vocabulary_node_types} WHERE vid = %d", $edit['vid']);
    foreach ($edit['nodes'] as $type) {
      db_query("INSERT INTO {vocabulary_node_types} (vid, type) VALUES (%d, '%s')", $edit['vid'], $type);
    }
Dries's avatar
 
Dries committed
144
    module_invoke_all('taxonomy', 'update', 'vocabulary', $edit);
145
    $message = t('Updated vocabulary %name.', array('%name' => theme('placeholder', $edit['name'])));
Dries's avatar
 
Dries committed
146
  }
Dries's avatar
 
Dries committed
147 148
  else if ($edit['vid']) {
    $message = taxonomy_del_vocabulary($edit['vid']);
Kjartan's avatar
Kjartan committed
149 150
  }
  else {
Dries's avatar
 
Dries committed
151
    $data['vid'] = $edit['vid'] = db_next_id('{vocabulary}_vid');
Dries's avatar
 
Dries committed
152
    db_query('INSERT INTO {vocabulary} '. _taxonomy_prepare_insert($data, 1) .' VALUES '. _taxonomy_prepare_insert($data, 2));
Dries's avatar
 
Dries committed
153 154 155
    foreach ($edit['nodes'] as $type) {
      db_query("INSERT INTO {vocabulary_node_types} (vid, type) VALUES (%d, '%s')", $edit['vid'], $type);
    }
Dries's avatar
 
Dries committed
156
    module_invoke_all('taxonomy', 'insert', 'vocabulary', $edit);
157
    $message = t('Created new vocabulary %name.', array('%name' => theme('placeholder', $edit['name'])));
Kjartan's avatar
Kjartan committed
158
  }
Dries's avatar
 
Dries committed
159 160

  cache_clear_all();
Dries's avatar
 
Dries committed
161

Dries's avatar
 
Dries committed
162
  drupal_set_message($message);
163

Dries's avatar
 
Dries committed
164
  return $edit;
Kjartan's avatar
Kjartan committed
165
}
Dries's avatar
 
Dries committed
166

Kjartan's avatar
Kjartan committed
167
function taxonomy_del_vocabulary($vid) {
Dries's avatar
 
Dries committed
168 169
  $vocabulary = taxonomy_get_vocabulary($vid);

Dries's avatar
 
Dries committed
170
  db_query('DELETE FROM {vocabulary} WHERE vid = %d', $vid);
Dries's avatar
 
Dries committed
171
  db_query('DELETE FROM {vocabulary_node_types} WHERE vid = %d', $vid);
Dries's avatar
 
Dries committed
172
  $result = db_query('SELECT tid FROM {term_data} WHERE vid = %d', $vid);
Kjartan's avatar
Kjartan committed
173 174
  while ($term = db_fetch_object($result)) {
    taxonomy_del_term($term->tid);
Dries's avatar
 
Dries committed
175
  }
Dries's avatar
 
Dries committed
176

Dries's avatar
 
Dries committed
177
  module_invoke_all('taxonomy', 'delete', 'vocabulary', $vocabulary);
Dries's avatar
 
Dries committed
178

Dries's avatar
 
Dries committed
179 180
  cache_clear_all();

Dries's avatar
 
Dries committed
181
  return t('deleted vocabulary "%name".', array('%name' => $vocabulary->name));
Dries's avatar
 
Dries committed
182 183 184 185 186
}

function _taxonomy_confirm_del_vocabulary($vid) {
  $vocabulary = taxonomy_get_vocabulary($vid);

187 188 189 190 191 192 193 194 195 196 197
  $extra  = form_hidden('type', 'vocabulary');
  $extra .= form_hidden('vid', $vid);

  $output = theme('confirm',
                  t('Are you sure you want to delete the vocabulary %title?', array('%title' => $vocabulary->name)),
                  'admin/taxonomy',
                  t('Deleting a vocabulary will delete all the terms in it. This action cannot be undone.'),
                  t('Delete'),
                  t('Cancel'),
                  $extra);
  return $output;
Kjartan's avatar
Kjartan committed
198
}
Dries's avatar
 
Dries committed
199

Kjartan's avatar
Kjartan committed
200
function taxonomy_form_term($edit = array()) {
Dries's avatar
 
Dries committed
201
  $vocabulary_id = isset($edit['vid']) ? $edit['vid'] : arg(4);
Kjartan's avatar
Kjartan committed
202
  $vocabulary = taxonomy_get_vocabulary($vocabulary_id);
Dries's avatar
 
Dries committed
203

Dries's avatar
 
Dries committed
204 205
  $form = form_textfield(t('Term name'), 'name', $edit['name'], 50, 64, t('The name for this term.  Example: "Linux".'), NULL, TRUE);
  $form .= form_textarea(t('Description'), 'description', $edit['description'], 60, 5, t('A description of the term.'));
Dries's avatar
 
Dries committed
206

Kjartan's avatar
Kjartan committed
207
  if ($vocabulary->hierarchy) {
Dries's avatar
 
Dries committed
208 209
    $parent = array_keys(taxonomy_get_parents($edit['tid']));
    $children = taxonomy_get_tree($vocabulary_id, $edit['tid']);
Dries's avatar
 
Dries committed
210

Dries's avatar
 
Dries committed
211
    // A term can't be the child of itself, nor of its children.
Dries's avatar
 
Dries committed
212 213 214
    foreach ($children as $child) {
      $exclude[] = $child->tid;
    }
Dries's avatar
 
Dries committed
215
    $exclude[] = $edit['tid'];
Dries's avatar
 
Dries committed
216

Kjartan's avatar
Kjartan committed
217
    if ($vocabulary->hierarchy == 1) {
218
      $form .= _taxonomy_term_select(t('Parent'), 'parent', $parent, $vocabulary_id, l(t('Parent term'), 'admin/help/taxonomy', NULL, NULL, 'parent') .'.', 0, '<'. t('root') .'>', $exclude);
Dries's avatar
 
Dries committed
219
    }
Kjartan's avatar
Kjartan committed
220
    elseif ($vocabulary->hierarchy == 2) {
221
      $form .= _taxonomy_term_select(t('Parents'), 'parent', $parent, $vocabulary_id, l(t('Parent terms'), 'admin/help/taxonomy', NULL, NULL, 'parent') .'.', 1, '<'. t('root') .'>', $exclude);
Dries's avatar
 
Dries committed
222
    }
Kjartan's avatar
Kjartan committed
223
  }
Dries's avatar
 
Dries committed
224

225
  if ($vocabulary->relations) {
Dries's avatar
 
Dries committed
226
    $form .= _taxonomy_term_select(t('Related terms'), 'relations', array_keys(taxonomy_get_related($edit['tid'])), $vocabulary_id, NULL, 1, '<'. t('none') .'>', array($edit['tid']));
227 228
  }

229
  $form .= form_textarea(t('Synonyms'), 'synonyms', implode("\n", taxonomy_get_synonyms($edit['tid'])), 30, 5, t('<a href="%help-url">Synonyms</a> of this term, one synonym per line.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'synonyms'))));
Dries's avatar
 
Dries committed
230
  $form .= form_weight(t('Weight'), 'weight', $edit['weight'], 10, t('In listings, the heavier terms will sink and the lighter terms will be positioned nearer the top.'));
Dries's avatar
 
Dries committed
231 232
  $form .= form_hidden('vid', $vocabulary->vid);
  $form .= form_submit(t('Submit'));
Kjartan's avatar
Kjartan committed
233

Dries's avatar
 
Dries committed
234 235 236
  if ($edit['tid']) {
    $form .= form_submit(t('Delete'));
    $form .= form_hidden('tid', $edit['tid']);
Dries's avatar
 
Dries committed
237
  }
238 239 240
  else {
    $form .= form_hidden('destination', $_GET['q']);
  }
Dries's avatar
 
Dries committed
241

Kjartan's avatar
Kjartan committed
242 243
  return form($form);
}
Dries's avatar
 
Dries committed
244

Kjartan's avatar
Kjartan committed
245
function taxonomy_save_term($edit) {
Dries's avatar
 
Dries committed
246 247
  if ($edit['tid'] && $edit['name']) {
    $data = array('name' => $edit['name'], 'description' => $edit['description'], 'weight' => $edit['weight']);
Dries's avatar
 
Dries committed
248

Dries's avatar
 
Dries committed
249
    db_query('UPDATE {term_data} SET '. _taxonomy_prepare_update($data) .' WHERE tid = %d', $edit['tid']);
Dries's avatar
 
Dries committed
250
    module_invoke_all('taxonomy', 'update', 'term', $edit);
251
    $message = t('The term %term has been updated.', array('%term' => theme('placeholder', $edit['name'])));
Kjartan's avatar
Kjartan committed
252
  }
Dries's avatar
 
Dries committed
253 254
  else if ($edit['tid']) {
    return taxonomy_del_term($edit['tid']);
Kjartan's avatar
Kjartan committed
255 256
  }
  else {
Dries's avatar
 
Dries committed
257 258
    $edit['tid'] = db_next_id('{term_data}_tid');
    $data = array('tid' => $edit['tid'], 'name' => $edit['name'], 'description' => $edit['description'], 'vid' => $edit['vid'], 'weight' => $edit['weight']);
Dries's avatar
 
Dries committed
259
    db_query('INSERT INTO {term_data} '. _taxonomy_prepare_insert($data, 1) .' VALUES '. _taxonomy_prepare_insert($data, 2));
Dries's avatar
 
Dries committed
260
    module_invoke_all('taxonomy', 'insert', 'term', $edit);
261
    $message = t('Created new term %term.', array('%term' => theme('placeholder', $edit['name'])));
Kjartan's avatar
Kjartan committed
262
  }
Dries's avatar
 
Dries committed
263

Dries's avatar
 
Dries committed
264 265 266
  db_query('DELETE FROM {term_relation} WHERE tid1 = %d OR tid2 = %d', $edit['tid'], $edit['tid']);
  if ($edit['relations']) {
    foreach ($edit['relations'] as $related_id) {
Kjartan's avatar
Kjartan committed
267
      if ($related_id != 0) {
Dries's avatar
 
Dries committed
268
        db_query('INSERT INTO {term_relation} (tid1, tid2) VALUES (%d, %d)', $edit['tid'], $related_id);
Dries's avatar
 
Dries committed
269
      }
Kjartan's avatar
Kjartan committed
270
    }
Kjartan's avatar
Kjartan committed
271
  }
Dries's avatar
 
Dries committed
272

Dries's avatar
 
Dries committed
273 274
  db_query('DELETE FROM {term_hierarchy} WHERE tid = %d', $edit['tid']);
  if (!isset($edit['parent'])) {
275
    $edit['parent'] = array(0);
Kjartan's avatar
Kjartan committed
276
  }
Dries's avatar
 
Dries committed
277 278
  if (is_array($edit['parent'])) {
    foreach ($edit['parent'] as $parent) {
279 280 281 282 283 284 285 286
      if (is_array($parent)) {
        foreach ($parent as $tid) {
          db_query('INSERT INTO {term_hierarchy} (tid, parent) VALUES (%d, %d)', $edit['tid'], $tid);
        }
      }
      else {
        db_query('INSERT INTO {term_hierarchy} (tid, parent) VALUES (%d, %d)', $edit['tid'], $parent);
      }
Dries's avatar
 
Dries committed
287
    }
Kjartan's avatar
Kjartan committed
288
  }
Dries's avatar
 
Dries committed
289

Dries's avatar
 
Dries committed
290 291 292
  db_query('DELETE FROM {term_synonym} WHERE tid = %d', $edit['tid']);
  if ($edit['synonyms']) {
    foreach (explode ("\n", str_replace("\r", '', $edit['synonyms'])) as $synonym) {
Dries's avatar
 
Dries committed
293
      if ($synonym) {
Dries's avatar
 
Dries committed
294
        db_query("INSERT INTO {term_synonym} (tid, name) VALUES (%d, '%s')", $edit['tid'], chop($synonym));
Dries's avatar
 
Dries committed
295
      }
Kjartan's avatar
Kjartan committed
296
    }
Dries's avatar
 
Dries committed
297
  }
Dries's avatar
 
Dries committed
298

Dries's avatar
 
Dries committed
299 300
  cache_clear_all();

Dries's avatar
 
Dries committed
301
  drupal_set_message($message);
Dries's avatar
 
Dries committed
302
  return $edit;
Kjartan's avatar
Kjartan committed
303
}
Dries's avatar
 
Dries committed
304

Kjartan's avatar
Kjartan committed
305
function taxonomy_del_term($tid) {
306 307 308 309 310 311 312 313 314 315 316 317 318 319
  $tids = array($tid);
  while ($tids) {
    $children_tids = $orphans = array();
    foreach ($tids as $tid) {
      // See if any of the term's children are about to be become orphans:
      if ($children = taxonomy_get_children($tid)) {
        foreach ($children as $child) {
          // If the term has multiple parents, we don't delete it.
          $parents = taxonomy_get_parents($child->tid);
          if (count($parents) == 1) {
            $orphans[] = $child->tid;
          }
        }
      }
Dries's avatar
 
Dries committed
320

321
      $term = taxonomy_get_term($tid);
Dries's avatar
 
Dries committed
322

323 324 325 326 327
      db_query('DELETE FROM {term_data} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_hierarchy} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_relation} WHERE tid1 = %d OR tid2 = %d', $tid, $tid);
      db_query('DELETE FROM {term_synonym} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_node} WHERE tid = %d', $tid);
Dries's avatar
 
Dries committed
328

329
      module_invoke_all('taxonomy', 'delete', 'term', $term);
330
      drupal_set_message(t('Deleted term %name.', array('%name' => theme('placeholder', $term->name))));
331
    }
Dries's avatar
 
Dries committed
332

333 334
    $tids = $orphans;
  }
Dries's avatar
 
Dries committed
335

Dries's avatar
 
Dries committed
336
  cache_clear_all();
Dries's avatar
 
Dries committed
337 338 339 340 341
}

function _taxonomy_confirm_del_term($tid) {
  $term = taxonomy_get_term($tid);

342 343
  $extra  = form_hidden('type', 'term');
  $extra .= form_hidden('tid', $tid);
Dries's avatar
 
Dries committed
344

345
  $output = theme('confirm',
346
                  t('Are you sure you want to delete the term %title?', array('%title' => theme('placeholder', $term->name))),
347 348 349 350 351
                  'admin/taxonomy',
                  t('Deleting a term will delete all its children if there are any. This action cannot be undone.'),
                  t('Delete'),
                  t('Cancel'),
                  $extra);
352 353

  return $output;
Kjartan's avatar
Kjartan committed
354
}
Dries's avatar
 
Dries committed
355

Dries's avatar
 
Dries committed
356 357 358
/**
 * Generate a tabular listing of administrative functions for vocabularies.
 */
Kjartan's avatar
Kjartan committed
359
function taxonomy_overview() {
Dries's avatar
 
Dries committed
360

Dries's avatar
Dries committed
361 362 363 364 365 366 367 368
  $vid = arg(2);

  // Show all vocabularies and their terms. if vocabulary is "Free tagging",
  // don't show terms here, but instruct user to "view terms" instead.
  if (!$vid) {
    $header = array(t('Name'), t('Type'), array('data' => t('Operations'), 'colspan' => '3'));
    $vocabularies = taxonomy_get_vocabularies();
    foreach ($vocabularies as $vocabulary) {
369 370 371 372 373 374 375 376 377 378 379 380 381
      $types = array();
      foreach ($vocabulary->nodes as $type) {
        $node_type = node_invoke($type, 'node_name');
        $types[] = $node_type ? $node_type : $type;
      }
      $rows[] = array('<strong>'.check_plain($vocabulary->name).'</strong>', implode(', ', $types), l(t('edit vocabulary'), "admin/taxonomy/edit/vocabulary/$vocabulary->vid"), l(t('add term'), "admin/taxonomy/add/term/$vocabulary->vid"), l(t('view terms'), "admin/taxonomy/$vocabulary->vid"));

      // Show terms if non-free.
      if (!$vocabulary->tags) {
        $tree = taxonomy_get_tree($vocabulary->vid);
        if ($tree) {
          foreach ($tree as $term) {
            $rows[] = array(array('data' => _taxonomy_depth($term->depth) . ' ' . check_plain($term->name), 'class' => 'term'), NULL, NULL, NULL, l(t('edit term'), "admin/taxonomy/edit/term/$term->tid"));
Dries's avatar
Dries committed
382 383
          }
        }
384 385
        else {
          $rows[] = array(array('data' => t('No terms available.'), 'colspan' => '5', 'class' => 'message'));
Dries's avatar
Dries committed
386
        }
387
      }
388 389 390
      elseif ($vocabulary->tags) {
        $rows[] = array(array('data' => t('This is a free tagging vocabulary:') . ' ' . l(t('view terms'), "admin/taxonomy/$vocabulary->vid") . '.', 'colspan' => '5', 'class' => 'message'));
      }
Dries's avatar
Dries committed
391 392 393 394 395 396
    }

    if (!$rows) {
      $rows[] = array(array('data' => t('No categories available.'), 'colspan' => '5', 'class' => 'message'));
    }
  }
Dries's avatar
 
Dries committed
397

Dries's avatar
Dries committed
398 399 400 401 402 403 404 405 406 407 408
  // Free tagging vocabularies get their own terms pager
  // since there is a greater chance of 1000+ terms.
  else {
    $header = array(t('Name'), array('data' => t('Operations'), 'width' => '60'));
    $vocabulary = taxonomy_get_vocabulary($vid);
    if ($vocabulary->module == 'taxonomy') {
      drupal_set_title(check_plain($vocabulary->name));
      $start_from      = $_GET['from'] ? $_GET['from'] : 0;
      $total_entries   = 0;  // total count for pager
      $page_increment  = 25; // number of tids per page
      $displayed_count = 0;  // number of tids shown
Kjartan's avatar
Kjartan committed
409

410
      $tree = taxonomy_get_tree($vocabulary->vid);
Kjartan's avatar
Kjartan committed
411
      foreach ($tree as $term) {
Dries's avatar
Dries committed
412 413 414 415
        $total_entries++; // we're counting all-totals, not displayed
        if (($start_from && $start_from > $total_entries) || ($displayed_count == $page_increment)) { continue; }
        $rows[] = array(_taxonomy_depth($term->depth) . ' ' . check_plain($term->name), l(t('edit term'), "admin/taxonomy/edit/term/$term->tid"));
        $displayed_count++; // we're counting tids displayed
Dries's avatar
 
Dries committed
416
      }
Dries's avatar
Dries committed
417 418 419

      if (!$rows) {
        $rows[] = array(array('data' => t('No terms available.'), 'colspan' => '2'));
420
      }
Dries's avatar
 
Dries committed
421

Dries's avatar
Dries committed
422 423 424 425
      $GLOBALS['pager_from_array'][] = $start_from;
      $GLOBALS['pager_total'][]      = $total_entries;
      $rows[] = array(array('data' => theme('pager', NULL, $page_increment), 'colspan' => '2'));
    }
Dries's avatar
 
Dries committed
426 427
  }

Dries's avatar
Dries committed
428
  return theme('table', $header, $rows, array('id' => 'taxonomy'));
Kjartan's avatar
Kjartan committed
429 430
}

Dries's avatar
 
Dries committed
431 432 433
/**
 * Generate a form element for selecting terms from a vocabulary.
 */
Dries's avatar
 
Dries committed
434
function taxonomy_form($vid, $value = 0, $help = NULL, $name = 'taxonomy') {
Dries's avatar
 
Dries committed
435
  $vocabulary = taxonomy_get_vocabulary($vid);
436
  $help = ($help) ? $help : $vocabulary->help;
Kjartan's avatar
Kjartan committed
437 438 439 440
  if ($vocabulary->required) {
    $blank = 0;
  }
  else {
Dries's avatar
 
Dries committed
441
    $blank = '<'. t('none') .'>';
Kjartan's avatar
Kjartan committed
442
  }
Dries's avatar
 
Dries committed
443

444
  return _taxonomy_term_select(check_plain($vocabulary->name), $name, $value, $vid, $help, intval($vocabulary->multiple), $blank);
Kjartan's avatar
Kjartan committed
445
}
Dries's avatar
 
Dries committed
446

447
/**
448 449 450
 * Generate a set of options for selecting a term from all vocabularies. Can be
 * passed to form_select.
 */
Dries's avatar
Dries committed
451
function taxonomy_form_all($free_tags = 0) {
452 453 454
  $vocabularies = taxonomy_get_vocabularies();
  $options = array();
  foreach ($vocabularies as $vid => $vocabulary) {
Dries's avatar
Dries committed
455
    if ($vocabulary->tags && !$free_tags) { continue; }
456 457 458 459 460 461 462 463 464 465 466
    $tree = taxonomy_get_tree($vid);
    $options[$vocabulary->name] = array();
    if ($tree) {
      foreach ($tree as $term) {
        $options[$vocabulary->name][$term->tid] = _taxonomy_depth($term->depth, '-') . $term->name;
      }
    }
  }
  return $options;
}

Dries's avatar
 
Dries committed
467 468 469 470 471 472
/**
 * Return an array of all vocabulary objects.
 *
 * @param $type
 *   If set, return only those vocabularies associated with this node type.
 */
Dries's avatar
 
Dries committed
473
function taxonomy_get_vocabularies($type = NULL) {
Kjartan's avatar
Kjartan committed
474
  if ($type) {
475
    $result = db_query("SELECT v.*, n.type FROM {vocabulary} v LEFT JOIN {vocabulary_node_types} n ON v.vid = n.vid WHERE n.type = '%s' ORDER BY v.weight, v.name", $type);
Kjartan's avatar
Kjartan committed
476 477
  }
  else {
478
    $result = db_query('SELECT v.*, n.type FROM {vocabulary} v LEFT JOIN {vocabulary_node_types} n ON v.vid = n.vid ORDER BY v.weight, v.name');
Kjartan's avatar
Kjartan committed
479
  }
Dries's avatar
 
Dries committed
480

Kjartan's avatar
Kjartan committed
481
  $vocabularies = array();
Dries's avatar
 
Dries committed
482
  $node_types = array();
Kjartan's avatar
Kjartan committed
483
  while ($voc = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
484 485 486 487
    $node_types[$voc->vid][] = $voc->type;
    unset($voc->type);
    $voc->nodes = $node_types[$voc->vid];
    $vocabularies[$voc->vid] = $voc;
Dries's avatar
 
Dries committed
488
  }
Dries's avatar
 
Dries committed
489

Kjartan's avatar
Kjartan committed
490 491
  return $vocabularies;
}
Dries's avatar
 
Dries committed
492

Dries's avatar
 
Dries committed
493 494 495
/**
 * Generate a form for selecting terms to associate with a node.
 */
Dries's avatar
 
Dries committed
496
function taxonomy_node_form($type, $node = '', $help = NULL, $name = 'taxonomy') {
Dries's avatar
Dries committed
497
  if (!array_key_exists('taxonomy', $node)) {
Kjartan's avatar
Kjartan committed
498
    if ($node->nid) {
Dries's avatar
Dries committed
499
      $terms = taxonomy_node_get_terms($node->nid);
Kjartan's avatar
Kjartan committed
500 501
    }
    else {
Dries's avatar
Dries committed
502
      $terms = array();
Dries's avatar
 
Dries committed
503
    }
Kjartan's avatar
Kjartan committed
504 505 506 507
  }
  else {
    $terms = $node->taxonomy;
  }
Dries's avatar
 
Dries committed
508

Dries's avatar
 
Dries committed
509
  $c = db_query("SELECT v.*, n.type FROM {vocabulary} v INNER JOIN {vocabulary_node_types} n ON v.vid = n.vid WHERE n.type = '%s' ORDER BY v.weight, v.name", $type);
Kjartan's avatar
Kjartan committed
510
  while ($vocabulary = db_fetch_object($c)) {
Dries's avatar
Dries committed
511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530
    if ($vocabulary->tags) {
      $typed_terms = array();
      foreach ($terms as $term) {
        if ($term->vid == $vocabulary->vid) {

          // Commas and quotes in terms are special cases, so encode 'em.
          if (preg_match('/,/', $term->name) || preg_match('/"/', $term->name)) {
            $term->name = '"'.preg_replace('/"/', '""', $term->name).'"';
          }

          $typed_terms[] = $term->name;
        }
      }
      $typed_string = implode(', ', $typed_terms) . (array_key_exists('tags', $terms) ? $terms['tags'][$vocabulary->vid] : NULL);
      $result[] = form_textfield($vocabulary->name, 'taxonomy][tags]['. $vocabulary->vid, $typed_string, 50, 100, t('A comma-separated list of terms describing this content (Example: funny, bungie jumping, "Company, Inc.").'), NULL, ($vocabulary->required ? TRUE : FALSE));
    }
    else {
      $ntterms = array_key_exists('taxonomy', $node) ? $terms : array_keys($terms);
      $result[] = taxonomy_form($vocabulary->vid, $ntterms, $help, $name);
    }
Dries's avatar
 
Dries committed
531
  }
Kjartan's avatar
Kjartan committed
532 533
  return $result ? $result : array();
}
Dries's avatar
 
Dries committed
534

Dries's avatar
 
Dries committed
535 536 537 538 539
/**
 * Find all terms associated to the given node, within one vocabulary.
 */
function taxonomy_node_get_terms_by_vocabulary($nid, $vid, $key = 'tid') {
  $result = db_query('SELECT t.* FROM {term_data} t, {term_node} r WHERE t.tid = r.tid AND t.vid = %d AND r.nid = %d ORDER BY weight', $vid, $nid);
Kjartan's avatar
Kjartan committed
540 541 542
  $terms = array();
  while ($term = db_fetch_object($result)) {
    $terms[$term->$key] = $term;
Dries's avatar
 
Dries committed
543
  }
Kjartan's avatar
Kjartan committed
544 545 546
  return $terms;
}

Dries's avatar
 
Dries committed
547 548 549 550
/**
 * Find all terms associated to the given node.
 */
function taxonomy_node_get_terms($nid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
551
  static $terms;
Dries's avatar
 
Dries committed
552

Dries's avatar
 
Dries committed
553
  if (!isset($terms[$nid])) {
Dries's avatar
 
Dries committed
554
    $result = db_query('SELECT t.* FROM {term_data} t, {term_node} r WHERE r.tid = t.tid AND r.nid = %d ORDER BY weight, name', $nid);
Kjartan's avatar
Kjartan committed
555
    $terms[$nid] = array();
Dries's avatar
 
Dries committed
556
    while ($term = db_fetch_object($result)) {
Kjartan's avatar
Kjartan committed
557
      $terms[$nid][$term->$key] = $term;
Dries's avatar
 
Dries committed
558 559
    }
  }
Kjartan's avatar
Kjartan committed
560 561
  return $terms[$nid];
}
Dries's avatar
 
Dries committed
562

Dries's avatar
Dries committed
563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579
/**
 * Make sure incoming vids are free tagging enabled.
 */
function taxonomy_node_validate(&$node) {
  if ($node->taxonomy) {
    $terms = $node->taxonomy;
    if ($terms['tags']) {
      foreach ($terms['tags'] as $vid => $vid_value) {
        $vocabulary = taxonomy_get_vocabulary($vid);
        if (!$vocabulary->tags) {
          form_set_error("taxonomy[tags][$vid", t('The %name vocabulary can not be modified in this way.', array('%name' => theme('placeholder', $vocabulary->name))));
        }
      }
    }
  }
}

Dries's avatar
 
Dries committed
580 581 582
/**
 * Save term associations for a given node.
 */
Kjartan's avatar
Kjartan committed
583
function taxonomy_node_save($nid, $terms) {
584
  taxonomy_node_delete($nid);
Dries's avatar
Dries committed
585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625

  // Free tagging vocabularies do not send their tids in the form,
  // so we'll detect them here and process them independently.
  if ($terms['tags']) {
    $typed_input = $terms['tags'];
    unset($terms['tags']);

    foreach ($typed_input as $vid => $vid_value) {
      // This regexp allows the following types of user input:
      // this, "somecmpany, llc", "and ""this"" w,o.rks", foo bar
      $regexp = '%(?:^|,\ *)("(?>[^"]*)(?>""[^"]* )*"|(?: [^",]*))%x';
      preg_match_all($regexp, $vid_value, $matches);
      $typed_terms = $matches[1];

      foreach ($typed_terms as $typed_term) {
        // If a user has escaped a term (to demonstrate that it is a group,
        // or includes a comma or quote character), we remove the escape
        // formatting so to save the term into the DB as the user intends.
        $typed_term = str_replace('""', '"', preg_replace('/^"(.*)"$/', '\1', $typed_term));
        $typed_term = trim($typed_term);
        if ($typed_term == "") { continue; }

        // See if the term exists in the chosen vocabulary
        // and return the tid, otherwise, add a new record.
        $possibilities = taxonomy_get_term_by_name($typed_term);
        $typed_term_tid = NULL; // tid match if any.
        foreach ($possibilities as $possibility) {
          if ($possibility->vid == $vid) {
            $typed_term_tid = $possibility->tid;
          }
        }

        if (!$typed_term_tid) {
          $new_term = taxonomy_save_term(array('vid' => $vid, 'name' => $typed_term));
          $typed_term_tid = $new_term['tid'];
        }

        db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $typed_term_tid);
      }
    }
  }
Dries's avatar
 
Dries committed
626

627
  if (is_array($terms)) {
Dries's avatar
 
Dries committed
628
    foreach ($terms as $term) {
629 630 631 632 633 634 635
      if (is_array($term)) {
        foreach ($term as $tid) {
          if ($tid) {
            db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $tid);
          }
        }
      }
636
      else if ($term) {
Dries's avatar
 
Dries committed
637
        db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $term);
638
      }
Dries's avatar
 
Dries committed
639 640
    }
  }
Kjartan's avatar
Kjartan committed
641
}
Dries's avatar
 
Dries committed
642

Dries's avatar
 
Dries committed
643 644 645
/**
 * Remove associations of a node to its terms.
 */
Kjartan's avatar
Kjartan committed
646
function taxonomy_node_delete($nid) {
Dries's avatar
 
Dries committed
647
  db_query('DELETE FROM {term_node} WHERE nid = %d', $nid);
Kjartan's avatar
Kjartan committed
648
}
Dries's avatar
 
Dries committed
649

Dries's avatar
 
Dries committed
650 651 652 653
/**
 * Find all term objects related to a given term ID.
 */
function taxonomy_get_related($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
654
  if ($tid) {
Dries's avatar
 
Dries committed
655
    $result = db_query('SELECT t.*, tid1, tid2 FROM {term_relation}, {term_data} t WHERE (t.tid = tid1 OR t.tid = tid2) AND (tid1 = %d OR tid2 = %d) AND t.tid != %d ORDER BY weight, name', $tid, $tid, $tid);
Kjartan's avatar
Kjartan committed
656 657 658
    $related = array();
    while ($term = db_fetch_object($result)) {
      $related[$term->$key] = $term;
Dries's avatar
 
Dries committed
659
    }
Kjartan's avatar
Kjartan committed
660
    return $related;
Dries's avatar
 
Dries committed
661
  }
Kjartan's avatar
Kjartan committed
662 663
  else {
    return array();
Dries's avatar
 
Dries committed
664
  }
Kjartan's avatar
Kjartan committed
665
}
Dries's avatar
 
Dries committed
666

Dries's avatar
 
Dries committed
667 668 669 670
/**
 * Find all parents of a given term ID.
 */
function taxonomy_get_parents($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
671
  if ($tid) {
Dries's avatar
 
Dries committed
672
    $result = db_query('SELECT t.* FROM {term_hierarchy} h, {term_data} t WHERE h.parent = t.tid AND h.tid = %d ORDER BY weight, name', $tid);
Kjartan's avatar
Kjartan committed
673 674 675
    $parents = array();
    while ($parent = db_fetch_object($result)) {
      $parents[$parent->$key] = $parent;
Dries's avatar
 
Dries committed
676
    }
Kjartan's avatar
Kjartan committed
677
    return $parents;
Dries's avatar
 
Dries committed
678
  }
Kjartan's avatar
Kjartan committed
679 680 681 682
  else {
    return array();
  }
}
Dries's avatar
 
Dries committed
683

Dries's avatar
 
Dries committed
684 685 686 687
/**
 * Find all ancestors of a given term ID.
 */
function taxonomy_get_parents_all($tid) {
Dries's avatar
 
Dries committed
688 689 690 691 692 693 694 695 696 697 698 699
  $parents = array();
  if ($tid) {
    $parents[] = taxonomy_get_term($tid);
    $n = 0;
    while ($parent = taxonomy_get_parents($parents[$n]->tid)) {
      $parents = array_merge($parents, $parent);
      $n++;
    }
  }
  return $parents;
}

Dries's avatar
 
Dries committed
700 701 702 703
/**
 * Find all children of a term ID.
 */
function taxonomy_get_children($tid, $vid = 0, $key = 'tid') {
Kjartan's avatar
Kjartan committed
704
  if ($vid) {
Dries's avatar
 
Dries committed
705
    $result = db_query('SELECT t.* FROM {term_hierarchy} h, {term_data} t WHERE t.vid = %d AND h.tid = t.tid AND h.parent = %d ORDER BY weight, name', $vid, $tid);
Dries's avatar
 
Dries committed
706
  }
Kjartan's avatar
Kjartan committed
707
  else {
Dries's avatar
 
Dries committed
708
    $result = db_query('SELECT t.* FROM {term_hierarchy} h, {term_data} t WHERE h.tid = t.tid AND parent = %d ORDER BY weight', $tid);
Kjartan's avatar
Kjartan committed
709 710 711 712 713 714 715
  }
  $children = array();
  while ($term = db_fetch_object($result)) {
    $children[$term->$key] = $term;
  }
  return $children;
}
Dries's avatar
 
Dries committed
716

Dries's avatar
 
Dries committed
717 718 719 720 721 722 723 724 725 726 727 728 729
/**
 * Create a hierarchical representation of a vocabulary.
 *
 * @param $vid
 *   Which vocabulary to generate the tree for.
 *
 * @param $parent
 *   The term ID under which to generate the tree. If 0, generate the tree
 *   for the entire vocabulary.
 *
 * @param $depth
 *   Internal use only.
 *
Dries's avatar
 
Dries committed
730 731 732
 * @param $max_depth
 *   The number of levels of the tree to return. Leave NULL to return all levels.
 *
Dries's avatar
 
Dries committed
733 734 735 736 737
 * @return
 *   An array of all term objects in the tree. Each term object is extended
 *   to have "depth" and "parents" attributes in addition to its normal ones.
 */
function taxonomy_get_tree($vid, $parent = 0, $depth = -1, $max_depth = NULL) {
Dries's avatar
 
Dries committed
738
  static $children, $parents, $terms;
Dries's avatar
 
Dries committed
739

Kjartan's avatar
Kjartan committed
740
  $depth++;
Dries's avatar
 
Dries committed
741

Dries's avatar
 
Dries committed
742 743 744 745
  // We cache trees, so it's not CPU-intensive to call get_tree() on a term
  // and its children, too.
  if (!isset($children[$vid])) {
    $children[$vid] = array();
Dries's avatar
 
Dries committed
746

Dries's avatar
 
Dries committed
747
    $result = db_query('SELECT t.*, parent FROM {term_data} t, {term_hierarchy} h WHERE t.tid = h.tid AND t.vid = %d ORDER BY weight, name', $vid);
Dries's avatar
 
Dries committed
748
    while ($term = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
749 750 751
      $children[$vid][$term->parent][] = $term->tid;
      $parents[$vid][$term->tid][] = $term->parent;
      $terms[$vid][$term->tid] = $term;
Dries's avatar
 
Dries committed
752 753
    }
  }
Dries's avatar
 
Dries committed
754

Dries's avatar
 
Dries committed
755
  $max_depth = (is_null($max_depth)) ? count($children[$vid]) : $max_depth;
Dries's avatar
Dries committed
756 757 758 759 760 761 762 763 764 765 766 767
  if ($children[$vid][$parent]) {
    foreach ($children[$vid][$parent] as $child) {
      if ($max_depth > $depth) {
        $terms[$vid][$child]->depth = $depth;
        // The "parent" attribute is not useful, as it would show one parent only.
        unset($terms[$vid][$child]->parent);
        $terms[$vid][$child]->parents = $parents[$vid][$child];
        $tree[] = $terms[$vid][$child];

        if ($children[$vid][$child]) {
          $tree = array_merge($tree, taxonomy_get_tree($vid, $child, $depth, $max_depth));
        }
Dries's avatar
 
Dries committed
768
      }
Dries's avatar
 
Dries committed
769
    }
Kjartan's avatar
Kjartan committed
770
  }
Dries's avatar
 
Dries committed
771

Dries's avatar
 
Dries committed
772
  return $tree ? $tree : array();
Kjartan's avatar
Kjartan committed
773
}
Dries's avatar
 
Dries committed
774

Dries's avatar
 
Dries committed
775 776 777
/**
 * Return an array of synonyms of the given term ID.
 */
Kjartan's avatar
Kjartan committed
778 779
function taxonomy_get_synonyms($tid) {
  if ($tid) {
Dries's avatar
 
Dries committed
780
    $result = db_query('SELECT name FROM {term_synonym} WHERE tid = %d', $tid);
Kjartan's avatar
Kjartan committed
781
    while ($synonym = db_fetch_array($result)) {
Dries's avatar
 
Dries committed
782
      $synonyms[] = $synonym['name'];
Dries's avatar
 
Dries committed
783
    }
Kjartan's avatar
Kjartan committed
784
    return $synonyms ? $synonyms : array();
Dries's avatar
 
Dries committed
785
  }
Kjartan's avatar
Kjartan committed
786 787
  else {
    return array();
Dries's avatar
 
Dries committed
788
  }
Kjartan's avatar
Kjartan committed
789
}
Dries's avatar
 
Dries committed
790

Dries's avatar
 
Dries committed
791 792 793 794 795
/**
 * Return the term object that has the given string as a synonym.
 */
function taxonomy_get_synonym_root($synonym) {
  return db_fetch_object(db_query("SELECT * FROM {term_synonym} s, {term_data} t WHERE t.tid = s.tid AND s.name = '%s'", $synonym));
Kjartan's avatar
Kjartan committed
796
}
Dries's avatar
 
Dries committed
797

Dries's avatar
 
Dries committed
798 799 800
/**
 * Given a term id, count the number of published nodes in it.
 */
Dries's avatar
 
Dries committed
801
function taxonomy_term_count_nodes($tid, $type = 0) {
Kjartan's avatar
Kjartan committed
802
  static $count;
Dries's avatar
 
Dries committed
803

Dries's avatar
 
Dries committed
804 805 806
  if (!isset($count[$type])) {
    // $type == 0 always evaluates true is $type is a string
    if (is_numeric($type)) {
807
      $result = db_query(db_rewrite_sql('SELECT t.tid, COUNT(n.nid) AS c FROM {term_node} t INNER JOIN {node} n ON t.nid = n.nid WHERE n.status = 1 GROUP BY t.tid'));
Dries's avatar
 
Dries committed
808 809
    }
    else {
810
      $result = db_query(db_rewrite_sql("SELECT t.tid, COUNT(n.nid) AS c FROM {term_node} t, {node} n WHERE t.nid = n.nid AND n.status = 1 AND n.type = '%s' GROUP BY t.tid"), $type);
Dries's avatar
 
Dries committed
811
    }
Kjartan's avatar
Kjartan committed
812
    while ($term = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
813
      $count[$type][$term->tid] = $term->c;
Dries's avatar
 
Dries committed
814 815 816
    }
  }

Kjartan's avatar
Kjartan committed
817
  foreach (_taxonomy_term_children($tid) as $c) {
Dries's avatar
 
Dries committed
818
    $children_count += taxonomy_term_count_nodes($c, $type);
Kjartan's avatar
Kjartan committed
819
  }
Dries's avatar
 
Dries committed
820
  return $count[$type][$tid] + $children_count;
Kjartan's avatar
Kjartan committed
821 822
}

Dries's avatar
 
Dries committed
823 824 825
/**
 * Helper for taxonomy_term_count_nodes().
 */
Kjartan's avatar
Kjartan committed
826 827
function _taxonomy_term_children($tid) {
  static $children;
Dries's avatar
 
Dries committed
828

Dries's avatar
 
Dries committed
829
  if (!isset($children)) {
Dries's avatar
 
Dries committed
830
    $result = db_query('SELECT tid, parent FROM {term_hierarchy}');
Kjartan's avatar
Kjartan committed
831 832
    while ($term = db_fetch_object($result)) {
      $children[$term->parent][] = $term->tid;
Dries's avatar
 
Dries committed
833
    }
Dries's avatar
 
Dries committed
834
  }
Kjartan's avatar
Kjartan committed
835 836
  return $children[$tid] ? $children[$tid] : array();
}
Dries's avatar
 
Dries committed
837

Dries's avatar
 
Dries committed
838
/**
Dries's avatar
 
Dries committed
839
 * Try to map a string to an existing term, as for glossary use.
Dries's avatar
 
Dries committed
840
 *
Dries's avatar