MODX utility snippet: replace absolute formed links in site content eg www.xxx.com/99 -> [[~99]] note: backing up modx_site_content table is a good idea before running this :) (original author: BobRay)

modx-content-search-and-replace.php

<?php
$docs = $modx->getCollection('modDocument');
 
$pattern = '/www.xxx.com/(\d+)/';
$replacement = '[[~$1]]';
$count = 0;
 
foreach ($docs as $doc)  {
   $content = $doc->getContent();
   $hash1 = sha1($content);
   $content = preg_replace($pattern, $replacement, $content);
   $hash2 = sha1($content);
 
   if ($hash1 === $hash2) { /* no change */.
       continue;
   }
   $doc->setContent($content);
   $doc->save();
   $count++;
}
 
return 'Modified ' . $count . ' Resources'