condition('name', db_like('sharethis_') . '%', 'LIKE')->execute(); cache_clear_all('variables', 'cache'); } /** * Remove the custom ShareThis table. */ function sharethis_update_7001() { // Move from the st_table to the variables table. if (db_table_exists('st_table')) { // Select all options in the ShareThis table. $result = db_select('st_table', 's')->fields('s', array('st_option', 'st_value'))->execute(); while ($record = $result->fetchAssoc()) { // Variable name switches. publisherID stays the same. switch ($record['st_option']) { case 'buttons': $record['st_option'] = 'button_option'; break; case 'nodeType': $record['st_option'] = 'node_option'; break; case 'services': $record['st_option'] = 'service_option'; break; case 'viewMode': $record['st_option'] = 'teaser_option'; break; case 'widget': $record['st_option'] = 'widget_option'; break; } // Prefix the option with a "sharethis_" namespace. variable_set('sharethis_' . $record['st_option'], $record['st_value']); } // Now that our settings are in the variables table, safely drop the table. db_drop_table('st_table'); // Return a success message. return t('Switched from the custom ShareThis table to the Variables table.'); } }