Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX)

Info:
This hack will show how many new posts/threads have been posted in forums since your 'last visit'. New posts are checked via AJAX, manually or in defined time interval. Optionally you can enable and configure Smart Search Menu to give users ability to search individual forum sections. View screenshots...

Installation:
Import product XML: AdminCP > Plugin System > Manage Products > [Add/Import Product]

To set options:
Go to: AdminCP > vBulletin Options > VSa - Advanced 'New Posts'

Versions:
v1.0 - Apr 29. 2006.
-First version
v2.4 - Jan 18. 2009.
-Latest 3.x version
v3.0 - Jan 17. 2010.
-Updated for vBulletin 4.x
-Mod prefix (Cyb) changed to 'VSa'
v3.0.1 - Jan 17. 2010.
-Fixed bug where individual forum search does not work properly
-Fixed bug where product is not stopped when forums are turned off
v3.0.2 - Apr 11. 2010.
-Fixed: WOL confusion
-New: Compatible with DB thread/forum read marking types
-New: Navbar items merged
-Fixed: Permissions bug
-Fixed: Minor bugs
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

[Honk0815]

Can I use the addon with vbcms?
I have only in Forum Advanced 'New Posts' (AJAX) and i need this in cms too

[jdeveaux]

Originally Posted by Valter

At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

[CAG CheechDogg]

How do you exclude certain forums?

[dlewisr]

Nice one. Works with 4.2.0. Does exactly what it says on the tin.

Cheers

[jdeveaux]

Originally Posted by jdeveaux

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

By chance I've discovered that this issue is caused by installing a combination of VSA Hacks... now the new question is which one

I'm going through and testing one by one but thus far I haven't found the smoking gun. Installed by itself it works great.

[root2012]

I have a problem after install

Datenbankfehler in vBulletin 4.1.0:

Invalid SQL:

					SELECT COUNT(*) AS posts, post.threadid
					FROM post as post /*FORCE INDEX (dateline)*/
					INNER JOIN thread as thread USING (threadid)
					INNER JOIN forum AS forum USING (forumid)
					LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 67)
					LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 67)
					WHERE thread.visible IN (1)
					AND thread.forumid NOT IN(106,107,108,109,110,99,100,)
					AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
					AND thread.lastpost > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
					AND post.dateline > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
					AND thread.lastpost > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
					AND post.dateline > 1352086208 AND thread.lastpost > 1352086208
					GROUP BY post.threadid;

MySQL-Fehler  : 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 ')
					AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadre' at line 8
Fehler-Nr.    : 1064
Fehler-Zeit   : Monday, November 5th 2012 @ 03:27:08 PM
Datum         : Monday, November 5th 2012 @ 03:27:09 PM
Skript        : http://new/vb4/misc.php?show=vsaanp_newposts
Referrer      : http://new/vb4/forum.php

[emperatour]

Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

<div id="pagetitle">
		<h1>
			<vb:if condition="$search_back_url">
				<a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
			<vb:else />
				<strong>{vb:rawphrase search}:</strong>
			</vb:if>
		</h1>
		<p class="description">
			{vb:raw criteriaDisplay}		
		</p>
	</div>

I appreciate your work.

[Amaury]

So, under New Posts in your screenshot, what does 3 | 2 mean?

[Dwarden]

Originally Posted by Valter

v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

well I tried update from 3.0.2 to 3.0.3 and the post counter is gone on 4.2.x forum
reverting to 3.0.2 fixes it

Originally Posted by emperatour

Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

<div id="pagetitle">
		<h1>
			<vb:if condition="$search_back_url">
				<a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
			<vb:else />
				<strong>{vb:rawphrase search}:</strong>
			</vb:if>
		</h1>
		<p class="description">
			{vb:raw criteriaDisplay}		
		</p>
	</div>

I appreciate your work.

where this goes to please ?

[NoMatt3r]

Installed on 4.2.1 and working great!

But it still shows 4 | 6 altough i've already read the new posts/threads. And the SSM shows forums although the usergroup doesn't have permissions.