#!/usr/bin/php
<?php
// SYNC DISCOVERED METHODS - Toutes les 10 minutes via cron
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$methods = $pdo->query("SELECT DISTINCT send_method FROM admin.brain_configs WHERE send_method IS NOT NULL")->fetchAll(PDO::FETCH_COLUMN);
foreach ($methods as $m) {
    $pdo->query("SELECT update_discovered_method_stats('$m')");
}
echo "[".date('H:i:s')."] Synced ".count($methods)." methods\n";