phpMyFAQ

Doubt : obtaining the original creation date of a FAQ record – is it possible?

Dear Thorsten / dear All

Does phpMyFAQ’s DB store permanently - and in a non-modifiable way - the original creation date of a FAQ record?

We need to create a report with the number and the question text of FAQ records created on 2009 and 2010 (separately).

Some 2009's FAQs were reviewed in 2010.

We tried several direct MySQL SQL queries on the DB tables/fields (datum, solution_id, revision_id, …)
without consistent results.

Is it possible to obtain this kind of reports?

Software and versions :

phpMyFAQ - 2.6.13
Database Server - MySQL
Database Client Version - 5.1.54
Database Server Version - 5.5.8
PHP - 5.3.4


Thanking in advance

Kind regards
2011-01-06
pt20100201

Hi,

you can do this by analyzing the faqadminlog table...

I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7

bye
Thorsten

Thorsten wrote:you can do this by analyzing the faqadminlog table...

I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7

Dear Thorsten

Thanks for your quick answer.

We must analyse the faqadminlog table a little more deeper...

The "fixed creation date" is important - even for those that don’t need to present reports.

Please continue your good work.

Kind regards
2011-01-07
pt20100201