I think using website membership would be the easiest and simplest thing to do in this case.  Let me know if you have extra concerns or run into any trouble.

Thanks
Robin

Another thing to look for is to make sure "Disable auto-formatting" is checked in the text box settings.  The auto-formatting can cause trouble with code.  

Let me know if you're still having trouble and we'll figure it out.

Thanks,
Robin

When outputting your text box with the paypal code are you using a plain echo like:

<?php echo $record['paypal_code']; ?>

?

Thanks,
Robin

You can echo php variables right into the JS.  Like:

alert("Hi <?php echo $firstName; ?>.");

One thing to look out for is if there are any double quotes in the echo-ed variable they will need to be escaped.

Hope that helps!
Robin

Looks like you want to do this in sql?  Check out the mysql DATEDIFF function.  Something like
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_datediff

DATEDIFF(NOW(), createdDate);

Hope that helps!  Thanks,
Robin

My first suspicion for the problem here is maybe 'contact_email_address' might not be the correct field name from your contact us section in the cms.  If you check the section editor for contact us you can see the field names.

Does it cause an error if you remove the @ from @$contact_usRecord['contact_email_address']?

Hope that helps!  Please let me know any other questions or if the problem persists.  Thanks,
Robin

I'm surprised about that error since line 167 in header_functions.php is not code, it's a comment.  That file may have uploaded incorrectly like your previous problem.  Please upload that file again and see if it resolves.  If the problem persists please fill out a second level support request with your CMS/FTP details (https://www.interactivetools.com/support/request/) and we'll take a look at what's going on.

Thanks,
Robin

Thanks,
Robin

The uber_file_get_contents() function is in:
/lib/file_functions.php

That error makes me suspect that the file_functions.php file didn't properly copy your server.  I'd try re-copying the lib folder from the CMSB install to your server.

Hope that helps!
Robin

hmmm so something isn't matching up here.  Is $productsRecord['category'] the variable that contains the category name?  If so - in the record that shows the category as not found, what's the value of $productsRecord['category']?

Thanks!
Robin

You can use the product record to help get the right category automatically.  In the example below i used your product category variable ($productsRecord['category']) to search for the category.

 // load record from 'categories'
  list($categoriesRecords, $categoriesMetaData) = getRecords(array(
    'tableName'   => 'categories',
    'where' => " title='" . mysql_escape($productsRecord['category']) . "' ",
    'orderBy'     => 'RAND()',
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $categoriesRecord = @$categoriesRecords[0]; // get first record
  if (!$categoriesRecord) { dieWith404("Record not found!"); } // show error message if no record found

Hope that helps!  Please let me know any questions.  Thanks,

Robin

Yes, it's the tabs that will be causing you trouble here.  You'll need to use LIKE conditions to get those values.  Unfortunately you can't use LIKE and IN at the same time.  You'll need to construct your sql something like this: (searching for gulet and motorsail)

list($yachtsRecords, $yachtsMetaData) = getRecords(array(
'tableName' => 'yachts',
'where' => "(type LIKE '%\tgulet\t%' OR type LIKE '%\motorsail\t%') AND active ='1' AND hide ='0' AND private ='1' ",
'loadUploads' => true,
'allowSearch' => true,
'useSeoUrls' => true,
'limit' => 3,
'debugSql' => true,
));

This is using LIKEs with ORs surrounded by brackets to achieve the same functionality as IN).   The "\t" is a tab and the % is a wildcard.  These help with the multivalue field setup in the cms.

Hope that helps!  Please let me know any other questions.  Thanks,
Robin

The download mail plugin just downloads everything it finds in the account (then archives or deletes the mails on the server after success).

Some ideas:
-Maybe you just needed to run it again?  It might have hit the download limit.
-If the thread was really long I wonder if it might have overwhelmed the database field character limit. (The field type can be updated in the section editor)
-There may have been some broken html in that message that might cause the message to not show properly (but should still show in the raw html).

Hope that helps. Please let me know any other questions. Thanks,
Robin

So $CURRENT_USER['preferred_yacht_types'] contains the preferred yacht types separated by spaces?

You can use a MySQL IN statement for this kind of thing:
https://www.w3resource.com/mysql/comparision-functions-and-operators/in-function.php

To you IN you'll need to make the data comma separated.  Here is another forum post we can use as a base example:
https://www.interactivetools.com/forum/forum-posts.php?postNum=2243600#post2243600

In this case you might try something like:

if ($CURRENT_USER['preferred_yacht_types']) {
  $preferred_yacht_types = explode(" ", trim($CURRENT_USER['preferred_yacht_types']));
  $user_yacht_type = mysql_escapeCSV($preferred_yacht_types);
} else {
  $user_yacht_type = "0";
}

list($yachtsRecords, $yachtsMetaData) = getRecords(array(
'tableName'   => 'yachts',
'where'     => "type IN (" . $user_yacht_type . ") AND active ='1' AND hide ='0' AND private ='1' ", 
'loadUploads' => true,
'allowSearch' => false,
'useSeoUrls'    => true,
'limit' => 3,
'debugSql' => true,
));

Hope that helps.  Please let me know any questions.  Thanks,
Robin

There is not a built in way to expire comments. (Though I think that's a great idea for future versions).

For now you could accomplish this with a small modification to the plugin.  

In the file websiteComments.php

Edit line 122:

From:

    'where'         => mysql_escapef("tableOrTag=? AND recordNum=?", $tableOrTag, $recordNum),

To:

    'where'         => mysql_escapef("tableOrTag=? AND recordNum=?", $tableOrTag, $recordNum) . " AND createdDate > (NOW() - INTERVAL 90 DAY)",

Please let me know if you run into any trouble.  Thanks,
Robin

It sounds like you're using Article Manager?  Do you have $article.author$ available as a placeholder?

Thanks,
Robin

Setting a field to allow author access but not viewer access is not possible with the current CMS.  However you can do it with a plugin.  I've attached a simple plugin that allows you to restrict fields to authors but not viewers.

Note:
The field permission should be set to "Everyone" or they wont have access anyway.

The plugin has an array at the top that you can edit (code example just below this paragraph).  "test" and "test2" are table sections.  The sub-arrays containing "field1", "field3" etc. are field names.  Change the table section names to your desired tables and the field names to the fields you want to hide from viewers.

$GLOBALS['authorOnlyField']['tableFields'] =
    array(  'test'  => array('field1','field3'),
            'test2' => array('field2', 'field4')
         );

Hope that helps.  Please let me know any questions.  Thanks,
Robin

  parse_str( $response, $responseValues );

Change to:

  $responseValues = $json;

Please let us know how that fix works for you.  Thanks,
Robin