user list filter

14 years 2 months ago #12248 by MadPax
user list filter was created by MadPax
I was trying to create a most recent users list with a filter.

I am using the following SQL command:

SELECT * FROM jos_users WHERE (registerDate + INTERVAL 60 DAY) > 2006-05-10 ORDER BY registerDate DESC LIMIT 0,5


which means I am looking for the most recent 5 users who have registered in the last 60 days and order them by their registration date.

but I'm getting the following error

Warning: Invalid argument supplied for foreach() in ...\components\com_comprofiler\comprofiler.html.php on line 718
User


when I try the following link (my list id is 4):

index.php?option=com_comprofiler&task=usersList&listid=4

the SQL command works fine in phpmyadmin.

What is happening?
Any help welcome.

Please Log in to join the conversation.

14 years 2 months ago #12252 by nant

Please Log in to join the conversation.

14 years 2 months ago #12373 by MadPax
Replied by MadPax on topic Re:user list filter
Ok as you might now know from the other thread I used the info there and aloms all is ok.

The only question I have is: where can I disable the serach box and list all users link from this content list?

Thnx in advance,
Pax

Please Log in to join the conversation.

14 years 2 months ago #12377 by nant
Replied by nant on topic Re:user list filter
you would have to hack the code - cant help you there.

Please Log in to join the conversation.

14 years 2 months ago #12489 by MadPax
Replied by MadPax on topic Re:user list filter
OK I can understand that. I'd rather not do that though! Not for this because I still want that functionality in the lists.

Let me just tell you what I was trying to. It was to get something similar to the random profiles module, but with the most recent ones.

How can I acheive that? Probably by hacking that module eh?

Thnx Nick.

Please Log in to join the conversation.

14 years 2 months ago #12501 by nant
Replied by nant on topic Re:user list filter
Yeah, modifying an existing module or writing your own.
Should be very easy - good starting point for a new developer.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.440 seconds

Facebook Twitter LinkedIn