chamilo-lms2/plugin/vchamilo/views/syncparams.controller.php

<?php

api_protect_admin_script();

$sql = "SELECT * FROM vchamilo";
$result = Database::query($sql);
$vchamilos = Database::store_result($result);

// propagate in all known vchamilos a setting
if ($action == 'syncall') {
    $keys = array_keys($_REQUEST);
    $selection = preg_grep('/sel_.*/', $keys);

    foreach ($selection as $selkey) {
        $settingId = str_replace('sel_', '', $selkey);

        if (!is_numeric($settingId)) {
            continue;
        }

        $value = $_REQUEST[$selkey];

        $setting = api_get_settings_params_simple(array('id' => $settingId));

        $params = array(
            'title' => $setting['title'],
            'variable' => $setting['variable'],
            'subkey' => $setting['subkey'],
            'category' => $setting['category'],
            'access_url' => $setting['access_url'],
        );

        foreach ($vchamilos as $vcid => $chm) {
            $table = $chm['main_database'].".settings_current ";
            $sql = " SELECT * FROM $table 
                     WHERE 
                        variable = '{{$setting['variable']}}' AND 
                        access_url = '{$setting['access_url']}'
                    ";
            $result = Database::query($sql);

            if (Database::num_rows($result)) {
                $sql = "UPDATE $table SET 
                            selected_value = '$value'
                      WHERE id = $settingId";
                Database::query($sql);
            }
            //$DB->set_field('settings_current', 'selected_value', $value, $params, 'id', $chm->main_database);
        }
    }
}

if ($action == 'syncthis') {
    $settingId = isset($_GET['settingid']) ? $_GET['settingid'] : '';

    if (is_numeric($settingId)) {
        $delifempty = isset($_REQUEST['del']) ? $_REQUEST['del'] : '';
        $value = $_REQUEST['value'];
        // Getting the local setting record.
        $setting = api_get_settings_params_simple(array('id' => $settingId));
        $params = array(
            'access_url_changeable' => $setting['access_url_changeable'],
            'title' => $setting['title'],
            'variable' => $setting['variable'],
            'subkey' => $setting['subkey'],
            'category' => $setting['category'],
            'type' => $setting['type'],
            'comment' => $setting['comment'],
            'access_url' => $setting['access_url'],
        );

        $errors = '';
        foreach ($vchamilos as $vcid => $chm) {
            $table = $chm['main_database'].".settings_current";
            if ($delifempty && empty($value)) {
                $sql = "DELETE FROM $table 
                        WHERE  
                            selected_value = '$value' AND   
                            variable = '{{$setting['variable']}}' AND 
                            access_url = '{$setting['access_url']}'
                ";
                Database::query($sql);

                //$res = $DB->delete_records('settings_current', $params, $chm->main_database);
                $case = "delete";
            } else {

                $sql = " SELECT * FROM $table 
                         WHERE 
                            variable = '".$setting['variable']."' AND 
                            access_url = '{$setting['access_url']}'
                        ";
                $result = Database::query($sql);

                if (Database::num_rows($result)) {
                    $sql = "UPDATE $table SET 
                            selected_value = '$value'
                      WHERE id = $settingId";
                    Database::query($sql);
                } else {
                    Database::insert($table, $params, true);
                }
            }
        }
        return $errors;
    } else {
        return "Bad ID. Non numeric";
    }
}

return 0;