[Paul M]

Originally Posted by Psionic Vision

Making a sequential installation with new steps added on top of the first one using the vBulletin framework for doing such is confusing and therefore prone to errors. So I just install new tables on the "if not exists" condition (which does not add too much server load given that a hack is only installed once in a very long time), and then add "on top" modifications every time myself by using is_newer_version(), which I believe is the same thing that vBulletin uses to determine which piece of installation code to execute. So I'm just doing the same thing a little differently than what's designated by vBulletin framework.

JFYI, this query will be run every time as its not inside any of your custom version checks

PHP Code:

// add fields to other tables
$db->query_write("
    ALTER TABLE `" . TABLE_PREFIX . "usergroup`
    ADD `psiwd_options` int(10) unsigned NOT NULL DEFAULT '0'
");