Multi-Language Support for EZ-Pages

[pricediscrimination]

http://www.zen-cart.com/content.php?...-and-try-again

I read that page five times in the past two days. But DrByte inspired me to go back to the log directory to see what's going on. Hmm, no new logs, despite the errors. Then went to the admin, only to realize after updating my database for 1.5.1 it pulled in the old log directory location. After updating the location got to the logs and found:

PHP Fatal error:  1054:Unknown column 'pages_meta_title' in 'field list' :: select pages_meta_title, pages_meta_keywords, pages_meta_description FROM zen_ezpages WHERE pages_id = 6 in /html/includes/classes/db/mysql/query_factory.php on line 120

So it wasn't this mod and in fact it was EZ-Pages Meta Tag Fields causing the error. Reinstalled the SQL and EZ Pages are back!

HOWEVER, that doesn't change the fact that the Install/Uninstall Multi-Language EZ-Pages option is still not showing up in the admin>tools, and now I hope I didn't screw anything up by running the file directly (uninstalled, reinstalled, then fixed).

[bimo_in_bali]

Hi,
I've installed the mod, but my TOC is gone missing. Anybody know why?
I also tried to translate (copy paste from google) my existing ez-pages, but the translations turned in to "?????????" characters.

Please if anyone have any clues how to fix these. Thanks in advance

[pricediscrimination]

Hi,
I also tried to translate (copy paste from google) my existing ez-pages, but the translations turned in to "?????????" characters.

I think that is something about not having the matching encoding support on your site that is being used on the site (google in this case) that you are copying and pasting from. Emphasis on I think.

[bimo_in_bali]

I think that is something about not having the matching encoding support on your site that is being used on the site (google in this case) that you are copying and pasting from. Emphasis on I think.

Hi, thanks for replying.
The thing is, I also copy pasted translation from Google that I put in Home page (define main page in admin) and its working fine showing the Chinese and Arabic characters.
I just don't understand why it doesn't work the same on EZ-Pages.

[cjcraven]

Where non-English text remains as ?????, in my case it turned out to be database collation settings, mine were originally a latin setting, I needed to change to to utf8_general_ci to make the Japanese readable.

Check the database table "ezpages_content" for the collation and fields "pages_title" and "pages_html_text".

[frank18]

Has anyone got this mod working with ZC 1.5.3 ??

Just upgraded a site from 1.5.1 to 1.5.3 and all EZ-pages are showing NO title and NO text.... no matter which language is chosen

There are NO entries in the /logs folder

TOC shows fine though.

Cheers / Frank

[dre]

Hello I installed Multi-Language EZ pages , But now not everything in the footer is showing;

This is my original footer file:

<?php
/**
 * ezpages bar (footer) - used to display links to EZ-Pages content in horizontal format (usually as a footer element)
 *
 * @package templateSystem
 * @copyright Copyright 2009 Glenn Herbert
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ezpages_bar_footer.php 6021 2007-03-17 16:34:19Z ajeh $ 
 * Modified for EZ-Pages Footer Columns by Glenn Herbert (gjh42) 2009-10-06    (line 31)
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
$zco_notifier->notify('NOTIFY_START_EZPAGES_FOOTERBAR');

// test if bar should display:
if (EZPAGES_STATUS_FOOTER == '1' or (EZPAGES_STATUS_FOOTER == '2' and (strstr(EXCLUDE_ADMIN_IP_FOR_MAINTENANCE, $_SERVER['REMOTE_ADDR'])))) {
  //  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status = 1 and languages_id=" . (int)$_SESSION['languages_id'] . " and 

horizontal_sort_order > 0 order by horizontal_sort_order, pages_title");
  if (isset($var_linksList)) {
    unset($var_linksList);
  }
  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, 

pages_title");
  if ($page_query->RecordCount()>0) {
    $rows = 0;
    while (!$page_query->EOF) {
      $rows++;
      $page_query_list_footer[$rows]['id'] = $page_query->fields['pages_id'];
      $page_query_list_footer[$rows]['name'] = $page_query->fields['pages_title'];
$page_query_list_footer[$rows]['sort'] = $page_query->fields['footer_sort_order'];//ezpages_footer_columns      
      $page_query_list_footer[$rows]['altURL'] = '';

      // if altURL is specified, check to see if it starts with "http", and if so, create direct URL, otherwise use a zen href link
      switch (true) {
        // external link new window or same window
        case ($page_query->fields['alt_url_external'] != ''):
        $page_query_list_footer[$rows]['altURL']  = $page_query->fields['alt_url_external'];
        break;
        // internal link new window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '1'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], '', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 

'SSL'), true, true, true));
        break;
        // internal link same window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '0'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], '', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 

'SSL'), true, true, true));
        break;
      }

      // if altURL is specified, use it; otherwise, use EZPage ID to create link
      $page_query_list_footer[$rows]['link'] = ($page_query_list_footer[$rows]['altURL'] =='') ?
      zen_href_link(FILENAME_EZPAGES, 'id=' . $page_query->fields['pages_id'] . ($page_query->fields['toc_chapter'] > 0 ? '&chapter=' . $page_query->fields

['toc_chapter'] : ''), ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL')) :
      $page_query_list_footer[$rows]['altURL'];
      $page_query_list_footer[$rows]['link'] .= ($page_query->fields['page_open_new_window'] == '1' ? '" target="_blank' : '');
      $page_query->MoveNext();
    }

    $var_linksList = $page_query_list_footer;
  }
} // test for display

$zco_notifier->notify('NOTIFY_END_EZPAGES_FOOTERBAR');
?>

This is my edited file:

<?php
/**
 * ezpages bar (footer) - used to display links to EZ-Pages content in horizontal format (usually as a footer element)
 *
 * @package templateSystem
 * @copyright Copyright 2009 Glenn Herbert
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ezpages_bar_footer.php 6021 2007-03-17 16:34:19Z ajeh $ 
 * Modified for EZ-Pages Footer Columns by Glenn Herbert (gjh42) 2009-10-06    (line 31)
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
$zco_notifier->notify('NOTIFY_START_EZPAGES_FOOTERBAR');

// test if bar should display:
if (EZPAGES_STATUS_FOOTER == '1' or (EZPAGES_STATUS_FOOTER == '2' and (strstr(EXCLUDE_ADMIN_IP_FOR_MAINTENANCE, $_SERVER['REMOTE_ADDR'])))) {
  //  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status = 1 and languages_id=" . (int)$_SESSION['languages_id'] . " and horizontal_sort_order > 0 order by horizontal_sort_order, pages_title");
  if (isset($var_linksList)) {
    unset($var_linksList);
  }
  // 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.toc_chapter, 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, pages_title");
  // end of modification            
  if ($page_query->RecordCount()>0) {
    $rows = 0;
    while (!$page_query->EOF) {
      $rows++;
      $page_query_list_footer[$rows]['id'] = $page_query->fields['pages_id'];
      $page_query_list_footer[$rows]['name'] = $page_query->fields['pages_title'];
      $page_query_list_footer[$rows]['sort'] = $page_query->fields['footer_sort_order'];//ezpages_footer_columns
      $page_query_list_footer[$rows]['altURL'] = '';

      // if altURL is specified, check to see if it starts with "http", and if so, create direct URL, otherwise use a zen href link
      switch (true) {
        // external link new window or same window
        case ($page_query->fields['alt_url_external'] != ''):
        $page_query_list_footer[$rows]['altURL']  = $page_query->fields['alt_url_external'];
        break;
        // internal link new window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '1'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], '', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL'), true, true, true));
        break;
        // internal link same window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '0'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], '', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL'), true, true, true));
        break;
      }

      // if altURL is specified, use it; otherwise, use EZPage ID to create link
      $page_query_list_footer[$rows]['link'] = ($page_query_list_footer[$rows]['altURL'] =='') ?
      zen_href_link(FILENAME_EZPAGES, 'id=' . $page_query->fields['pages_id'] . ($page_query->fields['toc_chapter'] > 0 ? '&chapter=' . $page_query->fields['toc_chapter'] : ''), ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL')) :
      $page_query_list_footer[$rows]['altURL'];
      $page_query_list_footer[$rows]['link'] .= ($page_query->fields['page_open_new_window'] == '1' ? '" target="_blank' : '');
      $page_query->MoveNext();
    }

    $var_linksList = $page_query_list_footer;
  }
} // test for display

$zco_notifier->notify('NOTIFY_END_EZPAGES_FOOTERBAR');
?>

And this i s the file from the mod:

<?php
/**
 * ezpages bar (footer) - used to display links to EZ-Pages content in horizontal format (usually as a footer element)
 *
 * @package templateSystem
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ezpages_bar_footer.php 2006-05-16 bunyip $
 * @modified from standard file to provide multi-language support
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
$zco_notifier->notify('NOTIFY_START_EZPAGES_FOOTERBAR');

// test if bar should display:
if (EZPAGES_STATUS_FOOTER == '1' or (EZPAGES_STATUS_FOOTER == '2' and (strstr(EXCLUDE_ADMIN_IP_FOR_MAINTENANCE, $_SERVER['REMOTE_ADDR'])))) {
  //  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status = 1 and languages_id=" . (int)$_SESSION['languages_id'] . " and horizontal_sort_order > 0 order by horizontal_sort_order, pages_title");
  if (isset($var_linksList)) {
    unset($var_linksList);
  }
  // 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.toc_chapter, 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, pages_title");
  // end of modification                
               
  if ($page_query->RecordCount()>0) {
    $rows = 0;
    while (!$page_query->EOF) {
      $rows++;
      $page_query_list_footer[$rows]['id'] = $page_query->fields['pages_id'];
      $page_query_list_footer[$rows]['name'] = $page_query->fields['pages_title'];
      $page_query_list_footer[$rows]['altURL'] = '';

      // if altURL is specified, check to see if it starts with "http", and if so, create direct URL, otherwise use a zen href link
      switch (true) {
        // external link new window or same window
        case ($page_query->fields['alt_url_external'] != ''):
        $page_query_list_footer[$rows]['altURL']  = $page_query->fields['alt_url_external'];
        break;
        // internal link new window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '1'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], 'target="_blank', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL'), true, true, true));
        break;
        // internal link same window
        case ($page_query->fields['alt_url'] != '' and $page_query->fields['page_open_new_window'] == '0'):
        $page_query_list_footer[$rows]['altURL']  = (substr($page_query->fields['alt_url'],0,4) == 'http') ?
        $page_query->fields['alt_url'] :
        ($page_query->fields['alt_url']=='' ? '' : zen_href_link($page_query->fields['alt_url'], '', ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL'), true, true, true));
        break;
      }

      // if altURL is specified, use it; otherwise, use EZPage ID to create link
      $page_query_list_footer[$rows]['link'] = ($page_query_list_footer[$rows]['altURL'] =='') ?
      zen_href_link(FILENAME_EZPAGES, 'id=' . $page_query->fields['pages_id'] . ($page_query->fields['toc_chapter'] > 0 ? '&chapter=' . $page_query->fields['toc_chapter'] : ''), ($page_query->fields['page_is_ssl']=='0' ? 'NONSSL' : 'SSL')) :
      $page_query_list_footer[$rows]['altURL'];
      $page_query_list_footer[$rows]['link'] .= ($page_query->fields['page_open_new_window'] == '1' ? '" target="_blank' : '');
      $page_query->MoveNext();
    }

    $var_linksList = $page_query_list_footer;
  }
} // test for display

$zco_notifier->notify('NOTIFY_END_EZPAGES_FOOTERBAR');
?>

Maybe someone can help me . I cant figure it out what is wrong

Thank you

[dre]

fixed it with:

$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");

[kalastaja]

OK, got it zipped: ezpages.zip

[kalastaja]

I got a

EZ-Pages Select a page ...

WARNING: An Error occurred, please refresh the page and try again.

on

http://localhost/test/admin/ezpages.php

Have done code additions/alterations as per plugin and corrections below!

Couldn't enter the whole ezpages.php file!