[Typo3] Problem with user listing in newloginbox extension

Livius Agrippa livius_agrippa at yahoo.com
Thu Sep 29 10:58:10 CEST 2005


Livius Agrippa wrote:
> Hi,
> 
> Recently I have started to work with Typo3 and I think it is a good and 
> powerful CMS.
> 
> I have installed the newloginbox extension and all work great but I have 
> a problem. For user fields/details I have selected all fields, but for 
> some of them the information in the frontend doesn't look ery nice.
> Eg. [usergroup] = 1
> [disable] = 0
> [starttime] = 0
> 
> What can I do to make this extension to show the information like this
> Usergroup = customers
> 
> Forgive me for my english.
> Any advice will be very appreciated
> 
> Livius

Hi

I found the answers for almost all my questions about this extension. 
But I still have one.
Can someone tell me how can I put this sql statement:
SELECT fe_users.*, fe_groups.title AS usergroup FROM fe_users, fe_groups 
WHERE fe_users.usergroup = fe_groups.uid
in this function
pi_list_query($table,$count=0,$addWhere='',$mm_cat='',$groupBy='',$orderBy='',$query='',$returnQueryArray=FALSE)
which is situated in tslib/class.tslib_pibase.php

I need that to take the group's name instead of number for the user 
listing part.

regards,
Livius



More information about the TYPO3-english mailing list