marksu:
Well never mind.
I made the changes my self it was mutch simpler than I thought.
Not sure if anyone care as not mutch communication hre but if somebody need solution here it is.
It is based on my earlier design which enables to add ezpaged filtering which groups they belong.
It would be even better code if it could outomatically check if multi languge expages module is installed instead of using comments character. Wen I dont know how to do it so this will do.
// --------------------
If ($chapNumber != ""){
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where toc_chapter = " . $chapNumber . " and status_header = 1 order by header_sort_order, pages_title");
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where toc_chapter = " . $chapNumber . " and e.pages_id = et.pages_id
and et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and status_header = 1
and header_sort_order > 0
order by header_sort_order, pages_title");
// end of modification
} else
{
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
$page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 order by header_sort_order, pages_title");
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, 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_header = 1
and header_sort_order > 0
order by header_sort_order, pages_title");
// end of modification
}
// --------------------
marksu
Perfect! Thanks so much!!!
