diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-11-24 14:59:26 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-11-24 14:59:26 +0000 |
| commit | d529f78adb85698c9382ad29e4583f309eaf850a (patch) | |
| tree | 58f973b636dac28e93c10274fc58b3bff777afc8 /phpBB/install/database_update.php | |
| parent | a0c3a326bd0e0162217589c57af90e7b477e4e88 (diff) | |
| download | forums-d529f78adb85698c9382ad29e4583f309eaf850a.tar forums-d529f78adb85698c9382ad29e4583f309eaf850a.tar.gz forums-d529f78adb85698c9382ad29e4583f309eaf850a.tar.bz2 forums-d529f78adb85698c9382ad29e4583f309eaf850a.tar.xz forums-d529f78adb85698c9382ad29e4583f309eaf850a.zip | |
rather large update, most important things done:
- implemented provided patch/diff file for bug #5350 (Highway of Life) with some tiny changes and alterations
- more username/colour changes/fixes
- added a note about PM rule-dependant message removals so the user is not wondering too much if he can't remember his rules. :)
- some column changes to fix unicode issues
- bugfixes
git-svn-id: file:///svn/phpbb/trunk@6650 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/database_update.php')
| -rw-r--r-- | phpBB/install/database_update.php | 37 |
1 files changed, 28 insertions, 9 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 6c03697e52..25ed12b824 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -289,13 +289,19 @@ $database_update_info = array( BBCODES_TABLE => array( 'bbcode_helpline' => array('VCHAR_UNI', ''), ), + USERS_TABLE => array( + 'user_occ' => array('TEXT_UNI', ''), + ), + CONFIG_TABLE => array( + 'config_value' => array('VCHAR_UNI', ''), + ), ), - /* Add the following columns + // Add the following columns 'add_columns' => array( - {table} => array( - {column_name} => array('USINT', 0), -> column type + GROUPS_TABLE => array( + 'group_founder_manage' => array('BOOL', 0), ), - ),*/ + ), ), // Latest version '3.0.b4-dev' => array(), @@ -448,13 +454,26 @@ $errored = $no_updates = false; flush(); +// some code magic switch ($current_version) { case '3.0.b3': -/* - some code magic -*/ - // No need to change here, before no break should appear + // Set group_founder_manage for administrators group + $sql = 'SELECT group_id + FROM ' . GROUPS_TABLE . " + WHERE group_name = 'ADMINISTRATORS' + AND group_type = " . GROUP_SPECIAL; + $result = $db->sql_query($sql); + $group_id = (int) $db->sql_fetchfield('group_id'); + $db->sql_freeresult($result); + + if ($group_id) + { + $sql = 'UPDATE ' . GROUPS_TABLE . ' SET group_founder_manage = 1 WHERE group_id = ' . $group_id; + _sql($sql, $errored, $error_ary); + } + + // No need to change here. Before this line, no break should appear break; case '3.0.b4-dev': @@ -628,7 +647,7 @@ function column_exists($dbms, $table, $column_name) } /** -* Function to prepare some column informations for better usage +* Function to prepare some column information for better usage */ function prepare_column_data($dbms, $column_data) { |