vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [VB3 RC3] Search by usergroup in memberlist (https://vborg.vbsupport.ru/showthread.php?t=60420)

Kentaurus 01-17-2004 10:00 PM

[VB3 RC3] Search by usergroup in memberlist
 
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 01-19-2004 07:18 AM

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

Cyricx 01-21-2004 08:50 PM

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 :)

[high]* Cyricx clicks install![/high]

Kentaurus 01-25-2004 05:07 AM

Quote:

Originally Posted by 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 :)

[high]* Cyricx clicks install![/high]

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 01-25-2004 09:02 PM

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 01-25-2004 10:18 PM

Quote:

Originally Posted by Socrate
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 01-26-2004 06:50 AM

Quote:

Originally Posted by kentaurus
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 01-26-2004 06:27 PM

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

Thank you!

eXtremeTim 01-28-2004 01:23 PM

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 01-31-2004 03:28 PM

Quote:

Originally Posted by Socrate
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 02-19-2004 03:31 AM

Quote:

Originally Posted by gmarik
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 02-29-2004 05:47 PM

Quote:

Originally Posted by Bill Thebert
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 05-26-2004 12:04 AM

This works in 3.0.1

Installed

Wasser 05-31-2004 08:39 AM

Quote:

Originally Posted by Kentaurus
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 06-13-2004 09:44 AM

^ yes, got the same problem here :ermm:

DeMiNe0 01-31-2005 05:05 PM

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 01-31-2005 06:24 PM

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 02-02-2005 03:21 PM

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

DeMiNe0 02-08-2005 10:01 PM

hello?

cashpath 03-20-2005 11:43 PM

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

commTRU 08-26-2005 12:14 PM

Quote:

Originally Posted by 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

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 09-28-2006 12:13 AM

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

DarkDraco07 11-26-2006 11:19 PM

yea i need this for 3.6 as well

sarahk 02-13-2007 01:21 AM

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 04-11-2008 11:02 PM

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

Quote:

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?)
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?
Referrer :
IP Address : 203.97.120.149
Username : Unregistered
Classname : vb_database
didn't work but could the variable management be more robust?


All times are GMT. The time now is 04:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01317 seconds
  • Memory Usage 1,793KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (25)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete