<?php
/***************************************************************************
 *                       blocks_imp_dyn_menu.php
 *                         -------------------
 *   begin                : 2007/02/06
 *   copyright            : Mighty Gorgon
 *   website              : http://www.mightygorgon.com
 *   email                :
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

if ( !defined('IN_PHPBB') )
{
    die('Hacking attempt');
}

if(!function_exists(imp_dyn_menu_block_func))
{
    function imp_dyn_menu_block_func()
    {
        global $phpbb_root_path, $template, $cms_config_vars, $block_id, $table_prefix, $phpEx, $db, $lang, $board_config, $theme, $images, $userdata;

        $template->_tpldata['cat_row.'] = array();
        //reset($template->_tpldata['cat_row.']);
        $template->_tpldata['menu_row.'] = array();
        //reset($template->_tpldata['menu_row.']);
        $template->_tpldata['show_hide.'] = array();
        //reset($template->_tpldata['show_hide.']);

        include_once($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_dyn_menu.' . $phpEx);

        $sql = "SELECT * FROM " . CMS_NAV_MENU_TABLE . "
                        WHERE menu_id = '" . intval($cms_config_vars['md_menu_id'][$block_id]) . "'
                            LIMIT 1";
        if ( !($result = $db->sql_query($sql, false, 'dyn_menu_')) )
        {
            message_die(GENERAL_ERROR, 'Could not query dynamic menu table');
        }
        //$row = $db->sql_fetchrow($result);
        while ($row = $db->sql_fetchrow($result))
        {
            break;
        }

        if ( ($row['menu_name_lang'] != '') && isset($lang[$row['menu_name_lang']]) )
        {
            $main_menu_name = $lang[$row['menu_name_lang']];
        }
        else
        {
            $main_menu_name = ( ($row['menu_name'] != '') ? $row['menu_name'] : $lang['quick_links']);
        }

        $sql = "SELECT * FROM " . CMS_NAV_MENU_TABLE . "
                        WHERE menu_parent_id = '" . intval($cms_config_vars['md_menu_id'][$block_id]) . "'
                        ORDER BY cat_parent_id ASC, menu_order ASC";
        if ( !($result = $db->sql_query($sql, false, 'dyn_menu_')) )
        {
            message_die(GENERAL_ERROR, 'Could not query dynamic menu table');
        }

        $menu_cat = array();
        $cat_item = array();
        $menu_item = array();
        while ($menu_item = $db->sql_fetchrow($result))
        {
            if ( $menu_item['cat_id'] > 0 )
            {
                $cat_item[$menu_item['cat_id']] = $menu_item;
            }
            if ( $menu_item['cat_parent_id'] > 0 )
            {
                $menu_cat[$menu_item['cat_parent_id']][$menu_item['menu_item_id']] = $menu_item;
            }
        }

        foreach($cat_item as $cat_item_data)
        {
            if ($cat_item_data['menu_status'] == false)
            {
                $cat_allowed = false;
            }
            else
            {
                $cat_allowed = true;
                $auth_level_req = $cat_item_data['auth_view'];
                switch($auth_level_req)
                {
                    case '0':
                        $cat_allowed = true;
                        break;
                    case '1':
                        $cat_allowed = ( $userdata['session_logged_in'] ? false : true );
                        break;
                    case '2':
                        $cat_allowed = ( $userdata['session_logged_in'] ? true : false );
                        break;
                    case '3':
                        $cat_allowed = ( ( ($userdata['user_level'] == MOD) || ($userdata['user_level'] == ADMIN) ) ? true : false );
                        break;
                    case '4':
                        $cat_allowed = ( ($userdata['user_level'] == ADMIN) ? true : false );
                        break;
                    default:
                        $cat_allowed = true;
                        break;
                }
            }

            if ( $cat_allowed == true )
            {


                //echo($cat_item_data['menu_name'] . '<br />');
                $cat_id = ($cat_item_data['cat_id']);
                if ( ($cat_item_data['menu_name_lang'] != '') && isset($lang['menu_item'][$cat_item_data['menu_name_lang']]) )
                {
                    $cat_name = $lang['menu_item'][$cat_item_data['menu_name_lang']];
                }
                else
                {
                    $cat_name = ( ($cat_item_data['menu_name'] != '') ? stripslashes($cat_item_data['menu_name']) : 'cat_item' . $cat_item_data['cat_id']);
                }
                $cat_icon = ( ($cat_item_data['menu_icon'] != '') ? '<img src="' . $cat_item_data['menu_icon'] . '" alt="" title="' . $cat_name . '" style="vertical-align:middle;" />&nbsp;&nbsp;' : '<img src="' . $images['nav_menu_sep'] . '" alt="" title="" style="vertical-align:middle;" />&nbsp;&nbsp;');
                //$cat_icon = ( ($cat_item_data['menu_icon'] != '') ? '<img src="' . $cat_item_data['menu_icon'] . '" alt="" title="' . $cat_name . '" style="vertical-align:middle;" />&nbsp;&nbsp;' : '&nbsp;');
                if ($cat_item_data['menu_link'] != '')
                {
                    $cat_link = append_sid($cat_item_data['menu_link']);
                    if ($cat_item_data['menu_link_external'] == true)
                    {
                        $cat_link .= '" target="_blank';
                    }
                }

                $template->assign_block_vars('cat_row', array(
                    'CAT_ID' => $cat_item_data['menu_parent_id'] . '_' . $cat_item_data['cat_id'],
                    'CAT_ITEM' => $cat_name,
                    'CAT_ICON' => $cat_icon,
                    )
                );

                foreach($menu_cat[$cat_id] as $menu_cat_item_data)
                {

                    if ($menu_cat_item_data['menu_status'] == false)
                    {
                        $menu_allowed = false;
                    }
                    else
                    {
                        $menu_allowed = true;
                        $auth_level_req = $menu_cat_item_data['auth_view'];
                        switch($auth_level_req)
                        {
                            case '0':
                                $menu_allowed = true;
                                break;
                            case '1':
                                $menu_allowed = ( $userdata['session_logged_in'] ? false : true );
                                break;
                            case '2':
                                $menu_allowed = ( $userdata['session_logged_in'] ? true : false );
                                break;
                            case '3':
                                $menu_allowed = ( ( ($userdata['user_level'] == MOD) || ($userdata['user_level'] == ADMIN) ) ? true : false );
                                break;
                            case '4':
                                $menu_allowed = ( ($userdata['user_level'] == ADMIN)? true : false );
                                break;
                            default:
                                $menu_allowed = true;
                                break;
                        }
                    }

                    if ( $menu_allowed == true )
                    {
                        //echo($menu_cat_item_data['menu_name'] . '<br />');
                        if ( ($menu_cat_item_data['menu_name_lang'] != '') && isset($lang['menu_item'][$menu_cat_item_data['menu_name_lang']]) )
                        {
                            $menu_name = $lang['menu_item'][$menu_cat_item_data['menu_name_lang']];
                        }
                        else
                        {
                            $menu_name = ( ($menu_cat_item_data['menu_name'] != '') ? stripslashes($menu_cat_item_data['menu_name']) : 'cat_item' . $menu_cat_item_data['cat_id']) ;
                        }
                        if ($menu_cat_item_data['menu_link_external'] == true)
                        {
                            $menu_link = $menu_cat_item_data['menu_link'];
                            $menu_link .= '" target="_blank';
                        }
                        else
                        {
                            $menu_link = append_sid($menu_cat_item_data['menu_link']);
                        }
                        $menu_icon = ( ($menu_cat_item_data['menu_icon'] != '') ? '<img src="' . $menu_cat_item_data['menu_icon'] . '" alt="" title="' . $menu_name . '" style="vertical-align:middle;" />' : '<img src="' . $images['nav_menu_sep'] . '" alt="" title="" style="vertical-align:middle;" />');

                        $template->assign_block_vars('cat_row.menu_row', array(
                            'MENU_ITEM' => $menu_name,
                            'MENU_LINK' => $menu_link,
                            'MENU_ICON' => $menu_icon,
                            )
                        );
                    }
                }
            }
        }

        if ($cms_config_vars['md_menu_show_hide'][$block_id] == true)
        {
            $template->assign_block_vars('show_hide_switch', array(
                )
            );
        }
        $template->assign_vars(array(
            'MAIN_MENU_NAME' => $main_menu_name,
            )
        );
    }
}

imp_dyn_menu_block_func();

?>

Set the permissions to CHMOD 777 to the following files and folders:

backup/
cache/
ctracker/logfiles/logfile_attempt_counter.txt
ctracker/logfiles/logfile_blocklist.txt
ctracker/logfiles/logfile_debug_mode.txt
ctracker/logfiles/logfile_malformed_logins.txt
ctracker/logfiles/logfile_spammer.txt
ctracker/logfiles/logfile_worms.txt
downloads/
files/
files/album/
files/album/cache/
files/album/med_cache/
files/album/wm_cache/
files/posted_images/
files/thumbs/
images/avatars/
logs/
pafiledb/uploads/
pafiledb/cache/
pafiledb/cache/templates/
pafiledb/cache/templates/ca_aphrodite/
pafiledb/cache/templates/mg_themes/


Set the permissions to CHMOD 666 to the following files:

includes/def_themes.php
includes/def_tree.php
includes/def_words.php

--
-- Estructura de tabla para la tabla `prueba_cms_block_variable`
--

DROP TABLE IF EXISTS `prueba_cms_block_variable`;
CREATE TABLE IF NOT EXISTS `prueba_cms_block_variable` (
  `bvid` int(10) NOT NULL auto_increment,
  `bid` int(10) NOT NULL default '0',
  `label` varchar(30) NOT NULL default '',
  `sub_label` varchar(255) default NULL,
  `config_name` varchar(30) NOT NULL default '',
  `field_options` varchar(255) default NULL,
  `field_values` varchar(255) default NULL,
  `type` tinyint(1) NOT NULL default '0',
  `block` varchar(255) default NULL,
  PRIMARY KEY  (`bvid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

--
-- Volcar la base de datos para la tabla `prueba_cms_block_variable`
--

INSERT INTO `prueba_cms_block_variable` (`bvid`, `bid`, `label`, `sub_label`, `config_name`, `field_options`, `field_values`, `type`, `block`) VALUES
(1, 0, 'Default Portal', 'Default Portal', 'default_portal', '', '', 1, '@Portal Config'),
(2, 0, 'Header width', 'Width of forum-wide left column in pixels', 'header_width', '', '', 1, '@Portal Config'),
(3, 0, 'Footer width', 'Width of forum-wide right column in pixels', 'footer_width', '', '', 1, '@Portal Config'),
(4, 3, 'Number of recent topics', 'number of topics displayed', 'md_num_recent_topics', '', '', 1, 'recent_topics'),
(5, 3, 'Recent Topics Style', 'choose static display or scrolling display', 'md_recent_topics_style', 'Scroll,Static', '1,0', 3, 'recent_topics'),
(6, 4, 'Poll Bar Length', 'decrease/increase the value for 1 vote bar length', 'md_poll_bar_length', '', '', 1, 'poll'),
(7, 4, 'Poll Forum ID(s)', 'comma delimited', 'md_poll_forum_id', '', '', 1, 'poll'),
(8, 8, 'Number of Top Posters', '', 'md_total_poster', '', '', 1, 'top_posters'),
(9, 9, 'Search option text', 'Text displayed as the default option', 'md_search_option_text', '', '', 1, 'search'),
(10, 11, 'Category to retrieve pics from', 'Enter 0 for all categories or comma delimited entries', 'md_cat_id', '', '', 1, 'album'),
(11, 11, 'Display from what galleries?', '', 'md_pics_all', 'Public,Public and Personal', '0,1', 3, 'album'),
(12, 11, 'Random or newest pics?', '', 'md_pics_sort', 'Newest,Random', '0,1', 3, 'album'),
(13, 11, 'Number of images to display', '', 'md_pics_number', '', '', 1, 'album'),
(14, 11, 'Number of columns', '', 'md_pics_cols_number', '1,2,3,4,5', '1,2,3,4,5', 3, 'album'),
(15, 11, 'Number of rows', '', 'md_pics_rows_number', '1,2,3,4', '1,2,3,4', 3, 'album'),
(16, 12, 'Links -> Style', 'choose static display or scrolling display', 'md_links_style', 'Scroll,Static', '1,0', 3, 'links'),
(17, 12, 'Links -> Own (Top)', 'show your own link button above other buttons', 'md_links_own1', 'Yes,No', '1,0', 3, 'links'),
(18, 12, 'Links -> Own (Bottom)', 'show your own link button below other buttons', 'md_links_own2', 'Yes,No', '1,0', 3, 'links'),
(19, 12, 'Links -> Code', 'show HTML for your own link button', 'md_links_code', 'Yes,No', '1,0', 3, 'links'),
(20, 14, 'Maximum Words', 'Select the maximum number of words to display', 'md_wordgraph_words', '', '', 1, 'wordgraph'),
(21, 14, 'Enable Word Counts', 'Display the total number of words next to each word', 'md_wordgraph_count', 'Yes,No', '1,0', 3, 'wordgraph'),
(22, 4, 'Poll Type', 'choose if you want to show latest or random', 'md_poll_type', 'Newest,Random', '0,1', 3, 'poll'),
(23, 19, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(24, 19, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(25, 18, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(26, 18, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(27, 20, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(28, 20, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(29, 23, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(30, 23, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(31, 25, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(32, 25, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(33, 28, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(34, 28, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(35, 31, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(36, 31, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(37, 34, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(38, 34, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(39, 37, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(40, 37, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(41, 43, 'Category to retrieve pics from', 'Enter 0 for all categories or comma delimited entries', 'md_cat_id', '', '', 1, 'album'),
(42, 43, 'Number of images to display', '', 'md_pics_number', '', '', 1, 'album'),
(43, 43, 'Number of rows', '', 'md_pics_rows_number', '1,2,3,4', '1,2,3,4', 3, 'album'),
(44, 43, 'Number of columns', '', 'md_pics_cols_number', '1,2,3,4,5', '1,2,3,4,5', 3, 'album'),
(45, 43, 'Random or newest pics?', '', 'md_pics_sort', 'Newest,Random', '0,1', 3, 'album'),
(46, 43, 'Display from what galleries?', '', 'md_pics_all', 'Public,Public and Personal', '0,1', 3, 'album'),
(47, 46, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(48, 46, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(49, 52, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(50, 52, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(51, 59, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(52, 59, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(56, 73, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(55, 73, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(57, 79, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(58, 79, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(59, 83, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(60, 83, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(61, 87, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(62, 87, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(63, 91, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(64, 91, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu'),
(65, 95, 'Menu block ID', 'Enter the ID of the menu block, type 0 for default', 'md_menu_id', '', '', 1, 'dyn_menu'),
(66, 95, 'Show / Hide', 'Enable Show/Hide Switch (it will work only on left block)', 'md_menu_show_hide', 'Yes,No', '1,0', 3, 'dyn_menu');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prueba_cms_config`
--

DROP TABLE IF EXISTS `prueba_cms_config`;
CREATE TABLE IF NOT EXISTS `prueba_cms_config` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `bid` int(10) NOT NULL default '0',
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

--
-- Volcar la base de datos para la tabla `prueba_cms_config`
--

INSERT INTO `prueba_cms_config` (`id`, `bid`, `config_name`, `config_value`) VALUES
(1, 0, 'default_portal', '1'),
(2, 0, 'header_width', '180'),
(3, 0, 'footer_width', '150'),
(4, 3, 'md_recent_topics_style', '1'),
(5, 3, 'md_num_recent_topics', '10'),
(6, 4, 'md_poll_bar_length', '65'),
(7, 4, 'md_poll_forum_id', '1,2,3,4,5,6,7'),
(8, 8, 'md_total_poster', '5'),
(9, 9, 'md_search_option_text', 'En 2 Ruedas'),
(10, 11, 'md_cat_id', '0'),
(11, 11, 'md_pics_all', '1'),
(12, 11, 'md_pics_sort', '0'),
(13, 11, 'md_pics_number', '3'),
(14, 11, 'md_pics_cols_number', '1'),
(15, 11, 'md_pics_rows_number', '3'),
(16, 12, 'md_links_style', '0'),
(17, 12, 'md_links_own1', '1'),
(18, 12, 'md_links_own2', '0'),
(19, 12, 'md_links_code', '1'),
(20, 14, 'md_wordgraph_words', '250'),
(21, 14, 'md_wordgraph_count', '1'),
(22, 4, 'md_poll_type', '1'),
(23, 19, 'md_menu_id', '2'),
(24, 19, 'md_menu_show_hide', '0'),
(25, 18, 'md_menu_id', '2'),
(26, 18, 'md_menu_show_hide', '0'),
(27, 20, 'md_menu_id', '2'),
(28, 20, 'md_menu_show_hide', '0'),
(29, 23, 'md_menu_id', '2'),
(30, 23, 'md_menu_show_hide', '0'),
(31, 25, 'md_menu_id', '2'),
(32, 25, 'md_menu_show_hide', '0'),
(33, 28, 'md_menu_id', '2'),
(34, 28, 'md_menu_show_hide', '0'),
(35, 31, 'md_menu_id', '2'),
(36, 31, 'md_menu_show_hide', '0'),
(37, 34, 'md_menu_id', '2'),
(38, 34, 'md_menu_show_hide', '0'),
(39, 37, 'md_menu_id', '2'),
(40, 37, 'md_menu_show_hide', '0'),
(41, 43, 'md_cat_id', '0'),
(42, 43, 'md_pics_number', '8'),
(43, 43, 'md_pics_rows_number', '2'),
(44, 43, 'md_pics_cols_number', '4'),
(45, 43, 'md_pics_sort', '1'),
(46, 43, 'md_pics_all', '1'),
(47, 46, 'md_menu_id', '2'),
(48, 46, 'md_menu_show_hide', '0'),
(49, 52, 'md_menu_id', '2'),
(50, 52, 'md_menu_show_hide', '0'),
(51, 59, 'md_menu_id', '2'),
(52, 59, 'md_menu_show_hide', '0'),
(56, 73, 'md_menu_show_hide', '0'),
(55, 73, 'md_menu_id', '2'),
(57, 79, 'md_menu_id', '2'),
(58, 79, 'md_menu_show_hide', '0'),
(59, 83, 'md_menu_id', '2'),
(60, 83, 'md_menu_show_hide', '0'),
(61, 87, 'md_menu_id', '2'),
(62, 87, 'md_menu_show_hide', '0'),
(63, 91, 'md_menu_id', '2'),
(64, 91, 'md_menu_show_hide', '0'),
(65, 95, 'md_menu_id', '2'),
(66, 95, 'md_menu_show_hide', '0');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prueba_cms_layout`
--

DROP TABLE IF EXISTS `prueba_cms_layout`;
CREATE TABLE IF NOT EXISTS `prueba_cms_layout` (
  `lid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `filename` varchar(100) NOT NULL default '',
  `template` varchar(100) NOT NULL default '',
  `forum_wide` tinyint(1) NOT NULL default '0',
  `view` tinyint(1) NOT NULL default '0',
  `edit_auth` tinyint(1) NOT NULL default '5',
  `groups` tinytext NOT NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Volcar la base de datos para la tabla `prueba_cms_layout`
--

INSERT INTO `prueba_cms_layout` (`lid`, `name`, `filename`, `template`, `forum_wide`, `view`, `edit_auth`, `groups`) VALUES
(1, '3 Columns', '', '3_column.tpl', 0, 0, 5, ''),
(2, '2 Columns', '', '2_column.tpl', 0, 0, 5, ''),
(3, 'Del Club :: Presentacion', '', '2_column.tpl', 0, 0, 3, ''),
(4, 'Del Club :: Como Pertenecer?', '', '2_column.tpl', 0, 0, 3, ''),
(5, 'Del Club :: Reglamento', '', '2_column.tpl', 0, 0, 3, ''),
(6, 'Del Club :: Puntos', '', '2_column.tpl', 0, 0, 3, ''),
(7, 'Patrocinadores :: Bike Wash', '', '2_column.tpl', 0, 0, 3, ''),
(8, 'Patrocinadores :: Cafezinho', '', '2_column.tpl', 0, 0, 3, ''),
(9, 'Patrocinadores :: K-Motos', '', '2_column.tpl', 0, 0, 3, ''),
(10, 'Patrocinadores :: Diego Servicios EVG', '', '2_column.tpl', 0, 0, 3, ''),
(11, 'Patrocinadores :: ACCE', '', '2_column.tpl', 0, 0, 3, ''),
(12, 'Del Club :: Productos', '', '2_column.tpl', 0, 0, 3, ''),
(13, 'Mapas :: Estacion Suramericana', '', '2_column.tpl', 0, 0, 3, ''),
(14, 'Mapas :: Cafezinho', '', '2_column.tpl', 0, 0, 3, ''),
(15, 'Mapas :: Texaco (San Diego)', '', '2_column.tpl', 0, 0, 3, ''),
(16, 'Mapas :: Mall Mediterraneo', '', '2_column.tpl', 0, 0, 3, ''),
(17, 'Mapas :: ESSO (Medellin-Bogota)', '', '2_column.tpl', 0, 0, 3, ''),
(18, 'Mapas :: Estacion Niquia', '', '2_column.tpl', 0, 0, 3, ''),
(19, 'Mapas :: Estacion Ayura', '', '2_column.tpl', 0, 0, 3, '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prueba_cms_layout_special`
--

DROP TABLE IF EXISTS `prueba_cms_layout_special`;
CREATE TABLE IF NOT EXISTS `prueba_cms_layout_special` (
  `lsid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `filename` varchar(100) NOT NULL default '',
  `template` varchar(100) NOT NULL default '',
  `forum_wide` tinyint(1) NOT NULL default '0',
  `view` tinyint(1) NOT NULL default '0',
  `edit_auth` tinyint(1) NOT NULL default '5',
  `groups` tinytext NOT NULL,
  PRIMARY KEY  (`lsid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Volcar la base de datos para la tabla `prueba_cms_layout_special`
--

INSERT INTO `prueba_cms_layout_special` (`lsid`, `name`, `filename`, `template`, `forum_wide`, `view`, `edit_auth`, `groups`) VALUES
(1, 'forum', 'forum', '', 0, 0, 5, ''),
(2, 'viewf', 'viewforum', '', 0, 0, 5, ''),
(3, 'viewt', 'viewtopic', '', 0, 0, 5, ''),
(4, 'viewonline', 'viewonline', '', 0, 0, 5, ''),
(5, 'search', 'search', '', 0, 0, 5, ''),
(6, 'profile', 'profile', '', 0, 0, 5, ''),
(7, 'memberlist', 'memberlist', '', 0, 0, 5, ''),
(8, 'group_cp', 'groupcp', '', 0, 0, 5, ''),
(9, 'faq', 'faq', '', 0, 0, 5, ''),
(10, 'rules', 'rules', '', 0, 0, 5, ''),
(11, 'download', 'dload', '', 0, 0, 5, ''),
(12, 'album', 'album', '', 0, 0, 5, ''),
(13, 'links', 'links', '', 0, 0, 5, ''),
(14, 'statistics', 'statistics', '', 0, 0, 5, ''),
(15, 'site_hist', 'site_hist', '', 0, 0, 5, ''),
(16, 'calendar', 'calendar', '', 0, 0, 5, ''),
(17, 'recent', 'recent', '', 0, 0, 5, ''),
(18, 'referrers', 'referrers', '', 0, 0, 5, ''),
(19, 'shoutbox', 'shoutbox_max', '', 0, 0, 5, ''),
(20, 'kb', 'kb', '', 0, 0, 5, ''),
(21, 'contact_us', 'contact_us', '', 0, 0, 5, '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prueba_cms_nav_menu`
--

DROP TABLE IF EXISTS `prueba_cms_nav_menu`;
CREATE TABLE IF NOT EXISTS `prueba_cms_nav_menu` (
  `menu_item_id` mediumint(8) unsigned NOT NULL auto_increment,
  `menu_id` mediumint(8) unsigned NOT NULL default '0',
  `menu_parent_id` mediumint(8) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `cat_parent_id` mediumint(8) unsigned NOT NULL default '0',
  `menu_status` tinyint(1) NOT NULL default '0',
  `menu_order` smallint(5) NOT NULL default '0',
  `menu_icon` varchar(255) default NULL,
  `menu_name_lang` varchar(150) default NULL,
  `menu_name` varchar(150) default NULL,
  `menu_desc` text,
  `menu_link` varchar(255) default NULL,
  `menu_link_external` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_view_group` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`menu_item_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;

--
-- Volcar la base de datos para la tabla `prueba_cms_nav_menu`
--

INSERT INTO `prueba_cms_nav_menu` (`menu_item_id`, `menu_id`, `menu_parent_id`, `cat_id`, `cat_parent_id`, `menu_status`, `menu_order`, `menu_icon`, `menu_name_lang`, `menu_name`, `menu_desc`, `menu_link`, `menu_link_external`, `auth_view`, `auth_view_group`) VALUES
(1, 1, 0, 0, 0, 0, 0, NULL, 'main_links', 'Main Links', 'Main Links Block', NULL, 0, 0, 0),
(2, 0, 1, 1, 0, 1, 3, './images/menu/application_view_tile.png', 'main_links', 'Main Links', 'Main Links', '', 0, 0, 0),
(3, 0, 1, 2, 0, 1, 3, './images/menu/newspaper.png', 'news', 'News', 'News', '', 0, 0, 0),
(4, 0, 1, 3, 0, 1, 4, './images/menu/information.png', 'info_links', 'Info', 'Info', '', 0, 0, 0),
(5, 0, 1, 4, 0, 1, 5, './images/menu/group.png', 'users_links', 'Users', 'Users & Groups', '', 0, 0, 0),
(6, 0, 1, 0, 1, 1, 1, '', 'ACP', 'ACP', 'ACP', 'adm/index.php', 0, 4, 0),
(7, 0, 1, 0, 1, 1, 2, '', 'cms', 'CMS', 'CMS', 'cms.php', 0, 4, 0),
(8, 0, 1, 0, 1, 1, 3, '', 'home', 'Home', 'Home Page', 'index.php', 0, 0, 0),
(9, 0, 1, 0, 1, 1, 4, '', 'forum', 'Forum', 'Forum', 'forum.php', 0, 0, 0),
(10, 0, 1, 0, 1, 1, 5, '', 'rules', 'Rules', 'Rules', 'rules.php', 0, 0, 0),
(11, 0, 1, 0, 1, 1, 6, '', 'faq', 'FAQ', 'FAQ', 'faq.php', 0, 0, 0),
(12, 0, 1, 0, 1, 1, 7, '', 'search', 'Search', 'Search', 'search.php', 0, 0, 0),
(13, 0, 1, 0, 1, 1, 8, '', 'album', 'Album', 'Album', 'album.php', 0, 0, 0),
(14, 0, 1, 0, 1, 1, 9, '', 'calendar', 'Calendar', 'Calendar', 'calendar.php', 0, 0, 0),
(15, 0, 1, 0, 1, 1, 10, '', 'downloads', 'Downloads', 'Downloads', 'dload.php', 0, 0, 0),
(16, 0, 1, 0, 1, 1, 11, '', 'profile', 'Profile', 'Profile', 'profile_main.php', 0, 2, 0),
(17, 0, 1, 0, 1, 1, 12, '', 'ajax_chat', 'Chat', 'Chat', 'ajax_chat.php', 0, 0, 0),
(18, 0, 1, 0, 1, 1, 13, '', 'links', 'Links', 'Links', 'links.php', 0, 0, 0),
(19, 0, 1, 0, 1, 1, 14, '', 'kb', 'Knowledge Base', 'Knowledge Base', 'kb.php', 0, 0, 0),
(20, 0, 1, 0, 1, 1, 15, '', 'contact_us', 'Contact Us', 'Contact Us', 'contact_us.php', 0, 0, 0),
(21, 0, 1, 0, 1, 1, 16, '', 'sudoku', 'Sudoku', 'Sudoku', 'sudoku.php', 0, 0, 0),
(22, 0, 1, 0, 2, 1, 1, '', 'news_cat', 'News Categories', 'News Categories', 'index.php?news=categories', 0, 0, 0),
(23, 0, 1, 0, 2, 1, 2, '', 'news_arc', 'News Archives', 'News Archives', 'index.php?news=archives', 0, 0, 0),
(24, 0, 1, 0, 2, 1, 3, '', 'digests', 'Digests', 'Digests', 'digests.php', 0, 2, 0),
(25, 0, 1, 0, 3, 1, 1, '', 'credits', 'Credits', 'Credits', 'credits.php', 0, 0, 0),
(26, 0, 1, 0, 3, 1, 2, '', 'viewonline', 'Who Is Online', 'Who Is Online', 'viewonline.php', 0, 0, 0),
(27, 0, 1, 0, 3, 1, 3, '', 'statistics', 'Statistics', 'Statistics', 'statistics.php', 0, 0, 0),
(28, 0, 1, 0, 3, 1, 4, '', 'site_hist', 'Site History', 'Site History', 'site_hist.php', 0, 0, 0),
(29, 0, 1, 0, 4, 1, 1, '', 'memberlist', 'Memberlist', 'Memberlist', 'memberlist.php', 0, 0, 0),
(30, 0, 1, 0, 4, 1, 2, '', 'usergroups', 'Usergroups', 'Usergroups', 'groupcp.php', 0, 0, 0),
(31, 0, 1, 0, 4, 1, 3, '', 'staff', 'Staff', 'Staff', 'memberlist.php?mode=staff', 0, 0, 0),
(38, 0, 2, 3, 0, 1, 6, './images/menu/newspaper.png', 'news_links', 'News', 'News', '', 0, 0, 0),
(37, 0, 2, 2, 0, 1, 5, './images/menu/application_view_tile.png', 'tools_links', 'Main Links', 'Main Links', '', 0, 0, 0),
(34, 2, 0, 0, 0, 0, 0, NULL, 'quick_links', 'Menu Personalizado', 'Menu Personalizado', NULL, 0, 0, 0),
(35, 0, 2, 1, 0, 1, 1, './images/menu/group.png', '', 'Del Club', 'Información del Club', '', 0, 0, 0),
(36, 0, 2, 0, 1, 1, 1, '', '', 'Presentacion', 'Historia del Club', 'index.php?page=3', 0, 0, 0),
(39, 0, 2, 4, 0, 1, 7, './images/menu/information.png', 'info_links', 'Info', 'Info', '', 0, 0, 0),
(51, 0, 2, 0, 3, 1, 1, '', 'news_cat', 'News Categories', 'News Categories', 'index.php?news=categories', 0, 0, 0),
(41, 0, 2, 0, 2, 1, 1, '', 'ACP', 'ACP', 'ACP', 'adm/index.php', 0, 4, 0),
(42, 0, 2, 0, 2, 1, 2, '', 'cms', 'CMS', 'CMS', 'cms.php', 0, 4, 0),
(43, 0, 2, 0, 2, 1, 3, '', 'home', 'Home', 'Home Page', 'index.php', 0, 0, 0),
(44, 0, 2, 0, 2, 1, 4, '', 'forum', 'Forum', 'Forum', 'forum.php', 0, 0, 0),
(45, 0, 2, 0, 2, 1, 7, '', 'album', 'Album', 'Album', 'album.php', 0, 0, 0),
(46, 0, 2, 0, 2, 1, 8, '', 'calendar', 'Calendar', 'Calendar', 'calendar.php', 0, 0, 0),
(47, 0, 2, 0, 2, 1, 9, '', 'downloads', 'Downloads', 'Downloads', 'dload.php', 0, 0, 0),
(48, 0, 2, 0, 2, 0, 10, '', 'links', 'Links', 'Links', 'links.php', 0, 0, 0),
(49, 0, 2, 0, 2, 1, 11, '', 'sudoku', 'Sudoku', 'Sudoku', 'sudoku.php', 0, 0, 0),
(50, 0, 2, 0, 4, 1, 3, '', 'memberlist', 'Memberlist', 'Memberlist', 'memberlist.php', 0, 2, 0),
(52, 0, 2, 0, 3, 1, 2, '', 'news_arc', 'News Archives', 'News Archives', 'index.php?news=archives', 0, 0, 0),
(53, 0, 2, 0, 3, 1, 3, '', 'digests', 'Digests', 'Digests', 'digests.php', 0, 0, 0),
(54, 0, 2, 0, 4, 1, 5, '', 'viewonline', 'Who Is Online', 'Who Is Online', 'viewonline.php', 0, 0, 0),
(55, 0, 2, 0, 4, 1, 6, '', 'site_hist', 'Site History', 'Site History', 'site_hist.php', 0, 0, 0),
(56, 0, 2, 0, 1, 1, 2, '', '', 'Como pertenecer?', 'Como Puedo Pertenecer?', 'index.php?page=4', 0, 0, 0),
(57, 0, 2, 0, 1, 1, 3, '', '', 'Reglamento', 'Reglamento del Club', 'index.php?page=5', 0, 0, 0),
(58, 0, 2, 0, 4, 1, 1, '', 'rules', 'Rules', 'Rules', 'rules.php', 0, 0, 0),
(59, 0, 2, 0, 4, 1, 2, '', 'faq', 'FAQ', 'FAQ', 'faq.php', 0, 0, 0),
(60, 0, 2, 5, 0, 1, 4, './images/menu/asterisk_orange.png', '', 'Patrocinadores', 'Patrocinadores', '', 0, 0, 0),
(61, 0, 2, 0, 1, 1, 4, '', '', 'Sistema de Puntos', 'Sistema de Puntos', 'index.php?page=6', 0, 0, 0),
(62, 0, 2, 0, 5, 1, 1, '', '', 'Bike Wash', 'Bike Wash', 'index.php?page=7', 0, 0, 0),
(63, 0, 2, 0, 5, 1, 2, '', '', 'Cafezinho', 'Cafezinho', 'index.php?page=8', 0, 0, 0),
(64, 0, 2, 0, 5, 1, 3, '', '', 'K-Motos', 'K-Motos', 'index.php?page=9', 0, 0, 0),
(65, 0, 2, 0, 5, 1, 4, '', '', 'Diego Servicios EVG', 'Diego Servicios', 'index.php?page=10', 0, 0, 0),
(67, 0, 2, 0, 4, 1, 4, '', 'usergroups', 'Usergroups', 'Usergroups', 'groupcp.php', 0, 4, 0),
(68, 0, 2, 6, 0, 1, 8, './images/menu/feed.png', '', 'Sindicacion RSS', 'Sindicacion RSS', '', 0, 0, 0),
(69, 0, 2, 0, 6, 1, 1, '', '', '¿Que es esto?', '', 'javascript:rss_news_help()', 0, 0, 0),
(70, 0, 2, 0, 5, 1, 5, '', '', 'ACCE', 'ACCE :: Accesorios para motos', 'index.php?page=11', 0, 0, 0),
(71, 0, 2, 0, 1, 1, 5, '', '', 'Productos', 'Productos Oficiales', 'index.php?page=12', 0, 0, 0),
(72, 0, 2, 7, 0, 1, 2, './images/menu/world.png', '', 'Mapas', 'Mapas de Ubicacion', '', 0, 0, 0),
(73, 0, 2, 0, 7, 1, 1, './images/menu/home.png', '', 'Estacion Suramericana', 'Estacion Suramericana', 'index.php?page=13', 0, 0, 0),
(74, 0, 2, 0, 7, 1, 2, './images/menu/home.png', '', 'Cafezinho (Planeacion)', 'Cafezinho (Planeacion)', 'index.php?page=14', 0, 0, 0),
(76, 0, 2, 0, 7, 1, 7, '', '', 'Texaco (San Diego)', 'Texaco (San Diego)', 'index.php?page=15', 0, 0, 0),
(77, 0, 2, 0, 7, 1, 6, '', '', 'Mall Mediterraneo', 'Mall Mediterraneo', 'index.php?page=16', 0, 0, 0),
(78, 0, 2, 0, 7, 1, 5, '', '', 'ESSO (Medellin-Bogota)', 'ESSO (Medellin-Bogota)', 'index.php?page=17', 0, 0, 0),
(79, 0, 2, 0, 7, 1, 4, '', '', 'Estacion Niquia', 'Estacion Niquia', 'index.php?page=18', 0, 0, 0),
(80, 0, 2, 0, 7, 1, 8, '', '', 'Estacion Ayura', 'Estacion Ayura', 'index.php?page=19', 0, 0, 0),
(83, 0, 2, 8, 0, 1, 2, './images/menu/route.png', '', 'Rutas', 'Mapas de Rutas', '', 0, 0, 0);