From 4f12fecebcd3f2a5bc6a0e7cdf9c420af4ed435a Mon Sep 17 00:00:00 2001
From: Carson Fleming <cflems@cflems.net>
Date: Thu, 16 Feb 2017 23:59:34 -0500
Subject: Did the profile

---
 inc/user.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'inc/user.php')

diff --git a/inc/user.php b/inc/user.php
index 789586f..cf0dde8 100644
--- a/inc/user.php
+++ b/inc/user.php
@@ -9,7 +9,7 @@ if (empty($_COOKIE[$b_config['c_name']]) || !preg_match('/^(\d+);([0-9a-zA-Z\.]+
 }
 else {
   $db = new bdb();
-  $result = $db->query('SELECT * FROM users WHERE id = '.intval($matches[1]).' AND session = \''.hash('sha512', $matches[2]).'\' AND active = 1 LIMIT 1') or fatal($db->error);
+  $result = $db->query('SELECT users.*, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM users LEFT JOIN ratings ON ratings.rated = users.id WHERE users.id = '.intval($matches[1]).' AND users.session = \''.hash('sha512', $matches[2]).'\' AND users.active = 1 LIMIT 1') or fatal($db->error);
   if ($result->num_rows < 1) $b_user = $guest_user;
   else $b_user = $result->fetch_assoc();
   $result->free();
-- 
cgit v1.2.3