it works fine, but can you make it so the username links to their website field on their profile. i know basic sql, but not enough to edit what you have. http://www.massbase.com - on the bottom right on the sidebar.. its all their. I got the rep points linking to their profiles fine, but i need to make the usernames link their websites.
<?php
global $bbdb;
$results=$bbdb->get_results("SELECT user_login as name,meta_value as reputation FROM $bbdb->usermeta LEFT JOIN $bbdb->users ON ID=user_id WHERE meta_key='bb_reputation' ORDER BY CAST(meta_value as UNSIGNED) DESC LIMIT 10");
foreach ($results as $result) {echo "$result->name(<a style='font-weight: bold; color: black;' href='http://www.massbase.com/profile/$result->name'>$result->reputation</a>) , ";}
?>
thanks
