s08e02 - Per Product FAQs SUPPORT / QUESTIONS / CHAT

[villameschik]

When you say it doesn't work, would you please be more specific?

I installed it in 1.0.8.1 and 1.0.8.0
admin => customer => click on FAQ
admin => modules => content => install FAQ
Then to test, I clicked on a couple of products then went to the bottom asked a question.
Went to admin => customer => click on FAQ and both questions were there.

Thanks,

thank you for your answer but I don't think I'm so naive yet to post to waste time, it works for me too in admin, I ask questions and answers, the customer side doesn't work for me, when the customer asks the question, it doesn't reach me in admin nothing. where am i wrong?

[villameschik]

Hi, I found the problem but I don't know how to fix it, the code works on admin of the language where the customer posted the question. I work on EN and DE how can it be solved?

[beerbee]

Hi,
try changing line 300 in admin/faq.php
from

Code: Select all

 $faqs_query_raw = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id WHERE cfi.language_id = " . (int)$languages_id . " ORDER BY cf.faq_id DESC"; 

to:

Code: Select all

$faqs_query_raw = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id GROUP BY cf.faq_id ORDER BY cf.faq_id DESC";

Best regards
Christoph

[beerbee]

There is another little error in the script, everywhere it states

Code: Select all

sID=

it should be

Code: Select all

fID=

as intended.

[villameschik]

There is another little error in the script, everywhere it states

Code: Select all

sID=

it should be

Code: Select all

fID=

as intended.

thanks @beerbee, now it works.

[plamastus]

Hi,

Suggestion for the gurus, it would be nice to see a "faq" pull down menu on the Top Navbar as questions get asked.

Thanks,

[beerbee]

Is it possible to add Maths Recaptcha to the module? Thank you

I tried but couldn't get it really working (with my limited abilities), there has to be the entry for the good page mentioned by Heatherbell, and inside ext/modules/content/product_info/ask_question.php there has to be

Code: Select all

       $OSCOM_Hooks->call('siteWide', 'injectFormVerify');
    if (tep_form_processing_is_valid()) { 

I put this just just before

Code: Select all

tep_db_perform('clubosc_faq', $sql_data_array);

and closed the condition after

Code: Select all

  tep_redirect(tep_href_link('product_info.php', 'products_id=' . (int)$_POST['products_id']));
  } 

adding another }.

This works but on error it does redirect to ask_question.php without the needed products_id parameter so this throws errors - not acceptable.

If I add an else case with a redirect to ask_question.php with parameter this works but I can't get any message about wrong math to be shown - better, but not acceptable too.

Best regards
Christoph

[heatherbell]

Is it possible to add Maths Recaptcha to the module? Thank you

We have had this addon (or very similar) running on our live shop for over 2 years and we have not yet had a single spammer find it so we have never put an anti-spam captcha on it - maybe spammers look for contact_us but don't look for this one?

[villameschik]

Is it possible to add Maths Recaptcha to the module? Thank you

We have had this addon (or very similar) running on our live shop for over 2 years and we have not yet had a single spammer find it so we have never put an anti-spam captcha on it - maybe spammers look for contact_us but don't look for this one?

hello now everything works, but with the file updates how are we ?, I still have not received anything, do you have any news? Thank you

[heatherbell]

but with the file updates how are we ?, I still have not received anything, do you have any news? Thank you

Burt is busy so please be patient.