In future, I'd recommend altering the names of tables and fields via the CMS itself. If I want to duplicate a section, I normally make a duplicate of the schema itself, then go into the CMS and it's automatically imported, then I can modify the fields from there.

To fix the issue with the unlinked fields, go to the cmsb/data/schema directory and open table_name.ini.php and rename the array keys that are the field names that have been changed. 

Thanks!

Greg

Would the subscription give the user access to certain features on the site? This is something that we've built before a few times using different methods.

One method is to use the Stripe subscription API to allow a user to sign up to certain monthly subscriptions, each month their subscription is automatically renewed until they cancel. 

Another method is to use Simple Cart to create a one-off subscription product. When a user purchases the product we give them a subscription for a certain amount of time. Once that that has expired they have to purchase the product again. This method is much simpler for us to implement, but the subscription is not automatically renewed.

If this is something you'd be interested in us helping you with, you can send an email to support@interactivetools.com and I can give you more details.

Cheers,

Greg

I'll take a look into this one now. I've just responded to your support email asking for a few more details.

Thanks,

Greg

Is this on a fresh install of CMS builder, or has it started happening on a site that had been working previously? I've done some quick research into that error, it's coming from the MySQL server itself and usually happens when there isn't enough disk space remaining for MySQL to operate.

I'd recommend raising a support ticket with your hosting provider regarding the issue and asking them if they can resolve it, as I don't think its an error that's coming from CMS Builder itself.

Let me know if you have any additional questions.

Cheers,

Greg

I'd highly recommend avoiding increasing the password reset time if possible, as you're reducing the security of your password reset process. Also, as you're changing a core function of one of our plugins we can't provide any support that arises from this change in future. First, you'll need to add this function to your user-password-request.php page after the viewer library has loaded:

  function _custom_isValidPasswordResetCode($userNum, $resetCode) {
    $userNum = (int) $userNum;
  
    // load user
    $user = mysql_get(accountsTable(), $userNum);
    if (!$user) { return false; }
  
    // reset codes are valid for 24-48 hours, check both days
    $codeToday     = _generatePasswordResetCode($userNum, 0);
    $codeYesterday = _generatePasswordResetCode($userNum, -1);
    $threeDaysAgo  = _generatePasswordResetCode($userNum, -2);
    $fourDaysAgo   = _generatePasswordResetCode($userNum, -3);
    $validCodes    = array($codeToday, $codeYesterday, $threeDaysAgo, $fourDaysAgo);
    $isValid       = (int) in_array($resetCode, $validCodes);
  
    //
    return $isValid;
  }

Then, update the line that calls the _isValidPasswordResetCode (line 63 on the default user-password-request.php page) to use our updated function:

    $isValidResetCode = _custom_isValidPasswordResetCode($_REQUEST['userNum'], $_REQUEST['resetCode']);

This code should increase the password security reset time from a maximum of 2 days to 4. 

Thanks,

Greg

The password reset link should remain active for up to 48 hours. Is this for resetting passwords on the front end of the site or in the CMS itself? Updating the reset password code in the CMS would require modifying the core codebase, so it's not recommended. But I can provide you with some sample code for updating the length of the password resets via the Website Membership plugin on the front end of the site if needed.

Cheers,

Greg

I'm basing this on my understanding of your previous posts, so I can't be 100% sure. But, if you're using the same database for the old and new installation, the cmsb_ prefixed tables are likely from the old installation. I can't really make the call if you're safe to delete those tables without investigating myself. 

If you do decide to delete them, you should ensure you make a full backup of the database before making any modifications and perhaps test by deleting a single table first (perhaps the error log) then confirming that change hasn't had any impact on the new installation. Also, I'd recommend confirming that none of your other sites is using this database and they could be the source of the cmsb_ prefixed tables as well.

You should also make sure that all of your front end pages are connected to the new CMS and any pages that perform CRUD functions on records are being made in the new tables. 

Cheers,

Greg

A couple of questions to help me diagnose the issue:

• Are the other sections appearing in the database with the correct prefix? For example, is there a table called cms_accounts or cmsb_accounts?
• It sounds like the old version of the CMS and upgraded version is on the same server, is that correct?

Cheers,

Greg

I think I've worked out the source of the issue, on line 146 the form starts that submits the updater record, but it doesn't include the record number. So when the form submits the page can no longer find the record it's supposed to be updating. 

If you change line 145 from this:

<form method="post" action="?">
  <input type="hidden" name="save" value="1" />
  <table border="0" cellspacing="0" cellpadding="2">

to this:

<form method="post" action="?">
  <input type="hidden" name="save" value="1" />
  <input type="hidden" name="recNum" value="<?php echo intval($recNum); ?>" />
  <table border="0" cellspacing="0" cellpadding="2">

Let me know if this resolves this issue.

Thanks!

Greg

I'm not sure what's causing that, are there any errors appearing in the error log? It might be that an error is appearing somewhere and causing the formatting of the page to be off. 

Cheers,

Greg

It would be great if you could give me a few more details on why users from those search pages are being redirected into the CMS, I'd recommend trying to avoid having that action happen if possible.

But if it is necessary, updating your code to the following should work:

  $programBaseUrl = _security_getProgramBaseRefererUrl();
  $popsearch1= 'https://popupdude.com/search.php';
  $popsearch2= 'https://popupdude.com/m/search.php';
  $isInternalReferer = ( startsWith($programBaseUrl, $_SERVER['HTTP_REFERER']) || startsWith($popsearch1, $_SERVER['HTTP_REFERER']) || startsWith($popsearch2, $_SERVER['HTTP_REFERER']) );
  if (!$isInternalReferer) {
    $format = "Security Warning: A link from an external source has been detected and automatically disabled.\n";

The problem was the previous code would pass true if any of the variables existed instead of passing a string, the code above will check if the referrer starts with the pop search 1 or 2 or the CMS base url.

As these are customizations to the CMS core, we can't provide any support if they cause any unforeseen issues, I'd recommend avoiding making these changes if you can.

Cheers,

Greg

To expand on Deborah's answer a bit, I'd create two upload fields, one that contains the book cover image called 'cover_image' and one that contains the book PDF called 'pdf'. I'd limit the fields so that each can only contain one upload. With this setup, Deborah's code would return one image and pdf per book record.

Thanks,

Greg

The problem was the function whereRecordNumberInUrl(0) would retrieve the number from the request before the internal link, so for the following link:

https://www.example.com/order.php?location=2&utm_medium=email&utm_source=sharpspring&sslid=MzM3NjQxMzWzMDcwBwA&sseid=MzIwszAzMTA3NwQA&jobid=75ea5113-e600-43aa-8a68-349d0be02a9f#/restaurants/nalleyfreshhuntvalley/1063/

It would use the value 9 (the final number before the hash and after the question mark) instead of the actual correct location of 2.

I've updated the code on the order page so that if it finds a location request variable, it will use that instead of the last value in the URL. Here is the updated code:

$recordNum = (!empty($_REQUEST['location']))? intval($_REQUEST['location']) : getLastNumberInUrl();


list($locationsRecords, $locationsMetaData) = getRecords(array(
'tableName' => 'locations',
'where' => "`num` = ".$recordNum,
'loadUploads' => true,
'allowSearch' => true,
'limit' => '1',
));
$locationsRecord = @$locationsRecords[0];
if (!$locationsRecord) { dieWith404("Record not found!"); }

Cheers,

Greg

I think I understand now, so you want to show the summary field for entries from the listings section and the title field for entries from the home pages section?

The results returned by the searchMultipleTables function include the table name, you can use this to work out which results came from which table and display the appropriate data like this:

<?php if($record['tablename'] == 'homepages'): ?>
  <a href="<?php echo $record['field5'] ?>"><?php echo $record['_title'] ?></a>  <!--This result was gained from the homepages table-->
<?php elseif($record['tablename'] == 'listings'): ?>
  <a href="<?php echo $record['field3'] ?>"><?php echo $record['_summary'] ?></a>  <!--This result was gained from the listings table-->
<?php endif; ?>

Cheers,

Greg

So the issue is that the search results are not being returned in the same set of results and you're having to call the searchMultipleTables function twice? I think the problem is that the variable searchTables is declared twice, which will remove the search options you've already set for the homepage. You need to remove it the second time it's appears:

...
  'titleField'   => 'fullname',
  'summaryField' => 'fullname',
  'searchFields' => array('fullname'),
  'field5'       => 'permalink',
);

$searchTables = array(); //REMOVE THIS LINE!
$searchTables['listings'] = array(
  'viewerUrl' => 'movie.html',
  'titleField' => 'user_movie',
...

Cheers,

Greg

Thanks for posting your code, here is an example using your sections that should point you in the right direction:

<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block to the TOP of your page BEFORE anything else. */
  require_once "init.php";

  list($listingRecords, $listingDetails) = getRecords(array(
    'tableName' => 'listings',
    'joinTable' => 'homepages',
    'perPage'   => '16',
  ));

$homePageNums    = [];
$homepageRecords = [];

//Step 1) Get all of the home page values
foreach($listingRecords as $listing) {
  if(!empty($listing['model:values'])) {
    foreach($listing['model:values'] as $modelNum) {
      if(!in_array($modelNum, $homePageNums)) {
        $homePageNums[] = $modelNum;
      }
    }
  }
}

//Step 2) Get all of the home page records that are used by the listings
if($homePageNums) {
  list($homepageRecords, $homepageDetails) = getRecords(array(
    'tableName'   => 'homepages',
    'where'       => '`num` IN('.mysql_escapeCSV($homePageNums).')',
    'allowSearch' => false,
  ));
  //Group them by the home page num to make them easy to find
  $homepageRecords = array_groupBy($homepageRecords, 'num');
}


?>
<!-- listing-item-container -->
<?php foreach ($listingRecords as $listing): ?>
  <?php foreach ($listing['model:values'] as $modelNum): ?>
    <!-- Get the linked home page record from the home page records array -->
    <?php $homepage = ($homepageRecords[$modelNum])? $homepageRecords[$modelNum] : [] ?>
    <?php if($homepage): ?>
      <a href="<?php echo $homepage['_link']; ?>"><?php echo $homepage['fullname']; ?></a>
    <?php endif; ?>
  <?php endforeach ?>
<?php endforeach ?>
<!-- listing-item end -->

So the code above collects all num values for the home pages that are used on this page, then collects the home page records and groups them by their num to make them easier to find later on.

Then, when you're cycling through all the listings, the code checks if a home page record is in the array that has that num, then displays it if it exists. 

Cheers,

You can call the emailTemplate_loadFromDB and sendMessage functions for each email that you need to send. For example, if you have two templates called TEST-MAIL-ME and TEST-MAIL-ME-2, you could send both using the following code:

if (!$errorsAndAlerts) {
  
  //Create the placeholders that will be used in both emails
  $placeholders = [
    'visitor.name'      => $fullname,
    'visitor.email'     => $email,
    'visitor.phone'     => $phone,
    'visitor.message'   => $message,
    'visitor.agree'     => $agree,
  ];

  //Send the first email
  $emailHeaders = emailTemplate_loadFromDB(array(
    'template_id'        => 'TEST-MAIL-ME',
    'addHeaderAndFooter' => false,
    'placeholders'       => $placeholders,
  ));
  $mailErrors = sendMessage($emailHeaders);


  //Send the second
  $emailHeaders = emailTemplate_loadFromDB(array(
    'template_id'        => 'TEST-MAIL-ME-2',
    'addHeaderAndFooter' => false,
    'placeholders'       => $placeholders,
  ));
  $mailErrors = sendMessage($emailHeaders);

This just example code, so you'll have to make a few changes to get it working (for example; updating the email template ID's), but it should point you in the right direction.

Cheers,

You'll need to create a foreach loop at the top of the page that gets all of the subcategory num's into a single array then makes a call to the database to select all the num values in one go using a MySQL IN statement.

Would it be possible to post the code you've created so far that shows all the permalinks? Then I can give you more details on how to set this up.

This is a great idea, I've added it to our internal list of feature requests. It would also be possible to create this feature using a plugin if it's something you'd be interested in us developing for you. If it is, you send an email to support@interactivetools.com and I can give you an estimate for building it.

Cheers,

Greg

Your method would work great, the only change I would make is to check the related_pages values exist before imploding them, or you might get an error:

<?php

  // load record from 'pages'
  list($pagesRecords, $pagesMetaData) = getRecords(array(
  'tableName'   => 'pages',
  'where'       => '`num` =' .$selectedCategory['num'],
  'loadUploads' => true,    'allowSearch' => false,
  'limit'       => '1',
  ));

  $pagesRecord = @$pagesRecords[0]; // get first record
  if (!$pagesRecord) { dieWith404("Record not found!"); } // show error message if no record found

  if (!empty($related['related_pages:values'])) {
    $relatedNums = implode(", ", $related['related_pages:values']);
    if($relatedNums) { $pagesRecord['related_pages:records'] = mysql_select('pages', "`num` IN ($relatedNums)"); }
  }

I also noticed that the HTML contains an image URL, so you might need to swap out the mysql_select for a getRecords so that the upload records are included.

Cheers,

Greg

I've not come across that issue before, it would be great if I could have a look at the site affected so I can work out the source of the issue.

Please could you send an email to support@interactivetools.com and include the URL and login credentials for the sites CMS, as well as the FTP credentials?

Thanks!

Your mention of the forum made me think of a really easy way to do this. Do you have a copy of the Simple Forum plugin? If you do, it comes with a function that will convert any URL's it finds to links as well as removing any malicious looking HTML from a string. If you had the Simple Forum plugin installed you could call the function anywhere in your site like this:

<?php
  include_once 'cmsb/lib/viewer_functions.php'; //Include the viewer functions (if not already included)
  $testString = 'Here is my test string with a URL: https://www.google.com'; //Example string which you want any URLs converted to links.
  $testString = sforum_cleanAndFormatHTML($testString); //Forum function to convert the url to a link.
  echo $testString; //Display the string

If you don't have that plugin, I found this article from css-tricks.com that explains how you can convert a URL to a link:

https://css-tricks.com/snippets/php/find-urls-in-text-make-links/

I've not tested the method in this article, but css-tricks are normally reputable. It also looks like it wouldn't be difficult to modify this method to add the span around the link.

Thanks!

Good to hear the issue is resolved.

When sending the values from a set of multi-select checkbox fields, the simplest solution is to send the values as a comma-separated string using the implode function.

For example, if you had a set of multi-select checkboxes like this:

<input name="cities[]" value="London" />
<input name="cities[]" value="New York" />
<input name="cities[]" value="Tokyo" />

You could add the values as a placeholder to your email using the following method:

  $cities = "";
  if( !empty($_REQUEST['cities']) && is_array($_REQUEST['cities']) ) {
    $cities = implode(", ", $_REQUEST['cities']);
  }

  $placeholders = [
    'visitor.name'      => $fullname,
    'visitor.email'     => $email,
    'visitor.phone'     => $phone,
    'visitor.message'   => $message,
    'visitor.agree'     => $agree,
    'visitor.cities'    => $cities
  ];

This is just sample code, so you'll probably need to make a few changes to get it working with your codebase, but hopefully, it will point you in the right direction.

Thanks!

Greg