Navigation Manager

[kapii]

For some unknow reason, in 4.2 with the Navigation Manager if you delete a item, it leaves behind the record in the navigation table and in the phrase table.

I have found a way to delete the record in the navigation table by adding this code via a plugin to the navigation_admin_dodelete hook.

PHP Code:

if ($_REQUEST['do'] == 'dodelete')
{
$vbulletin->input->clean_array_gpc('r', array(
    'navid'    => TYPE_UINT,
    'tabid'    => TYPE_UINT
));

$db->query_write("
    DELETE FROM " . TABLE_PREFIX . "navigation
    WHERE navid = " . $navelement['navid'] . "
");
} 


But I have not been able to come up with a way to delete the phrase record, if anybody can help me out it would be greatly appreciated.

Thanks

[Lynne]

Did you put in a bug report about this?

[kapii]

Hi Lynne their is already something in JIRA http://tracker.vbulletin.com/browse/VBIV-15177

But that don't help me at the moment.

Thanks

[nhawk]

I'm the one that filed that report and just about fell out of my chair when I saw it marked "As designed" and "Resolved".

I would have to double check it, but the reason you can't delete the phrase is there isn't any id that links them to the navigation item. You need to know the full name of the phrase and delete it using that phrase.

The standard phrases for navigation items are...

FOR MENUS:	vb_navigation_menu_' . $name . '_text'
FOR TABS:	vb_navigation_tab_' . $name . '_text'
FOR LINKS:	vb_navigation_link_' . $name . '_text'

[Simon Lloyd]

I'm soooo glad i haven't moved to vb4 beta wonder if vb5 will still be in constant beta mode?

[kapii]

Originally Posted by nhawk

I'm the one that filed that report and just about fell out of my chair when I saw it marked "As designed" and "Resolved".

I would have to double check it, but the reason you can't delete the phrase is there isn't any id that links them to the navigation item. You need to know the full name of the phrase and delete it using that phrase.

The standard phrases for navigation items are...

FOR MENUS:	vb_navigation_menu_' . $name . '_text'
FOR TABS:	vb_navigation_tab_' . $name . '_text'
FOR LINKS:	vb_navigation_link_' . $name . '_text'

Right, but how would I add that to my delete code to remove the phrase when it removes the item from the navigation table, if it is even possible?

Thanks

[nhawk]

Originally Posted by kapii

Right, but how would I add that to my delete code to remove the phrase when it removes the item from the navigation table, if it is even possible?

Thanks

Get the name from the navigation table prior to deleting it. Then use the name (varname) to delete the phrase from the phrase table.

[kapii]

I tried something like that but I don't think I write it correctly, when I would delete a item via the navigation manager, it would delete the item in the db just fine but not the phrase, so I don't know how to code it to do that.

[Lynne]

Originally Posted by kapii

I tried something like that but I don't think I write it correctly, when I would delete a item via the navigation manager, it would delete the item in the db just fine but not the phrase, so I don't know how to code it to do that.

Post your code so we can try to see what was wrong.

[kapii]

Hi Lynne, actually I tried so many different things I deleted the whole thing and then just wrote the part to remove the item from the navigation table. I know that don't help you but I tried looking back on my text files and don't have what I wrote anymore.