Shawn

I'm just following up on an old post of mine regarding emailing the content of a form to a specific email address. I know someone mentioned to modify the plugin by calling the sendMessage() function (in /cmsb/lib/common.php) when the record is successfully created. I'm just a little puzzled on what exactly to modify and where inside common.php.

Thanks!

I'd like to make a responsive calendar of events on the website, where the events are managed in CMSB through a multi-event section editor. (the ultimate goal is to show a calendar of upcoming concerts at a venue)

Is this possible?

Thanks!

Shawn

I reached out to the support for the hosting company. They responded with the following:

Unfortunately, due to our system's features we do not support utf8mb4_unicode_520_ci and utf8mb4_general_ci, because there is no way such changes be implemented for particular users on a shared platform as it will affect every user. This may be implemented for all users in the future. You may find this link useful: https://stackoverflow.com/questions/42385099/1273-unknown-collation-utf8mb4-unicode-520-ci/44877331

I took a look at that link, but I have no idea what it means or if it's helpful at all.

Will I end up having to switch to a different hosting company to use CMS Builder?

Thanks

Error connecting to MySQL:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I get the above error that displays in the actual install page, on the very top. If I change the MySQL Hostname from "localhost" to "sql5c40n.carrierzone.com" the page refreshes and it goes to a completely blank white page with black text that says:

mysqli: error setting character set utf8mb4: Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)

I tried disabling the php.ini, .htaccess, and users.ini files, still no luck.

Is this something I need to contact my hosting company's customer support about? Or is there something I can change to fix this. 

Thanks!

1. If I have a simple Contact Us form, if someone fills out the form and submits it, where does that information go? Can I have it sent directly to my email?

2. Is it easy to add a CAPTCHA to a form? Or is there anything to deter spam submissions?

Thanks!

Shawn

I'm not on my regular computer to test it out, but that does look like it should work.

thank you guys very much! I really appreciate it.

Thanks for helping me out! I really appreciate it.

But with your bottom example, that would essentially group the starred items on top and the rest below? The 'Silver' , 'Gold' ,and 'Platinum' are basically just names for templates. 'Platinum' results would link to a.php(then the record link), 'Gold' results would link to b.php(then the record link), and Silver would link to c.php(then the record link).    But when someone types in their zip code on the homepage, the results should be in order by distance, not if they are a starred listing or not. That's where i think it would get hard, because some of the results should not be links and some should link to a.php(then the record link), some should link to b.php(then the record link), and some c.php(then the record link).

Your top one would be ideal, but how could i get certain ones to link to certain templates, and some not link anywhere?

Let me know if this makes sense or not, or if Im just explaining it weird lol.

Thanks again!

Thanks for helping me out on this. Yes it is the same question as my other post, I just thought I'd re-word it.

- Shawn

I was wondering how I should set up the backend so i can show a list of records sorted by a given location.

The thing is, some of the records would have to link to a specific template (either template-A or template-B) and some of the records would not link to anything at all, but all would still have to be in order by distance away from the given location. 

---------

Currently I have 3 checkboxes for each record in the backend, and on the actual list.php page, any record that has anything checked shows on the top of the list, and the rest show below them. But now, I need everything in order by the given distance away. (im also using the geocoder)

Im just wondering if anyone else had any thoughts on this. I've been looking at it more, and I am pretty stumped.

my website is www.seenstream.com. if you enter a zip code to go to the list area and click on one of the starred results it will take you to a minipage specific to that bar. My question is, with this Membership plugin, could I make it so each bar could have their own log-in information to log in to change the information on their specific page?

Thanks

I think that is how i have it set up right now. But I actually need everything all mixed together. 

- Shawn

Website: www.seenstream.com

Right now, if you search for a zip code from the homepage, it will display records that have either a "platinum" or "gold" or "silver" listing on the top of the list with a star next to their listing and will link to their respected template...and everything that is not one of those is displayed below it. 

(basically... if the record has a checkbox checked in cmsAdmin, it will display on top of the list, clickable, with a star. everything else below it, not clickable, and no star)

How can I make it so everything is displayed in the list where it should be according to the distance that was searched. (i'm using the geotagger plugin) without having the starred ones on top, and the non-starred ones below.

Thanks!

Code is as follows on the 'list.php' page:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php require_once "cmsAdmin/lib/viewer_functions.php"; ?>
<?php if (!@$GLOBALS['GEOCODER_PLUGIN']) { die("You must activate the Geocoder plugin before you can access this page."); } ?>
<?php

  $kmOrMiles = 'miles'; // can be 'miles' or 'km'

  // set default values
  if (!array_key_exists('fromAddress', $_REQUEST)) { $_REQUEST['fromAddress'] = '10001'; }      // this is the default address/postalcode if none entered
  if (!@$_REQUEST['maxDistance'])                  { $_REQUEST['maxDistance'] = '50000'; } // this will include all results

  // get coordinates
  list($myLat, $myLng) = geocodeAddress( @$_REQUEST['fromAddress'] );

  // error checking
  $errorsAndAlerts = '';
  if (@$_REQUEST['search']) {
    if     (!@$_REQUEST['fromAddress']) { $errorsAndAlerts .= "No address entered!<br/>\n"; }
    elseif (!$myLat || !$myLng)         { $errorsAndAlerts .= "We couldn't determine your location, please try again!<br/>\n"; }
  }

  // get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($trueAddressRecords, $trueAddressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
      'where'         => "platinum  = '1' OR gold = '1' OR silver = '1'", 
    ));
  }

// get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($falseAddressRecords, $falseAddressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
      'where'         => "platinum  = '0' AND gold = '0' AND silver = '0'",   
  'perPage'       => '5',
    ));
  }

?>

displaying results code:

<!-- participating --> 
<?php if (@$_REQUEST['search'] && !$errorsAndAlerts): ?>
<?php foreach ($trueAddressRecords as $record): ?>
<a href="http://www.seenstream.com/<?php if($record['platinum'] ==1): ?>
a.php?<?php echo $record['_link'] ?>
<?php elseif ($record['gold'] ==1): ?>
b.php?<?php echo $record['_link'] ?>
<?php elseif ($record['silver'] ==1): ?>
c.php?<?php echo $record['_link'] ?>
<?php endif ?>" />
<div class="listing-container"><?php foreach ($record['logo'] as $index => $upload): ?><img class="barlogo" src="<?php echo $upload['urlPath'] ?>" /><?php endforeach; ?> 
<div class="listing-container-heading"><h2><?php echo $record['title']; ?></h2></div> 
<p><?php echo $record['address']; ?><br /><?php echo $record['phone_number']; ?><br />(<?php echo floor($record['_distance'] * 10) / 10; ?> <?php echo $kmOrMiles ?> away)</p> 
<div class="star"></div></div> 
</a> 
<?php endforeach ?> 
<?php endif ?>

<!-- not participating -->
<?php if (@$_REQUEST['search'] && !$errorsAndAlerts): ?>
<?php foreach ($falseAddressRecords as $record): ?>
<!--<?php echo htmlspecialchars($record['title']); ?>,-->
<div class="listing-container"><img class="barlogo" src="i/barlogo_seenstream.jpg" /><div class="listing-container-heading"><h2><?php echo $record['title']; ?></h2></div><p><?php echo $record['address']; ?><br /><?php echo $record['phone_number']; ?><br />(<?php echo floor($record['_distance'] * 10) / 10; ?> <?php echo $kmOrMiles ?> away)</p></div>
<?php endforeach ?>


<?php if (!$falseAddressRecords): ?>
No results found!
<?php endif ?>
<?php endif ?>

I am attempting to geotag quite a large amount of things, could this be a reason? i noticed if i keep trying to geotag the same table more of the skipped ones do get geotagged.

<?php echo htmlencode($record['streamaddress']) ?>


that is what I am currently using and it is displaying the full HTML instead of actually rendering the HTML. I also tried...

<?php echo htmlspecialchars($record['streamaddress']) ?>


Thanks again!

So on my website, seenstream.com, I have a zip code search that displays a list of closest results. On the top of that list are the main "Participating Bars"

Each participating bar has check boxes in the backend to designate which template it should link to... Platinum, Gold, or Silver. The Platinum should link to a.php, Gold links to b.php, Silver links to c.php.

But my problem is as soon as i uncheck the "platinum" checkbox in its record in the backend, and check "gold" it then does not show up in the list. When it should show up, right next to the Platinum results, and link to b.php.

my code above the DOCTYPE is:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php require_once "cmsAdmin/lib/viewer_functions.php"; ?>
<?php if (!@$GLOBALS['GEOCODER_PLUGIN']) { die("You must activate the Geocoder plugin before you can access this page."); } ?>
<?php

  $kmOrMiles = 'miles'; // can be 'miles' or 'km'

  // set default values
  if (!array_key_exists('fromAddress', $_REQUEST)) { $_REQUEST['fromAddress'] = '10001'; }      // this is the default address/postalcode if none entered
  if (!@$_REQUEST['maxDistance'])                  { $_REQUEST['maxDistance'] = '50000'; } // this will include all results

  // get coordinates
  list($myLat, $myLng) = geocodeAddress( @$_REQUEST['fromAddress'] );

  // error checking
  $errorsAndAlerts = '';
  if (@$_REQUEST['search']) {
    if     (!@$_REQUEST['fromAddress']) { $errorsAndAlerts .= "No address entered!<br/>\n"; }
    elseif (!$myLat || !$myLng)         { $errorsAndAlerts .= "We couldn't determine your location, please try again!<br/>\n"; }
  }

  // get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($trueAddressRecords, $trueAddressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
  'where'      => "platinum  = '1'", 
    ));
  }

  
// get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($falseAddressRecords, $falseAddressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
  'where'      => "platinum  = '0'",   
  'perPage'       => '5',
    ));
  }

?>

and my code in the search area is:

<?php if (@$_REQUEST['search'] && !$errorsAndAlerts): ?>
<?php foreach ($trueAddressRecords as $record): ?>
<a href="http://www.seenstream.com/<?php if($record['platinum'] ==1): ?>
a.php?<?php echo $record['_link'] ?>
<?php elseif ($record['gold'] ==1): ?>
b.php?<?php echo $record['_link'] ?>
<?php elseif ($record['silver'] ==1): ?>
c.php?<?php echo $record['_link'] ?>
<?php endif ?>" />
<div class="listing-container"><?php foreach ($record['logo'] as $index => $upload): ?><img class="barlogo" src="<?php echo $upload['urlPath'] ?>" /><?php endforeach; ?> 
<div class="listing-container-heading"><h2><?php echo $record['title']; ?></h2></div> 
<p><?php echo $record['address']; ?><br /><?php echo $record['phone_number']; ?><br />(<?php echo floor($record['_distance'] * 10) / 10; ?> <?php echo $kmOrMiles ?> away)</p> 
<div class="star"></div></div> 
</a> 
<?php endforeach ?> 
<?php endif ?>

<?php if (@$_REQUEST['search'] && !$errorsAndAlerts): ?>
<?php foreach ($falseAddressRecords as $record): ?>
<!--<?php echo htmlspecialchars($record['title']); ?>,-->
<div class="listing-container"><img class="barlogo" src="i/barlogo_seenstream.jpg" /><div class="listing-container-heading"><h2><?php echo $record['title']; ?></h2></div><p><?php echo $record['address']; ?><br /><?php echo $record['phone_number']; ?><br />(<?php echo floor($record['_distance'] * 10) / 10; ?> <?php echo $kmOrMiles ?> away)</p></div>
<?php endforeach ?>
<?php if (!$falseAddressRecords): ?>
No results found!
<?php endif ?>
<?php endif ?>

Please let me know if you need any other information, or have any other questions for me.

again...

if you go to www.seenstream.com, type in like "54952", it should show 3 bars with stars next to them. 1 to a template a.php and the other 2 to the template b.php

In the record... in the WYSIWYG editor, when I click HTML and add a bunch of stuff, when i click "update" The code disappears, and doesnt save anything that i add.

I am only looking to add HTML code into this field, is there a way I can just avoid the WYSIWYG editor and just add a text box where I can enter in a chunk of code that will display on the website?