[ABD] CPF Member Search v.0.0.1

[4_seven]

Fine, that it works 4 you.I wrote the needed convert

Code: Select all

phpbb_profile_fields_data to utf8_unicode_ci

for case insensitive search some times ago, but may not all people have read that.

I write a Notice next time, so it is clear

[4_seven]

Here it is..

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]

up with this info, bcs. of discussion behind..

CPF Member Search - Addition #1 released...

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

Info

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

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

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

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

[trigger_error]

mille grazie for this addition. works great like main part

[4_seven]

You're Welcome

[Volksdevil]

4_seven, looks like another great mod by you

Just a question...I have already added 'Age' to my memberlist so it displays members age as a number. It is not linked or searchable, it just displays.

Can 'Age' be searched for with this mod using drop down menu's maybe?
As 'Age' is not a custom profile field.

Maybe like in each drop you have >
FROM:
16
17
18
19
20
21
22
23
+continues to 99?

TO:
16
17
18
19
20
21
22
23
+continues to 99?

Thanks.

[4_seven]

first, thx. this mod works with all cpf fields/types, which are setup'ed in acp.
other cpf's, which are not in database, are not supported.

btw: normally it gives no reason, to make it not with acp > cpf..

[Volksdevil]

Thanks for the reply.

Unfortunately it would make little sense for me to add a new cpf called 'Age' I really need a way to search members by 'Age' too.

I still may use the mod though as searching by 'Gender' at least would be very cool.

[4_seven]

Unfortunately it would make little sense for me to add a new cpf called 'Age' I really need a way to search members by 'Age' too.

that all you can search, when you make this as cpf.
personally i see no sense to have that not as cpf.
all is possible with cpf. why phpbb have made it, when not?

I still may use the mod though as searching by 'Gender' at least would be very cool.

as you can see in demo, search for gender is allready possible.
Just make a cpf named 'Gender' and there you go..

[Volksdevil]

Unfortunately it would make little sense for me to add a new cpf called 'Age' I really need a way to search members by 'Age' too.

that all you can search, when you make this as cpf.
personally i see no sense to have that not as cpf.
all is possible with cpf. why phpbb have made it, when not?

Just make a cpf named 'Gender' and there you go..

Sorry if I have misunderstood 4_seven. But if i made a cpf called 'Age' people would have to update it manually which is no good unfortunately.

[4_seven]

think twice. this is very good, so just send a board-pm and push your user, to do that.
so they are forced to update her/his profiles and the board get the newest, current age status
and may some think about to show it or not or whatever

[Volksdevil]

4_seven, I currently have no users (New board)

Are you saying that if I make a cpf for people to put their age, that it could update automatically? Otherwise they would have to change it every year themselves.

[4_seven]

why not search for 'date of birth', so you have it auto 'updated'.
also an 'auto update' of an age is possible (hidden ucp 'date of birth field' with public 'age display').
but that's another mod.

[Volksdevil]

Hi 4_seven,

I'd need to search between two ages...like 18-30 if possible. Searching exact dob would be too specific for what I need.

It's ok anyway, I appreciate the effort you put into mods and helping so don't worry about it.

[4_seven]

why worry? it's not my wish, so, as i say..

but that's another mod.

so your need is the possibility to search from number to number (math.).
in words: this needs a mod, which change the search behaviour at all.
and, after this, eg. this mod must change to work with this new syntax ..