| 1 | 1 | simandl | <?xml version="1.0" encoding="ISO-8859-1"?> |
| 2 | | | <!-- |
| 3 | | | star-light - version 1.0.3 (2005/06/24) |
| 4 | | | Copyright 2005, Dean Edwards |
| 5 | | | License: http://creativecommons.org/licenses/LGPL/2.1/ |
| 6 | | | --> |
| 7 | | | |
| 8 | | | <!-- SQL module by Rob Eberhardt --> |
| 9 | | | |
| 10 | | | <public:component xmlns:public="urn:HTMLComponent" lightweight="true"> |
| 11 | | | <public:attach event="ondocumentready" handler="init"/> |
| 12 | | | <script type="text/javascript"> |
| 13 | | | //<![CDATA[ |
| 14 | | | |
| 15 | | | var KEYWORDS = |
| 16 | | | "ADD|ALL|ALTER|AND|ANY|AS|ASC|AUTHORIZATION|BACKUP|BEGIN|BETWEEN|BREAK|BROWSE|BULK|BY|CASCADE|CASE|CHECK|CHECKPOINT|COALESCE|" + |
| 17 | | | "COLLATE|COLUMN|COMMIT|COMPUTE|CONSTRAINT|CONTAINS|CLOSE|CLUSTERED|CONTAINSTABLE|CONTINUE|CONVERT|CREATE|CROSS|CURRENT|" + |
| 18 | | | "CURRENT_DATE|CURRENT_TIME|CURRENT_TIMESTAMP|CURRENT_USER|CURSOR|DATABASE|DBCC|DEALLOCATE|DECLARE|DEFAULT|DELETE|DENY|DESC|" + |
| 19 | | | "DISK|DISTINCT|DISTRIBUTED|DOUBLE|DROP|DUMMY|DUMP|ELSE|END|ERRLVL|ESCAPE|EXCEPT|EXEC|EXECUTE|EXISTS|EXIT|" + |
| 20 | | | "FETCH|FILE|FILLFACTOR|FOR|FOREIGN|FREETEXT|FREETEXTTABLE|FROM|FULL|FUNCTION|GOTO|GRANT|GROUP|HAVING|HOLDLOCK|" + |
| 21 | | | "IDENTITY|IDENTITY_INSERT|IDENTITYCOL|IF|IN|INDEX|INNER|INSERT|INTERSECT|INTO|IS|JOIN|KEY|KILL|LEFT|LIKE|LINENO|LOAD|" + |
| 22 | | | "NATIONAL|NOCHECK|NONCLUSTERED|NOT|NULL|NULLIF|OF|OFF|OFFSETS|ON|OPEN|OPENDATASOURCE|OPENQUERY|OPENROWSET|OPENXML|OPTION|OR|" + |
| 23 | | | "ORDER|OUTER|OVER|PERCENT|PLAN|PRECISION|PRIMARY|PRINT|PROC|PROCEDURE|PUBLIC|RAISERROR|READ|READTEXT|RECONFIGURE|REFERENCES|" + |
| 24 | | | "REPLICATION|RESTORE|RESTRICT|RETURN|REVOKE|RIGHT|ROLLBACK|ROWCOUNT|ROWGUIDCOL|RULE|SAVE|SCHEMA|SELECT|SESSION_USER|SET|" + |
| 25 | | | "SETUSER|SHUTDOWN|SOME|STATISTICS|SYSTEM_USER|TABLE|TEXTSIZE|THEN|TO|TOP|TRAN|TRANSACTION|TRIGGER|TRUNCATE|TSEQUAL|" + |
| 26 | | | "UNION|UNIQUE|UPDATE|UPDATETEXT|USE|USER|VALUES|VARYING|VIEW|WAITFOR|WHEN|WHERE|WHILE|WITH|WRITETEXT"; |
| 27 | | | |
| 28 | | | var DATA_TYPES = |
| 29 | | | "bigint|int|smallint|tinyint|bit|decimal|numeric|money|smallmoney|float|real|datetime|smalldatetime|char|varchar|text" + |
| 30 | | | "nchar|nvarchar|ntext|binary|varbinary|image|cursor|sql_variant|table|timestamp|uniqueidentifier"; |
| 31 | | | |
| 32 | | | var GLOBAL = |
| 33 | | | "@@DATEFIRST|@@DBTS|@@LANGID|@@LANGUAGE|@@LOCK_TIMEOUT|@@MAX_CONNECTIONS|@@MAX_PRECISION|@@NESTLEVEL|@@OPTIONS|@@REMSERVER|@@SERVERNAME|@@SERVICENAME|@@SPID|@@TEXTSIZE|@@VERSION|" + |
| 34 | | | "@@CURSOR_ROWS|CURSOR_STATUS|@@FETCH_STATUS|" + |
| 35 | | | "DATEADD|DATEDIFF|DATENAME|DATEPART|DAY|GETDATE|GETUTCDATE|MONTH|YEAR|" + |
| 36 | | | "ABS|DEGREES|RAND|ACOS|EXP|ROUND|ASIN|FLOOR|SIGN|ATAN|LOG|SIN|ATN2|LOG10|SQUARE|CEILING|PI|SQRT|COS|POWER|TAN|COT|RADIANS|" + |
| 37 | | | "COL_LENGTH|fn_listextendedproperty|COL_NAME|FULLTEXTCATALOGPROPERTY|COLUMNPROPERTY|FULLTEXTSERVICEPROPERTY|DATABASEPROPERTY|INDEX_COL|DATABASEPROPERTYEX|INDEXKEY_PROPERTY|DB_ID|INDEXPROPERTY|DB_NAME|OBJECT_ID|FILE_ID|OBJECT_NAME|FILE_NAME|OBJECTPROPERTY|FILEGROUP_ID|@@PROCID|FILEGROUP_NAME|SQL_VARIANT_PROPERTY|FILEGROUPPROPERTY|TYPEPROPERTY|FILEPROPERTY|" + |
| 38 | | | "fn_trace_geteventinfo|IS_SRVROLEMEMBER|fn_trace_getfilterinfo|SUSER_SID|fn_trace_getinfo|SUSER_SNAME|fn_trace_gettable|USER_ID|HAS_DBACCESS|USER|IS_MEMBER|" + |
| 39 | | | "ASCII|NCHAR|SOUNDEX|CHAR|PATINDEX|SPACE|CHARINDEX|REPLACE|STR|DIFFERENCE|QUOTENAME|STUFF|LEFT|REPLICATE|SUBSTRING|LEN|REVERSE|UNICODE|LOWER|RIGHT|UPPER|LTRIM|RTRIM|" + |
| 40 | | | "APP_NAME|CASE|CAST|CONVERT|COALESCE|COLLATIONPROPERTY|CURRENT_TIMESTAMP|CURRENT_USER|DATALENGTH|@@ERROR|fn_helpcollations|fn_servershareddrives|fn_virtualfilestats|FORMATMESSAGE|GETANSINULL|HOST_ID|HOST_NAME|IDENT_CURRENT|IDENT_INCR|IDENT_SEED|@@IDENTITY|IDENTITY|ISDATE|ISNULL|ISNUMERIC|NEWID|NULLIF|PARSENAME|PERMISSIONS|@@ROWCOUNT|ROWCOUNT_BIG|SCOPE_IDENTITY|SERVERPROPERTY|SESSIONPROPERTY|SESSION_USER|STATS_DATE|SYSTEM_USER|@@TRANCOUNT|USER_NAME|" + |
| 41 | | | "@@CONNECTIONS|@@PACK_RECEIVED|@@CPU_BUSY|@@PACK_SENT|fn_virtualfilestats|@@TIMETICKS|@@IDLE|@@TOTAL_ERRORS|@@IO_BUSY|@@TOTAL_READ|@@PACKET_ERRORS|@@TOTAL_WRITE|" + |
| 42 | | | "PATINDEX|TEXTPTR|TEXTVALID"; |
| 43 | | | |
| 44 | | | function init() { |
| 45 | | | parser.ignoreCase = true; |
| 46 | | | |
| 47 | | | // default text colour |
| 48 | | | style.color = "black"; |
| 49 | | | |
| 50 | | | // comments |
| 51 | | | var LINE_COMMENT = /(--)[^\n]*\n/; |
| 52 | | | parser.add(BLOCK_COMMENT, "color:green"); |
| 53 | | | parser.add(LINE_COMMENT, "color:green"); |
| 54 | | | |
| 55 | | | // strings |
| 56 | | | parser.add(STRING1, "color:maroon"); // single quotes |
| 57 | | | parser.add(STRING2, "color:maroon"); // double quotes |
| 58 | | | |
| 59 | | | // numbers |
| 60 | | | parser.add(NUMBER, "color:maroon"); |
| 61 | | | |
| 62 | | | // urls/email |
| 63 | | | urls = true; |
| 64 | | | email = true; |
| 65 | | | |
| 66 | | | tabStop = 4; |
| 67 | | | |
| 68 | | | // vbcript keywords |
| 69 | | | parser.add(KEYWORDS, "color:blue"); |
| 70 | | | parser.add(DATA_TYPES, "color:orange"); |
| 71 | | | parser.add(GLOBAL, "color:#ff0099"); |
| 72 | | | }; |
| 73 | | | //]]> |
| 74 | | | </script> |
| 75 | | | </public:component> |
