Hidden pages in Permalinks table

Hey Tim,

What code are you using to generate the sitemap? Could you post it here for me? It might be possible to add some code that checks if a particular record in a section is hidden or expired and stop it added.

Cheers,

Greg

Hey Greg.

This is the basic code I use.

<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

// load viewer library
$libraryPath = 'cmsb/lib/viewer_functions.php';
$dirsToCheck = array('/home/xxx/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from '_permalinks'
list($_permalinksRecords, $_permalinksMetaData) = getRecords(array(
'tableName' => '_permalinks',
'orderBy' => '', // use default database order
'loadUploads' => false,
'allowSearch' => false,
));

?>
<?php header('Content-type: application/xml; charset=utf-8'); ?><?php echo '<'.'?xml version="1.0" encoding="UTF-8"?>'; ?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">

<?php foreach ($_permalinksRecords as $record): ?>
<?php if (!$record['old']): ?>
<url>

<loc>http://<?php echo $_SERVER['HTTP_HOST']; ?><?php echo $record['_link'] ?></loc>

<lastmod><?php echo date('Y-m-d', strtotime($record['updatedDate'])) ?></lastmod>

<changefreq>weekly</changefreq>


<priority>0.5</priority>

</url>
<?php endif ?>
<?php endforeach ?>

</urlset>

Thanks Tim, 

I've written some example code that will get a linked record, so that we can check if it's hidden or not:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('C:/wamp/www/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

   // load records from '_permalinks'
  list($_permalinksRecords, $_permalinksMetaData) = getRecords(array(
    'tableName' => '_permalinks',
    'orderBy' => '', // use default database order
    'loadUploads' => false,
    'allowSearch' => false,
  ));
  
?>
<?php header('Content-type: application/xml; charset=utf-8'); ?><?php echo '<'.'?xml version="1.0" encoding="UTF-8"?>'; ?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
  <?php foreach ($_permalinksRecords as $record): ?>
    <?php
      if($record['tableName'] && $record['recordNum']){
        $linkedRecord = mysql_get($record['tableName'], $record['recordNum']);
      }
    ?>
    <?php if (!$record['old'] && !@$linkedRecord['hidden']): ?>
      <url>
        <loc>http://<?php echo $_SERVER['HTTP_HOST']; ?><?php echo $record['_link'] ?></loc>
        <lastmod><?php echo date('Y-m-d', strtotime($record['updatedDate'])) ?></lastmod>
        <changefreq>weekly</changefreq> 
        <priority>0.5</priority>
      </url>
    <?php endif ?> 
  <?php endforeach ?>
</urlset>

So this code works by checking if the table name and record num are set for a permalink, if they are it retrieves the linked record and sets it to the variable $linkedRecord which can then be checked to see if a hidden variable is set.

You could also use the $linkedRecord variable to check if a start and end date are set as well.

Let me know if you have any questions. 

Cheers,

Greg