ILIAS  Release_4_1_x_branch Revision 61804
 All Data Structures Namespaces Files Functions Variables Groups Pages
HFile_sybase11x.php
Go to the documentation of this file.
1 <?php
2 $BEAUT_PATH = realpath(".")."/Services/COPage/syntax_highlight/php";
3 if (!isset ($BEAUT_PATH)) return;
4 require_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 
769 function donothing($keywordin)
770 {
771  return $keywordin;
772 }
773 
774 }?>