CSS Dropdown menu for the header- With Categories!

[bsteinagel]

Worked perfectly. Thanks rainthebat!

[marksu]

Well allmost all problems solved.
Seems like this module is not compatible with Multi-Language Support for EZ-Pages module.

The problem is that ezpages_drop_menu.php uses the original ezpages_drop_menu.php database table to get ezpage data.

Instead it should use the zen_ezpages_content table that is used on
Multi-Language Support for EZ-Pages module.

Any change anyone have solved the issue?

marksu

[marksu]

Well never mind.

I made the changes my self it was mutch simpler than I thought.

Not sure if anyone care as not mutch communication hre but if somebody need solution here it is.

It is based on my earlier design which enables to add ezpaged filtering which groups they belong.

It would be even better code if it could outomatically check if multi languge expages module is installed instead of using comments character. Wen I dont know how to do it so this will do.

// --------------------


If ($chapNumber != ""){

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where toc_chapter = " . $chapNumber . " and status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where toc_chapter = " . $chapNumber . " and 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


} else

{
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
$page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, 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
}
// --------------------

marksu

[jettrue]

Well never mind.

I made the changes my self it was mutch simpler than I thought.

Not sure if anyone care as not mutch communication hre but if somebody need solution here it is.

It is based on my earlier design which enables to add ezpaged filtering which groups they belong.

It would be even better code if it could outomatically check if multi languge expages module is installed instead of using comments character. Wen I dont know how to do it so this will do.

// --------------------


If ($chapNumber != ""){

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where toc_chapter = " . $chapNumber . " and status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where toc_chapter = " . $chapNumber . " and 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


} else

{
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
$page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, 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
}
// --------------------

marksu

Glad you figured it out, I don't have the time to make sure every module is compatible with this template, but perhaps I'll add this to future designs.

[marksu]

Glad you figured it out, I don't have the time to make sure every module is compatible with this template, but perhaps I'll add this to future designs.

Yes I understand. That is why I was happy to give contribution by providing the code.

Thank you for nice mod.

marksu

[mauryg]

jettrue,
Just noticed an interesting effect in my drop down menu. The last item in the bar is "MyAccount" and includes: Log In, Create Account, Shopping Cart, Shipping Info, Discount Coupons and Newsletter Unsubscribe. If I add a product to the shopping cart, the last 3 items disappear from the menu.
Is this normal ZenCart behaviour or something I need to fix with the menu?

Maury

[jettrue]

jettrue,
Just noticed an interesting effect in my drop down menu. The last item in the bar is "MyAccount" and includes: Log In, Create Account, Shopping Cart, Shipping Info, Discount Coupons and Newsletter Unsubscribe. If I add a product to the shopping cart, the last 3 items disappear from the menu.
Is this normal ZenCart behaviour or something I need to fix with the menu?

Maury

It looks like something you need to fix. You added the Shipping Info, Discount Coupons and Newsletter Unsubscribe yourself, right? I'm assuming you need to fix it somehow. Could you post that section of includes/templates/YOUR_TEMPLATE/common/tpl_drop_menu.php?

[pheniks]

Well never mind.

I made the changes my self it was mutch simpler than I thought.

Not sure if anyone care as not mutch communication hre but if somebody need solution here it is.

It is based on my earlier design which enables to add ezpaged filtering which groups they belong.

It would be even better code if it could outomatically check if multi languge expages module is installed instead of using comments character. Wen I dont know how to do it so this will do.

// --------------------


If ($chapNumber != ""){

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where toc_chapter = " . $chapNumber . " and status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where toc_chapter = " . $chapNumber . " and 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


} else

{
// USE THIS IS MULTI-LANGUGE EZPAGES MODULE NOT INSTALLED
$page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 order by header_sort_order, pages_title");

// USE THIS IS MULTI-LANGUGE EZPAGES MODULE IS INSTALLED
// 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, 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
}
// --------------------

marksu

marksu:

Any specific location within the file to place the above code? I'm drawing a blank how the suggested code should be in ezpages_drop_menu.php.

Thanks in advance...

[pheniks]

Jade (or anyone else):

Do you have any idea where the code in http://www.zen-cart.com/forum/showpo...&postcount=992 is supposed to go or how it is supposed to replace existing queries? marksu doesn't seem to be responding.

Thanks in advance,

[jettrue]

Jade (or anyone else):

Do you have any idea where the code in http://www.zen-cart.com/forum/showpo...&postcount=992 is supposed to go or how it is supposed to replace existing queries? marksu doesn't seem to be responding.

Thanks in advance,

I'm not sure, though I'm guessing it might belong in modules/sideboxes/YOUR_TEMPLATE/ezpages_drop_menu.php page not tpl_drop_menu.php since it has sql queries in it.