[ABD] CPF Member Search v.0.0.1

[4_seven]

CPF Member Search

MOD-Title: CPF Member Search
MOD-Version: 0.0.1
MOD-Author: 4seven

Credits: manic2 for a little code part of Search Custom Profile Field

phpBB-Version: phpBB 3.0.8/9
phpBB-Languages: en
phpBB-Styles: prosilver

MOD-Description: Searching in Custom Profile Fields

Download: http://www.4seven.de/forum/6test/viewtopic.php?f=3&t=43





Features:
- Search in all kind of Custom Profile Fields on Member Search Page
- Autogenerated Search-Fields, controlled by genuine CPF ACP
- ACP Option to switch CPF to searchable/unsearchable

Demo: http://www.4seven.de/forum/media/member ... searchuser
may watch cpf entrys from a profile before you check out searching
eg. http://www.4seven.de/forum/media/member ... rofile&u=2

Screens:

Memberlist: (with Addition#1)
http://www.loaditup.de/files/595090.png

ACP:
http://www.loaditup.de/files/590714.png
http://www.loaditup.de/files/590716.png
http://www.loaditup.de/files/590717.png
http://www.loaditup.de/files/590718.png

CPF Member Search - Addition #1:
Download: http://www.4seven.de/forum/6test/viewtopic.php?f=3&t=43
Info: http://www.phpbb.com/community/viewtopi ... #p12968979
Demo:
http://www.4seven.de/forum/media/memberlist.php
http://www.4seven.de/forum/media/member ... searchuser
Screens:
http://www.loaditup.de/files/595097.png
http://www.loaditup.de/files/595090.png

Note: Use this fix to show the status for all members

To-Do/Requests:
- ?

Take also a look at CPF Group Search

[4_seven]

CASE INSENSITIVE SEARCH INFO

BASE INFO

Code: Select all

		// Table Converting for case in-sensitive searching
		/* ###############################
		utf8_unicode_ci is *generally* more accurate for all scripts.
		For example, on Cyrillic block:
		utf8_unicode_ci is fine for all these languages:
		Russian, Bulgarian, Belarusian, Macedonian, Serbian, and Ukrainian.
		While utf8_general_ci is fine only for Russian and Bulgarian subset of Cyrillic.
		Extra letters used in Belarusian, Macedonian, Serbian, and Ukrainian are sorted not well. 
		################ */

CHANGE COLLATION
- put this in index.php
- call index.php and click 1 time F5
- after that, remove this edit

Code: Select all

if ($auth->acl_get('a_') && !empty($user->data['is_registered'])){
		$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . '
		CONVERT TO CHARACTER SET utf8 
		COLLATE utf8_unicode_ci';
		$db->sql_query($sql);}

CHANGE COLLATION INFO

Code: Select all

		/* ################
		So change 
		COLLATE utf8_unicode_ci 
		to 
		COLLATE utf8_generale_ci
		if needed.
		Set
		COLLATE utf8_bin
		if your language have no classic upercase letters or it makes no sense for your needs
		################ */

[4_seven]

v.0.0.1 released.

read first post for further details..

[trigger_error]

Hello four_7, absolut great work. Big THanx for that

[4_seven]

thx, trigger_error

-----------------------

[DEV] v.0.0.2 Preview

- Avatar Display
- Online/Offline Status
- CPF Onmouseover Quick-View

Demo: (follows)

Screens:
http://www.loaditup.de/files/595097.png
http://www.loaditup.de/files/595090.png

[heredia21]

Great work! About to try it out.

[4_seven]

thx - v.0.0.2 should come out ~ 'end of the week' with named features..

[trigger_error]

CAnt WAit for that update. THis will Satesfy all my needs

[4_seven]

thx 4 interest..

[4_seven]

This is the next Mod, which get's an update

- Avatar Display
- Online/Offline Status
- CPF Onmouseover Quick-View

Demo: http://4seven.kilu.de/phpbb3/memberlist ... searchuser

Screens:
http://www.loaditup.de/files/595097.png
http://www.loaditup.de/files/595090.png

It is well tested in public now, so i write the ModX asap..

[4_seven]

info about planned update

after some talks to user, i bring out this addition as a plugin with own modx

reason:
- you can use this addition standalone
- more people want the main mod stay smart

release date: soon

[4_seven]

CPF Member Search - Addition #1 released...

Download: http://4seven.kilu.de/forum/phpbb3/view ... 1997#p1997
Demo/Info: http://www.phpbb.com/community/viewtopi ... #p12968979

[oliver911]

Hi,

I install CPF with CPF Member Search - Addition #1 on my phpBB3.0.8-Board and add a multi-row-field "IT-Knowledge".
When I save this Words "Windows Server Lancom Astaro Microsoft Netgear Exchange" I get no search-result, when I search for e.g. *lancom*

Please try it, I'm going crazy, because the the search-engine work with other words without problems

Olli

[oliver911]

Dooh!
case-sensitive

Can I case-sensitive off?
On your Test-Board:
Ram -> Found
ram -> Found
On my board:
ram -> no resuelt, because its Ram

[oliver911]

ok...
change charset for phpbb_profile_fields_data to utf8_unicode_ci and it's good - (was on utf8_bin)