Getting "new post" to update instantly

[DRJ]

When I view new posts on my site I have a list of all the posts. Nowwhen I click on one and read it, then go back to view all the newposts, it is still there. Eventually it will go away or I can Mark AllForums Read and it will update immediately.

So I was wondering if it could show all unread posts instead ofall new posts. That way once you read a message it will no longer showup when you view all the new posts.

[AN-net]

you would have to rerun the new posts page from the beginning because vb caches search results etc. to save load on the server and database

see when you click on new post it gathers all the new post threadids and puts them into a hash and then stores them in the database. upon redirection it regrabs those cached thread ids

[DRJ]

Hmm might be too much trouble to change then. Is there a query I could run to check for new posts that are also unread?

I already show new posts and new threads above the navbar. So maybe I could do something like:

New Posts: 15 (5 Threads) (2 Unread)

I already have the first two queries, but is there one I could use to get the total unread and new posts?

Thanks