diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:39:47 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:39:47 +0000 |
| commit | 1981196e99a84e1ad1f8e817f74bda730ba6fe88 (patch) | |
| tree | 2eb5fe6c8239e8793813e1ab7157eab26c7cd90c /phpBB/adm | |
| parent | 5449c591a9721a63098f794a24e0bcef690ebb51 (diff) | |
| download | forums-1981196e99a84e1ad1f8e817f74bda730ba6fe88.tar forums-1981196e99a84e1ad1f8e817f74bda730ba6fe88.tar.gz forums-1981196e99a84e1ad1f8e817f74bda730ba6fe88.tar.bz2 forums-1981196e99a84e1ad1f8e817f74bda730ba6fe88.tar.xz forums-1981196e99a84e1ad1f8e817f74bda730ba6fe88.zip | |
- some bugfixes
git-svn-id: file:///svn/phpbb/trunk@5255 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/adm')
| -rw-r--r-- | phpBB/adm/admin_forums.php | 59 |
1 files changed, 0 insertions, 59 deletions
diff --git a/phpBB/adm/admin_forums.php b/phpBB/adm/admin_forums.php index d83c9dfb4b..12391d3371 100644 --- a/phpBB/adm/admin_forums.php +++ b/phpBB/adm/admin_forums.php @@ -1575,65 +1575,6 @@ function delete_forum_content($forum_id) $db->sql_transaction('commit'); } -function recalc_btree() -{ - global $db; - - $sql = 'SELECT forum_id, parent_id, left_id, right_id - FROM ' . FORUMS_TABLE . ' - ORDER BY parent_id ASC'; - $f_result = $db->sql_query($sql); - - while ($forum_data = $db->sql_fetchrow($f_result)) - { - if ($forum_data['parent_id']) - { - $sql = 'SELECT left_id, right_id - FROM ' . FORUMS_TABLE . ' - WHERE forum_id = ' . $forum_data['parent_id']; - $result = $db->sql_query($sql); - - if (!$row = $db->sql_fetchrow($result)) - { - $sql = 'UPDATE ' . FORUMS_TABLE . ' SET parent_id = 0 WHERE forum_id = ' . $forum_data['forum_id']; - $db->sql_query($sql); - } - $db->sql_freeresult($result); - - $sql = 'UPDATE ' . FORUMS_TABLE . ' - SET left_id = left_id + 2, right_id = right_id + 2 - WHERE left_id > ' . $row['right_id']; - $db->sql_query($sql); - - $sql = 'UPDATE ' . FORUMS_TABLE . ' - SET right_id = right_id + 2 - WHERE ' . $row['left_id'] . ' BETWEEN left_id AND right_id'; - $db->sql_query($sql); - - $forum_data['left_id'] = $row['right_id']; - $forum_data['right_id'] = $row['right_id'] + 1; - } - else - { - $sql = 'SELECT MAX(right_id) AS right_id - FROM ' . FORUMS_TABLE; - $result = $db->sql_query($sql); - - $row = $db->sql_fetchrow($result); - $db->sql_freeresult($result); - - $forum_data['left_id'] = $row['right_id'] + 1; - $forum_data['right_id'] = $row['right_id'] + 2; - } - - $sql = 'UPDATE ' . FORUMS_TABLE . ' - SET left_id = ' . $forum_data['left_id'] . ', right_id = ' . $forum_data['right_id'] . ' - WHERE forum_id = ' . $forum_data['forum_id']; - $db->sql_query($sql); - } - $db->sql_freeresult($f_result); -} - // // End function block // ------------------ |