change them to
includes/modules/ezpages_bar_footer.phpPHP Code:// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.toc_chapter, 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, et.pages_title");
// end of modification
includes/modules/sideboxes/ezpages.phpPHP Code:// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.toc_chapter, 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_footer = 1 and footer_sort_order > 0 order by footer_sort_order, et.pages_title");
// end of modification
PHP Code:// 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, e.sidebox_sort_order,
e.footer_sort_order, e.toc_sort_order, e.toc_chapter, e.page_open_new_window,
e.page_is_ssl, 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_sidebox = 1
and sidebox_sort_order > 0
order by sidebox_sort_order, et.pages_title");
// end of modification


Reply With Quote
