Forum Members (membelist.php)

[BirdOPrey5]

Further Development by BirdOPrey5
www.Qapla.com (http://www.qapla.com/mods/)

Previous Development by ChrisTERiS

1.- What's this?

This AddOn replaces the file memberlist.php and shows this list in a better interface and adds more features in the listing (mostly in the PRO version). Please note, that as I said before, there is a replacement of the original memberlist.php, so in case that you want to revert back, you must re-upload this file from your vB distribution. Also after any vB upgrade you need to re-upload my memberlist.php (just re-upload, no re-importing the xml file).



2.- Features
Homepage with the following blocks
Meet Our Admins
2nd Same Block to promote another usergroup (PRO version only)
Top Rated Members (PRO version only)
Top Posters Last Week
Top Posters Last Month
Top Posters Overall
Just Join Us
*** All blocks can be turn On/Off and also you can change the title
Search Members
Username
Location
Join date
Posts
Age (PRO version only)
Points (PRO version only)
Infractions (PRO version only)
Aim, Icq, Msn, Yahoo, Skype (PRO version only)
For Messaging the search works like "Has Aim, Has Icq" and not as the native vB Search where you can search only for a specific account.
Rate This Member (PRO version only)
Contact Member
Email
PM
Add to Buddy
Send Friend Request
Aim, Icq, Msn, Yahoo, Skype (PRO version only)
Show Avatar or Image
Show Online Status
Reputation (PRO version only)
Featured Members (Different background color) (PRO version only)3.- Installation
Upload all files in upload directory to your forum directory
Import product-forummembers.xml
Goto Forum Member Setting and set them as you like
Click "Usergroups" (Forum Members Menu) and select which usergroups you want to show (Hold Ctrl + Click for multi select).
Goto vB Usergroup permissions and set them accordinally.4.- Copyright

This mod is an upgrade of Mary's MemberIndex for which I've got the rights. Copyright removal is phohibited (PRO version does not has copyright link).

5.- Demo (PRO version) (http://www.christeris.com/testvb4/memberlist.php)


Chris

[kfyonur]

i am there :)

[sadiq6210]

Wow
Awesome Chris, really awesome

I will try it

First Installed + 5 stars =)

[blue6995]

Where can I get the Pro version?

[Paul M]

Very nice.
Not something I will personally use but nevertheless, nominated for motm.

[Christos Teriakis]

Very nice.
Not something I will personally use but nevertheless, nominated for motm.

Pitty that you'll not use it:erm: Well I think that memberlist is the only part of vBulletin that never has been retouched. All other sections appear so nicelly except this.

Chris

[Christos Teriakis]

Where can I get the Pro version?

http://www.christeris.com/cart.php

Edited: If it doesn't works, please wait a bit as I want to revert to an earlier version of the cart.

Thank you
Chris

[Mark.B]

Looks very nice.

My only comment would be, it needs an option to simplify it so that (a) it just goes straight to the actual member list and (b) it can show all members in one view, not split by usergroup. A lot of sites like mine have usergroup names kept private, they are never exposed in the public UI and members generally don't know they exist.

I can probably hack it to be like that myself but I think it'd be a useful option to have.

[Christos Teriakis]

(b) it can show all members in one view, not split by usergroup. A lot of sites like mine have usergroup names kept private, they are never exposed in the public UI and members generally don't know they exist.

I can probably hack it to be like that myself but I think it'd be a useful option to have.

There is an option to admincp to specify which usergroup(s) you want to show. So its up to you to not include your special usergroups.

Chris

[Mark.B]

There is an option to admincp to specify which usergroup(s) you want to show. So its up to you to not include your special usergroups.

Chris
Thanks...is there an option to just show all off them though? That's really what I'd need to do.
Aside from admin/mod, we use usergroups to restrict permissions to certain types of member and this is done entirely back-end, there's no public visibility of the fact the groups exist, nor who is in them.

Though as I say (without seeing the code) I reckon I can fairly easily hack this in.

[Christos Teriakis]

Thanks...is there an option to just show all off them though? That's really what I'd need to do.
Aside from admin/mod, we use usergroups to restrict permissions to certain types of member and this is done entirely back-end, there's no public visibility of the fact the groups exist, nor who is in them.

Though as I say (without seeing the code) I reckon I can fairly easily hack this in.

Try the attached file. Haven't checked it, but it should works.

Chris

[qpurser]

Another excellent mod from you Chris.

Your link to the PRO version gives an error...

When I look at my memberlist the "username" is white and when hovering over it it turns black.
Where can I change the color of the username text (white) to another color as the white one is not visible?

[Scalemotorcars]

Chris your e-shop seems to have bitten the dust.

[Christos Teriakis]

Chris your e-shop seems to have bitten the dust.

Fixed :D The direct link is:
http://www.christeris.com/cart.php?do=viewproduct&productid=1

Chris

[Christos Teriakis]

Another excellent mod from you Chris.

Your link to the PRO version gives an error...

When I look at my memberlist the "username" is white and when hovering over it it turns black.
Where can I change the color of the username text (white) to another color as the white one is not visible?

You need to check the stylevar: blocksubhead

Chris

[Phil K?vin]

Very nice.

[Mark.B]

Try the attached file. Haven't checked it, but it should works.

Chris
Thank you...I shall have a play with this tonight/tomorrow and report back.

[Davey-UK]

I dont see the search function?

[Gemma]

I dont see the search function?

Usergroup Settings.

Uninstalled it just now, very buggy. The default avatar (noavatar.gif) path is broken, the alphabetic username search doesn't work and the pagination doesn't work either - it redirects you to forumhome. Also the css for my header (logo/login toplinks) and navbar is broken when viewing the memberlist.php

[Mark.B]

Usergroup Settings.

Uninstalled it just now, very buggy. The default avatar (noavatar.gif) path is broken, the alphabetic username search doesn't work and the pagination doesn't work either - it redirects you to forumhome. Also the css for my header (logo/login toplinks) and navbar is broken when viewing the memberlist.php

Agreed, I have uninstalled for now.

Main issues are as above - Alphabetic bar is not working and the same for the pagenav - both just lead to white pages.

Very promising though. I had it looking pretty decent, but only the first page would display.

[Christos Teriakis]

Usergroup Settings.

Uninstalled it just now, very buggy. The default avatar (noavatar.gif) path is broken, the alphabetic username search doesn't work and the pagination doesn't work either - it redirects you to forumhome. Also the css for my header (logo/login toplinks) and navbar is broken when viewing the memberlist.php

Anything has bugs. What makes the difference is the time to fix them. In less than 45min, I just released a fix for:

1.- Wrong avatar path
2.- Pagination wrong link
3.- Sorry I was unable to reproduce your report for wrong Letter search. For me works.
4.- As for your special style, as I seen you're designer. Just include the css to the head section of forummembers_index template and everything should be ok.

Chris

[Mark.B]

Anything has bugs. What makes the difference is the time to fix them. In less than 45min, I just released a fix for:

1.- Wrong avatar path
2.- Pagination wrong link
3.- Sorry I was unable to reproduce your report for wrong Letter search. For me works.
4.- As for your special style, as I seen you're designer. Just include the css to the head section of forummembers_index template and everything should be ok.

Chris
Chris I can also reproduce the letter issue...clicking a letter gives me a white blank page.

[Christos Teriakis]

Chris I can also reproduce the letter issue...clicking a letter gives me a white blank page.

Could you please copy the URL of the blank page. eg in my installation is:
memberlist.php?do=usergrouplisting&ltr=N&groupid=2&pagenumber=1
and works fine.

Chris

[Mark.B]

Could you please copy the URL of the blank page. eg in my installation is:
memberlist.php?do=usergrouplisting&ltr=N&groupid=2&pagenumber=1
and works fine.

Chris
My URLs are the same, I verified them against the demo. But I just get blank pages, same with the pagenav.

[Christos Teriakis]

Chris I can also reproduce the letter issue...clicking a letter gives me a white blank page.

Opssss..... if you're talking for the special file that I post for you, I need to check it again, as I've renamed the usergrouplisting procedure as "main".

Chris

[Mark.B]

Opssss..... if you're talking for the special file that I post for you, I need to check it again, as I've renamed the usergrouplisting procedure as "main".

Chris
Thanks Chris...I can probably make the changes myself (I have already customised the file) if you point me in the right direction.

[Christos Teriakis]

Thanks Chris...I can probably make the changes myself (I have already customised the file) if you point me in the right direction.

Hello Mark,

Please don't get me wrong, there is no intention to underestimate your experiance to modify the file, but its easier for me to make the changes than to write instructions on how to do it. Actually there were lots of changes.

Please upload the attached file. Also import the xml file to remove the usergroup block from the template.

Chris

[thecore762]

Very nice mod, I'd love to use, but most likely it's not going to work for me.

[doctorsexy]

Very nice ..but not showing top posters only 0 posters and how do i select more than 1 usergroup in the Acp..

[mgcom]

Nominated - 5 Stars

Any plans for Maria's old newsletter Chris ?

I like the idea of this one, sadly it never worked or got support

https://vborg.vbsupport.ru/showthread.php?t=269620

It pulls all the info from VB into the newsletter - which saves a lot of time putting a newsletter together

Cheers Chris

[Mark.B]

Hello Mark,

Please don't get me wrong, there is no intention to underestimate your experiance to modify the file, but its easier for me to make the changes than to write instructions on how to do it. Actually there were lots of changes.

Please upload the attached file. Also import the xml file to remove the usergroup block from the template.

Chris
Thanks Chris, with some tweaking I think I have this how I'd like it now...

http://www.bowlandcentral.com/forum/memberlist.php

Obviously the templates are tweaked somewhat, mine always are. :)

Only thing I can't get working is the online status of each user. Nothing seems to show, even when I used the default template.

[Christos Teriakis]

Nominated - 5 Stars

Any plans for Maria's old newsletter Chris ?

I like the idea of this one, sadly it never worked or got support

https://vborg.vbsupport.ru/showthread.php?t=269620

It pulls all the info from VB into the newsletter - which saves a lot of time putting a newsletter together

Cheers Chris

Hello Mark,

Nice to see you again. There is a post about Mary's ForoMail in my site:
http://www.christeris.com/entry.php?1-ForoMail-Retouch

Take care
Chris

[TheChief]

Hey

I've downloaded and added this to my forum

It appears that when i select the top posts etc etc it only seems to pull the data from the registered users group not my other usergroups that i have created therefore it is saying that the top poster has 14 posts....the top poster actually has 2800 (ish) posts

Help please

[Christos Teriakis]

Hey

I've downloaded and added this to my forum

It appears that when i select the top posts etc etc it only seems to pull the data from the registered users group not my other usergroups that i have created therefore it is saying that the top poster has 14 posts....the top poster actually has 2800 (ish) posts

Help please

Yes, you're right. The Top poster are counting only from the register usergroup for a simple reason. Always the usergroups Administrators and Moderators are those which are having the most posts, so it has no sense to show as Top posters these usergroups.
In any case I'm planing to add a feature to select which usergroups to search for counting the Top posters.

Chris

[DEREKTROTTER]

I'm not sure why, but the search option doesn't seem to be showing up for me. Do you know why?

[Mark.B]

I have now completed my work, using this to turn my memberlist into a sexy beast!
http://www.bowlandcentral.com/forum/memberlist.php

My only small concern is that this mod is very heavy on queries. I have 32 members per page and it's 138 queries.
Other than that it's great.

[CharlieDelta]

I have now completed my work, using this to turn my memberlist into a sexy beast!
http://www.bowlandcentral.com/forum/memberlist.php
Very nice!:up:
I would also like to have the memberlist open up to a specific usergroup but also have the usergroup menu.

[laebshade]

Slow and buggy. Removed.

[qpurser]

I have now completed my work, using this to turn my memberlist into a sexy beast!
http://www.bowlandcentral.com/forum/memberlist.php

My only small concern is that this mod is very heavy on queries. I have 32 members per page and it's 138 queries.
Other than that it's great.

WOW... Really nice work!!
Maybe you share the code changes you made? :)

[RedPoint]

http://www.bowlandcentral.com/forum/memberlist.php


Wow, how you make this?

[zchartouni]

Great Mod! Would love to be able to search by custom profile fields as with the original member list.. But definitely a great upgrade from the stock list.

[Christos Teriakis]

I have now completed my work, using this to turn my memberlist into a sexy beast!
http://www.bowlandcentral.com/forum/memberlist.php

My only small concern is that this mod is very heavy on queries. I have 32 members per page and it's 138 queries.
Other than that it's great.

When I'll have some free time I'll change the way that queries work. This in no way means that the queries that Mary used are wrong. I'm just avoiding to use JOIN in queries, a command that can make a single query to be 5 or more. I've my own technique on this.

Chris

[SwollenCranium]

I have now completed my work, using this to turn my memberlist into a sexy beast!
http://www.bowlandcentral.com/forum/memberlist.php.

:eek:
You made the one shown in the link with THIS mod or the PRO version?

[zhai]

Tagged. Nice Hack!

Anyway, this thread's title is missing a letter:
"Forum Members (memberlist.php)" :p

[Mark.B]

WOW... Really nice work!!
Maybe you share the code changes you made? :)
Wouldn't really be practical, my site's styles are already heavily customised.
:eek:
You made the one shown in the link with THIS mod or the PRO version?
This is with the Lite version, using the alternative file Chris provided for me a little higher up (this removes the "landing" page and allows you to go straight to the full memberlist without a usergroup selector bar).

Then it's mainly some template edits to get the look and feel I wanted. I also added some code to the file to do such things as pulling my custom user fields through that power the username foreground and background colours and also the vBStatus text, altering the format of the date, adding times, and a few fairly minor tweaks.

Redesigned the advanced search box to match the normal vB4 dropdown menus, and created a dropdown pre-populated with common filters (this replicates the ability to click the column headers to change the sort order that was present on the old memberlist).

All in all I am pretty pleased with the result, the memberlist is a much neglected area of vB.

Once Chris sorts the queries out this will be very good, at the moment a *really* busy site would get hit with the queries this creates.

[SwollenCranium]

at the moment a *really* busy site would get hit with the queries this creates.

Indeed. I have a small site and had to uninstall this mod back when Mary had it because of the load.

Query fix will be welcome as the default vb member-list is a hideous monstrosity and has no place in a custom style.

[thientinh2110]

not good at vbb4.1.8

[thientinh2110]

Pro version, how do i have it?

[fluidswork]

Just awesome !!!

[datoneer]

4.1.8 not working, when i tried to click (example registered users list) nothing happend. I did set everything in usergroups

[Christos Teriakis]

4.1.8 not working, when i tried to click (example registered users list) nothing happend. I did set everything in usergroups

Any link to check it?

[Christos Teriakis]

Pro version, how do i have it?

http://www.christeris.com

Chris

[SwollenCranium]

http://www.christeris.com

Chris
Yeah.

Never mind. />?:)

[Alfa1]

My only small concern is that this mod is very heavy on queries. I have 32 members per page and it's 138 queries.
Other than that it's great.

When I'll have some free time I'll change the way that queries work. This in no way means that the queries that Mary used are wrong. I'm just avoiding to use JOIN in queries, a command that can make a single query to be 5 or more. I've my own technique on this.
That would be very nice. I installed the 3.8 version on my big board and it repeatedly crashed my site due to the slow queries and the massive number of queries. It was a very problematic addon performance wise.

The functionality is very nice, so I was disappointed that I could not use it.

[GameOverViper]

This looks nice! Do I have any way of adding the Xbox LIVE Gamercards to this style memberlist like I have here (http://www.revolutionofgaming.com/forum/members/list/)? Maybe in the Pro version?

[Christos Teriakis]

Yeah.

Never mind. />?:)

Sure there is. It's a commercial site and I don't like everyone to have access to my members. That's why, when my site should be totally ready, not even the standard memberlist will be there.

Chris

[Christos Teriakis]

That would be very nice. I installed the 3.8 version on my big board and it repeatedly crashed my site due to the slow queries and the massive number of queries. It was a very problematic addon performance wise.

The functionality is very nice, so I was disappointed that I could not use it.

Programming is a very strange job. You can do the same thing in several ways and all of them to be correct, but at the same time to have their bad points. Let me explain:

1.- About Rating. The current way of use (and most used among programmers) is to store ratings in a seperate file, saving there the userid, the raterid and the rating. That's good. But when it comes to show the rating you must add one more query to check that table. Especially in this case the query is more heavy as it not looks for a single records, but for all records with userid=xxx and then calculate the average. Imagine that this way the queries must be execute even for users who have none rating. My way is different. I'll add in user table 3 more fields: Votes, Rating, Voters. When someone posts a rating it will calculate at THAT time the average rating. What you'll solve with this way. No extra query at all. Just print the rating value on the screen.

2.- Another point that I don't agree with the canonical programming has to do with showing "Rate him" instead of the rating (depending if you have rate him or not, or if you have permissions to rate or not), or a gray icon (eg contact) instead of the normal icon depending or your permissions to contact. Why? Let's say that I'm visiting your memberlist, just to see your members and nothing more. The system will perform a dozen of queries without any special reason. So my approach is: Show the rating, and ONLY if the visitor wants to rate the user, ONLY THEN perform the query to check if he has rated before or not, or if he has right to rate etc etc.

Chris

[SwollenCranium]

Sure there is. It's a commercial site and I don't like everyone to have access to my members. That's why, when my site should be totally ready, not even the standard memberlist will be there.

Chris

Yeah .. I DID say never mind.

Handle your business your way, killer !

Good luck to ya.

[datoneer]

Any link to check it?

http://www.imspot.org/members/list/

[Sarcoth]

I like the look of it. Not sure I would use on my site b/c I use the current memberlist now and then, but still a nice job. In the future, I would like to suggest you just make it a separate addon. Great job nonetheless.

[Alfa1]

Programming is a very strange job. You can do the same thing in several ways and all of them to be correct, but at the same time to have their bad points. Let me explain:

1.- About Rating. The current way of use (and most used among programmers) is to store ratings in a seperate file, saving there the userid, the raterid and the rating. That's good. But when it comes to show the rating you must add one more query to check that table. Especially in this case the query is more heavy as it not looks for a single records, but for all records with userid=xxx and then calculate the average. Imagine that this way the queries must be execute even for users who have none rating. My way is different. I'll add in user table 3 more fields: Votes, Rating, Voters. When someone posts a rating it will calculate at THAT time the average rating. What you'll solve with this way. No extra query at all. Just print the rating value on the screen.

2.- Another point that I don't agree with the canonical programming has to do with showing "Rate him" instead of the rating (depending if you have rate him or not, or if you have permissions to rate or not), or a gray icon (eg contact) instead of the normal icon depending or your permissions to contact. Why? Let's say that I'm visiting your memberlist, just to see your members and nothing more. The system will perform a dozen of queries without any special reason. So my approach is: Show the rating, and ONLY if the visitor wants to rate the user, ONLY THEN perform the query to check if he has rated before or not, or if he has right to rate etc etc.

Chris
That sounds sensible. I hope that the new version will be able to cope with thousands of concurrent users. Thanks.

[datoneer]

Can you update this to work with 4.1.8

[Jncocontrol]

I like the idea to change the Memer.php, But adding the usergroup in the top seems to defeat the point of showgroup.php

[tsac]

I'd sure like to use this for just one usergroup with all members on one page. Like a simple roster for 4.1.10 :erm:

[TombstoneWarrior]

someone post and let me know when all the bugs are worked out on this mod because i would like to have it on my forum.

[CharlieDelta]

The header image is not showing on my custom styles. It is shwoing fine on the default.

How can I fix this?

[solohdes]

Don't work for me. The usergropus buttons don't shows, I have 4.1.5.

http://www.todohd.net/members/list/

Can you take a look?

[TombstoneWarrior]

someone post and let me know when all the bugs are worked out on this mod because i would like to have it on my forum.?????

[Bulbucan]

Have a little problem here, up there with usergroups i see only text "Usergroups" nothing more like my usergroups

[Christos Teriakis]

Have a little problem here, up there with usergroups i see only text "Usergroups" nothing more like my usergroups

You must set which usergroups to show. Many sites are using private usergroups which they don't like to show them in public. So visit your admincp and you'll find an option "Usergroups" in Memberlist plugin. You can select multiple usergroups by holding down the Ctrl key and clicking on them.

Chris

[solohdes]

You must set which usergroups to show. Many sites are using private usergroups which they don't like to show them in public. So visit your admincp and you'll find an option "Usergroups" in Memberlist plugin. You can select multiple usergroups by holding down the Ctrl key and clicking on them.

Chris

Can you do a screen capture of this? I can't find.

[CharlieDelta]

The header image is not showing on my custom styles. It is shwoing fine on the default.

How can I fix this?

[CharlieDelta]

I sorted it out.

I added in the forummembers_index template{vb:raw headinclude_bottom}
Right below {vb:raw header}
So it should look like this <body>
{vb:raw header}
{vb:raw headinclude_bottom}
{vb:raw navbar}

[CharlieDelta]

I just realized you will also need to do the above ^ edit in the forummembers_search_results template as well.

[CharlieDelta]

If you are like me and have custom usergroups and your new members are not displaying in the "just joined us" section you will need to edit the usergroupid in the memberslist.php

Find
// Just Joined us
if ($vbulletin->options["forummembers_newest"] == '1') {
$newusers_get = $db->query_read("
SELECT userid, username, usertitle
FROM ".TABLE_PREFIX."user
WHERE usergroupid=xx OR FIND_IN_SET(xx, membergroupids)
ORDER BY joindate DESC
LIMIT $limit");
and edit the usergroupid (xx) in red to represent your custom usergroup.

[BadgerDog]

I was trying to look at (and locate) the PRO version, but when I click on the link, I get this? :confused:

Not Found

The requested URL /vb4/memberlist.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache Server at www.christeris.net Port 80

Regards,
Doug

[BadgerDog]

Installed with thanks ... :)

However, I'm confused ... :confused:

It shows our Top Overall Poster as a member with 1,400 posts ..

Yet, there's at least 8 members with higher post counts (one is at 5,000 posts) and they're not even listed?

PaulM's "Top Posters" mod shows the correct information and post counts.....

Am I missing something?

Thanks for any feedback ... :)

Regards,
Doug

[Christos Teriakis]

Installed with thanks ... :)

However, I'm confused ... :confused:

It shows our Top Overall Poster as a member with 1,400 posts ..

Yet, there's at least 8 members with higher post counts (one is at 5,000 posts) and they're not even listed?

PaulM's "Top Posters" mod shows the correct information and post counts.....

Am I missing something?

Thanks for any feedback ... :)

Regards,
Doug

The only that you're missing is that I found more reable to not include Admins/Moderators in top posters as they (by position) have always the highers posts. So, I'm showing there Top posters from usergroup 2 (registered members).

Chris

[Christos Teriakis]

I was trying to look at (and locate) the PRO version, but when I click on the link, I get this? :confused:



Regards,
Doug

Currently I haven't installed somewhere a demo for this mod.

Chris

[BadgerDog]

The only that you're missing is that I found more reable to not include Admins/Moderators in top posters as they (by position) have always the highers posts. So, I'm showing there Top posters from usergroup 2 (registered members).

Chris

Thanks Chris ... I understand ... :)

Is there somewhere in the plugins or code where I could add an "if usergroup = " type statement that would force it to include a specific set of usergroups for its calculations?

Appreciate your work ...

Regards,
Doug

[BadgerDog]

Currently I haven't installed somewhere a demo for this mod.

Chris

Thanks ...

Is there someplace I can go to buy the PRO version of this mod?

Regards,
Doug

[Christos Teriakis]

Thanks Chris ... I understand ... :)

Is there somewhere in the plugins or code where I could add an "if usergroup = " type statement that would force it to include a specific set of usergroups for its calculations?

Appreciate your work ...

Regards,
Doug

You need to edit memberlist.php. An example for Top posters last week (lines 219-240) is showing below:

// Week's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,6,8);
if ($vbulletin->options["forummembers_week"] == '1') {
$timelimit = time() - 7 * 24 * 60 * 60;
$mostactiveweek_get = $db->query_read("
SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM " . TABLE_PREFIX . "post AS post
JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'
GROUP BY post.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['forummembers_week_text'], 2, $totalposts['postcount']);
unset($users);
}
}


Hope that it helps.

Chris

[BadgerDog]

You need to edit memberlist.php. An example for Top posters last week (lines 219-240) is showing below:

// Week's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,6,8);
if ($vbulletin->options["forummembers_week"] == '1') {
$timelimit = time() - 7 * 24 * 60 * 60;
$mostactiveweek_get = $db->query_read("
SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM " . TABLE_PREFIX . "post AS post
JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'
GROUP BY post.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['forummembers_week_text'], 2, $totalposts['postcount']);
unset($users);
}
}


Hope that it helps.

Chris

It does Sir .. :)

Thank you ... very gracious of you to take the time to do this ...

Regards,
Doug

[BadgerDog]

Hi Chris ... :)
'
Ok, I made the changes, but now get this SQL error?

Did I miss something?

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM post AS post
JOIN user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN(Array) AND post.dateline>'1334411824'
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 4;

MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Request Date : Saturday, April 21st 2012 @ 09:57:03 AM
Error Date : Saturday, April 21st 2012 @ 09:57:04 AM
Script : http://www.xxxx.com/memberlist.php
Referrer : http://www.xxxx.com/index.php
IP Address : xx.xxx.xxx.xxx
Username : Tester
Classname : vB_Database
MySQL Version : 5.0.95

Thanks...

Regards,
Doug

By the way, here's the code the way I changed it...

// Week's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_week"] == '1') {
$timelimit = time() - 7 * 24 * 60 * 60;
$mostactiveweek_get = $db->query_read("
SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM " . TABLE_PREFIX . "post AS post
JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'
GROUP BY post.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['forummembers_week_text'], 2, $totalposts['postcount']);
unset($users);
}
}
// Month's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_month"] == '1') {
$timelimit = time() - 30 * 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 user.usergroupid IN($include_groups)
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['forummembers_month_text'], 2, $totalposts['postcount']);
unset($users);
}
// Overall Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_overall"] == '1') {
$mostactive_get = $db->query_read("
SELECT userid, username, usertitle, posts AS postcount
FROM ".TABLE_PREFIX."user
WHERE user.usergroupid IN($include_groups)
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['forummembers_overall_text'], 2, $totalposts['postcount']);
unset($users);
}

[Christos Teriakis]

Hello,

A new update (ver.1.2.0) is available for download. In this version there is an extra setting where you can set which usergroup(s) to include in the TOP's blocks. The earlier version was counting posts only from Registered Members (usergroupid=2).

To upgrade upload all the files and import product-forummembers.xml selecting to overwrite.

Chris

[Christos Teriakis]

Hi Chris ... :)
'
Ok, I made the changes, but now get this SQL error?

Did I miss something?



Thanks...

Regards,
Doug


From now on you don't need any custom changes as I added a new setting for this reason.

Chris

[Nirjonadda]

Where is PRO version link of this mod?

[Christos Teriakis]

Where is PRO version link of this mod?

http://www.vbulleton.com

Chris

[BadgerDog]

From now on you don't need any custom changes as I added a new setting for this reason.

Chris

Thank you Chris ... :)

Excellent addition for us... appreciate it ...

Do you have PayPal?

Regards,
Doug

[Christos Teriakis]

Thank you Chris ... :)

Excellent addition for us... appreciate it ...

Do you have PayPal?

Regards,
Doug

Thank you Doug,

Actually, I have only PayPal:D

Chris

[BadgerDog]

Anyone else not seeing background color highlighting when a user is Featured?

Also anyone know how the Administrator can EDIT user ratings, if someone makes an incorrect entry?

Thanks for any feedback ... :)

Regards,
Doug

[faisaly.com]

Mod does not work showing any usergroups on top, breaks up the borders badly and you cannot disable this mod.... have to uninstall I guess... Hope it all works out for ya...Also anyone that is going to try this backup your memberlist.php before installing so if you do uninstall you can reupload or you won't display a thing...

[Tyran1]

Please this for 3.8.7

[Christos Teriakis]

Mod does not work showing any usergroups on top, breaks up the borders badly and you cannot disable this mod.... have to uninstall I guess... Hope it all works out for ya...Also anyone that is going to try this backup your memberlist.php before installing so if you do uninstall you can reupload or you won't display a thing...

Mods works fine, if you select from admincp which usergroups to show on the top. Mod can be disable or uninstall, just keeep in mind that you need to upload the original (vB) memberlist.php.

Chris

[megabink]

I can confirm that the mod works perfectly on my forum.(4.1.12)
It has some small bugs but it's not the mods fault it's the custom style i am using but i can live with that.
You can see for your self: http://www.megathemer.x10.mx
Thanks Chris for your hard work.

[Christos Teriakis]

I can confirm that the mod works perfectly on my forum.(4.1.12)
It has some small bugs but it's not the mods fault it's the custom style i am using but i can live with that.
You can see for your self: http://www.megathemer.x10.mx
Thanks Chris for your hard work.

Thank you for your supporting words. Have told many times that unfortunatelly my knowledge in design is average or even lower. I visited your site and I seen the cyan border around the blocks. Its my mistake as I've used hand coded color.

I think that I need to find a designer for correcting my mods. I don't even like to see such bad color combinations.

Edited: I also found some phrases missing (eg Join at). I think that I need to give a look on it.

Chris

[megabink]

Thank you for your supporting words. Have told many times that unfortunatelly my knowledge in design is average or even lower. I visited your site and I seen the cyan border around the blocks. Its my mistake as I've used hand coded color.

I think that I need to find a designer for correcting my mods. I don't even like to see such bad color combinations.

Edited: I also found some phrases missing (eg Join at). I think that I need to give a look on it.

Chris

Thanks Chris.
It would be nice to fix some bugs,but like I told you before I can live with it.
So no worries mate,we have to remember that the most mods are free and that we have to be happy for it.

[Christos Teriakis]

we have to remember that the most mods are free and that we have to be happy for it.

Free doesn't gives me the excuse to deliver rubishes. Some missing features, yes is acceptable. But features that I'm including, I want them to work perfectly.

Chris

[megabink]

Free doesn't gives me the excuse to deliver rubishes. Some missing features, yes is acceptable. But features that I'm including, I want them to work perfectly.

Chris
Yes i understand Chris i am also a perfectionist.
But in the meantime we have a working mod and updates are to improve things.
I am sure you will find a solution to fix the borders and the phrases in the next update.
Grt John.

[faisaly.com]

Mods works fine, if you select from admincp which usergroups to show on the top. Mod can be disable or uninstall, just keeep in mind that you need to upload the original (vB) memberlist.php.

Mod does not work fine, no usergroups showed using vb4.1.11, borders and styles missing, and could not disable... and yes free is free... but if it causes user problems... or messes up the forum and a users work... no one will be happy... please change the title of this mod to (beta) or do not release....

Thank You...

[Christos Teriakis]

Mod does not work fine....

First of all, I'll appreciate if don't use bold letters. I can read normal fonts fine.
Second. This mod works with ALL versions of 4x. Has released by Mary juts 10 days of the first release of 4.0.0. So, it's not a version problem.

Check if the usergroups that you've selected have been saved. As for disabling. It depends on what you want to see. If you just disable it WITHOUT UPLOADING the original vB memberlist.php for sure you'll see it again because memberlist.php is a file that must exist in you directory. If you've uploaded the original vB file and still you're seeing the screens of my mod, just clear your browser's cache.

As for the styling issues. Is it compatible with vB Default style? If yes, and you want it to appear ok with your custom template, then contact your designer or company from where you bought it.

Thank you
Chris

[BirdOPrey5]

Hello All,

I will be taking over this mod for ChrisTERiS. I am investigating how it will best work, I may end up starting my own mod thread with a slightly updated version in the next few days.

Please stand by while I figure out the logistics.

Thank you again to ChrisTERiS for this great mod!

[BadgerDog]

Thanks Joe ... :)

I use and like it, but it has some rough edges ...

Regards,
Doug

[pantani]

i have problem 4.2
I only see the letters, but when i click on a letter to see the members, nothing happens?

https://vborg.vbsupport.ru/external/2012/06/24.png

[Christos Teriakis]

i have problem 4.2
I only see the letters, but when i click on a letter to see the members, nothing happens?


Have you set which usergroups to show? You can find it in admincp below the General settings (left side menu).

Chris

[pantani]

Yes i have, but still nothing :(
Can't see any member?

[pantani]

i uninstalled and reinstalled, but now i get this:
But no index with letters to look for members:

https://vborg.vbsupport.ru/external/2012/06/23.png

[Christos Teriakis]

i uninstalled and reinstalled, but now i get this:
But no index with letters to look for members:


The letter index appears only when you click in any of the usergroups. But I can't see the usergrousp bar at the top, so once more I'm saying to set which usergroups to show.

Chris

[pantani]

Have you set which usergroups to show? You can find it in admincp below the General settings (left side menu).

Chris

I'm not sure where you mean, in usergroups i gave permision to the most usergroups, where else?
Thanks

[BirdOPrey5]

On the Admin CP Sidebar there is a new menu group called Forum Members

Expand it and click on Usergroups

On that page you then select the usergroups Chris is talking about.

(I missed it to my first time.)

[pantani]

ok, the search is working, but still not showing the letter index, and selected the users who are able to see it?

[pantani]

Chris? You know what could be the probs, or what to do?

[Naijasite]

please upgrade this memberlist product to 4.2.0

[doubleclick]

Can you put a direct link to the PRO version? I noodled around www.Qapla.com and can't find any mention of it.

thanks,
dc

[BirdOPrey5]

Hello,

I have not yet updated the Pro version so it is not yet available. This mod recently underwent a change of ownership.

I will post an updated with a new free version and link to pro version when it is ready.

[BirdOPrey5]

Mod returned back to ChrisTERiS.