$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;