[VB3 RC3] Search by usergroup in memberlist

[Kentaurus]

In memberlist in the advanced search you can search by name, web page,
posts... but you can't list all the members in a certain usergroup.

The leader of the usergroup has the option to view all the members
in the usergroup. This is an extension so any user can do a search
for a usergroup and check which members they have.

Why this? It is common to belong to a usergroup but not everybody has
the custom title of the group, you have no way of knowing who else
belongs to the usergroup besides asking the leader.

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org (../) at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

[gmarik]

Not bad. Would be nice to have a search by varfield as well, for example, Location (the city, I mean).

[Cyricx]

Hmm anyway for me to link to a specific search?

Needing to be able to list all the members of one group and be able to link to it. Hoping I can do something like that with this :)

Either way, great hack :)

* Cyricx clicks install!

[Kentaurus]

Hmm anyway for me to link to a specific search?

Needing to be able to list all the members of one group and be able to link to it. Hoping I can do something like that with this :)

Either way, great hack :)

* Cyricx clicks install!Yes, if you install this hack the usergroups are exposed (as long as they are public) so you can just link to memberlist.php?do=getall&usergroupid=xxx where xxx is the id of the usergroup. That link wouldn't work without the hack because it would require you to be the usergroup leader.

[Allan]

I do not arrive has to make it function.

I return the number of the group, for example "6", and it finds me nothing.

could you indicate to me of advantage of information of its operation ?

[Kentaurus]

I do not arrive has to make it function.

I return the number of the group, for example "6", and it finds me nothing.

could you indicate to me of advantage of information of its operation ?
6 is the administrator usergroup, you can not list that usergroup as that would be a security risk, for example a user could list all the banned users and I'm pretty sure that is not something that should be allowed.

The usergroup must be public for it to be listed. Create a custom usergroup, make it public (joinable) and then you will be able to list it in the memberlist.

[Allan]

6 is the administrator usergroup, you can not list that usergroup as that would be a security risk, for example a user could list all the banned users and I'm pretty sure that is not something that should be allowed.

The usergroup must be public for it to be listed. Create a custom usergroup, make it public (joinable) and then you will be able to list it in the memberlist.

ok, thank Kentaurus :)

==============================
edit
==============================

I have to check well to have all to install but Ca does not function, in fact, it finds me well the user group to require but no name puts to me below :(

[Cyricx]

Awesome!! Very nice hack, just what I was needing :)

Thank you!

[eXtremeTim]

Its a nice hack but would be nice if instead we could select under the usergroup permissions if it shows up instead of the group having to be publicly joinable.

[Allan]

I have to check well to have all to install but Ca does not function, in fact, it finds me well the user group to require but no name puts to me below :(

always similar not the pseudo one below :(

[Bill Thebert]

Not bad. Would be nice to have a search by varfield as well, for example, Location (the city, I mean).

I would like to see yet another variation on this theme.

I would like to see the "Advanced Search" form (for searching the FORUMS, not just the memberlist) include one or two of the custom user profile fields.

Practical example:

Four of my forums are used for classified advertising.

Two custom fields in the user profile are CITY and STATE (separated, rather than the combined "Location" field).

I would like to include these two fields next to the USER NAME field in the Advanced Search form, such that my users could search, for example, as follows:

"Display all threads/posts in one or all (4) of the Classified ad forums, posted by users from Colorado, for the word 'widget'."

Or find a transmission in Dallas, or an axle from someone named Joe in Kentucky, etc. (My site is automotive-related, obviously.)

The Advanced Search form is alredy doing a cross-table query, right? Selecting posts from one table, based on info from a separate user table?

I would happily hire someone for such a hack.

Regards,

Bill

[Kentaurus]

I would like to see yet another variation on this theme.

I would like to see the "Advanced Search" form (for searching the FORUMS, not just the memberlist) include one or two of the custom user profile fields.

Practical example:

Four of my forums are used for classified advertising.

Two custom fields in the user profile are CITY and STATE (separated, rather than the combined "Location" field).

I would like to include these two fields next to the USER NAME field in the Advanced Search form, such that my users could search, for example, as follows:

"Display all threads/posts in one or all (4) of the Classified ad forums, posted by users from Colorado, for the word 'widget'."

Or find a transmission in Dallas, or an axle from someone named Joe in Kentucky, etc. (My site is automotive-related, obviously.)

The Advanced Search form is alredy doing a cross-table query, right? Selecting posts from one table, based on info from a separate user table?

I would happily hire someone for such a hack.

Regards,

Bill
that's a mod for the search function, not for the memberlist. You are better of putting it on the modification request forum, and as I read your post it is something rather complicated. It is a good idea, though.

[Aurous]

This works in 3.0.1

Installed

[Wasser]

Yes, if you install this hack the usergroups are exposed (as long as they are public) so you can just link to memberlist.php?do=getall&usergroupid=xxx where xxx is the id of the usergroup. That link wouldn't work without the hack because it would require you to be the usergroup leader.

i've noticed an odd an annoying quirk.

if i go thru the search it'll display "Members of User Group: XXXXX" at the top of the results.

however, if i do a direct link it simply says "Members of User Group:". the user group name is missing.

does anyone have an idea how to keep the user group name appearing with a direct link?

[Aurous]

^ yes, got the same problem here :ermm:

[DeMiNe0]

i did all the file edits, and even reedited it, but when i search a usergroup i get the following:

The usergroup you are searching for was not found

even if i directly link to the usergroup ID i get the same. running vb 3.0.3

[T3MEDIA]

is there a way to show me how to do this with a drop down? I dont expect people to spell the usergroup name.
Thanks.

[DeMiNe0]

can anyone help me with my problem, or just send me there modifyed memberlist file?

[DeMiNe0]

hello?

[cashpath]

How would I edit this to make the group not have to be joinable?

[commTRU]

i did all the file edits, and even reedited it, but when i search a usergroup i get the following:

The usergroup you are searching for was not found

even if i directly link to the usergroup ID i get the same. running vb 3.0.3

I had that same problem too. Its because I had edited my user group title to have bold tags surrounding them. Try copying the exact text straight from the title field when you edit your usergroup and see if that works.

cashpath, to make the group not joinable you would need to edit the usergroup settings and set the 'Public (Joinable) Custom Clubs' setting to No.

Thanks very much for this hack, it'll prove very useful to me :)

[top end ms]

If you could get this to work for VB 3.6 that would be AWESOME!

[DarkDraco07]

yea i need this for 3.6 as well

[sarahk]

This is actually really easy in 3.6 - I've been able to do everything via the Plugin Manager. Only outstanding issue is how to do the page navigation ... see http://www.vbulletin.com/forum/showthread.php?t=220020

I'll post the actual plugins once I've got it finished if anyone is interested.

[sarahk]

We've just had an attempt a sql injection targetted at this plugin

SELECT COUNT(*) AS users
FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield USING (userid)

WHERE 1=1 AND ( concat( ',', user.membergroupids, ',') like '%,http://phonefamily.chat.ru/images?,%' || user.usergroupid = http://phonefamily.chat.ru/images?)
AND user.usergroupid IN (-1,6,34,7,2,33,38,5);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '://phonefamily.chat.ru/images (http://phonefamily.chat.ru/images)?)
AND user.usergroupid IN (-1,
Error Number : 1064
Date : Saturday, April 12th 2008 @ 03:31:03 AM
Script : http://www.mysite.com/forum/memberlist.php?mqusergroup=http://phonefamily.chat.ru/images (http://www.propertytalk.com/forum/memberlist.php?mqusergroup=http://phonefamily.chat.ru/images)?
Referrer :
IP Address : 203.97.120.149 (http://203.97.120.149/)
Username : Unregistered
Classname : vb_databasedidn't work but could the variable management be more robust?