Чистим контент сайта от Рекламнай Сети Яндекса.

clear.php

<?php
$table = $modx->getTableName('modResource');
$sql = "SELECT id,content FROM {$table};";
$stmt = $modx->prepare($sql);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$sql = '';
$ids = array();

foreach ($rows as $row) {
    $id = $row['id'];
    $content = $row['content'];
    if (preg_match("#<!-- Яндекс.Директ -->#", $content)) {
        $content = preg_replace("#<!-- Яндекс.Директ -->(.*?)</script>#msi", '', $content);
        $sql .= "UPDATE {$table} SET `content` = '{$content}' WHERE `id` = '{$id}';";
        $ids[] = $id;
    }
}
$q = $modx->prepare($sql);
$q->execute();
print_r(count($ids));