Previous Thread
Next Thread
Print Thread
Hop To
Advanced search Options: "Text Field Search" doesn't work #240065 10/21/2010 11:00 AM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
I was trying to find my members with the Member Custom Title "AI Subscriber" using Advanced search Options: "Text Field Search" it didn't find anything.

I then tried searching for #FFCC33 in the Name Color field and again, the search came up with nada.

The description for Text Field Search says
This field searches text in the Occupation, Location, Hobbies, Bio and Custom fields.

What's going on?


Member since November 2004
Gold Member since Feb 2008
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240073 10/21/2010 2:11 PM
Joined: Jun 2006
Posts: 15,844
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,844
Well, I believe that "custom fields" exclude the "custom title", I think it's just the 4 "whatever you want" fields in the profile...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240074 10/21/2010 2:17 PM
Joined: Jun 2006
Posts: 15,844
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,844
In admin/membersearch.php:
Code
		$extra .= " and (t2.USER_OCCUPATION LIKE '%$fieldsearch%' OR t2.USER_LOCATION LIKE '%$fieldsearch%' OR t2.USER_HOBBIES LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_1 LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_2 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_3 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_4 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_5 LIKE '%$fieldsearch%') ";


Doesn't hit the custom title field; so you'll have to add it like:
Code
		$extra .= " and (t2.USER_OCCUPATION LIKE '%$fieldsearch%' OR t2.USER_LOCATION LIKE '%$fieldsearch%' OR t2.USER_HOBBIES LIKE '%$fieldsearch%' OR t2.USER_CUSTOM_TITLE LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_1 LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_2 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_3 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_4 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_5 LIKE '%$fieldsearch%') ";





I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240083 10/22/2010 9:33 AM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
ah, thanks Gizmo.

The description for that feature should probably change to be a bit more clear or the feature should change to include the custom title in the custom field search.


Member since November 2004
Gold Member since Feb 2008

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 1:11 AM
Unable to save General settings
by amciotola - 10/13/2019 4:23 AM
I see signature line images, but no avatars
by Morgan - 10/12/2019 2:21 PM
Show PDF
by Geoff - 10/09/2019 1:33 AM
Subscription’s Auto Return URL for PayPal
by Geoff - 09/27/2019 12:10 AM
Who's Online Now
1 registered members (JAISP), 98 guests, and 427 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20190930)