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 » Thu Jul 20, 2006 8:54 pm

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
Contact:

Re: inaktive users

Post by rivaldo » Fri Jul 21, 2006 4:24 pm

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 » Fri Jul 21, 2006 4:38 pm

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 » Fri Jul 21, 2006 8:26 pm

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 » Fri Jul 21, 2006 9:30 pm

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 » Fri Jul 21, 2006 9:37 pm

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 » Fri Jul 21, 2006 10:19 pm

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 » Sat Jul 22, 2006 3:10 am

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 » Sat Jul 22, 2006 2:21 pm

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 » Sat Jul 22, 2006 8:03 pm

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

Post Reply