[Mapbender-commits] r2720 - branches/2.5/resources/db/mysql

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-07-25 08:35:57 -0400 (Fri, 25 Jul 2008)
New Revision: 2720

Modified:
   branches/2.5/resources/db/mysql/mysql_schema.sql
Log:
gettext function

Modified: branches/2.5/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/2.5/resources/db/mysql/mysql_schema.sql	2008-07-25 08:34:48 UTC (rev 2719)
+++ branches/2.5/resources/db/mysql/mysql_schema.sql	2008-07-25 12:35:57 UTC (rev 2720)
@@ -3,6 +3,30 @@
 --
 -- --------------------------------------------------------
 
+
+DELIMITER $$
+
+DROP FUNCTION IF EXISTS gettext$$
+
+
+CREATE FUNCTION gettext(locale_arg text, querystring text) RETURNS text READS SQL DATA
+
+BEGIN
+
+DECLARE result text;
+
+SELECT msgstr INTO result FROM translations WHERE locale = locale_arg AND msgid = querystring;
+
+IF result IS NULL THEN
+RETURN querystring;
+ELSE
+RETURN result;
+END IF;
+
+END$$
+
+DELIMITER ;
+
 -- 
 -- Tabellenstruktur für Tabelle 'gui'
 --