Official CYBERMIDI FAQ Center

DEBUG INFORMATION:
/hermes/web01/b1371/pow.cybermidi/htdocs/faq/inc/Init.php:
PMF_Configuration->getAll() in line 103:

            SELECT
                config_name, config_value
            FROM
                faq_faqconfig

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/inc/Category.php:
PMF_Category->getOrderedCategories() in line 154:

            SELECT
                fc.id AS id,
                fc.lang AS lang,
                fc.parent_id AS parent_id,
                fc.name AS name,
                fc.description AS description,
                fc.user_id AS user_id
            FROM
                faq_faqcategories fc
            LEFT JOIN
                faq_faqcategory_group fg
            ON
                fc.id = fg.category_id
            LEFT JOIN
                faq_faqcategory_user fu
            ON
                fc.id = fu.category_id
            WHERE
                ( fg.group_id IN (-1)
            OR
                (fu.user_id = -1 AND fg.group_id IN (-1)))
            AND
                fc.lang = 'en'
            GROUP BY
                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id
            ORDER BY
                fc.id

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Faq->getRecordTitle() in line 263:

SELECT
                thema
            FROM
                faq_faqdata
            WHERE
                id = 1 AND lang = 'en'

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Faq->getRecordKeywords() in line 264:

SELECT
                keywords
            FROM
                faq_faqdata
            WHERE id = 1 AND lang = 'en'

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Faq->getRecordPreview() in line 265:

            SELECT
                content as answer
            FROM
                faq_faqdata
            WHERE 
                id = 1 
            AND 
                lang = 'en'

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/inc/Category.php:
PMF_Category->getCategoriesFromArticle() in line 913:

            SELECT
                fc.id AS id,
                fc.lang AS lang,
                fc.parent_id AS parent_id,
                fc.name AS name,
                fc.description AS description
            FROM
                faq_faqcategoryrelations fcr,
                faq_faqcategories fc
            WHERE
                fc.id = fcr.category_id
            AND
                fcr.record_id = 1
            AND
                fcr.category_lang = 'en'
            AND
                fc.lang = 'en'

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Tags->existTagRelations() in line 368:

            SELECT
                COUNT(record_id) AS n
            FROM
                faq_faqdata_tags

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Session->getUsersOnline() in line 392:

                SELECT
                    count(sid) AS anonymous_users
                FROM
                    faq_faqsessions
                WHERE
                    user_id = -1
                AND 
                    time > 1283466750

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/index.php:
PMF_Session->getUsersOnline() in line 392:

                SELECT
                    count(session_id) AS registered_users
                FROM
                    faq_faquser
                WHERE
                    session_timestamp > 1283466750

/hermes/web01/b1371/pow.cybermidi/htdocs/faq/inc/Faq.php:
PMF_Faq->getStickyRecordsData() in line 2991:

            SELECT
                fd.id AS id,
                fd.lang AS lang,
                fd.thema AS thema,
                fcr.category_id AS category_id
            FROM
                faq_faqdata fd
            LEFT JOIN
                faq_faqcategoryrelations fcr
            ON
                fd.id = fcr.record_id
            AND
                fd.lang = fcr.record_lang
            LEFT JOIN
                faq_faqdata_group AS fdg
            ON
                fd.id = fdg.record_id
            LEFT JOIN
                faq_faqdata_user AS fdu
            ON
                fd.id = fdu.record_id
            WHERE
                fd.lang = 'en'
            AND 
                fd.date_start <= '20100903003730'
            AND 
                fd.date_end   >= '20100903003730'
            AND 
                fd.active = 'yes'
            AND 
                fd.sticky = 1
            AND
                ( fdu.user_id = -1 OR fdu.user_id = -1 )