Chapter error.
ezpages_bar_footer.php:
Find
Code:
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$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_footer = 1
and footer_sort_order > 0
order by footer_sort_order, et.pages_title");
// end of modification
Replace by
Code:
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$page_query = $db->Execute("SELECT e.*, et.pages_title
FROM " . TABLE_EZPAGES . " e
LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
AND e.status_footer = 1
AND e.footer_sort_order > 0
ORDER BY e.header_sort_order, et.pages_title");
// end of modification
ezpages_bar_header.php:
Find:
Code:
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title");
$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
Replace by
Code:
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$page_query = $db->Execute("SELECT e.*, et.pages_title
FROM " . TABLE_EZPAGES . " e
LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
AND e.status_header = 1
AND e.header_sort_order > 0
ORDER BY e.header_sort_order, et.pages_title");
// end of modification
Bookmarks