HFile_mysql.php

Go to the documentation of this file.

<?php
$BEAUT_PATH = realpath(".") . "/Services/COPage/syntax_highlight/php";
if (!isset($BEAUT_PATH)) {
    return;
}
require_once("$BEAUT_PATH/Beautifier/HFile.php");
  class HFile_mysql extends HFile
  {
      public function HFile_mysql()
      {
          $this->HFile();
          /*************************************/
          // Beautifier Highlighting Configuration File
          // MySQL
          /*************************************/
          // Flags
 
          $this->nocase                 = "1";
          $this->notrim                 = "0";
          $this->perl                   = "0";
 
          // Colours
 
          $this->colours                = array("blue", "purple", "gray");
          $this->quotecolour            = "blue";
          $this->blockcommentcolour     = "green";
          $this->linecommentcolour      = "green";
 
          // Indent Strings
 
          $this->indent                 = array();
          $this->unindent               = array();
 
          // String characters and delimiters
 
          $this->stringchars            = array();
          $this->delimiters             = array("!", "&", "*", "(", ")", "+", "=", "|", "/", ";", "\"", "'", "<", ">", " ", "   ", ",", ".", "/");
          $this->escchar                = "";
 
          // Comment settings
 
          $this->linecommenton          = array("#");
          $this->blockcommenton         = array("");
          $this->blockcommentoff        = array("");
 
          // Keywords (keyword mapping to colour number)
 
          $this->keywords               = array(
            "add" => "1",
            "all" => "1",
            "alter" => "1",
            "and" => "1",
            "as" => "1",
            "asc" => "1",
            "auto_increment" => "1",
            "between" => "1",
            "binary" => "1",
            "both" => "1",
            "by" => "1",
            "change" => "1",
            "check" => "1",
            "column" => "1",
            "columns" => "1",
            "create" => "1",
            "cross" => "1",
            "data" => "1",
            "database" => "1",
            "databases" => "1",
            "default" => "1",
            "delayed" => "1",
            "delete" => "1",
            "desc" => "1",
            "describe" => "1",
            "distinct" => "1",
            "drop" => "1",
            "enclosed" => "1",
            "escaped" => "1",
            "exists" => "1",
            "explain" => "1",
            "field" => "1",
            "fields" => "1",
            "flush" => "1",
            "for" => "1",
            "foreign" => "1",
            "from" => "1",
            "function" => "1",
            "grant" => "1",
            "group" => "1",
            "having" => "1",
            "identified" => "1",
            "if" => "1",
            "ignore" => "1",
            "index" => "1",
            "insert" => "1",
            "infile" => "1",
            "into" => "1",
            "join" => "1",
            "key" => "1",
            "keys" => "1",
            "kill" => "1",
            "leading" => "1",
            "left" => "1",
            "like" => "1",
            "limit" => "1",
            "lines" => "1",
            "load" => "1",
            "local" => "1",
            "lock" => "1",
            "low_priority" => "1",
            "modify" => "1",
            "natural" => "1",
            "not" => "1",
            "null" => "1",
            "on" => "1",
            "optimize" => "1",
            "option" => "1",
            "optionally" => "1",
            "or" => "1",
            "order" => "1",
            "outer" => "1",
            "outfile" => "1",
            "primary" => "1",
            "proceedure" => "1",
            "read" => "1",
            "references" => "1",
            "regexp" => "1",
            "rename" => "1",
            "replace" => "1",
            "returns" => "1",
            "revoke" => "1",
            "rlike" => "1",
            "select" => "1",
            "set" => "1",
            "show" => "1",
            "soname" => "1",
            "status" => "1",
            "straight_join" => "1",
            "table" => "1",
            "tables" => "1",
            "teminated" => "1",
            "to" => "1",
            "trailing" => "1",
            "unique" => "1",
            "unlock" => "1",
            "unsigned" => "1",
            "update" => "1",
            "use" => "1",
            "using" => "1",
            "values" => "1",
            "variables" => "1",
            "where" => "1",
            "with" => "1",
            "write" => "1",
            "zerofill" => "1",
            "xor" => "1",
            "abs" => "2",
            "acos" => "2",
            "adddate" => "2",
            "ascii" => "2",
            "asin" => "2",
            "atan" => "2",
            "atan2" => "2",
            "avg" => "2",
            "bin" => "2",
            "bit_and" => "2",
            "bit_count" => "2",
            "bit_or" => "2",
            "ceiling" => "2",
            "char_lengh" => "2",
            "character_length" => "2",
            "concat" => "2",
            "conv" => "2",
            "cos" => "2",
            "cot" => "2",
            "count" => "2",
            "curdate" => "2",
            "curtime" => "2",
            "current_time" => "2",
            "current_timestamp" => "2",
            "date_add" => "2",
            "date_format" => "2",
            "date_sub" => "2",
            "dayname" => "2",
            "dayofmonth" => "2",
            "dayofweek" => "2",
            "dayofyear" => "2",
            "degrees" => "2",
            "elt" => "2",
            "encrypt" => "2",
            "exp" => "2",
            "find_in_set" => "2",
            "floor" => "2",
            "format" => "2",
            "from_days" => "2",
            "from_unixtime" => "2",
            "get_lock" => "2",
            "greatest" => "2",
            "hex" => "2",
            "hour" => "2",
            "ifnull" => "2",
            "instr" => "2",
            "isnull" => "2",
            "interval" => "2",
            "last_insert_id" => "2",
            "lcase" => "2",
            "lower" => "2",
            "least" => "2",
            "length" => "2",
            "locate" => "2",
            "log" => "2",
            "log10" => "2",
            "lpad" => "2",
            "ltrim" => "2",
            "max" => "2",
            "mid" => "2",
            "min" => "2",
            "minute" => "2",
            "mod" => "2",
            "month" => "2",
            "monthname" => "2",
            "now" => "2",
            "oct" => "2",
            "octet_length" => "2",
            "password" => "2",
            "period_add" => "2",
            "period_diff" => "2",
            "pi" => "2",
            "position" => "2",
            "pow" => "2",
            "quarter" => "2",
            "radians" => "2",
            "rand" => "2",
            "release_lock" => "2",
            "repeat" => "2",
            "reverse" => "2",
            "right" => "2",
            "round" => "2",
            "rpad" => "2",
            "rtrim" => "2",
            "second" => "2",
            "sec_to_time" => "2",
            "session_user" => "2",
            "sign" => "2",
            "sin" => "2",
            "soundex" => "2",
            "space" => "2",
            "sqrt" => "2",
            "strcmp" => "2",
            "substring" => "2",
            "substring_index" => "2",
            "sysdate" => "2",
            "system_user" => "2",
            "std" => "2",
            "sum" => "2",
            "tan" => "2",
            "time_format" => "2",
            "time_to_sec" => "2",
            "to_days" => "2",
            "trim" => "2",
            "truncate" => "2",
            "ucase" => "2",
            "unix_timestamp" => "2",
            "user" => "2",
            "version" => "2",
            "week" => "2",
            "weekday" => "2",
            "year" => "2",
            "bigint" => "3",
            "blob" => "3",
            "char" => "3",
            "date" => "3",
            "datetime" => "3",
            "decimal" => "3",
            "double" => "3",
            "doubleprecision" => "3",
            "enum" => "3",
            "float" => "3",
            "float4" => "3",
            "float8" => "3",
            "int" => "3",
            "int1" => "3",
            "int2" => "3",
            "int3" => "3",
            "int4" => "3",
            "int8" => "3",
            "integer" => "3",
            "long" => "3",
            "longblob" => "3",
            "longtext" => "3",
            "mediumblob" => "3",
            "mediumint" => "3",
            "mediumtext" => "3",
            "middleint" => "3",
            "numeric" => "3",
            "real" => "3",
            "smallint" => "3",
            "text" => "3",
            "time" => "3",
            "timestamp" => "3",
            "tinyint" => "3",
            "tinytext" => "3",
            "tinyblob" => "3",
            "varbinary" => "3",
            "varchar" => "3",
            "varying" => "3");
 
          // Special extensions
 
          // Each category can specify a PHP function that returns an altered
          // version of the keyword.
        
        
 
          $this->linkscripts            = array(
            "1" => "donothing",
            "2" => "donothing",
            "3" => "donothing");
      }
 
 
      public function donothing($keywordin)
      {
          return $keywordin;
      }
  }