/** fM v2.0 **/ function fmUpgrade_200($database) { global $fmdb, $fm_name; $success = true; /** Prereq */ $success = $GLOBALS['running_db_version'] < 37 ? fmUpgrade_2002($database) : true; if ($success) { if (!setOption('ssh_user', 'fm_user', 'auto', true, $_SESSION['user']['account_id'])) { return false; } if ($pw_strength = getOption('auth_fm_pw_strength')) { if (!setOption('auth_fm_pw_strength', ucfirst($pw_strength))) { return false; } } $table[] = "DELETE FROM {$database}.`fm_options` WHERE option_name='fm_user_caps'"; /** Create table schema */ if (count($table) && $table[0]) { foreach ($table as $schema) { $fmdb->query($schema); if (!$fmdb->result || $fmdb->sql_errors) { return false; } } } } upgradeConfig('fm_db_version', 42, false); return $success; }
/** fM v2.1-beta1 **/ function fmUpgrade_2101($database) { global $fmdb, $fm_name; $success = true; /** Prereq */ $success = $GLOBALS['running_db_version'] < 42 ? fmUpgrade_200($database) : true; if ($success) { $table[] = "CREATE TABLE IF NOT EXISTS {$database}.`fm_groups` (\n `group_id` int(11) NOT NULL AUTO_INCREMENT,\n `account_id` int(11) NOT NULL DEFAULT '1',\n `group_name` varchar(128) NOT NULL,\n `group_caps` text,\n `group_comment` text,\n `group_status` enum('active','disabled','deleted') NOT NULL DEFAULT 'active',\n PRIMARY KEY (`group_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $table[] = "ALTER TABLE {$database}.`fm_users` ADD `user_group` INT(11) DEFAULT NULL AFTER `user_email`"; /** Create table schema */ if (count($table) && $table[0]) { foreach ($table as $schema) { $fmdb->query($schema); if (!$fmdb->result || $fmdb->sql_errors) { return false; } } } } upgradeConfig('fm_db_version', 43, false); return $success; }