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 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391
  $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) {
      if ($vocabulary->module == 'taxonomy') {
        $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"));
            }
          }
          else {
            $rows[] = array(array('data' => t('No terms available.'), 'colspan' => '5', 'class' => 'message'));
          }
        }
        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'));
        }
392
      }
Dries's avatar
Dries committed
393 394 395 396 397 398
    }

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

Dries's avatar
Dries committed
400 401 402 403 404 405 406 407 408 409 410
  // 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
411

412
      $tree = taxonomy_get_tree($vocabulary->vid);
Kjartan's avatar
Kjartan committed
413
      foreach ($tree as $term) {
Dries's avatar
Dries committed
414 415 416 417
        $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
418
      }
Dries's avatar
Dries committed
419 420 421

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

Dries's avatar
Dries committed
424 425 426 427
      $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
428 429
  }

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

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

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

449
/**
450 451 452
 * Generate a set of options for selecting a term from all vocabularies. Can be
 * passed to form_select.
 */
Dries's avatar
Dries committed
453
function taxonomy_form_all($free_tags = 0) {
454 455 456
  $vocabularies = taxonomy_get_vocabularies();
  $options = array();
  foreach ($vocabularies as $vid => $vocabulary) {
Dries's avatar
Dries committed
457
    if ($vocabulary->tags && !$free_tags) { continue; }
458 459 460 461 462 463 464 465 466 467 468
    $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
469 470 471 472 473 474
/**
 * 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
475
function taxonomy_get_vocabularies($type = NULL) {
Kjartan's avatar
Kjartan committed
476
  if ($type) {
477
    $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
478 479
  }
  else {
480
    $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
481
  }
Dries's avatar
 
Dries committed
482

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

Kjartan's avatar
Kjartan committed
492 493
  return $vocabularies;
}
Dries's avatar
 
Dries committed
494

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

Dries's avatar
 
Dries committed
511
  $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
512
  while ($vocabulary = db_fetch_object($c)) {
Dries's avatar
Dries committed
513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532
    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
533
  }
Kjartan's avatar
Kjartan committed
534 535
  return $result ? $result : array();
}
Dries's avatar
 
Dries committed
536

Dries's avatar
 
Dries committed
537 538 539 540 541
/**
 * 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
542 543 544
  $terms = array();
  while ($term = db_fetch_object($result)) {
    $terms[$term->$key] = $term;
Dries's avatar
 
Dries committed
545
  }
Kjartan's avatar
Kjartan committed
546 547 548
  return $terms;
}

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

Dries's avatar
 
Dries committed
555
  if (!isset($terms[$nid])) {
Dries's avatar
 
Dries committed
556
    $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
557
    $terms[$nid] = array();
Dries's avatar
 
Dries committed
558
    while ($term = db_fetch_object($result)) {
Kjartan's avatar
Kjartan committed
559
      $terms[$nid][$term->$key] = $term;
Dries's avatar
 
Dries committed
560 561
    }
  }
Kjartan's avatar
Kjartan committed
562 563
  return $terms[$nid];
}
Dries's avatar
 
Dries committed
564

Dries's avatar
Dries committed
565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581
/**
 * 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
582 583 584
/**
 * Save term associations for a given node.
 */
Kjartan's avatar
Kjartan committed
585
function taxonomy_node_save($nid, $terms) {
Dries's avatar
Dries committed
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 626

  // 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
627

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

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

Dries's avatar
 
Dries committed
651 652 653 654
/**
 * Find all term objects related to a given term ID.
 */
function taxonomy_get_related($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
655
  if ($tid) {
Dries's avatar
 
Dries committed
656
    $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
657 658 659
    $related = array();
    while ($term = db_fetch_object($result)) {
      $related[$term->$key] = $term;
Dries's avatar
 
Dries committed
660
    }
Kjartan's avatar
Kjartan committed
661
    return $related;
Dries's avatar
 
Dries committed
662
  }
Kjartan's avatar
Kjartan committed
663 664
  else {
    return array();
Dries's avatar
 
Dries committed
665
  }
Kjartan's avatar
Kjartan committed
666
}
Dries's avatar
 
Dries committed
667

Dries's avatar
 
Dries committed
668 669 670 671
/**
 * Find all parents of a given term ID.
 */
function taxonomy_get_parents($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
672
  if ($tid) {
Dries's avatar
 
Dries committed
673
    $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
674 675 676
    $parents = array();
    while ($parent = db_fetch_object($result)) {
      $parents[$parent->$key] = $parent;
Dries's avatar
 
Dries committed
677
    }
Kjartan's avatar
Kjartan committed
678
    return $parents;
Dries's avatar
 
Dries committed
679
  }
Kjartan's avatar
Kjartan committed
680 681 682 683
  else {
    return array();
  }
}
Dries's avatar
 
Dries committed
684

Dries's avatar
 
Dries committed
685 686 687 688
/**
 * Find all ancestors of a given term ID.
 */
function taxonomy_get_parents_all($tid) {
Dries's avatar
 
Dries committed
689 690 691 692 693 694 695 696 697 698 699 700
  $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
701 702 703 704
/**
 * Find all children of a term ID.
 */
function taxonomy_get_children($tid, $vid = 0, $key = 'tid') {
Kjartan's avatar
Kjartan committed
705
  if ($vid) {
Dries's avatar
 
Dries committed
706
    $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
707
  }
Kjartan's avatar
Kjartan committed
708
  else {
Dries's avatar
 
Dries committed
709
    $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
710 711 712 713 714 715 716
  }
  $children = array();
  while ($term = db_fetch_object($result)) {
    $children[$term->$key] = $term;
  }
  return $children;
}
Dries's avatar
 
Dries committed
717

Dries's avatar
 
Dries committed
718 719 720 721 722 723 724 725 726 727 728 729 730
/**
 * 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
731 732 733
 * @param $max_depth
 *   The number of levels of the tree to return. Leave NULL to return all levels.
 *
Dries's avatar
 
Dries committed
734 735 736 737 738
 * @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
739
  static $children, $parents, $terms;
Dries's avatar
 
Dries committed
740

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

Dries's avatar
 
Dries committed
743 744 745 746
  // 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
747

Dries's avatar
 
Dries committed
748
    $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
749
    while ($term = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
750 751 752
      $children[$vid][$term->parent][] = $term->tid;
      $parents[$vid][$term->tid][] = $term->parent;
      $terms[$vid][$term->tid] = $term;
Dries's avatar
 
Dries committed
753 754
    }
  }
Dries's avatar
 
Dries committed
755

Dries's avatar
 
Dries committed
756
  $max_depth = (is_null($max_depth)) ? count($children[$vid]) : $max_depth;
Dries's avatar
Dries committed
757 758 759 760 761 762 763 764 765 766 767 768
  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
769
      }
Dries's avatar
 
Dries committed
770
    }
Kjartan's avatar
Kjartan committed
771
  }
Dries's avatar
 
Dries committed
772

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

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

Dries's avatar
 
Dries committed
792 793 794 795 796
/**
 * 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
797
}
Dries's avatar
 
Dries committed
798

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

Dries's avatar
 
Dries committed
805 806 807
  if (!isset($count[$type])) {
    // $type == 0 always evaluates true is $type is a string
    if (is_numeric($type)) {
808
      $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
809 810
    }
    else {
811
      $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
812
    }
Kjartan's avatar
Kjartan committed
813
    while ($term = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
814
      $count[$type][$term->tid] = $term->c;
Dries's avatar
 
Dries committed
815 816 817
    }
  }

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

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

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

Dries's avatar
 
Dries committed
839
/**
Dries's avatar
 
Dries committed
840
 * Try to map a string to an existing term, as for glossary use.
Dries's avatar
 
Dries committed
841
 *
Dries's avatar
 
Dries committed
842 843 844 845 846 847 848 849
 * Provides a case-insensitive and trimmed mapping, to maximize the
 * likelihood of a successful match.
 *
 * @param name
 *   Name of the term to search for.
 *
 * @return
 *   An array of matching term objects.
Dries's avatar
 
Dries committed
850 851
 */
function taxonomy_get_term_by_name($name) {
Dries's avatar
 
Dries committed
852
  $db_result = db_query("SELECT * FROM {term_data} WHERE LOWER('%s') LIKE LOWER(name)", trim($name));