<?php
require '/var/www/clients/client2/web20/web/wp-load.php';
global $wpdb;

$max_len = 155;

$rows = $wpdb->get_results("
    SELECT pm.meta_id, pm.post_id, pm.meta_value as description, p.post_type, p.post_name,
           CHAR_LENGTH(pm.meta_value) as len
    FROM {$wpdb->postmeta} pm
    JOIN {$wpdb->posts} p ON pm.post_id = p.ID
    WHERE pm.meta_key = '_dgt_meta_description'
    AND CHAR_LENGTH(pm.meta_value) > {$max_len}
    AND p.post_status = 'publish'
    ORDER BY len DESC
");

$updated = 0;
foreach ($rows as $r) {
    $desc = $r->description;
    $short = mb_substr($desc, 0, $max_len);
    $last = mb_strrpos($short, '.');
    if ($last && $last > 100) {
        $short = mb_substr($short, 0, $last + 1);
    } else {
        $last = mb_strrpos($short, ',');
        if ($last && $last > 100) {
            $short = mb_substr($short, 0, $last);
            $short .= '.';
        } else {
            $last = mb_strrpos($short, ' ');
            if ($last > 80) {
                $short = mb_substr($short, 0, $last);
            }
            $short = rtrim($short, ' -–,;:/&') . '.';
        }
    }

    $final_len = mb_strlen($short);
    if ($final_len > 160) {
        $short = mb_substr($short, 0, 155);
        $ls = mb_strrpos($short, ' ');
        if ($ls > 100) $short = mb_substr($short, 0, $ls);
        $short = rtrim($short, ' -–,;:/&.') . '.';
    }

    $wpdb->update($wpdb->postmeta, array('meta_value' => $short), array('meta_id' => $r->meta_id));
    $updated++;
    echo mb_strlen($short) . " | {$r->post_name} | {$short}\n";
}

echo "\nShortened $updated descriptions\n";