Quote:
Originally Posted by Ipuck
I have the same problem. No answer from the coder :erm:. No post from coder since 3/25  |
well it looks like you won't get any help from the developer so...
I think you have the same problem I did,you have usergroups that you created other than the default "registered members" group
you need to define these groups in the memberidex.php
file of the addon
Open memberidex.php and look for the lines // Week's Top Posters // Month's Top Posters and // Overall Top Posters under those lines you will find
PHP Code:
WHERE usergroupid=2
now you wanna add the groupids of your custom groups
like this
PHP Code:
WHERE usergroupid=2 OR usergroupid=x OR usergroupid=x
replace the x's with the ids of your groups,you can find the group id by going in your admin cp and navigating to "Usergroups/Usergroup Manager"
save the file and reupload it and it should now show the posters from all your groups
here's what mine looks like,hope this helps
PHP Code:
// Week's Top Posters
if ($vbulletin->options[micromembers_week] == '1') {
$timelimit = time() - 7 * 24 * 60 * 60;
$mostactiveweek_get = $db->query_read("
SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle,
COUNT(".TABLE_PREFIX."post.postid) AS postcount
FROM ".TABLE_PREFIX."user
LEFT JOIN ".TABLE_PREFIX."post
ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid
AND dateline>$timelimit
WHERE usergroupid=2 or usergroupid=2 or usergroupid=5 or usergroupid=6 or usergroupid=7 or usergroupid=8 or usergroupid=11 or usergroupid=12
GROUP BY ".TABLE_PREFIX."user.userid
ORDER BY postcount DESC
LIMIT $limit");
$users = array();
while($user = $db->fetch_array($mostactiveweek_get))
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>$timelimit");
$mostactiveusersweek = printUsers($users, $vbulletin->options['micromembers_week_text'], 2, $totalposts['postcount']);
unset($users);
}
// Month's Top Posters
if ($vbulletin->options[micromembers_month] == '1') {
$timelimit = time() - 30 * 7 * 24 * 60 * 60;
$mostactivemonth_get = $db->query_read("
SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle,
COUNT(".TABLE_PREFIX."post.postid) AS postcount
FROM ".TABLE_PREFIX."user
LEFT JOIN ".TABLE_PREFIX."post
ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid
AND dateline>$timelimit
WHERE usergroupid=2 or usergroupid=2 or usergroupid=5 or usergroupid=6 or usergroupid=7 or usergroupid=8 or usergroupid=11 or usergroupid=12
GROUP BY ".TABLE_PREFIX."user.userid
ORDER BY postcount DESC
LIMIT $limit");
$users = array();
while($user = $db->fetch_array($mostactivemonth_get))
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>$timelimit");
$mostactiveusersmonth = printUsers($users, $vbulletin->options['micromembers_month_text'], 2, $totalposts['postcount']);
unset($users);
}
// Overall Top Posters
if ($vbulletin->options[micromembers_overall] == '1') {
$mostactive_get = $db->query_read("
SELECT userid, username, usertitle, posts AS postcount
FROM ".TABLE_PREFIX."user
WHERE usergroupid=2 or usergroupid=2 or usergroupid=5 or usergroupid=6 or usergroupid=7 or usergroupid=8 or usergroupid=11 or usergroupid=12
ORDER BY posts DESC
LIMIT $limit");
$users = array();
while($user = $db->fetch_array($mostactive_get))
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post");
$mostactiveusers = printUsers($users, $vbulletin->options['micromembers_overall_text'], 2, $totalposts['postcount']);
unset($users);
}
More Information