inaktive users

Discuss features as they are added to the new version. Give us your feedback. Don't post bug reports, feature requests, support questions or suggestions here.
Forum rules
Discuss features as they are added to the new version. Give us your feedback. Don't post bug reports, feature requests, support questions or suggestions here. Feature requests are closed.
User avatar
robertmf
Registered User
Posts: 52
Joined: Wed Jul 23, 2003 5:20 pm
Location: In PA, 55 min. via commuter RR outside Filthadelphia
Contact:

Re: inaktive users

Post by robertmf »

espenhh wrote: Can't log in... And that kind of takes away all their permissions as users :roll:


Ah, comprende'. Thanks.

:?: Do you know if inactive users get the bulk email sent out by Admin ? If not, this is a way for me to control bouncebacks, but not truely lose the member.

rivaldo
Registered User
Posts: 269
Joined: Wed Feb 23, 2005 1:05 am

Re: inaktive users

Post by rivaldo »

JuliusCaesar wrote: thx lasthof but waht about my 2nd question:
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:danke,biste auch deutscher????
Nein. Ich spreche Altavista Babelfish: http://babelfish.altavista.com/tr" target="_blank

User avatar
robertmf
Registered User
Posts: 52
Joined: Wed Jul 23, 2003 5:20 pm
Location: In PA, 55 min. via commuter RR outside Filthadelphia
Contact:

Re: inaktive users

Post by robertmf »

rivaldo wrote: Nein. Ich spreche Altavista Babelfish: http://babelfish.altavista.com/tr" target="_blank


:lol: 8O :lol: Tun Sie mich so, nur ich verwende http://www.translate.ru" target="_blank für den Russen (Freunde der Deutschen:-)

JuliusCaesar
Posts: 84
Joined: Sat Jun 24, 2006 2:02 pm
Location: Germany
Contact:

Re: inaktive users

Post by JuliusCaesar »

and is there any option to view users,who are activated but don't visit the forum??? 8O 8O 8O


@robertmf and rivaldo:
das babelfish zeugs is schrott^^
wenn ich eingebe: "Ich heiße Julian"
kommt da "Hello I is called Julian" 8O 8O 8O 8O

da funzt die russische seite besser ;) ;) ;)
JuliusCaesar

User avatar
robertmf
Registered User
Posts: 52
Joined: Wed Jul 23, 2003 5:20 pm
Location: In PA, 55 min. via commuter RR outside Filthadelphia
Contact:

Re: inaktive users

Post by robertmf »

JuliusCaesar wrote: and is there any option to view users,who are activated but don't visit the forum??? 8O 8O 8O

As a negative test in phpBB2, you could use something like

Code: Select all

SELECT FROM users WHERE user_active = 1 AND user_lastvisit != 0 

JuliusCaesar
Posts: 84
Joined: Sat Jun 24, 2006 2:02 pm
Location: Germany
Contact:

Re: inaktive users

Post by JuliusCaesar »

well..... :oops: :oops: :oops: :oops: right....
where can I find this???
JuliusCaesar

User avatar
robertmf
Registered User
Posts: 52
Joined: Wed Jul 23, 2003 5:20 pm
Location: In PA, 55 min. via commuter RR outside Filthadelphia
Contact:

Re: inaktive users

Post by robertmf »

JuliusCaesar wrote: well..... :oops: :oops: :oops: :oops: right....
where can I find this???


8) You can use phpMyAdmin, or something like it, to access your database tables and take a peek.

User avatar
Highway of Life
Registered User
Posts: 1399
Joined: Tue Feb 08, 2005 10:18 pm
Location: I'd love to change the World, but they won't give me the Source Code
Contact:

Re: inaktive users

Post by Highway of Life »

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'
Image

Waleed
Registered User
Posts: 150
Joined: Tue Feb 28, 2006 11:35 am
Location: Pakistan
Contact:

Re: inaktive users

Post by Waleed »

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'


...are the contents of this user_lastvisit field displayed somewhere in the ACP?

User avatar
Highway of Life
Registered User
Posts: 1399
Joined: Tue Feb 08, 2005 10:18 pm
Location: I'd love to change the World, but they won't give me the Source Code
Contact:

Re: inaktive users

Post by Highway of Life »

Hmm.... nooooo, not that I know of. :?
Image

Post Reply