diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-04-18 00:54:26 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-04-18 00:54:26 +0200 |
| commit | a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce (patch) | |
| tree | 882f7f81539785edfd29e032d63a782245c7cb58 | |
| parent | 514bcb2fac1a11a53e20c789ea95be6207c38e80 (diff) | |
| download | forums-a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce.tar forums-a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce.tar.gz forums-a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce.tar.bz2 forums-a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce.tar.xz forums-a183fc1118b5ec3b1654ab4fda9c56fa1144e4ce.zip | |
[ticket/11495] Manually specify the table columns
PHPBB3-11495
| -rw-r--r-- | phpBB/includes/nestedset/base.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/nestedset/base.php b/phpBB/includes/nestedset/base.php index 5673a913fc..7c1e7f631e 100644 --- a/phpBB/includes/nestedset/base.php +++ b/phpBB/includes/nestedset/base.php @@ -157,8 +157,8 @@ abstract class phpbb_nestedset_base implements phpbb_nestedset_interface * siblings between the current spot and the target then the * item will move as far as possible */ - $sql = 'SELECT ' . implode(', ', $this->table_columns) . ' - FROM ' . $this->table_name . ' + $sql = "SELECT {$this->column_item_id}, {$this->column_parent_id}, {$this->column_left_id}, {$this->column_right_id}, {$this->column_item_parents} + FROM " . $this->table_name . ' WHERE ' . $this->column_parent_id . ' = ' . (int) $item[$this->column_parent_id] . ' ' . $this->get_sql_where() . ' AND '; |