user list filter

13 years 6 months ago #12248 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

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


the SQL command works fine in phpmyadmin.

What is happening?
Any help welcome.
13 years 6 months ago #12373 by MadPax
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,
13 years 6 months ago #12377 by nant
you would have to hack the code - cant help you there.
13 years 6 months ago #12489 by MadPax
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.
13 years 6 months ago #12501 by nant
Yeah, modifying an existing module or writing your own.
Should be very easy - good starting point for a new developer.
Moderators: beatnantkrileon
Time to create page: 0.430 seconds
Facebook Twitter Google LinkedIn