Version 6 (modified by 9 years ago) (diff) | ,
---|
Home
TOL
Software
Download
Installation
Packages
OTAN
TOL Project
About TOL
Manuals
Development
R-Projects
Other Links
Trac Guide
MMS
TOLGrid
Left Menu
This page contains the left menu used in the main pages.
The menu in this page can be applied to the others using the following query:
UPDATE tolsch.wiki a SET text = regexp_replace(a.text, '<LEFT-MENU>.*?</LEFT-MENU>', m.lmenu) FROM ( SELECT name, Max(version) as version FROM tolsch.wiki WHERE text LIKE '%<LEFT-MENU>%' AND name <> 'LeftMenu' GROUP BY name ) av, ( SELECT (regexp_matches(text, '<LEFT-MENU>.*?</LEFT-MENU>'))[1] as lmenu FROM tolsch.wiki b, ( SELECT Max(version) as version FROM tolsch.wiki WHERE name = 'LeftMenu' ) bv WHERE b.name = 'LeftMenu' AND b.version = bv.version ) m WHERE a.name = av.name AND a.version = av.version