Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+5 votes
in Q2A Core by
I want to create a page on the site with php, to display the method of calculating points on the site from the database

1 Answer

+1 vote

I guess the admin/points section has all the needed information. Just take the number you've set for each category, multiply it by the multiplier at the bottom, add the initial points and the bonus per user (those are set while editing the user profile). That should be it.

The values for each user are stored in the ^userpoints table. Note the points column is used to hold the resulting value of applying the calculation.

The multiplier and initial points can be fetched from the ^options table. Check the options points_multiple and points_base.

I want to show the point table to the visitor