2 DROP PROCEDURE IF EXISTS cms_page_fullpath;
6 CREATE PROCEDURE cms_page_fullpath(
8 IN in_separator VARCHAR(64),
14 DECLARE v_parent_title TEXT;
15 DECLARE v_parent_id INT(11);
16 DECLARE v_translation_of_id INT(11);
19 SET v_parent_title = '';
21 SET v_translation_of_id = 0;
22 SET max_sp_recursion_depth = 255;
24 SELECT title, parent_id, translation_of_id INTO v_title, v_parent_id, v_translation_of_id FROM cms_page WHERE id = in_id;
26 IF (v_translation_of_id > 0) THEN
27 SELECT title, v_parent_id INTO v_title, v_parent_id FROM cms_page WHERE id = v_translation_of_id;
30 IF (v_parent_id = 0) THEN
31 SET fullpath = v_title;
33 CALL cms_page_fullpath(v_parent_id, in_separator, v_parent_title);
35 SELECT CONCAT_WS(in_separator, v_parent_title, v_title) INTO fullpath;
42 DROP FUNCTION IF EXISTS cms_page_fullpath;
45 CREATE FUNCTION cms_page_fullpath(
47 in_separator VARCHAR(64)
49 RETURNS TEXT DETERMINISTIC
54 CALL cms_page_fullpath(in_id, in_separator, v_ret);