[Mapbender-commits] r2720 - branches/2.5/resources/db/mysql
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Fri Jul 25 08:35:57 EDT 2008
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'
--
More information about the Mapbender_commits
mailing list