[Iken]

Hi all,

I want to change the following code in index.php:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");

$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'");

I want to exclude two forums from these queries, how?
Thank you!


Someone suggested this ->
Yes, the forumid 1/2 are the forumid's that you don't want to be included, and your queries would look like this:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit] AND forumid!=forumid1 AND forumid!=forumid2'");

$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit] AND forumid!=forumid1 AND forumid!=forumid2'");

But this didn't work. Any suggestions?

[MattR]

AND forumid NOT IN ( 123, 456 )

of course change 123 and 456 to be your actual forum IDs that you wish to omit.

[Iken]

Originally posted by MattR
AND forumid NOT IN ( 123, 456 )

of course change 123 and 456 to be your actual forum IDs that you wish to omit.

Thanks for your reply but this doesn't work.

[MattR]

It should. What do you mean by 'doesn't work'. Show the exact query you are entering.

[Iken]

This are the two queries:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit] AND forumid NOT IN ( 31, 33, 37 ) '");
$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit] AND forumid NOT IN ( 31, 33, 37 ) ' ");

They work but they not exclude the forums I want.

[MattR]

I don't think post has the forumid table in it.

That means you will have to JOIN to the thread table which can get very expensive. Why not look at the forum table? There is a postcount column on there.