Title for ELLNav H/V menu

[Ken]

Hi, 
I would like to know if ELLNav H/V allows to get a title at top of vertical menu? 
This title would be parent level menu_text!

I've found a topic speaking about this but with no answer.
http://forum.cmsmadesimple.org/index.ph ... ml#msg7404
Solution would be a tag with code below. Could this be validated by CMSMS guru 

global $gCms;
global $db;

$vars = $gCms->variables;

$query = "SELECT content_name FROM ".cms_db_prefix()."content WHERE content_id = (SELECT parent_id FROM ".cms_db_prefix()."content WHERE content_id = '".$vars['content_id']."');";

$dbresult = $db->Execute($query);
if ($dbresult && $dbresult->RowCount() > 0) {
  $row = $dbresult->FetchRow();
  echo $row['content_name'];
}



Thanks for help

[Ted]

Well, it would need a slight modification.  Put this code into a user-defined tag.  Call it parent_title.

Code: Select all

global $gCms;
$db =& $db->GetDb();

$vars =& $gCms->variables;

$query = "SELECT content_name FROM ".cms_db_prefix()."content WHERE content_id = (SELECT parent_id FROM ".cms_db_prefix()."content WHERE content_id = '".$vars['content_id']."');";

$dbresult = $db->Execute($query);
if ($dbresult && $dbresult->RowCount() > 0) {
  $row = $dbresult->FetchRow();
  echo $row['content_name'];
}

Then put this tag ({parent_title}) pretty much anywhere, either content/template or menu manager template.

[Ken]

Hi Ted ... thank you for your very quick answer.

When I tried code you posted, I got :
Fatal error: Call to a member function on a non-object in c:\program files\easyphp1-8\www\lib\content.functions.php(653) : eval()'d code on line 2
(I'm still working locally with easyPHP 1.8.0.1 and I'm testing release 0.13-beta4)

The code found on the forum gives no error message but doesn't work properly as ...
I'm working with 3 levels

- first level with H menu
- second and third with V menu.

I would like to get the menu_text (or title) of [glow=red,2,300]LEVEL 1[/glow] at the top of V menu.
Code found on the forum doesn't do that and yours gives an error I don't understand.

Last question. What's the best way to customize this menu title with CSS?

Thx again

[Ted]

Sorry, there was a typo in line 2.

Code: Select all

global $gCms;
$db =& $gCms->GetDb();

$vars =& $gCms->variables;

$query = "SELECT content_name FROM ".cms_db_prefix()."content WHERE content_id = (SELECT parent_id FROM ".cms_db_prefix()."content WHERE content_id = '".$vars['content_id']."');";

$dbresult = $db->Execute($query);
if ($dbresult && $dbresult->RowCount() > 0) {
  $row = $dbresult->FetchRow();
  echo $row['content_name'];
}

You'll want to wrap the output of this plugin in a div or span or something that you can give an id to.  Then you can just style it with css normally.

[Ken]

Hi Ted ... Thank you

No error message now  ... but (sorry about that) code doesn't work properly as the idea is :

• to get the menu_text (or title) from H menu (level 1) ...
• ... above V menu (2nd and 3rd level) ...
• ... when item at V menu (Level 1) is selected.

Current code is giving parent_title. Then Title does appear only if we click on an item of 2nd level and not at the same time as V menu appears.





[attachment deleted by admin]

[mikemee]

This was a GREAT thread.

Trying to give a bit back, I've added it as a FAQ entry at http://wiki.cmsmadesimple.org/index.php ... nu_Heading.

thanks again!

[Ken]

Hi mikemee
Sure it is but not working properly yet.
It will be much more sexy when item from first level appears above V menu when we click on this item.
You see what I mean? Sorry for my English.
I hope Ted will have a few seconds to sort it out as I do know nothing in php!

[mikemee]

I think I understand the problem and have a possible solution.

The problem is that you're still at the 1st level when you've clicked on the 1st menu, so there is no parent_title to display yet. But after clicking on the 2nd level menu, now parent_title becomes the first level title and displays as expected.  To fix it, we need to detect the lack of result and use the current level.

In short, the following code will work as you expect:

Code: Select all

global $gCms;
$db =& $gCms->GetDb();

$vars =& $gCms->variables;

$query = "SELECT content_name FROM ".cms_db_prefix()."content WHERE content_id = (SELECT parent_id FROM ".cms_db_prefix()."content WHERE content_id = '".$vars['content_id']."');";

$dbresult = $db->Execute($query);
if ($dbresult && $dbresult->RowCount() > 0) {
  $row = $dbresult->FetchRow();
  echo $row['content_name'];
} else {
  echo $vars['pageinfo']->content_menutext;
}

Note the last three lines have changed by adding an else.  (It took 10 mins of digging around the source code to find the menutext to return - my first exploration of cmsms code - but I learnt a lot  ).

Hope this fixes your problem!

[Ken]

Yes ... you did it !
That's cool ! Just one little thing. It should be better if parent_title doesn't appear if there is nothing in the submenu   

Well done .. many thx for your help !