cbExtensions.com

This module can display usernames and thumbnails for up to ten queries, giving you an extremely powerful and flexible way of displaying cross-sections of your userbase. BubbleTips can be attached to either usernames or thumbnails. Data from jos_comprofiler can be displayed in the bubbleTips. Thumbnails can be custom sized so that they all display nicely. The CSS for module can be edited directly from the admin backend. No external CSS files to mess with. Paginates well when large numbers of users are returned.

SQL: The query below displays random users from the JoomlaWebDesigners.com membership.

 
SELECT 
 c.avatar, 
 c.user_id, 
 u.username, 
 u.id
FROM 
 #__comprofiler AS c,
 #__users AS u
WHERE 
 c.user_id = u.id 
 AND c.confirmed = '1'
 AND c.approved = '1'
 AND c.banned = '0'
 AND u.block = '0'
ORDER BY RAND() DESC
 

CSS: The Container CSS was styled using the CSS below.

 
table.avatarMoo td {
 text-align:center;
 border:1px solid #f88b60;
 padding:0px;
}
 

CSS: The table cells and their contents were styled using the CSS below.

 
table.avatarMoo td a.username {
 display:block;
 width:100%;
 background: #f88b60;
 color:#222;
 line-height:1.5em
}
 
table.avatarMoo td img {
 margin:8px;
 border:none;
}