function mailhandler_update_7203 in Mailhandler 7.2

Move human-readable mailbox name into separate field.

File

./mailhandler.install, line 150

Install, update and uninstall functions for the Mailhandler module.

Code

function mailhandler_update_7203() {
  $table = 'mailhandler_mailbox';
  $field = 'admin_title';
  if (!db_field_exists($table, $field)) {
    db_add_field($table, $field, array(
      'type' => 'varchar',
      'length' => '255',
      'description' => 'Human-readable name (email address) of this mailbox.',
    ));
    $result = db_query('SELECT * FROM {mailhandler_mailbox}');
    while ($row = $result
      ->fetchAssoc()) {
      $row['settings'] = unserialize($row['settings']);
      $row['admin_title'] = $row['settings']['mail'];
      unset($row['settings']['mail']);
      db_update('mailhandler_mailbox')
        ->fields(array(
        'admin_title' => $row['admin_title'],
        'settings' => serialize($row['settings']),
      ))
        ->condition('mid', $row['mid'])
        ->execute();
    }
  }
}