Found a little but in this version any fields that are set as system fields with passwords they dont show anything in the text input field in the cmsb they are showing as blank.

I have tried all them and none work with Rocky Linux.

With wkhtmltopdf now not supporting current releases of OS eg Rocky 8 or 9 and it wont run with the Almalinux either on the server what will become of the PDF plugin?

I have a need for a new project that requires to create a lot of PDF from webpages how do we go about this?

there is an issue with saving Email Templates they create a pop error about saving the template.

So i have found a solution that works perfect no mysql or anything just pure PHP check it out https://www.xml-sitemaps.com/standalone-google-sitemap-generator.html

they are not cheap hosting they are around $250 a year, the issue comes from cPanel turing this feature of by default and have told all hosting companies to do so.

I spun up a VPS server the other day and do an install of cPanel and yep there it was turned off by default.

here is an excerpt from the ticket from a large hosting company here in Australia

We have checked and confirmed with our System Administrators that the PHP Functions (show_source, system, shell_exec, passthru, exec, popen, proc_open, allow_url_fopen, pcntl_exe) are all disabled on all Shared Hosting servers. This change was made due to potential vulnerabilities being exploitable using those functions. For the same reason, the decision was not made public and was on the advice from WHM/cPanel.

I have run into this with a few hosts now and it seems that every single web hosting company that is using cPanel has turned this feature off and has been told to by cPanel due to some security risk with binarys being run on servers now.

I have spoken with 3 hosting companies in Australia and they all say the same thing and refuse to turn it back on and said if you want this then you need to buy a VPS to get the feature control and turn it off at your own risk.

This is only going to get worse as more and more hosting companies turn this off.

Might be worth looking into another solution for the plugin as i have 5 websites that now can't do this.

that worked now cheers.

Am trying to install CMSB 3.09 on PHP 7 which is working fine but when i try and install the permalink 1.08 version i get this error all the time.

MySQL Error - in plugin_functions.php on line 305 by permalink_cms_onInstallCreateSchemas()

Any idea why?

OK did a fresh install on both PHP7 and PHP7.1 and both worked and all looking great no issues so far.

Great news about releasing for PHP7

I tried doing an install on PHP7.0.13 and it worked but i get this error straight after install

Notice: Only variables should be passed by reference in /cmsb/lib/admin_functions.php on line 312
Warning: Cannot modify header information - headers already sent by (output started at /cmsb/lib/admin_functions.php:312) in /cmsb/lib/menus/header.php on line 4

I then tried an install on PHP7.1.0 and i got these errors on the first page load when the setup loads.

Warning: A non-numeric value encountered in /cmsb/lib/menus/header_functions.php on line 72
Warning: A non-numeric value encountered in /cmsb/lib/menus/header_functions.php on line 72
Warning: A non-numeric value encountered in /cmsb/lib/menus/header_functions.php on line 72

These are the only issues I got on install and using the system at all.

I found a way around it so now each section FAQs and Testimonials is using its own Load Records statement and then using a custom Where statement to pull the ProductsNum from the Products section and then relating them to each record to display only the records related to that product.

SELECT SQL_CALC_FOUND_ROWS `products`.*,
faqs.`num` as `faqs.num`,
faqs.`products` as `faqs.products`,
faqs.`question` as `faqs.question`,
faqs.`content` as `faqs.content`,
testimonials.`num` as `testimonials.num`,
testimonials.`products` as `testimonials.products`,
testimonials.`name` as `testimonials.name`,
testimonials.`content` as `testimonials.content`
FROM `cmsb_products` as `products`
LEFT JOIN `cmsb_faqs` AS `faqs` ON products.`num` = faqs.num
LEFT JOIN `cmsb_testimonials` AS `testimonials` ON products.`num` = testimonials.num
WHERE (products.num =1)
ORDER BY dragSortOrder DESC

Well at the moment there isnt any but we are expecting a few in there and the products could be changing a lot so that is why LeftJoin would be better as the FAQ and Testimonials will be linked to each product. they will not be shown on other pages on the product page related to the product.

I have change the associated records to use this but still it wont load any records from the leftJoin tables and i have no idea why it wouldnt be.

// load record from 'products'
list($products, $productsMeta) = getRecords(array(
'tableName' => 'products',
'where' => 'products.num =' . getNumberFromEndOfUrl(),
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
'leftJoin' => array('faqs' => 'num', 'testimonials' => 'num'),
//'debugSql' => true,
));
$products = @$products[0];

I have this section called Products which lists details about all the products.

Then there are 2 other multi sections for FAQ's and Testimonials.

I have the FAQ's and testimonials setup with a list item for each so that each of the FAQ and Testimonials can be associated with products.

I want to be able to pull the details from each of them and then display with the related product page.

How can i put all the related records for each of the FAQ and Testimonials.?

This is what i have but it wont pull the related records

// load record from 'products'
list($products, $productsMeta) = getRecords(array(
'tableName' => 'products',
'where' => 'products.num =' . getNumberFromEndOfUrl(),
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
'leftJoin' => array('faqs' => 'title', 'testimonials' => 'title'),
//'debugSql' => true,
));
$products = @$products[0];

I just downloaded and run an upgrade on one of my test servers and it all run well on the upgrade

There are some small issues with the layout that i will email over with screen shots when i get a chance to look over everything.

that worked great cheers.

yer i have tried that the issue is that it removes the first <p> tag which is great BUT because when you put a line break in WYSIWYG in the source code it dosnt put the class of the <p> tag

eg the first P tag and all P in the div should be <p class="text"> content goes in here </p> and then the next P should be the same.

i have section that stores testimonials and the issue is that after every 2nd record i need to add a class to the div class. on the Div <div class="one_half  animate" data-anim-type="fadeInLeft" data-anim-delay="100"> i need to add on the class so it is bold text to the right after the 2nd record so record 1 dosnt have it but the 2nd record does. <div class="one_half  last animate" data-anim-type="fadeInLeft" data-anim-delay="100">

                <?php foreach ($testimonials_listPages as $record): ?>
                <div class="one_half  animate" data-anim-type="fadeInLeft" data-anim-delay="100">
                    <div class="box">" <?php echo textLimitTestimonials ($record['content'], 300) ?><br>
                        <a href="<?php echo $record['_link'] ?>" class="button eleven">..read more</a>
                    </div>
                    
                    <div class="who">
                    
                        <?php foreach ($record['logo'] as $index => $upload): ?>
                        <img src="<?php echo $upload['thumbUrlPath'] ?>" alt="<?php echo htmlencode($record['title']) ?>" title="<?php echo htmlencode($record['title']) ?>"/>
                        <?php endforeach ?>
                        <strong><?php echo htmlencode($record['title']) ?></strong>
                        
                    </div>
                </div>
                <?php endforeach ?>

I have this text block

<p class="text"><?php echo ($record['content']) ?></p>

but i need to remove all the <p> </p> tags from the statement inside the content, it is using WYSIWYG and i cant change it to text block because it needs to be able to bold font and underline and so on.

i have this code that checks if i website is alive or not i need this for some google functions for google tag manager but how can i put the url inside the current php code.

This is the code that checks the url is alive how can i place this inside the $url = <?php echo htmlencode($record['url']) ?>

<?php
$url = 'THIS IS WHRE THE URL GOES';
$array = get_headers($url);
$string = $array[0];
if(strpos($string,"200")) {
    echo '<span style="color:#7cdefe; font-weight: bold">Active</span>';
} else {
    echo '<span style="color:#ff0000; font-weight: bold">Not Active</span>';
}
?>

that was perfect and works great cheers.

no errors loading and the standard map pin icons are loading perfect 

mmm have never needed to do that before every other single time it has worked as per what I have on every other single install why would it change all of a sudden and the other sites are still working ok

am having some issues trying to get the active classes set on a record when it is active in the slider function here is the html code i have and also the output from the cmsb.

I only need to display the <?php echo $record['content']; ?> inside the carousel inner function

  // load records from 'testimonials'
  list($testimonialsRecords, $testimonialsMetaData) = getRecords(array(
    'tableName'   => 'testimonials',
    'perPage'     => '1',
    'orderBy'     => 'RAND()',
    'loadUploads' => false,
    'allowSearch' => false,
  ));

    <?php foreach ($testimonialsRecords as $record): ?>
      Record Number: <?php echo htmlencode($record['num']) ?><br/>
      Class (value): <?php echo $record['class'] ?><br/>
      Class (label): <?php echo $record['class:label'] ?><br/>
      First (value): <?php echo $record['first'] ?><br/>
      First (label): <?php echo $record['first:label'] ?><br/>
      Title: <?php echo htmlencode($record['title']) ?><br/>
      Content: <?php echo $record['content']; ?><br/>
      Youtube: <?php echo htmlencode($record['youtube']) ?><br/>
      Youtube ID: <?php echo htmlencode($record['youtube_id']) ?><br/>
      _link : <a href="<?php echo $record['_link'] ?>"><?php echo $record['_link'] ?></a><br/>
      <hr/>
    <?php endforeach ?>

                        <div id="home_testimonial" class="carousel slide" data-ride="carousel">
                            <!-- Indicators -->
                            <ol class="carousel-indicators">
                                <li data-target="#home_testimonial" data-slide-to="0" class="active"></li>
                                <li data-target="#home_testimonial" data-slide-to="1"></li>
                                <li data-target="#home_testimonial" data-slide-to="2"></li>
                                <li data-target="#home_testimonial" data-slide-to="3"></li>
                            </ol>
                            
                            <!-- Wrapper for slides -->
                            <div class="carousel-inner">
                                <div class="item active">
                                    <p>"Claritas est etiam processus dynamicus, qui sequitur mutationem consuetudium lectorum. Mirum est notare quam littera gothica, quam nunc putamus parum claram, anteposuerit litterarum."</p>
                                </div>
                                <div class="item">
                                    <p>"Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui."</p>
                                </div>
                                <div class="item">
                                    <p>"Claritas est etiam processus dynamicus, qui sequitur mutationem consuetudium lectorum. Mirum est notare quam littera gothica, quam nunc putamus parum claram, anteposuerit litterarum."</p>
                                </div>
                                <div class="item">
                                    <p>"Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui."</p>
                                </div>
                            </div>
                        </div>