in Joomla, Joomla Extention

Easyfaq2 content element for joomfish2

I think you guys who are familiar with joomla also know about it’s popular extension joomfish.Don no about joomfish ? ok let see what joomfish is:

The Joom!Fish is your key for providing multilingual content to your visitors! International (i8n) portals, companies or projects require content in different languages and processes which help to keep track of the translations. The Joom!Fish extension for the CMS Joomla! does exactly this.

Ya I like another extension for joomla to manage faq easily and it’s easyfaq.

Easy FAQ is a small and simple component that allows you to add a simple “Frequently Asked Questions” sections to your Joomla site. It allows you to specify categories and subcategories and add FAQ to it. It’s allows tagging to create a second level of categorization.

* Define categories and subcategories
* Add FAQ to a categorie
* Add tags to your FAQ
* Show a tag cloud on your site

Now ? I made joomfish plugin(contentelement) for easyfaq so that you can translate easyfaq faqs, categories, tags etc via joomfish translalation panel. that’s it. See the attach file bellow for download . LEt me know if you get any problem.
Note: This is upgraded version of old plugin that I did for earlier version of joomla, joomfish and easyfaq. So you can use this new version for joomla1.5, easyfaq2+, joomfish2+
[download id=”14″]

  1. Hi. Did you ever get around to writing a tutorial for creating a content element for joomfish? Your feedback would be appreciated.

  2. I found the solution… As I thought, EasyFAQ SQL queries are not compatible with Joomfish. I had to change the queries in componentscom_easyfaqmodelFaq_JA_Model.php, adding an SQL 'AS' when query uses aliases (e.g. 'FROM #__easyfaq f' becomes 'FROM #__easyfaq AS f').

    There certainly are other non-Joomfish-compatible syntaxes in this file and in other files. But for what I needed of EasyFAQ this is enough.

    Check Joomfish Documentation if ever you still are in trouble with some EasyFAQ translations.

  3. #

    Here is what I get when I enable Joomla debug (on page displaying a FAQ Category and its entries). As you can see, there is a Joomfish query after EasyFAQ query on category (jos_easyfaq_categories table), but there is no Joomfish query on entries after EasyFAQ query (jos_easyfaq table).

    Can you check what SQL queries look like on you site? Any clue on how to investigate this?

    [code language=”"sql"”]

    <code>SELECT *

    FROM jos_easyfaq_categories

    WHERE id = '3'

    #

    SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value

    FROM jos_jf_content AS jf_content

    WHERE jf_content.language_id=1

    AND jf_content.published=1

    AND jf_content.reference_id IN(3)

    AND jf_content.reference_table='easyfaq_categories'

    #

    SELECT c.*

    FROM jos_easyfaq_categories c

    WHERE c.state = 1

    AND c.parent_id = 3

    ORDER BY c.parent_id, c.ordering

    #

    SELECT c.*

    FROM jos_easyfaq_categories c

    WHERE c.state = 1

    ORDER BY c.parent_id, c.ordering

    #

    SELECT f.*, c.name AS category, u.name AS author, GROUP_CONCAT(DISTINCT CONCAT(t.id, '|', t.name)

    ORDER BY t.name) AS tags, AVG(r.rating) AS rating

    FROM jos_easyfaq f

    LEFT JOIN jos_easyfaq_categories c

    ON f.category_id = c.id

    LEFT JOIN jos_users u

    ON f.created_by = u.id

    LEFT JOIN jos_easyfaq_link_ft ft

    ON f.id = ft.faq_id

    LEFT JOIN jos_easyfaq_tags t

    ON ft.tag_id = t.id

    AND t.state = 1

    LEFT JOIN jos_easyfaq_rating r

    ON f.id = r.faq_id

    WHERE category_id = 3

    AND c.state = 1

    AND f.state = 1

    GROUP BY f.id

    ORDER BY c.name, f.ordering

    #

    SELECT id, title, module, position, content, showtitle, control, params

    FROM jos_modules AS m

    [/code]

    • <blockquote cite="comment-9334">

      N.Richard: Have you had the time to check this?

      Sorry I forgot it :(. I just checked it, didn't find any problem with faq entries translation. Please check you published those.

  4. Well it does not seem to work for me. Categories are correctly translated, but FAQ entries themselves are not. I think this is rather due to the SQL query being done by EasyFAQ, which does not meet the Joomfish requirements (see here).

    By enabling Joomla System Debug, you can see that no Joomfish query is made after the EasyFAQ query retrieving the FAQ… But I'm not SQL literate enough to diagnose the problem in the EasyFAQ query, and how to correct it! Any help greatly appreciated!

    • <blockquote cite="comment-9260">

      N.Richard: Well it does not seem to work for me. Categories are correctly translated, but FAQ entries themselves are not… But I’m not SQL literate enough to diagnose the problem in the EasyFAQ query, and how to correct it! Any help greatly appreciated!

      Please back to this blog post after one week and hope I will get time to check this within this time.

Comments are closed.