inaktive users

[JuliusCaesar]

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????

[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

[Waleed]

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.

[JuliusCaesar]

tahnx but what about this:

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????

[Waleed]

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