Avatar Gallery (was Avatar Matrix) beta released

SELECT * FROM #__comprofiler WHERE avatarapproved=1 AND banned='0' ORDER BY avatar DESC

But when I do this, I get duplicate users. Some users show up twice, some show up once. Any ideas? I've checked the DB, just in the event that there were duplicate entries, and there are none. I'm really confused about this.. admittedly, I dont know much about SQL, so I could have typed something wrong.

Try SELECT DISTINCT * FROM etc etc.

This approach works for me with the much of the same problems.

Can someone else test this and confirm it? I'd like to know whether it's an issue with a particular platform or install of SQL or whether it's a genuine bug.

Roger

Hey,

this is a great plugin!!!

But not easy to find...

Insert it in www.joomlaos.de .

This module is aboslutely brilliant. I have tested all settings but still cannot get current users online to work. Does anyone else have this working? Absolutely brilliant.

Can you post the query you're using for current users online?

Roger

Here's what I'm using for current users online, listed by time of last login.

[code:1]
SELECT DISTINCT

u.username,
u.id,
u.lastvisitDate,
c.user_id

FROM
#__comprofiler c,
#__users u,
#__session s

WHERE c.banned=0
AND (u.id = c.user_id)
AND (u.id = s.userid) AND (s.guest = 0)
ORDER BY u.lastvisitDate DESC[/code:1]

Usually for me, this module goes into a mosloadposition user12. Is it just me that uses this as a content item and not as a module, or what do you others do?

Edit: removed superfluous code.

Post edited by: Pubocyno, at: 2006/11/24 08:41