2 DROP FUNCTION IF EXISTS core_enum_translation_display_name;
5 CREATE FUNCTION core_enum_translation_display_name(
9 RETURNS TEXT DETERMINISTIC
13 DECLARE v_orginal TEXT;
17 SELECT display_name INTO v_orginal FROM core_enum WHERE id = in_id;
19 SELECT txt INTO v_ret FROM cms_templatestr WHERE active = 1 AND lang = in_lang AND on_id = in_id AND on_table = 'core_enum' AND on_col = 'display_name' LIMIT 1;
21 IF (v_ret IS NULL OR v_ret = '') THEN