[ABD] CPF Member Search v.0.0.1

[MSliCK]

hi this the list im using in drop down menu

[Select U.K County]
Aberdeenshire
Alderney
Angus/Forfarshire
Argyllshire
Avon
Ayrshire
Banffshire
Bedfordshire
Berkshire
Berwickshire
Buckinghamshire
Buteshire
Caithness
Cambridgeshire
Cheshire
Clackmannanshire
Clwyd
Cornwall
County Antrim
County Armagh
County Down
County Fermanagh
County Londonderry
County Tyrone
Cumbria
Derbyshire
Devon

(dont show any of these under this in member search but shows fine in profile)
Dorset
Dumbartonshire
Dumfriesshire
Durham
Dyfed
East Lothian
East Sussex
East Yorkshire
Essex
Fair Isle
Fife
Gloucestershire
Greater London
Greater Manchester
Guernsey
Gwent
Gwynedd
Hampshire
Herefordshire
Herm
Hertfordshire
Huntingdonshire
Inner Hebrides
Inverness-shire
Isle of Man
Isle of Wight
Isles of Scilly
Jersey
Kent
Kincardineshire
Kinross-shire
Kirkcudbrightshire
Lanarkshire
Lancashire
Leicestershire
Lincolnshire
Merseyside
Mid Glamorgan
Middlesex
Midlothian/Edinburghshire
Morayshire
Nairnshire
Norfolk
North Yorkshire
Northamptonshire
Northumberland
Nottinghamshire
Orkney
Orkney
Outer Hebrides
Oxfordshire
Peeblesshire
Perthshire
Powys
Renfrewshire
Ross-shire
Roxburghshire
Rutland
Sark
Selkirkshire
Shetland
Shetland
Shropshire
Somerset
South Glamorgan
South Yorkshire
Staffordshire
Stirlingshire
Suffolk
Surrey
Sutherland
Tyne and Wear
Warwickshire
West Glamorgan
West Lothian/Linlithgowshire
West Midlands
West Sussex
West Yorkshire
Wigtownshire
Wiltshire
Worcestershire

but last one it displays is devon

[4_seven]

hm, no clue. i test it out by bring in exact these fields in my testforum.
but, if all works ok on my board, i need a testuser (admin) and ftp-access to help you further.

[MSliCK]

ok if u can pm or email me if it dont work then ill can give u them details as i cant use pm on here

[4_seven]

wow. seems you find a bug . can you switch debug mode in config.php to on and post the error-result?
on my boards it shows 86 entrys (till Selkirkshire), for each more it gives one more error: Undefined offset: number+1.
wired, never enter so much entrys for testing before
have you setup all single fields for dropdown in acp > cpf using genuine phpbb3 cpf?

[4_seven]

get it

it was a 1024 signs sql concat limitation*,
so all signs and words after this limit are cut away.
also the further index is missing, so the error Undefined offset: number+1 toses

* http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet. The syntax to change the value of group_concat_max_len at runtime is as follows, where val is an unsigned integer:

Code: Select all

SET [GLOBAL | SESSION] group_concat_max_len = val;

open

memberlist.php

find

Code: Select all

        $sql = SELECT field_name, field_ident, GROUP_CONCAT(lang_value) as lang_value, 

before add (in a new line before)

Code: Select all

        $sql = 'SET SESSION group_concat_max_len= 4096';
        $db->sql_query($sql);     

this is enough for ~ 428 entrys
currently you have 107 (normally 106, but one is doubled)

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

after some more tests package will be updated..

[MSliCK]

Hi mate great job works now great job i have tested it and checked in with all my U.S countys as well and both working good now so thank you

[MSliCK]

and i tryed to join your site but cant as what ever secret answer i put don't work

[4_seven]

you have pm.

[trigger_error]

Thank you for the fix

[4_seven]

Due my data loss in the near past i've re-pack and re-upload main mod and addition#1 with all available fixes. Both codings works well in productive areas. Until a new demo is out, you have screens in first post.

[trigger_error]

Thanks for your effort, 4_seven. I use this for several month now and my user love it

[4_seven]

thx trigger,
i've add new demo for main mod and addition#1
see first post for further details

[Zaishen]

i think is good mod, but i hate to see 10000000000000 options when i search,

would be nice to be simple, one small window on the midle o the page where to type your word/nick etc and thats all, always when u try to search in phpbb u are tired and sick because apears 10k options..

dont take this like a blame or whateva, no, this is my opinion

and good job because is good one

for example i was trying to remember my old phpbb usernmae here and there were no user search on the forum

[4_seven]

i think is good mod, but i hate to see 10000000000000 options when i search

which options? shure, you are on the right mod? there is only a search field per cpf
http://www.4seven.de/forum/media/member ... searchuser

[Zaishen]

i think is good mod, but i hate to see 10000000000000 options when i search

which options? shure, you are on the right mod? there is only a search field per cpf
http://www.4seven.de/forum/media/member ... searchuser

This mod is to search users on the forum right?




No only options, i mean..., you have to many small windows, names of things , and down the list of the usernames, etc, i think will be more original to hide all that things and make it something like this:

http://rapid-search-engine.com/

thats one example, one space to search your things, 2/3 options and you are done

But this is my personal opinion, im sure that there are ppl who like to see 20 de options and links etc