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.
JuliusCaesar
Posts: 84
Joined: Sat Jun 24, 2006 2:02 pm
Location: Germany
Contact:

Re: inaktive users

Post by JuliusCaesar »

Doc wrote: user_type 2 are the bots.

Code: Select all

SELECT * FROM phpbb_users WHERE group_id != 2 AND user_type != 2 AND user_lastvisit = 0
so is this code for normal users or for bots????

in the memberlist u can sort users by last active method:
does this sort the users by the date of their last post or the date of their last visit????
JuliusCaesar
User avatar
Dr.Death
Registered User
Posts: 25
Joined: Thu Feb 24, 2005 10:33 am
Location: Germany
Contact:

Re: inaktive users

Post by Dr.Death »

If you select all user_type 2, than you select all bots.
You don't want to select the bots... so it must be

Code: Select all

user_type != 2
To sort it use this:

Code: Select all

SELECT * FROM phpbb_users 
WHERE group_id != 2 
AND user_type != 2 
AND user_lastvisit != 0 
ORDER BY user_lastvisit ASC
Doc.

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

Re: inaktive users

Post by Waleed »

Dr.Death wrote: To sort it use this:

Code: Select all

SELECT * FROM phpbb_users 
WHERE group_id != 2 
AND user_type != 2 
AND user_lastvisit != 0 
ORDER BY user_lastvisit ASC


This would give you all the users other than bots, sorted by the order they visited in. :D
JuliusCaesar
Posts: 84
Joined: Sat Jun 24, 2006 2:02 pm
Location: Germany
Contact:

Re: inaktive users

Post by JuliusCaesar »

tahnx but what about this:
JC wrote: n the memberlist u can sort users by last active method:
does this sort the users by the date of their last post or the date of their last visit????
JuliusCaesar
Waleed
Registered User
Posts: 150
Joined: Tue Feb 28, 2006 11:35 am
Location: Pakistan
Contact:

Re: inaktive users

Post by Waleed »

I would say last post; because last visit is stored seperately under user_lastvisit. But I am not sure.
Post Reply