diff options
| author | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2002-11-05 04:50:55 +0000 |
|---|---|---|
| committer | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2002-11-05 04:50:55 +0000 |
| commit | bc6e36ef4f79132029f4f27f592872311724097b (patch) | |
| tree | 612cf91829c5dba2d33dd2ad8bbd81cbf04d0a3b /phpBB/admin/admin_forums.php | |
| parent | 5b73ad4cbd8c83f1fd5cc5713836e15caff8a045 (diff) | |
| download | forums-bc6e36ef4f79132029f4f27f592872311724097b.tar forums-bc6e36ef4f79132029f4f27f592872311724097b.tar.gz forums-bc6e36ef4f79132029f4f27f592872311724097b.tar.bz2 forums-bc6e36ef4f79132029f4f27f592872311724097b.tar.xz forums-bc6e36ef4f79132029f4f27f592872311724097b.zip | |
viewforum queries update + a couple of bugfixes.
git-svn-id: file:///svn/phpbb/trunk@3007 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/admin/admin_forums.php')
| -rw-r--r-- | phpBB/admin/admin_forums.php | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/phpBB/admin/admin_forums.php b/phpBB/admin/admin_forums.php index 021dbcbb96..3e79720dff 100644 --- a/phpBB/admin/admin_forums.php +++ b/phpBB/admin/admin_forums.php @@ -222,6 +222,13 @@ switch ($mode) { move_forum($forum_id, $parent_id); } + elseif ($row['forum_name'] != $_POST['forum_name']) + { + $sql = 'UPDATE ' . FORUMS_TABLE . ' + SET forum_parents = "" + WHERE left_id > ' . $row['left_id'] . ' AND right_id < ' . $row['right_id']; + $db->sql_query($sql); + } $sql = array( 'forum_name' => (!empty($_POST['forum_name'])) ? $_POST['forum_name'] : $row['forum_name'], @@ -904,7 +911,7 @@ function move_forum($from_id, $to_id) // Resync parents // $sql = 'UPDATE ' . FORUMS_TABLE . " - SET right_id = right_id - $diff + SET right_id = right_id - $diff, forum_parents = '' WHERE left_id < " . $from_data['right_id'] . " AND right_id > " . $from_data['right_id']; $db->sql_query($sql); @@ -912,7 +919,7 @@ function move_forum($from_id, $to_id) // Resync righthand side of tree // $sql = 'UPDATE ' . FORUMS_TABLE . " - SET left_id = left_id - $diff, right_id = right_id - $diff + SET left_id = left_id - $diff, right_id = right_id - $diff, forum_parents = '' WHERE left_id > " . $from_data['right_id']; $db->sql_query($sql); @@ -924,7 +931,7 @@ function move_forum($from_id, $to_id) // Resync new parents // $sql = 'UPDATE ' . FORUMS_TABLE . " - SET right_id = right_id + $diff + SET right_id = right_id + $diff, forum_parents = '' WHERE " . $to_data['right_id'] . ' BETWEEN left_id AND right_id AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')'; $db->sql_query($sql); @@ -933,7 +940,7 @@ function move_forum($from_id, $to_id) // Resync the righthand side of the tree // $sql = 'UPDATE ' . FORUMS_TABLE . " - SET left_id = left_id + $diff, right_id = right_id + $diff + SET left_id = left_id + $diff, right_id = right_id + $diff, forum_parents = '' WHERE left_id > " . $to_data['right_id'] . ' AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')'; $db->sql_query($sql); @@ -960,7 +967,7 @@ function move_forum($from_id, $to_id) } $sql = 'UPDATE ' . FORUMS_TABLE . " - SET left_id = left_id $diff, right_id = right_id $diff + SET left_id = left_id $diff, right_id = right_id $diff, forum_parents = '' WHERE forum_id IN (" . implode(', ', $moved_ids) . ')'; $db->sql_query($sql); } |