Oops! Yikes ! Help! - Erased Menu items!

Yikes!

Today i was fiddling around with the "Menu Builder" in my Admin Control panel .. and .. well i removed the MEMBERS menu option..

I know, this is kinda embarrassing but .. is there a way to restore the menus and all sub-options to their original state when 1st installed by my provider WITHOUT having to re-install dolphin ?

Thank you for the replies.. I'm learning .. steep learning curve from building "regular" websites.. :/

BeN

Some one here might be able to extract the needed fields from a running copy and post a SQL query you can run to put those back in, but we need to know what version of dolphin you are using.

I'm running Dolphin7 RC2 ..

Thats the only way to restore menu items ? OUCH! .. What happens if i remove menu items from the "navigation" menu for users ? The same thing applies ?

Instead of removing menu options .. can we hide them from the users when they're not in the appropriate group ?

Thanks for the help.

BeN

dont feel bad i did the same thing in rc1 and i have been using dolphin for a long time.  let me see if i can build an sql statement for you.

ok give this a try.  i just deleted the members link like you did and created it again with this statement.

well really i just draged it down to all items and it deleted itself for some reason.

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'users', '_adm_mmi_users', '{siteAdminUrl}profiles.php', '', 'mm_users.png', 'mm_users_l.png', '', 2);

SET @iParentId = LAST_INSERT_ID();

and that should do it for you. 

open phpmyadmin 

click on the database for dolphin

click on sys_menu_admin

click on sql and paste in the info above and hit go.

Hello!

Thank you for the help .. worked like a charm..

Now i assume that if i removed some "website menu options" i'd have to do the same ?

How can i HIDE a menu option ? I know that if users don't have the correct priviledges they cannot access a function.. but is there a way to hide them if they dont have access to them ?

BeN!

It seems yesterday i also erased the SETTINGS option.. GRRR

Can you help me one other time please ?

THank you

Do better than help you again, teach you how it's done.

All you have to do is just open the zip copy of Dolphin 7 RC2 that we know you still have.  Go to the install directory and grab the install sql file, open it up and then browse down.  It'll have Create Table and then Insert Into.  Just find the Table effected and then the Insert Into section you need.  Copy and paste as an SQL query into your phpMyAdmin and your done.

Works every time.

YAWWWW

I was about to write that in my previous message.. "Teach someone that's hungry how to fish instead of feeding him"

Thank you for the info.. I was about to ask how you guyz figured that out..

THANKS!

Ok, the only trouble i'm having is this ..

I opened up the database with phpmyadmin , then injected :

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
(0, 'settings', '_adm_mmi_settings', '', '', 'mm_settings.png', 'mm_settings_l.png', '', 6);
SET @iParentId = LAST_INSERT_ID();

Which creates the TOP LEVEL ITEM (so far so good!)

then i tried injecting the following :

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
(@iParentId, 'admin_password', '_adm_mmi_admin_password', '{siteAdminUrl}settings.php?cat=ap', 'Change a password for access to administration panel here', 'mmi_admin_password.gif', '', '', 1),
(@iParentId, 'basic_settings', '_adm_mmi_basic_settings', '{siteAdminUrl}basic_settings.php', 'For managing site system settings', 'mmi_basic_settings.gif', '', '', 2),
(@iParentId, 'advanced_settings', '_adm_mmi_advanced_settings', '{siteAdminUrl}advanced_settings.php', 'More enhanced settings for your site features', 'mmi_advanced_settings.gif', '', '', 3),
(@iParentId, 'languages_settings', '_adm_mmi_languages_settings', '{siteAdminUrl}lang_file.php', 'For languages management your website is using and making changes in your website content', 'mmi_languages_settings.gif', '', '', 4),
(@iParentId, 'membership_levels', '_adm_mmi_membership_levels', '{siteAdminUrl}memb_levels.php', 'For setting up different membership levels, different actions for each membership level and action limits', 'mmi_membership_levels.gif', '', '', 5),
(@iParentId, 'email_templates', '_adm_mmi_email_templates', '{siteAdminUrl}email_templates.php', 'For setting up email texts which are sent from your website to members automatically', 'mmi_email_templates.gif', '', '', 6),
(@iParentId, 'css_styles', '_adm-mmi_css_styles', '{siteAdminUrl}css_file.php', 'For CSS files management: to make changes in your current template', 'mmi_css_styles.gif', '', '', 7),
(@iParentId, 'tags_settings', '_adm_mmi_tags_settings', '{siteAdminUrl}settings.php?cat=25', 'For tags settings, which will work for search and browse options', 'mmi_tags_settings.gif', '', '', 8),
(@iParentId, 'database_pruning', '_adm_mmi_database_pruning', '{siteAdminUrl}settings.php?cat=11', 'For Database management: clearing of old, unnecessary information', 'mmi_database_prunning.gif', '', '', 9),
(@iParentId, 'meta_tags', '_adm_mmi_meta_tags', '{siteAdminUrl}settings.php?cat=19', 'Setting up Meta Tags to facilitate search engine indexing for your website', 'mmi_meta_tags.gif', '', '', 10),
(@iParentId, 'moderation_settings', '_adm_mmi_moderation_settings', '{siteAdminUrl}settings.php?cat=6', 'To enable/disable pre-moderation of members profiles, members photos, etc.', 'mmi_moderation_settings.gif', '', '', 11),
(@iParentId, 'privacy_settings', '_adm_mmi_privacy_settings', '{siteAdminUrl}settings.php?cat=9', 'For configuring privacy settings', 'mmi_privacy_settings.gif', '', '', 12),
(@iParentId, 'permalinks', '_adm_mmi_permalinks', '{siteAdminUrl}settings.php?cat=26', 'Friendly permalinks activation', 'mmi_permalinks.gif', '', '', 13),
(@iParentId, 'predefined_values', '_adm_mmi_predefined_values', '{siteAdminUrl}preValues.php', '', 'mmi_predefined_values.gif', '', '', 14),
(@iParentId, 'categories_settings', '_adm_mmi_categories_settings', '{siteAdminUrl}categories.php', 'Categories settings', 'mmi_categories_settings.gif', '', '', 15),
(@iParentId, 'watermark', '_adm_mmi_watermark', '{siteAdminUrl}settings.php?cat=16', 'Setting up watermark for media content', 'mmi_watermark.png', '', '', 16);

This code should insert the 2nd level items no ? It creates them as TOP LEVEL .. and when i try to move them manually "under" settings.. the selection doesnt stick.

I'm getting there .. with your help .. slowly and surely.. :)

Thank

BenGalf:

Did you ever get this sorted out?

I have the Settings button back on my screen, but it just goes to an empty page.

Tried your second set of SQL and I'm running into the same problem with the changes not being able to get the entries under the Settings button.

I just figured it out.

I had to set the parent_id of each of the new items because they were all zero after those inserts. I guess setting @PARENTID doesn't work in phpMyAdmin.

My Settings entry from the first SQL had an ID of 55, so I ran this to fix it all up:

update`sys_menu_admin` set parent_id = 55 where id > 55