function styles_update_7215 in Styles 7.2

Delete duplicate entries from the styles table.

File

./styles.install, line 357

Install, update and uninstall functions for the Styles module.

Code

function styles_update_7215() {
  $names = db_query("SELECT name FROM {styles} GROUP BY name HAVING COUNT(*) > 1")
    ->fetchCol();
  foreach ($names as $name) {
    $sids = db_select('styles')
      ->fields('styles', array(
      'sid',
      'name',
    ))
      ->condition('name', $name)
      ->orderBy('sid', 'DESC')
      ->execute()
      ->fetchCol();
    array_shift($sids);
    foreach ($sids as $sid) {
      db_delete('styles')
        ->condition('sid', $sid)
        ->execute();
    }
  }
}