// No breaks
// Update to 0.7.0
// No breaks
// Update to 0.7.0
case '0.3.1':
// Lets change our test_enable to false
$umil->config_update('test_enable', false);
// Lets remove some of those permission settings we added before
$umil->permission_remove(array(array('f_test_mod', false), array('u_test_mod', true)));
// Now to add a table (this uses the layout from develop/create_schema_files.php and from phpbb_db_tools)
$umil->table_add('phpbb_test', array('COLUMNS' => array('test_id' => array('UINT', NULL, 'auto_increment'), 'test_text' => array('VCHAR_UNI', ''), 'test_bool' => array('BOOL', 0)), 'PRIMARY_KEY' => 'test_id', 'KEYS' => array('test_bool' => array('INDEX', 'test_bool'))));
// Update to 0.9.0
// Update to 0.9.0
case '0.7.0':
// Lets add a new column to the phpbb_test table named test_time
$umil->table_column_add('phpbb_test', 'test_time', array('TIMESTAMP', 0));
// Lets make the test_time column we just added an index
$umil->table_index_add('phpbb_test', 'test_time', 'test_time');
// Alright, now lets add some modules to the ACP
$umil->module_add(array(array('acp', 'ACP_CAT_DOT_MODS', 'ACP_CAT_TEST_MOD'), array('acp', 'ACP_CAT_TEST_MOD', array('module_basename' => 'board', 'modes' => array('settings', 'features'))), array('acp', 'ACP_CAT_TEST_MOD', array('module_basename' => 'board', 'module_langname' => 'ACP_AVATAR_SETTINGS', 'module_mode' => 'avatar', 'module_auth' => 'acl_a_board'))));
// Update to 0.9.1
// Update to 0.9.1
case '0.9.0':
// This is done in the custom function from umil_auto_example
$sql_ary = array('test_text' => 'This is a test message.', 'test_bool' => 1, 'test_time' => time());
$sql = 'INSERT INTO ' . $table_prefix . 'test ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
// Update to 1.0.0
// Update to 1.0.0
case '0.9.1':
}
}
trigger_error('NOT_AUTHORISED');
}
if (!class_exists('umil')) {
include $phpbb_root_path . 'umil/umil.' . $phpEx;
}
$umil = new umil(true);
$mod = array('name' => 'Legend Repositioning', 'version' => '1.0.3', 'config' => 'legend_repositioning_version', 'enable' => 'legend_repositioning_enable');
if (confirm_box(true)) {
// Install the base 1.0.3 version
if (!$umil->config_exists($mod['config'])) {
// Lets add a config setting for enabling/disabling the MOD and set it to true
$umil->config_add($mod['enable'], true);
// We must handle the version number ourselves.
$umil->config_add($mod['config'], $mod['version']);
$umil->table_column_add('phpbb_groups', 'group_position', array('UINT', '0'));
// Select all groups that have no set position
$sql = 'SELECT group_id
FROM ' . GROUPS_TABLE . '
WHERE group_position = 0';
$result = $db->sql_query($sql);
// Set default positions for groups (so that all positions are not set to 0)
$group_position = 0;
while ($row = $db->sql_fetchrow($result)) {
$group_position++;
$sql = 'UPDATE ' . GROUPS_TABLE . '
SET group_position = ' . $group_position . '
WHERE group_id = ' . $row['group_id'];
$db->sql_query($sql);
}
$db->sql_freeresult($result);
