New Zenner
- Join Date:
- Aug 2008
- Posts:
- 15
- Plugin Contributions:
- 0
ezpages toc sidebox vs multilingual
Hi
I'm new to this, for about a week or so... just getting to grips with things etc. I wanted to use ezpages_toc_sidebox with the ezpages multilingual addon... and made a change in the ez_pages_toc.php of the ezpages_toc_sidebox addon. Commented out the following line and replaced it with whats below. It seems to work, however I didn't know how to check which of the select should be performed, if the multi lingual module is plugged in ? Can anyone help me with this ?
Kind regards
Neil
// $pages_order_toc_query = "SELECT *
// FROM " . TABLE_EZPAGES . "
// WHERE ((status_toc = 1 and toc_sort_order <> 0) and toc_chapter= :chapterID )
// AND alt_url_external = '' and alt_url = ''
// ORDER BY toc_sort_order, pages_title";
$pages_order_toc_query = "SELECT e.pages_id, et.pages_id, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
WHERE e.pages_id = et.pages_id
AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
AND ((status_toc = 1 and toc_sort_order <> 0) and toc_chapter= 0 )
AND alt_url_external = ''
and alt_url = ''
ORDER BY toc_sort_order, pages_title";