can we somehow edit/modify the system fields createdDate and updatedDate without editing the MySQL database?

-aev-

here is another method Dave showed me some time ago. I use this on all sites we create, works very good and is easy to adapt.

Remove your existing code in RED and replace with new code in BLUE in the list (load records) code. For the "customMenuUlAttr" and "customMenuLiAttr" I included more code than you need for your case just to some some examples. You need the one marked in BLUE.

  // load records
  list($pagesRecords, $pagesMetaData) = getCategories(array(  
    'tableName'   => 'pages',
    'defaultCategory' => '', // Enter 'first', a category number, or leave blank '' for none
    'rootCategoryNum' => '0', // Only categories _below_ this one will be shown (defaults to 0 for all)
    'categoryFormat' => 'showall', // showall, onelevel, twolevel, breadcrumb
    'ulAttributes' => " class='dropdown' ", // add html attributes to <ul> tags
    'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
    'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
    'ignoreHidden' => true, // don't hide records with hidden flag set
    'useSeoUrls' => true,
  ));

  // customMenuUlAttr
  function customMenuUlAttr($category) {
    $id = "id{$category['num']}";
    $class = "depth{$category['depth']}";
    return "class='$class'";
  }


  // customMenuLiAttr
  function customMenuLiAttr($category) {
    $id = "id{$category['num']}";
    $class = "clickable depth{$category['depth']}";
    if ($category['depth'] < 1) { $class .= " isTop"; }
    if ($category['depth'] > 0) { $class .= " isChild"; }
    if ($category['_isSelectedBranch']) { $class .= " isSelectedBranch"; }
    if ($category['_isSelected']) { $class .= " isSelected"; }
    if ($category['_isChildSelected']) { $class .= " childSelected"; }
    if ($category['_hasChild']) { $class .= " hasChild"; }
    return "class='$id $class'";
  }

Now you can simply add if statements for any of these fields to add classes:

_isSelected
_isAncestorSelected
_isDescendantSelected
_isSelectedBranch
_isBreadcrumb
_hasParent
_hasChild
_isFirstChild
_isLastChild
_hasSiblings
_isSiblingSelected
_isParentSelected
_isChildSelected

-aev-

I added your changes and it works as expected.

Thanks!

-aev-

yes that is what I'm looking to do, but I want to trigger the infowindow from an external link. Like this:

http://www.geocodezip.com/v3_MW_example_linktomap.html

I just need some guidelines how to transfer this example to the pages provided with the geocoder plugin.

-aev-

we just bought the Gecoder addon and so far it is working great for gecoding and getting a map with multiple tags up and running, but we would like to add a feature not provided by the included example page.

We want to make the addresses we output to our page from a Multi Record CMSB section have a link or onclick event to open the corresponding "infowindow" on the Google map. Has anyone done this? Code or tips are greatly appreciated :)

-aev-

I saw it and have implemented the fix. I just wanted to say that I think this should be addressed in CMS Builder, I don't like that I have to remember to implement this fix the next time we are using the Prev/Next feature.

-aev-

I just ran into this issue:

http://www.interactivetools.com/forum/forum-posts.php?postNum=2231087

It was not mentioned in the post, so I hope you file this as a bug and address it in a future update.

-aev-

But thanks for your code, it is an interesting starting point, but I hope Dave and his team will implement this into CMSB.

-aev-

Do you build sites for clients? If yes can you briefly describe the steps they have to do use the solution you linked to.

Thanks!

-aev-

we are also very interested in a feature like this. We have many clients uploading PDFs of brochures and manuals, and it would be great to be able to present a thumbnail/preview from these uploads.

Did some googling and it seems like ImageMagick/Ghostscript can do this, I'm unsure if GD is capable.

Maybe Interactivetools can extend CMSB or create a plugin to do this?

-aev-

the prices are usually updated once a year. The CSV addons could be a solution, I'll take a look. Thanks!

-aev-

we need to update 500 records with new numbers (prices), does anyone have great tip for speeding up this task?

It would be great to edit the records directly in the CMSB admin/list-view with a ajaxified-apply button for each record. Or a save button for a big editable admin page, but I guess that would be a bit complicated. Can IT make any of these features through consulting?

Another approach that could work would be a variant of the "Save & Copy" plugin called "Save & Edit next". Can that be done?

-aev-

Can we make the breadcrumb clickable?

Home : Products : Product-1

For the breadcrumb above we would like to have three individual links; "Home", "Products" and "Product-1".  The last one "Product-1" may be redundant as the user would most likely be on that page :)

-aev-

is it possible to change the breadcrumbs separator from ":" to another character?

-aev-

I'm already using the "skip inside foreach" method, but sometimes depending on the task, it would be easier to do it with a where filter.

Thanks for explaining my options.

-aev-

I get an error when trying to use the 'where' option for a Category section. How can I filter a Category section?

-aev-

I guess this could solve your problem:

http://forrst.com/posts/Allowing_Flash_Uploads_Through_Apache_Authentica-CT3

-aev-

-aev-

I have a new problem similar to the one above.

On a another site I'm working on we have 4 category sections, but we only display one at a time. I load the pages with this url:

http://www.example.com/index.php?nav=2

And pass the nav value like this:

list($categoryRecords, $selectedCategory) = getCategories(array( 
  'tableName' => mysql_escapef(@$getNav), 
  'defaultCategory' => 'first', // Enter 'first', a category number, or leave blank '' for none
  'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
  'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
  'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
  'selectedCategoryNum' => mysql_escapef(@$getRecord), 
));


This work fine, the problem is that since this page doesn't have the url variable like id=34 I use to pass to $getRecord, this getCategories call treats my nav=2 as the record number. We don't want this, we would like the category to load with the 'first' cat selected.

To sum this up; how can we load a category with the first category selected, not cat. num=1 but categoryRecords[0] (this can be cat. num=3).

-aev-

thanks! 'selectedCategoryNum' => '0', was the missing piece I needed for getting this to work!

Here is the code I ended up using:

if ($getSection == "nav") {

  // Menu 1 (selected)
  list($categoryRecords, $selectedCategory) = getCategories(array( 
    'tableName' => 'nav', 
    'defaultCategory' => 'first', // Enter 'first', a category number, or leave blank '' for none
    'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
    'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
    'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
    'selectedCategoryNum' => mysql_escapef(@$getRecord), 
  ));

  // Menu 2
  list($categoryRecords2) = getCategories(array( 
    'tableName' => 'nav2', 
    'defaultCategory' => '', // Enter 'first', a category number, or leave blank '' for none
    'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
    'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
    'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
    'selectedCategoryNum' => '0'
  ));

} elseif  ($getSection == "nav2") {

  // Menu 1
  list($categoryRecords) = getCategories(array( 
    'tableName' => 'nav',
    'defaultCategory' => '', // Enter 'first', a category number, or leave blank '' for none
    'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
    'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
    'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
    'selectedCategoryNum' => '0' 
  ));

  // Menu 2 (selected)
  list($categoryRecords2, $selectedCategory ) = getCategories(array( 
    'tableName' => 'nav2', 
    'defaultCategory' => 'first', // Enter 'first', a category number, or leave blank '' for none
    'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
    'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
    'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
    'selectedCategoryNum' => mysql_escapef(@$getRecord), 
  ));

}


-aev-

when a $categoryRecords record is loaded I also get a "[_isSelected] => 1" on the record with the same record-num in $categoryRecords2 even if I load $categoryRecords2 with "categoryFormat => onelevel" and no "selectedCategoryNum" set.

As you suggest I could workaround this by changing my code for displaying $categoryRecords2, but I would rather know if I can adjust getCategories and keep the same code for displaying my categories.

Is there any documentation explaining all the details for using getCategories?

-aev-

I'm trying to use two category sections on the same page, making the active one display as "onelevel" and the other to only list it's top-level.

Here is my code so far:

if ($getSection == "nav") {

  // nav1
  list($categoryRecords, $selectedCategory) = getCategories(array( 
  'tableName' => 'nav', 
  'defaultCategory' => 'first', // Enter 'first', a category number, or leave blank '' for none
  'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
  'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
  'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
  'selectedCategoryNum' => mysql_escapef(@$getRecord), 
  ));

  // nav2
  list($categoryRecords2) = getCategories(array( 
  'tableName' => 'nav2', 
  'defaultCategory' => '', // Enter 'first', a category number, or leave blank '' for none
  'categoryFormat' => 'onelevel', // showall, onelevel, twolevel 
  'ulAttributesCallback' => 'customMenuUlAttr', // ADVANCED: custom function to return ul attributes, eg: myUlAttr($category);
  'liAttributesCallback' => 'customMenuLiAttr', // ADVANCED: custom function to return li attributes, eg: myLiAttr($category);
  ));

} else {

  ..the same as above but swap 'nav' and 'nav2'

}

The problem is that the second category menu get's selected in the same way as the primary, showing like a selected 'onelevel' menu. Any suggestions?

-aev-

great suggestion, we would also appreciate to know what have and can be done through Interactivetools' consulting.

-aev-

on this page spambotEmailProtector is not putting the mailto inside a Javascript 'window.location' even if the "jsLocation" is set to true. The result is non-working email addresses when clicking on them, at least on my Mac using Outlook.

http://mrb.no/?s=nav&r=Om-oss-Hvem-er-vi-10

The mailto's are created with this code:

<a href="mailto:<?php echo $record['mail'] ?>"><?php echo $record['mail'] ?></a>

If I create a mailto using the wysiwyg editor on the same site the 'window.location' is used and everything works fine.

Anyone seen this before? Any suggestions?

-aev-

totally agree, our experience is the same.

-aev-