Colours::highlight_sql PHP Method

    public static function highlight_sql($sql)
    {
        $sql_keywords = array('ADD', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'AS', 'ASC', 'ASENSITIVE', 'BEFORE', 'BETWEEN', 'BIGINT', 'BINARY', 'BLOB', 'BOTH', 'BY', 'CALL', 'CASCADE', 'CASE', 'CHANGE', 'CHAR', 'CHARACTER', 'CHECK', 'COLLATE', 'COLUMN', 'CONDITION', 'CONNECTION', 'CONSTRAINT', 'CONTINUE', 'CONVERT', 'CREATE', 'CROSS', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER', 'CURSOR', 'DATABASE', 'DATABASES', 'DAY_HOUR', 'DAY_MICROSECOND', 'DAY_MINUTE', 'DAY_SECOND', 'DEC', 'DECIMAL', 'DECLARE', 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DETERMINISTIC', 'DISTINCT', 'DISTINCTROW', 'DIV', 'DOUBLE', 'DROP', 'DUAL', 'DUPLICATE', 'EACH', 'ELSE', 'ELSEIF', 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXIT', 'EXPLAIN', 'FALSE', 'FETCH', 'FLOAT', 'FLOAT4', 'FLOAT8', 'FOR', 'FORCE', 'FOREIGN', 'FROM', 'FULLTEXT', 'GOTO', 'GRANT', 'GROUP', 'HAVING', 'HIGH_PRIORITY', 'HOUR_MICROSECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'IF', 'IGNORE', 'IN', 'INDEX', 'INFILE', 'INNER', 'INOUT', 'INSENSITIVE', 'INSERT', 'INT', 'INT1', 'INT2', 'INT3', 'INT4', 'INT8', 'INTEGER', 'INTERVAL', 'INTO', 'IS', 'ITERATE', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LABEL', 'LEADING', 'LEAVE', 'LEFT', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCK', 'LONG', 'LONGBLOB', 'LONGTEXT', 'LOOP', 'LOW_PRIORITY', 'MATCH', 'MEDIUMBLOB', 'MEDIUMINT', 'MEDIUMTEXT', 'MIDDLEINT', 'MINUTE_MICROSECOND', 'MINUTE_SECOND', 'MOD', 'MODIFIES', 'NATURAL', 'NOT', 'NO_WRITE_TO_BINLOG', 'NULL', 'NUMERIC', 'ON', 'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'PRECISION', 'PRIMARY', 'PROCEDURE', 'PURGE', 'READ', 'READS', 'REAL', 'REFERENCES', 'REGEXP', 'RELEASE', 'RENAME', 'REPEAT', 'REPLACE', 'REQUIRE', 'RESTRICT', 'RETURN', 'REVOKE', 'RIGHT', 'RLIKE', 'SCHEMA', 'SCHEMAS', 'SECOND_MICROSECOND', 'SELECT', 'SENSITIVE', 'SEPARATOR', 'SET', 'SHOW', 'SMALLINT', 'SONAME', 'SPATIAL', 'SPECIFIC', 'SQL', 'SQL_BIG_RESULT', 'SQL_CALC_FOUND_ROWS', 'SQLEXCEPTION', 'SQL_SMALL_RESULT', 'SQLSTATE', 'SQLWARNING', 'SSL', 'STARTING', 'STRAIGHT_JOIN', 'TABLE', 'TERMINATED', 'THEN', 'TINYBLOB', 'TINYINT', 'TINYTEXT', 'TO', 'TRAILING', 'TRIGGER', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE', 'UPGRADE', 'USAGE', 'USE', 'USING', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING', 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL');
        $wp_tables = array('commentmeta', 'comments', 'links', 'options', 'postmeta', 'posts', 'terms', 'term_relationships', 'term_taxonomy', 'usermeta', 'users', 'blogs', 'blog_versions', 'registration_log', 'signups', 'site', 'sitecategories', 'sitemeta');
        //
        // Highlight keywords
        //
        foreach ($sql_keywords as $keyword) {
            $sql = preg_replace('/\\b' . $keyword . '\\b/', Colours::fg('bold_cyan') . $keyword . Colours::fg('white'), $sql);
        }
        //
        // Highlight WordPress table names
        //
        global $wpdb;
        foreach ($wp_tables as $table) {
            $sql = preg_replace('/\\b(' . $wpdb->prefix . '(\\d+_)?' . $table . ')\\b/', Colours::fg('purple') . '\\1' . Colours::fg('white'), $sql);
        }
        return $sql;
    }

 /**
  * Emits all queries to the console
  */
 public function wps_filter_query($query)
 {
     if (isset($this->options['no-sql'])) {
         return $query;
     }
     $in_wp_content = false;
     $backtrace = debug_backtrace();
     // Check for something in wp-content
     foreach ($backtrace as $i => $func) {
         if (empty($func['file'])) {
             continue;
         }
         // I am not sure that this is robust
         // It assumes that the stack looks like this:
         // - wp-db.php stuff
         //  - wp-db.php stuff
         //   - function that calls wpdb with a query
         //    - function that calls the thing which does the query <-- user interested in this
         if (preg_match('/wp-db/', $func['file']) && preg_match('/wp-db/', $backtrace[$i + 1]['file'])) {
             $in_func = $backtrace[$i + 3];
         }
         if (preg_match('/wp-content/', $func['file'])) {
             $in_wp_content = true;
             $in_func = $func;
             break;
         }
     }
     if (!isset($this->options['show-wp-queries']) && !$in_wp_content) {
         return $query;
     }
     $message = Colours::fg("purple") . "Query: ";
     if (isset($in_func)) {
         $file = str_replace($this->options['wp-root'] . "/wp-content/", '', $in_func['file']);
         $message .= Colours::off() . "Triggered by function " . Colours::fg("blue") . "{$in_func['function']}" . Colours::off() . " called from " . Colours::fg("brown") . $file . Colours::off() . " at line {$in_func['line']}:";
     } else {
     }
     $this->message($message);
     $this->message(Colours::highlight_sql("  " . trim($query)));
     return $query;
 }