Displaying Total number of views and Discussions

Sampath_Amitash

In my vanilla forum installation, I would like to show the grand total of all the discussions and views. How can I do that?

x00

Probably something like

$TotalCount = Gdn::SQL()->Select('SUM(CountViews) As Total')->From('Discussion')->Value('Total');

Then you have to decide where you are going to want to put it.

x00

Though probably you are going to need a denormalised version, becuase if you have many records it is going to be a quite an overhead to look it up every time.

camo

how would you do that with total members?

would the above example be < php echo xxxxxx ? > or just that line?

whats denormalised?