Need some custom code changes to the phpBB core simple enough that you feel doesn't require an extension? Then post your request here so that community members can provide some assistance.
NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
kronos1 wrote: ↑Mon Jan 07, 2019 8:17 pm
Is there away you can list or search members by their location or does anyone have any SQL code for this so I can run it in phpMyAdmin.
Thank you.
Since you can use phpMyAdmin, why not use the in-built querybuilder? There's even a search function ready (with wildcards). You'll get the correct SQL somewhere near the top of the page.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Time flies like an arrow, but fruit flies like a banana.
Username is in the users_table and should be found by joining to user_id from phpbb_ profile_fields_data to user_id from phpbb_users
I can't write correct SQL with joins just like that (too used to VB-sql) but you should check non-empty locations
something like FROM 'phpbb_profile_fields_data'.'user_id' WHERE 'pf_phpbb_location' != ''
If you're used to working with MS Office, you can use an odbc connector and do everything in Access (the experts will probably cringe reading this, but hey, it does the job for me).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Time flies like an arrow, but fruit flies like a banana.