Ezpages Footer Columns support

I noticed that an update is due to be released any day now. If I install the mod today, will the new version be an easy override, or should I just wait a few weeks for the release? I just want to make it easy! :smile:

You would need to merge any custom defines you had made into the new language define file, but aside from that there will be nothing changed in the base setup, just some new capabilities. The rest of the files can safely just replace the current versions. You might want to tweak the styling a bit too.

Hi Glenn - dumb question of the day. Can this mod be used for the Main Page, i.e. index or home page. If so how does it apply, index page doesn't show up in E-Z Pages to use the mod as per your instructions. If not then can you direct me to the area I should be in to modify my footer, i.e. to include external links (links being links to my other sites). I will use this mod for E-Z pages as I develop more and include in existing ones.

cheers,
Mike

The footer columns will display in the footer of all pages, home/index or any other, unless you add custom coding to limit it.
Just install it and configure some ez-page external links per the readme, and see how it works.

Hi:

I installed the mod and everything was great until I looked at it in Compatability View. Then the headings and page titles are all messed up. I am using 1.3.9h.

You can see it at http://poolcuesexpress.com/testsite. Username is dave, Password is dave123

I would appreciate any help anyone could give me.

Dave

I'm out of time to look at this right now, but the problem only happens in IE7 compatibility view, not IE8 or 9, so it must be some effect of an IE7 bug. IE developer tools seem very rudimentary and I haven't yet found out how to edit the CSS to add properties. What happens if you look in your stylesheet and replace the

#navSupp{background:#fff;}
.ezpagesFooterCol{float:left;padding:0 0 0.5em 0}

with

#navSupp{background:#fff;display: table; width: 100%;}
.ezpagesFooterCol{display: table-cell; padding:0 0 0.5em 0}

This is some of the updated CSS I use in the upcoming version of the mod; I don't know if it will have any effect on the background color and text height you are getting in IE7, but it can't hurt to try it.

Glenn, I tried that code and it took the background color away but the text still wasn't fixed.

You said that that only happens in IE7? If that's the case then I am not going to worry too much about it.

Thanks for the help and support. The mod works great other that that and it does exactly what I wanted it to do.

Dave

Hi Glenn,

I just uploaded the mod, and instead of footer I get:
WARNING: An Error occurred, please refresh the page and try again.

The only two things I can think of are my version, and the language:
1.50 Italian

I made a copy of the english directory, and uploaded it.

Last bit of info is I haven't created any ez-pages yet, but I would expect the rest of footer to show.

Thank you

There are no v1.5.0 changes to core files the mod touches, so the version shouldn't matter. Correct copying of language files should not cause a problem. Can I see the site where this is happening?

What is the latest myDebug file in /cache/?

Thank you.

DeBug
[23-Aug-2012 08:07:45] PHP Fatal error: 1054:Unknown column 'pages_title' in 'order clause' :: select * from ezpages where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title in /showroom/includes/classes/db/mysql/query_factory.php on line 101

Site is
afzdesign dot com / showroom

I have removed the plugin, if you want me to put it back up, please let me know.

It is choking on the SQL query, which is identical to the stock file's query. But if you are using the Multilanguage mod, that would probably be the issue, as that mod changes the SQL query and only fetches certain fields and not * ("everything"). My latest development version of this mod has an alternate version of ezpages_bar_footer.php which is compatible with the Multilanguage mod. ```php

<?php /** * ezpages bar (footer) - used to display links to EZ-Pages content in horizontal format (usually as a footer element) * * @package templateSystem * @copyright Copyright 2012 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 from standard file to provide multi-language support 2006-05-16 bunyip $ * @added support for EZ-Pages Footer Columns by Glenn Herbert (gjh42) 2012-02-22 */ 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 and ez-pages footer columns $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, e.footer_sort_order 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'); ?>

Looking at the revised $page_query, I see et.pages_title, which means that the title field has been moved from the ezpages table to the ezpages_text table. Thus the original query cannot find it to order by.

Thank you very much for your usual kindness.

I copied the code, and now it seems working fine, Just added one test page.

Thank you to share

gjh42:

There will be no changes in the admin appearance. You need to set the relevant ez-pages' footer sort orders as described in the readme.

You will get no footer columns until you have set ez-pages to appear in the footer.

I have turned on the ez pages in footer and changed all of the sort orders and still it is not sorting them into separate columns...what am I doing wrong?

Website is https://www.highplainsprospectors.com

Any help is appreciated.

Thanks!
Josh

You do not have EZ-Pages Footer Columns properly installed in your template, if at all. The output is strictly stock, but you have the stylesheet from clydejones' Footer Menu mod (though none of its output). Please verify what you have installed.

Our site is set up here: http://seventyfourdegrees.com/shop/index.php?main_page=page&id=16

We have installed the footer column module, enabled it in the ez-pages, changed the css, changed the column headers in the language file, updated the footer order of our links to the 110, 120 etc. but nothing is appearing. Is there something I am missing. There should be no disable footers in the config.

Basically we want the footer to look something like this: http://seventyfourdegrees.com/footer.jpg

Any help you can give or at least point us in the right direction if this has come up before would be much appreciated.

Thanks in advance.

What order did you install things in? Your Template Monster template has a customized tpl_footer.php, and you could not have both that and the Footer Columns active without combining the customizations in both versions of the file. Whichever one you installed last would be the only one active, and you do have the TM footer code active.

Can you post the contents of your template version of tpl_footer.php? That will tell exactly what is enabled, and I can tell you how to activate the footer columns if they are disabled.

Hmm we definitely installed the columns last, OK thanks for your help gjh42 I shall try combining and the two.