https://community.jforum.net/posts/list/2.page JForum - http://www.jforum.net
I wanted to ask about extracting statistical forum data. JForum has boards and rankings with useful insights, but I was wondering if it would be possible to extract that data, let's say in CSV or XLS for Reports. I'm particularly interested in extracting information about topic answers raised per date.

Thanks!]]> https://community.jforum.net/posts/preList/234/1067.page https://community.jforum.net/posts/preList/234/1067.page GMT https://community.jforum.net/posts/preList/234/1068.page https://community.jforum.net/posts/preList/234/1068.page GMT
I'm interested in extracting information in CSV or XLS format about the following:
[list]New topics raised by date and user[/list]
[list]New answers raised by date and user[/list]
[list]Views by date[/list]

An SQL script would be much appreciated, thanks!]]> https://community.jforum.net/posts/preList/234/1069.page https://community.jforum.net/posts/preList/234/1069.page GMT [code=sql]
select t.topic_id, t.forum_id, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.user_id, u.username, pt.post_text
from jforum_topics t, jforum_users u, jforum_posts p, jforum_posts_text pt
where t.user_id = u.user_id
and t.topic_id = p.topic_id
and p.post_id = pt.post_id
and t.topic_time > '2021-01-01'
and p.post_id = t.topic_first_post_id
[/code]

This gives you all replies after a specific time, along with the user name who posted the reply and the text of each reply:
[code=sql]
select t.topic_id, t.forum_id, t.topic_title, p.post_time, p.user_id, u.username, pt.post_text
from jforum_topics t, jforum_posts p, jforum_posts_text pt, jforum_users u
where t.user_id = u.user_id
and t.topic_id = p.topic_id
and p.post_id = pt.post_id
and p.post_time > '2021-01-01'
and p.post_id <> t.topic_first_post_id
[/code]

Views are only tracked per topic overall, not on a daily basis.]]> https://community.jforum.net/posts/preList/234/1070.page https://community.jforum.net/posts/preList/234/1070.page GMT