Thanks for the example images, that made things very easy to test! I did some research and it seems like there aren't many cameras which rely on the EXIF Orientation tag rather than saving the image content with the correct rotation in the first place, which is why we haven't seen this issue come up often. The EXIF Orientation tag seems to be poorly-supported by many software systems, and unfortunately the PHP image processing functions we're relying on don't offer support for it.

I wrote a patch which will rotate affected uploaded images before they go through the complicated "resizeOversizedImages" step, but unfortunately it seems like this approach uses a lot of memory, so we can't enable this solution by default. We're going to try to come up with a better long-term solution that will work for everyone, but in the meantime, the next version of CMS Builder will include the following code in cmsb/lib/upload_functions.php:

  // [experimental] rotate uploaded JPEG file if EXIF Orientation flag has been set
  // explanation: certain cameras save rotated JPEG content and use a poorly-supported EXIF flag to tell users the image must be rotated (90, -90, or 180)
  // our resampling code, which relies on GD, doesn't respect or preserve that flag, which can result in certain uploaded files being saved with incorrect rotation
  // in testing, doing rotations like the following before resampling caused out-of-memory errors on reasonably large image files, so this fix has been disabled by default
  $fixJpegExifOrientation = false; // defaulted to false to avoid potential out-of-memory errors
  if ($fixJpegExifOrientation) {
    _image_fixJpegExifOrientation($mainUploadWorkingPath);
  }

Once you've upgraded to the next version of CMSB, (we should be releasing it for beta testing within the next couple days,) you can edit this file and change "false" to "true", which should fix rotation issues for you. Please make sure to test it by uploading a big image to make sure your server has enough memory to be able to rotate the image. If you get an "out of memory" error, let us know and we'll let you know what your options are.

I'm assuming you found the 'adminUI_args' plugin filter and were attempting to add html to $adminUI['CONTENT']? I thought your approach should have worked, so I tested it and found a small bug which was preventing plugins from being able to modify 'CONTENT' (and only 'CONTENT'). I've patched this bug and the fix should be in the release of CMS Builder after the next one (we're in the middle of releasing and I don't think I can get my patch in to 3.03.)

There's not really much documentation for the adminUI_args array yet, as it's brand new, however there are some examples of its use above the adminUI() function in admin_functions.php -- and you may find it helpful to search the codebase for calls to adminUI() to see how it's used. I hope this helps!

That said, "admin_header" (or "admin_footer") is probably a much better (simpler) hook to use in this case, as you're now doing.

Glad to hear you were able to get it working!

Thanks for the details! I've fixed this issue for the next release of CMS Builder, although we're still using Railway and Open Sans.

If you wish to customize future versions of CMS Builder, please note that the font is now being included by lib/menus/header_css.php, instead of with an @import rule:

<link href='https://fonts.googleapis.com/css?family=Open+Sans:400,700,300|Raleway:400,700,500' rel='stylesheet' type='text/css'>

You can enforce this within CMS Builder by turning on system field editing (Admin > Section Editors > User Accounts, Advanced Commands... (near the bottom of the page)), then setting up the Allowed Content input validation settings for the username field. Let me know if the attached screenshot doesn't make it clear how to set it up and how it works.

If you have a front-end form which allows people to sign up and/or change their usernames, you'll need to add custom logic into it. If that's the case, please post the source code of your form and we can see if we can help from there.

Hope this helps!

That's great! I'm glad you got it working.

mysql_get() is just a shorter way to write your getRecords() call, but it doesn't have all the features that getRecords() has, so it's probably better that you're using getRecords().

I recommend replacing your three list fields with one list field. Call it "hotel", and in the Field Options in the Field Editor, select "num" for the List Value field and "name" (or whatever you like) for the List Label field.

Basically, if your Hotels table has three records (e.g. #1 Astoria, #2 Biltmore, #3 Caberet), the pulldown will show you the names (e.g. Astoria, Biltmore, Caberet), but you'll be storing just the record number (e.g. 3) in the Show records. Then in the front end, you use the number to look up the entire Hotel record. An easy way to do this is with mysql_get().

Here's an example:

<?php

list($showsRecords, $showsMetaData) = getRecords(array(
  'tableName' => 'shows',
  'where'     => whereRecordNumberInUrl(1),
  'limit'     => '1',
));
$showsRecord = @$showsRecords[0]; // get first record
?>


<?php if ($showsRecord['hotel']): ?>

  <?php $hotelRecord = mysql_get('hotel', $showsRecord['hotel']); ?>

  <?php if ($hotelRecord): ?>

    <b>Hotel accommodation available at</b>:
    <a href="<?php echo $hotelRecord['website'] ?>" title="<?php echo $hotelRecord['name'] ?>" target="_blank"><?php echo $hotelRecord['name'] ?></a>
    <?php if ($hotelRecord['rooms_cost']): ?> @ <?php echo $hotelRecord['rooms_cost'] ?><?php endif ?>.
    Telephone <?php echo $hotelRecord['phone'] ?>.<br/><br/>

  <?php endif ?>
<?php endif ?>

In my example, I'm guessing that your Hotel section name is 'hotel', but if it's 'hotels' or something else, you'll need to change the mysql_get line:

mysql_get('hotels', $showsRecord['hotel']);

The first "hotels" is the section name to load your hotel record from. The second "hotel" is the name of the (one) List Field in your shows section.

I'm also guessing at the field names in your hotel section, which you may need to change in my example code:

• $hotelRecord['name']
• $hotelRecord['website']
• $hotelRecord['rooms_cost']
• $hotelRecord['phone']

The extra "if" block in there is just for safety: in case you delete a Hotel but there are still Shows which had it selected, it protects you from showing an error. After trying to load hotel number 4, it'll make sure that we actually loaded a record before showing any Hotel fields.

If you can't get this working, please post the viewer code for your Hotel section, so we can see what the fields are in that section too.

Hope this helps!

I'm working on a fix for this.

As a workaround in the meantime, you can try grabbing the row from its top or bottom.

Thanks for the video demonstration!

<script type="text/javascript">
function initialize() {
  var mapCanvasId = 'map_canvas';
  var mapOptions  = { mapTypeId: google.maps.MapTypeId.ROADMAP };
  var map         = new google.maps.Map(document.getElementById(mapCanvasId), mapOptions);
  var bounds      = new google.maps.LatLngBounds();
  var infowindow  = new google.maps.InfoWindow();
<?php
foreach ($myRecords as $record) {
  if (!$record['latitude'] || !$record['longitude']) { continue; }
  $jsFunctionArgs = "{$record['latitude']}, {$record['longitude']}, {$record['num']}, '" .escapeJs($record['_link']). "', '" .escapeJs(@$record['marker_icon'][0]['urlPath']). "'";
  print "  _geocoder_addMarker($jsFunctionArgs);\n";
}
?>

  //
  function _geocoder_addMarker(latitude, longitude, recordNum, detailLink, markerIconUrl) {
    var latLng       = new google.maps.LatLng(latitude, longitude);
    var infowindowEl = document.getElementById('marker_infowindow_' + recordNum);
    var marker       = new google.maps.Marker({ map: map, position: latLng, icon: markerIconUrl });
    google.maps.event.addListener(marker, 'click', function() {
      if (infowindowEl) {
        infowindow.setContent(infowindowEl.innerHTML);
        infowindow.open(map, marker);
      }
      else {
        window.location = detailLink;
      }
    });
    bounds.extend(latLng);
  }

  //
  map.fitBounds(bounds);
}

</script>


Hope this helps!

If you've got a workaround that works for you, that's great! All the best! :)

I took a look at showHideDependentFieldsPlus, but it's been rather drastically changed and it would probably take me a couple of hours to sort out a fix. We could do this through our consulting service if you'd like. Please let us know if you're interested.

Here's a little plugin which uses Javascript to add a Send Test Email feature to the Email Templates section. Please let me know what you think!

Not an easy fix, no. Because of how customizable a "Get options from mySQL" list field can be, it's harder to check to make sure the field uses the foreign `num` field, and even to make sure that the foreign table is a CMSB-controlled table! This is a feature we could build for you through our consulting service. Please let us know if this is something you're interested in.

You'll want to add a "name" attribute to that <select>, and you'll want to pass in both the month and the year to the "value" of the <option>s, like this:

<?php
// get list of unique months and years with articles
$query = "SELECT DATE_FORMAT(publication_date, '%M %Y') as dateAndYear, YEAR(publication_date) as year, MONTH(publication_date) as month FROM cms_articles_by_erica WHERE `hidden` = 0 GROUP BY dateAndYear ORDER BY publication_date DESC";
$result = mysql_query($query) or die("MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
?>

<form method="POST" action="articlestest2.php">
<select name="dateAndYear" style="width:350px;" >
<option value="">Choose An Archive</option>
<?php while ($record = mysql_fetch_assoc($result)):?>
<option value="<?php echo $record['dateAndYear'] ?>"><?php echo $record['dateAndYear']; ?></option><?php endwhile ?></select>
<input type="submit" name="submit" value="Go To Archive" style="width:200px; "></form>

...And then on your archive list page, you can extract the month and year from $_REQUEST['dateAndYear']:

<?php
@list($month, $year) = explode(' ', @$_REQUEST['dateAndYear']); // split on space
...
?>

Does that help?

No, if there's no problem, it's not important. Setting field names up like that is only useful for automatically filling in the field responsible for joining when creating a new record from a related records list. Just so you don't have to select the Individual from the dropdown, for example.

Hope this helps clear things up! :)

I think I have a solution. Can you try making this change to the plugin to see if it fixes the problem?

In saveAndCopy.php, change line 22:

$button = '<input type="button" name="action=save" value="' .t('Save & Copy'). '" onclick="window.SAVE_AS_COPY_CLICKED=true; $(\'form\').submit();" class="button" />';

...adding this new code:

$button = '<input type="button" name="action=save" value="' .t('Save & Copy'). '" onclick="window.SAVE_AS_COPY_CLICKED=true; $(\'form\')[0].onsubmit(); $(\'form\').submit();" class="button" />';

Does that solve the problem? Please let me know and I will patch the add on. Thanks!

The reason they're showing up is that the current record doesn't have a num yet; that is to say that @$RECORD['num'] is ''. You can add a test to the MySQL Where to avoid showing records when the current record doesn't have a num yet by adding this:

individual ='<?php echo mysql_escape(@$RECORD['num']) ?>
AND <?php echo (@$RECORD['num'] ? 'TRUE' : 'FALSE') ?>

Or perhaps this would be simpler:

individual ='<?php echo mysql_escape(@$RECORD['num']) ?>
AND individual > 0

On a side note, you may want to rename your field from individual to individualsNum (the name of the table, plus "Num"). The reason is that the Related Records' create link will attempt to populate a field with that name (and there's currently no way to customize that.) You can see it attempting to do that in the address bar when you click Create on a Related Records field; for example, for a Create button on my "test" table (with a self-referential Related Records relationship):

http://example.com/cmsAdmin/admin.php?menu=test&action=edit&testNum=7&returnUrl=%3Fnum%3D7%26menu%3Dtest%26action%3Dadd

I hope this helps! Please let me know if you have any questions.

Try this:

$where = "title > ''";

Usually, you can get away with title != '', but that won't catch NULL fields, so the above is safer.

Does that help?

//Get prev/next links using the blog num 
$where = "num != 2";
list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array( 
'tableName' => 'films', 
'recordNum' => $filmsRecord['num'], 
'where'     => $where,
'orderBy'   => 'createdDate'
));

Does that help?

I'm assuming you're using getPrevAndNextRecords()? You can use a where clause to filter certain results.

// Supported options: tableName (required), recordNum (optional), and orderBy (optional, defaults to schema listPageOrder)
// list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array(
// 'tableName' => 'news',
// 'recordNum' => $record['num'],
// 'where' => '1', // optional - defaults to all records in section
// 'orderBy' => 'createdDate', // optional - defaults to schema listPageOrder
// ));

For example:

$where = "num != 2";

list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array(
  'tableName' => 'news',
  'recordNum' => $record['num'],
  'where'     => $where,
));

Does that help?

You can count the $basketRecords array with count():

There were <?php echo count($basketRecords); ?> record(s) returned.

The simplest way to sum a field is to use a variable and a foreach loop:

<?php
$sum = 0;
foreach ($basketRecords as $record) {
  $sum = $sum + $record['price'];
}
?>
The total price is: <?php echo $sum ?>

Does that help?

I'm not sure I quite understand what you're doing. Can you post the complete PHP source code for your page? Preferably as an attachment?

Generating the _link field will require another call to getRecords(), whether you're using the standard _link (which is generated from other fields) or a permalink _link. A simple solution would be to replace your code with this:

<?php
$where = 'num IN (' . mysql_escapeCSV($record['category:values']) . ')';
list($linkRecords) = getRecords(array(
  'tableName'   => 'category', // TODO: set this to the tableName for your link records
  'where'       => $where,
  'allowSearch' => false,
));
foreach ($linkRecords as $linkRecord): ?>
<a href="<?php echo $linkRecord['_link']; ?>"><?php echo $linkRecord['title']; ?></a>,
<?php endforeach ?>

Does that work?

However, if your code is already inside of a foreach, this is going to mean an extra getRecords() call per $record you're displaying, which may slow down your page. Let me know if this is a problem and I can show you how to load all the child records all at once (caching them at the top of your page).

How are disengaged, put on hold, and inactive/expired accounts represented in the database? Is it manufacturer.disabled or something like that?

Can you show us the detail page which is returning the "No record found" message so we can see what the logic is there?