Home

TOL
Software
Download
Installation
Packages
OTAN

TOL Project
About TOL
Manuals
Development
R-Projects

Other Links
Trac Guide
Wiki Tree
​MMS

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