[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id: site_verify.install,v 1.10.2.1 2010/02/04 04:50:37 davereid Exp $
   3  
   4  /**
   5   * @file
   6   * Install, update and uninstall functions for the site_verify module.
   7   */
   8  
   9  /**
  10   * Implements hook_scheam().
  11   */
  12  function site_verify_schema() {
  13    $schema['site_verify'] = array(
  14      'description' => '',
  15      'fields' => array(
  16        'svid' => array(
  17          'type' => 'serial',
  18          'unsigned' => TRUE,
  19          'not null' => TRUE,
  20          'description' => 'Primary Key: Unique site verification ID.',
  21        ),
  22        'engine' => array(
  23          'type' => 'varchar',
  24          'length' => 32,
  25          'not null' => TRUE,
  26          'default' => '',
  27          'description' => '',
  28        ),
  29        'file' => array(
  30          'type' => 'varchar',
  31          'length' => 255,
  32          'default' => '',
  33          'description' => '',
  34        ),
  35        'file_contents' => array(
  36          'type' => 'text',
  37          'not null' => TRUE,
  38          'size' => 'big',
  39          'description' => '',
  40        ),
  41        'meta' => array(
  42          'type' => 'text',
  43          'not null' => TRUE,
  44          'description' => '',
  45        ),
  46      ),
  47      'primary key' => array('svid'),
  48      'indexes' => array(
  49        'engine' => array('engine'),
  50      ),
  51    );
  52  
  53    return $schema;
  54  }
  55  
  56  /**
  57   * Implements hook_install().
  58   */
  59  function site_verify_install() {
  60    // Add tables.
  61    drupal_install_schema('site_verify');
  62  
  63    // Import data from deprecated modules.
  64    $ret = array();
  65    site_verify_import_xmlsitemap($ret);
  66    site_verify_import_ghs($ret);
  67  }
  68  
  69  /**
  70   * Implements hook_uninstall().
  71   */
  72  function site_verify_uninstall() {
  73    // Remove tables.
  74    drupal_uninstall_schema('site_verify');
  75  }
  76  
  77  function site_verify_update_1() {
  78    $ret = array();
  79    db_drop_unique_key($ret, 'site_verify', 'file');
  80    return $ret;
  81  }
  82  
  83  function site_verify_update_2() {
  84    $ret = array();
  85    $ret[] = update_sql("UPDATE {site_verify} SET engine = 'bing' WHERE engine = 'live_search'");
  86    return $ret;
  87  }
  88  
  89  function site_verify_update_3() {
  90    $ret = array();
  91    site_verify_import_xmlsitemap($ret);
  92    site_verify_import_ghs($ret);
  93    return $ret;
  94  }
  95  
  96  /**
  97   * Import data from XML sitemap engines.
  98   */
  99  function site_verify_import_xmlsitemap(&$ret) {
 100    $engines = array('google', 'bing', 'yahoo');
 101    foreach ($engines as $engine) {
 102      if ($file = db_escape_string(variable_get('xmlsitemap_engines_' . $engine . '_verify', ''))) {
 103        if (!db_result(db_query("SELECT 1 FROM {site_verify} WHERE engine = '%s' AND file <> '$file'", $engine))) {
 104          $file_content = db_escape_string(variable_get('xmlsitemap_engines_' . $engine . '_verify_string', ''));
 105          $ret[] = update_sql("INSERT INTO {site_verify} (engine, file, file_contents, meta) VALUES ('$engine', '$file', '$file_content', '')");
 106        }
 107      }
 108      variable_del('xmlsitemap_engines_' . $engine . '_verify');
 109      variable_del('xmlsitemap_engines_' . $engine . '_verify_string');
 110    }
 111  }
 112  
 113  /**
 114   * Import data from Google Apps Verification.
 115   */
 116  function site_verify_import_ghs(&$ret) {
 117    if (!db_result(db_query("SELECT 1 FROM {site_verify} WHERE engine = 'google' AND file <> 'googlehostedservice.html'"))) {
 118      if ($google_content = db_escape_string(variable_get('ghs_string_verify', ''))) {
 119        $ret[] = update_sql("INSERT INTO {site_verify} (engine, file, file_contents, meta) VALUES ('google', 'googlehostedservice.html', '$google_content', '')");
 120      }
 121    }
 122    variable_del('ghs_string_verify');
 123  }