1. dladuron
  2. Support
  3. Tuesday, November 10 2015, 05:05 AM
I want to be able to limit the display of the list that is generated by the list module to specific profile pages.

I want it to be displayed on user profiles using a specific user id (i.e. user id12)
I do NOT want the list to be displayed on user profiles using a specific user id (i.e. user id 8)

Any idea on how I can do this?
admin Accepted Answer
Admin
Hi,
maybe I have not understand your question, anyway I try to reply

You can use SQL custom where to filter users, in SQL custom where you can use also our content plugin.

for example with this SQL custom where the module show all users except current user displayed on current profile page
id != {user id displayed raw}


Docs about SQL Custom Where at http://docs.easy-profile.com/article/sql-custom-where
Docs about Content Plugin at http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Support
  3. # 1
dladuron Accepted Answer
no - sql only limits who is on the list.

I want the list to be displayed with all users of particular id's.
I want the list to be displayed to all users except on specific users profiles.

Example: SQL 'group_id IN (12,8)' greats List of users A, B, C

User profile A (group id 12) page - displays list with users A, B, C

User profile B (group id 12) page - displays list with users A, B, C

User profile C (group id 8) page - does not display list
  1. more than a month ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
This is possible, but is complex.

Sql custom where put the value into DB query, and mysql support IF statement, so for example:

( IF( {user avatar displayed raw} IN (406,407), 1, 0) = 1 AND group_id IN (12,8) ) OR ( IF( {user avatar displayed raw} IN (408,409), 1, 0) = 1 AND group_id IN (12) ) OR ( IF( {user avatar displayed raw} IN (410,411), 1, 0) = 1 AND group_id IN (8) )


in this example:
- if you see profile page of user 406 and 407 you will see a list of users from group 12 and 8
- if you see profile page of user 408 and 409 you will see a list of users from group 12
- if you see profile page of user 410 and 411 you will see a list of users from group 8

{user avatar displayed raw} this code return id of current displayed user
  1. more than a month ago
  2. Support
  3. # 3
dladuron Accepted Answer
Getting closer but still missing the mark.
I want a list of all users to be displayed on every users profile page EXCEPT those users profile that belong to group id (12)

Display if {user avatar displayed raw} groupid != 12
  1. more than a month ago
  2. Support
  3. # 4
admin Accepted Answer
Admin
Sorry this is too complex for our support, build this query require too time.

we can point you on right way, but can't do this for you.

you need to add a sql SELECT into IF statement...it's possible but very complex.
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.