phpMyFAQ Codename Prospero FAQ News 
There are 0 FAQs online
There are 0 FAQs online
SELECT
config_name, config_value
FROM
faqconfig
SELECT
MAX(sid) AS current_id
FROM
faqsessions
INSERT INTO
faqsessions
(sid, user_id, ip, time)
VALUES
(3549, -1, '38.107.179.241', 1337545526)
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
faqcategories fc
LEFT JOIN
faqcategory_group fg
ON
fc.id = fg.category_id
LEFT JOIN
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
SELECT
COUNT(record_id) AS n
FROM
faqdata_tags
SELECT
count(sid) AS anonymous_users
FROM
faqsessions
WHERE
user_id = -1
AND
time > 1337545226
SELECT
count(session_id) AS registered_users
FROM
faquser
WHERE
session_timestamp > 1337545226
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20120520222526'
AND
fd.date_end >= '20120520222526'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND
( fdu.user_id = -1 OR fdu.user_id = -1 )