From: edward <edward@roojs.com>
Date: Thu, 10 Dec 2015 05:34:07 +0000 (+0800)
Subject: mysql/core_enum_translation_display_name.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=23c595333126461d3dcf52f5fcda5d224619d388

mysql/core_enum_translation_display_name.sql
---

diff --git a/mysql/core_enum_translation_display_name.sql b/mysql/core_enum_translation_display_name.sql
index a22cba13..4cc47638 100644
--- a/mysql/core_enum_translation_display_name.sql
+++ b/mysql/core_enum_translation_display_name.sql
@@ -16,7 +16,23 @@ RETURNS TEXT DETERMINISTIC
 
         SELECT display_name INTO v_orginal FROM core_enum WHERE id = in_id;
         
-        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;
+        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;
 
         IF (v_ret IS NULL OR v_ret = '') THEN
             RETURN v_orginal;