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