ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
HFile_sybase11x.php
Go to the documentation of this file.
1<?php
2$BEAUT_PATH = realpath(".")."/Services/COPage/syntax_highlight/php";
3if (!isset ($BEAUT_PATH)) return;
4require_once("$BEAUT_PATH/Beautifier/HFile.php");
5 class HFile_sybase11x extends HFile{
6 function HFile_sybase11x(){
7 $this->HFile();
8/*************************************/
9// Beautifier Highlighting Configuration File
10// Sybase 11.x SQL
11/*************************************/
12// Flags
13
14$this->nocase = "1";
15$this->notrim = "0";
16$this->perl = "0";
17
18// Colours
19
20$this->colours = array("blue", "gray", "gray", "purple", "brown", "blue", "purple");
21$this->quotecolour = "blue";
22$this->blockcommentcolour = "green";
23$this->linecommentcolour = "green";
24
25// Indent Strings
26
27$this->indent = array("begin");
28$this->unindent = array("end");
29
30// String characters and delimiters
31
32$this->stringchars = array();
33$this->delimiters = array("~", "!", "%", "^", "&", "*", "(", ")", "-", "+", "=", "|", "\\", "/", "{", "}", "[", "]", ":", ";", "\"", "'", "<", ">", " ", ",", " ", ".", "?");
34$this->escchar = "";
35
36// Comment settings
37
38$this->linecommenton = array("--");
39$this->blockcommenton = array("/*");
40$this->blockcommentoff = array("*/");
41
42// Keywords (keyword mapping to colour number)
43
44$this->keywords = array(
45 "activation" => "1",
46 "add" => "1",
47 "all" => "1",
48 "alter" => "1",
49 "and" => "1",
50 "any" => "1",
51 "arith_overflow" => "1",
52 "as" => "1",
53 "asc" => "1",
54 "at" => "1",
55 "authorization" => "1",
56 "avg" => "7",
57 "begin" => "1",
58 "between" => "1",
59 "break" => "1",
60 "browse" => "1",
61 "bulk" => "1",
62 "by" => "1",
63 "cascade" => "1",
64 "char_convert" => "1",
65 "check" => "1",
66 "checkpoint" => "1",
67 "close" => "1",
68 "clustered" => "1",
69 "commit" => "1",
70 "compute" => "1",
71 "confirm" => "1",
72 "connect" => "1",
73 "constraint" => "1",
74 "consumers" => "1",
75 "continue" => "1",
76 "controlrow" => "1",
77 "convert" => "7",
78 "count" => "7",
79 "create" => "1",
80 "current" => "1",
81 "cursor" => "1",
82 "database" => "1",
83 "dbcc" => "1",
84 "deallocate" => "1",
85 "declare" => "1",
86 "default" => "1",
87 "delete" => "1",
88 "desc" => "1",
89 "disk" => "1",
90 "distinct" => "1",
91 "double" => "1",
92 "drop" => "1",
93 "dummy" => "1",
94 "dump" => "1",
95 "else" => "1",
96 "end" => "1",
97 "endtran" => "1",
98 "errlvl" => "1",
99 "errordata" => "1",
100 "errorexit" => "1",
101 "escape" => "1",
102 "except" => "1",
103 "exclusive" => "1",
104 "exec" => "1",
105 "execute" => "1",
106 "exists" => "1",
107 "exit" => "1",
108 "external" => "1",
109 "fetch" => "1",
110 "fillfactor" => "1",
111 "for" => "1",
112 "foreign" => "1",
113 "from" => "1",
114 "goto" => "1",
115 "grant" => "1",
116 "group" => "1",
117 "having" => "1",
118 "holdlock" => "1",
119 "identity_insert" => "1",
120 "identity_start" => "1",
121 "if" => "1",
122 "in" => "1",
123 "index" => "1",
124 "insert" => "1",
125 "intersect" => "1",
126 "into" => "1",
127 "is" => "1",
128 "isolation" => "1",
129 "key" => "1",
130 "kill" => "1",
131 "level" => "1",
132 "like" => "1",
133 "lineno" => "1",
134 "load" => "1",
135 "max" => "7",
136 "max_rows_per_page" => "1",
137 "membership" => "1",
138 "min" => "7",
139 "mirror" => "1",
140 "mirrorexit" => "1",
141 "national" => "1",
142 "noholdlock" => "1",
143 "nonclustered" => "1",
144 "not" => "1",
145 "null" => "1",
146 "numeric_transaction" => "1",
147 "of" => "1",
148 "off" => "1",
149 "offsets" => "1",
150 "on" => "1",
151 "once" => "1",
152 "online" => "1",
153 "only" => "1",
154 "open" => "1",
155 "option" => "1",
156 "or" => "1",
157 "order" => "1",
158 "over" => "1",
159 "partition" => "1",
160 "passwd" => "1",
161 "perm" => "1",
162 "permanent" => "1",
163 "plan" => "1",
164 "precision" => "1",
165 "prepare" => "1",
166 "primary" => "1",
167 "print" => "1",
168 "privileges" => "1",
169 "proc" => "1",
170 "procedure" => "1",
171 "processexit" => "1",
172 "proxy" => "1",
173 "public" => "1",
174 "raiserror" => "1",
175 "read" => "1",
176 "readtext" => "1",
177 "reconfigure" => "1",
178 "references" => "1",
179 "replace" => "1",
180 "return" => "3",
181 "revoke" => "1",
182 "role" => "1",
183 "rollback" => "1",
184 "rowcount" => "1",
185 "rows" => "1",
186 "rule" => "1",
187 "save" => "1",
188 "schema" => "1",
189 "select" => "1",
190 "session" => "1",
191 "set" => "1",
192 "setuser" => "1",
193 "shared" => "1",
194 "shutdown" => "1",
195 "some" => "1",
196 "statistics" => "1",
197 "stripe" => "1",
198 "sum" => "7",
199 "syb_identity" => "1",
200 "syb_restree" => "1",
201 "table" => "1",
202 "temp" => "1",
203 "temporary" => "1",
204 "textsize" => "1",
205 "to" => "1",
206 "tran" => "1",
207 "transaction" => "1",
208 "trigger" => "1",
209 "truncate" => "1",
210 "tsequal" => "7",
211 "union" => "1",
212 "unique" => "1",
213 "unpartition" => "1",
214 "update" => "1",
215 "use" => "1",
216 "user" => "7",
217 "user_option" => "1",
218 "using" => "1",
219 "values" => "1",
220 "varying" => "1",
221 "view" => "1",
222 "waitfor" => "1",
223 "where" => "1",
224 "while" => "1",
225 "with" => "1",
226 "work" => "1",
227 "writetext" => "1",
228 "absolute" => "2",
229 "action" => "2",
230 "allocate" => "2",
231 "are" => "2",
232 "assertion" => "2",
233 "bit" => "2",
234 "bit_length" => "2",
235 "both" => "2",
236 "cascaded" => "2",
237 "case" => "2",
238 "cast" => "2",
239 "catalog" => "2",
240 "char" => "7",
241 "char_length" => "7",
242 "character" => "2",
243 "character_length" => "2",
244 "coalesce" => "7",
245 "collate" => "2",
246 "collation" => "2",
247 "column" => "2",
248 "connection" => "2",
249 "constraints" => "2",
250 "corresponding" => "2",
251 "cross" => "2",
252 "current_date" => "2",
253 "current_time" => "2",
254 "current_timestamp" => "2",
255 "current_user" => "2",
256 "date" => "2",
257 "day" => "2",
258 "dec" => "2",
259 "decimal" => "2",
260 "deferrable" => "2",
261 "deferred" => "2",
262 "describe" => "2",
263 "descriptor" => "2",
264 "diagnostics" => "2",
265 "disconnect" => "2",
266 "domain" => "2",
267 "end-exec" => "2",
268 "exception" => "2",
269 "extract" => "2",
270 "false" => "2",
271 "first" => "2",
272 "float" => "2",
273 "found" => "2",
274 "full" => "2",
275 "get" => "2",
276 "global" => "2",
277 "go" => "2",
278 "hour" => "2",
279 "immediate" => "2",
280 "indicator" => "2",
281 "initially" => "2",
282 "inner" => "2",
283 "input" => "2",
284 "insensitive" => "2",
285 "int" => "2",
286 "integer" => "2",
287 "interval" => "2",
288 "join" => "2",
289 "language" => "2",
290 "last" => "2",
291 "leading" => "2",
292 "left" => "2",
293 "local" => "2",
294 "lower" => "7",
295 "match" => "2",
296 "minute" => "2",
297 "module" => "2",
298 "month" => "2",
299 "names" => "2",
300 "natural" => "2",
301 "nchar" => "2",
302 "next" => "2",
303 "no" => "2",
304 "nullif" => "2",
305 "numeric" => "2",
306 "octet_length" => "2",
307 "outer" => "2",
308 "output" => "2",
309 "overlaps" => "2",
310 "pad" => "2",
311 "partial" => "2",
312 "position" => "2",
313 "preserve" => "2",
314 "prior" => "2",
315 "real" => "2",
316 "relative" => "2",
317 "restrict" => "2",
318 "right" => "7",
319 "scroll" => "2",
320 "second" => "2",
321 "section" => "2",
322 "session_user" => "2",
323 "size" => "2",
324 "smallint" => "2",
325 "space" => "7",
326 "sql" => "2",
327 "sqlcode" => "2",
328 "sqlerror" => "2",
329 "sqlstate" => "2",
330 "substring" => "7",
331 "system_user" => "2",
332 "then" => "2",
333 "time" => "2",
334 "timestamp" => "2",
335 "timezone_hour" => "2",
336 "timezone_minute" => "2",
337 "trailing" => "2",
338 "translate" => "2",
339 "translation" => "2",
340 "trim" => "2",
341 "true" => "2",
342 "unknown" => "2",
343 "upper" => "7",
344 "usage" => "2",
345 "value" => "2",
346 "varchar" => "2",
347 "varbinary" => "2",
348 "when" => "2",
349 "whenever" => "2",
350 "write" => "2",
351 "year" => "2",
352 "zone" => "2",
353 "after" => "3",
354 "alias" => "3",
355 "async" => "3",
356 "before" => "3",
357 "boolean" => "3",
358 "breadth" => "3",
359 "call" => "3",
360 "completion" => "3",
361 "cycle" => "3",
362 "data" => "3",
363 "depth" => "3",
364 "dictionary" => "3",
365 "each" => "3",
366 "elseif" => "3",
367 "equals" => "3",
368 "general" => "3",
369 "ignore" => "3",
370 "leave" => "3",
371 "less" => "3",
372 "limit" => "3",
373 "loop" => "3",
374 "modify" => "3",
375 "new" => "3",
376 "none" => "3",
377 "object" => "3",
378 "oid" => "3",
379 "old" => "3",
380 "operation" => "3",
381 "operators" => "3",
382 "others" => "3",
383 "parameters" => "3",
384 "pendant" => "3",
385 "preorder" => "3",
386 "private" => "3",
387 "protected" => "3",
388 "recursive" => "3",
389 "ref" => "3",
390 "referencing" => "3",
391 "resignal" => "3",
392 "returns" => "3",
393 "routine" => "3",
394 "row" => "3",
395 "savepoint" => "3",
396 "search" => "3",
397 "sensitive" => "3",
398 "sequence" => "3",
399 "signal" => "3",
400 "similar" => "3",
401 "sqlexception" => "3",
402 "structure" => "3",
403 "test" => "3",
404 "there" => "3",
405 "type" => "3",
406 "under" => "3",
407 "variable" => "3",
408 "virtual" => "3",
409 "visible" => "3",
410 "wait" => "3",
411 "without" => "3",
412 "sp_activeroles" => "4",
413 "sp_addalias" => "4",
414 "sp_addauditrecord" => "4",
415 "sp_addaudittable" => "4",
416 "sp_addextendedproc" => "4",
417 "sp_addexternlogin" => "4",
418 "sp_addgroup" => "4",
419 "sp_addlanguage" => "4",
420 "sp_addlogin" => "4",
421 "sp_addmessage" => "4",
422 "sp_addobjectdef" => "4",
423 "sp_addremotelogin" => "4",
424 "sp_add_resource_limit" => "4",
425 "sp_addsegment" => "4",
426 "sp_addserver" => "4",
427 "sp_addthreshold" => "4",
428 "sp_add_time_range" => "4",
429 "sp_addtype" => "4",
430 "sp_addumpdevice" => "4",
431 "sp_adduser" => "4",
432 "sp_altermessage" => "4",
433 "sp_autoconnect" => "4",
434 "sp_bindcache" => "4",
435 "sp_bindefault" => "4",
436 "sp_bindmsg" => "4",
437 "sp_bindrule" => "4",
438 "sp_cacheconfig" => "4",
439 "sp_cachestrategy" => "4",
440 "sp_changedbowner" => "4",
441 "sp_changegroup" => "4",
442 "sp_checknames" => "4",
443 "sp_checkreswords" => "4",
444 "sp_checksource" => "4",
445 "sp_chgattribute" => "4",
446 "sp_clearstats" => "4",
447 "sp_commonkey" => "4",
448 "sp_countmetadata" => "4",
449 "sp_cursorinfo" => "4",
450 "sp_column_privileges" => "4",
451 "sp_columns" => "4",
452 "sp_configure" => "4",
453 "sp_databases" => "4",
454 "sp_datatype_info" => "4",
455 "sp_dbcc_alterws" => "4",
456 "sp_dbcc_configreport" => "4",
457 "sp_dbcc_createws" => "4",
458 "sp_dbcc_deletedb" => "4",
459 "sp_dbcc_deletehistory" => "4",
460 "sp_dbcc_differentialreport" => "4",
461 "sp_dbcc_evaluatedb" => "4",
462 "sp_dbcc_faultreport" => "4",
463 "sp_dbcc_fullreport" => "4",
464 "sp_dbcc_runcheck" => "4",
465 "sp_dbcc_statisticsreport" => "4",
466 "sp_dbcc_summaryreport" => "4",
467 "sp_dbcc_updateconfig" => "4",
468 "sp_dboption" => "4",
469 "sp_defaultloc" => "4",
470 "sp_depends" => "4",
471 "sp_diskdefault" => "4",
472 "sp_displayaudit" => "4",
473 "sp_displaylevel" => "4",
474 "sp_displaylogin" => "4",
475 "sp_displayroles" => "4",
476 "sp_dropalias" => "4",
477 "sp_dropdevice" => "4",
478 "sp_dropexeclass" => "4",
479 "sp_dropextendedproc" => "4",
480 "sp_dropexternlogin" => "4",
481 "sp_dropglockpromote" => "4",
482 "sp_dropgroup" => "4",
483 "sp_dropkey" => "4",
484 "sp_droplanguage" => "4",
485 "sp_droplogin" => "4",
486 "sp_dropmessage" => "4",
487 "sp_dropobjectdef" => "4",
488 "sp_dropremotelogin" => "4",
489 "sp_drop_resource_limit" => "4",
490 "sp_dropsegment" => "4",
491 "sp_dropserver" => "4",
492 "sp_dropthreshold" => "4",
493 "sp_drop_time_range" => "4",
494 "sp_droptype" => "4",
495 "sp_dropuser" => "4",
496 "sp_estspace" => "4",
497 "sp_extendsegment" => "4",
498 "sp_familylock" => "4",
499 "sp_forceonline_db" => "4",
500 "sp_forceonline_page" => "4",
501 "sp_foreignkey" => "4",
502 "sp_freedll" => "4",
503 "sp_getmessage" => "4",
504 "sp_grantlogin" => "4",
505 "sp_help" => "4",
506 "sp_helpartition" => "4",
507 "sp_helpcache" => "4",
508 "sp_helpconfig" => "4",
509 "sp_helpconstraint" => "4",
510 "sp_helpdb" => "4",
511 "sp_helpdevice" => "4",
512 "sp_helpextendedproc" => "4",
513 "sp_helpexternlogin" => "4",
514 "sp_helpgroup" => "4",
515 "sp_helpindex" => "4",
516 "sp_helpjoins" => "4",
517 "sp_helpkey" => "4",
518 "sp_helplanguage" => "4",
519 "sp_helplog" => "4",
520 "sp_helpobjectdef" => "4",
521 "sp_helpremotelogin" => "4",
522 "sp_help_resource_limit" => "4",
523 "sp_helprotect" => "4",
524 "sp_helpsegment" => "4",
525 "sp_helpserver" => "4",
526 "sp_helpsort" => "4",
527 "sp_helptext" => "4",
528 "sp_helpthreshold" => "4",
529 "sp_helpuser" => "4",
530 "sp_hidetext" => "4",
531 "sp_indsuspect" => "4",
532 "sp_listsuspect_db" => "4",
533 "sp_listsuspect_page" => "4",
534 "sp_lock" => "4",
535 "sp_locklogin" => "4",
536 "sp_logdevice" => "4",
537 "sp_loginconfig" => "4",
538 "sp_logininfo" => "4",
539 "sp_logiosize" => "4",
540 "sp_modifylogin" => "4",
541 "sp_modify_resource_limit" => "4",
542 "sp_modify_time_range" => "4",
543 "sp_modifythreshold" => "4",
544 "sp_monitor" => "4",
545 "sp_monitorconfig" => "4",
546 "sp_passthru" => "4",
547 "sp_password" => "4",
548 "sp_placeobject" => "4",
549 "sp_plan_dbccdb" => "4",
550 "sp_primarykey" => "4",
551 "sp_processmail" => "4",
552 "sp_procqmode" => "4",
553 "sp_procxmode" => "4",
554 "sp_recompile" => "4",
555 "sp_remoteoption" => "4",
556 "sp_remotesql" => "4",
557 "sp_rename" => "4",
558 "sp_renamedb" => "4",
559 "sp_reportstats" => "4",
560 "sp_revokelogin" => "4",
561 "sp_role" => "4",
562 "sp_serveroption" => "4",
563 "sp_setlangalias" => "4",
564 "sp_setpglockpromote" => "4",
565 "sp_setsuspect_granularity" => "4",
566 "sp_setsuspect_threshold" => "4",
567 "sp_spaceused" => "4",
568 "sp_syntax" => "4",
569 "sp_sysmon" => "4",
570 "sp_unbindcache" => "4",
571 "sp_unbindcache_all" => "4",
572 "sp_unbindefault" => "4",
573 "sp_unbindmsg" => "4",
574 "sp_unbindrule" => "4",
575 "sp_volchanged" => "4",
576 "sp_who" => "4",
577 "sp_fkeys" => "4",
578 "sp_server_info" => "4",
579 "sp_special_columns" => "4",
580 "sp_sproc_columns" => "4",
581 "sp_statistics" => "4",
582 "sp_stored_procedures" => "4",
583 "sp_table_privileges" => "4",
584 "sp_tables" => "4",
585 "xp_cmdshell" => "4",
586 "xp_deletemail" => "4",
587 "xp_enumgroups" => "4",
588 "xp_findnextmsg" => "4",
589 "xp_logevent" => "4",
590 "xp_readmail" => "4",
591 "xp_sendmail" => "4",
592 "xp_startmail" => "4",
593 "xp_stopmail" => "4",
594 "dbo" => "5",
595 "master" => "5",
596 "model" => "5",
597 "tempdb" => "5",
598 "sysalternates" => "5",
599 "sysattributes" => "5",
600 "syscharsets" => "5",
601 "syscolumns" => "5",
602 "syscomments" => "5",
603 "sysconfigures" => "5",
604 "sysconstraints" => "5",
605 "syscurconfigs" => "5",
606 "sysdatabases" => "5",
607 "sysdepends" => "5",
608 "sysdevices" => "5",
609 "sysengines" => "5",
610 "sysgams" => "5",
611 "sysindexes" => "5",
612 "syskeys" => "5",
613 "syslanguages" => "5",
614 "syslisteners" => "5",
615 "syslocks" => "5",
616 "sysloginroles" => "5",
617 "syslogins" => "5",
618 "syslogs" => "5",
619 "syslogshold" => "5",
620 "sysmessages" => "5",
621 "sysmonitors" => "5",
622 "sysobjects" => "5",
623 "syspartitions" => "5",
624 "sysprocedures" => "5",
625 "sysprocesses" => "5",
626 "sysprotects" => "5",
627 "sysreferences" => "5",
628 "sysremotelogins" => "5",
629 "sysresourcelimits" => "5",
630 "sysroles" => "5",
631 "syssecmechs" => "5",
632 "syssegments" => "5",
633 "sysservers" => "5",
634 "syssrvroles" => "5",
635 "sysstatistics" => "5",
636 "systabstats" => "5",
637 "systestlog" => "5",
638 "systhresholds" => "5",
639 "systimeranges" => "5",
640 "systypes" => "5",
641 "sysusages" => "5",
642 "sysusermessages" => "5",
643 "sysusers" => "5",
644 "sybsystemprocs" => "5",
645 "@@char" => "6",
646 "@@connections" => "6",
647 "@@cpu" => "6",
648 "@@error" => "6",
649 "@@global" => "6",
650 "@@identity" => "6",
651 "@@idle" => "6",
652 "@@io" => "6",
653 "@@isolation" => "6",
654 "@@langid" => "6",
655 "@@max" => "6",
656 "@@ncharsize" => "6",
657 "@@nestlevel" => "6",
658 "@@options" => "6",
659 "@@pack" => "6",
660 "@@packet" => "6",
661 "@@pagesize" => "6",
662 "@@parallel" => "6",
663 "@@rowcount" => "6",
664 "@@scan" => "6",
665 "@@servername" => "6",
666 "@@sqlstatus" => "6",
667 "@@textcolid" => "6",
668 "@@textdbid" => "6",
669 "@@textobjid" => "6",
670 "@@textp" => "6",
671 "@@textptr" => "6",
672 "@@textsize" => "6",
673 "@@textts" => "6",
674 "@@thresh" => "6",
675 "@@total" => "6",
676 "@@tranchained" => "6",
677 "@@version" => "6",
678 "abs" => "7",
679 "acos" => "7",
680 "ascii" => "7",
681 "asin" => "7",
682 "atan" => "7",
683 "atn2" => "7",
684 "ceiling" => "7",
685 "charindex" => "7",
686 "col_length" => "7",
687 "col_name" => "7",
688 "cos" => "7",
689 "cot" => "7",
690 "curunreservedpgs" => "7",
691 "data_pgs" => "7",
692 "datalength" => "7",
693 "dateadd" => "7",
694 "datediff" => "7",
695 "datename" => "7",
696 "datepart" => "7",
697 "db_id" => "7",
698 "db_name" => "7",
699 "degrees" => "7",
700 "difference" => "7",
701 "exp" => "7",
702 "floor" => "7",
703 "getdate" => "7",
704 "host_id" => "7",
705 "host_name" => "7",
706 "index_col" => "7",
707 "isnull" => "7",
708 "is_sec_service_on" => "7",
709 "lct_admin" => "7",
710 "log" => "7",
711 "log10" => "7",
712 "ltrim" => "7",
713 "mut_excl_roles" => "7",
714 "object_id" => "7",
715 "object_name" => "7",
716 "patindex" => "7",
717 "pi" => "7",
718 "power" => "7",
719 "proc_role" => "7",
720 "ptn_data_pgs" => "7",
721 "radians" => "7",
722 "rand" => "7",
723 "replicate" => "7",
724 "reserved_pgs" => "7",
725 "reverse" => "7",
726 "role_contain" => "7",
727 "role_id" => "7",
728 "role_name" => "7",
729 "round" => "7",
730 "rowcnt" => "7",
731 "rtrim" => "7",
732 "show_role" => "7",
733 "show_sec_services" => "7",
734 "sign" => "7",
735 "sin" => "7",
736 "soundex" => "7",
737 "sqrt" => "7",
738 "str" => "7",
739 "stuff" => "7",
740 "suser_id" => "7",
741 "suser_name" => "7",
742 "tan" => "7",
743 "textptr" => "7",
744 "textvalid" => "7",
745 "used_pgs" => "7",
746 "user_id" => "7",
747 "user_name" => "7",
748 "valid_name" => "7",
749 "valid_user" => "7");
750
751// Special extensions
752
753// Each category can specify a PHP function that returns an altered
754// version of the keyword.
755
756
757
758$this->linkscripts = array(
759 "1" => "donothing",
760 "7" => "donothing",
761 "3" => "donothing",
762 "2" => "donothing",
763 "4" => "donothing",
764 "5" => "donothing",
765 "6" => "donothing");
766}
767
768
769function donothing($keywordin)
770{
771 return $keywordin;
772}
773
774}?>
$BEAUT_PATH
donothing($keywordin)