espenhh wrote: Can't log in... And that kind of takes away all their permissions as users![]()
Ah, comprende'. Thanks.
espenhh wrote: Can't log in... And that kind of takes away all their permissions as users![]()
Nein. Ich spreche Altavista Babelfish: http://babelfish.altavista.com/tr" target="_blankJuliusCaesar wrote: thx lasthof but waht about my 2nd question:@rivaldo:danke,biste auch deutscher????JuliusCaesar wrote: when does a user count as inaktive????
and will there be a feature in the final version to decide when a user is inaktive????
rivaldo wrote: Nein. Ich spreche Altavista Babelfish: http://babelfish.altavista.com/tr" target="_blank
JuliusCaesar wrote: and is there any option to view users,who are activated but don't visit the forum??? 8O 8O 8O
Code: Select all
SELECT FROM users WHERE user_active = 1 AND user_lastvisit != 0
JuliusCaesar wrote: well.....![]()
![]()
![]()
right....
where can I find this???
Code: Select all
SELECT * FROM `phpbb_users` WHERE `group_id` != '2' AND `user_lastvisit` = '0'
Highway of Life wrote: Or for phpBB3 CVS (currently)
To find users who are not inactive, but have not been active on the forums.Code: Select all
SELECT * FROM `phpbb_users` WHERE `group_id` != '2' AND `user_lastvisit` = '0'