Searchable Fields from AntonLV

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

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.

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!

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

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}%'";

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

 You're welcome.

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!

Thanks a lot.

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

Run the following query to revert that DB change back

ALTER TABLE `sys_profile_fields` DROP COLUMN `Searchable`;

Thanks.

You are welcome.

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.