Title: Points question
Last modified: July 3, 2019

---

# Points question

 *  Resolved [mikecrf121](https://wordpress.org/support/users/mikecrf121/)
 * (@mikecrf121)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/)
 * So i Have a site where i have every major sport and challenges for each.
    so 
   each challenge for say football will have 50 winners and 1st gets more points
   then 2nd and so on. I then want these points to count towards an over all leaderboard
   so im thinking ill need a point sytstem for each sport, but then have all those
   5 different point types add up into overall points.
 * These point types will be used to calculated 1.leaderboard for each sport.
    and
   2. overall leaderboard for all sport points combined.
 * Can this be done with this point system/plugin??

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Thread Starter [mikecrf121](https://wordpress.org/support/users/mikecrf121/)
 * (@mikecrf121)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11702194)
 * actually figured out how to do this :).
    so this will give leaderboard for whatever
   pointsspecifically, or a combination you want. hope this helps people as well.
 *  SELECT
    row_number() OVER (ORDER BY score DESC) AS ‘Rank’, users.`user_nicename`
   AS User, SUM(*********usermeta.`meta_value`) AS ‘Score’ FROM ***********usermeta
   INNER JOIN ******users ON *********usermeta.`user_id` = *********users.`ID` WHERE
   1=1 AND **********usermeta.`meta_key` = ‘mycred_default’ //use only this for 
   just 1 point type OR ***********usermeta.`meta_key` = ‘mycred_winnings’//keep
   adding point types to include in overall points combined total GROUP BY User
 *  Plugin Author [WPExperts.io](https://wordpress.org/support/users/wpexpertsio/)
 * (@wpexpertsio)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11702299)
 * Hi [@mikecrf121](https://wordpress.org/support/users/mikecrf121/),
 * Glad to hear that you were able to figure out the solution to your problem. We
   also appreciate you sharing the solution for others.
 * Kindly feel free to contact us again with any query regarding our plugin.
 * Thanks!
 *  Thread Starter [mikecrf121](https://wordpress.org/support/users/mikecrf121/)
 * (@mikecrf121)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11705126)
 * correction to my solution for all point type leaderboard
    SUM(CAST(usermeta.`
   meta_value`AS INT)) AS ‘Score’
 *  [fimo66](https://wordpress.org/support/users/fimo66/)
 * (@fimo66)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11706768)
 * [@mikecrf121](https://wordpress.org/support/users/mikecrf121/)
    Thanks for sharing
   and i will test soon on my site… have a nice evening
 *  Plugin Author [WPExperts.io](https://wordpress.org/support/users/wpexpertsio/)
 * (@wpexpertsio)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11710389)
 * Hi there,
 * Thank you for updating.
 * Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Points question’ is closed to new replies.

 * ![](https://ps.w.org/mycred/assets/icon-128x128.gif?rev=3512531)
 * [Points Management System For Gamification, Ranks, Badges, and Loyalty Rewards Program - myCred](https://wordpress.org/plugins/mycred/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mycred/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mycred/)
 * [Active Topics](https://wordpress.org/support/plugin/mycred/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mycred/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mycred/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [WPExperts.io](https://wordpress.org/support/users/wpexpertsio/)
 * Last activity: [6 years, 11 months ago](https://wordpress.org/support/topic/points-question/#post-11710389)
 * Status: resolved