RM 1.2 Ratings/Reviews count

[hotdoghero]

Does this have to be calculated by a query every time or is this count stored somewhere in the database per user like message/like/resource_count?

 

[Paul B]

It's stored in the xf_resource_version table.

 

[hotdoghero]

Sorry, to clarify, I'm trying to get the number of ratings/reviews a user has given for the purposes of trophies/promotion criteria.

 

[Chris D]

That isn't stored anywhere, if it was then it'd be in the xf_user table like resource_count.