bsoder wrote:The SQL I posted doesn't reflect the actual number of new posts, it reflects the number of new topics. I've changed the text in language/en/common.php, the SEARCH_NEW value, to read "View new topics" on my board. I like topic count better than post count anyway, but just so you all are aware of the difference.
Nice one. But it is not working 100% for me. It is not updating the number/count as it should...
Would it be possible to change the query to show new topics since last page refresh instead of last login?
Also, is it possible to add a new variable "SEARCH_NEW_TOPIC" instead of altering the text for SEARCH_NEW n language/en/common.php?
If so, I guess I have to somehow add this new variable in index.php or somewhere else?