[BETA] Admin Page Name Menu Override?

[dbltoe]

Kuroi,
That too was part of my concern. The mod I'm munging has many items to add to the configuration table as well.
That could possibly mess with the LAST_INSERT_ID() as we then need to make sure the group ID is not confused with the configuration ID.
Simpler to stick with the @t4

BTW I tested three browsers on the iPad2. None would scroll the code in either mobile or regular view.

[lat9]

Shouldn't the install SQL also take care of unregistering the previously-installed admin_pages entries as well?

# Clears out any pre-existing Links Manager configuration settings
SET @t4=0;
SELECT (@t4:=configuration_group_id) AS t4
FROM configuration_group
WHERE configuration_group_title= 'Links Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM admin_pages WHERE language_key = 'BOX_LINKS';
DELETE FROM admin_pages WHERE language_key='BOX_LINK_CATEGORIES';
DELETE FROM admin_pages WHERE language_key='BOX_LINKS_CONTACT';
DELETE FROM admin_pages WHERE language_key='BOX_CONFIGURATION_LINKS_MANAGER';

# Insert New Links Manager Configuration Group (will be indexed differently to any old one cleared out about)
INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '1', '1');
UPDATE configuration_group SET sort_order = LAST_INSERT_ID() WHERE configuration_group_id = LAST_INSERT_ID();

# Register the paghes for Admin Access Control
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order)
VALUES ('links','BOX_LINKS','FILENAME_LINKS','','extras','Y',101),
       ('linkCategories','BOX_LINK_CATEGORIES','FILENAME_LINK_CATEGORIES','','extras','Y',102),
       ('linksContact','BOX_LINKS_CONTACT','FILENAME_LINKS_CONTACT','','extras','Y',103),
       ('linksConfig','BOX_CONFIGURATION_LINKS_MANAGER','FILENAME_CONFIGURATION',CONCAT('gID=',LAST_INSERT_ID()),'configuration','Y',LAST_INSERT_ID());

[kuroi]

No and yes.

No, because admin_pages was only introduced in this version of Zen Cart, so wouldn't be any prior entries to clear out.

Yes, because it does no harm and may even help in a number of edge cases, e.g. somebody running the SQL twice, and possibly for users upgrading a cart with Admin Profiles installed (haven't looked at that in depth yet).

Yes, for future updates if the settings have changed.

So on balance I'd now use:

# Clears out any pre-existing Links Manager configuration settings
SELECT @links_mgr:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Links Manager';
DELETE FROM configuration WHERE configuration_group_id = @links_mgr;
DELETE FROM configuration_group WHERE configuration_group_id = @links_mgr;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM admin_pages WHERE language_key = 'BOX_LINKS';
DELETE FROM admin_pages WHERE language_key='BOX_LINK_CATEGORIES';
DELETE FROM admin_pages WHERE language_key='BOX_LINKS_CONTACT';
DELETE FROM admin_pages WHERE language_key='BOX_CONFIGURATION_LINKS_MANAGER';

# Insert New Links Manager Configuration Group (will be indexed differently to any old one cleared out about)
INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '1', '1');
SET @links_mgr = LAST_INSERT_ID();
UPDATE configuration_group SET sort_order = @links_mgr WHERE configuration_group_id = @links_mgr;

# Register the pages for Admin Access Control
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order)
VALUES ('links','BOX_LINKS','FILENAME_LINKS','','extras','Y',101),
       ('linkCategories','BOX_LINK_CATEGORIES','FILENAME_LINK_CATEGORIES','','extras','Y',102),
       ('linksContact','BOX_LINKS_CONTACT','FILENAME_LINKS_CONTACT','','extras','Y',103),
       ('linksConfig','BOX_CONFIGURATION_LINKS_MANAGER','FILENAME_CONFIGURATION',CONCAT('gID=',@links_mgr),'configuration','Y',@links_mgr);

INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', @links_mgr, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
.
.
.

[dbltoe]

Still playing with this, but the good news is safari for iOS5 now scrolls quotes and code left and right on the iPad2!

[Calljj]

don't suppose anyone has looked into the upgrade for 1.3.9h to 1.5 with admin profiles installed?? Caused me a few probs with blank admin login after upgrade, but after deleting the original profiles files mamanged to get in, but now having real difficulty trying to get all my installed mods back on the menus.

[ray-the-otter]

personally, id run through the uninstall of Admin Profiles, then upgrade to 1.5

Test site of course, see if it worked.