LS,
I just downloaded and installed the FAQ Manager Module. It worked directly with ZenCart 1.3.9h (except for the SQL-script which I had to change manually since my table structure isn't standard, almost nothing any module can do about this).
I only had one problem: Every FAQ was displayed three times.
However: We also have three languages on our site (Dutch, English and French), so this connection was quickly made.
I changed one line in
includes\templates\<myTemplate>\templates\tpl_faqs_all_default.php
Line 41/42 has become:
adding theCode:$faqs_all_query_raw = "select f.*, fd.*, fcd.faq_categories_name from " . TABLE_FAQS . " f, " . TABLE_FAQS_DESCRIPTION . " fd, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " fcd, " . TABLE_FAQ_CATEGORIES . " fc " . "where f.faqs_status = '1' and f.faqs_id = fd.faqs_id and fd.language_id = '" . (int) $_SESSION['languages_id'] . "' and fd.language_id = fcd.language_id and f.master_faq_categories_id = fcd.faq_categories_id and f.master_faq_categories_id = fc.faq_categories_id and fc.faq_categories_status='1' ";
solved my problem.Code:and fd.language_id = fcd.language_id
I've already PM-ed this to the latest uploader of this module (sunnycoolboy) but wanted to share this knowledge directly with all of you too.
With kind regards,
Fred Schenk
PS: I haven't checked to see if this is the only place where the language-check should be extended.


Reply With Quote
