Hi Jason
I spoke to Ray yesterday and he managed to sort it out, I had no problem following his steps to create the dynamic menu items for all the sections that will need new pages created, using the same file as he worked on.
I thought that I had it nailed however having built the site it needed a lot of changes due to the new dynamic nature of the navigation, so I created a new site scuptor site definition and built the new site in a different directory, so as to not destroy what I achieved yesterday.
Everything worked great but for some unknown reason my new pages are not showing up in the navigation,
I am pretty sure I am doing everything correctly but I have probably missed out a vital step somewhere along the line.
I have since closed my ticket, and feel bad about bothering him again, is there any chance you could check with him to see if I am doing this correctly?
My Steps were
1/ Open menu.php, edit the very top line to
<?php
if (0==1) {
?>
<?php require_once('../../Connections/PowerCMSConnection.php'); ?>
<?php
}
?>
2/Duplicate a Sub Menu Page and rename it to PAGENAME_template.php
3/Update the content area names to the Top Level name
4/Save the template page
5/back to menu.php select the link I wish to make dynamic in design view, duplicate it and rename it as the newly created template page,
6/Go to behaviours panel and add a recordset name it NameRS enter the SQL query, and click ok (when I test this it says no records? If I look on the one we did yesterday it shows a record set)
7/From the behaviours panel drag the ContentPageSetOrder within the link,
8/Delete the original text link and drag the ContentGroup from the behavoirs panel to replace the text link
9/Add Repeat region
above the link<?php do { ?>
below link <?php } while ($row_NameRS = mysql_fetch_assoc($NameRS)); ?>
10/File Save
11/Put
12/No to dependent files
I believe Ray did something that I did not pick up on at step 6 when he went into the phpMyAdmin, I am sure this is pretty much all that can be wrong.
I would like to post the full solution to help others that may be having the same problem but I would like to check I have it 100% right so as not to mislead people.