Changeset 1184

User picture

Author: Blitze

(2012/02/11 07:14) 3 months ago

[menu] sql correction

Affected files

Updated trunk/primetime/root/modules/menu/blocks/cms_menu.php Download diff

11831184
52
		$sql = 'SELECT i1.*, (COUNT(i2.item_id) - 1) AS depth
52
		$sql = 'SELECT i1.*, (COUNT(i2.item_id) - 1) AS depth
53
			FROM ' . MENU_ITEMS_TABLE . ' i1, ' . MENU_ITEMS_TABLE . ' i2
53
			FROM ' . MENU_ITEMS_TABLE . ' i1, ' . MENU_ITEMS_TABLE . ' i2
54
			WHERE i1.left_id BETWEEN i2.left_id AND i2.right_id
54
			WHERE i1.left_id BETWEEN i2.left_id AND i2.right_id
 
55
				AND i1.menu_id = i2.menu_id



55
			GROUP BY i1.item_id
56
			GROUP BY i1.item_id



56
			ORDER BY i1.left_id ASC';
57
			ORDER BY i1.left_id ASC';



57
		$result = $db->sql_query($sql);
58
		$result = $db->sql_query($sql);


...
...
85
	{
86
	{



86
		$menu_data = $menu_cache['menus'][$menu_id];
87
		$menu_data = $menu_cache['menus'][$menu_id];



87
		$items_data = $menu_data['items'];
88
		$items_data = $menu_data['items'];



88



89
		$current_url = htmlspecialchars($user->page['page']);
89
		$current_url = htmlspecialchars($user->page['page']);



90
90



91
		cms_set_template_path($mtemplate, 'menu', 'block_menus.html');
91
		cms_set_template_path($mtemplate, 'menu', 'block_menus.html');