11.用户在线中按用户组排序
If Dvbbs.boardid=0 Then
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online Order by userid desc,lastimebk Desc"
Else
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online where boardid="&Dvbbs.Boardid&" Order by userid desc,lastimebk Desc"
End If
修改为:
If Dvbbs.boardid=0 Then
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online Order by usergroupid asc"
Else
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online where boardid="&Dvbbs.Boardid&" Order by usergroupid asc"
End If
If Dvbbs.boardid=0 Then
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online Order by userid desc,lastimebk Desc"
Else
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online where boardid="&Dvbbs.Boardid&" Order by userid desc,lastimebk Desc"
End If
修改为:
If Dvbbs.boardid=0 Then
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online Order by usergroupid asc"
Else
SQL="Select id,username,UserGroupID,userhidden,userid,userclass"&Selectlist&" from Dv_online where boardid="&Dvbbs.Boardid&" Order by usergroupid asc"
End If