[Ian Emu-UK]

Great hack

I have a couple of private forums, and I have fudged around with the PHP to stop it from counting them in the total with some help from a friend (Thanks RCK):-

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]' and forumid <> '21' and forumid <> '19'");
$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post, thread WHERE lastpost > '$bbuserinfo[lastvisit]' and thread.threadid=post.threadid and thread.forumid <> '21' and thread.forumid <> '19'"); 


It works a treat apart from the fact it counts all the posts in a thread instead of just counting the new post.

I would be most grateful if one of you PHP/mySQL gods could help me with this one