vb.org Archive - Hopw to run search for users who have certain profile field filled in

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

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

- - Hopw to run search for users who have certain profile field filled in (https://vborg.vbsupport.ru/showthread.php?t=262329)

TopShelfGamer

04-20-2011 03:53 PM

Hopw to run search for users who have certain profile field filled in

How can i run a search for all users who have at least entered some kind of info into a custom profile field i have.

I am sure its something easy but the only thing i could think of was putting $ into the search query but that didnt work

kh99	04-20-2011 04:40 PM

I don't know if there's a way to do that in vb or not. The member list search uses the mysql "LIKE' to compare, but it also escapes the '%' and '_' wildcards so you can't use them.

You could do your own query, like:

Code:

SELECT user.userid, user.username, field6

FROM userfield

LEFT JOIN user ON (userfield.userid = user.userid )

WHERE field6 <> ''

(if you have a table prefix defined in your config.php you have to add it to the beginning of the table names for this to work).

All times are GMT. The time now is 10:34 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01628 seconds Memory Usage 1,707KB 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_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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
Messages: