Multi-Language Support for EZ-Pages

[a_berezin]

Chapter error.

ezpages_bar_footer.php:
Find

  // 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

  // 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:

  // 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

  // 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