function seochecklist_update_6001 in SEO Checklist 6.3

Same name and namespace in other branches

1. 6.2 seochecklist.install \seochecklist_update_6001()
2. 7.3 seochecklist.install \seochecklist_update_6001()

Update from 6.x-1.x to 6.x-2.x.

File

./seochecklist.install, line 71

Install, update and uninstall functions for the seochecklist module.

Code

function seochecklist_update_6001() {
  $ret = array();
  $query = db_query("SELECT linked_seo FROM {seo_checklist} ORDER BY id DESC LIMIT 1");
  $result = db_fetch_object($query);
  variable_set('seo_checklist_link', intval($result->linked_seo));
  $query = db_query("SELECT extra2, extra3 FROM {seo_checklist} WHERE id = 1");
  $result = db_fetch_object($query);
  variable_set('seo_checklist_thanks', intval($result->extra2));
  variable_set('seo_checklist_podcast', intval($result->extra3));
  db_drop_field($ret, 'seo_checklist', 'extra2');
  db_drop_field($ret, 'seo_checklist', 'extra3');
  db_drop_field($ret, 'seo_checklist', 'linked_seo');
  db_drop_field($ret, 'seo_group', 'subgroup');
  db_drop_table($ret, 'seo_subgroup');
  return $ret;
}