function money_update_6000 in Money field 6

Update all money fields to reflect the new Views integration feature.

References: http://drupal.org/node/131953 (CCK feature request) http://drupal.org/node/335546 (Money CCK field task)

File

./money.install, line 88

Module installation/uninstallation hooks.

Code

function money_update_6000() {
  drupal_load('module', 'content');
  if ($abort = content_check_update('money')) {
    return $abort;
  }
  $ret = array();
  $result = db_query("SELECT field_name, db_columns FROM {content_node_field} WHERE type = 'money'");
  while ($field = db_fetch_object($result)) {
    $db_columns = unserialize($field->db_columns);
    if (empty($db_columns['amount']['views'])) {
      $db_columns['amount']['views'] = TRUE;
      $db_columns['currency']['views'] = TRUE;
      $success = db_query("UPDATE {content_node_field} SET db_columns = '%s' WHERE field_name = '%s'", serialize($db_columns), $field->field_name);
      $ret[] = array(
        'success' => $success !== FALSE,
        'query' => strtr('Updating definition of the Money CCK field: %field-name.', array(
          '%field-name' => $field->field_name,
        )),
      );
    }
  }
  if (!empty($ret)) {
    content_clear_type_cache();
  }
  return $ret;
}