blob: 70bc64642597fad0be86e4f2ea3c30f7fd41deff (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php
global $b_user;
$guest_user = array(
'id' => 0,
);
if (empty($_COOKIE[$b_config['c_name']]) || !preg_match('/^(\d+);([0-9a-zA-Z\.]+)$/', $_COOKIE[$b_config['c_name']], $matches)) {
$b_user = $guest_user;
}
else {
$db = new bdb();
$result = $db->query('SELECT users.*, SUM(ratings.stars) / COUNT(ratings.stars) AS rating, COUNT(notif.id) AS notif FROM users LEFT JOIN ratings ON ratings.rated = users.id LEFT JOIN notif ON notif.uid = users.id AND notif.seen = 0 WHERE users.id = '.intval($matches[1]).' AND users.session = \''.bulletin_hash($matches[2]).'\' AND users.active = 1 GROUP BY users.id LIMIT 1') or fatal($db->error);
if ($result->num_rows < 1) $b_user = $guest_user;
else $b_user = $result->fetch_assoc();
$result->free();
$db->close();
}
?>
|
