Changing $getnewpost and $getnewthread variable (exclude forums)

[Domenico]

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!

[filburt1]

Add this to the query:
[sql]
...AND forumid != forumid1AND forumid != forumid2
[/sql]

[Domenico]

Originally posted by filburt1
Add this to the query:
[sql]
...AND forumid != forumid1AND forumid != forumid2
[/sql]

Thanks for answering!

Can you please be more specific?

Must I add this to the query:
AND forumid != forumid1 AND forumid != forumid2

Where 1 and 2 must be the forumid's wich are going to be excluded?

Where in the query must I add this?
$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");



Thank you!

[Domenico]

Can someone please answer my question since I'm puzzled how to do this.

[Silenced Soul]

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
'");

[Domenico]

Originally posted by Silenced Soul
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
'");

This worked.
Thanks a lot!

Too bad none of the other members feeled the need to answer this question.

[Boofo]

I don't find that in the 2.2.9 index.php. Is that an addon?

[Domenico]

Originally posted by Boofo
I don't find that in the 2.2.9 index.php. Is that an addon?

I still have 2.2.6 and because it has so many hacks I don't upgrade it anymore. My next upgrade will be to 3.x I think.

Anyways, I thought it did work but it stildoes the same as before so this isn't the way to go...

[Boofo]

I think you want to do it in the search.php, anyway. This is for "Todays Active Threads".

Find:

PHP Code:

$wheresql.=" AND thread.open<>10"; 


and replace it as:

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=X"; 


If you want to do more than one forum, change it to this:

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=X AND thread.forumid!=X"; 


There are 2 instances, one is for members, the other is for guests. If you want to exclude forums for both of them, change both lines.

[Domenico]

Originally posted by Boofo
I think you want to do it in the search.php, anyway. This is for "Todays Active Threads".

Find:

PHP Code:

$wheresql.=" AND thread.open<>10"; 


and replace it as:

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=X"; 


If you want to do more than one forum, change it to this:

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=X AND thread.forumid!=X"; 


There are 2 instances, one is for members, the other is for guests. If you want to exclude forums for both of them, change both lines.

Hi boofo, thanks for replying!

I allready fixed this in search.php where I excluded three forums from the search and that's why I need to remove these three forums also from this query.

When people click on new posts they get less new posts to see because new threads and new posts on index.php still include the three forums excluded from search.php

I hope someone can come up with the solution for this.