The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Complex sort question

When member's search for others members the results are ordered by lastvisit, eg:
select * FROM members ORDER BY lastvisit DESC

I'm introducing a new field, hiddentime, so member's can hide and be invisible to other members.

This works fine through out the site, except when it comes to ordering in search.
hiddentime is also an int(10) and set to 0 when not hidden. This stores the time they "go into hiding" and returns to "0" when they stop playing hide and seek.

I can not modify lastvisit as it is updated every page view, across many pages, plus the script is encoded in parts which makes that more trouble.

Is it possible to order by lastvisit but if they have a hiddentime to use the hiddentime instead of lastvisit time?