function fontyourface_update_6200 in @font-your-face 7

Same name and namespace in other branches

1. 6.2 fontyourface.install \fontyourface_update_6200()

Implements hook_update_N().

File

./fontyourface.install, line 182

Adds fontyourface tables for tracking fonts.

Code

function fontyourface_update_6200() {

  // Get old fonts
  $old_fonts = array();
  $old_fonts_sql = 'SELECT * FROM {fontyourface}';
  $old_font_results = db_query($old_fonts_sql);
  while ($old_font = db_fetch_object($old_font_results)) {
    $old_fonts[] = $old_font;
  }

  // while
  // Drop old table.
  db_drop_table('fontyourface');

  // Drop provider tables from old version (may not all be there).
  $ignore = array();
  db_drop_table('fontsquirrel_group');
  db_drop_table('kernest');
  db_drop_table('typekit_api_variant');

  // Import from any used providers.
  $used_providers = array();
  foreach ($old_fonts as $old_font) {
    $used_providers[$old_font->provider] = TRUE;
  }

  // foreach
  foreach ($used_providers as $used_provider) {
    $import_function = $used_provider . '_fontyourface_import';
    if (function_exists($import_function)) {
      $import_function();
    }

    // if
  }

  // foreach
  // Add tables.
  $schema = fontyourface_6200_schema();
  db_create_table('fontyourface_font', $schema['fontyourface_font']);
  db_create_table('fontyourface_tag', $schema['fontyourface_tag']);
  db_create_table('fontyourface_tag_font', $schema['fontyourface_tag_font']);

  // Re-enable fonts.
  foreach ($old_fonts as $old_font) {
    $new_fonts = fontyourface_get_fonts("provider = '" . $old_font->provider . "' AND name = '" . $old_font->name . "'");
    if (count($new_fonts) > 0) {
      $new_font = $new_fonts[0];
      fontyourface_enable_font($new_font);
      fontyourface_set_css_selector($new_font, $old_font->css);
    }

    // if
  }

  // foreach
  return t('Updated @font-your-face.');
}