There is no COUNT() because that wouldn't do the job ;) I use a totally different method in order to get the three sets of data I need from just the one query, which with testing on a usual new post/thread count seems equally as fast as two queries.

Remember also thats more queries can sometimes be better and quicker.

I know, that's why I've left it at 2 queries (for now anyways, until I find time to test the different queries I could use and their speeds :D)

Yours hacks are used rather often!

Is it just me, or will this let people who have no access to a certain forum realize that a new post has been made even if they can't check it?

I make a post in my Central Command, some registered user sees that the posts since last visit went up by 1, even though he has no permission to view the post.

Anybody know a way to fix this? Check for permission somehow in or after the query?

Am I the only person that has no idea where to find the hack installer listed in the txt? installer.php?

:/

I think Gary W made an error, I don't think you need to run an installer with this hack, just make the changes listed :)

LOL its just one file edit, like a mini mod

Yeah I figured it was just a accident. I got it working, now I'm working on trying out vbIndex and eventually replacing vbportal when I switch to 3.0. I got to post on the vbindex topic about an error I'm getting there now :)

i really want this hack on my forum but when i try to look in the global.php file, i cannot find those commands listed anywhere on that file. i did a search on the global.php file and i can't find anywhere it says echo or anything. and i'm not sure if the navbar template file is the same as the template file in the admincp directory or not.... can someone please help? thanks.

/me clicks install

Thanks mate!

Christian