freebie: popout section aware nav.

[NicNac]

Woohoo!

[fourone]

That's great thanks NicNac, that has worked a treat!

[NicNac]

Great to hear fourone!

It feels good to give something back for a change

[gabrielcrowe]

thanks for the addition of the extra menus, but there is a more interesting issue at hand.

Dont you think that removing the complexity of a store navigation from the cart is a good idea?

Why would you want them to go faffing about in the store, when you need them to go and pay for something? I understand the need to upsell, but there are things inside actinic that can do that for you.

take a look at amazon, play and dabs to see what i mean. they remove the left hand nav, when paying for goods, it confuses people and makes the checkout more freindly.

[NicNac]

Dunno, I was just answering the question lol

[gabrielcrowe]

and a good answer it was!

[TraceyHand]

Just found a problem in the code.
If you have any deleted sections in the site then the current code builds them into the menu system.

it needs an additional condition ( AND [Status]='N' ) in the function SectionList to check the value of Status.

So the code

		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 ORDER BY [Catalogue Section Sequence] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0  ORDER BY [Catalogue Section Sequence] ASC";
		}

should be changed to

		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		}

Ok, I've had an old client come back to me with this problem and I've done the below but it hasn't fixed it
I've reinstalled the whole menu from scratch, to make sure I was using up to date code/latest version but no luck.

I've restarted (Actinic) and compacted several times.
Any ideas what else could be making these deleted sections appear in the menu still?
(How long is a piece of string? I know...but someone else may have had the same problem and managed to resolve it)

Editted to add: It works ok with sections hidden..just that it still shows deleted (red X) ones

[malbro]

Anyone who wants an alphabetic sort on the sections can use this code but change the last section of the line as below

		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 AND [Status]='N' ORDER BY [Section text] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [Status]='N' ORDER BY [Section text] ASC";
		}

I used this for a client recently as part of a multiple navigation system that included an alphabetical list of all the sections which as they were SPP gave an alphabetical list of products.

[John_C]

Error in menu

I have I think done everythink right.
Point 16 in your noob giude needs to be more well noob friendly!

Anyway thye menu displays but apart from the first link in the list the rest either do not work or take you back to the home page.

Any ideas.

Thanks

John
PS using version 9 and closed down and restarted actinic etc.

[NicNac]

I have I think done everythink right.
Point 16 in your noob giude needs to be more well noob friendly!

Anyway thye menu displays but apart from the first link in the list the rest either do not work or take you back to the home page.

Any ideas.

Thanks

John
PS using version 9 and closed down and restarted actinic etc.

I don't know if this is causing the problem John, but a bit more detail about point 16.

Go to your design tab and look over to the right hand side. There should be a section of the window called either 'Design Tree' or 'Content Tree'. If not, go to the Window menu on the top toolbar and select 'Restore Split View Layout'.

So, over to the right hand side of the screen, there should be the Design Tree or Content Tree. If it's showing content tree, go to the bottom of that section and click the other tab. Either way you should now be on the Design Tree.

Right click on the very top entry (should be something relating to your outer layout) and click 'Insert Layout'. A new window should appear where you'll be able to select your newly created layout selector. Once you've found it, click Insert and it should show right at the top of the list (but below the very top entry).

Don't know if you've already got that far or if it helps at all!

[malbro]

Anyway thye menu displays but apart from the first link in the list the rest either do not work or take you back to the home page.

Do you have a site where we can see the problem?

If the menu appears with all the sections in it then it is likely the code is correctly inserted, the php code scans the actinic database and generates the menu listing on the web page. I presume that you have not modified the code supplied by gabe in anyway.

[John_C]

Error in menu solved?

I have solved it but it was not related to any of the scripts.

In the page settings in the sections content tree if there is not a name/address under the page name field that section does not have a link under the script when it displays on the webpage.

I do not know if there is a quick way to fill this feild in for all the sections but now that seems the issue.

Anyway good addon

Thanks

John

[malbro]

I have solved it but it was not related to any of the scripts.

In the page settings in the sections content tree if there is not a name/address under the page name field that section does not have a link under the script when it displays on the webpage.

I do not know if there is a quick way to fill this feild in for all the sections but now that seems the issue.

Anyway good addon

Thanks

John

The code needs the Page Name (that is the name of the page on the web site, normally ends in .html) under Page Settings. The Name of the section (under general) and the section ID which is an internal actinic setting. If any of these are blank then the code cannot generate a valid link normally only the page name can be left blank and as far as I can ascertain if you leave the Page Name blank Actinic does not generate the web page so the code ought to do the same.

 if (!function_exists('SectionList')) {
function SectionList($connect,$sectid,$recursedepth,$rendermode,$thispatharr,$stylecounter,$respect) {

    $recursedepth=$recursedepth-1;
    $stylecounter=$stylecounter+1;
    if($respect==true) { 
		$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 ORDER BY [Catalogue Section Sequence] ASC";
    } else {
		$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 ORDER BY [Catalogue Section Sequence] ASC";
	 }
	 $result = odbc_exec($connect, $query);
    $numrows = useful_odbc_num_rows($result);

    if ($numrows!=0) {echo "\n\n<ul class=\"ul".$stylecounter."\">\n";}
        while(odbc_fetch_row($result)){
        
            $sPageName = odbc_result($result, 1);
            $Sectiontext = odbc_result($result, 2);
            $nSectionID = odbc_result($result, 3);
            // add this line  here to stop generating code for non existent pages 
            if ($sPageName!="") {
                $thisstyle="";
                $expandthis=false;
                foreach ($thispatharr as $value) {
                    if ($value==$nSectionID) {
                    $thisstyle="_selected";
                    $expandthis=true;
                    }
                }
                $linkitem="<a href=\"#link#\" class=\"link".$stylecounter.$thisstyle."\">";

            echo "\t<li class=\"li".$stylecounter.$thisstyle."\">";
            echo str_replace("#link#",$sPageName,$linkitem);
            echo trim($Sectiontext);
            echo "</a>";
                //recurse
                if ($rendermode == 1) { $expandthis=true; }
                if ($recursedepth>=1 and $expandthis==true){
                        SectionList($connect,$nSectionID,$recursedepth,$rendermode,$thispatharr,$stylecounter,$respect);
                    }
            echo "</li>\n";
          // and this one to close the condition.
          }
        }
    if ($numrows!=0) { echo "</ul>\n\n"; }
odbc_free_result($result);
}        
}

Just add the two lines shown into the function SectionList to stop it producing links to pages that will not exist.

[John_C]

error version 10

I have a new issue in version 10, but it may be a problem with older versions.

If I do a new section it does not show up and if I delete a section it still shows in the nav menu.

Any ideas?

[malbro]

I have a new issue in version 10, but it may be a problem with older versions.

If I do a new section it does not show up and if I delete a section it still shows in the nav menu.

Any ideas?

Hi John
Have you just upgraded to V10 or was it always in V10? The php code reads the database from the current Actinic site however the code is specific to the relevant version of Actinic. For example if it worked on V9 and you install V10 alongside V9 and import th site into the V10 version of Actinic whilst the old version is still on the machine then the code will read the database from the V9 site not the V10 one.

If this is the case then go through the PHP code in the V10 version and change all references to Catalog9 to be Catalog10.