* @version $Id$ * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ global $plug; function get_item_name($category, $id) { global $sql_object; $mapping = array( 'news' => array('table' => T_NEWS, 'field_name' => 'news_title', 'field_id' => 'news_id'), 'news-archives' => array('table' => T_NEWS, 'field_name' => 'news_title', 'field_id' => 'news_id'), 'publication' => array('table' => T_PUBLI, 'field_name' => 'publi_title', 'field_id' => 'publi_id'), 'publication-archives' => array('table' => T_PUBLI, 'field_name' => 'publi_title', 'field_id' => 'publi_id'), 'project' => array('table' => T_PROJECT, 'field_name' => 'project_name', 'field_id' => 'project_id'), 'project-archives' => array('table' => T_PROJECT, 'field_name' => 'project_name', 'field_id' => 'project_id'), 'workgroup' => array('table' => T_WORK, 'field_name' => 'workshop_denomination', 'field_id' => 'workshop_id'), 'page' => array('table' => T_PAGE, 'field_name' => 'page_title', 'field_id' => 'page_id') ); $name = false; if(array_key_exists($category, $mapping)) { $q = 'SELECT '.$mapping[$category]['field_name'].' as name from '.$mapping[$category]['table'].' WHERE '.$mapping[$category]['field_id'].' = '.$id.';'; // _debug($q, 'rewrite'); $data = $sql_object->DBSelect($q); if(isset($data[0]['name'])) $name = $data[0]['name']; } else { // logfile(LOG_MAINFILE, array(__FUNCTION__, 'Item not found - category : '. $category . ' - id : ' . $id)); } // _debug('cat : '. $category . ' - ID : ' . $id . ' - name : ' . $name, 'rewrite'); return $name; } /** * dynamicMenu($id, $wrap = true) * Replace the default menu function * by that one into public template * to make the dynamic Menu ready-to-use * @param integer $id * @param boolean $wrap * @todo handle url rewriting */ function dynamicMenu($id, $wrap = true, $accesskey = true, $arrow = true) { global $sql_object; $query = "SELECT * FROM l21_menu WHERE menu_parent=".$id." AND menu_active = 'Y' order by menu_order"; $result = $sql_object->DBSelect($query, 'OBJECT'); if($wrap) echo '