$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;'>