Recently the CreatePDF plugin is now giving the following error on two different sites using the same plugin and setup.

Site 1:

sh: /home/XXXXXX/public_html/cmsb/plugins/createPDF/wkhtmltopdf/wkhtmltopdf-0.12.5-1.centos7.x86_64: Permission denied
Error executing wkhtmltopdf! (Exit code: 126)

Site 2:

/home/XXXXXX/public_html/cmsb/plugins/createPDF/wkhtmltopdf/wkhtmltopdf-0.12.5-1.centos6.x86_64: error while loading shared libraries: libpng12.so.0: cannot open shared object file: No such file or directory
Error executing wkhtmltopdf! (Exit code: 127)

I'm not sure if it's an ini issue on the server, a server update that caused this, or if the plugin requires an update.

Any help would greatly be appreciated.

Dan

I need help to display content only to IPs that match an IP in the "restrictByIP" array from the CMS Security Settings.

The code below gets a site visitor IP and then checks to see if that IP is listed in the "restrictByIP" array from the CMS Security Settings.

This line, from the code below, is where I need help modifying  $safeips = array($SETTINGS['restrictByIP']);

Here is the code I have:

if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}

$safeips = array($SETTINGS['restrictByIP']);

if (in_array($ip, $safeips) !== FALSE)
{
echo "Match found display content";
} else {
echo "Match not found do not display content";
}

- Dan

I'm looking to add more "Placeholders" to a "Forum Notification Post" email.

For example, the client would like the full post message to appear in the email. However, I only see #post.message_snippet# only available.  Is there an area in the CMS where I can create my own placeholders, in the CMS, so I can display the entire post?

Another example placeholder I would need is a link to access the #forum# in the email. Currently I'm only able to show the forum name via the #forum# placeholder.

Any help would be greatly appreciated.

Dan

Thanks for the rapid response!  The update worked!

Dan

This solution also help me within the cms to remove the errors, but, I also see a similar error on the "Simple Forum" now.

This is what I see on the forum:

Deprecated: Array and string offset access syntax with curly braces is deprecated in /cms/cmsAdmin/3rdParty/HTMLPurifier/HTMLPurifier.standalone.php on line 3941 Deprecated: Array and string offset access syntax with curly braces is deprecated in /cms/cmsAdmin/3rdParty/HTMLPurifier/HTMLPurifier.standalone.php on line 14584 Deprecated: Array and string offset access syntax with curly braces is deprecated in /cms/cmsAdmin/3rdParty/HTMLPurifier/HTMLPurifier.standalone.php on line 21109 Deprecated: Array and string offset access syntax with curly braces is deprecated in /cms/cmsAdmin/3rdParty/HTMLPurifier/HTMLPurifier.standalone.php on line 21109

- Dan

The site require all members to have a unapproved checkbox to be unchecked for members to have access to members only areas.  Having one admin doing that makes it difficult for this client as they have many members that will be assigned to regions.

This is why if there was a way I can have a display of users in the user accounts based by author (createdby) the user would see only accounts associated to them.

Regarding how we would auto apply the createdby - One way we would set the "Created By" would be in the create a login form to add a radio selection for one of the four regions and the value would be the createdby user account.

Any thoughts?

Today i had a major issue, still trying to resolve, where the cmsb__error_log table encountered over 13 gigs of info.  It first caused the site to receive a "Hello, Website Visitors! error page. and then finally crashed the server.

I believe this may have happened today as both bing and google bots were on the sites gathering their info.

The iT guys at hostgator said the permalinks dispatch php was  causing an issue too.

Here is my thought

Could the bing bots have caused to many permalinks to get loaded at once which then increased the amount of server errors per permalink causing the cmsb_error_log to get too large which then crashed the DB eventually the server?

If so, can the Error Log be turned off?

Is there something that can be done to optimize the permalink plugin?

My server and sql db are being checked as I write this message.  If anyone has encountered anything similar or if you have a solution please reply.

Thanks

Dan

This is what we use:

// error checking
    $errorsAndAlerts = "";
    if (!@$_REQUEST['fullname'])                { $errorsAndAlerts .= "You must enter your full name!<br/>\n"; }
    if (!@$_REQUEST['email'])                   { $errorsAndAlerts .= "You must enter your Email!<br/>\n"; }
    else if(!isValidEmail(@$_REQUEST['email'])) { $errorsAndAlerts .= "Please enter a valid Email (example: user@example.com)<br/>\n"; }
    if (!@$_REQUEST['username'])                { $errorsAndAlerts .= "You must choose a username!<br/>\n"; }


Any help greatly appreciated.

- Dan

The code works great until now where I need a third dropdown to appear if it relates to the secondary dropdown. For example section > category > subcategory

I'm pretty close to accomplishing this but I can't get the third dropdown to appear after selecting the secondary populated dropdown based on the first selected dropdown.  Below is the code I have modified. 

I would greatly appreciate it If you could take a look at the code below and let me know what am I missing to make the ajax reload the page to show the third related dropdown. 

<?php
//Get the viewer functions.
include_once 'cmsb/lib/viewer_functions.php';
if($CURRENT_USER){
$sections = mysql_select('sections', mysql_escapef("`createdByUserNum` = ? AND mail = ? AND contact = ? AND hide_in_tab = ? AND hide = ?", $CURRENT_USER['num'],0,0,0,0));
$where = "TRUE ";
if(isset($_REQUEST['sections'])){
$categories = mysql_select('categories', mysql_escapef("`section` = ? AND hide = ?", $_REQUEST['sections'],0));
if(isset($_REQUEST['get_section_ajax'])) { //If we're loading the system via AJAX,
displayCategories($categories);
exit;
}
}
if(isset($_REQUEST['categories'])){
$subcategories = mysql_select('subcategories', mysql_escapef("`category` = ? ", $_REQUEST['categories']));
if(isset($_REQUEST['get_section_sub_ajax'])) { //If we're loading the system via AJAX,
displaySubCategories($subcategories);
exit;
}
}
}

//This function contains the code that displays the category menu.
function displayCategories($categories) {
?>
<?php if($categories): ?>
<label for="categories">Categories</label>
<select id="categoriesselect" name="categories">
<option value="" >Please Select</option>
<?php foreach($categories as $category): ?>
<option <?php selectedIf(@$_REQUEST['categories'], $category['num']); ?> value="<?php echo htmlEncode($category['num']); ?>" ><?php echo htmlEncode($category['title']); ?></option>
<?php endforeach; ?>
</select><br>
<?php endif; ?>
<?php
}
//This function contains the code that displays the subcategory menu.
function displaySubCategories($subcategories) {
?>
<?php if($subcategories): ?>
<label for="subcategories">SubCategories</label>
<select id="subcategoriesselect" name="subcategories">
<option value="" >Please Select</option>
<?php foreach($subcategories as $subcategory): ?>
<option <?php selectedIf(@$_REQUEST['subcategories'], $subcategory['num']); ?> value="<?php echo htmlEncode($subcategory['num']); ?>" ><?php echo htmlEncode($subcategory['title']); ?></option>
<?php endforeach; ?>
</select><br>
<?php endif; ?>
<?php
}


?>
<!DOCTYPE html>
<html>
<head>
<title>Example Page</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
</head>
<body>
<form method="post" action="">
<?php if($CURRENT_USER): ?>
<label for="sections">Sections</label>
<?php if($sections): ?>
<select id="sectionsselect" name="sections">
<option value="" >Please Select</option>
<?php foreach($sections as $section): ?>
<option <?php selectedIf(@$_REQUEST['sections'], $section['num']); ?> value="<?php echo htmlEncode($section['num']); ?>" ><?php echo htmlEncode($section['title']); ?></option>
<?php endforeach; ?>
</select><br>
<?php else: ?>
<p>There aren't any sections for this account.</p>
<?php endif; ?>

<!-- This div will load the content of the category drop down via ajax -->
<div id="category_containerselect">
<?php if(isset($_REQUEST['sections'])) { displayCategories($categories); } ?>
</div>
<div id="subcategory_containerselect">
<?php if(isset($_REQUEST['categories'])) { displaySubCategories($subcategories); } ?>
</div>
<input type="submit" name="go" value="Go" />
<?php else: ?>
<p>You must be logged in to use this dropdown.</p>
<?php endif; ?>
</form>
</body>
<script type="text/javascript">
$(document).ready(function() {
$('#sectionsselect').change(function(){
var sections = $(this).val();
var categories = $('#categoriesselect').val();
$.get( "?get_section_ajax=1&sections=" + sections + "&categories=" + categories, function( data ) {
$( "#category_containerselect" ).html( data );
});
});
});
$(document).ready(function() {
$('#categoriesselect').change(function(){
var categories = $(this).val();
var subcategories = $('#subcategoriesselect').val();
$.get( "?get_section_sub_ajax=1&categories=" + categories + "&subcategories=" + subcategories, function( data ) {
$( "#subcategory_containerselect" ).html( data );
});
});
});
</script>
</html>

$mailErrors = sendMessage(array(
      'to'       =>  $_REQUEST['email'],
      'from'     =>  'Website Admin <admin@website.com>',
      'subject'  =>  $_REQUEST['reply_subject'],
      'html'     =>  $message,
    ));

   $mailErrors = sendMessage(array(
      'to'       =>  $_REQUEST['email'],
      'from'     =>  'admin@website.com',
      'subject'  =>  $_REQUEST['reply_subject'],
      'html'     =>  $message,
    ));

Any help would be greatly appreciated.

Dan

Thanks for the reply. I have attached a sample php of how I would like it to appear with some code and also attaching the schema for both sections and categories. 

I needed to add a php header and footer using the Email Templates and was able to do with two custom placeholders.

I first added a header and footer  to the placeholder array:

 $emailHeaders = emailTemplate_loadFromDB(array(
          'template_id'  => 'USER-PASSWORD-RESET',
          'placeholders' => array(
          'header'  =>  file_get_contents('header.php',TRUE),
          'footer'  =>  file_get_contents('footer.php',TRUE),
          'user.username' => $user['username'],
            'user.email'    => $user['email'],
            'loginUrl'      => realUrl($GLOBALS['WEBSITE_LOGIN_LOGIN_FORM_URL']),
            'resetUrl'      => realUrl($GLOBALS['WEBSITE_LOGIN_RESET_URL'] . "?userNum={$user['num']}&resetCode=" . _generatePasswordResetCode( $user['num'] )),
        )));

Then in the email template I added #header# in the top of the Message HTML code and added #footer# at the bottom.

This setup was extremely helpful as I wanted to run db generated content in the email without having to copy and paste html code everytime I send an email.  It also helps clean your coding as having a header and footer include doesnt require that code in the Message HTML area.

Hope this helps! 

For example I have a Sports section here: www.newspaper.com/sports/

I would like to buy the domain name NewspaperSports.com and point it to: www.newspaper.com/sports/

The domain should remain as NewspaperSports.com at least for the initial landing page.

I don't want the url to be seen as www.newspapersports.com/sports/

Is there a way to do this via .htaccess?

My current code creates a redirect:

RewriteCond %{HTTP_HOST} ^NewspaperSports.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.NewspaperSports.com$
RewriteRule ^/?$ "http\:\/\/NewspaperSports\.com\/sports\/" [R=301,L]

Any help or suggestion would be greatly appreciated.

Dan

<?php if (sizeof($record['quickship_image']) >= 1): ?>   

<?php foreach ($record['quickship_image'] as $upload): ?>
<?php if ($upload['isImage']): ?>
<a href="<?php echo $record['link'] ?>"><img src="<?php echo $upload['urlPath'] ?>" alt="" class="img-bord" width="150" height="150" border="0" /></a> <?php endif ?>
<?php break; ?>
<?php endforeach ?>

<?php elseif (sizeof($record['main_image']) >= 1): ?> 

<?php foreach ($record['main_image'] as $upload): ?>
<?php if ($upload['isImage']): ?>
<a href="<?php echo $record['link'] ?>"><img src="<?php echo $upload['urlPath'] ?>" alt="" class="img-bord" width="150" height="150" border="0" /></a> <?php endif ?>
<?php break; ?>
<?php endforeach ?>

<?php endif ?>

In case anyone else is experiencing this here is how to resolve:

1. Open the section in the Admin Section Editor
2. Select the "Searching" tab of the section
3. Add _all_ to the Search Fields field then save