Prevent posts from a certain forum from showing up in "New Posts"

[JGM]

I have Cyb Advanced New Posts installed on my site, now we have a section in which threads/topics which have dead links are put in to. Each one has a reply made by staff so as if the original poster has a subscription to the post then they get notified that the links are dead.

Now the problem is that this reply stating that the links are dead shows up in the new posts link in the navbar. Is there any way at all to prevent this from happening?

Forum is running vBulletin v3.8.5

Thank you.

JGM.

JGM Reviewed by JGM on 10th Aug 2011. Prevent posts from a certain forum from showing up in "New Posts" I have Cyb Advanced New Posts installed on my site, now we have a section in which threads/topics which have dead links are put in to. Each one has a reply made by staff so as if the original poster has a subscription to the post then they get notified that the links are dead. Now the problem is that this reply stating that the links are dead shows up in the new posts link in the navbar. Is there any way at all to prevent this from happening? Forum is running vBulletin v3.8.5 Thank Rating: 5

[soft2050]

Which vbulletin version?

[JGM]

Sorry should have mentioned that, it is v3.8.5 (added to the first post).

JGM.

[soft2050]

May work but untested

Admin CP > Plugin Manager > Cyb - Advanced 'New Posts' - AE (Hook location: misc_start)

Open the above file

In the plugin php code, there would be sql query code, somewhat like this:

SELECT COUNT(*) AS posts, post.threadid, thread.forumid
                FROM " . TABLE_PREFIX . "post
                LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
                WHERE post.visible = '1' $cybanp_exclforums AND post.dateline >= " . $db->escape_string($vbulletin->userinfo['lastvisit']) . "
                GROUP BY post.threadid 

You can amend the above code to your needs, maybe somewhat like this:

SELECT COUNT(*) AS posts, post.threadid, thread.forumid
                FROM " . TABLE_PREFIX . "post
                LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
                WHERE post.visible = '1' $cybanp_exclforums AND  post.dateline >= " .  $db->escape_string($vbulletin->userinfo['lastvisit']) . " AND thread.forumid   !=myid
                GROUP BY post.threadid 

[JGM]

Thanks I will try it out and see what happens it gets me that vBulletin does not have this feature built unless it is in v4.

EDIT - Tried the code as is above and it stops the hack from working it won't show any new posts at all.

JGM.