vb.org Archive - Blocking final forum post count for some forums

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Blocking final forum post count for some forums (https://vborg.vbsupport.ru/showthread.php?t=56198)

floridaideal

08-14-2003 02:10 PM

Blocking final forum post count for some forums

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 ! :confused:

Thank you

Stuart

NTLDR

08-14-2003 03:07 PM

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

08-14-2003 03:19 PM

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

08-14-2003 03:29 PM

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

08-14-2003 03:40 PM

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

08-14-2003 03:46 PM

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

08-14-2003 04:12 PM

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

08-14-2003 04:25 PM

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

08-15-2003 07:00 AM

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

08-15-2003 12:13 PM

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 :)

All times are GMT. The time now is 07:53 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02407 seconds Memory Usage 1,754KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: