Multi-Language Support for EZ-Pages

**eweb** · 18 Feb 2007, 01:23 PM

My headings on the ezbar header show the appropriate translated names (I'm using English & French), but when I click on either language, it shows the old EZPages data from before the install on the ezpages table (not ezpages_content). This content is now non-editable - and all the same language. I can update the ezpages_content via the admin section no problem - I just can't get my links to work and to display the new content. If anyone can help, I would be so greatfull

**Backstage** · 28 Feb 2007, 12:51 AM

Hi Please help with a solution to make ez pages run with multi language for 1.3.6 and 1.3.7

**Backstage** · 28 Feb 2007, 12:52 AM

eweb writes this:
I figured out that while the ezpages_content db is being updated (hence the reason we can see our page content in the admin section - and view our changes), it seems that the pages (in the shop side) are being pulled from the old html_content in the ezpages table instead of from the ezpages_content table. I'm not that proficient in PHP so I don't think I can fix this - maybe bunyip can update her mod for 1.3.7????

Maybe someone will help us :)

**carol** · 9 Mar 2007, 07:12 PM

I had multilanguage EZ pages working correctly in my 1.3.6 shop. However now I´m upgrading to 1.3.7 and multilanguage EZ pages doesn´t seem to work anymore. I have added all the files...

I upgraded the database to 1.3.7. I don´t know if I have to install Multilanguage EZ pages again or Fix/Repair. I tried both but with no satisfactory results. The EZ pages are all blank, even though in the admin I added the content and it looks all fine.

Please advise me how to proceed. I can´t get it to work.
Thanks,
Carol

**godspeed27** · 17 Mar 2007, 06:19 AM

I am having some crazy problems with 1.3.7 too, I have Japanese and it will only work in Japanese...it pulls the database info from the Japanese side when I change it to English, then I unistalled and reinstalled it and it caused the English in the Admin section of the edit page to turn to Japanese. Really a pain in the ######## as this is one of my favorite contributions.

**godspeed27** · 20 Mar 2007, 05:48 AM

Is Bunyip not around??? It looks to be almost a month since Bunyip has posted anything....HELP!

Does anyone know what the update in 1.3.6 to 1.3.7 that changed this? I am looking at the change log but can't find what might have done it, but then again I am not really sure what I am looking for.

**a_berezin** · 21 Mar 2007, 09:18 PM

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

**godspeed27** · 21 Mar 2007, 11:03 PM

This is great if this fixes it, tested?

**godspeed27** · 22 Mar 2007, 01:14 AM

ok, well this still isn't working for me. It's pulling in the english language on ezpages that I already had up and not pulling in anything but the title for new pages I make.

Think I am just going to go down to 1.3.6 until this gets fixed