function quicktabs_update_7300

Same name in other branches

1. 8.x-1.x quicktabs.install \quicktabs_update_7300()

Update to 7.x-3.x

File

./quicktabs.install, line 97

Code

function quicktabs_update_7300() {
    $output = array();
    if (!db_field_exists('quicktabs', 'renderer')) {
        // Add the renderer field
        $renderer_field = array(
            'description' => 'The rendering mechanism.',
            'type' => 'varchar',
            'length' => 255,
            'not null' => TRUE,
            'default' => 'quicktabs',
        );
        db_add_field('quicktabs', 'renderer', $renderer_field);
        $output[] = "Added the renderer field";
    }
    if (!db_field_exists('quicktabs', 'machine_name')) {
        // 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');
        $name_field = array(
            'description' => 'The primary identifier for a qt block.',
            'type' => 'varchar',
            'length' => 255,
            'not null' => TRUE,
        );
        db_add_field('quicktabs', 'machine_name', $name_field);
        db_add_primary_key('quicktabs', array(
            'machine_name',
        ));
        $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']);
            $row['style'] = '';
            $row['renderer'] = 'tabs';
            $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);
}