vb.org Archive - Load members of certain usergroup only?

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Load members of certain usergroup only? (https://vborg.vbsupport.ru/showthread.php?t=221998)

binaryg

09-14-2009 06:45 PM

for that you are going to need to loop through the values for each member and use that code. Though, it would probably be a bit more simple just to use a php file and select all the members from the database that meet your criteria. You might be able to get away with that if you were able to copy some code from the memberlist templates, essentially creating your own, and then use your custom information to sort the users but I think you would probably need to enable that particular field to be indexed in the memberlist. I wouldn't know which is the easiest route. I haven't played with member data very much.

ohh, and it looks like your parse error is the result of the first " in "OH". It closes out the tag

AFemaleProdigy

09-14-2009 07:57 PM

I did make my custom page based off of the memberlist.php but I don't know what to add in there and then what to put in my template to make this work.

--------------- Added [DATE]1252966903[/DATE] at [TIME]1252966903[/TIME] ---------------

What would be the fastest way for me to get this working? :)

binaryg

09-14-2009 09:14 PM

PHP Code:


		
			
$users= $db->query_first("
                SELECT member AS member
                FROM " . TABLE_PREFIX . "members AS members
                WHERE useridcolumn = " . $useridvariable . " AND fieldcolumn = dataforfield
                LIMIT 1
            ");

There's probably all sorts of things wrong with that's should get you started... plug whatever info you need in there and see where it takes ya. That's what I do

All times are GMT. The time now is 05:52 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02225 seconds Memory Usage 1,721KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (3)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: