function getOverallUserRating($pUserId)
{
$ret = array();
if (@BitUser::verifyId($pUserId) && $pUserId > 0) {
global $gBitSystem;
$bindVars = array($pUserId);
$query = "SELECT sth.`rating`, COUNT( sth.`rating`) AS `rating_count`, SUM( sth.`weight` ) AS `weight`\n\t\t\t\tFROM `" . BIT_DB_PREFIX . "liberty_content` lc\n\t\t\t\tLEFT JOIN `" . BIT_DB_PREFIX . "liberty_content_history` lch ON( lch.`content_id`=lc.`content_id` )\n\t\t\t\tLEFT JOIN `" . BIT_DB_PREFIX . "stars_history` sth ON( sth.`content_id`=lc.`content_id` )\n\t\t\t\tWHERE sth.`version` != 0 AND lch.`user_id`=?\n\t\t\t\tGROUP BY sth.`rating`";
$summary = $this->mDb->getAll($query, $bindVars);
list($rating, $rating_count) = $this->calculateRatingFromSummary($summary);
$ret['stars_rating'] = $rating;
$ret['stars_rating_count'] = $rating_count;
$normalized_rating = $this->normalizeRating($rating);
$ret['stars_pixels'] = $normalized_rating * $gBitSystem->getConfig('stars_icon_width', 22);
$ret['stars_load'] = TRUE;
}
return $ret;
}
