From d576dd60e27f611dce0bbc3e1fe1203f90923668 Mon Sep 17 00:00:00 2001 From: Chris Date: Mon, 28 Jan 2013 20:56:00 +0800 Subject: [PATCH] DataObjects/core_functions.sql --- DataObjects/core_functions.sql | 22 +++++++++++++++++++++- 1 file changed, 21 insertions(+), 1 deletion(-) diff --git a/DataObjects/core_functions.sql b/DataObjects/core_functions.sql index d35ce1e4..a1744479 100644 --- a/DataObjects/core_functions.sql +++ b/DataObjects/core_functions.sql @@ -14,7 +14,27 @@ CREATE FUNCTION i18n_translate(in_ltype varchar(1) , in_lkey varchar(8), in_inl END $$ DELIMITER ; - +DROP FUNCTION IF EXISTS i18n_translate_with_title; +DELIMITER $$ +CREATE FUNCTION i18n_translate(in_ltype varchar(1) , in_lkey varchar(8), in_inlang varchar(8), in_lval VARCHAR(64)) + RETURNS VARCHAR(64) DETERMINISTIC + BEGIN + DECLARE ret VARCHAR(64); + SET ret = ''; + SELECT lval INTO ret FROM i18n + WHERE + ltype=in_ltype + AND + lkey=in_lkey + AND + inlang=in_inlang + AND + lval LIKE '%in_val%' + LIMIT 1; + RETURN ret; + + END $$ +DELIMITER ; DROP FUNCTION IF EXISTS core_enum_seqmax_update; DELIMITER $$ -- 2.39.2