diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-02-27 00:12:18 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-02-27 00:12:18 +0100 |
| commit | d61eb95b4868377cfc2a7a98b03a7d908418b1af (patch) | |
| tree | 9be71ad379caa2db797d9a6200a074ccf12ff28d /phpBB | |
| parent | ba97303a60342bdb54979223cc6d18e815a70d90 (diff) | |
| download | forums-d61eb95b4868377cfc2a7a98b03a7d908418b1af.tar forums-d61eb95b4868377cfc2a7a98b03a7d908418b1af.tar.gz forums-d61eb95b4868377cfc2a7a98b03a7d908418b1af.tar.bz2 forums-d61eb95b4868377cfc2a7a98b03a7d908418b1af.tar.xz forums-d61eb95b4868377cfc2a7a98b03a7d908418b1af.zip | |
[ticket/10411] Revert database_update.php changes from for easier update
Revert the changes from 8fc022033a16b50aa07d06af8dc2a2508f0d94a6
* [ticket/10411] Update schema and fix database update
The database changes will be added as a migration in the next step
PHPBB3-10411
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/install/database_update.php | 52 |
1 files changed, 16 insertions, 36 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 8592b03be7..0a065573bf 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -1165,18 +1165,11 @@ function database_update_info() 'ext_name' => array('UNIQUE', 'ext_name'), ), ), - TEAMPAGE_TABLE => array( - 'COLUMNS' => array( - 'teampage_id' => array('UINT', NULL, 'auto_increment'), - 'group_id' => array('UINT', 0), - 'teampage_name' => array('VCHAR_UNI:255', ''), - 'teampage_position' => array('UINT', 0), - 'teampage_parent' => array('UINT', 0), - ), - 'PRIMARY_KEY' => 'teampage_id', - ), ), 'add_columns' => array( + GROUPS_TABLE => array( + 'group_teampage' => array('UINT', 0, 'after' => 'group_legend'), + ), PROFILE_FIELDS_TABLE => array( 'field_show_on_pm' => array('BOOL', 0), ), @@ -2482,39 +2475,26 @@ function change_database_data(&$no_updates, $version) set_config('use_system_cron', 0); } - $sql = 'SELECT teampage_id - FROM ' . TEAMPAGE_TABLE; + $sql = 'SELECT group_teampage + FROM ' . GROUPS_TABLE . ' + WHERE group_teampage > 0'; $result = $db->sql_query_limit($sql, 1); - $added_groups_teampage = (bool) $db->sql_fetchfield('teampage_id'); + $added_groups_teampage = (bool) $db->sql_fetchfield('group_teampage'); $db->sql_freeresult($result); if (!$added_groups_teampage) { - $sql = 'SELECT * - FROM ' . GROUPS_TABLE . ' + $sql = 'UPDATE ' . GROUPS_TABLE . ' + SET group_teampage = 1 WHERE group_type = ' . GROUP_SPECIAL . " - AND (group_name = 'ADMINISTRATORS' - OR group_name = 'GLOBAL_MODERATORS') - ORDER BY group_name ASC"; - $result = $db->sql_query($sql); - - $teampage_entries = array(); - while ($row = $db->sql_fetchrow($result)) - { - $teampage_entries[] = array( - 'group_id' => (int) $row['group_id'], - 'teampage_name' => '', - 'teampage_position' => sizeof($teampage_entries) + 1, - 'teampage_parent' => 0, - ); - } - $db->sql_freeresult($result); + AND group_name = 'ADMINISTRATORS'"; + _sql($sql, $errored, $error_ary); - if (sizeof($teampage_entries)) - { - $db->sql_multi_insert(TEAMPAGE_TABLE, $teampage_entries); - } - unset($teampage_entries); + $sql = 'UPDATE ' . GROUPS_TABLE . ' + SET group_teampage = 2 + WHERE group_type = ' . GROUP_SPECIAL . " + AND group_name = 'GLOBAL_MODERATORS'"; + _sql($sql, $errored, $error_ary); } if (!isset($config['legend_sort_groupname'])) |