Request to join usergroup: Order of Request

[greentips]

Hello all,

How do I change the order of the requests displayed in the "Request to join usergroup"? I would like to make the requests displayed in the order of the date the request is submitted. This makes the group leader's job a bit easiler as we would like to process the requests in the order that we have received.

I posted this inquiry at the vbulletin.com and they suggested that that needs some code modification.

Any help will be appreciated.

[vbenhancer]

... i hate to see when people are not answered for such small things:

in file /modcp/user.php

find in line 1145/1149:

[SQL] WHERE user.userid IS NOT NULL[/SQL]


just below, add:

[SQL] ORDER BY usergrouprequest.dateline ASC[/SQL]

that's all... if the order is reversed, use DESC instead of ASC...