/** 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;
}
