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:
Post
by JuliusCaesar » Thu Jul 27, 2006 2:51 pm
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
Dr.Death
Registered User
Posts: 25 Joined: Thu Feb 24, 2005 10:33 am
Location: Germany
Contact:
Post
by Dr.Death » Thu Jul 27, 2006 3:11 pm
If you select all user_type 2, than you select all bots.
You don't want to select the bots... so it must be
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.
Waleed
Registered User
Posts: 150 Joined: Tue Feb 28, 2006 11:35 am
Location: Pakistan
Contact:
Post
by Waleed » Thu Jul 27, 2006 6:23 pm
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.
JuliusCaesar
Posts: 84 Joined: Sat Jun 24, 2006 2:02 pm
Location: Germany
Contact:
Post
by JuliusCaesar » Thu Jul 27, 2006 9:54 pm
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:
Post
by Waleed » Fri Jul 28, 2006 8:46 am
I would say last post; because last visit is stored seperately under user_lastvisit. But I am not sure.