function prod_monitor_update_6106 in Production check & Production monitor 6

Add new dbconnect_path setting to database to prevent warnings.

File

prod_monitor/prod_monitor.install, line 303

Code

function prod_monitor_update_6106() {
  $ret = array();
  $table = 'prod_monitor_sites';

  // Fetch all settings.
  $result = db_query("SELECT id, settings FROM {%s}", $table);

  // Update all sites to add new setting.
  while ($site = db_fetch_object($result)) {
    $settings = unserialize($site->settings);
    $settings['dbconnect_path'] = '';
    $site->settings = serialize($settings);

    // Write to DB.
    drupal_write_record($table, $site, array(
      'id',
    ));
  }
  return $ret;
}