function quicktabs_update_7200

Update to Drupal 7.

File

./quicktabs.install, line 82

Code

function quicktabs_update_7200() {
    // If upgrading from 6.x-2.x, we will need to convert all QT instances to the
    // new schema. 6.x-3.x will already be converted.
    if (db_field_exists('quicktabs', 'machine_name')) {
        return t('No updates necessary');
    }
    // Pull all existing quicktabs, and then delete existing quicktabs. We will reinsert.
    $result = db_query("SELECT * FROM {quicktabs}");
    if (!db_query("DELETE FROM {quicktabs}")) {
        throw new DrupalUpdateException(t('Could not complete the update.'));
    }
    db_drop_field('quicktabs', 'qtid');
    $new_field = array(
        'description' => 'The primary identifier for a qt block.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
    );
    db_add_field('quicktabs', 'machine_name', $new_field);
    db_add_primary_key('quicktabs', array(
        'machine_name',
    ));
    $output = $used = array();
    foreach ($result as $qt) {
        $row = (array) $qt;
        // Generate a machine-readable string
        $qt_name = strtolower(preg_replace('/[^a-zA-Z0-9_]+/', '_', $row['title']));
        $i = 0;
        while (in_array($i == 0 ? $qt_name : "{$qt_name}_{$i}", $used)) {
            $i++;
        }
        $row['machine_name'] = $used[] = $i == 0 ? $qt_name : "{$qt_name}_{$i}";
        unset($row['qtid']);
        $placeholders = implode(', ', array_keys($row));
        $values = array();
        // Ugh - really?? Somebody tell me there's a better way to do this :-/
        foreach ($row as $name => $value) {
            $values[':' . $name] = $value;
        }
        $tokens = implode(', ', array_keys($values));
        db_query("INSERT INTO {quicktabs} ({$placeholders}) VALUES({$tokens})", $values);
        $output[] = "Converted quicktab {$row['machine_name']}.";
    }
    return implode('<br />', $output);
}