If that's the case you can do it by modifying the checkbox input to include the icon image. For example, if a checkbox looks like this:

<input type="checkbox" id="example" name="example" value="1" />
<label for="example">Example</label>

You can include the icon by:

<input type="checkbox" id="example" name="example" value="1" />
<label for="example"><img src="path/to/image" /></label>

However, if you want it to have it like your example as the checkbox is hidden, you will have to use javascript/jQuery to create a similar experience.

Let me know if you have any questions.

Thanks,

Do you want to add icons on the front-end pages of your website or you want to add it to the cmsb pages where the checkboxes are shown?

I have just tested the feature locally and it works without an issue. Could you let me know what does the returning email look like? Also make sure the $user variable has the fields you want to pass as placeholders.

Thanks,

Your url parameters will all be in the variable $_REQUEST. For example if you url looks like this: index.php?video_category=2, you will have this variable $_REQUEST['video_category'] equals 2. So your where statement can be something like this: 'video_category = "%\t' . $_REQUEST['video_category'] . '\t%"'. Note that if you didn't pass "video_category" parameter in the url and call $_REQUEST['video_category'], it will give you an error sayting $_REQUEST['video_category'] doesn't exist. So it's better to do an if(empty($_REQUEST['video_category'])) check before using it.

Let me know if you have any questions!

Thanks,

The combo page generator does not support this feature by default, However, you can make it happen by a few simple steps:

1. In the combo page, find where the getRecords() is called for "text list" records and change the "loadUploads" option to be true. By default, it will look something like this:

list($booksRecords, $booksMetaData) = getRecords(array(
'tableName'   => 'books',
'loadUploads' => true,
'allowSearch' => false,
));


2. Find where the "text list" is generated. Modify the list to show image uploads or whatever information you want for the list:

<!-- STEP2: Display Record List (Paste this where you want your record list) -->
    <b>Record List</b><br/>
    <?php foreach ($booksRecords as $listRecord): ?>
      <?php $isSelected = ($listRecord['num'] == $detailRecord['num']); ?>
      <?php if ($isSelected) { print "<b>"; } ?>
      <a href="<?php echo htmlencode($listRecord['_link']) ?>"><img src="<?php echo $listRecord['images'][0]['urlPath'] ?>" /></a><br/>
      <?php if ($isSelected) { print "</b>"; } ?>
    <?php endforeach ?>

If you want to use the thumbnail instead of the original image, change "urlPath" to "thumbUrlPath".

Let me know if you got any questions!

 You can get the full list of records and use array_groupBy() to categorize them by services_provided field. Here is a reference of a forum post showing how to use it: https://www.interactivetools.com/forum/forum-posts.php?postNum=2239479#post2239479.

Let me know if you have any questions!

If you go to your cmsb admin page with this parameter in the url: admin.php?menu=uploads, you can get to the page containing all the upload information. When you have your pdf generated you can add a new record to this section with proper information.

Let me know if you have any questions!

Thanks,

Here is an example of mysql_count usage:

mysql_count('products', 'type = "' . $type . '"');

Let me know if you have any questions!

Thanks,

I think updating CMSB version to the newest (3.12+) will solve the problem! Let me know if you find any issues updating or just general questions.

Thanks,

Did your or the hosting company updated PHP version? What is the CMSB version and PHP version that you are running right now?

It's not a temporary fix, you have some other options to resolve it but this is the best and fastest way to solve it. There are no significant security concerns as far as I know. To know more about sql strict mode you can check it here: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-strict

Thanks,

No it's a typo. It should be maxRecords.

The "true" disables sql strict mode temporarily so that integer fields takes empty value as valid input.

Can you try Changing the mysql_insert to:

mysql_insert('_accesslist', array(
 ...
 'maxRecords' => '',
 ...
), true);

Let me know if you are still getting errors!

Sorry I didn't realize it's generated by the website membership plugin. In that case, can you try setting it to be null?

Let me know if it works.

Thanks,

Change maxRecords to 0 should fix the error.

Thanks,

You can send your cms builder and ftp access information to support@interactivetools.com, and we can take a look at the issue. Also please attach the exact link to the record that has this issue.

Thanks,

Yes, it is because of the redirecting. I would recommend you modify the 404 page to add the libraries you need.

Thanks,

Is the permalink field set to be required or are you logged in as a non-admin user? When I test it with the admin account (And permalink not being admin only) and not required permalink field it works.

To show the first image of a record, you can directly use the first element of uploads field. For example: $record['images'][0]['urlPath'] will be the url path of the first element of "images" field uploads.

To organize the record array by let or others, you can manually set the if statement to pick them out first. For example:

foreach($itemsGroupByLamping['led'] as $record){
  // Display LED records
}

foreach($itemsGroupByLamping as $category => $records){
  if($category !== 'led'){
    // Display other records
  }
}

Or you can set order by to make led records the first of the array and use 1 foreach loop to display them all.

Let me know if you have any questions.

Thanks,

On your nl_manager.php or other pages that generates the list of newsletter lists, you can add an if statement to select which list you want to show. For example:

<?php foreach($lists as $list): ?>
...
<?php if($list['num'] == 1): ?>
...
<?php endif ?>
<?php endforeach ?>

Hope that answers your question and let me know if you need more help!

Thanks,

I have tested the permalinks plugin locally and it works with num field being used to created permalinks. Could you provide more details about what you want to achieve so we can identify what your issue is?

Thanks,

Can you try changing join('<li> ', $record['features:labels']); to join('</li><li>', $record['features:labels']); And let me know if that is what you want?

Thanks,

That looks good to me!

You can use array_groupBy() to get the results separated by a field. Here is an example:

// For $itemsRecords:
$itemsGroupByLamping = array_groupBy($itemsRecords, 'lamping', true);


That will give you an array of records grouped by their "lamping" category. The next thing you need is to loop through them and display:

foreach($itemsGroupByLamping as $category => $records){
 // Display the category.
 foreach($records as $record){
  // Display the record.
 }
}

Hope this helps you to solve the problem. If you need further help feel free to send the details to consulting@interactivetools.com.

Thanks,

We are glad to help you. However, we need some details to identify the issues:

1. What are the login issues and database issues specifically?

2. What steps did you take to create the issues?

3. What are the error messages showing for the issues?

If you have concerns about posting some of the information on the forum, you can always send them to support@interactivetools.com.

Thanks,