Public Member Functions | |
HFile_tsql () | |
donothing ($keywordin) |
Definition at line 5 of file HFile_tsql.php.
HFile_tsql::donothing | ( | $ | keywordin | ) |
Definition at line 765 of file HFile_tsql.php.
{
return $keywordin;
}
HFile_tsql::HFile_tsql | ( | ) |
Definition at line 6 of file HFile_tsql.php.
References HFile::HFile().
{ $this->HFile(); /*************************************/ // Beautifier Highlighting Configuration File // Transact SQL /*************************************/ // Flags $this->nocase = "1"; $this->notrim = "0"; $this->perl = "0"; // Colours $this->colours = array("blue", "purple", "gray", "brown", "blue", "purple"); $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( "ABSOLUTE" => "1", "ACTION" => "1", "ALLOCATE" => "1", "ARE" => "1", "ASSERTION" => "1", "AT" => "1", "AUTHORIZATION" => "1", "BOTH" => "1", "CASCADE" => "1", "CASCADED" => "1", "CAST" => "1", "CATALOG" => "1", "CHAR_LENGTH" => "1", "CHARACTER" => "1", "CHARACTER_LENGTH" => "1", "COLLATE" => "1", "COLLATION" => "1", "COLUMN" => "1", "CONNECT" => "1", "CONNECTION" => "1", "CONSTRAINTS" => "1", "CORRESPONDING" => "1", "DATE" => "1", "DAY" => "1", "DEFERRABLE" => "1", "DEFERRED" => "1", "DESCRIBE" => "1", "DESCRIPTOR" => "1", "DIAGNOSTICS" => "1", "DISCONNECT" => "1", "DOMAIN" => "1", "END_EXEC" => "1", "ESCAPE" => "1", "EXCEPTION" => "1", "EXPIREDATE" => "1", "EXTERNAL" => "1", "EXTRACT" => "1", "FALSE" => "1", "FILE" => "1", "FIRST" => "1", "FULL" => "1", "GET" => "1", "GLOBAL" => "1", "HOUR" => "1", "IMMEDIATE" => "1", "INITIALLY" => "1", "INNER" => "1", "INPUT" => "1", "INTERVAL" => "1", "JOIN" => "1", "LAST" => "1", "LEADING" => "1", "LEFT" => "1", "LOCAL" => "1", "MATCH" => "1", "MINUTE" => "1", "MONTH" => "1", "NAMES" => "1", "NATIONAL" => "1", "NATURAL" => "1", "NCHAR" => "1", "NEXT" => "1", "NO" => "1", "OCTET_LENGTH" => "1", "OUTER" => "1", "OUTPUT" => "1", "OVERLAPS" => "1", "PAD" => "1", "PARTIAL" => "1", "POSITION" => "1", "PRESERVE" => "1", "PRIOR" => "1", "PRIVILEGES" => "1", "RELATIVE" => "1", "RESTRICT" => "1", "RETAINDAYS" => "1", "RIGHT" => "1", "ROWS" => "1", "SCHEMA" => "1", "SECOND" => "1", "SESSION" => "1", "SIZE" => "1", "SPACE" => "1", "SQLSTATE" => "1", "TIME" => "1", "TIMEZONE_HOUR" => "1", "TIMEZONE_MINUTE" => "1", "TRAILING" => "1", "TRANSLATE" => "1", "TRANSLATION" => "1", "TRUE" => "1", "UNKNOWN" => "1", "USAGE" => "1", "USING" => "1", "VALUE" => "1", "VOLUME" => "1", "WORK" => "1", "WRITE" => "1", "YEAR" => "1", "ZONE" => "1", "ADD" => "2", "ALL" => "2", "ALTER" => "2", "AND" => "2", "ANY" => "2", "AS" => "2", "ASC" => "2", "AVG" => "2", "BEGIN" => "2", "BETWEEN" => "2", "BREAK" => "2", "BROWSE" => "2", "BULK" => "2", "BY" => "2", "CASE" => "2", "CHECK" => "2", "CHECKPOINT" => "2", "CLOSE" => "2", "CLUSTERED" => "2", "COALESCE" => "2", "COMMIT" => "2", "COMMITTED" => "2", "COMPUTE" => "2", "CONFIRM" => "2", "CONSTRAINT" => "2", "CONTINUE" => "2", "CONTROLROW" => "2", "CONVERT" => "2", "COUNT" => "2", "CREATE" => "2", "CURRENT" => "2", "CURRENT_DATE" => "2", "CURRENT_TIME" => "2", "CURRENT_TIMESTAMP" => "2", "CURRENT_USER" => "2", "CURSOR" => "2", "DATABASE" => "2", "DBCC" => "2", "DEALLOCATE" => "2", "DECLARE" => "2", "DEFAULT" => "2", "DELETE" => "2", "DESC" => "2", "DISK" => "2", "DISTINCT" => "2", "DOUBLE" => "2", "DROP" => "2", "DUMMY" => "2", "DUMP" => "2", "ELSE" => "2", "END" => "2", "ERRLVL" => "2", "ERROREXIT" => "2", "EXCEPT" => "2", "EXEC" => "2", "EXECUTE" => "2", "EXISTS" => "2", "EXIT" => "2", "FETCH" => "2", "FILLFACTOR" => "2", "FLOPPY" => "2", "FOR" => "2", "FOREIGN" => "2", "FROM" => "2", "GOTO" => "2", "GRANT" => "2", "GROUP" => "2", "HAVING" => "2", "HOLDLOCK" => "2", "IDENTITY" => "2", "IDENTITY_INSERT" => "2", "IDENTITYCOL" => "2", "IF" => "2", "IN" => "2", "INDEX" => "2", "INSENSITIVE" => "2", "INSERT" => "2", "INTERSECT" => "2", "INTO" => "2", "IS" => "2", "ISOLATION" => "2", "KEY" => "2", "KILL" => "2", "LEVEL" => "2", "LIKE" => "2", "LINENO" => "2", "LOAD" => "2", "MAX" => "2", "MIN" => "2", "MIRROREXIT" => "2", "NOCHECK" => "2", "NONCLUSTERED" => "2", "NOT" => "2", "NULL" => "2", "NULLIF" => "2", "OF" => "2", "OFF" => "2", "OFFSETS" => "2", "ON" => "2", "ONCE" => "2", "ONLY" => "2", "OPEN" => "2", "OPTION" => "2", "OR" => "2", "ORDER" => "2", "OVER" => "2", "PERM" => "2", "PERMANENT" => "2", "PIPE" => "2", "PLAN" => "2", "PRECISION" => "2", "PREPARE" => "2", "PRIMARY" => "2", "PRINT" => "2", "PROC" => "2", "PROCEDURE" => "2", "PROCESSEXIT" => "2", "PUBLIC" => "2", "RAISERROR" => "2", "READ" => "2", "RECONFIGURE" => "2", "REFERENCES" => "2", "REPEATABLE" => "2", "REPLICATION" => "2", "RETURN" => "2", "REVOKE" => "2", "ROLLBACK" => "2", "ROWCOUNT" => "2", "RULE" => "2", "SAVE" => "2", "SCROLL" => "2", "SELECT" => "2", "SERIALIZABLE" => "2", "SESSION_USER" => "2", "SET" => "2", "SETUSER" => "2", "SHUTDOWN" => "2", "SOME" => "2", "STATISTICS" => "2", "SUM" => "2", "SYSTEM_USER" => "2", "TABLE" => "2", "TAPE" => "2", "TEMP" => "2", "TEMPORARY" => "2", "TEXTSIZE" => "2", "THEN" => "2", "TO" => "2", "TRAN" => "2", "TRANSACTION" => "2", "TRIGGER" => "2", "TRUNCATE" => "2", "TSEQUAL" => "2", "UNCOMMITTED" => "2", "UNION" => "2", "UNIQUE" => "2", "UPDATE" => "2", "UPDATETEXT" => "2", "USE" => "2", "USER" => "2", "VALUES" => "2", "VARYING" => "2", "VIEW" => "2", "WAITFOR" => "2", "WHEN" => "2", "WHERE" => "2", "WHILE" => "2", "WITH" => "2", "WRITETEXT" => "2", "sp_column_privileges" => "3", "sp_special_columns" => "3", "sp_columns" => "3", "sp_sproc_columns" => "3", "sp_databases" => "3", "sp_statistics" => "3", "sp_datatype_info" => "3", "sp_stored_procedures" => "3", "sp_fkeys" => "3", "sp_table_privileges" => "3", "sp_pkeys" => "3", "sp_tables" => "3", "sp_server_info" => "3", "sp_addpublisher" => "3", "sp_dropsubscriber" => "3", "sp_addsubscriber" => "3", "sp_helpdistributor" => "3", "sp_changesubscriber" => "3", "sp_helpserver" => "3", "sp_dboption" => "3", "sp_helpsubscriberinfo" => "3", "sp_droppublisher" => "3", "sp_replsync" => "3", "sp_addarticle" => "3", "sp_helparticle" => "3", "sp_addpublication" => "3", "sp_helparticlecolumns" => "3", "sp_articlecolumn" => "3", "sp_helppublication" => "3", "sp_changearticle" => "3", "sp_helppublicationsync" => "3", "sp_changepublication" => "3", "sp_helpreplicationdb" => "3", "sp_droparticle" => "3", "sp_replflush" => "3", "sp_droppublication" => "3", "sp_replstatus" => "3", "sp_enumfullsubscribers" => "3", "sp_addsubscription" => "3", "sp_helpsubscription" => "3", "sp_changesubscription" => "3", "sp_subscribe" => "3", "sp_changesubstatus" => "3", "sp_unsubscribe" => "3", "sp_dropsubscription" => "3", "sp_distcounters" => "3", "sp_replica" => "3", "sp_replcleanup" => "3", "sp_MSkill_job" => "3", "sp_repldone" => "3", "sp_replcmds" => "3", "sp_repltrans" => "3", "sp_replcounters" => "3", "sp_addtask" => "3", "sp_helptask" => "3", "sp_droptask" => "3", "sp_addalert" => "3", "sp_helpalert" => "3", "sp_addnotification" => "3", "sp_helpnotification" => "3", "sp_addoperator" => "3", "sp_helpoperator" => "3", "sp_dropalert" => "3", "sp_updatealert" => "3", "sp_dropnotification" => "3", "sp_updatenotification" => "3", "sp_dropoperator" => "3", "sp_updateoperator" => "3", "sp_purgehistory" => "3", "sp_helphistory" => "3", "sp_updatetask" => "3", "sp_MSSQLOLE65_version" => "3", "sp_MSSQLOLE_version" => "3", "sp_MS_upd_sysobj_category" => "3", "sp_MSdbuserprofile" => "3", "sp_MSdependencies" => "3", "sp_MSenumsubsystems" => "3", "sp_MSfilterclause" => "3", "sp_MSforeach_worker" => "3", "sp_MSforeachdb" => "3", "sp_MSforeachtable" => "3", "sp_MSgetalertinfo" => "3", "sp_MSgetexecinfo" => "3", "sp_MShelpcolumns" => "3", "sp_MShelpindex" => "3", "sp_MShelptype" => "3", "sp_MSindexspace" => "3", "sp_MSkilldb" => "3", "sp_MSloginmappings" => "3", "sp_MSmatchkey" => "3", "sp_MSobjectprivs" => "3", "sp_MSsetalertinfo" => "3", "sp_MSsetexecinfo" => "3", "sp_MSsettopology" => "3", "sp_MSsubscriptions" => "3", "sp_MStablechecks" => "3", "sp_MStablekeys" => "3", "sp_MStablerefs" => "3", "sp_MStablespace" => "3", "sp_MSuninstall_publishing" => "3", "sp_MSuniquename" => "3", "sp_TDGEN_CURSOR1" => "3", "sp_TD_table_summary" => "3", "sp_TDaccess_server_drives" => "3", "sp_TDblocks" => "3", "sp_TDcheck_indexes" => "3", "sp_TDcheck_rowcount" => "3", "sp_TDdb_locks" => "3", "sp_TDdbsizes_data" => "3", "sp_TDdbsizes_log" => "3", "sp_TDdbsizes_total" => "3", "sp_TDdefault_db_audit" => "3", "sp_TDdevspace" => "3", "sp_TDdroplogin" => "3", "sp_TDformat_commas" => "3", "sp_TDget_logins" => "3", "sp_TDgetdbsizes" => "3", "sp_TDhelpdb" => "3", "sp_TDhelplogin" => "3", "sp_TDmirrorlogin" => "3", "sp_TDpassword_change" => "3", "sp_TDrunthis" => "3", "sp_TDspaceused" => "3", "sp_TDtable_sizes" => "3", "sp_TDupdate_stats" => "3", "sp_a_count_bits_on" => "3", "sp_abort_xact" => "3", "sp_add_app_user" => "3", "sp_addalias" => "3", "sp_addextendedproc" => "3", "sp_addgroup" => "3", "sp_addlanguage" => "3", "sp_addlogin" => "3", "sp_addmessage" => "3", "sp_addremotelogin" => "3", "sp_addsegment" => "3", "sp_addserver" => "3", "sp_addtype" => "3", "sp_addumpdevice" => "3", "sp_adduser" => "3", "sp_altermessage" => "3", "sp_articlefilter" => "3", "sp_articletextcol" => "3", "sp_articleview" => "3", "sp_bindefault" => "3", "sp_bindrule" => "3", "sp_blockcnt" => "3", "sp_certify_removable" => "3", "sp_change_users_login" => "3", "sp_changedbowner" => "3", "sp_changegroup" => "3", "sp_check_objects" => "3", "sp_check_removable" => "3", "sp_checknames" => "3", "sp_chklangparam" => "3", "sp_coalesce_fragments" => "3", "sp_commit_xact" => "3", "sp_commonkey" => "3", "sp_configure" => "3", "sp_create_distribution_tables" => "3", "sp_create_removable" => "3", "sp_db_locks" => "3", "sp_db_upgrade" => "3", "sp_db_upgrade1" => "3", "sp_db_upgrade2" => "3", "sp_db_upgrade3" => "3", "sp_dbinstall" => "3", "sp_dbremove" => "3", "sp_ddopen" => "3", "sp_defaultdb" => "3", "sp_defaultlanguage" => "3", "sp_depends" => "3", "sp_devcreate" => "3", "sp_devoption" => "3", "sp_diskdefault" => "3", "sp_dropalias" => "3", "sp_dropdevice" => "3", "sp_dropextendedproc" => "3", "sp_dropgroup" => "3", "sp_dropkey" => "3", "sp_droplanguage" => "3", "sp_droplogin" => "3", "sp_dropmessage" => "3", "sp_dropremotelogin" => "3", "sp_dropsegment" => "3", "sp_dropserver" => "3", "sp_droptype" => "3", "sp_dropuser" => "3", "sp_dropwebtask" => "3", "sp_dsninfo" => "3", "sp_dtdba_checkfull" => "3", "sp_dtdba_constraint" => "3", "sp_dtdba_createsql" => "3", "sp_dtdba_freedevice" => "3", "sp_dtdba_getobj" => "3", "sp_dtdba_getobjectpermissions" => "3", "sp_dtdba_gettabkey" => "3", "sp_dtdba_gettabper" => "3", "sp_dtdba_getuserpermissions" => "3", "sp_dtdba_helpcolumn" => "3", "sp_dtdba_helpcolumn2" => "3", "sp_dtdba_indexkeys" => "3", "sp_dtdba_userprotects" => "3", "sp_enumdsn" => "3", "sp_exec" => "3", "sp_extendsegment" => "3", "sp_fallback_MS_enroll_db" => "3", "sp_fallback_MS_enroll_dev" => "3", "sp_fallback_MS_enroll_usg" => "3", "sp_fallback_MS_sel_fb_svr" => "3", "sp_fallback_MS_verify_ri" => "3", "sp_fallback_activate_svr" => "3", "sp_fallback_deactivate_svr" => "3", "sp_fallback_deactivate_svr_db" => "3", "sp_fallback_enroll_svr_db" => "3", "sp_fallback_help" => "3", "sp_fallback_help_db_dev" => "3", "sp_fallback_permanent_svr" => "3", "sp_fallback_upd_dev_drive" => "3", "sp_fallback_withdraw_svr_db" => "3", "sp_fixindex" => "3", "sp_foreignkey" => "3", "sp_get_volume_label" => "3", "sp_hcchangesubstatus1" => "3", "sp_hcchangesubstatus2" => "3", "sp_help" => "3", "sp_help_revdatabase" => "3", "sp_helpconstraint" => "3", "sp_helpdb" => "3", "sp_helpdevice" => "3", "sp_helpextendedproc" => "3", "sp_helpgroup" => "3", "sp_helpindex" => "3", "sp_helpjoins" => "3", "sp_helpkey" => "3", "sp_helplanguage" => "3", "sp_helplog" => "3", "sp_helplogins" => "3", "sp_helpremotelogin" => "3", "sp_helprotect" => "3", "sp_helpsegment" => "3", "sp_helpsort" => "3", "sp_helpsql" => "3", "sp_helpstartup" => "3", "sp_helptext" => "3", "sp_helpuser" => "3", "sp_kill" => "3", "sp_lock" => "3", "sp_lock2" => "3", "sp_lockinfo" => "3", "sp_logdevice" => "3", "sp_lookup" => "3", "sp_makestartup" => "3", "sp_makewebtask" => "3", "sp_markreport" => "3", "sp_monitor" => "3", "sp_namecrack" => "3", "sp_namecrack_qi" => "3", "sp_objcheck" => "3", "sp_objectsegment" => "3", "sp_password" => "3", "sp_placeobject" => "3", "sp_primarykey" => "3", "sp_probe_xact" => "3", "sp_processinfo" => "3", "sp_processmail" => "3", "sp_publishdb" => "3", "sp_recompile" => "3", "sp_remoteoption" => "3", "sp_remove_xact" => "3", "sp_rename" => "3", "sp_renamedb" => "3", "sp_runwebtask" => "3", "sp_scan_xact" => "3", "sp_schedulersignal" => "3", "sp_serveroption" => "3", "sp_setlangalias" => "3", "sp_setnetname" => "3", "sp_spaceused" => "3", "sp_sqlexec" => "3", "sp_sqlregister" => "3", "sp_start_xact" => "3", "sp_stat_xact" => "3", "sp_sysbackuphistory_limiter" => "3", "sp_tableoption" => "3", "sp_tempdbspace" => "3", "sp_textcolstatus" => "3", "sp_unbindefault" => "3", "sp_unbindrule" => "3", "sp_unmakestartup" => "3", "sp_user_counter1" => "3", "sp_user_counter10" => "3", "sp_user_counter2" => "3", "sp_user_counter3" => "3", "sp_user_counter4" => "3", "sp_user_counter5" => "3", "sp_user_counter6" => "3", "sp_user_counter7" => "3", "sp_user_counter8" => "3", "sp_user_counter9" => "3", "sp_userdefcounters" => "3", "sp_validlang" => "3", "sp_validname" => "3", "sp_who" => "3", "sp_who2" => "3", "xp_enumgroups" => "3", "xp_logininfo" => "3", "xp_grantlogin" => "3", "xp_revokelogin" => "3", "xp_loginconfig" => "3", "xp_deletemail" => "3", "xp_sendmail" => "3", "xp_findnextmsg" => "3", "xp_startmail" => "3", "xp_readmail" => "3", "xp_stopmail" => "3", "xp_cmdshell" => "3", "xp_sprintf" => "3", "xp_logevent" => "3", "xp_sscanf" => "3", "xp_msver" => "3", "CONNECTIONS" => "4", "CPU_BUSY" => "4", "CURSOR_ROWS" => "4", "DATEFIRST" => "4", "DBTS" => "4", "ERROR" => "4", "FETCH_STATUS" => "4", "IDLE" => "4", "IO_BUSY" => "4", "LANGID" => "4", "LANGUAGE" => "4", "MAX_CONNECTIONS" => "4", "MAX_PRECISION" => "4", "MICROSOFTVERSION" => "4", "NESTLEVEL" => "4", "PACK_RECEIVED" => "4", "PACK_SENT" => "4", "PACKET_ERRORS" => "4", "PROCID" => "4", "REMSERVER" => "4", "SERVERNAME" => "4", "SERVICENAME" => "4", "SPID" => "4", "TIMETICKS" => "4", "TOTAL_ERRORS" => "4", "TOTAL_READ" => "4", "TOTAL_WRITE" => "4", "TRANCOUNT" => "4", "VERSION" => "4", "ABS" => "5", "ACOS" => "5", "ASCII" => "5", "ASIN" => "5", "ATAN" => "5", "ATN2" => "5", "COL_NAME" => "5", "CHARINDEX" => "5", "CHAR" => "5", "COT" => "5", "COS" => "5", "CEILING" => "5", "COL_LENGTH" => "5", "DB_NAME" => "5", "DB_ID" => "5", "DATALENGTH" => "5", "DIFFERENCE" => "5", "DATEADD" => "5", "DATENAME" => "5", "DATEDIFF" => "5", "DATEPART" => "5", "DEGREES" => "5", "EXP" => "5", "FLOOR" => "5", "GETANSINULL" => "5", "GETDATE" => "5", "HOST_ID" => "5", "HOST_NAME" => "5", "ISNULL" => "5", "INDEX_COL" => "5", "IDENT_SEED" => "5", "IDENT_INCR" => "5", "LOWER" => "5", "LTRIM" => "5", "LOG" => "5", "LOG10" => "5", "OBJECT_ID" => "5", "OBJECT_NAME" => "5", "PATINDEX" => "5", "POWER" => "5", "PI" => "5", "RTRIM" => "5", "REVERSE" => "5", "REPLICATE" => "5", "RADIANS" => "5", "RAND" => "5", "ROUND" => "5", "SUSER_NAME" => "5", "SUSER_ID" => "5", "STATS_DATE" => "5", "SUBSTRING" => "5", "STUFF" => "5", "STR" => "5", "SOUNDEX" => "5", "SIGN" => "5", "SIN" => "5", "SQRT" => "5", "TEXTVALID" => "5", "TEXTPTR" => "5", "TAN" => "5", "USER_NAME" => "5", "USER_ID" => "5", "UPPER" => "5", "BINARY" => "6", "BIT" => "6", "DATETIME" => "6", "DECIMAL" => "6", "FLOAT" => "6", "IMAGE" => "6", "INT" => "6", "MONEY" => "6", "NTEXT" => "6", "NUMERIC" => "6", "NVARCHAR" => "6", "REAL" => "6", "SMALLDATETIME" => "6", "SMALLMONEY" => "6", "TEXT" => "6", "TIMESTAMP" => "6", "TINYINT" => "6", "UNIQUEIDENTIFIER" => "6", "VARBINARY" => "6", "VARCHAR" => "6"); // 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", "4" => "donothing", "5" => "donothing", "6" => "donothing"); }