It looks like Djulia's shuffle solution will work nicely for you. Based on your existing code structure, here's a slightly modified version to shuffle if there is more than one image upload:

Replace this:

<div class="imagebg">
<?php foreach ($calendar_random_imagesRecord['image'] as $index => $upload): ?>
<img src="<?php echo htmlencode($upload['urlPath']) ?>" width="100%" height="100%" />
<?php endforeach ?>
</div>

With this:

<div class="imagebg">
<?php if (count($calendar_random_imagesRecord['image']) > 1) { shuffle($calendar_random_imagesRecord['image']); } ?>
<?php foreach ($calendar_random_imagesRecord['image'] as $index => $upload): ?>
 <?php if ($index >= 1) { continue; } ?>
 <img src="<?php echo htmlencode($upload['urlPath']) ?>" width="100%" height="100%" />
<?php endforeach ?>
</div>

That should do it for you.

Also, you can remove "'orderBy' => 'RAND()'," at line 37 from your previous test. 

Let us know how you make out.

Best,
Steve

Wow... ZenDB sounds incredible. I've only had time for a cursory review since the beta released, but this looks absolutely brilliant!

Best,
Steve

$blogMetaData['totalRecords'] provides a count of all records returned from getRecords.

Modifying your existing code, you can run a query inside the following foreach loop to get counts for each Year/Month archive.

Try changing this:

<?php foreach($months as $date => $name): ?>
    <li><a href="blog.php?createdDate_keyword=<?php echo "$date";?>" ><?php echo $name;?> <?php echo $year;?><span><?php echo $blogMetaData['totalRecords']; ?></span><i class=" icon-right-open"></i></a></li>
<?php endforeach ?>

To this:

<?php foreach($months as $date => $name): ?>
<?php $archiveMonthCount = mysql_count('blog', "`createdDate` LIKE '$date%'"); ?>
    <li><a href="blog.php?createdDate_keyword=<?php echo "$date";?>" ><?php echo $name;?> <?php echo $year;?><span><?php echo $archiveMonthCount; ?></span><i class=" icon-right-open"></i></a></li>
<?php endforeach ?>

mysql_count is an internal CMSB function that returns the number of records found. For the WHERE clause, we're searching createdDate using the LIKE operator with wildcard % on your $date string (ex. 2023-09). This will match createdDate fields starting with your $date string value.

Hope this helps!

Best,
Steve

It appears you have code that is setting an image upload as inline style background image on the div tag. I can see 5 image tags output within that div as "display:none;". Can you post the full code sample that creates this section (see attached screenshot)? 

Best,
Steve

PHPMailer:

One thing I've noticed while testing PHPMailer using the sendMessage function is sending will fail if "CC" or "BCC" headers are set without values ('CC' isn't a valid email!; 'BCC' isn't a valid email!).

Usage context, in our CMS installations we provide optional text fields for users to add email addresses as "CC" or "BCC". The previous mailer implementation would simply ignore these headers if no values were set. I'm sure we could modify our process to create the headers array dynamically, but would prefer not needing to patch all instances. Otherwise it seems to work well!

Section Editor Sorting:

Very nice! This functionality would be great for the Fields portion as well.

Thanks Dave!

Best,
Steve

Glad to hear it's getting some use, and I appreciate the feedback! I'd noted this as well and plan to have a think on it.

In the meantime, you can easily add values to the per page drop down list by modifying this:
cmsb/lib/menus/default/list.php
Line 180 in latest CMSB v3.61

<?php echo getSelectOptions($metaData['perPage'], array(5, 10, 25, 50, 100, 250, 1000)); ?>

Just make note of the change for future cmsb upgrades.

Thanks, and please let me know of any other feedback!

Best,
Steve

I emailed you a screenshot of Recent Changes to check out.

Best,
Steve

Andreas - Agreed. For this plugin I was able to utilize the list page "selected records" checkboxes, so unfortunately it wouldn't work for section editor field sorting. However, I do believe that capability is part of the multi-select drag/drop sorting wishlist item Dave wanted to look into.

Best,
Steve

I had some time between projects and this utility was of interest. That being said, I've created a plugin I'd like to share with the community called "Move Records Here". It allows you to select multiple records in a manually sorted (dragSortOrder) list section and move them to their new sort position.

Note: This plugin has not been tested with Category type and has built-in checks to not enable for these sections.

Dave checked out the plugin before I put the finishing touches on it. He still plans to look into the multi record drag sort, but this plugin will work as a nice stop-gap.

See attached.

Best,
Steve

Playing off the "insert record here" concept, perhaps a "move selected records here" plugin? Action links could appear if records are selected.

Selected records could be moved to their new position, while retaining their respective group order. Would alleviate the need to "drag" over long lists as well.

Best,
Steve

The plugins defaultSqlData files ENGINE and CHARSET could use an update to InnoDB and utf8mb4, respectively. Functions that run when accessing admin Section Editors updates these anyway, so that's probably why I kept forgetting to post this :)

Best,
Steve

Kind of ironic that the forum post title for a beta has a bug. :-)

See attachment :)

Yes, Tim's method is straight forward and will certainly work well. 

You can also run UPDATE statements if you're comfortable. Make a backup and proceed with caution.
For example, these two statements would update the uploads table filePath and urlPath fields (finds and replaces ending .jpg with .webp):

UPDATE cmsb_uploads
SET filePath = REPLACE(filePath, '.jpg', '.webp')
WHERE filePath LIKE ('%.jpg');

UPDATE cmsb_uploads
SET urlPath = REPLACE(urlPath, '.jpg', '.webp')
WHERE urlPath LIKE ('%.jpg');

If your site uses thumbnails then you'd need to do the same process for each thumbFilePath and thumbUrlPath (thumbFilePath2 and thumbUrlPath2; etc up to 4).

To note, if all of your images were converted .jpg to .webp using the plugin this will work.
However, if you have "Use WebP" active in general settings, any new uploads appear to have the previous file type appended to the filename (ex. "myimage.jpg" would become "myimage-jpg.webp", which would require modifying the update statement replace '.webp' portion with '-jpg.webp').

Make a backup, and backup the backup :) Good luck!

Best,
Steve

P.S. I'd already started drafting this and didn't see your post update until complete :) Glad you got everything working again! I'll leave this up here in case it's useful in the future.

You may want to review the base CMSB htaccess <IfModule mod_phpX.c> directive. Will continue testing the beta release.

Thanks!
Steve

I've experienced this before. It's seeing the last number in url as 9999999999.

Try something like this, using the $blogPageWhere string to set your query (set from preview:num, or to use your normal page query):

if (getLastNumberInUrl() == '9999999999') { // if preview mode
$blogPreviewNum = intval( @$_REQUEST['preview:num'] );
$blogPageWhere  = "blog.num = $blogPreviewNum";
} else {
$blogPageWhere  = "blog.num='" . getLastNumberInUrl() . "'";
}

Hope this helps!

Best,
Steve

Just noticed the Spambot Email Protector plugin is no longer available. https://www.interactivetools.com/plugins/spambot-email-protector/

Curious as to why it was removed? We have some sites with updates planned that are using it, so was wondering about compatibility.

Best,
Steve

Everything else works correctly? No issues with API key, map record values, etc? Anything in the browser Console log that might give us a clue?

Not sure if you've seen or used it yet, but Google has a map style wizard with multiple themes available. Can do Silver theme, which is close to your example PNG. Dark theme, etc. It generates the base code for you, then you can modify it to work for your application.
https://mapstyle.withgoogle.com

Best,
Steve

Since upgrading to CMSB v3.55 and PHP 8 we've been frequently seeing the following error with the Add Apply Button v0.04 plugin:

UNCAUGHT_EXCEPTION: array_unshift(): Argument #1 ($array) must be of type array, null given
/path/to/web/root/cmsb/plugins/addApplyButton/addApplyButton.php (line 17)
https://www.domainname.com/cmsb/admin.php?menu=tableName&action=edit&num=48

The error has been frequent but occurs randomly so unfortunately I've been unable to identify anything record, or section editor, specific to aid in troubleshooting.

Thoughts on cause and patch? Thanks in advance.

Steve

If you were to treat the primary image upload file as your source file, the "thumbnail" sizes can be treated as alternative image sizes (versus the literal naming convention).

Use one of the available "thumbnails" as the main image for your page. The recreate utility will generate all your new images, then just update your website code to reference this "thumbnail" (alternative image size).

Best,
Steve