SQL query for forum nembre

SQL query for forum nembre

by lovely Sandra -
Number of replies: 3

Hi ,all

plz i want to know the number of forum read for each student ...can someone help me to do this query please ??

thank you 

Average of ratings: -
In reply to lovely Sandra

Re: SQL query for forum nembre

by Mike Churchward -
Picture of Core developers Picture of Plugin developers Picture of Testers

Hi -

If you are using forum read tracking (settings in the forum activity module), you can count records in the 'forum_read' table. But this will only work for the forums that this is enabled for, and will not include reads that are older than the cutoff date for considering a post as read.

If you are not using read tracking, and need a count of all posts read, then you will have to do some complex analysis of the log store, looking for "view forum" and/or "view discussion" events.

mike

In reply to Mike Churchward

Re: SQL query for forum nembre

by lovely Sandra -

thank you for help Mr mike ..my problem is ..my table 'forum_read' is empty i did not understand why???


In reply to lovely Sandra

Re: SQL query for forum nembre

by Mike Churchward -
Picture of Core developers Picture of Plugin developers Picture of Testers

Hi -

That table is only used if forums have been configured to use read tracking. Check the system settings for the forum activity. There are several settings that affect how read tracking is used.

Your forum settings are in http://[yoursite]/admin/settings.php?section=modsettingforum

mike