Blocking final forum post count for some forums

[floridaideal]

Hello all

Can anyone please tell me if there is a way of stopping one forums posts counting towards the final forum post count at the top of the screen?

i.e I have just installed the newsgroup hack so I now have 2 extra forums with 3000 new posts BUT I worked hard for the original 50,000 posts that helped build my forum so I feel I am cheating a little.

I know there is a way to stop it counting towards users posts but I would like to block the forum from counting either of the 2 I just added and count the rest as per normal.

I hope someone understands me !

Thank you

Stuart

[NTLDR]

In index.php find:

PHP Code:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']); 


Replace with:

PHP Code:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post WHERE forumid NOT IN(1,2,3)');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread WHERE forumid NOT IN(1,2,3)');
$totalthreads=number_format($countthreads['threads']); 


Change 1,2,3 to the forumids of the newgroup forums eg 23,45 or 556,23,67,56.

Untested but should work.

[floridaideal]

Hi NTLDR

Thank you for your hack thats very kind of you, only I get a database error when I install it? Any ideas please? Thank you again.

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE forumid NOT IN(127,128)
mysql error: Unknown column 'forumid' in 'where clause'

mysql error number: 1054

[NTLDR]

Ah yes, the forumid isn't saved along with the posts, try:

PHP Code:

// get total posts 
$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads, SUM(replycount) AS posts FROM thread WHERE forumid NOT IN(1,2,3)'); 
$totalthreads=number_format($countthreads['threads']);
$totalposts=number_format($countthreads['posts']+$countthreads['threads']); 


Again, untested, but this time should work

[floridaideal]

Your the man Lee, thank you for that works like a dream!

Wouldnt happen to know how I can stop these posts appearing in the "view new posts" now would you?

Thank you

Stuart

[NTLDR]

In search.php find around line 558 (of an unhacked 2.3.2 file):

PHP Code:

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


replace with:

PHP Code:

$wheresql.=" AND thread.open<>10";
$wheresql.=" AND thread.forumid NOT IN(1,2,3)"; 


Again untested but should work for you

[floridaideal]

Hi Lee

Wonderful thank you, sorry to keep bugging you but is there anyway the number posts since your last visit can also be changed to ignore these 2 forums? Don't want to upset my members and have them asking why the view new posts isnt working.

Thanks again Lee, your a gent!

Stuart

[NTLDR]

I'll assume this is the hack you have installed: Since Your Last Visit!

If so, find:

PHP Code:

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


Replace with:

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]' AND forumid NOT IN(1,2,3)"); 
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post LEFT JOIN thread USING (threadid) WHERE dateline > '$bbuserinfo[lastvisit]' AND thread.forumid NOT IN(1,2,3)"); 


The new post query isn't very optimised, but I can't think of any other way of doing it, but it does work. Remember to changes the forumids again

[floridaideal]

Hello again

Sorry for the delay in replying and thank you so much for your help!

I installed the hack you last posted but am getting a sql errror:

Invalid SQL: SELECT COUNT(*) AS posts FROM post LEFT JOIN thread USING (threadid) WHERE dateline > '1060933721' AND thread.forumid NOT IN(127,128)
mysql error: Column: 'dateline' in where clause is ambiguous

mysql error number: 1052

Any ideas?

Thank you

Stuart

[NTLDR]

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]' AND forumid NOT IN(1,2,3)"); 
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post LEFT JOIN thread USING (threadid) WHERE post.dateline > '$bbuserinfo[lastvisit]' AND thread.forumid NOT IN(1,2,3)"); 


Sorry, a small error in the second query, use the above code instead I'm positive that will work, but I haven't got a vB2 set up hence why I haven't tested any of this