diff options
author | Aleksander Machniak <alec@alec.pl> | 2015-04-06 12:00:09 +0200 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2015-04-06 12:00:09 +0200 |
commit | 48d01837a0a5725d2779f30d20478e77572e9ac5 (patch) | |
tree | c912c8f80b09c1cc619dce799ebff8dace0dbc16 /program/lib/Roundcube/rcube_db.php | |
parent | 1ad0e7da5207ab0403f40ee4e14eb282cfab3080 (diff) |
Fix tables listing routine on mysql and postgres so it skips system or other database tables and views (#1490337)
Diffstat (limited to 'program/lib/Roundcube/rcube_db.php')
-rw-r--r-- | program/lib/Roundcube/rcube_db.php | 11 |
1 files changed, 4 insertions, 7 deletions
diff --git a/program/lib/Roundcube/rcube_db.php b/program/lib/Roundcube/rcube_db.php index a31b2005d..4ccc59ba3 100644 --- a/program/lib/Roundcube/rcube_db.php +++ b/program/lib/Roundcube/rcube_db.php @@ -691,14 +691,11 @@ class rcube_db { // get tables if not cached if ($this->tables === null) { - $q = $this->query('SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME'); + $q = $this->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES" + . " WHERE TABLE_TYPE = 'BASE TABLE'" + . " ORDER BY TABLE_NAME"); - if ($q) { - $this->tables = $q->fetchAll(PDO::FETCH_COLUMN, 0); - } - else { - $this->tables = array(); - } + $this->tables = $q ? $q->fetchAll(PDO::FETCH_COLUMN, 0) : array(); } return $this->tables; |