Another example is at www.peterska2.co.uk/vbnewscms.php

I have named my link in the navbar News Feeds as that is what I am using it to display.

I run an exclude in the new posts link to exclude the new feeds from the new posts search at all times. However, the new posts/todays posts in the quicklinks I have left where they include the news feeds. To exclude if they are in a forum and have less than x replies will take a query, and depending on how often new posts searches are ran, could be rather server intensive.

dont work for me - i dont have a forumid that begins with 10 for some reason so is there no way to fix this.In admincp i have entered the corect forumids for the forums i want to show but the sql error is still coming up when i go to the page.

Why have a default forumid10 anyway ??

Replace the 10 in the first one with the first forum you wish to have the news taken from. This can be any number.

10 was only used as an example. Make sure the rest of the forums are set to 0 (ones that are not in use). What version of MySQL do you have and which version of the software did you use?

i used vbnews.php

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid AND t.visible = 1 AND 5 > ( SELECT count(5) FROM thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid IN (102,0,0,0,0,0,0,0,0)
ORDER BY field(f.forumid,102,0,0,0,0,0,0,0,0), t.dateline desc;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(5) FROM thread WHERE forumid = f.forumid AND visib
Error Number : 1064

also i have entered the correct forumids i want and still get the error.

Any i dont want to use i have left at 0

Which version - regular or legacy? If your MySQL version is lower than 4.1 then the vbnews-100 will not work and give you the above error message - try using the vbnewslegacy-100.

got it soprted now using the vblegacy version cheers

/me clicks install

:D - glad to hear it was sorted.

Hi please ignore the guy who says this is rubbish or not needed. Its something that can be useful. thank you

This may work..

Opt-Out Forums from Get New/Get Daily