Searchable Fields from AntonLV

Hello everybody.
This is a support forum for our Searchable Fields module.
If you have some questions or suggestions regarding it feel free to post them here or contact us directly.
Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 3 Feb 2012

Hello, I just bought this mod and don't have a problem adding code to php files.

I do not know how to do this first task and last time I tried something like this I messed my whole database up. DO you have a youtube video or something showing how to insert this or can you help me? The 1. step is listed below I need help with. I am in phpmyadmin all the time editing files but this is new to me.


1.    Execute SQL query (using phpMyAdmin for example)

    ALTER TABLE `sys_profile_fields` ADD `Searchable` TINYINT( 1 ) DEFAULT '1' NOT NULL  AFTER `Unique` ;

 

Thanks,

James

000
Quote · 11 Jun 2012

Hello hotpointis,

If your phpMyAdmin allows you to edit files then most likely it is not a phpMyAdmin. :)

phpMyAdmin allows to manage database. It is available on most of the hosting administrative panels.
Just open phpMyAdmin, select database which is used by your Dolphin, click on "SQL" tab then paste in the SQL query and hit "GO" button. Done.

 

Unfortunately we do not have any videos for that.

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 12 Jun 2012

Thanks Anton, I figured it out on my own. I was very easy as you state. Learn something new everyday. Thanks for the great mod!

000
Quote · 12 Jun 2012

Hello everybody.
The module was updated. It's available for Dolphin 7.1 now.

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 7 Nov 2012

Hello, everybody!

Is it possible to make separate words searcheable in one field? (If they are separated by commas, for example.)

When I enter "interests" (e.g. music, books, films) - the whole list becomes a link, but I would like each word to be clickable. How can I do it?

Thanks, Kate

Quote · 21 May 2014

 

Hello, everybody!

Is it possible to make separate words searcheable in one field? (If they are separated by commas, for example.)

When I enter "interests" (e.g. music, books, films) - the whole list becomes a link, but I would like each word to be clickable. How can I do it?

Thanks, Kate

Hello Kate,

The easiest way is to make that field as a multiselectable list. If that is not an option for you and you want to leave it as a text field then you'd need to apply the following patch:

Edit the file inc/classes/BxDolProfileFields.php, find the line

$sValue = addslashes(urlencode($sValue));

insert right above it the code

if ($aItem['Name'] == 'interests') {
    $aValues = explode(',', $sValue);
    $aValuesLinks = array();
    foreach ($aValues as $sValue) {
        $sValue = trim($sValue);
        $sValueLink = addslashes(urlencode($sValue));
        $aValuesLinks[] = "<a href=\"{$site['url']}search.php?field={$aItem['Name']}&value={$sValueLink}\">{$sValue}</a>";
    }
    return implode(', ', $aValuesLinks);
}

 

Edit the file templates/base/scripts/BxBaseProfileView.php, the line

if (strlen($value)) $aWhere[] = "`{$field}` = '{$value}'";

replace with

if (strlen($value)) $aWhere[] = "`{$field}` LIKE '%{$value}%'";

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 21 May 2014

Thank you very much Anton, that's exactly what I wanted!

Quote · 15 Aug 2014

Thank you very much Anton, that's exactly what I wanted!

 You're welcome.

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 16 Aug 2014

Hi Anton, I actually discovered this module doing a google search. It's not easy to find on the Boonex site unless you know what you're searching for. For anyone slightly interested, it's actually a simple to install patch that completely changes the way Dolphin thinks. Members can now search for other members with the same interests directly from their profile.  It's "BRILLIANT!" This has to be the BEST modification you can make to Dolphin and the $15 outlay is worth every cent.

 

I have this facility on another of my sites running Elgg. My members love it, but sadly it's not available in Dolphin. Thanks to you, it now is and I can now safely upgrade my site.

 

Well done!

Quote · 29 Feb 2016

Thanks a lot.

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 29 Feb 2016

Has anyone tried to upgrade from 7.1.6 to 7.2.0 with 'Searchable Fields' installed?

I've tried twice and get errors.

 

INSERT INTO `sys_profile_fields` VALUES(NULL, 'FullName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, IFNULL(@iMiscBlockId, 0), IF(ISNULL(@iMiscBlockId), NULL, 1), 17, 2, 17, 2, 0, NULL, 17, 2, 17, 5, 0, NULL, 17, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);: Column count doesn't match value count at row 1

 

I'm wondering if Searchable Fields might have helped cause this.

The installation file requires

1. Execute SQL query (using phpMyAdmin for example)

 ALTER TABLE `sys_profile_fields` ADD `Searchable` TINYINT( 1 ) DEFAULT '1' NOT NULL  AFTER `Unique` ;

 

Unfortunately, there's no uninstall notes to roll that back (if needed).

TravelNotes.org - The Online Guide to Travel
Quote · 22 Mar 2016

Run the following query to revert that DB change back

ALTER TABLE `sys_profile_fields` DROP COLUMN `Searchable`;
Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 22 Mar 2016

Thanks.

TravelNotes.org - The Online Guide to Travel
Quote · 22 Mar 2016

Thanks.

You are welcome.

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 23 Mar 2016

Hi Anton, I'm finally trying to upgrade to 7.4.2. I downloaded the latest version but the zip file is empty. Can you please fix this?

I assume there will be a readme outlining any traps I may encounter along the way.

Many thanks,

Demmy

Quote · 20 Feb 2020

 

Hi Anton, I'm finally trying to upgrade to 7.4.2. I downloaded the latest version but the zip file is empty. Can you please fix this?

I assume there will be a readme outlining any traps I may encounter along the way.

Many thanks,

Demmy

 Hi Demmy,

The zip file has been updated. Sorry. 

Best Regards AntonLV - http://www.boonex.com/market/posts/AntonLV
Quote · 20 Feb 2020
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.