BuddyPress.org

I’m looking to do something similar. I want to sort members by who has the most points. Any direction would be helpful.

Here is the sql when points are logged:

‘ global $wpdb;
$wpdb->query(“INSERT INTO `”.CPDB.”` (`id`, `uid`, `type`, `source`, `points`, `timestamp`)
VALUES (NULL, ‘”.$uid.”‘, ‘”.$type.”‘, ‘”.$source.”‘, ‘”.$points.”‘, “.time().”);”);’