Get the number of discussions and replies (sql)
By HMED on Monday, 30 November 2015
Posted in General Issues
Likes 0
Views 688
Votes 0
Hi,

we are using odometer module by Nordmograpgh, thats help us to show some data count on the fron end (number of members, groups, etc.).

we tried to retrieve the number of discussions and replies in the tavle discuss_posts but we get both (discussions+replies), any way to get the number of discussions and the number of replies ?
Hi Jan,

#1. How to get total numbers of discussion:
You can take a look on the following helper file, /components/com_easydiscuss/models/post.php at method @getTotal() to get the total number of discussion on your site.

#2. How to get total numbers of replies in a discussion:
In the same file as I mentioned above, you can use the method @getTotalReplies() to get the total numbers of replies within the discussion.

Hope these help.
Ezrul Fazwan
·
Tuesday, 01 December 2015 11:22
·
0 Likes
·
0 Votes
·
0 Comments
·
thank you Ezrul
HMED
·
Tuesday, 01 December 2015 23:51
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Jan.
Ezrul Fazwan
·
Wednesday, 02 December 2015 11:42
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post