I may be asking this in the wrong place, but as it's to do with this mod I thought it'd be a good place to start!
Firstly - the mod is excellent - I'm using it on a forum which is restricted to membership of an organisation, so I've implemented "Name" and "Membership Number" fields - the first is visible to all, the second is only visible to moderators - and required that they are both completed on signing up to the forum. This means that new users no longer have to e-mail me with these details to request access - saving a lot of effort!
However, we already have 270-odd users, and although some will add the info, others probably won't and we'll have to chase them up about it (I don't fancy going through 18 months of e-mails finding all of the members details and adding them manually...)
I need a way of viewing members who have not yet filled this field in... Either by searching for them, or by viewing a list of all members, and organising it by the appropriate column ascending/descending to have the "blank" fields at the top. The custom fields are not displayed in the Admin member list or search functions... and I don't really wish to start modifying these files, as 1) I don't know enough about how SMF works, and 2) I want to make it easy to upgrade the forum in future so I try to avoid changing the main code base.
Does anyone have any suggestions, please? I thought about running a search on the DB (using PHPMyAdmin, or writing a custom PHP script) which would just return all usernames, e-mails, and custom profile fields. However, SMF is quite a complex application, and to make things more complicated, the custom fields are kept in smf_settings, whilst the rest of the member information is in smf_members (and I'm not sure how they're linked, precisely...)
Any help would be greatly appreciated!
Thanks,
Sunil