fix Special Query for views in mysqli

diff --git a/DB/mysqli.php b/DB/mysqli.php
index 7f394f4..70a3f41 100644 (file)
--- a/DB/mysqli.php
+++ b/DB/mysqli.php
@@ -1122,6 +1122,11 @@ class DB_mysqli extends DB_common
      * @access protected
      * @see DB_common::getListOf()
      */
+
+    // }}}
+    // {{{ getSpecialQuery()
+
+     
     function getSpecialQuery($type)
     {
         switch ($type) {
@@ -1131,10 +1136,22 @@ class DB_mysqli extends DB_common
                 return 'SELECT DISTINCT User FROM mysql.user';
             case 'databases':
                 return 'SHOW DATABASES';
+            case 'views':
+                return "SELECT
+                        distinct(TABLE_NAME)
+                    FROM
+                        information_schema.TABLES
+                    WHERE
+                        table_type = 'VIEW'
+                        AND
+                        TABLE_SCHEMA=DATABASE()
+                    ";
+            
             default:
                 return null;
         }
     }
+    
 
     // }}}