Hi guys, I wanted to ask which table stores the number of posts by a user? What I wanted to do is to write a custom code to determine the top 5 contributors (5 most number of posts) into the homepage of the website.
Or is there a built in feature (i.e. shortcode) to display users with the most contributions?
Hi @janvillaroel,
On this page: https://wpforo.com/participants/, all members are displayed with ordering based on the most posts created.
For the database table, the information about profiles can be found in the `wp_wpforo_profiles` table.
Or you can request a custom widget from our Pro Support Team.
https://wpforo.com/pro-support/
@blackraz Thank you so much for your response.
It's okay. I can create myself a custom plugin for this.
In wp_wpforo_profiles, is the points column refer to reputation points? What is custom points? Do we have a documentation for these columns and tables so i could just look over.
Hi @janvillaroel
Sorry, but there is no specific documentation for the database tables. However, the table columns are logical and can describe what data they store. Regarding points, it is used for reputation and calculated using various data such as posts, topics, reactions, etc.
