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

// Product meta titles and descriptions
$products = $wpdb->get_results("SELECT ID, post_title, post_name, post_content FROM {$wpdb->posts} WHERE post_type='dgt_product' AND post_status='publish'");
$updated = 0;

foreach ($products as $p) {
    $name = $p->post_title;
    $current_title = get_post_meta($p->ID, '_dgt_meta_title', true);
    $current_desc = get_post_meta($p->ID, '_dgt_meta_description', true);
    $current_kw = get_post_meta($p->ID, '_dgt_meta_keywords', true);
    
    if ($current_title && $current_desc && $current_kw) continue;
    
    // Determine substance from product name
    $substances = array();
    $test_type = 'Drogentest';
    
    if (stripos($name, 'THC') !== false || stripos($name, 'Marihuana') !== false || stripos($name, 'Cannabis') !== false) $substances[] = 'THC';
    if (stripos($name, 'AMP') !== false || stripos($name, 'Amphetamin') !== false) $substances[] = 'Amphetamin';
    if (stripos($name, 'COC') !== false || stripos($name, 'Kokain') !== false) $substances[] = 'Kokain';
    if (stripos($name, 'MDMA') !== false || stripos($name, 'Ecstasy') !== false) $substances[] = 'MDMA';
    if (stripos($name, 'MOR') !== false || stripos($name, 'Opiat') !== false) $substances[] = 'Opiate';
    if (stripos($name, 'Multi') !== false) $test_type = 'Multi-Drogentest';
    if (stripos($name, 'Teststreifen') !== false) $test_type .= ' Teststreifen';
    elseif (stripos($name, 'Testkassette') !== false || stripos($name, 'Testkas') !== false) $test_type .= ' Testkassette';
    elseif (stripos($name, 'Tauchtest') !== false) $test_type .= ' Tauchtest';
    
    $sub_str = !empty($substances) ? implode(', ', array_slice($substances, 0, 3)) : '';
    
    // Generate title
    if (empty($current_title)) {
        $new_title = $name . ' kaufen';
        if (mb_strlen($new_title) > 60) {
            // Shorten: remove " 1 St." suffix and PZN-like numbers
            $short = preg_replace('/\s+\d+\s*St\.?$/i', '', $name);
            $new_title = $short . ' kaufen';
        }
        if (mb_strlen($new_title) > 60) {
            $new_title = mb_substr($name, 0, 53) . ' kaufen';
        }
        update_post_meta($p->ID, '_dgt_meta_title', $new_title);
    }
    
    // Generate description
    if (empty($current_desc)) {
        if ($sub_str) {
            $new_desc = $name . ': ' . $sub_str . ' schnell und zuverlässig nachweisen. Einfache Anwendung, diskreter Versand, Ergebnis in Minuten.';
        } else {
            $new_desc = $name . ' für die Heimanwendung: schnell, zuverlässig, diskret. Einfacher Drogentest mit Ergebnis in wenigen Minuten.';
        }
        if (mb_strlen($new_desc) > 155) {
            $short = preg_replace('/\s+\d+\s*St\.?$/i', '', $name);
            $new_desc = $short . ': schnell und zuverlässig testen. Einfache Anwendung, Ergebnis in Minuten. Diskreter Versand.';
        }
        if (mb_strlen($new_desc) > 155) {
            $new_desc = mb_substr($name, 0, 60) . ': zuverlässiger Drogentest für zuhause. Ergebnis in Minuten, diskreter Versand.';
        }
        update_post_meta($p->ID, '_dgt_meta_description', $new_desc);
    }
    
    // Generate keywords
    if (empty($current_kw)) {
        $kw_parts = array('Drogentest kaufen');
        if ($sub_str) {
            foreach ($substances as $s) $kw_parts[] = $s . ' Test';
        }
        $kw_parts[] = 'Drogentest';
        $kw_parts[] = 'Schnelltest';
        if (stripos($name, 'Multi') !== false) $kw_parts[] = 'Multi-Drogentest';
        update_post_meta($p->ID, '_dgt_meta_keywords', implode(', ', $kw_parts));
    }
    
    $updated++;
    echo "PRODUCT: $name\n";
    echo "  Title: " . (get_post_meta($p->ID, '_dgt_meta_title', true)) . "\n";
    echo "  Desc (" . mb_strlen(get_post_meta($p->ID, '_dgt_meta_description', true)) . "): " . mb_substr(get_post_meta($p->ID, '_dgt_meta_description', true), 0, 80) . "...\n\n";
}

echo "Products updated: $updated\n";