Joomlapolis - The home of Community Builder - Re:user list filter

Joomlapolis Forums

home | post reply | threaded view | help | rules

Boardwalk :: Forum List

CB 1.0 RC2 Discussions (LOCKED - Please Use 1.0 area)

Tips and Tricks

<< Start < Prev 1 2 Next > End >>

user list filter
Date: 2006/05/11 04:15	By: MadPax	Status: User
Karma: 3

Junior Joomlapolitan

Posts: 33

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 ...componentscom_comprofilercomprofiler.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.

The topic has been locked.

Re:user list filter
Date: 2006/05/11 04:28	By: nant	Status: Admin
Karma: 466

Admin

Posts: 6230

http://www.joomlapolis.com/content/view/431/37/

Use the above technique.

Nick A.
CB Core Team Member
Support CB Development and Get Detailed Documentation
Developer of Nant's Gallery plugin
CB Gallery Extensions Listing, Rate CB Gallery on Extensions Site
Developer of CB AutoWelcome Plugin
CB AutoWelcome Extensions Listing,Rate CB AutoWelcome on Extensions Site
People ignoring your call for help? Read this!
FAQ you
Joomlapolis Extensions Directory (new)- check it out!

The topic has been locked.

Re:user list filter
Date: 2006/05/11 22:49	By: MadPax	Status: User
Karma: 3

Junior Joomlapolitan

Posts: 33

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

The topic has been locked.

Re:user list filter
Date: 2006/05/11 23:32	By: nant	Status: Admin
Karma: 466

Admin

Posts: 6230

you would have to hack the code - cant help you there.

The topic has been locked.

Re:user list filter
Date: 2006/05/12 20:46	By: MadPax	Status: User
Karma: 3

Junior Joomlapolitan

Posts: 33

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.

The topic has been locked.

Re:user list filter
Date: 2006/05/12 22:19	By: nant	Status: Admin
Karma: 466

Admin

Posts: 6230

Yeah, modifying an existing module or writing your own.
Should be very easy - good starting point for a new developer.

The topic has been locked.

<< Start < Prev 1 2 Next > End >>

Boardwalk :: Forum List CB 1.0 RC2 Discussions (LOCKED - Please Use 1.0 area) Tips and Tricks

Joomlaboard Forum Component 1.1.3 Stable
Two Shoes M-Factory

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC4)

What?

Why?

Where?

Just click here for answers!

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

Download 1.1

The latest release candidate of Community Builder is version 1.2 RC4, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers and now also to all registered joomlapolitans.

1.2 RC 4

Documentation

Download Latest Release

CB Login