For now I’m just going to post my comments in, I’ll form this up later to explain what I did.
Tables
NavNodes (location of the quicklaunch)
AllDocs (location of the document needed for the DocID in NavNodes
Find the row with the entry of a botched quick launch item (one that was deleted, then added back later).
The way the permissions work is that if there is a URL specified in the NavNodes part, it breaks the permission and treats it like a node that everybody can see. However, if the DocID is set with the specific hex code (look below), and the URL is set to null, and ElementType is changed to 1(not entirely sure what this is for, maybe to specify if it’s custom….er something), then you can set it back up to how the quick launch works when you first make a site (based on the permissions of the site)
–select * from navnodes where siteid=’84EAD071-5977-4C59-AC79-71BD4988BE7D’ and webid=’AB489397-264F-4C9D-9791-59E44C0EDB66′ and eid=2016
select * from NavNodes where Name like ‘Team Site%’
select * from NavNodes where Name like ‘Web Services%’
–select * from alldocs where dirname like ‘%web_services/team_site%’ and leafname=’default.aspx’
–select * from NavNodes where Eidparent=1026
– 9CF75CF6-3204-4734-9336-00FF65F3E254
–select * from alldocs where id=’23A06CEE-87FE-4B2C-B9A3-0937ED66F6F5′
Edit: Who am I kidding, I’m not going to go back to this and clean it up. Let’s leave it as is!