Modify SQL query which generates memberlist

[GreenFeetz]

Hi all,

first let me thank you for this awsome theme – I really enjoy using this! 🙂

I am trying to influence the member-result list that comes back from the database and since I am really new to this field I am stuck (meaning I dont get any results when I add my desired SQL-statements)
so I hope that you can point me in the right direction with the following questions:

— is it correct, that the DB-query for the memberlist is generated in the “kleo-bp-search.php” file?
— Does the query work on the <wp_space>_bp_xprofile_data table?
— I added my SQL at around line 736 (after the parameters from the search form have been tranlated to SQL) – is this the correct place or should this be done elsewhere?

Many thanks in advance,
Chris

[Abe]

Hi, Thank you very much, we appreciate it.

Hi, if you want to alter the search then yes kleo-bp-search.php file is the right one and the table is right. Yes you can alter the sql there and also echo the $sql variable to see your generated query if is correct since you probably have an error in the statement

Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution

---
@ SeventhQueen we do our best to have super happy customers. Thanks for being our customer.

[Author]

Posts