- ';
foreach ($likedusers as $item)
{
echo '
- ', $item['link'], ' '; } echo '
global $scripturl, $smcFunc, $txt, $days, $modSettings;
// Configuration
// Specify number of days for likes and number of users to show
$days = '365';
$max = '10';
$showtitle = 'Y';
// End Config
// get the likes
loadLanguage('Stats');
// Liked users top X.
$max_liked_users = 1;
$request = $smcFunc['db_query']('', '
SELECT m.id_member AS liked_user, COUNT(l.content_id) AS count, mem.real_name
FROM {db_prefix}user_likes AS l
INNER JOIN {db_prefix}messages AS m ON (l.content_id = m.id_msg)
INNER JOIN {db_prefix}members AS mem ON (m.id_member = mem.id_member)
WHERE content_type = {literal:msg}
AND like_time > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL {int:days} DAY))
AND m.id_member > {int:zero}
GROUP BY m.id_member, mem.real_name
ORDER BY count DESC
LIMIT {int:max}',
array(
'no_posts' => 0,
'zero' => 0,
'days' => $days,
'max' => $max,
)
);
$likedusers = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$likedusers[] = array(
'id' => $row['liked_user'],
'num' => $row['count'],
'href' => $scripturl . '?action=profile;u=' . $row['liked_user'],
'name' => $row['real_name'],
'link' => '' . $row['real_name'] . '',
);
if ($max_liked_users < $row['count'])
$max_liked_users = $row['count'];
}
$smcFunc['db_free_result']($request);
foreach ($likedusers as $i => $request)
$likedusers[$i]['percent'] = round(($request['num'] * 100) / $max_liked_users);
// output the likes
echo '
';
if ($showtitle == 'Y')
echo '
';
echo '
';
foreach ($likedusers as $item)
{
echo '
-
', $item['link'], '
';
}
echo '
';