$query = "SELECT user_id, AVG(points) pointsa, AVG(`precision`) preca FROM #__jtips_history " . "WHERE round_id IN ('" . implode("', '", $rids) . "') GROUP BY user_id ";
if ($params->get('type') == 'worst') {
$query .= " ORDER BY pointsa ASC, preca DESC, RAND()";
} else {
$query .= " ORDER BY pointsa DESC, preca ASC, RAND()";
}
//jTipsDebug($query);
$database->setQuery($query, 0, 1);
$result = $database->loadAssocList();
if (!empty($result) and count($result)) {
$row = array_shift($result);
$jTipsUser = new jTipsUser($database);
//jTipsDebug($row);
$jTipsUser->load($row['user_id']);
//get the user avator if enabled
$name = $jTipsUser->getName();
if ($params->get('socimage')) {
if ($params->get('socimage') == 'cb') {
// Link is to CB Pofile
$img = getCommunityBuilderAvatar($jTipsUser->user_id);
$link = "index.php?option=com_comprofiler&task=userProfile&user=" . $jTipsUser->user_id;
} else {
if ($params->get('socimage') == 'js') {
$img = getJomSocialAvatar($jTipsUser->user_id);
$link = getJomSocialProfileLink($jTipsUser->user_id);
}
}
$alt = $name;
if (!empty($img)) {
?>
<div style='text-align:center;'>
