Thanks for your inputs, I will discuss it with our senior programmer.

Regards,

You're missing a "`" on this line:

$updateQuery = "UPDATE `{$TABLE_PREFIX}accounts` SET $updateSet WHERE $updateWhere";

Cheers,

Can you please try using the HTML separator instead of the header bar and add the following HTML:

<div class="separator "><div><font color="red"><b>SHOW IN CURRENT NEWSLETTER OR ON WEB SITE</b></font></div></div>

And please let me know if that works for you.

Thanks,

<?php foreach ($records AS $record): ?>

Anyway, I'm glad you got it working.

Cheers,

Use array_groupBy() function on your faq_questions records array.
For example:

$faqsTopicsToRecords= array_groupBy($faq_quesitons, 'topics:label', true);

// to see how the new array looks like
showme($faqsTopicsToRecords);

Your foreach loop should now look something like this:

<?php foreach ($faqsTopicsToRecords as $topic => $records): ?>
  <h1><?php echo htmlencode($topic) ?></h1>

  <?php foreach ($records as $record): ?>
    <p>
      <?php echo $record['question'] ?><br>
      <?php echo $record['answer'] ?><br><br>
    </p>
  <?php endforeach ?>

<?php endforeach ?>

Hope this helps!

Cheers,

The 'listRow_trStyle' filter passes the table name of the section to $tableName variable.
You can use that to check if the current table is _sc_orders, if not, return the tr style without any changes.
For example:

function grey_hidden_records_listRow_trStyle($trStyle, $tableName, $record) {
  if ($tableName != '_sc_orders') { return $trStyle; } // change nothing if this is not the orders table
  if (!@$record['hidden']) { return $trStyle; } // skip if record either doesn't have a hidden field or the hidden field isn't checked
  return "color: #CCC;";
}

Cheers,

• CMS Menus: Added icons for "CMS Setup" and "Admin" menus

• Section Editors: Added "Menu Icon" field for adding menu icon

• Field Editor: Added "crop" feature for upload field's thumbnail images

Here's the complete changelog for v3.06:

*** August 25, 2016 - Version 3.06 (CMS Menu Icons and Thumbnail Cropping)

SERVER REQUIREMENTS:
- This software version requires: PHP 5.5+ and MySQL 5.0+
- Future versions will require: PHP 5.6+ and MySQL 5.5+
- NOTE: Some plugin may need to be updated when upgrading from v2.xx

NEW FEATURES
- CMS Menus: Added icons for "CMS Setup" and "Admin" menus
- Section Editors: Added "Menu Icon" field for adding menu icon
- Field Editor: Added "crop" feature for upload field's thumbnail images

MINOR CHANGES
- CMS Menus: "Backup & Restore" has been moved from "General Settings" to its own page
- CMS Menus: "Text Link" menus that redirects to an external page now display an "external-link" icon
- Section Editors: Moved "Hidden menu" option from "Advanced" tab to "General" tab
- Field Editor: Added <br> tag support for text field prefix and description
- Code Generator: Changed the RSS feed's isPermalink attribute value to false by default so that it will pass the w3c validation
- Code Generator: Included hidden menus in the "Select Section" list options
- Programmers: Updated getPage() function to send HTTP/1.1 header, added support for HTTP-chunked data
- Programmers: Added new plugin filters: sendMessage_options

BUG FIXES
- CMS Menus: Fixed display issue where menus sometimes didn't appear correctly
- CMS Menus: Fixed issue where background color turns black when printing a CMS Menu page in Chrome browser
- CMS Menus: Fixed issue where thumbnails on the section list page sometimes disappear when adding a new thumbnail setting
- Field Editor: Fixed issue where save & copying a field doesn't automatically update the fieldname when changing the label
- Upload Field Editor: Fixed issue where recreating new thumbnail, the URL and file paths of that new thumbnail don't get set in its upload record
- Misc Code and other minor improvements

To see the full list of changes, please visit the CMS Builder changelog: 
http://www.interactivetools.com/tour/changelog.php

CMS Builder users can upgrade by donation at this page: 
http://www.interactivetools.com/upgrade/

Please feel free to create a new forum post for your feedback and questions.

Thanks!

It's a bit tricky to sort a combined multi-dimensional array.
So I'd like to suggest to use mysql_select_query() function, for example:

$urlsAndLinks = mysql_select_query("SELECT CONCAT('./', permalink) AS URL, CONCAT(name,' (Page)') AS LINK from {$GLOBALS['TABLE_PREFIX']}pages
                                    UNION
                                    SELECT CONCAT('?rec=', num) AS URL, CONCAT(name,' (Record)') AS LINK from {$GLOBALS['TABLE_PREFIX']}records
                                    ORDER BY LINK");

Let me know how it goes.

Thanks,

    // mark all other matching permalinks for this record as old
    $where = mysql_escapef("`tableName` = ? AND `recordNum` = ? AND permalink != ?", $tableName, $recordNum, $permalinkText);
    mysql_update('_permalinks', null, $where, array('old' => '1'));

I didn't mention the exact lines/code as I'm not sure what version you're using.

Cheers,

You can do that by changing the code that updates the old permalink to mark it as "old" to have it delete the old record instead.

You can find that code in the permalink_add() function.

I'd comment out the code that updates the record instead of deleting it so I can restore it back easily when I need to.

What were the problems when you tried to do it on a normal page?

Regards,

Yes, that's doable.

But why would you want to delete the old entries?

We use the old permalinks to redirect the users to the current ones.
This is useful if a user bookmarked an old URL, or search engines haven't indexed the new URL yet and referred the user to the old one.

Cheers,

So you were referring to the menu suffix icon and not the prefix.

No, I don't think we need a field in the section editor for the suffix icon because I think it will not be used that much.
We can use the plugin filter to add/change the suffix icon for now unless many people asked for a field to set it.

And right, you can hide it using CSS or update it to change to other icon using the plugin filter.

Cheers,

Is it also envisaged to add a field for menu-prefix-icon?

Are you referring to the plugin filter where you can set the menu-prefix-icon?

If yes, setting a menu icon in the section editor does the same thing so we don't need another field for that.

Regards,

Functions that send or modify the headers, ie: setcookie() which is called by setPrefixedCookie(), should be executed first before displaying any output.

So I'd check if the setPrefixedCookie() code is called before anything that displays an output.

PS: Check out this StackOverflow thread that discusses the same error for more details: http://stackoverflow.com/a/8028987

Hope this helps!

Thanks,

You can use the end() function to get the last array element then add an if statement inside your foreach loop that checks if the current array's num is equal to the last array element's num. If yes, then add the class.

Cheers,

Tim:

You have a link to font awesome for additional icons - any instructions on how to add them?

You just need to copy-paste the name of the icon. You'll see the name of the icon when you click on one of them, ie: "fa-check":
http://fontawesome.io/icon/check/

Jeff:

I already link to font awesome and add my own icons for each record. In the section editor when you set the icon for the menu item, I would like to set my icon to the cmsb menu item as it's default. I thought I might be able to do it via the viewer but could do it in cmsb by setting the default value for my icon to the cmsb menu icon.

Is there a way to do that?

You'd like the icons you set/used in each record of a section to be the default menu icons options in the section editor?

If I understand your question correctly: No, there is currently no way to do that.

If that's not what your question is meant, can you please provide an example for what you're trying to do?

Thanks,

We'll look into adding support for SVG image file type for the next release. 

You can add the following patch, for now, to display the thumbnails for SVG images in the admin.

In showUploadPreview function in \cmsb\lib\upload_functions.php file, add the following code after line 1086:

$isImage = preg_match("/\.(gif|jpg|jpeg|png)$/i", $uploadRecord['urlPath']); // line 1086

// display image preview for svg image file type
if (preg_match("/\.(svg)$/i", $uploadRecord['urlPath'])) {
  $isImage                = true;
  $uploadRecord['width']  = "150";
  $uploadRecord['height'] = "150";
}


Note: This patch is for v3.05 and don't forget to create a backup first

Let me know any questions.

Thanks,

Thanks for your feedback.

To answer your question, viewer function doesn't load the menu icons.
If you want to use the icons, you need to include the font CSS file in your viewer page:

<link rel="stylesheet" href="<?php echo CMS_ASSETS_URL ?>/3rdParty/clipone/plugins/font-awesome/css/font-awesome.min.css">

Regards,

I will look into the issue where some icons don't show and discuss your feedback with Dave.

It would be possible to exclude the 'old' link in functions permalink_cms_onSaveUpdatePermalinks and permalink_add ?

It would be then possible to again use a link without having to remove it before in permalinks table.

You would like to use permalink URL that is already used (old) by another record without having to delete it from the permalink table?

I wouldn't recommend doing it because we're using the old permalink to redirect the users to the current one when they visit the old URL. 
This is helpful for users who bookmarked a URL with an old permalink or when search engines or browsers cached the page's old URL, users will still get redirected to the correct page.

But if you don't mind the old permalinks, you can delete the old permalink record instead of updating it as an old record whenever you add a new one.
To do that, in permalink_add() function, change the block of code with comment "mark all other matching permalinks for this record as old" from mysql update to mysql delete.

I never tried this before and don't know what other negative effects it could cause so I'd like to suggest to do lots of testing first and see if the benefits of not checking the old permalink outweigh the negative effects of it.

Hope that helps!

Cheers,

We've just released v3.06 beta 1 (beta list members will get an email shortly). 

The major new features are:

• CMS Menus: Added icons for "CMS Setup" and "Admin" menus
• Section Editors: Added "Menu Icon" field for adding menu icon
• Field Editor: Added "crop" feature for upload field's thumbnail images

If you're not already on the beta tester email list and you'd like to get notified of upcoming betas (you must own at least 1 CMSB license) you can sign up here: 
http://www.interactivetools.com/news/manage.php

And if you have a license you can download the latest beta here:
https://www.interactivetools.com/order/download.php

Please post any feedback, questions, or bugs you find! Thanks! 

Thanks!

Have I added the new line correctly?

Looks good!

Currently my savePage does not "report" errors. (If there is a code problem it just doesn't work!)

1) In the unlikely event that there is a clash of permalinks, how would I feed the error back to my savePage - without breaking the anything (and losing the changes that could have been made to the page)?

The permalink_cms_onSaveUpdatePermalinks() function doesn't return the error message and instead, calls the die($error) function if there's an error.
So if you want to control the error reporting, you can copy the code and create your own version of this function that returns the error messages instead of dying. See the second step below.

2) What code would I use to check if a new permalink has been added to an input box and, if so, then update the required tables?

First, convert the input box value to SEO-friendly URL (converts spaces to dashes, removes non-alphanumeric characters):

$permalink = _permalink_generate_formatInputText($_REQUEST['permalink_input_box']);

Second, check $permalink for errors. The code below is derived from permalink_cms_onSaveErrorChecking() function (you can convert the code below to you own function):

// check if permalink already exists in database
$permalinkRecord = mysql_get('_permalinks', null, array('permalink' => $permalink)); 
$isAlreadyUsed   = $permalinkRecord && $permalinkRecord['recordNum'] != $recordNum && ($tableName != '_permalinks');

// error checking
$errors = '';
$requiredPrefix  = $GLOBALS['schema']['permalink']['defaultValue'];
if     (!$permalink)                              { $errors .= "You must enter a value for 'permalink'!"; }
elseif (preg_match("!^/!", $requiredPrefix))      { $errors .= "Permalink prefix can not start with a slash! Change the 'Default Value' for permalink field in Field Editor."; }
elseif ($permalink == $requiredPrefix)            { $errors .= "You must enter a value for 'permalink' after '" .htmlencode($requiredPrefix). "'!"; }
elseif (!startsWith($requiredPrefix, $permalink)) { $errors .= "Permalink must start with '" .htmlencode($requiredPrefix). "'!"; }
elseif (preg_match("|[^\w\-\./]|i", $permalink))  { $errors .= "Permalink can only contain these chars (a-z0-9/-.)!"; }
elseif (preg_match("!^/|/$!", $permalink))        { $errors .= "Permalink can not start or end with a slash!"; }
elseif (preg_match("!\.{2,}!", $permalink))       { $errors .= "Permalink can not include '..'!"; }
elseif (preg_match("!/{2,}!", $permalink))        { $errors .= "Permalink can not include '//'!"; }
elseif ($isAlreadyUsed)                           { $errors .= sprintf("Permalink '%s' is already in use, please choose another!", htmlencode($permalink)); }

Next, if there's no error, add/update the permalink of the record.
The permalink_add() function will take care of adding/updating the new permalink and will return an error if there is any.
If it doesn't return an error, you can continue with your other process, ie: update record.

if (!$errors) {
  // add/update permalink
  $errors = permalink_add($permalink, $tableName, $recordNum);
  
  if (!$error) {
    // do other stuff here, ie: update record
  }
}

Or you can do your other process first then add/update the permalink.

Finally, if there's an error, display it on your page.

NOTE: The code above are just examples and were not tested so you might need to tweak it more.

Let me know any questions!

Thanks,

It seems like permalink_cms_onSaveUpdatePermalinks function is not getting loaded on your page anymore.

I checked the code and the permalink_cms_onSaveUpdatePermalinks() function has been moved to /cmsb/plugins/permalinks/permalinks_cmsMenus.php since version 1.03.

And the permalinks_cmsMenus.php is only called if the logged in user is an admin.

To resolve this, you can either:

1. Include the permalinks_cmsMenus.php file in your add/edit page (not recommended because the functions inside this file are designed to be used in CMS admin pages)
2. Use permalink_add() function which returns an error if there is any. Ie: permalink is already in use

   // add/update permalink
$errors = permalink_add(@$_REQUEST['permalink'], $tableName, $recordNum);

Let me know how it goes!

UPDATE:

The permalink_add() doesn't do the permalink error checking, so it's better to include permalinks_cmsMenus.php file and use permalink_cms_onSaveUpdatePermalinks() function.

Thanks,

Verify in db that thumb 4 path is written - you will notice that the sizes are written even if path is not

This is actually the cause of the issue that Tim described.

The newly added thumbnails don't get displayed because the paths were empty on their uploads records.

As a solution, when adding new thumbnails settings and recreate the thumbnails, the script now updates the uploads records to store the new thumb paths.

This solution is included in the next CMSB release.

Regards,