'Taxonomy Block', 'description' => 'Show taxonomy in a block with i18n support', 'access arguments' => array('administer taxonomy_block'), 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_block_admin_settings'), 'type' => MENU_NORMAL_ITEM, 'file' => 'taxonomy_block.settings.inc', ); return $items; } /** * Implementation of hook_block(). * */ function taxonomy_block_block($op = 'list', $delta = 0) { if ($op == 'list') { $blocks[0]['info'] = 'Taxonomy Block'; return $blocks; } if ($op == 'view') { $vid = variable_get('taxonomy_block_settings_vid',1); $node_count = variable_get('taxonomy_block_settings_node_count',0); $num_term = 20; switch($delta) { case 0: $block['subject'] = 'Taxonomy Block'; $output = ''; //Check database $sql = " SELECT td.tid, td.name, th.parent from {term_data} td " ." INNER JOIN {term_hierarchy} th ON th.tid=td.tid " ." WHERE vid='%d' AND th.parent=0 ORDER BY name ASC LIMIT %d"; $term_parents = db_query($sql, $vid, $num_term ); $output .= '

'; while ($term_parent = db_fetch_object($term_parents)) { $tid_parent = $term_parent->tid; $name_parent= $term_parent->name; $output .= '
• '; if (module_exists("i18n")) { $output .= l(tt("taxonomy:term:$tid_parent:name", $name_parent), "taxonomy/term/$tid_parent"); } if (module_exists("taxonomy_redirect")) { // Get the redirect link $curterm = taxonomy_get_term($tid_parent); $redirect = taxonomy_redirect_term_path($curterm); $output.= l(t($name_parent), $redirect); } else { $output .= l(t($name_parent), "taxonomy/term/$tid_parent"); } if ($node_count) { $total_parent = db_result(db_query("SELECT COUNT(nid) FROM {term_node} WHERE tid = %d", $tid_parent)); $output .= " ($total_parent)"; } $output .= "
"; $sql_count_childs = " SELECT count(td.tid) from {term_data} td " ." INNER JOIN {term_hierarchy} th ON th.tid=td.tid " ." WHERE td.vid='%d' AND th.parent='%d'"; $count_childs = db_query($sql_count_childs, $vid, $tid_parent); $count_child = db_result($count_childs); if ($count_child) { $sql_term_childs = " SELECT td.tid, td.name from {term_data} td " ." INNER JOIN {term_hierarchy} th ON th.tid=td.tid " ." WHERE vid='%d' AND th.parent='%d' ORDER BY name ASC LIMIT %d"; $term_childs = db_query($sql_term_childs, $vid, $tid_parent, $num_term ); $output .= '
'; while ($term_child = db_fetch_object($term_childs)) { $tid_child = $term_child->tid; $name_child = $term_child->name; $output .= '
• '; if (module_exists("i18n")) { $output .= l(tt("taxonomy:term:$tid_child:name", $name_child), "taxonomy/term/$tid_child"); } if (module_exists("taxonomy_redirect")) { // Get the redirect link $curterm = taxonomy_get_term($tid_child); $redirect = taxonomy_redirect_term_path($curterm); $output.= l(t($name_child), $redirect); } else { $output .= l(t($name_child), "taxonomy/term/$tid_child"); } if ($node_count) { $total_child = db_result(db_query("SELECT COUNT(nid) FROM {term_node} WHERE tid = %d", $tid_child)); $output .= " ($total_child)"; } $output .= "
"; } $output .= "
"; } } $output .= "

"; $block['content'] = $output; break; } return $block; } } ?>