Virtuemart + Joomla selected menu item

Fix for wrong selected menu item in joomla menu.
Bug reason: virtuemart finds a first menu ItemId of type "Virtuemart" and make it selected.
Almost always it is not the really selected one. And always the wrong in subcategories.

Small fix, suitable for my my task. Not perfect, but can be used as a starting point for understanding.
Find a suitable menu item for current virtuemart category or its root item.

The function url() in file /administrator/components/com_virtuemart/classes/ps_session.php
has to be changed like this:

	<?php
	function url($text, $createAbsoluteURI=false, $encodeAmpersands=true, $ignoreSEF=false ) {
	// .....
	// Check if there is a menuitem for a category_id
	$ii_cat_id=intval($ii_arr['category_id']);
	if ( $ii_cat_id && $tmp_Itemid=='') {
	$db->query( "SELECT id FROM #__menu WHERE link='index.php?option=com_virtuemart' AND params like '%category_id=$ii_cat_id%' AND published=1");
	if( $db->next_record() )
	$tmp_Itemid = $db->f("id");
	else {
	$db->query( "SELECT id FROM #__menu WHERE link='index.php?option=com_virtuemart' AND params like CONCAT('%category_id=', vm_category_find_root($ii_cat_id),'%') AND published=1");
	if( $db->next_record() ) $tmp_Itemid = $db->f("id");
	}
	}
	//.............
	}
	?>

view raw ps_session.php hosted with ❤ by GitHub

I have added only the else branch in script above and mysql stored procedure for finding the root vitruemart category:

	CREATE FUNCTION vm_category_find_root(value INT) RETURNS INT
	NOT DETERMINISTIC
	READS SQL DATA
	BEGIN
	DECLARE _id INT;
	DECLARE _parent INT;
	SET _id = value;
	SET _parent = value;
	IF _id IS NULL THEN
	RETURN NULL;
	END IF;
	WHILE _parent <> 0 DO
	BEGIN
	SELECT category_parent_id, category_child_id
	INTO _parent, _id
	FROM jos_vm_category_xref
	WHERE category_child_id = _parent;
	END;
	END WHILE;
	RETURN _id;
	END

view raw sql.sql hosted with ❤ by GitHub