ZCA Bootstrap 4 Template [Support Thread]

[keneso]

Here is what I found more:

includes/pages/page/header.php
has this

$sql = "select * from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et 
        where e.pages_id = et.pages_id 
          and et.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
          and e.pages_id = " . (int)$ezpage_id;
// comment the following line to allow access to pages which don't have a status switch set to Yes:
$sql .= " AND (e.status_toc > 0 or e.status_header > 0 or e.status_sidebox > 0 or e.status_footer > 0)";

// Check to see if page exists and is accessible, retrieving relevant details for display if found
$var_pageDetails = $db->Execute($sql);
// redirect to home page if page not found (or deactivated/deleted):
if ($var_pageDetails->EOF) {
  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  $messageStack->add_session('header', ERROR_PAGE_NOT_FOUND, 'caution');
  header('HTTP/1.1 404 Not Found');
  zen_redirect(zen_href_link(FILENAME_DEFAULT));
}

//check db for prev/next based on sort orders
$pos = (isset($_GET['pos'])) ? $_GET['pos'] : 'v';  // v for vertical, h for horizontal  (v assumed if not specified)
$vert_links = array();
$toc_links = array();
//  $pages_order_query = "SELECT pages_id FROM " . TABLE_EZPAGES . " WHERE status = 1 and vertical_sort_order <> 0 ORDER BY vertical_sort_order, horizontal_sort_order, pages_title";
//  $pages_order_query = "SELECT * FROM " . TABLE_EZPAGES . " WHERE ((status_sidebox = 1 and sidebox_sort_order <> 0) or (status_footer = 1 and footer_sort_order <> 0) or (status_header = 1 and header_sort_order <> 0)) and alt_url_external = '' ORDER BY header_sort_order, sidebox_sort_order, footer_sort_order, pages_title";

// next query modified for multi-language support
$pages_order_query = "SELECT e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.header_sort_order, e.sidebox_sort_order, 
                      e.footer_sort_order, e.toc_sort_order, e.toc_chapter, e.status_header, e.status_sidebox, e.status_footer, status_toc, et.pages_title, 
                      et.pages_html_text  
                      FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et 
                      WHERE ((status_toc = 1 and toc_sort_order <> 0) and toc_chapter= :chapterID )
                      AND alt_url_external = '' and alt_url = '' 
                      AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
                      AND e.pages_id = et.pages_id
                      ORDER BY toc_sort_order, pages_title";
// end modification 

I changed last line to

ORDER BY toc_sort_order, et.pages_title"; 

But no joy.

Then there are these other modified files:

admin/ezpages.php
which I don't know how, too many changes for my comprehension.

includes/extra_datafiles/ezpages_multilangauge_database_names.php
admin/includes/extra_datafiles/ezpages_multilangauge_database_names.php
these two are the same, and I'd guess are not the issue

<?php
/**
 * @package admin
 * @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_multilangauge_database_names.php 2006-05-16 Neville Kerr $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

define('TABLE_EZPAGES_TEXT', DB_PREFIX . 'ezpages_content');
?>