Re: [TYPO3-english] Show count of users in usergroup

2013-12-29 Thread Jigal van Hemert
Hi, On 29-12-2013 16:46, Nemanja Todic wrote: he structure is basically this " usergroup id | start date | end date | " IMO the developer of the ext. that introduced this "timed" feature did a bad job by storing data in such format. Not necessarily. It's meant to be used during login when the

Re: [TYPO3-english] Show count of users in usergroup

2013-12-29 Thread Jigal van Hemert
Hi, On 28-12-2013 17:50, Miguel wrote: No, i'm not asking for someone to do the research for me, only for some advices, as i have been searching this for some time, and the little information that i have got in english was some talk about that snippet... If i have offended someone, i apologize f

Re: [TYPO3-english] Show count of users in usergroup

2013-12-29 Thread Stephan Schuler
Hey there. I agree that having such a format is pretty bad since it is both, difficult to handle and unnecessary resource consuming. But that doesn't require stored procedures, you can still use inline query options. Have a look at SUBSTRING_INDEX. It's really ugly, but you can do something like

Re: [TYPO3-english] Show count of users in usergroup

2013-12-26 Thread Jigal van Hemert
Hi, On 18-12-2013 12:42, Miguel wrote: C'mon guys, is this a so weird question that nobody can give some advices ? The goal is only to show the number of users from a usergroup field ;) Well, you expect others to do a lot of research for you it seems :-) and i found a snippet that does exact

[TYPO3-english] Show count of users in usergroup

2013-12-16 Thread Miguel
Greetings friends, In my homepage i want to show the number of users that belong to certain usergroup...Well this sound easy, and i found a snippet that does exactly this, but the problem is that i work with timed usergroups, so the snippet that points to "usergroup" don't work if i redirect t